It's all about the answers!

Ask a question

Adding enumerations in database table

Milan Krivic (9808164136) | asked Mar 28 '13, 4:56 a.m.

when we add some custom enumerations in project area, we can choose whether it will be stored in PA process or database.
If we choose database, these enumerations are not visible in PA process configuration source, right?
So, there are stored in RICALM.REQUEST_ENUMERATION table, right?

My question is next:
Can I add more literals to this enumeration through this table, not via Project Configuration, so these new literal can be visible in Project Configuration or on work item which use this enumeration?


One answer

permanent link
Ralph Schoon (60.7k33643) | answered Mar 28 '13, 5:18 a.m.
edited Mar 28 '13, 7:46 a.m.
Hi Milan,

you should not attempt to modify the database directly at all, as far as I know. Unless support tells you so, the DB should be off limits to direct modification, unless you want to potentially get yourself into serious trouble.

If you want to modify things use the UI and the API if necessary. The UI and API go through the applications persistence layer that knows how to manage things and in which (potentially multiple) locations changes need to be made to be consistent. 

With respect to the DB backed Enumerations, please be aware that they currently don't take part in process sharing and unless this is addressed in future versions, you need to consider this shortcoming.

Ralph Schoon commented Mar 28 '13, 5:47 a.m.

There are some DB maintenance activities that might be exceptions to the rule not to modify the database.These don't modify the data in the database but metadata that is used by the DBMS to access and organize the database more efficient. Again, be careful, because some actions might have also a bad effect on performance.

Another exception is of course backup and restore. Please, again, be aware that these operations need to be considered carefully too. For example with respect to backing up a database that is in usage. Look into the and the support pages for more information on this.

Your answer

Register or to post your answer.