Teradata Database Message 9146 - 9146 - Analytics Database - Teradata Vantage

Message

Block pointer in GeoSpatial Index is corrupted.

Explanation

This error occurs when a bad pointer in a directory or leaf block is detected. A Geospatial Index is physically stored in Hilbert RTREE organized as a multilevel hierachy consisting of N-1 directory levels and 1 leaf level. The hierarchy is constructed using directory blocks containing directory rows and leaf blocks containing leaf rows. The directory rows contain pointers that point toward the child blocks in the level below them. The header in each child and directory block contains a pointer that points backward to its parent row. When such a pointer become invalid, the index is unusable.

Generated By

CheckTable.

For Whom

Site support representative.

Notes

This error can occur in the following situations: 1. The backpointer in the header of leaf block is corrupted. 2. The backpointer in the header of directory block is corrupted. 3. The pointer in a directory row pointing toward to a child block is corrupted.

Remedy

Contact your Support Representative immediately.