Process Flow exception: Invalid SqlDataSource object

[marcello_rosadini]

[ FlexSim 16.2.2 ]

Hi,

I'm getting an error in the first run of a model which includes a subflow to handle a task sequence :

exception: Invalid SqlDataSource object

This has happened other times in models that include a process flow, but it is always just in the first run. Then the model works fine and behaves as expected.

Any hints on how to solve it?

Thanks

subflow-transporte.fsm

[sam_stubbsYXX86 · Accepted solution]

You have a query in your Zone properties. "ORDER BY zonaCarga ASC" You are trying to Order in ascension the tokens in the Zone by the "zonaCarga" label. But your tokens don't have a zonaCarga label. It looks like you have the zonaCarga label on the Operator, but at the point where you enter the zone, you don't have a reference yet in your Process Flow to the Operator. If you can get a reference to the Operator, you could change the "Enter For" field on the token to the Operator, and then you could use queries on the Operator's labels.