Skip to main content

Dear Support,

My customer is having some troubles with executing a tabular semantic model. This customer has three semantic models, Finance, Sales and Logistics. Finance and Sales are running fine, but Logistics sometimes give the error "The stream does not have an active operation!”.

I solve this issue by doing a Full process on the model in SQL Management Studio. But what I want to know is what causes this error? As I said Finance and Sales are running fine, but Logistics gives this error now and then.

See the file in the attachment for the error.

 

TimeXtender version: 6346.1

 

Hi @christian.koeken ,

this could be caused by transient network errors among other things. As you have some models that reload without issues, could it be the logistics model is larger than the others?

Hi @christian.koeken perhaps retries can help minimize these transient errors. Have you setup retries in your execution package?

Hi @Christian Hauggaard ,

Yes, I have setup retries. 

Retries: 3

Retries per step: 3

Retries delay in minutes: 2

 

@christian.koeken Following up on Rory’s question, could it be the logistics model is larger than the others? Also, are you using SSAS or Azure Analysis Services Server? Could you please try increasing the timeout on the DW instance that contains the source tables for the tabular Semantic Model?

 

@christian.koeken do you have an update on this?

Reply


Terms and ConditionsCookie settings