IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

"Problem with "getProcessInstanceList" in built servcie

  • 1.  "Problem with "getProcessInstanceList" in built servcie

    Posted Wed November 26, 2008 07:37 AM

    [FONT=&quot]Hi All,

    I am using “pub.monitor.process.instance.getInstanceList” in built service as part of a wrapper flow service to retrieve all the process instances for a model id for a particular application. This service runs fine when i execute it normally from developer but fails when i run it using a scheduler with the below error. I am running from Scheduler as “Administrator” only. Please help me with this…

    Below is the error… ( i have checked run time values using save and restorePipeline and all the values necessary for "getProcessInstanceList are available at runtime) Plese let me know if you need any more details

    [SIZE=4],ErrorMsg=com.wm.monitor.util.MonitorException: [pub.monitor.process.instance:getInstanceList] java.lang.NullPointerException,ServiceName=pub.monitor.process.instance:getInstanceList<<<.
    2008-11-26 12:32:47 GMT+05:30 [ISS.0095.0003C] AuditLogManager Runtime Exception: java.sql.SQLException:[wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-01003: no statement parsed
    processing log entry >>>BasicData:RootContextID=312ecd00bb8811dd97a9fb47946abcdd,AuditTimestamp=1227682967295,ContextID=3173ec50bb8811dd9931f02c69d5ea16,ParentContextID=3173ec50bb8811dd9930b005f1b2eba3,AuditSchemaName=wMError,AuditSchemaVersion=1,ServerID=10.226.107.130:5555,ErrStackTrace=com.wm.monitor.util.MonitorException: [pub.monitor.process.instance:getInstanceList] java.lang.NullPointerException
    at com.wm.monitor.util.MonitorUtil.rethrow(MonitorUtil.java:1026)
    at pub.monitor.process.instance.getInstanceList(instance.java:246)
    at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:403)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:630)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:232)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:220)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:618)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:535)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
    at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:189)
    at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:324)
    at com.wm.lang.flow.FlowMapInvoke.invokeService(FlowMapInvoke.java:220)
    at com.wm.lang.flow.FlowMap.invoke(FlowMap.java:317)
    at com.wm.lang.flow.FlowMap.invoke(FlowMap.java:162)
    at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:581)
    at com.wm.lang.flow.FlowState.step(FlowState.java:441)
    at com.wm.lang.flow.FlowState.invoke(FlowState.java:406)
    at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1040)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:630)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:232)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:220)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:618)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:535)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
    at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:189)
    at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:324)
    at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:581)
    at com.wm.lang.flow.FlowState.step(FlowState.java:441)
    at com.wm.lang.flow.FlowState.invoke(FlowState.java:406)
    at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1040)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:630)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:232)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:220)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:618)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:535)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
    at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:189)
    at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:324)
    at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:581)
    at com.wm.lang.flow.FlowState.step(FlowState.java:441)
    at com.wm.lang.flow.FlowState.invoke(FlowState.java:406)
    at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1040)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:630)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:232)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:220)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:618)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:535)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
    at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
    at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:189)
    at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:324)
    at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:581)
    at com.wm.lang.flow.FlowState.step(FlowState.java:441)
    at com.wm.lang.flow.FlowState.invoke(FlowState.java:406)
    at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1040)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:630)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:232)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:220)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
    at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:618)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:535)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
    at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:358)
    at com.wm.app.b2b.server.scheduler.ScheduleDB$ScheduledService.run(ScheduleDB.java:2375)
    at com.wm.util.pool.PooledThread.run(PooledThread.java:112)
    at java.lang.Thread.run(Thread.java:595)
    [/size][/FONT]


    #webMethods
    #Flow-and-Java-services
    #Integration-Server-and-ESB