dhis2-devs team mailing list archive

[Sultanahamar Mohammad <sultanm@xxxxxxxxxxxxxxxx>]

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.