Problems running analytics on individual records version 2.15

I have upgraded my 2.14 database using a (slightly edited script) and upgraded to 2.15 build revision 15163.

I can now see all of my patient tracker data - using single event without registration.

However when I run analytics in order to create event reports, it fails:

2014-07-05 08:16:24
Process failed: Exception during execution
2014-07-05 08:16:09
Populating analytics tables
2014-07-05 08:15:52
Creating analytics tables

The logs are not helpful. The script seems to stop in the middle of a query without an error message.

When I look at the database on the backend the analytics process has created many files like: analytics_event_temp_1912_bld4ovw2mfp. Numbers go from 1912 to 2014 - 8 temp files per year.

I only have event data entered since 2013.

Any suggestions?

···


Randy Wilson

Senior HMIS and Data Use Advisor, Ministry of Health/Rwanda

Integrated Health Systems Strengthening Project

Management Sciences for Health, Inc. (MSH)

BP 371

Kigali, Rwanda

+250-788308835

Skype Name (wilsonrandy_us)

www.msh.org

Stronger health systems. Greater health impact.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.