ORA-00904 Invalid identifier

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
CLOPES
Participant
Posts: 52
Joined: Tue Jul 22, 2003 8:05 am
Location: France
Contact:

ORA-00904 Invalid identifier

Post by CLOPES »

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 ?!!?? :shock:
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
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

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.
csrazdan
Participant
Posts: 127
Joined: Wed May 12, 2004 6:03 pm
Location: Chicago IL

Post by csrazdan »

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
CLOPES
Participant
Posts: 52
Joined: Tue Jul 22, 2003 8:05 am
Location: France
Contact:

Post by CLOPES »

[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.
CLOPES
Participant
Posts: 52
Joined: Tue Jul 22, 2003 8:05 am
Location: France
Contact:

Post by CLOPES »

[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.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

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.
CLOPES
Participant
Posts: 52
Joined: Tue Jul 22, 2003 8:05 am
Location: France
Contact:

Re: ORA-00904 Invalid identifier

Post by CLOPES »

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.
Post Reply