Solved

The stream does not have an active operation

  • 13 November 2023
  • 5 replies
  • 182 views

Badge

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

 

icon

Best answer by Christian Hauggaard 16 November 2023, 17:21

View original

5 replies

Userlevel 6
Badge +7

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?

Userlevel 6
Badge +5

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

Badge

Hi @Christian Hauggaard ,

Yes, I have setup retries. 

Retries: 3

Retries per step: 3

Retries delay in minutes: 2

 

Userlevel 6
Badge +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?

 

Userlevel 6
Badge +5

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

Reply