GRC RAR 5.3 upload object Permission error

[Former Member]

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

[neerajmanocha · Accepted solution]

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

[Former Member · Accepted solution]

Thank you very much Neeraj..I have changed text file is UTF-8 unicode file.and upload then it is successful.

[Former Member · Accepted solution]

Within the text files, check for any "Spaces"/Padded texts. These can sometimes be a pain to search for. On the front end during upload, it may have also given the line number within the text file that is causing the issue.

[neerajmanocha · Accepted solution]

Glad to hear that UTF-8 resolved your issue.

You can marked this thread as answered.

Thanks & Regards

Neeraj