Hi all,
I'm trying to import the following object (derived from an exported object) with request:
http://[server]:8088/ae/api/v1/[client]/objects/?overwrite_existing_objects=true{
"path" : "TEST/SCHEDULE",
"data" : {
"jsch" : {
"general_attributes" : {
"minimum_ae_version" : "11.2",
"auto_deactivation" : "A",
"workflow_children" : "1",
"name" : "SCHED.TEST",
"type" : "JSCH",
"inherit_output_filter" : "N",
"queue" : "CLIENT_QUEUE",
"time_zone" : "TZ.GMT.1"
},
"schedule_attributes" : {
"period" : "99",
"start_time" : "2000-01-01 00:00:00.0"
},
"workflow_definitions" : {
"earliest_start_time" : "001818",
"object_name" : "1300_J_IVKMDS_0001_JOBP.UC298",
"object_type" : "JOBP",
"postcondition_execute_flag" : "1"
}}}}
and getting this error
REST:
{
"code" : 45110,
"error" : "An Automation Engine internal error occured.",
"details" : "No detail information available."
}
Server log:
U00045098 Method 'POST', URL: 'http://[server]:8088/ae/api/v1/[client]/objects'
U00045105 Log on of 'XXX' successful.
U00045197 FileSync: Import object 'JSCH.NEW.1' of type 'JSCH'
U00045014 Exception 'com.automic.database.api.DBException: "INSERT INTO OSA (OSA_ACTATRUN,OSA_OH_IDNR,OSA_PERIOD,OSA_StartTime) VALUES (?,?,?,?)
The insert or update value of the FOREIGN KEY "UC4DBUSR.OSA.FK_OSA_OH" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=4.17.29"' at 'com.automic.database.impl.DBConnectionImpl.executeInternal():462'.
U00045015 The previous error was caused by 'com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: "DB2 SQL Error: SQLCODE=-530, SQLSTATE=23503, SQLERRMC=UC4DBUSR.OSA.FK_OSA_OH, DRIVER=4.17.29"' at 'com.ibm.db2.jcc.am.hd.a():743'.
U00045099 The server replied with following status: '500'
Any idea what could be the reason for this problem?
------------------------------
IT Architect
IBM Germany
------------------------------