ORA-00001 unique constraint violated when creating a project from template that has custom lookup with default value

Document ID : KB000020393
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When a project is created from template and the template has custom attribute with data type multi valued lookup with a default value, the user gets error "ERROR 500 - Internal Server Error. the server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator". The lookup is a custom lookup.


Steps to Recreate:

  1. Create a custom lookup, source static list, values (region1, region2, region3, none)
  2. In Project object create a custom attribute which has data type as Multi Value Lookup String and select lookup created in step 1.

    Default the attribute to some value (say : None).

  3. Add it to Project View
  4. On the application side create a project.
  5. The above attribute defaults to None.
  6. Make the Project as template.
  7. Create New Project from the above template.
  8. When clicked save on the Create page system gives

    Error Message : Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.

  9. Modify the template removing the default value of the custom attribute created in step 1.
  10. Create New Project from the template again. This time you don't get the error 500

Expected Result: New project created from template should be saved without receiving any error

Actual Result:Received error 500 when new project created from template is saved. The log error shows ORA-00001.

Solution:

Workaround:
Work around has been done by temporarily removing the default value on Multi Value Lookup

STATUS/RESLUTION:

This is documented as CLRT-68730
Resolved in Clarity 13.1 Generic Patch. Reference TEC581256
Resolved in Clarity 13.2