Kbase P28548: ORACLE Dsrv: CRC errors are encountered after schema changes
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/07/2003 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Fail to compare ORACLE schema;
file <table> counted num flds: 76 fildes: 77. (2720)
RECIDFLG NOT set; fldinfo count: 138. (4508)
Unable to locate index for <table>. (3252)
** Unable to run startup procedure <program>. (492)
** CRC for <table> does not match CRC in <program>. Try recompiling. (1896)
Errors are encountered when running program
Program ran fine before schema changes were made
Can not recompile code as only runtime license is installed
Failover development system (another machine) running fine with new schema changes
Failover system has exact directory structure
CHANGE:
Recent schema changes were made to schema holder through "Update/Add Table Definitions" menu.
CAUSE:
If recent schema changes were made to SH, the existing code was compiled against older schema. Progress code can not run if code was compiled against a different schema infrastructure.
FIX:
Copy over schema holder and rcode from failover system to production system
1. Make a backup of all files on the production system
2. Make a backup (via probkup) of the schema holder on development system
3. Restore Progress bkup to production system
4. Copy over rcode from development into rcode directory into production