The JWP process throws a DB error

book

Article ID: 101495

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

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. 
 

Environment

Release: AUTWAB99000-11.2-Automic Workload Automation-Base Edition
Component:

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.