It's all about the answers!

Ask a question

Error creating Database stored enumeration

Simo Suurla (681424) | asked Feb 19 '15, 4:22 a.m.
 I'm getting error creating enumeration stored in database, cant save process configuration:

An error occurred during "Save Project Area".

An error occurred while updating persisted enumerations.

Ralph Schoon commented Feb 19 '15, 5:31 a.m.

If you don't provide more information about the environment (versions) the error (e.g. click that link or look into the client/server logs), I don't see how we can help.

If you use process sharing, you can't use DB backed enumerations.
If you want to change DB backed enumerations, you require a role that has sufficient permissions, although I would have expected a different error. 

Simo Suurla commented Feb 19 '15, 5:51 a.m. | edited Feb 19 '15, 5:53 a.m.

Hi, thank you. Yes we use process sharing. And we are looking for functionality to use customized enumerations on project areas using shared process. Because now If we change one enumerations content it will disconnect all enumerations from process. Would like to customize only one enumeration list. And keep all other lists sync with shared process.

But as you told this database option seems not to be resolution.

Accepted answer

permanent link
Ralph Schoon (62.7k33643) | answered Feb 19 '15, 6:03 a.m.
Hi, unfortunately, as far as I know process sharing is based on the process XML today. There is a disconnect with DB backed enumerations. There are several work items around this and as far as I can tell, this is not yet addressed.

Here a work item requesting what you try:

I don't think you can use this approach today. I would recommend to either vote up the above request or create a new one.

What is currently working ( and I have not tested this with enumerations or otherwise at all) is described here:
Simo Suurla selected this answer as the correct answer

Your answer

Register or to post your answer.