ODBC Invalid Precision value
Posted: Thu Jul 05, 2018 2:18 pm
Hi,
We are moving our jobs from 8.5 to 11.7 and our jobs extract data from SQL Server to Oracle 12c. These jobs are RCP enabled and we use ODBC stage for loading data into target.
This jobs extracts data from intermediate Dataset to Oracle. We don't have any problem running these jobs in 8.5, but in 11.7 we get the below error whenever there is a length miss-match between source and target fields. In source for one of field lengths is VARCHAR 5000 and target length is VARCHAR 4000.
So we changed the length in target to 5000 (after enabling MAX_STRING_SIZE= extended in Oracle), I am still getting the same error. Any suggestions please? I was able to load other tables where the lengths are matching.
ODBC_Connector_13,0: ODBC function "SQLExecute" reported: SQLSTATE = HY104: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver]Invalid precision value. Error in parameter 14. (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 832)
We are moving our jobs from 8.5 to 11.7 and our jobs extract data from SQL Server to Oracle 12c. These jobs are RCP enabled and we use ODBC stage for loading data into target.
This jobs extracts data from intermediate Dataset to Oracle. We don't have any problem running these jobs in 8.5, but in 11.7 we get the below error whenever there is a length miss-match between source and target fields. In source for one of field lengths is VARCHAR 5000 and target length is VARCHAR 4000.
So we changed the length in target to 5000 (after enabling MAX_STRING_SIZE= extended in Oracle), I am still getting the same error. Any suggestions please? I was able to load other tables where the lengths are matching.
ODBC_Connector_13,0: ODBC function "SQLExecute" reported: SQLSTATE = HY104: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver]Invalid precision value. Error in parameter 14. (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 832)