on 05-03-2012 10:55 AM
Hi
When I try to upload permissions objects into GRC RAR 5.3 SP16, I got below error message. I successfully uploaded Text Objects, when I ry to upload permissions objects I got error.
ORA-00001: unique constraint (SAPSR3DB.SYS_C00154815) violated
com.virsa.cc.rulearchitect.bo.SAPObjectBO.compareAndInsert(SAPObjectBO.java:172)
com.virsa.cc.comp.UploadTexts.onActionUploadTextObjs(UploadTexts.java:456)
com.virsa.cc.comp.wdp.InternalUploadTexts.wdInvokeEventHandler(InternalUploadTexts.java:170)
com.sap.tc.webdynpro.progmodel.generation.DelegatingView.invokeEventHandler(DelegatingView.java:87)
com.sap.tc.webdynpro.progmodel.controller.Action.fire(Action.java:67)
com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.doHandleActionEvent(WindowPhaseModel.java:420)
com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequest(WindowPhaseModel.java:132)
com.sap.tc.webdynpro.clientserver.window.WebDynproWindow.processRequest(WebDynproWindow.java:335)
com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:143)
com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:321)
com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessingStandalone(ClientSession.java:713)
com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessing(ClientSession.java:666)
com.sap.tc.webdynpro.clientserver.session.ClientSession.doProcessing(ClientSession.java:250)
com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:149)
com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:62)
com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doPost(DispatcherServlet.java:53)
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)
com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)
com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:386)
com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:364)
com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:1039)
com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:265)
com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)
com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175)
com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)
com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)
com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)
java.security.AccessController.doPrivileged(Native Method)
com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104)
com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)
Please helpout what is the issue, what are the points can I consider while upload auth objects
Hi Nagaraju,
It seems there are some entries which are already in VIRSA_CC_SAPOBJ table and when you try to upload the data, system gives duplicate key error.
There are below approaches to overcome this situation.
1. Delete data from VIRSA_CC_SAPOBJ table as this table holds the data for Permission which you upload from RAR upload permission link.
VIRSA_CC_SAPOBJ & VIRSA_CC_OBJTEXT are the 2 tables which holds the data for text and permission uploaded under RAR application.
so if you delete the data from these tables and upload the files again, this will solve your purpose.
2. Check whether your file is UTF-8 unicode file. If not, please change it to UTF-8 and then try to upload it again. This can also resolve your issue, if there is any formating issue.
3. execute below query into your data base and check which table is impacted. If this says some other table (other than VIRSA_CC_SAPOBJ), please ignore first approach given above.
Select * from DBA_CONSTRAINTS where constraint_name like '%SYS_C00154815%'
I hope this helps.
Thanks & Regards
Neeraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.