Teradata Database Message 7516 - 17.10 - 7516 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
Stale object identifier.
This error is returned when a reference to a large object value cannot be resolved because the object was deleted or modified after the reference was generated.
Generated By
The large object access routines
For Whom
This error can occur in the following situations: 1. A query referenced a large object under an access lock while another transaction modified the same object. 2. A query returned a non-static locator, which was used in a subsequent query after committing the original transaction, but the object was modified in the interval between the end of the original transaction and the time the locator was dereferenced.
In the first situation, resubmit the query that failed. If the error occurs too frequently, consider using a read lock. In the second situation, consider using static locators to preclude occurrences of this error.