Page 1 of 1

What does this error mean? Status code = -1004

Posted: Fri May 18, 2007 9:39 am
by Minhajuddin
Hi all,
I have designed a parallel job.
It has two sequential files joined by a JOIN stage and then pass through a transformer to the target sequential file.
And when I compile and run it. This is the error it shows.

Status code = -1004
[1] + Done(134) ?
5296 Abort test

Can anybody help me out with this.
Thanks a lot.

Posted: Fri May 18, 2007 10:26 am
by DSguru2B
Are there any other error messages? Any warning message?

There are a lot of warnings related to Schema..

Posted: Fri May 18, 2007 10:42 am
by Minhajuddin
Hi
There are a lot of warnings related to scema...
But this error is FATAL.

Posted: Fri May 18, 2007 10:45 am
by DSguru2B
Then fixing those warning message will elimate the fatal message. And therefore require knowledge of the warning messages. Do you mind sharing it with us?

There are a lot of warnings. Here are some........

Posted: Fri May 18, 2007 10:49 am
by Minhajuddin
Join_2: When checking operator: On input data set 1: When binding input interface field "BILLING_ACCT_NUMBER" to field "BILLING_ACCT_NUMBER": Implicit conversion; from source type "int32" to result type "string[max=100]": Converting number to string

Sequential_File_5: When checking operator: When validating export schema: At field "CUSTOMER_CODE": Exporting nullable field without null handling properties

Sequential_File_5: When checking operator: When validating export schema: At field "BILLING_ACCT_NUMBER": Exporting nullable field without null handling properties

Posted: Fri May 18, 2007 10:51 am
by DSguru2B
Now that makes it so much easier.
Two things
1) You are directly linking an integer field to a character field which is a big no no. You need to explicitly convert.
2) You have a nullable field without any null handling.

Now if you search on the error messages, you will see that this has been covered time and again. Therein you will find your answers.

Thank you very much......

Posted: Fri May 18, 2007 10:54 am
by Minhajuddin
Hi
Thank you very much..........

:D :D :D
:D :D :D
:D :D :D