DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
CLOPES
Participant



Joined: 22 Jul 2003
Posts: 50
Location: France
Points: 388

Post Posted: Tue Mar 06, 2007 1:25 pm Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Additional info: Oracle client in Unix server 10.2.0.2 into Oracle db 9.2
Hi All,

I create a simple job with DS => TRT => OCI
I read a single column in the dataset (ID Bigint) then i add a column timestamp (UPDT_DATE CurrentTimestamp()) in the transformer.
I insert them into a table IVRS_DATA_LOG in load and append with parallel option and NLS WE8ISO8859P1.
There's just one line.

Then i have this message error :
SQL*Loader-925: Error while uldlpim: OCIStmtExecute
ORA-00904: "MESSAGE_NUM": Invalid identifier

I don't know where this column come from ?!!?? Shocked
My oracle table have four columns and i insert data into two of them.
This column doesn't exist. So anybody have an idea ??
DSguru2B

Premium Poster


since February 2006

Group memberships:
Premium Members, Heartland Usergroup

Joined: 09 Feb 2005
Posts: 6854
Location: Houston, TX
Points: 35663

Post Posted: Tue Mar 06, 2007 1:27 pm Reply with quote    Back to top    

What about your metadata? Do you have this column there? Do you have user defined sql?

_________________
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Rate this response:  
Not yet rated
csrazdan
Participant



Joined: 12 May 2004
Posts: 127
Location: Chicago IL
Points: 1189

Post Posted: Tue Mar 06, 2007 1:33 pm Reply with quote    Back to top    

Add a environment variable APT_STRING_PADCHAR to your job and set the value to 0X00

Hope it helps....

_________________
Assume everything I say or do is positive
Rate this response:  
Not yet rated
CLOPES
Participant



Joined: 22 Jul 2003
Posts: 50
Location: France
Points: 388

Post Posted: Tue Mar 06, 2007 1:39 pm Reply with quote    Back to top    

[quote="DSguru2B"]What about your metadata? Do you have this column there? Do you have user defined sql?[/quote]

this column don't exist in the target and i don't use user defined in this case.
Rate this response:  
Not yet rated
CLOPES
Participant



Joined: 22 Jul 2003
Posts: 50
Location: France
Points: 388

Post Posted: Tue Mar 06, 2007 1:41 pm Reply with quote    Back to top    

[quote="csrazdan"]Add a environment variable APT_STRING_PADCHAR to your job and set the value to 0X00

Hope it helps....[/quote]

i'l see it tomorow at work thanks.
Rate this response:  
Not yet rated
DSguru2B

Premium Poster


since February 2006

Group memberships:
Premium Members, Heartland Usergroup

Joined: 09 Feb 2005
Posts: 6854
Location: Houston, TX
Points: 35663

Post Posted: Tue Mar 06, 2007 3:02 pm Reply with quote    Back to top    

Make sure you have the correct qualified name for the database table.

_________________
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Rate this response:  
Not yet rated
CLOPES
Participant



Joined: 22 Jul 2003
Posts: 50
Location: France
Points: 388

Post Posted: Mon Mar 12, 2007 1:29 pm Reply with quote    Back to top    

FOUND.

OCI PX stage need to read/write an Oracle view using LOAD (SqlLoader) and it seems that in Oracle 9i or in the Database i want to insert data 9.2.0.1 version, there's just a column MESSAGE and not MESSAGE_NUM.
I changed to upsert and it works,

Thanks.
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