Importer issue in 2.26

Hi Team,

While importing metadata into 2.26 instance from 2.26, we are facing the below exception. Could you please shed light on what might have gone wrong.

Exception:

  • INFO 2017-06-08 14:18:45,768 (system-process) Creating 245 object(s) of type ProgramStageDataElement (DefaultObjectBundleService.java [taskScheduler-9])
  • INFO 2017-06-08 14:18:46,073 (system-process) Creating 1 object(s) of type ProgramDataElement (DefaultObjectBundleService.java [taskScheduler-9])
  • WARN 2017-06-08 14:18:46,124 SQL Error: 0, SQLState: 23502 (SqlExceptionHelper.java [taskScheduler-9])
  • ERROR 2017-06-08 14:18:46,124 ERROR: ** null value** in column “programid” violates not-null constraint
    Detail: Failing row contains (2441, OPpE5v0VxoN, null, 2016-11-28 15:49:28.35, 2017-06-08 14:18:46.074, null, 1428). (SqlExceptionHelper.java [taskScheduler-9])
  • ERROR 2017-06-08 14:18:46,189 Exception occurred while trying to import the metadata. could not execute statement (MetadataSyncImportHandler.java [taskScheduler-9])
    org.hibernate.exception.ConstraintViolationException: could not execute statement
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)

Thanks,

Sultan Ahamar.

Hi Sultan

Would you mind reporting the bug in JIRA? (jira.dhis2.org)

···

On Thu, Jun 8, 2017 at 8:19 PM, Sultanahamar Mohammad sultanm@thoughtworks.com wrote:

Hi Team,

While importing metadata into 2.26 instance from 2.26, we are facing the below exception. Could you please shed light on what might have gone wrong.

Exception:

  • INFO 2017-06-08 14:18:45,768 (system-process) Creating 245 object(s) of type ProgramStageDataElement (DefaultObjectBundleService.java [taskScheduler-9])
  • INFO 2017-06-08 14:18:46,073 (system-process) Creating 1 object(s) of type ProgramDataElement (DefaultObjectBundleService.java [taskScheduler-9])
  • WARN 2017-06-08 14:18:46,124 SQL Error: 0, SQLState: 23502 (SqlExceptionHelper.java [taskScheduler-9])
  • ERROR 2017-06-08 14:18:46,124 ERROR: ** null value** in column “programid” violates not-null constraint
    Detail: Failing row contains (2441, OPpE5v0VxoN, null, 2016-11-28 15:49:28.35, 2017-06-08 14:18:46.074, null, 1428). (SqlExceptionHelper.java [taskScheduler-9])
  • ERROR 2017-06-08 14:18:46,189 Exception occurred while trying to import the metadata. could not execute statement (MetadataSyncImportHandler.java [taskScheduler-9])
    org.hibernate.exception.ConstraintViolationException: could not execute statement
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)

Thanks,

Sultan Ahamar.

Morten Olav Hansen

Senior Engineer, DHIS 2

University of Oslo

http://www.dhis2.org