Question Online Field/Table Description Changes

KMoody

KMoody

Member
Is it true that changing the description of a table or field is not allowed while its database is in multi-user mode? If so, I'd like to understand why. If users can change the format of existing fields online, then why can't they change descriptions?
 
KMoody said:
Is it true that changing the description of a table or field is not allowed while its database is in multi-user mode?
Click to expand...
I just tried changing a table description and a field description online; it worked. (12.1, Linux)

What does your testing show?
 
Sorry, I forgot to mention that we're using Progress 11.7.5.

I'm unable to make any changes online through the Data Dictionary while in multi-user mode. I am able to add fields and tables by loading an incremental df in Data Administration. However, I tried to change an existing field's description like this:

db_incr.df
Code: 
......

UPDATE FIELD "TUBECUT-REPORT-QTY" OF "WIP"
  DESCRIPTION "change descriptions."
  COLUMN-LABEL ?
 
  ......

That gave me this error:

Requested schema change not allowed on-line, aborting the change (15262).
 
Did you check the "online" checkbox when loading the .df?

If you did and it still failed then I suggest that you report it as a bug.
 
KMoody said:
Where do I report bugs?
Click to expand...
If you are a direct client, you would open a case with Tech Support; you'll need a Progress ID if you don't have one already.

If you are an indirect client (i.e. using an OpenEdge partner application), you would report the problem to the application partner and they would open a case on your behalf.
 
According to these articles it appears only new tables, new fields to existing tables or new indexes to existing tables can be added on-line:

Progress Customer Community

knowledgebase.progress.com knowledgebase.progress.com

Progress Customer Community

knowledgebase.progress.com knowledgebase.progress.com

If the .df to be applied contains any other actions besides the Schema Changes listed above, Progress will issue an error and all changes will be rolled back.
Requested schema change not allowed on-line, aborting the change (15262)
Click to expand...

Maybe changes to existing fields are not actually allowed on-line unless everyone is disconnected so you can obtain a schema lock.
 
There's no reason why they shouldn't be doable online, and Progress are moving towards making as much as possible an online operation. So if it's not a "bug", it's a missing feature, so they should be alerted all the same IMO.
 
You must log in or register to reply here.
Back
Top