Article ID: 117207, created on Sep 11, 2013, last review on Nov 17, 2016

  • Applies to:
  • Operations Automation
  • Business Automation

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";
    

Search Words

domain won't register

subscriptions don't renew

renew

confirmation mail

ODBC code #XX002: ERROR: index "TaskEHID" contains unexpected zero page at block 147; Error while executing the query

Billing not available now

contains unexpected zero page at block

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 5356b422f65bdad1c3e9edca5d74a1ae

Email subscription for changes to this article
Save as PDF