GRC-AC v5.3, patch8.1: cannot retrieve user information in CUP Request

[Former Member]

Hello,

version: GRC-AC v5.3, patch8.1

I am currently having trouble bringing up user information in a CUP Request. It is only occuring in our GRC-AC DEV system. I have checked that all of my AE Config settings are the same and the backend system RTA is correct.

Thanks for your help!

Here is the AE Log:

2009-12-02 14:21:48,912 [SAPEngine_Application_Thread[impl:3]_35] ERROR com.sap.mw.jco.JCO$Exception: (104) RFC_ERROR_SYSTEM_FAILURE: No more storage space available for extending an internal table.

com.sap.mw.jco.JCO$Exception: (104) RFC_ERROR_SYSTEM_FAILURE: No more storage space available for extending an internal table.

at com.sap.mw.jco.MiddlewareJRfc.generateJCoException(MiddlewareJRfc.java:516)

at com.sap.mw.jco.MiddlewareJRfc$Client.execute(MiddlewareJRfc.java:1514)

at com.sap.mw.jco.JCO$Client.execute(JCO.java:3980)

at com.sap.mw.jco.JCO$Client.execute(JCO.java:3417)

at com.virsa.ae.service.sap.SAPR3UserDAO.executeFind(SAPR3UserDAO.java:441)

at com.virsa.ae.service.sap.SAPR3UserDAO.getUsers(SAPR3UserDAO.java:1762)

at com.virsa.ae.service.umi.sap.SAPR3SearchUser.getUsers(SAPR3SearchUser.java:317)

at com.virsa.ae.search.bo.SearchUserBO.findUsers(SearchUserBO.java:110)

at com.virsa.ae.search.actions.SearchUserAction.searchUsers(SearchUserAction.java:2315)

at com.virsa.ae.search.actions.SearchUserAction.searchRequestors(SearchUserAction.java:1999)

at com.virsa.ae.search.actions.SearchUserAction.execute(SearchUserAction.java:260)

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

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

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:386)

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

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

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

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

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

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:104)

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

2009-12-02 14:21:48,931 [SAPEngine_Application_Thread[impl:3]_35] ERROR Search could not be completed

com.virsa.ae.service.ServiceException: No more storage space available for extending an internal table.

at com.virsa.ae.service.sap.SAPR3UserDAO.executeFind(SAPR3UserDAO.java:444)

at com.virsa.ae.service.sap.SAPR3UserDAO.getUsers(SAPR3UserDAO.java:1762)

at com.virsa.ae.service.umi.sap.SAPR3SearchUser.getUsers(SAPR3SearchUser.java:317)

at com.virsa.ae.search.bo.SearchUserBO.findUsers(SearchUserBO.java:110)

at com.virsa.ae.search.actions.SearchUserAction.searchUsers(SearchUserAction.java:2315)

at com.virsa.ae.search.actions.SearchUserAction.searchRequestors(SearchUserAction.java:1999)

at com.virsa.ae.search.actions.SearchUserAction.execute(SearchUserAction.java:260)

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

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

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:386)

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

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

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

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

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

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:104)

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

Caused by: com.sap.mw.jco.JCO$Exception: (104) RFC_ERROR_SYSTEM_FAILURE: No more storage space available for extending an internal table.

at com.sap.mw.jco.MiddlewareJRfc.generateJCoException(MiddlewareJRfc.java:516)

at com.sap.mw.jco.MiddlewareJRfc$Client.execute(MiddlewareJRfc.java:1514)

at com.sap.mw.jco.JCO$Client.execute(JCO.java:3980)

at com.sap.mw.jco.JCO$Client.execute(JCO.java:3417)

at com.virsa.ae.service.sap.SAPR3UserDAO.executeFind(SAPR3UserDAO.java:441)

... 23 more

2009-12-02 14:21:48,937 [SAPEngine_Application_Thread[impl:3]_35] ERROR Search could not be completed

com.virsa.ae.service.umi.UMIException: Search could not be completed

at com.virsa.ae.service.umi.sap.SAPR3SearchUser.getUsers(SAPR3SearchUser.java:326)

at com.virsa.ae.search.bo.SearchUserBO.findUsers(SearchUserBO.java:110)

at com.virsa.ae.search.actions.SearchUserAction.searchUsers(SearchUserAction.java:2315)

at com.virsa.ae.search.actions.SearchUserAction.searchRequestors(SearchUserAction.java:1999)

at com.virsa.ae.search.actions.SearchUserAction.execute(SearchUserAction.java:260)

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

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

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:386)

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

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

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

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

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

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:104)

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

Caused by: com.virsa.ae.service.ServiceException: No more storage space available for extending an internal table.

at com.virsa.ae.service.sap.SAPR3UserDAO.executeFind(SAPR3UserDAO.java:444)

at com.virsa.ae.service.sap.SAPR3UserDAO.getUsers(SAPR3UserDAO.java:1762)

at com.virsa.ae.service.umi.sap.SAPR3SearchUser.getUsers(SAPR3SearchUser.java:317)

... 21 more

Caused by: com.sap.mw.jco.JCO$Exception: (104) RFC_ERROR_SYSTEM_FAILURE: No more storage space available for extending an internal table.

at com.sap.mw.jco.MiddlewareJRfc.generateJCoException(MiddlewareJRfc.java:516)

at com.sap.mw.jco.MiddlewareJRfc$Client.execute(MiddlewareJRfc.java:1514)

at com.sap.mw.jco.JCO$Client.execute(JCO.java:3980)

at com.sap.mw.jco.JCO$Client.execute(JCO.java:3417)

at com.virsa.ae.service.sap.SAPR3UserDAO.executeFind(SAPR3UserDAO.java:441)

... 23 more

2009-12-02 14:21:48,943 [SAPEngine_Application_Thread[impl:3]_35] ERROR Error in Searching Users...

com.virsa.ae.core.BOException: Error in Searching Users...

at com.virsa.ae.search.bo.SearchUserBO.findUsers(SearchUserBO.java:125)

at com.virsa.ae.search.actions.SearchUserAction.searchUsers(SearchUserAction.java:2315)

at com.virsa.ae.search.actions.SearchUserAction.searchRequestors(SearchUserAction.java:1999)

at com.virsa.ae.search.actions.SearchUserAction.execute(SearchUserAction.java:260)

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

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

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:386)

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

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

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

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

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

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:104)

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

[Former Member]

All,

I have solved this issue. It was a CUP Config change to the Connections setting "HR Sysytem". It needed to be set to "YES".

Thanks for your help on this.

Regards,

John Stephens

[Former Member]

Hi,

As per error log, sounds space issue.

"ERROR com.sap.mw.jco.JCO$Exception: (104) RFC_ERROR_SYSTEM_FAILURE: No more storage space available for extending an internal table. com.sap.mw.jco.JCO$Exception: (104) RFC_ERROR_SYSTEM_FAILURE: No more storage space available for extending an internal table."

Check the tablespace with your Basis guy and increase it if neccessary.

Regards,

Sabita

[former_member771067]

Hi John,

Sabita is absolutely right. When there is either no freespace or insufficient freespace in the tablespace, system cannot read/write properly from/to the database. That's why it should be consistently monitored by any of the Basis Adminstrator and SAP suggests to add data file, when 90% of available space has been allocated. Take the help of any basis person and check which tablespace, there is no space available and add data file to that. Hope your problem would be resolved with this.

Thanks,

Guru