SQL and SSAS and cubes Processing via job

Question

Hello am trying to create a job to process my default/customized cubes however, each time the job runs it gives me this error:
"Message
[136] Job DailyProcesCubes reported: <return xmlns="urn:schemas-microsoft-com:xml-analysis"><results xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults"><root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"><Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception"><Error ErrorCode="3239575556" Description="Either the 'domain\DB$' user does not have permission to process the 'Budget control cube' object, or the object does not exist." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" /></Messages></root></results></return>
"
if I log unto SSAS server and process the cube manually it worked fine. Completes without problem. I want to set it to run automatically because the cubes are to refresh/process every 15 minutes.

And help how to resolve the problem above would be greatly appreciated.

Answer 1

Hi @Lionel Folkes ,

Welcome to Microsoft Q&A!

Description="Either the 'domain\DB$' user does not have permission to process the 'Budget control cube' object, or the object does not exist."

The 'domain\DB$' user don’t have sufficient permission to run cubs. For detailed information, please refer to Grant cube or model permissions (Analysis Services).

Best regards,
Carrin

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi Thanks for your help. I would have done all of this already. I have created a group and allow the group to have full permission to process cube but its still not working. I am also sing the service account..please note this is something that used to work in the past.

Answer 3

Hi @Lionel Folkes ,

I reproduced a similar error and solved by below steps, hope it can help you.

1. Open SQL Server Configuration Manager, check the SQL Server Agent Account Name:
   
2. Add the SQL Server Agent Account Name to Analysis Service Properties - Server administrators:
   
3. Right click the cube which you want to schedule it, and the select Process. Cope the XLMA script:
   
4. Create a job as below:
   
   
5. Success