I am trying to deploy and process cubes to production server, i got this error with processing failure
Errors in the back-end database access module. OLE DB reported the '' status, which is unknown, for column 1.
So deployment works fine. I have deployed and processed and the same cube to Development and Test server, it goes through pretty well without any errors.
Any one has an idea what this error means?
Thanks
This error means Analysis Server for some reason couldn’t instantiate OLEDB provider to connect to relational database.
Several reasons:
1. For some reason your production sever cannot access relational database. Check Analysis Server service account. Does it have privileges to access relational database?
2. Installation or configuration gone wrong. See if you can fix the problem by re-installaing Analysis Server.
3. Another suggestion for you to use Synchronization functionality to move database from test to production.
Hope that helps
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment