Kbase P27237: Getting error 7967 when running new code against database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/06/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Getting error 7967 when running new code against database
Unable to locate index '<indexname>' on table '<tablename>' for procedure '<procedure>'. (7967)
CAUSE:
Schema changes hadn't been propagated from the dev database to the database that the code should run against; delta.df hadn't been applied.
The following was tested on 9.1D on HP-UX 11 32-bit:
1. prodb sports sports
2. pro sports
3. Compile the following:
/* disp.p */
for each cust:
disp cust.
end.
This gives you disp.r
4. mkdir prod
5. prodb prod/sports sports
6. cp disp.r prod
7. pro prod/sports -p disp.r works ok.
8. Add a new index to sports.
9. Compile the following code against that database:
/* disp.p */
for each cust use-index newindex:
disp cust.
end.
10. cp disp.r prod
11. pro prod/sports -p disp.r
returns the 7967 error.
Generating a delta.df between sports and prod/sports and applying this to prod/sports then allows the new disp.r to run ok.
FIX:
Ensure to apply the schema changes to the database you want to run the code against. The schema has to be the same as for the database against which the code was compiled.