Hi all,
I have an issue on importing Program Indicators. The dry run shows that the data will create 23 new but when you then click on import there is an error with 0 imported.
I would appreciate some guidance to troubleshoot.
Elmarie
1 Like
Sorry to hear you’re facing this issue. It must be confusing having the dry run show a result which is then conflicted with the final result. I see the error message says: “constraint violation exception”. Could you check the Catalina.out log and see which metadata is facing this constraint violation?
Thanks!
@Gassim thanks. I eventually figured out the issue. There was a duplicated constraint, but although I removed it I still had errors about constraints in my original file. My first approach that resulted in this issue was to export PIs out and then to base the new PIs on that format. Eventually, I went with looking for the endpoint [URL/api/schemas/programIndicator.json?fields=properties[fieldName,required]] which listed the required fields. After I trimmed the payload to those fields only I was then able to import.
PS: I do believe this is a bug though, but unsure how exactly to duplicate it in Play instance in order to report so maybe someone from Oslo can attempt to replicate it and then report the bug where the Dry Run provides a successful import but the actual import must be checking for constraints as well and then fails. So clearly the dry run is not checking all the steps. Version I am using is 2.42.3.1