Unable to import file from Backend in SAP Virsa AE 5.2

[Former Member]

hi,

currently we are having AE 5.2 with SP11. when we go to Configuration tab -> Role -> Import role and give the role name which is in the backend and click on Import role, we are getting an error as " Action Failed".

the role is existing in the backend. all the other roles are getting imported except for this role. Also we have tired the template Role file and have given the details and uploaded the file. Even this didnt work out.

any help on this will be really great.

thanks in advance.

Amith

[Former Member]

Hi Amith,

Did you check everything Harleen recommended? It seems it is throwing error around locale which means language.

Please don't open different threads for same issue.

Regards,

Alpesh

[Former Member]

Hi Amith ,

I am aware of this issue . Two many customers reported it , I certified this as bug in SP08 when i was in SAP .

Please follow my recommendations as given earlier .

@alpesh ,

I am jasmine ( not harleen )

Take care

Jasmine

[Former Member]

Hi Jasmine,

Thanks for the reply.

1)The language is English in both the systems.

2)The profile for the role does exist in SAP system. The profile name is "T-RD773627".

3)The role does exist in the system. I have tried by selecting the overwrite option while importing but have the same error.

4)When I try to delete the role by Searching in the Configuration-> Roles->search role, I get the same error as "Action Failed".

5)The logs i have pasted are the logs from the system after i have tried to import the role by overwriting.

Regards

Amith

[former_member366047]

Amith-

That issue has been addressed in AE SP11 Patch 1.

Ankur

SAP GRC RIG

[Former Member]

Hi Ankur,

Thanks for your response.

We already have SP11 Patch 1 in our system.

Regards

Amith

[Former Member]

Hi Amith ,

The role is in english , was it created in english ? Can you please try to open the role in edit mode and check to see if you are allowed to modify , you would be allowed if the role is created in english else it wont .

secondly , Were the other roles also have same naming convention ?

Thanks

Jasmine

[Former Member]

Hi Jasmine,

Thanks for you updates.

The language of the role is English and it has been created in English. The error is coming up with the roles with only one particular Role owner.

We have connectivity of Access Enforcer to the User data source using a LDAP connection, which when we test for is showing as Connection succesful.

But when we try to import the roles or try to select the roles assigned to this Role owner there is an error as "Action Failed".

Can you please help me out on this. I am attaching the log where this particular role owner is trying to approve a request and which he is not able to open.

thanks in Advance,

Amith

2009-03-18 08:02:08,792 [SAPEngine_Application_Thread[impl:3]_28] ERROR Conflict while approving request when compared with the database

com.virsa.ae.workflow.InvalidTransactionException: Other approver approved this request, please get the details details of this request

at com.virsa.ae.accessrequests.bo.RequestBO.approveRequest(RequestBO.java:5298)

at com.virsa.ae.accessrequests.actions.RequestViewAction.confirmRequestApproval(RequestViewAction.java:801)

at com.virsa.ae.accessrequests.actions.RequestViewAction.execute(RequestViewAction.java:88)

at com.virsa.ae.commons.utils.framework.NavigationEngine.execute(NavigationEngine.java:256)

at com.virsa.ae.commons.utils.framework.servlet.AEFrameworkServlet.service(AEFrameworkServlet.java:423)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:387)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:365)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:944)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:266)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:160)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

[Former Member]

Hi Amith ,

Kindly check the following :

1. Language of role in which role was created in pfcg is same as default language of AE . if these languages are different , then set the language of AE as the language in which you have created the role in backend .

( For Roles created in Chinese this was BUG uptil SP10 ) .

2. Is this Role generated in SAP system . Does a profile exist for this one .

3. Does this role already exists in AE , if so then you need to import with selecting overwrite existing checkbox while importing .

4.Make sure the Role with similar name does nt exist in AE , if so you would have to delete that one and import this new one if you are not using it ,

5.Check in the AE error logs if there is any error for duplicate key or language or paste the logs here for review .

Thanks

Jasmine

[Former Member]

Amith,

Could this one role have some definitions such as "fucntional area" that are not defined to AE?

You may want to check that the role and all the values you have defined in the template are valid and the ones that are required to be defined in AE are also correctly defined

As Alpesh indicated, if you post the values and the error it could help in identifying the problem. I think you can obtain the error by reviewing the system log

Jerry Synoga

Ryerson, Inc.

[Former Member]

Amit,

Please post the logs here. I don't understand why only one role would not be imported from backend system.

Regards,

Alpesh

[Former Member]

Hi Alpesh,

I am trying to import role "ZF:M_IO_INT_INV_RECORD_ABC" from PRD 095 system. Here is the log.

Thanks in Advance.

Regards

Amith

__________________

2009-03-03 07:41:20,263 [SAPEngine_Application_Thread[impl:3]_24] ERROR LocaleUtil.java: Locale Object:

2009-03-03 07:41:35,975 [SAPEngine_Application_Thread[impl:3]_18] ERROR java.util.NoSuchElementException

java.util.NoSuchElementException

at java.util.StringTokenizer.nextToken(StringTokenizer.java:259)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getManagerDetailsByLDAPURL(LDAPSearchUser.java:883)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUserByDN(LDAPSearchUser.java:256)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.setManagerDetails(LDAPSearchUser.java:786)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUsers(LDAPSearchUser.java:636)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUserById(LDAPSearchUser.java:760)

at com.virsa.ae.search.bo.SearchUserBO.getUserById(SearchUserBO.java:192)

at com.virsa.ae.service.cache.AECacheUtil.getUser(AECacheUtil.java:321)

at com.virsa.ae.service.cache.AECacheUtil.getUserFullName(AECacheUtil.java:220)

at com.virsa.ae.dao.sqlj.RoleDAO.findApproversByRoleProfName(RoleDAO.sqlj:51)

at com.virsa.ae.dao.sqlj.RoleDAO.findRoleDetailsByName(RoleDAO.sqlj:211)

at com.virsa.ae.configuration.bo.ImportRolesBO.upsert(ImportRolesBO.java:557)

at com.virsa.ae.configuration.bo.ImportRolesBO.importFromSAPSystem(ImportRolesBO.java:167)

at com.virsa.ae.configuration.bo.ImportRolesBO.importFromSystem(ImportRolesBO.java:99)

at com.virsa.ae.configuration.actions.ImportRolesAction.importRoles(ImportRolesAction.java:189)

at com.virsa.ae.configuration.actions.ImportRolesAction.execute(ImportRolesAction.java:61)

at com.virsa.ae.commons.utils.framework.NavigationEngine.execute(NavigationEngine.java:256)

at com.virsa.ae.commons.utils.framework.servlet.AEFrameworkServlet.service(AEFrameworkServlet.java:423)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:387)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:365)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:944)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:266)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:160)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

2009-03-03 07:41:35,979 [SAPEngine_Application_Thread[impl:3]_18] ERROR com.virsa.ae.configuration.ConfigurationException

com.virsa.ae.configuration.ConfigurationException

at com.virsa.ae.configuration.bo.ImportRolesBO.upsert(ImportRolesBO.java:723)

at com.virsa.ae.configuration.bo.ImportRolesBO.importFromSAPSystem(ImportRolesBO.java:167)

at com.virsa.ae.configuration.bo.ImportRolesBO.importFromSystem(ImportRolesBO.java:99)

at com.virsa.ae.configuration.actions.ImportRolesAction.importRoles(ImportRolesAction.java:189)

at com.virsa.ae.configuration.actions.ImportRolesAction.execute(ImportRolesAction.java:61)

at com.virsa.ae.commons.utils.framework.NavigationEngine.execute(NavigationEngine.java:256)

at com.virsa.ae.commons.utils.framework.servlet.AEFrameworkServlet.service(AEFrameworkServlet.java:423)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:387)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:365)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:944)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:266)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:160)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

Caused by: java.util.NoSuchElementException

at java.util.StringTokenizer.nextToken(StringTokenizer.java:259)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getManagerDetailsByLDAPURL(LDAPSearchUser.java:883)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUserByDN(LDAPSearchUser.java:256)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.setManagerDetails(LDAPSearchUser.java:786)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUsers(LDAPSearchUser.java:636)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUserById(LDAPSearchUser.java:760)

at com.virsa.ae.search.bo.SearchUserBO.getUserById(SearchUserBO.java:192)

at com.virsa.ae.service.cache.AECacheUtil.getUser(AECacheUtil.java:321)

at com.virsa.ae.service.cache.AECacheUtil.getUserFullName(AECacheUtil.java:220)

at com.virsa.ae.dao.sqlj.RoleDAO.findApproversByRoleProfName(RoleDAO.sqlj:51)

at com.virsa.ae.dao.sqlj.RoleDAO.findRoleDetailsByName(RoleDAO.sqlj:211)

at com.virsa.ae.configuration.bo.ImportRolesBO.upsert(ImportRolesBO.java:557)

... 21 more

2009-03-03 07:41:35,982 [SAPEngine_Application_Thread[impl:3]_18] ERROR com.virsa.ae.configuration.ConfigurationException

com.virsa.ae.configuration.ConfigurationException

at com.virsa.ae.configuration.bo.ImportRolesBO.upsert(ImportRolesBO.java:744)

at com.virsa.ae.configuration.bo.ImportRolesBO.importFromSAPSystem(ImportRolesBO.java:167)

at com.virsa.ae.configuration.bo.ImportRolesBO.importFromSystem(ImportRolesBO.java:99)

at com.virsa.ae.configuration.actions.ImportRolesAction.importRoles(ImportRolesAction.java:189)

at com.virsa.ae.configuration.actions.ImportRolesAction.execute(ImportRolesAction.java:61)

at com.virsa.ae.commons.utils.framework.NavigationEngine.execute(NavigationEngine.java:256)

at com.virsa.ae.commons.utils.framework.servlet.AEFrameworkServlet.service(AEFrameworkServlet.java:423)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:387)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:365)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:944)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:266)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:160)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

Caused by: com.virsa.ae.configuration.ConfigurationException

at com.virsa.ae.configuration.bo.ImportRolesBO.upsert(ImportRolesBO.java:723)

... 21 more

Caused by: java.util.NoSuchElementException

at java.util.StringTokenizer.nextToken(StringTokenizer.java:259)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getManagerDetailsByLDAPURL(LDAPSearchUser.java:883)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUserByDN(LDAPSearchUser.java:256)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.setManagerDetails(LDAPSearchUser.java:786)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUsers(LDAPSearchUser.java:636)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUserById(LDAPSearchUser.java:760)

at com.virsa.ae.search.bo.SearchUserBO.getUserById(SearchUserBO.java:192)

at com.virsa.ae.service.cache.AECacheUtil.getUser(AECacheUtil.java:321)

at com.virsa.ae.service.cache.AECacheUtil.getUserFullName(AECacheUtil.java:220)

at com.virsa.ae.dao.sqlj.RoleDAO.findApproversByRoleProfName(RoleDAO.sqlj:51)

at com.virsa.ae.dao.sqlj.RoleDAO.findRoleDetailsByName(RoleDAO.sqlj:211)

at com.virsa.ae.configuration.bo.ImportRolesBO.upsert(ImportRolesBO.java:557)

... 21 more

2009-03-03 07:41:35,983 [SAPEngine_Application_Thread[impl:3]_18] ERROR com.virsa.ae.configuration.ConfigurationException

com.virsa.ae.configuration.ConfigurationException

at com.virsa.ae.configuration.bo.ImportRolesBO.importFromSAPSystem(ImportRolesBO.java:171)

at com.virsa.ae.configuration.bo.ImportRolesBO.importFromSystem(ImportRolesBO.java:99)

at com.virsa.ae.configuration.actions.ImportRolesAction.importRoles(ImportRolesAction.java:189)

at com.virsa.ae.configuration.actions.ImportRolesAction.execute(ImportRolesAction.java:61)

at com.virsa.ae.commons.utils.framework.NavigationEngine.execute(NavigationEngine.java:256)

at com.virsa.ae.commons.utils.framework.servlet.AEFrameworkServlet.service(AEFrameworkServlet.java:423)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:387)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:365)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:944)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:266)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:160)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

Caused by: com.virsa.ae.configuration.ConfigurationException

at com.virsa.ae.configuration.bo.ImportRolesBO.upsert(ImportRolesBO.java:744)

at com.virsa.ae.configuration.bo.ImportRolesBO.importFromSAPSystem(ImportRolesBO.java:167)

... 20 more

Caused by: com.virsa.ae.configuration.ConfigurationException

at com.virsa.ae.configuration.bo.ImportRolesBO.upsert(ImportRolesBO.java:723)

... 21 more

Caused by: java.util.NoSuchElementException

at java.util.StringTokenizer.nextToken(StringTokenizer.java:259)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getManagerDetailsByLDAPURL(LDAPSearchUser.java:883)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUserByDN(LDAPSearchUser.java:256)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.setManagerDetails(LDAPSearchUser.java:786)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUsers(LDAPSearchUser.java:636)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUserById(LDAPSearchUser.java:760)

at com.virsa.ae.search.bo.SearchUserBO.getUserById(SearchUserBO.java:192)

at com.virsa.ae.service.cache.AECacheUtil.getUser(AECacheUtil.java:321)

at com.virsa.ae.service.cache.AECacheUtil.getUserFullName(AECacheUtil.java:220)

at com.virsa.ae.dao.sqlj.RoleDAO.findApproversByRoleProfName(RoleDAO.sqlj:51)

at com.virsa.ae.dao.sqlj.RoleDAO.findRoleDetailsByName(RoleDAO.sqlj:211)

at com.virsa.ae.configuration.bo.ImportRolesBO.upsert(ImportRolesBO.java:557)

... 21 more

2009-03-03 07:41:35,985 [SAPEngine_Application_Thread[impl:3]_18] ERROR Error occurred while importing roles.

2009-03-03 07:41:35,996 [SAPEngine_Application_Thread[impl:3]_18] ERROR LocaleUtil.java: Locale Object: