Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   LSN error using FASTLOAD
From:   Duell, Bob


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. The FASTLOAD version is I don't remember ever seeing this message before upgrading.

Thanks very much,


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