In IPA LawsonQuery doesn't return the second page of data for a Data Service call to APCINVOICE

I have a Lawson Query node that accesses the APCINVOlCE table. Generally it works fine but the other day it failed. When I looked at the node detail it appeared to fail on the 2nd page of the call and returned no records. The query should have returned over 1000 records and is set to send back 50 records for page. The second page didn't error but returned no records and a RECORD_COUNT = 0. I have no clue why it would do this other than the size of the query was over 1000 and most other queries are less than 100. I have seen it return multiple pages without a problem.

Any clue what went wrong?
Also, how do you set the records per page in IPA since I can't find it in the node?

Here is the first and second calls and the returned variables:

1st Call (correct)

S3 Query LwsnQuery9800: Executing S3 query: PROD=GHSE&FILE=APCINVOICE&FIELD=VENDOR;INVOICE&SELECT=AUTH-CODE=CON&OUT=CSV&DELIM=&MAX=50&NEXT=true, host: xxxxxxxxxxxxxxx.net:444, web user: xxxxxxxxxx, ejb user:
LwsnQuery9800_errorCode = 0
LwsnQuery9800_informationCode = 0
LwsnQuery9800_returnMessage = Query completed.
LwsnQuery9800_outputData =
LwsnQuery9800_currentPage = 1
LwsnQuery9800_complete = false
LwsnQuery9800_recordCount = 50
LwsnQuery9800_hasNext = true

2nd call (returns no records, incorrect)
Query:LwsnQuery9800 Retrieving next page 2
S3 Query LwsnQuery9800: Executing S3 query: DELIM=%7E&PROD=GHSE&MAX=50&FIELD=VENDOR%3BINVOICE&NEXT=true&FILE=APCINVOICE&SELECT=AUTH-CODE%3DCON&OUT=CSV&BEGIN=910=+++++1143=spaces=661156214=0, host: xxxxxxxxxxxxxxxxxxx:444, web user: xxxxxxxxxx, ejb user:
LwsnQuery9800_errorCode = 0
LwsnQuery9800_informationCode = 0
LwsnQuery9800_returnMessage = S3 Query LwsnQuery9800: No of records returned 0
LwsnQuery9800_outputData =
LwsnQuery9800_currentPage = 2
LwsnQuery9800_complete = true
LwsnQuery9800_recordCount = 0
LwsnQuery9800_hasNext = false
Activity completed
LwsnQuery9800_RECORD_COUNT = 0
Activity completed

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

unknown

I'm not sure about what went wrong, but based on the query you should be able to edit the records per page by changing the MAX=50 to whatever number you are looking for. That would be query to query though and not a global setting.

unknown

Hi, did you confirm whether there are records in APCINVOICE with a key greater than the key in the 2nd call (910=+++++1143=spaces=661156214=0) that have an AUTH-CODE equal to CON?

unknown

PS… The MAX= is what is setting the page size.

unknown

I know how the service works. I need to know how IPA sets the MAX

HR Talent; v2024.10 RT Introducing Benefits Health Coverage (ACA) Compliance Documents Recording.mp4

unknown

Hi, there is no place in the Lawson Query node's builder utility to set the MAX that I can see... The data service call syntax has some parms that the builder utility does not seem to give you the option to set. I just add them to the query string after I am done with the builder. For example, if you create a query with the builder and add "MAX=50" to the string, without the "NEXT=" parm, the query would just stop after 50 records. The builder doesn't put either of those parms in for you, you have to type them both into the string.

Copyright © 2025 Infor. All rights reserved.