Moodle statistics not working

[craigg]

The problem is we cannot get moodle to generate stats from reports > Statistics.

It displays the following error:

"Sorry there is no avaliable data to display"



Statistics are enabled in server > statistics

I have set up moodle-cron.exe as a service which does not work. I have set it up as per instructions on the moodle forums and get the following message from event viewer:

 The description for Event ID (0) in Source (Moodle Cron) cannot be found. The local computer may not have the necessary registry information or message DLL files to display message from a remote computer. You may be to use the /AUXSOURCE=flag to retrieve this description; see help and suport for details The following information is part of the event:

http://moodledev/admincron.phpServer Time: Tue, 01 Dec 2009 11:20:36 +0000

I have also set up the cron using the windows task scheduler. Using both the PHP and the wget methods (mentioned in moodle docs and forums)

The cron will now run and has out put some backup files and deleted old information but still has not pulled any statistics from the database.
Here is the output from a cron i have just ran.

Server Time: Tue, 01 Dec 2009 12:04:44 +0000


Starting activity modules
Processing module function assignment_cron ...done.
Processing module function forum_cron ...Starting digest processing...
Cleaned old digest records
done.
Processing module function journal_cron ...done.
Processing module function scorm_cron ...done.
Finished activity modules
Starting blocks
Processing cron function for rss_client....
0 feeds refreshed (took 0.008238 seconds)
done.
Processing cron function for search....Global searching is not enabled. Nothing performed by search.
done.
Finished blocks
Starting admin reports
Finished admin reports
Updating languages cache
Removing expired enrolments ...none found
Starting main gradebook job ...
done.
Running clean-up tasks...
Deleted assignment for user 2 from course 217
Deleted assignment for user 1509 from course 172
Deleted assignment for user 91 from course 241
Deleted assignment for user 1509 from course 177
Deleted assignment for user 1509 from course 169
Deleted assignment for user 1509 from course 181
Deleted assignment for user 1509 from course 168
Deleted assignment for user 1509 from course 109
Deleted assignment for user 1509 from course 174
Deleted assignment for user 1509 from course 175
Deleted assignment for user 1509 from course 130
Deleted assignment for user 1509 from course 131
Deleted assignment for user 1509 from course 137
Deleted assignment for user 1509 from course 135
Deleted assignment for user 1509 from course 133
Deleted assignment for user 1509 from course 132
Deleted assignment for user 1509 from course 176
Deleted assignment for user 1509 from course 147
Deleted assignment for user 1509 from course 146
Deleted assignment for user 1509 from course 138
Deleted assignment for user 1509 from course 139
Deleted assignment for user 1509 from course 140
Deleted assignment for user 1509 from course 145
Deleted assignment for user 90 from course 206
Deleted assignment for user 2 from course 10
Deleted assignment for user 2 from course 157
Deleted assignment for user 1509 from course 206
Deleted assignment for user 1 from course 206
Deleted assignment for user 1509 from course 163
Deleted assignment for user 90 from course 149
Deleted assignment for user 1509 from course 241
Deleted assignment for user 90 from course 230
Deleted assignment for user 90 from course 13
Deleted assignment for user 91 from course 206
Deleted assignment for user 1509 from course 197
Deleted assignment for user 90 from course 220
Deleted assignment for user 91 from course 222
Deleted assignment for user 90 from course 222
Deleted assignment for user 91 from course 157
Deleted assignment for user 90 from course 228
Deleted assignment for user 91 from course 217
Deleted assignment for user 2 from course 209
Deleted assignment for user 1509 from course 217
Deleted assignment for user 1509 from course 157
Deleted assignment for user 90 from course 193
Deleted assignment for user 90 from course 192
Deleted assignment for user 1509 from course 166
Deleted assignment for user 90 from course 177
Deleted assignment for user 90 from course 179
Deleted assignment for user 90 from course 35
Deleted assignment for user 90 from course 38
Deleted assignment for user 90 from course 184
Deleted assignment for user 4 from course 220
Deleted assignment for user 90 from course 75
Deleted assignment for user 90 from course 4
Deleted assignment for user 90 from course 172
Deleted assignment for user 90 from course 157
Deleted assignment for user 90 from course 223
Deleted old cache_text records
Synchronised metacourses
checking for create_password
creating passwords for new users
Executed tag cron
Cleaned up contexts
Cleaned cache flags
Built context paths
Finished clean-up tasks...
Running backups if required...
Checking backup status...INACTIVE
Backup tasks finished.
Running rssfeeds if required...
Generating rssfeeds...
assignment: ...NOT SUPPORTED (file)
chat: ...NOT SUPPORTED (file)
choice: ...NOT SUPPORTED (file)
forum: generating ...OK
glossary: generating ...OK
journal: ...NOT SUPPORTED (file)
label: ...NOT SUPPORTED (file)
lesson: ...NOT SUPPORTED (file)
quiz: ...NOT SUPPORTED (file)
resource: ...NOT SUPPORTED (file)
survey: ...NOT SUPPORTED (file)
workshop: ...NOT SUPPORTED (file)
scorm: ...NOT SUPPORTED (file)
wiki: ...NOT SUPPORTED (file)
hotpot: ...NOT SUPPORTED (file)
data: generating ...OK
lams: ...NOT SUPPORTED (file)
feedback: ...NOT SUPPORTED (file)
attforblock: ...NOT SUPPORTED (file)
Ending rssfeeds......OK
Rssfeeds finished
Running auth crons if required...
Running stats cleanup tasks...
...stats cleanup finished
Cron script completed correctly
Execution took 1.123076 seconds

We need to know why the stats aren’t being pulled and what we can do to get them in to the statistics page.


Has anyone had a similar problem to this?


Thanks in advance!

[beeswax]

The problem is we cannot get moodle to generate stats from reports > Statistics.

It displays the following error:

"Sorry there is no avaliable data to display"



Statistics are enabled in server > statistics

I have set up moodle-cron.exe as a service which does not work. I have set it up as per instructions on the moodle forums and get the following message from event viewer:

 The description for Event ID (0) in Source (Moodle Cron) cannot be found. The local computer may not have the necessary registry information or message DLL files to display message from a remote computer. You may be to use the /AUXSOURCE=flag to retrieve this description; see help and suport for details The following information is part of the event:

http://moodledev/admincron.phpServer Time: Tue, 01 Dec 2009 11:20:36 +0000

I have also set up the cron using the windows task scheduler. Using both the PHP and the wget methods (mentioned in moodle docs and forums)

The cron will now run and has out put some backup files and deleted old information but still has not pulled any statistics from the database.
Here is the output from a cron i have just ran.




We need to know why the stats aren’t being pulled and what we can do to get them in to the statistics page.


Has anyone had a similar problem to this?


Thanks in advance!

From my experience running stats is a hit and miss affair. We had ours running successfully for about 3 months and then they stopped. In the natural order of things you should set the stats to run about an hour before your cron job, but sometimes this has failed me. Running stats is very memory intensive and I have now stopped running them on our site for this reason. If you really want to gather some stats, set the time of the stats run to about 5 mins in the past, go to Notifications in the Site Admin panel and you should see a message which says "The cron.php job hasn't been run for 24 hours", or words to that effect, clicking this phrase will run the cron job. I can't guarantee that your stats will be compiled first time round. You may need a bucket load of patience, especially as this will be a first run. Good luck.

[craigg]

When you say set it to run an hour before our cron job, what do you mean?

I thought the scheduled task cron (which is set for every 10 minutes) invokes the statistic gathering when the time is the same as the "statsruntimestarthour" value in the Satistics settings.

I didnt realise that it was a seperate process.

Please correct me if im wrong.

[beeswax]

Sorry for ther delay craigg. I was at home yesterday studying and then the school suffered another substation power failure, fortunately I had an excuse for not coming in to school as I was waiting for the gasman to come and fix our central heating boiler.
You should schedule the stats to run about an hour before you run the backup. My mistake, apologies for that.
If you check the Moodle site for statistics you'll find that there are quite a few people who have problems running them.