SqlQuery - Unknown error occurred

[sakamoto_koUFFFM]

[ FlexSim 23.0.14 ]

Hi.

I have created a global list with a field using Table.query().

In this model unknownError.fsm, the score field in TEList1 corresponds to this field.

A pull on this list with the query "ORDER BY score DESC(or ASC)" would result in the following error message

time: 5.000000 exception: SqlQuery - Unknown error occurred: 

Creating the TEList2 with similar fields without using Table.query() does not generate this error, even though there is no difference in entries between the two lists.

Is this error due to the fact that I have configured the fields using query?

Thanks in advance.

[jason_lightfootVL7B4 · Accepted solution]

Since you're using this dynamically in a list I'd recommend you instead create a map of scores keyed on the areaType and opeType.

Map scores;
Array key=["a","b"];
scores[key]=1;

Store that on an object somewhere or recreate it at reset in a global variable based on your GlobalTable lookup.