Job aborts in half the way

arshi · 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 · 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?

chulett · 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.

arshi · 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 · 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 · Post by **ray.wurlod** » Mon Apr 30, 2007 12:39 am

Employ a pair of Code tags to make your "ASCII art" appear correct.