craigg Posted December 1, 2009 Posted December 1, 2009 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 Posted December 1, 2009 Posted December 1, 2009 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 Posted December 1, 2009 Author Posted December 1, 2009 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 Posted December 2, 2009 Posted December 2, 2009 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.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now