Need infromation regarding some Fatal errors

[ds_team]

When we run our job we are getting below Fatal errors, but the job is not getting aborted and no data missing is hapenning.
Can some one give me clues about why this fatal errors are coming up? How can i stop this?

199\2007-04-05 18:13:24\3\\3\APT_CombinedOperatorController,2: [DataDirect][ODBC SQL Serv (...)

185\2007-04-05 18:13:24\3\\3\APT_CombinedOperatorController,1: [DataDirect][ODBC SQL Serv (...)

170\2007-04-05 18:13:24\3\\3\APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Serv (...)

163\2007-04-05 18:13:24\3\\3\APT_CombinedOperatorController,0: [DataDirect][ODBC lib] Program type out of range

162\2007-04-05 18:13:23\3\\3\APT_CombinedOperatorController,2: [DataDirect][ODBC lib] Program type out of range

161\2007-04-05 18:13:23\3\\3\APT_CombinedOperatorController,1: [DataDirect][ODBC lib] Program type out of range

160\2007-04-05 18:13:23\3\\3\APT_CombinedOperatorController,3: [DataDirect][ODBC lib] Program type out of range

[ray.wurlod]

What have you listed here? It looks like the outout from DSGetLogSummary(). We really need detail of log events to be able to diagnose the problems more thoroughly. You may also need to disable combination, at least in the ODBC/DRS stage, to isolate the stage in which the errors are occurring.

[naserumak]

Hai,

This "DataDirect " is Special Driver For Informatica Power Center Tool.

Is There Any Informatica Job Is Running..

When we run our job we are getting below Fatal errors, but the job is not getting aborted and no data missing is hapenning.
Can some one give me clues about why this fatal errors are coming up? How can i stop this?

199\2007-04-05 18:13:24\3\\3\APT_CombinedOperatorController,2: [DataDirect][ODBC SQL Serv (...)

185\2007-04-05 18:13:24\3\\3\APT_CombinedOperatorController,1: [DataDirect][ODBC SQL Serv (...)

170\2007-04-05 18:13:24\3\\3\APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Serv (...)

163\2007-04-05 18:13:24\3\\3\APT_CombinedOperatorController,0: [DataDirect][ODBC lib] Program type out of range

162\2007-04-05 18:13:23\3\\3\APT_CombinedOperatorController,2: [DataDirect][ODBC lib] Program type out of range

161\2007-04-05 18:13:23\3\\3\APT_CombinedOperatorController,1: [DataDirect][ODBC lib] Program type out of range

160\2007-04-05 18:13:23\3\\3\APT_CombinedOperatorController,3: [DataDirect][ODBC lib] Program type out of range

[ds_team]

What do you meant by disable com...
I dont have more information related to this as this was a production error.
Can you let me know whether this error is something related to the job or is it comming from datasabe side, due to some configuration issues.

Our jobs picks flatfile and then uses ODBC stage to load the data in flat file to corresponding tables, with a tranfromer stage in between sequential file stage and odbcstage.
sequentialfile stage--->transformer stage---->ODBCstage (sybase database)
The fatal errors which i pasted is from the DSGetLogSummary.
Due to this error our job is not getting aborted. Any clue on why this message is coming up?????

[chulett]

Post some detail error messages so we can see what's behind the ellipses, the (...) part.

[ray.wurlod]

Look in the Director job log and double click on any of the error messages to get detail view.

You can code to get these using DSGetLogEntry() function.

[ds_team]

Errors from the director are as follows
APT_CombinedOperatorController,2: [DataDirect][ODBC lib] Program type out of range
APT_CombinedOperatorController,1: [DataDirect][ODBC lib] Program type out of range
APT_CombinedOperatorController,3: [DataDirect][ODBC lib] Program type out of range
APT_CombinedOperatorController,0: [DataDirect][ODBC lib] Program type out of range

And some times below errors also comes up with above listed errors.
APT_CombinedOperatorController,3: [DataDirect][ODBC SQL Serv
{0}
can some one give clues about why this is coming up??

These are the only fatal errors in director.My job wont get aborted due to these errros.

[ray.wurlod]

There must be more information available. Run the job with APT_DISABLE_COMBINATION set to True.

[ds_team]

can you please guide me where can i get the APT_DISABLE_COMBINATION? And how can i set it true?

There must be more information available. Run the job with APT_DISABLE_COMBINATION set to True. ...

[ray.wurlod]

Go to your job's Parameters grid (in job properties dialog).
Click Add Environment Variable.
Choose APT_DISABLE_COMBINATION from the list supplied.

When you run the job, set it to True.