Error in Oracle Stage

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
dganeshm
Premium Member
Premium Member
Posts: 91
Joined: Tue Aug 11, 2009 3:26 pm

Error in Oracle Stage

Post by dganeshm »

Fatal Error :

Update_Repl_Parts: The provided insert statement did not prepare correctly;
please verify that your statement is correct;
statement: INSERT INTO INTF_ORIG_REPL_PART (SC_AUTH_NUM, SC_ITEM_NUM, VID, REPL_PART_ID, Create_Dte, AUTH_FLG, AUTH_PART_ID) VALUES ( :SC_AUTH_NUM, :SC_ITEM_NUM, :VID, :REPL_PART_ID, :Create_Dte, :AUTH_FLG, :AUTH_PART_ID).
Unable to find a free dynamic SQL instance.
Error: Instance number must be 0 <= -1 <= 9


There is an information before this error : main_program: -nchar_cs option is deprecated.
-nchar_cs option is deprecated.
-nchar_cs option is deprecated.
-nchar_cs option is deprecated.
-nchar_cs option is deprecated.
-nchar_cs option is deprecated.
-nchar_cs option is deprecated.
-nchar_cs option is deprecated.

Can someone help ASAP , thanks in advance.
Regards,
Ganesh
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I would suggest looking for a paid-for service for "ASAP" support, this is a volunteer forum.

Could your problem be this IBM APAR?
dganeshm
Premium Member
Premium Member
Posts: 91
Joined: Tue Aug 11, 2009 3:26 pm

Post by dganeshm »

ArndW wrote:I would suggest looking for a paid-for service for "ASAP" support, this is a volunteer forum.

Could your problem be this IBM APAR?
Thanks ArndW..the patch worked..
Regards,
Ganesh
Post Reply