CODEWITHSUNDEEP
ssasolap-cube
user717316
user717316

Reputation: 99

SSAS Cube processing

I have deployed my SSAS solution to production. On the production server, I want to process my cube, but when I right click on the ssas cube and choose "Process", I recieve the follwong error: The 'Database' with 'ID' = 'XXX' doesn't exist in the collection.

Has anyone encountered this error in Microsoft SSAS? If so, can anyone tell me what to do to resove this error ?

Upvotes: 1

Views: 3531

Answers (4)

Sadat Rexhepi
Sadat Rexhepi

Reputation: 11

You can re-deploy the OLAP database from SSDT with a different name and before you do you just need to change the database name and set the Processing Option to Full. You can set these options under Project's Configuration Properties->Deployment.

Upvotes: 1

SSAS developer
SSAS developer

Reputation: 33

it can either be roles or kerberos, I got a similar error when the kerberos authentication wasnt setup in the cube server to interact with database server.

Upvotes: 0

Vincent G
Vincent G

Reputation: 361

I had the exact same problem. I solved it by editing the roles in my SSAS database :

Right Click properties

And then, check the boxes depending on what you want your job to do :

Check boxes

Then, you can process your cubes with your SSIS Jobs.

Upvotes: 0

Daryl Wenman-Bateson
Daryl Wenman-Bateson

Reputation: 3964

Check to see what the Id of the database is by right clicking on the database and selecting properties. Check the equivalent in visual studio and confirm it matches. If you have renamed the analysis services project (maybe for a backup), the id of the database does not get renamed and sometimes gets messed up in the XML file.

Try re-processing the dimensions on their own and then the cube. Failing that, if this is the first process (i.e. the cube is not live), try deleting and redeploying from visual studio.

Upvotes: 1

Related Questions