Symptom

When Index Business Process Runs it fails immediately with SQL Error Code: -204 SQL State: 42704 com.ibm.db2.jdbc.app.DB2 *FIRST in *N type *MEM not found on Iseries.

[2008-07-03 04:40:07.932] ERROR BPMovingService-> .indexBusinessProcess(). Error Detected While Running Index Business Process

[2008-07-03 04:40:07.932] ERROR SQL Error Code: -204

[2008-07-03 04:40:07.932] ERROR SQL State: 42704

com.ibm.db2.jdbc.app.DB2DBException: *FIRST in *N type *MEM not found.

java/lang/Throwable.<init>(Ljava/lang/String;)V+4 (Throwable.java:85)

java/lang/Exception.<init>(Ljava/lang/String;)V+1 (Exception.java:33)

java/sql/SQLException.<init>(Ljava/lang/String;Ljava/lang/String;I)V+1 (SQLException.java:34)

com/ibm/db2/jdbc/app/DB2Exception.<init>(Ljava/lang/String;Ljava/lang/String; I)V+0 (DB2Exception.java:49)

com/ibm/db2/jdbc/app/DB2SQLException2.<init>(Ljava/lang/String;Ljava/lang/Str ing;I[B)V+0 (DB2SQLException2.java:62)

com/ibm/db2/jdbc/app/DB2DBException.<init>(Ljava/lang/String;Ljava/lang/Strin g;I[B)V+0 (DB2DBException.java:47)

com/ibm/db2/jdbc/app/DB2StatementRuntimeImpl.SQLExecDirect(ILjava/lang/String ;IIII)I+?? (DB2StatementRuntimeImpl.java:??)

com/ibm/db2/jdbc/app/DB2StatementRuntimeImpl.execDirect(ILjava/lang/String;II II)I+0 (DB2StatementRuntimeImpl.java:171)

com/ibm/db2/jdbc/app/DB2Statement.commonExecDirect(Ljava/lang/String;Z)Z+0 (DB2Statement.java:938)

com/ibm/db2/jdbc/app/DB2Statement.commonExecDirect(Ljava/lang/String;)Z+0 (DB2Statement.java:1138)

com/ibm/db2/jdbc/app/DB2Statement.executeUpdate(Ljava/lang/String;)I+36 (DB2Statement.java:1166)

com/sterlingcommerce/woodstock/services/bpmovingservice/BPMovingService.setAr chiveDate()V+75 (BPMovingService.java:811)

com/sterlingcommerce/woodstock/services/bpmovingservice/BPMovingService.proce ssBps(ILjava/util/Map;)Ljava/util/Map;+822 (BPMovingService.java:360)

com/sterlingcommerce/woodstock/services/bpmovingservice/BPMovingService.proce ssBps(I)Ljava/util/Map;+3 (BPMovingService.java:263)

com/sterlingcommerce/woodstock/services/bpmovingservice/BPMovingService.index BusinessProcesses()Z+122 (BPMovingService.java:237)

com/sterlingcommerce/woodstock/services/bpmovingservice/BPMovingServiceImpl.p rocessData(Lcom/sterlingcommerce/woodstock/workflow/WorkFlowContext;)Lcom/sterli ngcommerce/woodstock/workflow/WorkFlowContext;+269 (BPMovingServiceImpl.java:136)

com/sterlingcommerce/woodstock/workflow/activity/engine/ActivityEngineHelper. invokeService(Lcom/sterlingcommerce/woodstock/workflow/WorkFlowContext;)Lcom/ste rlingcommerce/woodstock/workflow/WorkFlowContext;+0 (ActivityEngineHelper.java:1974)

com/sterlingcommerce/woodstock/workflow/activity/engine/ActivityEngineHelper. nextMainLogic(Lcom/sterlingcommerce/woodstock/workflow/WorkFlowContext;)Lcom/ste rlingcommerce/woodstock/workflow/WorkFlowContext;+0 (ActivityEngineHelper.java:521)

com/sterlingcommerce/woodstock/workflow/activity/engine/ActivityEngineHelper. next(Lcom/sterlingcommerce/woodstock/workflow/WorkFlowContext;I)Lcom/sterlingcom merce/woodstock/workflow/WorkFlowContext;+0 (ActivityEngineHelper.java:281)

com/sterlingcommerce/woodstock/workflow/queue/WorkFlowQueueListener.doWork(Lc om/sterlingcommerce/woodstock/workflow/queue/WorkFlowQueueListener$WFCWrapper;Z) Lcom/sterlingcommerce/woodstock/workflow/queue/WorkFlowQueueListener$WFCWrapper; +0 (WorkFlowQueueListener.java:543)

com/sterlingcommerce/woodstock/workflow/queue/WorkFlowQueueListener.run()V+0 (WorkFlowQueueListener.java:481)

com/sterlingcommerce/woodstock/workflow/queue/WorkFlowQueueListener.onMessage (Lcom/sterlingcommerce/woodstock/workflow/WorkFlowContext;)V+0 (WorkFlowQueueListener.java:436)

com/sterlingcommerce/woodstock/workflow/queue/WorkFlowQueueListener.onMessage (Lcom/sterlingcommerce/woodstock/workflow/queue/wfTransporter;)V+0 (WorkFlowQueueListener.java:431)

com/sterlingcommerce/woodstock/workflow/queue/wfTransporter.run()V+0 (wfTransporter.java:271)

com/sterlingcommerce/woodstock/workflow/queue/BasicExecutor$Worker.run()V+0 (BasicExecutor.java:473)