Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

Running the UPDATE STATISTICS command for all tables on a database gives the following error: 'Update count = 0. === SQL Exception 1 === SQLState=HY000 ErrorCode=-219903[DataDirect][OpenEdge JDBC Driver][OpenEdge] Inconsistent metadata - contact Progress technical support. (7899)'

error 'Update count = 0. === SQL Exception 1 === SQLState=HY000 ErrorCode=-219903 [DataDirect][OpenEdge JDBC Driver][OpenEdge] Inconsistent metadata - contact Progress technical support. (7899) when doing the SQL command 'UPDATE STATISTICS;' when a table without any field is present in the database.

Running the UPDATE STATISTICS command for all tables on a database gives the following error: 'Update count = 0. === SQL Exception 1 === SQLState=HY000 ErrorCode=-219903 [DataDirect][OpenEdge JDBC Driver][OpenEdge] Inconsistent metadata -contact Progress technical support. (7899)'

FACT(s) (Environment):

progress 10.2B
OPenEdge category

CAUSE:

Bug# OE00205867

FIX:

To allow the SQL command 'update statistics;' to work either add a field to the empty table or delete the empty table from the database.
Under Microsoft Windows you can do the following:
To delete the empty table do the following:
Start -> All Programs -> OpenEdge -> Data Dictionary -> select the empty table and click on the button 'Delete Table'
To add an empty field to the empty table do the following:
Start -> All Programs -> OpenEdge -> Data Dictionary -> select the table 'guie' and click on the button 'Fileds' and then 'Create Field...' and enter a new field name for example 'deleteMeLater'