Kbase P97454: Adding a table with database online gives database in use error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/11/2008 |
|
Status: Verified
SYMPTOM(s):
Adding a table with database online gives error
Database is in use by batch
Not using 4GL client session parameter session:SCHEMA-CHANGE
FACT(s) (Environment):
OpenEdge 10.1x
All Supported Operating Systems
CAUSE:
The table is not being added using the new online option. Starting in OE 10.1A, Progress has relaxed the requirement for exclusive access to a database by allowing for the addition of sequences, 4GL tables and any fields, indexes, and database triggers associated with a new table as long as they are added in the same transaction as the table.
FIX:
There are two ways to address the error:
1. Load a definition file (.df) in the Data Dictionary and choose the option "Add new objects on-line"
2. Use a 4GL client session parameter named session:SCHEMA-CHANGE. This 4GL client session parameter relaxes the requirement for exclusive access to a database in order to add new tables, fields, indexes, sequences, and database triggers for a new application. The session attribute should be set to "NEW OBJECTS" to activate it, or the empty string "" or the unknown value to deactivate it..