Error while scheduling Background Job for User/Role Full Synchronization

[Former Member]

Hi all,

We have installed RAR 5.3 Component and uploaded the authorization data & established the connectors to the backend system.

We have performed all the post installation activities and everything is complete.

When we have scheduled User -Full Synchronization with the Back End system as a part of Post Installation Activity we are receiving the below error message

"Error while executing the Job:Cannot assign an empty string to host variable 2."

Also the VIEW LOG/ Terminate Job buttons are disabled in this screen.

Can somebody please help us in resolving the above issue

Thanks and Best Regards,

Srihari.K

[Former Member]

Issue got resolved. THere is an empty space in USRO2 table at the backend system. After removing the entry we were successfull in running the background job schedule for users & roles

Thanks and Best Regards,

Srihari.K

[Former Member]

Hi Sri,

Could you please paste Error log here.

Thanks and Regards,

Jagat

[Former Member]

Hi,

We are copy pasting the error log (Part as it is huge) below here. We could able to do Full Synch for Roles and also for Profiles. Only for User Synch we are getting this error and none of the users are sychronized to RAR

Jan 13, 2009 12:34:27 AM com.virsa.cscext.dao.CSCDAO populateGenObjUser

INFO: Update user WILSONA of HL2-QAHR

Jan 13, 2009 12:34:27 AM com.virsa.cscext.dao.CSCDAO populateGenObjUser

INFO: Update user WINDC of HL2-QAHR

Jan 13, 2009 12:34:27 AM com.virsa.cscext.dao.CSCDAO populateGenObjUser

INFO: Update user WLADICHJ of HL2-QAHR

Jan 13, 2009 12:34:27 AM com.virsa.cscext.dao.CSCDAO populateGenObjUser

INFO: Update user WUK of HL2-QAHR

Jan 13, 2009 12:34:27 AM com.virsa.cscext.dao.CSCDAO populateGenObjUser

INFO: Update user ZENGS of HL2-QAHR

Jan 13, 2009 12:34:27 AM com.virsa.cscext.dao.CSCDAO populateGenObjUser

INFO: Update user ZHENGL of HL2-QAHR

Jan 13, 2009 12:34:27 AM com.virsa.cscext.dao.CSCDAO populateGenObjUser

INFO: All System Flag:false=====Last Batch Flag:true

Jan 13, 2009 12:34:27 AM com.virsa.cc.xsys.bg.BatchRiskAnalysis loadUserData

INFO: @@@ User sync completed for params true: Syskey List is [HL2-QAHR]

Jan 13, 2009 12:34:27 AM com.virsa.cc.xsys.bg.BgJob run

WARNING: *** Job Exception: Cannot assign an empty string to host variable 2.

com.sap.sql.log.OpenSQLException: Cannot assign an empty string to host variable 2.

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.VarcharResultColumn.setString(VarcharResultColumn.java:57)

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.cscext.dao.CSCDAO.updateIgnoredUserData(CSCDAO.java:1388)

at com.virsa.cscext.dao.CSCDAO.populateGenObjUser(CSCDAO.java:1169)

at com.virsa.cc.xsys.bg.BatchRiskAnalysis.populateGenObj(BatchRiskAnalysis.java:868)

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

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

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

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

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

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

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

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

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

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

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

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

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

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(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:102)

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

Jan 13, 2009 12:34:27 AM com.virsa.cc.xsys.bg.BgJob setStatus

INFO: Job ID: 13 Status: Error

Jan 13, 2009 12:34:27 AM com.virsa.cc.xsys.bg.BgJob updateJobHistory

FINEST: --- @@@@@@@@@@@ Updating the Job History -

---

2@@Msg is Error while executing the Job:Cannot assign an empty string to host variable 2.

Jan 13, 2009 12:34:27 AM com.virsa.cc.xsys.bg.dao.BgJobHistoryDAO insert

INFO: -

---

Background Job History: job id=13, status=2, message=Error while executing the Job:Cannot assign an empty string to host variable 2.

Jan 13, 2009 12:34:27 AM com.virsa.cc.xsys.riskanalysis.AnalysisDaemonBgJob scheduleJob

INFO: -

---

Complted Job =>13----

---

Please let us know how to resolve this error

Thanks and Best Regards,

Srihari.K

[Former Member]

Hi Sri,

It seems one of the user name contains blank as User ID (I have noticed this at a client) or contains blank space before or after the user ID.

Check the logs to find out about this user or see where exactly you are getting this error. When you run Full sync, log should ususally tell you about at which user id you are receiving this error.

You might not have added action for View Log/Terminate Job to the administrator role. That might be the reason that these buttons are grayed out.

Try removing this user id from backend and run the full sync again. This should solve your problem.

Regards,

Alpesh

[Former Member]

Hi !

have you implemented the note 999785 ? Also check note 1034117.

[Former Member]

HI Sahad K ,

the note mentioned is not 999785 accessible .Its saying that it is for internal purpose .

[Former Member]

Hi,

We have observed the following for the above error

"The Authorization data extracted from /VIRSA/ZCC_DOWNLOAD_SAPOBJ have some blank spaces for the authorization values.

This we checked by converting the text files into Excel. Whether because of these blank spaces the error "Cannot assign an empty string to host variable2" is appearing when we scheduled the full synchronization for the User & Roles?

If yes, with what value can we replace these blank spaces - as they are the Authorization object values and reupload. (There are roughly around 22k such blank spaces)

If we reupload does this will get replaced with the original ones.

Thanks and Best Regards,

Srihari.K