Release Testing – Reporting Module, All composition Query are broken

0 views
Skip to first unread message

Eurico Jose

unread,
May 22, 2012, 6:24:12 AM5/22/12
to implem...@openmrs.org

Hi All,

I have migrated successfully from 1.7.1 to 1.9 RC4 but on reporting module section under administration I have 112 broken definitions and on production server I have 112 composition queries

On Tomcat log, for each composition query shows error attached.

I have tested Reporting Module 7.1.1 with OpenMRS 1.7.1 worked fine



Using tomcat 7.0.25

log.txt

Michael Seaton

unread,
May 22, 2012, 9:19:36 AM5/22/12
to implem...@openmrs.org
Hi Eurico,

This might be a similar error to one recently reporting in 1.9 due to automatic assignment of UUIDs breaking serialization/deserialization.� Can you send me the raw XML of one of the definitions that you are trying to deserialize?

Thanks,
Mike

Eurico Jose

unread,
May 23, 2012, 3:26:57 AM5/23/12
to implem...@openmrs.org
Find in attach the one of XML

On Tue, May 22, 2012 at 3:19 PM, Michael Seaton <mse...@pih.org> wrote:
Hi Eurico,

This might be a similar error to one recently reporting in 1.9 due to automatic assignment of UUIDs breaking serialization/deserialization.  Can you send me the raw XML of one of the definitions that you are trying to deserialize?


Thanks,
Mike


On 05/22/2012 06:24 AM, Eurico Jose wrote:

Hi All,

I have migrated successfully from 1.7.1 to 1.9 RC4 but on reporting module section under administration I have 112 broken definitions and on production server I have 112 composition queries

On Tomcat log, for each composition query shows error attached.

I have tested Reporting Module 7.1.1 with OpenMRS 1.7.1 worked fine



Using tomcat 7.0.25

-- OpenMRS Implementers: http://go.openmrs.org/implementers
Post: implem...@openmrs.org
Unsubscribe: implementers...@openmrs.org
XMLFile.xml

Michael Seaton

unread,
May 23, 2012, 9:32:09 AM5/23/12
to implem...@openmrs.org
Hi Eurico,

When you did this upgrade, did the version of the reporting module change?� Or the version of the serialization.xstream module?� Or was it only the core OpenMRS version that changed?

One thing you can try on a test environment to try to isolate the problem would be to selectively edit the underlying XML in the database for a particular definition, and to see if you can narrow down a particular portion of the XML that is causing the deserialization to fail.

Mike



On 05/23/2012 03:26 AM, Eurico Jose wrote:
Find in attach the one of XML

On Tue, May 22, 2012 at 3:19 PM, Michael Seaton <mse...@pih.org> wrote:
Hi Eurico,

This might be a similar error to one recently reporting in 1.9 due to automatic assignment of UUIDs breaking serialization/deserialization.� Can you send me the raw XML of one of the definitions that you are trying to deserialize?


Thanks,
Mike


On 05/22/2012 06:24 AM, Eurico Jose wrote:

Hi All,

I have migrated successfully from 1.7.1 to 1.9 RC4 but on reporting module section under administration I have 112 broken definitions and on production server I have 112 composition queries

On Tomcat log, for each composition query shows error attached.

I have tested Reporting Module 7.1.1 with OpenMRS 1.7.1 worked fine



Using tomcat 7.0.25

-- OpenMRS Implementers: http://go.openmrs.org/implementers
Post: implem...@openmrs.org
Unsubscribe: implementers...@openmrs.org

Michael Seaton

unread,
May 23, 2012, 5:15:03 PM5/23/12
to implem...@openmrs.org
Hi Eurico,

I managed to reproduce this today.� It looks like the cause is due to the fact that the logger was serialized along with the definition and is failing to deserialize properly.

You can fix this via brute force by going into the serialized_object table in your database and selecting all rows where the subtype = 'org.openmrs.module.reporting.cohort.definition.CompositionCohortDefinition' and remove the text "<log class="org.apache.commons.logging.impl.SLF4JLocationAwareLog" id="6"/>" in the serialized data.

I will try to work on a better alternative solution, but wanted to get this to you for now...

Cheers,

Mike



On 05/23/2012 03:26 AM, Eurico Jose wrote:
Find in attach the one of XML

On Tue, May 22, 2012 at 3:19 PM, Michael Seaton <mse...@pih.org> wrote:
Hi Eurico,

This might be a similar error to one recently reporting in 1.9 due to automatic assignment of UUIDs breaking serialization/deserialization.� Can you send me the raw XML of one of the definitions that you are trying to deserialize?


Thanks,
Mike


On 05/22/2012 06:24 AM, Eurico Jose wrote:

Hi All,

I have migrated successfully from 1.7.1 to 1.9 RC4 but on reporting module section under administration I have 112 broken definitions and on production server I have 112 composition queries

On Tomcat log, for each composition query shows error attached.

I have tested Reporting Module 7.1.1 with OpenMRS 1.7.1 worked fine



Using tomcat 7.0.25

-- OpenMRS Implementers: http://go.openmrs.org/implementers
Post: implem...@openmrs.org
Unsubscribe: implementers...@openmrs.org
Reply all
Reply to author
Forward
0 new messages