Kbase P42606: Schema changes not seen by SQL92 process
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1B
Progress 9.1C
Progress 9.1D
SYMPTOM(s):
SQL-WIDTH changes performed online are being ignored.
Increased SQL-WIDTH of field after receiving 7864 error
Column <column> in table <table> has value exceeding it max length or precision (7864)
CAUSE:
Bug# 20010727-027
CAUSE:
Any actual database schema changes performed are not reflected in the schema cache of any existing running _sqlsrv2 server process. There is no reread of the schema information for _sqlsrv2 processes. The mechanism to detect changed schema information is not working in case of SQL WIDTH change.
FIX:
Upgrade to 9.1D06 or later.
To workaround the problem perform the following:
Shutdown and restart the database. This ensures that all _sqlsrv2 processes receive updated schema information. Otherwise, new users connecting to existing _sqlsrv2 process will not see the changes, while those connections that get a new _sqlsrv2 process will.