Symptom

When using File System storage as the default storage option for services and adapters, errors are reported in the wf.log and visibility.log.

While using services and adapters storing to the File system as default the wf.log shows:

[2009-12-07 13:00:28.334] ERROR 000110010887 WORKFLOW.WORKFLOW.ERR_Document_updateAfterAppend [Document.updateAfterAppend()]
[2009-12-07 13:00:28.334] ERROR SQL Error Code: -99999
[2009-12-07 13:00:28.334] ERROR SQL State: null
com.ibm.db2.jcc.a.SqlException: Invalid argument: parameter index 4 is out of range.
at com.ibm.db2.jcc.a.id.e(id.java:3089)
at com.ibm.db2.jcc.a.id.d(id.java:3082)
at com.ibm.db2.jcc.a.id.b(id.java:887)
at com.ibm.db2.jcc.a.id.setString(id.java:879)
at com.sterlingcommerce.woodstock.workflow.Document.updateRAFInfo(Document.java:328 2)
at com.sterlingcommerce.woodstock.workflow.RandomAccessFileWrapper.close(RandomAcce ssFileWrapper.java:48)
at com.sterlingcommerce.woodstock.cdinterop.impl.serverImpl.IRandomAccessFileImpl.c lose(IRandomAccessFileImpl.java:77)
at com.sterlingcommerce.woodstock.cdinterop.impl.serverImpl.DocumentReadingConduitI mpl$DocRAF_FSReader.read(DocumentReadingConduitImpl.java:262)
at com.sterlingcommerce.woodstock.cdinterop.impl.serverImpl.DocumentReadingConduitI mpl.read(DocumentReadingConduitImpl.java:113)
at com.sterlingcommerce.woodstock.cdinterop.impl.serverImpl.TwoWayDocumentConduitIm pl.read(TwoWayDocumentConduitImpl.java:160)
at com.sterlingcommerce.woodstock.cdinterop.impl.serverImpl.copy.CopyHandler.read(C opyHandler.java:212)
at com.sterlingcommerce.cd.oemglue.GISFileSystem.read(GISFileSystem.java:216)
at com.sterlingcommerce.cd.oemglue.GISDataMgr.fillBuffer(GISDataMgr.java:301)
at com.sterlingcommerce.cd.oemglue.GISDataMgr.getNextLine_New(GISDataMgr.java:469)< br /> at com.sterlingcommerce.cd.oemglue.GISDataMgr.getNextLine(GISDataMgr.java:341)
at com.sterlingcommerce.cd.cdjava.ACdCopier.readTextRec(ACdCopier.java:268)
at com.sterlingcommerce.cd.cdjava.ACdCopier.sendData(ACdCopier.java:1242)
at com.sterlingcommerce.cd.cdjava.CdCopier.sendData(CdCopier.java:2671)
at com.sterlingcommerce.cd.cdjava.CdCopier.send(CdCopier.java:2602)
at com.sterlingcommerce.cd.cdjava.CdPnApi.copy(CdPnApi.java:1236)
at com.sterlingcommerce.cd.cdjava.CdPnApi.copy(CdPnApi.java:928)
at com.sterlingcommerce.cd.cdjava.CdPnApi.copy(CdPnApi.java:980)
at com.sterlingcommerce.cd.cdjava.CdPnApi.copy(CdPnApi.java:1108)
at com.sterlingcommerce.cd.oemglue.CopyStep.execute(CopyStep.java:392)
at com.sterlingcommerce.cd.oemglue.PnodeSessionMediator.execute(PnodeSessionMediato r.java:332)
at com.sterlingcommerce.woodstock.cdinterop.impl.serverImpl.PNodeConnection.execute (PNodeConnection.java:284)
at com.sterlingcommerce.woodstock.cdinterop.impl.serverImpl.CDServer.copyTo(CDServe r.java:1792)
at com.sterlingcommerce.woodstock.services.cdinterop.server.CDServerAdapterLittleAI mpl.copyTo(CDServerAdapterLittleAImpl.java:291)
at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav a:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)< br /> at java.lang.Thread.run(Thread.java:534)

in visibiliy.log:

[2009-12-07 14:50:28.176] ERROR 000000000000 GLOBAL_SCOPE DmiVisEventWarehouse.Worker.executeStatementsAsExecutor had a SQL exception from pstmnt: PreparedStatementHelper: SQL:
INSERT INTO ACT_NON_XFER (
NON_XFER_ID, SESSION_ID, SESSION_ARCHIVE_ID, START_TIME, END_TIME, WFID, WFSTEP, TYPE, VALUE, IS_SUCCESS, ERROR_MSG )
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Values:
MBIHttpServerAdapterPS1GIS01_126018541660811:324580999-n1,
MBIHttpServerAdapterPS1GIS01_126018541660811:324580999,
324580999,
2009-12-07 14:50:26.316,
2009-12-07 14:50:26.316,
4727703,
1,
processFile,
gisprod01:82c01f:1255ee52df5:-6d93,
1,
null]

[2009-12-07 14:50:28.176] ERROR SQL Error Code: -803
[2009-12-07 14:50:28.176] ERROR SQL State: 23505
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;TCGIS.ACT_NON_XFER
at com.ibm.db2.jcc.a.hd.d(hd.java:1392)
at com.ibm.db2.jcc.c.jb.l(jb.java:366)
at com.ibm.db2.jcc.c.jb.a(jb.java:64)
at com.ibm.db2.jcc.c.w.a(w.java:48)
at com.ibm.db2.jcc.c.dc.c(dc.java:312)
at com.ibm.db2.jcc.a.id.cb(id.java:1685)
at com.ibm.db2.jcc.a.id.d(id.java:2276)
at com.ibm.db2.jcc.a.id.Z(id.java:1295)
at com.ibm.db2.jcc.a.id.execute(id.java:1279)
at sun.reflect.GeneratedMethodAccessor115.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav a:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sterlingcommerce.woodstock.mailbox.db.SQLWrapper.forwardMethod(SQLWrapper.ja va:65)
at com.sterlingcommerce.woodstock.mailbox.db.StatementWrapper.invoke(StatementWrapp er.java:144)
at $Proxy1.execute(Unknown Source)
at com.sterlingcommerce.woodstock.dmi.visibility.db.DmiVisEventWarehouse$1.body(Dmi VisEventWarehouse.java:281)
at com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation._runInTransaction(Da tabaseOperation.java:301)
at com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation.runInTransaction(Dat abaseOperation.java:152)
at com.sterlingcommerce.woodstock.dmi.visibility.db.DmiVisEventWarehouse$Worker.exe cuteStatementsAsExecutor(DmiVisEventWarehouse.java:249)
at com.sterlingcommerce.woodstock.dmi.visibility.db.DmiVisEventWarehouse$Worker.run (DmiVisEventWarehouse.java:228)
at java.lang.Thread.run(Thread.java:534)