Kbase P22033: Schema changes not seen by SQL92 process fixed in 9.1D06
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/20/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1B
FACT(s) (Environment):
Progress 9.1C
FACT(s) (Environment):
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.