What does this error mean? Status code = -1004

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
Minhajuddin
Participant
Posts: 467
Joined: Tue Mar 20, 2007 6:36 am
Location: Chennai
Contact:

What does this error mean? Status code = -1004

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

<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Are there any other error messages? Any warning message?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Minhajuddin
Participant
Posts: 467
Joined: Tue Mar 20, 2007 6:36 am
Location: Chennai
Contact:

There are a lot of warnings related to Schema..

Post by Minhajuddin »

Hi
There are a lot of warnings related to scema...
But this error is FATAL.
Minhajuddin

<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post 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?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Minhajuddin
Participant
Posts: 467
Joined: Tue Mar 20, 2007 6:36 am
Location: Chennai
Contact:

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

Post 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
Minhajuddin

<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post 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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Minhajuddin
Participant
Posts: 467
Joined: Tue Mar 20, 2007 6:36 am
Location: Chennai
Contact:

Thank you very much......

Post by Minhajuddin »

Hi
Thank you very much..........

:D :D :D
:D :D :D
:D :D :D
Minhajuddin

<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
Post Reply