Consultor Eletrônico



Kbase P25597: Error 7967 after schema has been updated
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   2/21/2005
Status: Verified

FACT(s) (Environment):

Progress 9.1D

SYMPTOM(s):

Getting error 7967 after updating schema

Unable to locate index '<indexname>' on table '<tablename>' for procedure '<procedure>'. (7967)

Index was deleted during schema update

CAUSE:

Code (re)compiled against outdated schema.
The r-code will contain references to the indexes used, and these will be checked when the procedure is run.
As one of the indexes referenced in the r-code no longer exists, the error occurs.

FIX:

Recompile the code against the updated schema.