Does anyone know why I sometimes get this error on my Infor Lawson queries in IPA? Return message: Error while parsing data returned 0 >= 0
It happens often and generally if I rerun the flow, it works. Sometimes I have to restart it a couple times before it will eventually work. It happens in a variety of flows but it is always on the Lawson query node.
Here is the error in full:
Activity name:Query7100 id:1 started @ 01/26/2017 08:15:11.157 AM
S3 Query Query7100: Executing S3 query: PROD=GEN&FILE=QUEUEDJOB&FIELD=JOBNAME;USERNAME;STATUS;ACTSTARTDATE;JOBQUEUE;PRODUCTLINE;USERID;JOBNUMBER&SELECT=STATUS=34|STATUS=35|STATUS=31|STATUS=33&OUT=CSV&DELIM=~, host: https://chslwpweb.intra.chs-mi.com, web user: lawson, ejb user: lawson
Activity name:Query7100 id:1 failed @ 01/26/2017 08:15:11.248 AM
S3 query java.lang.Exception: Error while parsing data returned 0 >= 0
at com.lawson.bpm.database.dme.DmeQuery.doQuery(DmeQuery.java:181)
at com.lawson.bpm.processflow.workFlow.flowGraph.FgaProcessQuery.startActivity(FgaProcessQuery.java:405)
at com.lawson.bpm.processflow.workFlow.flowGraph.FgActivity.execute(FgActivity.java:946)
at com.lawson.bpm.processflow.workFlow.flowGraph.FgProcess.run(FgProcess.java:2194)
at com.lawson.bpm.eprocessserver.grid.ExecuteFlowImpl.executeFlow(ExecuteFlowImpl.java:425)
at com.lawson.bpm.eprocessserver.grid.ExecuteFlowImpl.executeFlow(ExecuteFlowImpl.java:160)
at com.lawson.bpm.eprocessserver.grid.ExecuteFlowImpl.executeFlow(ExecuteFlowImpl.java:143)
at com.lawson.bpm.eprocessserver.ProcessFlowEngine.execute(ProcessFlowEngine.java:150)
at com.lawson.bpm.eprocessserver.ProcessFlowEngine.startProcessAt(ProcessFlowEngine.java:101)
at com.lawson.bpm.eprocessserver.KBConnection.startProcess(KBConnection.java:173)
at com.lawson.bpm.eprocessserver.KBConnection.execute(KBConnection.java:143)
at com.lawson.bpm.eprocessserver.KBConnection.run(KBConnection.java:123)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
: Exception {1}
Terminating the process ...
Thanks!
