dhis2-devs team mailing list archive

[Morten Olav Hansen <morten@xxxxxxxxx>]

Hi Sultan

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

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Thu, Jun 8, 2017 at 8:19 PM, Sultanahamar Mohammad <
sultanm@xxxxxxxxxxxxxxxx> 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.
>