Teradata Database Message 7516 - 7516 - Analytics Database - Teradata Vantage

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.