The JWP process throws a DB error

Document ID : KB000101495
Last Modified Date : 19/07/2018
Show Technical Document Details
Issue:
The JWP process does not start correctly, a database error is received and can be found in the log file for the process.
Depending on the database the error message received is different:
Oracle
U00003590 UCUDB - DB error: '23000', 'ORA-01400: cannot insert NULL into ("UC4"."OH"."OH_CLIENT")  ', '1400', 'java.sql.SQLIntegrityConstraintViolationException' 
SQL Statement which caused this DB error: 
U02012075 Set bind parameter '1' of type 'Timestamp' to value 'CCYY-MM-DD HH:MM:SS.SSS' 
U02012075 Set bind parameter '2' of type 'Integer' to value '5' 
U02012075 Set bind parameter '3' of type 'Integer' to value '100621' 
U02012075 Set bind parameter '4' of type 'String' to value 'AAETEST#WP015' 
U02012075 Set bind parameter '5' of type 'String' to value 'SERV' 
INSERT INTO OH (OH_CrDate,OH_CrUserIdnr,OH_Idnr,OH_Name,OH_OType) VALUES (?,?,?,?,?)  

DB2
U00003590 UCUDB - DB-Fehler: '23502', 'DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=2, TABLEID=522, COLNO=0, DRIVER=4.7.85', '-407', 'com.ibm.db2.jcc.am.go'
SQL Statement which caused this DB error:
U02012075 Setze Bindparameter '1' vom Typ 'Timestamp' auf den Wert '2018-03-09 10:04:20.417'.
U02012075 Setze Bindparameter '2' vom Typ 'Integer' auf den Wert '5'.
U02012075 Setze Bindparameter '3' vom Typ 'Integer' auf den Wert '114642'.
U02012075 Setze Bindparameter '4' vom Typ 'String' auf den Wert 'DC4#WP010'.
U02012075 Setze Bindparameter '5' vom Typ 'String' auf den Wert 'SERV'.
INSERT INTO OH (OH_CrDate,OH_CrUserIdnr,OH_Idnr,OH_Name,OH_OType) VALUES (?,?,?,?,?)
Cause:
The JWP does not recognize the database schema when the owner of the database schema is defined differently as the database logon user ID in the "sqlDriverConnect" string in the ucsrv.ini. 
 
Resolution:
A correction for this issue is available on the following versions:
  • Automation Engine 11.2.8 - currently planned to be released the beginning of June 2018.
  • Automation Engine 12.0.5 - Available
  • Automation Engine 12.1.2 - Available
Please install one of the above listed versions or a higher version to resolve this issue.

Workaround:
Start the JWP with a database logon user ID, which is same as the database schema owner.