search cancel

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 Custom Investment Type (CIT), 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 a CIT
2. Create an attribute of type String
3. Measure how long it takes to complete.

Actual Results:  It can take 3 to 5 minutes to complete. During this time, none of the CITs can be accessed.
Expected Results: 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.

Engineering states there are several performance improvements surround CIT maintenance and are resolved in 16.0.2.

The database copy is needed for direct review if not upgraded to 16.0.2.

 

Attachments