When I try and query for backorders of a Global List using List.pull(), I keep getting the following error messages in the System Console
exception: Invalid SqlDataSource object exception: getquerymatchtablerow - invalid row index
Notably, the query is running successfully and returning correct results, but in the process it also produces the following error message. Additionally, in the model in which I first noticed this, I could successfully query backorders on one of my Global Lists, but not a different Global List, even when running the exact same FlexScript code to query their backorders (unfortunately, I cannot share that full model).
To try and isolate the cause, I've created a test model (backorder query.fsm) with a brand-new Global List. The following is the code that I'm using to test this.
List testList = List("List1");
//Create backorder
testList.pull("WHERE 0", 4, 1, nullvar, nullvar);
//Get all backorders
List.PullResult test = testList.pull("WHERE 1", 4, 1, nullvar, nullvar, LIST_PULL_BACK_ORDERS + LIST_DO_NOT_FULFILL);
return test;
In 18.2.0, the error occurs every single time I run that code from the Script window. In 19.0.0, the error never occurs with that test model. In 20.1.0, the error always occurs at first, but if I open the Global List and click "Apply" it stops happening.
What is causing these error messages? Since the query is otherwise working correctly, is there a way to suppress the error messages?
