DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
dskid
Participant



Joined: 19 Jun 2006
Posts: 13
Location: uk
Points: 179

Post Posted: Thu Jul 05, 2018 2:18 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Invalid precision value
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)


Last edited by dskid on Mon Jul 09, 2018 8:11 am; edited 1 time in total
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54248
Location: Sydney, Australia
Points: 294235

Post Posted: Mon Jul 09, 2018 12:36 am Reply with quote    Back to top    

Are the Oracle data types specified in BYTES or in CHARACTERS?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
dskid
Participant



Joined: 19 Jun 2006
Posts: 13
Location: uk
Points: 179

Post Posted: Mon Jul 09, 2018 8:08 am Reply with quote    Back to top    

Hi Ray,
In Target Oracle, it is defined as VARCHAR2(5000 BYTE).
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42617
Location: Denver, CO
Points: 219422

Post Posted: Mon Jul 09, 2018 10:17 am Reply with quote    Back to top    

So... which 12c version of Oracle? VARCHAR2 have been limited to 4000 bytes since forever until recently and you need to have set MAX_STRING_SIZE = EXTENDED for it to exceed that - up to 32767 bytes in that case. I wonder if that option is fully supported by ODBC / RCP... may need to be a support question.

_________________
-craig

And I'm hovering like a fly, waiting for the windshield on the freeway...
Rate this response:  
Not yet rated
dskid
Participant



Joined: 19 Jun 2006
Posts: 13
Location: uk
Points: 179

Post Posted: Mon Jul 09, 2018 2:12 pm Reply with quote    Back to top    

Yes, this has been sent to support as well. Thought will check in the forum if some one has already went thru this issue before. Anyway i will update the thread as soon as i hear from IBM
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours