Kbase P125479: Unable to suppress message 2624 using NO-ERROR option for schema tables in OpenEdge 10.x
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/15/2007 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
SYMPTOM(s):
Unable to suppress message 2624 using NO-ERROR option for schema tables
Schema in use by <user> on <tty>. Wait or choose CANCEL to stop. (2624)
<file-name> in use by <user> on <tty>. Wait or choose CANCEL to stop. (2624)
Same code used to work on Progress 9.x or earlier
CHANGE:
Upgrade from Progress 9.x or earlier to OpenEdge 10.x
CAUSE:
This is an expected behavior.
This is a side-effect of adding support for online schema changes starting on OpenEdge 10.0A.
Any ABL program acquiring exclusive record locks in the _file, _index,_sequence or _field tables is assumed to be making an online schema change.
FIX:
Do not use exclusive-locks when using _file, _index,_sequence or _field table.