Session Error

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
sanghamitra
Participant
Posts: 1
Joined: Wed Oct 24, 2007 4:31 am
Location: Gurgaon

Session Error

Post by sanghamitra »

Hi All,

I am getting the following eror while trying to insert data from dataset to Teradata table using Teradata Enterprise stage.

Teradata_Enterprise_0,0: TeraUtils:Put failed: Error Code = 350
Teradata_Enterprise_0,0: DBCAREA msg_txt: Completed successfully.
Teradata_Enterprise_0,0: session wait failed, return code = 311
Teradata_Enterprise_0,0: Error waiting for session.
Teradata_Enterprise_0,0: Cannot write record.
Teradata_Enterprise_0,0: The runLocally() of the operator failed.
Teradata_Enterprise_0,0: Operator terminated abnormally: runLocally did not return APT_StatusOk
Teradata_Enterprise_0: TeraGenericQuery Error: Request Close failed: Error Code = 305 Session return code = 305 , DBC return code = 305
DBC message: CLI2: NOREQUEST(305): Specified request does not exist.

I have enabled the APT_TERA_64K_BUFFERS parameter and have increased the Buffer Size at the stage level as well. The SessionPerPlayer have been set to 2.

Please help me in solving the error.
Sanghamitra
nishadkapadia
Charter Member
Charter Member
Posts: 47
Joined: Fri Mar 18, 2005 5:59 am

Re: Session Error

Post by nishadkapadia »

The following entry is mentioned in your log
---Teradata_Enterprise_0,0: Cannot write record.

Looks like ,check n the metadata in Teradata and in the source dataset
would be good place to start.
nishadkapadia
Charter Member
Charter Member
Posts: 47
Joined: Fri Mar 18, 2005 5:59 am

Re: Session Error

Post by nishadkapadia »

The following entry is mentioned in your log
---Teradata_Enterprise_0,0: Cannot write record.

Looks like ,check the metadata in Teradata and in the source dataset
would be good place to start.
Post Reply