DSXchange

gssr

dsjob -logsum <Project> <Job_name>

gssr

I dropped the Constraint in the table, the job works fine now,

Still could not able to get the error Source !!!

Thanks for your Thoughts!!!!

gssr

gssr wrote:

(ORD_IND IN(0,1,2,3,4,5,6,7,8)) INSTEAD OF (ORD_IND IN (0,1,2,3,4,5,6,7,8))
Anything this may cause!!!

in the above is actually '8' and ')'

gssr

I checked the DDL of the table with constraint

Code: Select all

ALTER TABLE Test.Table1
ADD CONSTRAINT CHK_ORD_IND CHECK
(ORD_IND IN(0,1,2,3,4,5,6,7,8))
 ENABLE
;

Is that correct to mention

(ORD_IND IN(0,1,2,3,4,5,6,7,8)) INSTEAD OF (ORD_IND IN (0,1,2,3,4,5,6,7,8))

Anything this may cause!!!

gssr

I tried to get into another dataset in target, and i can able to view it in the target output!!
I will try to use a peek stage and update about the feedback

gssr

I am just passing 3 record only , I can view the records in the input dataset as ORD_IND is all 6

In the error message, i am getting only this constraint as Violated!!

gssr

i checked with the constraint, and it is

Code: Select all

Ord_ind in (1,2,3,4,5,6)

The insert records are all having 6 as Ord_ind

But Still it was throwinmg the same error..

gssr

I can understand that by using Nikhil solution ,i can get the same output.

But, i want to know which is the cause for this ERROR!!

Any idea

I am currently trying to implement Nikhil's design, and post the update asap.

gssr

Thanks for your thoughts Nikhil,

Actually we got more than 20 constraints in the table

Its not possible to get all that in to the transformer...

Actually, i dont know why this error is arising??
Can you give me the root cause about this...

Thyanks in advance

gssr

I am updating and inserting the table with the following job Dataset --> Transformer --> Oracle -->Reject While executing it throws me the following errorm Orac_load,1: Open failed for insert: insert is: (<Insert Query> ) sqlcode is: -2290 esql complaint: ORA-02290: check constraint (Column Constrai...

gssr

We learned that one !!!!

Thanks for your thoughts,

gssr

Code: Select all

All exports from the DataStage repository are performed on the Windows workstation. There is
no server-side project export facility.

gssr

Hope this will help you,

viewtopic.php?t=124347&highlight=not+in+your+VOC

Hit the dsxchange search engine for more suggestions

gssr

Try this,

Code: Select all

dsjob -run -jobstatus projectname jobname

gssr

HI,
Can you send me the guide to my mail id rajkumar.datastage@gmail.com

Thanks in Advance,

Search found 243 matches

sqlcode is: -2290