15.00 - 7516 Stale object identifier. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

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