Symptoms

It is impossible to perform some action in Control Panel, the attempts fail with a similar error:

"ODBC error #XX002: ERROR: index "TableName" contains unexpected zero page at block XXX; Error while executing the queryODBC error #XX002: ERROR: index "TableName" contains unexpected zero page at block XXX; Error while executing the query"

e.g. you cannot create a new account, it fails with:

"ODBC error #XX002: ERROR: index "TaskEID" contains unexpected zero page at block 334; Error while executing the queryODBC error #XX002: ERROR: index "TaskEID" contains unexpected zero page at block 334; Error while executing the query"

Cause

An indicated table index was corrupted (may be a result of a recent postgres or system failure, there was a lack of free space on the device, etc).

Resolution

  1. Backup the database (for backup consistency it is recommended to perform it with stopped service) of Operations Automation or Business Automation, depending on the table origin.
  2. Reindex corrupted index:

    pba=> REINDEX INDEX "TaskEID";
    

Internal content