dhis2-users team mailing list archive

["Friedman, Roger (CDC/OID/NCHHSTP) (CTR)" <rdf4@xxxxxxx>]

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(Abstract
BatchHandler.java:195)

at
org.hisp.dhis.resourcetable.DefaultResourceTableService.generateOrganisa
tionUnitStructures(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