Index Failing with SQL Error Code: -204 SQL State: 42704 com.ibm.db2.jdbc.app.DB2 *FIRST in *N type *MEM not found

Troubleshooting

Problem

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.

Error Message

[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)

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

NFX2781

Was this topic helpful?

Document Information

Modified date:
11 February 2020

UID

swg21560515

Tips

Index Failing with SQL Error Code: -204 SQL State: 42704 com.ibm.db2.jdbc.app.DB2 FIRST in N type *MEM not found