Clarity: Specific Navigation between User-defined Portlet and User-defined Resource Subpage generates Error 500

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

Description:

Specific Navigation between User-defined Portlet and User-defined Resource Subpage generates Error 500

The Error 500 can be generated when following a specific sequence set of steps using a simple user-defined portlet and user-defined subpage on the Resource Object.

If the configuration and navigation steps are not followed precisely, the issue is not reproduced.

It is essential to reproduce the issue to have more than one page on the grid portlet and to have a user-defined subpage on the Resource Object

Steps to Set up Configuration of User-Defined Portlet and Subpage:

  1. Login as a Clarity Administrator

  2. Admin Tool > Queries > click 'New' button>

    Create a new portlet that generates a list of Project Managers and the number of Investments

    Figure 1

    Figure 2

    NSQL Statement:
    SELECT @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:MR.ID:MGRID@,     @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:MR.FULL_NAME:MANAGER@,     @SELECT:METRIC:USER_DEF:IMPLIED:COUNT(*):PROJECT_COUNT:AGG@FROM INV_INVESTMENTS I,     SRM_RESOURCES MRWHERE I.MANAGER_ID = MR.USER_IDAND @FILTER@GROUP BY MR.ID,     MR.FULL_NAMEHAVING @HAVING_FILTER@
    Figure 3

    Set Configurable Actions
    Action Source = Resource
    Object Primary Key Attribute = mgrid:bigDecimal

    Figure 4


    Create a new Link
    Link Name = Manager Link
    Link ID = manager_link
    Action = Resource Properties (projmgr.editResource)

    Figure 5

    Figure 6

    Figure 7

    Figure 8

    Figure 9

    Figure 10

  3. Studio: Objects > Resource Object > Views
    Resource Labor Properties [Layout: Edit]
    Click 'Create Subpages' button
    create a new subpage 'mySubpage' > click 'Submit' button
    Click on the name of the newly created subpage

    Figure 11


    Click 'Create Sections' button
    create a section for the subpage - 'Section1' > click 'Submit' button
    Click on the 'properties' icon for the newly created section

    Figure 12

    | Add some fields to the page layout > click 'Submit' button

    Figure 13

  4. Main Application > Overview Page > [Manage My Tabs] > General Tab > Content
    click 'Add' button > Select the portlet created in Step #2 > click 'Add' button
    Click 'Exit' button > Click 'Back' button to return to Overview page

    Figure 14

Note: If the results of the portlet does not generate more than one page, create more investments with different resources. One row is generated for each resource that is listed as the manager on a project.

Once the configuration is complete and the portlet generates more than one page, now you can use the steps below to replicate the issue.

Steps to Reproduce:

  1. From the user-defined portlet, navigate to page 2

    Click on the Manager Name Link for one of the resources (ie. User,Resource8)

    (it does not matter which resource)

    Click 'mySubpage' link

    Click 'Cancel' button (returns to Overview page where user-defined portlet is placed; on page 1 of the user-defined portlet)

    Figure 15

    Figure 16

    Figure 17

  2. From the user-defined portlet, navigate to page 2

    Click on the Manager Name Link for one of the resources (ie. User,Resource6)

    (it does not matter which resource - it could be the same resource or a different resource)

    Click 'mySubpage' link

    Click 'Cancel' button (returns to Overview page where user-defined portlet is placed; on page 1 of the user-defined portlet)

    Figure 18

    Figure 19

    Figure 20

    Figure 21

  3. From the user-defined portlet, navigate to page 2

    Click on the Manager Name Link for one of the resources (ie. User,Resource7)

    (it does not matter which resource - it could be the same resource or a different resource)

    Click 'mySubpage' link

    RED 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.

    Figure 22

    Figure 23

    Figure 24

    Figure 25

  4. Log out / Log in again

  5. Repeat Steps 1-3 using the 'Submit' button instead of 'Cancel' button

Expected Result:

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

Solution:

WORKAROUND:

None. The customer is using this portlet to update a list of resources and having to work around this issue causes delays in using the application.

STATUS/RESOLUTION:

Resolved in Clarity 12.1.3

Keywords: CLARITYKB, CLRT-63248, clarity8open, clarity12resolved, clarity1213resolved.