Error while retrieving & mapping user role?

[Former Member]

Hi All,

When I click OrgChart icon in the home page,

I get "An unknown error has occurred while processing the orgchart." error.

I have found the following from CDS.log file.

INFO: CommandProcessor.getDataSet : select CDSItem from CDSStorage where (CDSUserID='XXXXX\johndoe') and (CDSContext='CDSUserSettingsContext') and (CDSKey='CDSUserSettingsKey')

8/27/2009 1:50 PM: INFO: CommandProcessor.getDataSet : select SAP_USER_ID,SAP_USER_ID,PERSON_NUMBER,ROLE,EMPLOYEE_NAME from ROLES where ((Upper(SAP_USER_ID) is null) or (Upper(SAP_USER_ID)=Upper('')))

8/27/2009 1:50 PM: ERROR: RoleMapping_Default : MapRoles : Error while retrieving & mapping user role. Message:Object reference not set to an instance of an object.

8/27/2009 1:50 PM: ERROR: ApplicationConfiguration : getOrgChart : orgchart: does not exist.

8/27/2009 1:50 PM: WARNING: OrgChartAppProcessor : setupOrgchartApp : Orgchart () defined cannot be found in app resources.

How to resolve this error?

Thanks

Thruna Shanmuga

[Former Member]

Hello,

After we ran a data extraction recently, we have been getting the same error in our DEV environment.

ERROR: RoleMapping_Default : MapRoles : Error while retrieving & mapping user role. Message:Object reference not set to an instance of an object.

Can someone shed some light on how to start troubleshooting this problem?

Is this a problem with the SAP user we set up for Nakisa?

Thanks,

Jing

[lukemarson]

Hi JIng,

This error sometimes comes up if the user doesn't have an assigned role. It just means it cannot map the user's role to a role in the system. It is something that can, in this situation, be ignored. If you find a problem with user's roles not mapping as expected and you get this error then there is a configuration problem somewhere.

Best regards,

Luke

[lukemarson]

Hi Thruna,

The error isn't with the role mapping (the application will always work if it cna't map roles). The error is that it cannot find the or some configuration for the OrgChart. Please check your XML configuration in AppResources.xml.

Many thanks,

Luke

[Former Member]

Luke,

I copied the entire folder structure from PRD to DEV.

It was working fine in DEV until I changed the DB connections and the SAP Extract from ECC DEV to DEV DB.

I changed the DB connection details in AppResources.xml file also.

I checked the AppResources.xml for OrgChart but there are so many tags, don't know which is need to be corrected.

I found the following from CDS.log.

Earlier:

-

---

select SAP_USER_ID,SAP_USER_ID,PERSON_NUMBER,ROLE,EMPLOYEE_NAME from ROLES where (Upper(SAP_USER_ID)=Upper('P00012345'))

In the above line it was able to get my employee id.

current:

-

---

select SAP_USER_ID,SAP_USER_ID,PERSON_NUMBER,ROLE,EMPLOYEE_NAME from ROLES where ((Upper(SAP_USER_ID) is null) or (Upper(SAP_USER_ID)=Upper('')))

It is not able to get my employee ID.

That is the reason I'm getting the error.

Thanks

Thruna Shanmuga

Edited by: Thruna Shanmuga on Aug 28, 2009 5:21 PM

[lukemarson]

Hi Thruna,

Apart from changing the connection strings for SAP and the DB in AppResources.xml, did you change anything else when you moved to PRD?

Cheers,

Luke