Unable to upload authorization data in ERM (GRC 5....

former_member298408 · ‎10-29-2013

Hi All,

I was trying to upload 24 new roles from spreadsheet to ERM, while 18 roles got uploaded successfully, rest 6 roles have some issues, where roles were uploaded but no auth data was copied.

Below is the error log, I checked in AGR* tables and tried to remove all the null values from inactive auth objects, but still auth data is not getting uploaded, just for 6 roles.

Please help!!!

2013-10-29 11:55:14,871 [SAPEngine_Application_Thread[impl:3]_5] ERROR com.virsa.core.dao.DAOException: Cannot assign an empty string to host variable 3.

java.lang.Throwable: Cannot assign an empty string to host variable 3.

at com.virsa.re.dao.jdbc.AuthRoleTransactionDAO.insertDescription(AuthRoleTransactionDAO.java:225)

at com.virsa.re.dao.jdbc.AuthAuthorizationDataDAO.saveAuthData(AuthAuthorizationDataDAO.java:220)

at com.virsa.re.dao.jdbc.AuthAuthorizationDataDAO.saveAuthData(AuthAuthorizationDataDAO.java:137)

at com.virsa.re.dao.jdbc.AuthAuthorizationDataDAO.updateAuthData(AuthAuthorizationDataDAO.java:47)

at com.virsa.re.bo.impl.AuthorizationDataBO.saveAuthData(AuthorizationDataBO.java:422)

at com.virsa.re.bo.impl.AuthorizationDataBO.saveAuthData(AuthorizationDataBO.java:588)

at com.virsa.re.bo.impl.RoleImportBO.createRole(RoleImportBO.java:1595)

at com.virsa.re.bo.impl.RoleImportBO.importRoles(RoleImportBO.java:643)

at com.virsa.re.bo.impl.RoleImportBO.importRoles(RoleImportBO.java:336)

at com.virsa.re.configuration.action.MassRoleImportAction.generateRole(MassRoleImportAction.java:645)

at com.virsa.re.configuration.action.MassRoleImportAction.execute(MassRoleImportAction.java:81)

at com.virsa.framework.NavigationEngine.execute(NavigationEngine.java:273)

at com.virsa.framework.servlet.VFrameworkServlet.service(VFrameworkServlet.java:230)

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

at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.runServlet(FilterChainImpl.java:117)

at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:62)

at com.virsa.comp.history.filter.HistoryFilter.doFilter(HistoryFilter.java:43)

at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:58)

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

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)

2013-10-29 11:55:14,872 [SAPEngine_Application_Thread[impl:3]_5] ERROR Z_IT_RETAIL_SUPPORT_ADMIN : Cannot assign an empty string to host variable 3.

2013-10-29 11:55:14,873 [SAPEngine_Application_Thread[impl:3]_5] ERROR Role Import :: Message Not Found for the role name : Z_IT_RETAIL_SUPPORT_ADMIN Key : 22820

2013-10-29 11:57:41,848 [SAPEngine_Application_Thread[impl:3]_23] ERROR Cannot assign a java.lang.String object of length 2,530 to host variable 8 which has JDBC type VARCHAR(1,000).

java.lang.Throwable: Cannot assign a java.lang.String object of length 2,530 to host variable 8 which has JDBC type VARCHAR(1,000).

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85)

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:124)

at com.sap.sql.types.GenericResultColumn.checkLength(GenericResultColumn.java:212)

at com.sap.sql.types.VarcharResultColumn.setString(VarcharResultColumn.java:63)

at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:511)

at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.setString(PreparedStatementWrapper.java:355)

at com.virsa.re.dao.jdbc.ChangeHistoryDAO.saveChangeHistory(ChangeHistoryDAO.java:371)

at com.virsa.re.bo.impl.ChangeHistoryBO.saveChangeHistory(ChangeHistoryBO.java:77)

at com.virsa.re.workflow.bo.RoleServiceBO.recordRoleChangeHistory(RoleServiceBO.java:102)

at com.virsa.re.workflow.bo.RoleServiceBO.processWFExitRoleApproval(RoleServiceBO.java:67)

at com.virsa.ae.exitService.RequestService.execWFExitService(RequestService.java:140)

at com.virsa.ae.exitService.RequestServiceLocalLocalObjectImpl0_0.execWFExitService(RequestServiceLocalLocalObjectImpl0_0.java:103)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:331)

at com.sap.engine.services.webservices.runtime.EJBImplementationContainer.invokeMethod(EJBImplementationContainer.java:126)

at com.sap.engine.services.webservices.runtime.RuntimeProcessor.process(RuntimeProcessor.java:174)

at com.sap.engine.services.webservices.runtime.RuntimeProcessor.process(RuntimeProcessor.java:81)

at com.sap.engine.services.webservices.runtime.servlet.ServletDispatcherImpl.doPost(ServletDispatcherImpl.java:90)

at SoapServlet.doPost(SoapServlet.java:51)

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

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

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