The objects in PowerDesigner16 are invalid, and there is no solution to the extension attribute problem.

The object in PowerDesigner16 is invalid and no extended attributes are allowed

message 15135, level 16, state 1, process sp_addextendedproperty, line 37The object is invalid. ‘XXXXXXX’ does not allow extended attributes, or the object does not exist.

put

execute sp_addextendedproperty’MS_Description’,’mvc’,’user’,’Commons’,’table’,’Test’,’column’,’TestColumn’

go

The user in it can be replaced with schema.

required Set it up, the value in Database >> Edit Current DBMS >> Script >> Object >> Column >> ColumnComment should be changed from user to schema.

Note : If you can’t save it, please re-open Powerdesigner with administrator privileges, and then you can save it.

The object in PowerDesigner16 is invalid and no extended attributes are allowed

Message 15135, level 16, state 1, process sp_addextendedproperty, line 37The object is invalid. ‘XXXXXXX’ does not allow extended attributes, or the object does not exist.

put

execute sp_addextendedproperty’MS_Description’,’mvc’,’user’,’Commons’,’table’,’Test’,’column’,’TestColumn’

go

The user in it can be replaced with schema.

required Set it up, the value in Database >> Edit Current DBMS >> Script >> Object >> Column >> ColumnComment should be changed from user to schema.

Note : If you can’t save it, please re-open Powerdesigner with administrator privileges, and then you can save it.

Leave a Comment

Your email address will not be published.