Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 28 Nov 2007 @ 18:56:20 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   LSN error using FASTLOAD
 
From:   Duell, Bob

Hi,

I hope someone can help with a mysterious problem. We use SAS software to interact with Teradata. One feature enables SAS to invoke Teradata's FASTLOAD utility using a native SAS data source to provide rows to be inserted into a table. This has always worked well.

However, we have recently begun getting this error message from SAS:

ERROR: Fastload could not allocate data sessions: Associated LSN was not found.


The closest thing I can find in the Teradata Messages manual is this (from page 6-60):

*3029 Associated LSN was not found.*

*Explanation: *An LSN associate connect request has been received for a host/LSN which cannot be found in the system.

*Generated By: *Session Control.

*For Whom: *Support Representative.

*Notes: *This error is returned by an internal consistency check. This error causes an error message to be returned to the host.

*Remedy: *Check the LSN sent to the DBC to see that it already exists.


The problem cannot be reproduced; running the job a second time loads the table just fine so I assume it has something to do with system congestion or maybe a timing problem.

Can someone please help me diagnose this problem? If I can get a clear explanation on what this error means I may be able to get additional assistance from SAS.

Note: We upgraded the Teradata Utilities on our UNIX server in September, just prior to a system upgrade from V2R5. Our current release is V2R.06.01.01.74. The FASTLOAD version is 07.08.00.05. I don't remember ever seeing this message before upgrading.


Thanks very much,

Bob



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023