'Custom Objects' Menu Section has been removed - new custom objects don't get automatically added to Menu

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

Description:

The application allows you to remove the "Custom Objects" Menu Section. If the "Custom Objects" Menu Section has been removed, you cannot create a Menu Link for new custom objects.

NOTE: although the administrator deleted the "Custom Objects" Menu Section through the application, the section has not really been deleted, only hidden. See the WORKAROUND section for more information.

Steps to Reproduce:

  1. If your application already has a "Custom Objects" Menu Section, Move all the links for the Custom Objects Menu Section to another section.

    Administration, Menu Manager, Application Menu
    Click 'Add' button
    Create a new Section 'New Custom Objects' Section
    Click 'Submit' button
    Select/check all Menu Links under the existing 'Custom Objects' Section
    Click 'Move' button
    Move the links to the 'New Custom Objects' Section
    Click 'Submit' button

  2. Remove the "Custom Objects" Menu Section
    Select/check 'Custom Objects' Menu Section
    Click 'Delete' button

  3. Create a new Object = "My Object"
    Administration, Studio: Objects, click 'New' button

    Enter Object Name and ID, click 'Save and Exit' button

  4. Navigate to Main Application and view left Navigation Menu

    -or go to -

    Administration, Menu Manager, Application Menu

Expected Result: The creation of a new custom object "My Object", should automatically create a Menu Link and re-create the "Custom Objects" Menu Section (since it has been removed).
Actual Result: The "My Object" menu link is not automatically created (anywhere on the menu) and the "Custom Objects" Menu Section is not automatically re-created.

 

Solution:

WORKAROUND:

Please contact CA Technical Support for a solution and refer to CLRT-8979.
 
If the administrator tries to add the "My Object" Menu Link it is not possible, because the page does not appear in the browse selection window.
If the administrator tries to add the "Custom Objects" Menu Section with an "ID = odf.custom.customSection" the following error is generated... NPT-0023: Section ID must be unique.

SCENARIO #1:  The "Custom Objects" Menu Section is not really deleted; it is hidden....

Find out the internal ID of this section

SELECT a.id, action_code as section_code, a.is_system, c.name, c.description
FROM cmn_actions a, cmn_captions_nls c
WHERE a.action_code = 'odf.custom.customSection'
AND a.id = c.pk_id
AND c.table_name = 'CMN_ACTIONS'
AND c.language_code = 'en'

Contact CA Technical Support for details on how to update the affected data and refer to CLRT-8979.

 

SCENARIO #2:  The records for the "Custom Objects" Menu Section are deleted in one table and there are orphaned records in the 'actions' table? 

  1. We ran below query and it returned no result:
    SELECT a.id, action_code as section_code, a.is_system, c.name, c.description
    FROM cmn_actions a, cmn_captions_nls c WHERE a.action_code ='odf.custom.customSection'
    AND a.id = c.pk_id
    AND c.table_name = 'CMN_ACTIONS'
    AND c.language_code = 'en'

    ;
  2. Checked in CMN_ACTIONS table, there was an entry for action_code ='odf.custom.customSection' but no entry found in CMN_CAPTIONS_NLS table for respective CMN_ACTIONS.ID value
    SELECT * FROM CMN_ACTIONS WHERE ACTION_CODE = 'odf.custom.customSection'
    ;
    SELECT * FROM CMN_CAPTIONS_NLS
    WHERE TABLE_NAME = 'CMN_ACTIONS'
    AND PK_ID = (SELECT ID FROM CMN_ACTIONS WHERE ACTION_CODE = 'odf.custom.customSection')
    ;
  3. Tried to create "Custom Objects" Menu Section with an ID =odf.custom.customSection resulted in 'System Error'
  4. Contact CA Technical Support for details to update the affected data - reference CLRT-8979  
  5. Go to Administration > Menu Manager > Create "Custom Objects" Menu Section with an ID =odf.custom.customSection
  6. Existing Custom Object Menu links and creating a new custom object in Studio will now show in the application menu.

  

STATUS/RESOLUTION:

CLRT-8979 : Reviewed and closed with no plans to fix. If issue persists in current, supported release, please open a new case for investigation.

For more details please review the Customer Reported Defect Resolution Policy for Clarity.