To homepage To homepage
Solved

The stream does not have an active operation

  • 13 November 2023
  • 5 replies
  • 141 views
christian.koeken
Rank
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
1 Attachment

5 replies

rory.smith
Rank
Userlevel 5
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?

Christian Hauggaard
Rank
Userlevel 6
Badge +5

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

christian.koeken
Rank
Badge

Hi @Christian Hauggaard ,

Yes, I have setup retries. 

Retries: 3

Retries per step: 3

Retries delay in minutes: 2

 

Christian Hauggaard
Rank
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?

 

Christian Hauggaard
Rank
Userlevel 6
Badge +5

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

Reply


Terms and ConditionsCookie settings