One and the same get-metadata call is returning different INT types for the same table

Document ID : KB000095825
Last Modified Date : 11/07/2018
Show Technical Document Details
Issue:
In V12.1 SP1 when using OJDBC8.JAR driver the following error is thrown when a java work process (JWP) starts

Please note that this is just a short excerpt from the JWP log:
...
20180209/143650.126 - 25 INSERT INTO RT (RT_AH_Idnr,RT_Content,RT_Lnr,RT_Type) VALUES (?,?,?,?) 
20180209/143650.135 - 25 UCUDB32 EXEC RET 0001 HSTMT: 0000000000000067 VALUE: 0000000000000000 ALL: 0.00900 DB: 0.00000 ODBC: 0.00000 UDB: 0.00000 
20180209/143650.135 - 25 UCUDB32 CLST RET 0000 HSTMT: 0000000000000067 VALUE: 0000000000000000 
20180209/143650.136 - 25 U00003590 UCUDB - DB error: '23000', 'ORA-01400: cannot insert NULL into ("UC4"."RT"."RT_MSGNR") 
20180209/143650.136 - 25 ', '1400', 'java.sql.SQLIntegrityConstraintViolationException' 
20180209/143650.137 - 25 SQL Statement which caused this DB error: 
20180209/143650.137 - 25 U02012075 Set bind parameter '1' of type 'Integer' to value '1444001' 
Excerpt from logs 
20180209/143349.703 - 25 U00003590 UCUDB - DB error: '23000', 'ORA-01400: cannot insert NULL into ("UC4"."RH"."RH_CLIENT") 
20180209/143349.703 - 25 ', '1400', 'java.sql.SQLIntegrityConstraintViolationException' 
20180209/143349.704 - 25 SQL Statement which caused this DB error: 
20180209/143650.178 - 25 U02012075 Set bind parameter '3' of type 'Integer' to value '4' 
20180209/143650.178 - 25 U02012075 Set bind parameter '4' of type 'String' to value 'LOG' 
20180209/143650.179 - 25 INSERT INTO RT (RT_AH_Idnr,RT_Content,RT_Lnr,RT_Type) VALUES (?,?,?,?) ...
 ...

When calling get-metadata multiple times with  OJDBC8.JAR it is returning different INT types for the same table. 


The returned data type has to be added to our bundle. 
Environment:
Automation Engine with Oracle database
 
Resolution:
Update to a fixed version listed below or a newer version if available.
Component(s): AE Server and Initial data
Automation Engine 12.1.3 - Available
Automation Engine 12.2.0 - Available
Automation Engine 11.2.9 - Available

Workaround: Please use ojdbc7.jar and the UID in the UCSRV.INI connection string must be the same as the oracle dbowner e.g. ODBCVAR=NNJNIORO,DSN=UC4;UID=uc4;PWD=--1037B2E22BF022EBE2;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15