Process Flow exception: Invalid SqlDataSource object

Question

question

Marcello Rosadini asked Dec 13, '16 Sam Stubbs answered Dec 13, '16

Process Flow exception: Invalid SqlDataSource object

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

Software Version:

FlexSim 16.2.2

process flow exception exceptions

subflow-transporte.fsm (27.0 KiB)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2016-12-13T14:41:21Z

Sam Stubbs answered Dec 13, '16

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.

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

question