Intermittent Cube Processing Errors

• PhilT

  Valued Member

  Points: 62

  More actions

  October 18, 2023 at 7:13 am

  #4310235

  Hey guys,

  We are having issues when we process our cubes overnight. Eventually, they complete, sometimes after multiple re-tries, sometimes first time!, but often they will fail with the following error message:

  "Access is denied. ..An error occurred while parallel saving VertiPaq data objects for Schema...."

  Has anyone had anything similar?

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  October 19, 2023 at 8:10 am

  #4310961

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Chrissy321

  SSCoach

  Points: 15763

  More actions

  November 28, 2023 at 9:35 pm

  #4336242

  How are you issuing the processing command? Are you using a SQL Server job with Type: SQL Services Analysis Services Command?

  I dimly recall that error but I haven't seen it lately. I have had better success using TSQL against a linked server.

  DECLARE @XMLA NVARCHAR(MAX) = '{"refresh": {"type": "full","objects": [{"database": "MyDatabase"}]}}'

  EXEC (@XMLA) AT [MyLinkedServer];