Informix Wire, unexpected network error

rajiivnb · Post by **rajiivnb** » Wed Mar 23, 2005 10:12 pm

Hi Group,

Can any one tell me why this error is coming,

name_alias_11..Dest_name_alias.IP_02: DSD.BCIClose call to SQLTransact failed.
SQLSTATE=S1000, DBMS.CODE=-95
[DataStage][SQL Client][ODBC][DataDirect][ODBC Informix Wire Protocol driver][Informix]Unexpected Network Error.
SQLSTATE=S1000, DBMS.CODE=-255
[DataStage][SQL Client][ODBC][DataDirect][ODBC Informix Wire Protocol driver][Informix]Not in transaction.

Actually am running a big sequence, this error is thrown only for this job and that too in the target stage. am using ODBC has a target stage. my database is informix. this table contains 2.5 lacs data. another table with same data is running fine.. can any one suggest me wht i can do...

thnx in advance.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 23, 2005 10:16 pm

Looks like the network has dropped out around about when DataStage is trying to close the connection to Informix.

Does this happen reliably, or only once? Usually a dedicated network segment, isolated from the remainder of the network, is a good idea in these circumstances.

rajiivnb · Post by **rajiivnb** » Wed Mar 23, 2005 10:22 pm

Hi Ray,

Actually this problem comes only to this particular job. recently this error is coming when ever i run this job, before it was fine. Can you tell me clearly what should be done for this.

thnx,

Rajesh.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 23, 2005 10:38 pm

In short, check everything to do with the connectivity path. Thoroughly.

Check it again.

Get fresh eyes to look at it - you may be so familiar with it that you're missing seeing a vital "." or similar.