Archives of the TeradataForum

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

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

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>>