dhis2-devs team mailing list archive

["jason.p.pickering@xxxxxxxxx" <jason.p.pickering@xxxxxxxxx>]

This seems to be a recurring issue. Should this be part of the startup routine and or the data integrity checks?

Sent from my HTC

----- Reply message -----
From: "Lars Helge Øverland" <larshelge@xxxxxxxxx>
Date: Fri, Oct 22, 2010 3:17 pm
Subject: [Dhis2-devs] Export failed with cannot instantiate Source (was: Re: Re: Pivot tables)
To: "Ola Hodne Titlestad" <olati@xxxxxxxxxx>
Cc: "DHIS 2 developers" <dhis2-devs@xxxxxxxxxxxxxxxxxxx>


This SQL will do the trick:

delete from source where sourceid not in ( select organisationunitid from
organisationunit );

On Fri, Oct 22, 2010 at 3:00 PM, Ola Hodne Titlestad <olati@xxxxxxxxxx>wrote:

> Damiola,
>
> Please use a different subject when your email it is not related to the
> thread.
> That makes it easier for all of us to read emails and browse the list, and
> to respond to requests.
>
> Just compose a new email to dhis2-devs@xxxxxxxxxxxxxxxxxxx and it will go
> to the list.
> I would also recommend using the Bug report on launchpad when reporting
> bugs.
>
> Regarding your exception it seems the orgunit and source tables are out of
> synch which might happen if you manually delete or create orgunits directly
> in the database (which is not recommended). Please make sure that the all
> the IDs in Source and Organisationunit are exactly the same and try again.
> If it still doesn't work, it is something wrong and we need to create a bug
> report.
>
>
> ----------------------------------
> Ola Hodne Titlestad (Mr)
> HISP
> Department of Informatics
> University of Oslo
>
> Mobile: +47 48069736
> Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>
>
>
> 2010/10/22 <damilola@xxxxxxxxxxxxxxxxxxx>
>
>> Hi Bob,
>> Export (ALL) failed with the error below.  This began on upgrade from
>> previous to dhis2.0.5.
>>
>> org.hibernate.InstantiationException: Cannot instantiate abstract class or
>> interface: org.hisp.dhis.source.Source
>>     at
>> org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:101)
>>     at
>> org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:123)
>>     at
>> org.hibernate.tuple.entity.AbstractEntityTuplizer.instantiate(AbstractEntityTuplizer.java:606)
>>     at
>> org.hibernate.persister.entity.AbstractEntityPersister.instantiate(AbstractEntityPersister.java:3888)
>>     at org.hibernate.impl.SessionImpl.instantiate(SessionImpl.java:1412)
>>     at org.hibernate.impl.SessionImpl.instantiate(SessionImpl.java:1401)
>>     at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1342)
>>     at org.hibernate.loader.Loader.getRow(Loader.java:1251)
>>     at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:619)
>>     at org.hibernate.loader.Loader.doQuery(Loader.java:745)
>>     at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
>>     at org.hibernate.loader.Loader.doList(Loader.java:2294)
>>     at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2172)
>>     at org.hibernate.loader.Loader.list(Loader.java:2167)
>>     at
>> org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
>>     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1706)
>>     at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
>>     at
>> org.hisp.dhis.source.hibernate.HibernateSourceStore.getAllSources(HibernateSourceStore.java:98)
>>     at
>> org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getAllOrganisationUnits(DefaultOrganisationUnitService.java:164)
>>     at
>> org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrganisationUnits(DefaultOrganisationUnitService.java:169)
>>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>>     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>     at java.lang.reflect.Method.invoke(Unknown Source)
>>     at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
>>     at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
>>     at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
>>     at
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
>>     at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>>     at
>> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
>>     at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>>     at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
>>     at $Proxy12.getOrganisationUnits(Unknown Source)
>>     at
>> org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.write(OrganisationUnitConverter.java:115)
>>     at
>> org.hisp.dhis.importexport.ExportPipeThread.doRun(ExportPipeThread.java:164)
>>     at
>> org.hisp.dhis.system.process.OpenSessionThread.run(OpenSessionThread.java:58)
>> Exception in thread "Thread-21" java.