Archives of the TeradataForum
Message Posted: Wed, 28 Nov 2007 @ 18:56:20 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|