Question Online Field/Table Description Changes

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?
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
Is it true that changing the description of a table or field is not allowed while its database is in multi-user mode?
I just tried changing a table description and a field description online; it worked. (12.1, Linux)

What does your testing show?
 

KMoody

Member
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).
 

TomBascom

Curmudgeon
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

Member
If you mean "Add new objects on-line," then yes, I did have it checked.:

1574095637715.png

Where do I report bugs?
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
Where do I report bugs?
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.
 

Osborne

Active Member
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:


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)

Maybe changes to existing fields are not actually allowed on-line unless everyone is disconnected so you can obtain a schema lock.
 

Cringer

ProgressTalk.com Moderator
Staff member
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.
 
Top