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

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
Stale object identifier.
Explanation
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
Customer.
Notes
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.
Remedy
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.