Skip to main content
To homepage To homepage
Solved

The stream does not have an active operation

  • November 13, 2023
  • 5 replies
  • 261 views
christian.koeken
Contributor
Forum|alt.badge.img

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

 

Best answer by Christian Hauggaard

@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?

 

View original
Did this topic help you find an answer to your question?

5 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • rory.smith
  • TimeXtender Xpert
  • 686 replies
  • November 13, 2023

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?

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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

christian.koeken
Contributor
Forum|alt.badge.img

Hi @Christian Hauggaard ,

Yes, I have setup retries. 

Retries: 3

Retries per step: 3

Retries delay in minutes: 2

 

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

@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 Hauggaard
Community Manager
Forum|alt.badge.img+5

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

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings