VIRSA_CC_GENOBJ table empty even after full sync

[Former Member]

Hi,

We are running the BG job for full sync, the job getting completed quickly and no errors are found in the log for this job. But when checking the table VIRSA_CC_GENOBJ, it was still empty without any entries from backend system.

We tested all the connections and everything was fine.

Below was my system

GRC: SAP GRC AC 5.3 SP13

ECC: ECC6 Ehp4 with RTA's VIRSANH SP13 and VIRSAHR SP11.

Any suggestions on what could be missing, please help with your inputs.

Regards,

Sitarama

[Former Member · Accepted solution]

are you using JCO connections, then issue will be that they are wrongly created.

please check entries in VIRSA_CC_SYSTEMC

i will suggest you don't use JCO , rather create direct connection in RAR

then schedule the Sync job

regards,

Surpreet

[Former Member · Accepted solution]

Hi,

I did not get what you mean by direct connection, we had plan for 3 systems connected to GRC Dev system, so we are going with logical system.

Below was the output of VIRSA_CC_SYSTEMC

Row VSYSKEY| SYSNAME| SYSTYPE| SYSCON1| SYSCON2| SYSCON3| SYSCON4| SYSCON5| STATUS| MGMTRLVNT| SYSCON6| SYSCON7| SYSCON8| SYSCON9| EXTOBJ|

1 UPG usalpd63 SAP JCO VIRSAXSR3_01_MODEL VIRSAXSR3_01_METADATA JAVA 0 0 amusalpwtsd01 N

2 ERP_ECC Logical system for backend ECC systems-NON Prod LSYS ERP_ECC ERP_ECC 0 1

Regards,

Sitaram.

[Former Member · Accepted solution]

please open connector in RAR configuration tab in change mode

i think it was 'connection type', rather than JCO, select the one (sorry forgot nam) which allow you to maintain server name, client , user id, password in RAR itself

Regards,

Surpreet

[Former Member · Accepted solution]

Updating important part of log:

INFO: Started User sync for System UPG###true

Oct 24, 2010 2:49:37 AM com.virsa.cc.common.util.ExceptionUtil logError

SEVERE: null

java.lang.NullPointerException

at

com.virsa.cc.comp.wdp.IPublicBackendAccessInterface$IUserListInputElement.wdGetObject(IPublicBackendAccessInterface.java)

at com.sap.tc.webdynpro.progmodel.context.NodeElement.getAttributeAsText(NodeElement.java:888)

at com.virsa.cc.comp.BackendAccessInterface.execBAPI(BackendAccessInterface.java:401)

at com.virsa.cc.comp.BackendAccessInterface.executeBAPI(BackendAccessInterface.java:302)

at com.virsa.cc.comp.wdp.InternalBackendAccessInterface.executeBAPI(InternalBackendAccessInterface.java:4227)

at com.virsa.cc.comp.BackendAccessInterface.searchUser(BackendAccessInterface.java:761)

at com.virsa.cc.comp.wdp.InternalBackendAccessInterface.searchUser(InternalBackendAccessInterface.java:4279)

at com.virsa.cc.comp.wdp.InternalBackendAccessInterface$External.searchUser(InternalBackendAccessInterface.java:4748)

at com.virsa.cc.dataextractor.bo.DataExtractorSAP.searchObj(DataExtractorSAP.java:381)

at com.virsa.cc.xsys.bg.BatchRiskAnalysis.loadUserData(BatchRiskAnalysis.java:366)

at com.virsa.cc.xsys.bg.BatchRiskAnalysis.performBatchSyncAndAnalysis(BatchRiskAnalysis.java:1288)

at com.virsa.cc.xsys.bg.BgJob.runJob(BgJob.java:559)

at com.virsa.cc.xsys.bg.BgJob.run(BgJob.java:362)

at com.virsa.cc.xsys.riskanalysis.AnalysisDaemonBgJob.scheduleJob(AnalysisDaemonBgJob.java:375)

at com.virsa.cc.xsys.riskanalysis.AnalysisDaemonBgJob.start(AnalysisDaemonBgJob.java:92)

at com.virsa.cc.comp.BgJobInvokerView.wdDoModifyView(BgJobInvokerView.java:444)

at com.virsa.cc.comp.wdp.InternalBgJobInvokerView.wdDoModifyView(InternalBgJobInvokerView.java:1236)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingView.doModifyView(DelegatingView.java:78)

at com.sap.tc.webdynpro.progmodel.view.View.modifyView(View.java:337)

at com.sap.tc.webdynpro.clientserver.cal.ClientComponent.doModifyView(ClientComponent.java:481)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.doModifyView(WindowPhaseModel.java:551)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequest(WindowPhaseModel.java:148)

at com.sap.tc.webdynpro.clientserver.window.WebDynproWindow.processRequest(WebDynproWindow.java:335)

at com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:143)

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:333)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessingStandalone(ClientSession.java:741)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessing(ClientSession.java:694)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doProcessing(ClientSession.java:253)

at com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:149)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:62)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doGet(DispatcherServlet.java:46)

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

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(ApplicationSessionMessageLis

tener.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)

Oct 24, 2010 2:49:42 AM com.virsa.cc.xsys.bg.BatchRiskAnalysis loadUserData

INFO: User Sync Search Obj Result is --- Result is count is 2113

Oct 24, 2010 2:49:42 AM com.virsa.cc.xsys.bg.BatchRiskAnalysis insertBAPIUserData

INFO: User Sync Insert BAPI User data for SysKey:UPG#masterSys:UPG#from:.USERSETUP#to:LECHANTOUX,M# fullscan is true

Oct 24, 2010 2:49:42 AM com.virsa.cc.xsys.bg.BatchRiskAnalysis getBAPIUserData

INFO: --- Data Extractor -

---

com.virsa.cc.dataextractor.bo.DataExtractorSAP@2ab3ad55

Oct 24, 2010 2:49:42 AM com.virsa.cc.xsys.bg.BatchRiskAnalysis getBAPIUserData

INFO: -- Last Run Date is 1970-01-01

Oct 24, 2010 2:49:42 AM com.virsa.cc.xsys.bg.BatchRiskAnalysis getBAPIUserData

INFO: -- Current Date is 2010-10-24

Oct 24, 2010 2:49:42 AM com.virsa.cc.common.util.ExceptionUtil logError

SEVERE: null

java.lang.NullPointerException

at

com.virsa.cc.comp.wdp.IPublicBackendAccessInterface$IAuthChgUserInputElement.wdGetObject(IPublicBackendAccessInterface.java)

at com.sap.tc.webdynpro.progmodel.context.NodeElement.getAttributeAsText(NodeElement.java:888)

at com.virsa.cc.comp.BackendAccessInterface.execBAPI(BackendAccessInterface.java:401)

at com.virsa.cc.comp.BackendAccessInterface.executeBAPI(BackendAccessInterface.java:302)

at com.virsa.cc.comp.wdp.InternalBackendAccessInterface.executeBAPI(InternalBackendAccessInterface.java:4227)

at com.virsa.cc.comp.BackendAccessInterface.getAuthChangedUsers(BackendAccessInterface.java:3674)

at com.virsa.cc.comp.BackendAccessInterface.getAuthChangedUsers(BackendAccessInterface.java:3650)

at com.virsa.cc.comp.BackendAccessInterface.getAuthChangedObj(BackendAccessInterface.java:1032)

at com.virsa.cc.comp.wdp.InternalBackendAccessInterface.getAuthChangedObj(InternalBackendAccessInterface.java:4303)

at

com.virsa.cc.comp.wdp.InternalBackendAccessInterface$External.getAuthChangedObj(InternalBackendAccessInterface.java:4772)

at com.virsa.cc.dataextractor.bo.DataExtractorSAP.getAuthChangedObj(DataExtractorSAP.java:619)

at com.virsa.cc.xsys.bg.BatchRiskAnalysis.getBAPIUserData(BatchRiskAnalysis.java:664)

at com.virsa.cc.xsys.bg.BatchRiskAnalysis.insertBAPIUserData(BatchRiskAnalysis.java:127)

at com.virsa.cc.xsys.bg.BatchRiskAnalysis.loadUserData(BatchRiskAnalysis.java:391)

at com.virsa.cc.xsys.bg.BatchRiskAnalysis.performBatchSyncAndAnalysis(BatchRiskAnalysis.java:1288)

at com.virsa.cc.xsys.bg.BgJob.runJob(BgJob.java:559)

at com.virsa.cc.xsys.bg.BgJob.run(BgJob.java:362)

at com.virsa.cc.xsys.riskanalysis.AnalysisDaemonBgJob.scheduleJob(AnalysisDaemonBgJob.java:375)

at com.virsa.cc.xsys.riskanalysis.AnalysisDaemonBgJob.start(AnalysisDaemonBgJob.java:92)

at com.virsa.cc.comp.BgJobInvokerView.wdDoModifyView(BgJobInvokerView.java:444)

at com.virsa.cc.comp.wdp.InternalBgJobInvokerView.wdDoModifyView(InternalBgJobInvokerView.java:1236)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingView.doModifyView(DelegatingView.java:78)

at com.sap.tc.webdynpro.progmodel.view.View.modifyView(View.java:337)

at com.sap.tc.webdynpro.clientserver.cal.ClientComponent.doModifyView(ClientComponent.java:481)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.doModifyView(WindowPhaseModel.java:551)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequest(WindowPhaseModel.java:148)

at com.sap.tc.webdynpro.clientserver.window.WebDynproWindow.processRequest(WebDynproWindow.java:335)

at com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:143)

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:333)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessingStandalone(ClientSession.java:741)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessing(ClientSession.java:694)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doProcessing(ClientSession.java:253)

at com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:149)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:62)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doGet(DispatcherServlet.java:46)

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

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(ApplicationSessionMessageLis

tener.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)

Oct 24, 2010 2:49:44 AM com.virsa.cc.xsys.bg.BatchRiskAnalysis insertBAPIUserData

INFO: Gen Obj Users returned from the BAPI 14606

[Former Member · Accepted solution]

Only error observed was

INFO: Started User sync for System UPG###true

Oct 24, 2010 2:49:37 AM com.virsa.cc.common.util.ExceptionUtil logError

SEVERE: null

java.lang.NullPointerException

at .......................................

[Former Member · Accepted solution]

Hi,

In connection type we have selected Adaptive RFC, if I select SAP JCO it will ask for user-ID, Password, System details.....

Regards,

Sitaram.

[Former Member · Accepted solution]

yes select SAP JCO and create one.

don't forget to select checkbox for HR...... when creating (hope it is still there....... in lates SP)

regards,

Surrpeet

[Former Member · Accepted solution]

Thanks for the reponses

[Former Member]

Hi,

If you are performing a full sync, the job would require more time. Since, you are mentioning that the job is getting finished very quickly, I suspect a connection issue.

User the CC Debugger to run a query. Ensure that the CC Debugger is able to read all the user/role data. Incase if you are able to see the users, check the CC Log for any error message.

Hope this helps!!

Rgds,

Raghu

[Former Member]

Hi,

The CC debugger is able to fetch the backend system data eg. Users. we had no problems with connections, also no error message was observed in the log file for the job run. It says job successfully completed and no error entries in log.

Regards,

Sitaram.