Kbase P21910: Deployment process fails because of CRC error on 'Control' t
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/25/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Application has database table which contains 'Control' information
Deployment/Upgrade process reads the 'Control' table to determine current application/database version
The 'Control' table will now be modified (i.e. the CRC will change)
Deployment process now receives CRC errors and fails
CAUSE:
The 'Control' table was changed so the deployment process which used to simply do a FIND FIRST Control statement fails with a CRC error
FIX:
Modify the application code so that the following code is used to read the 'Control' table rather than a straight FIND statement:
DEFINE VARIABLE hQuery AS HANDLE NO-UNDO.
DEFINE VARIABLE hBuffer AS HANDLE NO-UNDO.
CREATE BUFFER hBuffer FOR TABLE 'Control'.
CREATE QUERY hQuery.
hQuery:SET-BUFFERS(hBuffer).
hQuery:QUERY-PREPARE("FOR EACH Control NO-LOCK").
hQuery:QUERY-OPEN().
hQuery:GET-FIRST().
... Code goes here to read data from the single record that exists in the table
hQuery:QUERY-CLOSE().
DELETE OBJECT hBuffer.
DELETE OBJECT hQuery.