ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Slow Performance When Adding Attributes on Custom Investment

book

Article ID: 241446

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

During the creation of an attribute, e.g. String attribute on a CIT custom investment, it takes at least 3 to 5 minutes to create the attribute.
During this time the whole object is not accessible due to the time it takes to complete the background operations.

STEPS TO REPRODUCE:
1. Create CIT
2. Create an attribute of type String
3. Measure how long it takes to complete.

Actual:  It can take 3 to 5 minutes to complete. During this time, none of the CITs can be accessed.
Expected: It should take a reasonable amount of time, e.g. 10 seconds.

A. Trace excerpt:

<INFO date="2022-05-06 14:39:19,230" user="clarity:trace" session="32332049__A44759F8-AC06-443D-A8A8-B6478BCEC3BE" action="odf.addObjectDefinitionAttribute" thread="http-nio-80-exec-348" category="trace.server.selective.user">
  <webRequest id="odf.addObjectDefinitionAttribute" elapsed="159,828.000" elapsedAfterLastNode="1.000" start="2:36:39:402" finish="2:39:19:230" memoryDelta="165789k">
    <persistence id="union.getSessionProp_set" elapsed="13.000" elapsedSincePriorNode="1.000" elapsedAfterLastNode="0.000" start="2:36:39:403" finish="2:36:39:416" memoryDelta="603k">
      <statementSet id="union.getSessionProp_set" location="unionPMD.xml" elapsedSincePriorNode="0.000" start="2:36:39:403"/>
      <statement id="union.getSessionProp_stmt" location="unionPMD.xml" elapsed="8.000" elapsedSincePriorNode="1,651,847,799,409.000" elapsedAfterLastNode="6.000" start="2:36:39:408" finish="2:36:39:416" memoryDelta="603k">

B. Parser showing actions:

C. Trace showing actions:

Line 33481:                   <![CDATA[INSERT INTO TEMP_ODF_OBJ_COMPS (COMPONENT_CODE) VALUES(?)
 Line 33574:                   <![CDATA[INSERT INTO TEMP_ODF_OBJ_COMPS (COMPONENT_CODE) VALUES(?)
 Line 35395:           <![CDATA[INSERT INTO CMN_ACTIONS
 Line 35441:           <![CDATA[INSERT INTO cmn_menu_items
 Line 35497:           <![CDATA[insert into cmn_action_params
 Line 35521:           <![CDATA[insert into cmn_action_params
 Line 35545:           <![CDATA[insert into cmn_action_params
 Line 35569:           <![CDATA[insert into cmn_action_params
 Line 35593:           <![CDATA[insert into cmn_action_params
 Line 35617:           <![CDATA[insert into cmn_action_params
 Line 35641:           <![CDATA[insert into cmn_action_params
 Line 35743:           <![CDATA[INSERT INTO CMN_ACTIONS
 Line 35789:           <![CDATA[INSERT INTO cmn_menu_items
 Line 35845:           <![CDATA[insert into cmn_action_params
 Line 35869:           <![CDATA[insert into cmn_action_params
 Line 35893:           <![CDATA[insert into cmn_action_params
 Line 35917:           <![CDATA[insert into cmn_action_params
 Line 35941:           <![CDATA[insert into cmn_action_params
 Line 35965:           <![CDATA[insert into cmn_action_params
 Line 35989:           <![CDATA[insert into cmn_action_params
 Line 40707:                   <![CDATA[INSERT INTO CMN_CONFIG( NAME, VALUE, ADDRESS, CREATED_DATE, LAST_UPDATED_DATE  )
 Line 40737:                   <![CDATA[INSERT INTO CMN_CONFIG( NAME, VALUE, ADDRESS, CREATED_DATE, LAST_UPDATED_DATE  )
 Line 40767:                   <![CDATA[INSERT INTO CMN_CONFIG( NAME, VALUE, ADDRESS, CREATED_DATE, LAST_UPDATED_DATE  )
 Line 40820:                   <![CDATA[INSERT INTO CMN_CONFIG( NAME, VALUE, ADDRESS, CREATED_DATE, LAST_UPDATED_DATE  )
 Line 40850:                   <![CDATA[INSERT INTO CMN_CONFIG( NAME, VALUE, ADDRESS, CREATED_DATE, LAST_UPDATED_DATE  )
 Line 40880:                   <![CDATA[INSERT INTO CMN_CONFIG( NAME, VALUE, ADDRESS, CREATED_DATE, LAST_UPDATED_DATE  )
 Line 41107:                   <![CDATA[INSERT INTO TEMP_ODF_OBJ_COMPS (COMPONENT_CODE) VALUES(?)
 Line 41200:                   <![CDATA[INSERT INTO TEMP_ODF_OBJ_COMPS (COMPONENT_CODE) VALUES(?)
 Line 45347:                   <![CDATA[INSERT INTO ODF_ATTR_METADATA(ID, ATTRIBUTE_CODE, OBJECT_CODE, INHERITED_FROM, OBJECT_ID, IS_CUSTOM, IS_SECURE,DATABASE_TABLE,DATABASE_COLUMN, ATTRIBUTE_API_ALIAS, CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY)
 Line 45368:                   <![CDATA[insert into ODF_CA_ODF_ATTR_METADATA
 Line 46996:                   <![CDATA[INSERT INTO ODF_ATTR_METADATA(ID, ATTRIBUTE_CODE, OBJECT_CODE, INHERITED_FROM, OBJECT_ID, IS_CUSTOM, IS_SECURE,DATABASE_TABLE,DATABASE_COLUMN, ATTRIBUTE_API_ALIAS, CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY)
 Line 47017:                   <![CDATA[insert into ODF_CA_ODF_ATTR_METADATA

 

 

Environment

Release : 16.0.1

 

Resolution

This is reported as DE65063 and will be under Engineering review.

Attachments