Kbase P6043: Error Disconnect from server; database is being shutdown. (2659)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/14/2008 |
|
Status: Verified
SYMPTOM(s):
Error Disconnect from server; database is being shutdown. (2659)
Does not occur on character clients
Running this code:
def var xx as int.
message "test" view-as alert-box.
loop:
FOR EACH sku WHERE
sku.big-string CONTAINS "ash*"
NO-LOCK:
message sku.sku sku.sku-desc view-as alert-box.
quit.
END.
Code fails when CONTAINS "ash*" -- >> wild card, if the wild card is removed it works.
Error in database log file:Unable to open or create <filename>, error <number>. (354)
FACT(s) (Environment):
Worked before upgraded
Windows 95
Windows XP
Windows 2000
Progress 8.3x
CHANGE:
Upgraded to new software and a new database schema.
CAUSE:
CONTAINS does honor the "*" with the condition that it
be at the END of the string, not at the beginning or middle.
So
CONTAINS "ABC"
is not equivalent to
CONTAINS "ABC*"
since the first one would return records where somefield had
a complete word "ABC", but the second one would return also
"ABCD" "ABCXYX" and anything else that begins with ABC.
FIX:
Run index rebuild.