AnswerHub Upload Issue
Our AnswerHub community currently has a bug that prevents you from attaching your model or other files to your questions. AnswerHub is aware of this issue and they are working on a fix. Until we receive their patch, you can upload your models and other files to FlexSim's file share site. Include the file name in your question so that we know which upload to reference.

question

Marcello Rosadini avatar image
0 Likes"
Marcello Rosadini asked Sam Stubbs answered

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

FlexSim 16.2.2
process flowexceptionexceptions
5 |100000

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

1 Answer

·
Sam Stubbs avatar image
0 Likes"
Sam Stubbs answered

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

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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