Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
arshi
Participant
Posts: 50 Joined: Wed Apr 18, 2007 5:12 am
Post
by arshi » Fri Apr 27, 2007 4:06 am
Hi,
while running the sequencer one job aborts in half the way.
It is giving the following Fatal warning in director.
Database is informix.
SQLSTATE=S1000, DBMS.CODE=-243
[DataStage][SQL Client][ODBC][DataDirect][ODBC Informix Wire Protocol driver][Informix]10843
Transformer_1: |19|
Help me to resove the problem.
Regards,
Arshi
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Fri Apr 27, 2007 7:07 am
Its an ODBC error. Can you please give us some insight on the job design the sequence job design. What other error messages are there, if any and what happens when you run this job outside the sequence job. Do you still get the same error message?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Apr 27, 2007 7:08 am
First thought would be to take these messages to your Informix DBA and see if they mean anything to them.
-craig
"You can never have too many knives" -- Logan Nine Fingers
arshi
Participant
Posts: 50 Joined: Wed Apr 18, 2007 5:12 am
Post
by arshi » Sun Apr 29, 2007 8:29 pm
DSguru2B,
I ran the same job individually.Stiil its giving same error.It stops at around 800th row then aborted.We checked the data at the source also.Every thing looks OK.
Design :
ODBC ------->>TRANS1------>TRANS2----->ODBC
^ ^
| |
| |
| |
0DBC ODBC
(lookup) (lookup)
Regards,
Arshi
arshi
Participant
Posts: 50 Joined: Wed Apr 18, 2007 5:12 am
Post
by arshi » Sun Apr 29, 2007 8:49 pm
DSGuru2B,
In the design of the job TRANS1 have ODBC lookup and TRANS2 have ODBC lookup.In this post it not showing correctcly
Design:
ODBC ------->>TRANS1------>TRANS2----->ODBC
^ ^
| |
| |
| |
0DBC ODBC
(lookup) (lookup)
At TRANS1 its aborted.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Apr 30, 2007 12:39 am
Employ a pair of
Code tags to make your "ASCII art" appear correct.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.