SAP IDM 8.0 SP6 - Could not retrieve job ID

former_member114258 · ‎07-18-2019

Hi,

I am facing issue after connecting my IDM System to AD.

Version of IDM is 8 SP 6 complete landscape

When i added repository of Active Directory in my IDM system, as soon as I add the parameters and click Save. I get error

Could Not retrieve Job ID "220"

Dispatcher is working fine

VDS is working fine and able to connect to LDAP

Trace files show as below:

Logs:

Time: 2019 07 18 12:58:04:576

SourceName: com.sap.sql.jdbc.direct.DirectPreparedStatement

Application: sap.com/tc~idm~wd~workflow

Location: com.sap.sql.jdbc.direct.DirectPreparedStatement

User: Administrator

Session: 6

DSRTransaction: 675d03cca93d11e9ccaa00000032073a

ThreadName: Thread[HTTP Worker [@1640188215],5,Dedicated_Application_Thread]

Severity: Error

TZone: +0300

CSNComponent: BC-JAS-PER-SQL

DCComponent: opensqlkernel

CorrelationID: 3278650000000004

DSRRootContextID: B6D7AEFDA93B11E9AE1B00000032073A

DSRCounter: 0

Text: SQL error occurred on connection R1DA-SIMW01:MXMCDevDB_db:MXMCDevDB_prov_u: code=0, state="S1093", message="The index 2 is out of range.";

SQL statement is "SELECT log_id, job_id, name, logdate, time_used, total, adds, mods, noop, dels, warns, errs, dispatcher, description, mcmv_data, mcmv_path FROM MCMV_JOBLOG WHERE job_id = ? AND logdate BETWEEN DATEADD(second, -?, GETDATE()) AND GETDATE()".

[EXCEPTION]

com.microsoft.sqlserver.jdbc.SQLServerException: The index 2 is out of range.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:228)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setterGetParam(SQLServerPreparedStatement.java:1124)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setValue(SQLServerPreparedStatement.java:1138)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setLong(SQLServerPreparedStatement.java:1438)

at com.sap.sql.jdbc.basic.BasicPreparedStatement.setLong(BasicPreparedStatement.java:133)

at com.sap.sql.jdbc.mss.MssInetPreparedStatement.setLong(MssInetPreparedStatement.java:205)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.setLong(DirectPreparedStatement.java:545)

at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.setLong(PreparedStatementWrapper.java:450)

at com.sap.idm.jmx.impl.SAP_ITSAM_IDM_Service_ManageJobsImpl.retrieveJobRuns(SAP_ITSAM_IDM_Service_ManageJobsImpl.java:409)

at com.sap.idm.jmx.impl.SAP_ITSAM_IDM_Service_ManageJobsImpl.retrieveJob(SAP_ITSAM_IDM_Service_ManageJobsImpl.java:237)

at com.sap.idm.jmx.impl.SAP_ITSAM_IDM_Service_Impl_Impl.retrieveJob(SAP_ITSAM_IDM_Service_Impl_Impl.java:2423)

at com.sap.idm.jmx.SAP_ITSAM_IDM_ServiceWrapper.invoke(SAP_ITSAM_IDM_ServiceWrapper.java:1707)

at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)

at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)

at com.sap.pj.jmx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:468)

at com.sap.pj.jmx.server.interceptor.MBeanServerWrapperInterceptor.invoke(MBeanServerWrapperInterceptor.java:288)

at com.sap.engine.services.jmx.CompletionInterceptor.invoke(CompletionInterceptor.java:612)

at com.sap.pj.jmx.server.interceptor.BasicMBeanServerInterceptor.invoke(BasicMBeanServerInterceptor.java:277)

at com.sap.jmx.provider.ProviderInterceptor.invoke(ProviderInterceptor.java:365)

at com.sap.engine.services.jmx.RedirectInterceptor.invoke(RedirectInterceptor.java:340)

at com.sap.pj.jmx.server.interceptor.MBeanServerInterceptorChain.invoke(MBeanServerInterceptorChain.java:367)

at com.sap.engine.services.jmx.MBeanServerSecurityWrapper.invoke(MBeanServerSecurityWrapper.java:289)

at com.sap.engine.services.jmx.ClusterInterceptor.invoke(ClusterInterceptor.java:813)

at com.sap.pj.jmx.server.interceptor.MBeanServerInterceptorChain.invoke(MBeanServerInterceptorChain.java:367)

at com.sap.idm.wd.jmx.SAP_ITSAM_IDM_Service$Impl.retrieveJob(SAP_ITSAM_IDM_Service.java:2251)

at com.sap.idm.wd.modelwrapper.ModelWrapperInterface.retrieveJob(ModelWrapperInterface.java:1425)

at com.sap.idm.wd.modelwrapper.wdp.InternalModelWrapperInterface.wdInvokeMethod(InternalModelWrapperInterface.java:948)

at com.sap.tc.webdynpro.progmodel.generation.ExternalControllerPI$ExternalInterfaceInvocationHandler.invoke(ExternalControllerPI.java:339)

at com.sun.proxy.$Proxy1834.retrieveJob(Unknown Source)

at com.sap.idm.wd.wf.systemparam.SystemParameterComp.getJobFromJmx(SystemParameterComp.java:2904)

at com.sap.idm.wd.wf.systemparam.SystemParameterComp.getCurrentJobFromJmx(SystemParameterComp.java:2898)

at com.sap.idm.wd.wf.systemparam.SystemParameterComp.refreshCurrentJob(SystemParameterComp.java:973)

at com.sap.idm.wd.wf.systemparam.SystemParameterComp.refreshJobsTreeAndCurrentJob(SystemParameterComp.java:1023)

at com.sap.idm.wd.wf.systemparam.SystemParameterComp.refresh(SystemParameterComp.java:2424)

at com.sap.idm.wd.wf.systemparam.SystemParameterComp.refresh(SystemParameterComp.java:672)

at com.sap.idm.wd.wf.systemparam.wdp.InternalSystemParameterComp.refresh(InternalSystemParameterComp.java:542)

at com.sap.idm.wd.wf.systemparam.RepositoriesView.onActionRefresh(RepositoriesView.java:582)

at com.sap.idm.wd.wf.systemparam.wdp.InternalRepositoriesView.wdInvokeEventHandler(InternalRepositoriesView.java:408)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingView.invokeEventHandler(DelegatingView.java:142)

at com.sap.tc.webdynpro.progmodel.controller.Action.fire(Action.java:75)

at com.sap.tc.webdynpro.clientserver.phases.ProcessingEventPhase.doHandleActionEvent(ProcessingEventPhase.java:159)

at com.sap.tc.webdynpro.clientserver.phases.ProcessingEventPhase.execute(ProcessingEventPhase.java:94)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequestPartly(WindowPhaseModel.java:162)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.doProcessRequest(WindowPhaseModel.java:110)

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

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

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

at com.sap.tc.webdynpro.clientserver.cal.ClientApplication.doExecute(ClientApplication.java:1671)

at com.sap.tc.webdynpro.clientserver.cal.ClientApplication.doProcessing(ClientApplication.java:1485)

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doApplicationProcessingStandalone(ApplicationSession.java:908)

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doApplicationProcessing(ApplicationSession.java:880)

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

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

at com.sap.tc.webdynpro.serverimpl.core.AbstractDispatcherServlet.doContent(AbstractDispatcherServlet.java:87)

at com.sap.tc.webdynpro.serverimpl.wdc.DispatcherServlet.doContent(DispatcherServlet.java:101)

at com.sap.tc.webdynpro.serverimpl.core.AbstractDispatcherServlet.doPost(AbstractDispatcherServlet.java:62)

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

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

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:152)

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.doWork(RequestDispatcherImpl.java:373)

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:501)

at com.sap.tc.webdynpro.serverimpl.wdc.ForwardServlet.doPost(ForwardServlet.java:77)

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

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

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:152)

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:38)

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

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:210)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:441)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:430)

at com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:38)