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
TeraSession: cli rejected buffer : Any one encountered this.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
-
- Participant
- Posts: 15
- Joined: Mon Mar 20, 2006 2:03 pm
Re: TeraSession: cli rejected buffer : Any one encountered t
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?
-
- Participant
- Posts: 15
- Joined: Mon Mar 20, 2006 2:03 pm
Re: TeraSession: cli rejected buffer : Any one encountered t
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?
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
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.
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.
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
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>
<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>
Re: TeraSession: cli rejected buffer : Any one encountered t
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]
[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]
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
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