Page Comparison

When working with Advanced Reporting, you may encounter the following issues:

...

This error occurs because of the mismatch of data set names with their corresponding Join Trees in the security file and domain. In the domain, the data sets are available under Display, Resources, Join Trees. 

To fix this issue, download and open the security file in your local computer. Compare the data set in the Join Trees between the security file and Resources pane. If the data sets are not matching with Join Trees, update the Join Trees in the security file to match with the Resources pane.

Follow these steps:

1. Click and download the security file custom_cloud_sm_security.xml from the Edit Domain, Optional Information, Security File to your local computer.
2. Click Edit with Domain Designer and access Domain Designer, Display tab. The Display tab opens with the list of Join Trees on the left pane under Resources.
3. Open the downloaded security file in a text editor such as WordPad.

4. Expand the Join Trees under Resources pane. Verify that the table names in all the Join Trees section and in the security file are same.
   For example, consider the following security file code:

   Code Block
   language xml
   <resourceAccessGrantList id="Tasks_FilterList" label="Tasks Filter List" resourceId="JoinTree_1"> <resourceAccessGrants> <resourceAccessGrant id="TaskSliceFilter"><principalExpression>(authentication.getPrincipal().getAttributes().any{ it.getAttrName() in ['nsd_slice']})</principalExpression> <filterExpression>(testProfileAttribute(dbo_VITPM_PROJECT_TASKS.slice,'nsd_slice'))</filterExpression> </resourceAccessGrant> <resourceAccessGrant id="TaskMemberFilter"> <principalExpression>(authentication.getPrincipal().getAttributes().any{it.getAttrName() in ['nsd_UserId']})</principalExpression> <filterExpression>((groovy('authentication.getPrincipal().getRoles().any{it.getRoleName()=="ROLE_CSM_ADMINISTRATOR"}') == 'true') or CHARINDEX(dbo_VITPM_PROJECT_TASKS.members,(groovy('authentication.getPrincipal().getAttributes().find{it.getAttrName()=="nsd_UserId"}.attrValue')))>=0)</filterExpression> </resourceAccessGrant> <resourceAccessGrant id="Task_OBSFilter"> <principalExpression> <![CDATA[authentication.getPrincipal().getAttributes().any{it.getAttrName() in ['nsd_OBSEnabled'] && it.getAttrValue() in ['True']}]]> </principalExpression> <filterExpression>(OBS_PRJ_TASKS.org_id in (dbo_VITPM_PROJECT_TASKS.org_id) and testProfileAttribute(OBS_PRJ_TASKS.user_id,'nsd_UserId'))</filterExpression> </resourceAccessGrant> </resourceAccessGrants> </resourceAccessGrantList>

   The resourceId specifies the Joint Tree name as JoinTree_1 and the filterExpression specifies the table name as dbo_VITPM_PROJECT_TASKS. Verify that the table name dbo_VITPM_PROJECT_TASKS matches the table name in JointTree_1 under Resources pane.

5. If the table names of the security file do not match with the Join Trees in the Resource pane, edit the security file accordingly.
   For example, consider the table name dbo_VITPM_PROJECT_TASKS is in the JoinTree_1 of the security file. In the Resources panel of the Display tab, the dbo_VITPM_PROJECT_TASKS table is available in JoinTree_2. To match the information, edit the security file and rename the resourceId value from JoinTree_1 to JoinTree_2.
   Change all the resourceId values in the security file, accordingly.  

6. Save your changes and close the security file.

7. Click Cancel to navigate back to the Edit Domain page.

8. In the Edit Domain page, click Change corresponding to the security file. Browse and select the security file from your local computer.

9. Click Submit. The old security file is replaced with the updated file and issue of invalid domain security file is resolved.

...