dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

There was some discussion about removing source entirely from the
model given that orgunit has turned out to be the only source sub-type
implemented.  Anyone rember what was decided on this?

Bob

2010/10/22 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.
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>