TeraSession: cli rejected buffer : Any one encountered this.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
DS_FocusGroup
Premium Member
Premium Member
Posts: 197
Joined: Sun Jul 15, 2007 11:45 pm
Location: Prague

TeraSession: cli rejected buffer : Any one encountered this.

Post by DS_FocusGroup »

Al_Address_Name_Link_FL,0: TeraSession: cli rejected buffer write, stall #0 of 0.

I am trying to FASTLOAD 30 million rows in teradata.It is failing

Any ideas.

For another table I put 9000 and it fails for the same reason


Serve is on UNIX
wenfei.chen
Participant
Posts: 15
Joined: Mon Mar 20, 2006 2:03 pm

Re: TeraSession: cli rejected buffer : Any one encountered t

Post by wenfei.chen »

Is that the only message you got from Director?
DS_FocusGroup wrote:Al_Address_Name_Link_FL,0: TeraSession: cli rejected buffer write, stall #0 of 0.
What's the next?
wenfei.chen
Participant
Posts: 15
Joined: Mon Mar 20, 2006 2:03 pm

Re: TeraSession: cli rejected buffer : Any one encountered t

Post by wenfei.chen »

Is that the only message you got from Director?
DS_FocusGroup wrote:Al_Address_Name_Link_FL,0: TeraSession: cli rejected buffer write, stall #0 of 0.
What's the next?
DS_FocusGroup
Premium Member
Premium Member
Posts: 197
Joined: Sun Jul 15, 2007 11:45 pm
Location: Prague

Post by DS_FocusGroup »

I got this as well : Al_Address_Name_Link_FL,0: TeraUtils:Put failed: Error Code = 350.

Al_Address_Name_Link_FL,0: DBCAREA msg_txt: Completed successfully.

and at the end

Al_Address_Name_Link_FL: 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.
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

You might have to install a patch for resolving this. Pls. refer this LINK for details.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
ewaddell
Premium Member
Premium Member
Posts: 1
Joined: Wed Aug 23, 2006 12:45 pm

Re: TeraSession: cli rejected buffer : Any one encountered t

Post by ewaddell »

I also experienced this error. Duplicate table rows was our issue.

[quote="DS_FocusGroup"]Al_Address_Name_Link_FL,0: TeraSession: cli rejected buffer write, stall #0 of 0.

I am trying to FASTLOAD 30 million rows in teradata.It is failing

Any ideas.

For another table I put 9000 and it fails for the same reason


Serve is on UNIX[/quote]
r.bhatia
Participant
Posts: 11
Joined: Mon Jun 30, 2008 12:45 am
Location: Manchester

Post by r.bhatia »

Hi!
I did encounter the same problem while loading 37million rows on to a table.

The job was executing successfully previously but started failing one day and gave the same error with multiple trials.

The table had one of its column as varchar 8 we changed it to char 8 in dataset and table definition. The load completed successfully after this change.

Can someone tell me is this a known problem with this stage?

Thanks
Rakesh
Post Reply