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?
