question

pbbbi-1798 avatar image
0 Votes"
pbbbi-1798 asked 29571163 commented

Intermittent error whilst running ProcessClear on SQL 2019 Tabular

I have an ETL process that clears and processes two tabular cubes each day, using the following command:

 {
   "refresh": {
     "type": "clearValues",
     "objects": [
       {
         "database": "MyCube"
       }
     ]
   }
 }

It is intermittently failing (regardless of which cube it attempts it on) with the following error (this is directly copied and pasted, the spelling mistake is in the actual error):

The Subscription identifier is invalid; it must be unique when subscribing and the identifier of a registerd subscription when unsubscribing.

Does anyone have any idea what might be going wrong?

SSAS Version 15.0.32.50

sql-server-analysis-services
· 13
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hey @pbbbi-1798, Did you got any solution or reason why this error. Please share .. I am facing same issue.

0 Votes 0 ·

No, not yet. I guess a workaround would be to put a restart on the SQL Agent job step that processes the cubes. That may not be an option for you though. I'd still like to know if there is a resolution to this error though. It may be a bug.

0 Votes 0 ·

Hi @pbbbi-1798 , I'm facing the same issue.
Are you running them parallel or sequential?

0 Votes 0 ·

It occurs doing it in parallel or sequential (the ETL framework I use does both). It does not seem to matter.

1 Vote 1 ·

I've changed mine to sequential and didn't have the error yet.
But then again, the error can't be easily replicated.
To be continued I guess...

0 Votes 0 ·

We encounter the same issue when processing SSAS Multidimensional databases in parallel.
not every night, but too often to be good.

running Analysis processing from within an SSIS package

restarting the processing runs without any problem

0 Votes 0 ·
pbbbi-1798 avatar image pbbbi-1798 FilipBouckaert-0707 ·

Interesting. What version are you on?

0 Votes 0 ·

hi, @pbbbi-1798 . have you solved this issue yet? I have the same problem like you did. SQL SERVER version is 2019. Runing the cube with SQL SERVER Agent job . It is so weird that sometimes it failed with the error discription you wrote, but sametime it succeeded 3 days in a row. That's so weird. I suppect it very likely a bug of SQL SERVER 2019, but I can't find anything helpful from SQL SERVER 2019 Cumulative updates. hope you got a solution now.

0 Votes 0 ·

I am still getting the issue intermittently. I put a restart on the SQL Agent step that runs the code which catches it. It's not exactly a resolution but it works.

0 Votes 0 ·

thanks for your feedback. may I ask if restarting SQL Agent service is an one-time-to-go action, or everytime it appears to be an failure there is no other choice but restarting SQL Agent?

0 Votes 0 ·
Show more comments

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered pbbbi-1798 commented

Hi,

I am not sure if this subscription issue came from SSAS ? What kind of subscription do you have ?

What ETL tools are you using in this case?

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I'm not sure what you mean by subscription in this context?

The tool being used to carry out the work is SSIS, using an Analysis Services Execute DDL Task.

0 Votes 0 ·

I mean the subscrition in the error message, never saw something like this before so I ask if you had any subscription related activity

0 Votes 0 ·

No subscriptions. It is just as I described - calling the above code from SSIS to do the process clear. It doesn't happen every time and just re-running the code resolves it. The problem is that this is an unattended overnight process.

0 Votes 0 ·