On Sun, May 2, 2010 at 5:30 PM, Friedman, Roger (CDC/OID/NCHHSTP) (CTR) < [email protected]> wrote:
> Using 2.0.3, attempting to create all four resource files, received the > following error: > > * ERROR 11:04:26,812 Error while executing action > (ExceptionInterceptor.java [http-8080-1]) > > java.lang.RuntimeException: Failed to add objects > > at > org.amplecode.quick.batchhandler.AbstractBatchHandler.addObject(AbstractBatchHandler.java:195) > > at > org.hisp.dhis.resourcetable.DefaultResourceTableService.generateOrganisationUnitStructures(DefaultResourceTableService.java:162) > > ...SNIP... > > Caused by: java.sql.SQLException: Lock wait timeout exceeded; try > restarting transaction > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) > > ... 93 more > > At this point, orgunitstructure is empty; orgunitgroupsetstructure appears > to be fully built; orgunitgroupsetexclusivestructure has orgunitids but no > exclusive groups; categoryoptioncomboname contains only id 1 default. > > Seems like it might be a MySQL setting issue, any suggestions? > > Thanks, Roger > > > > Yes looks like a Mysql issue. I am testing on postgres on a daily basis, will install mysql and investigate further. Lars > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
