Showing posts with label love. Show all posts
Showing posts with label love. Show all posts

Wednesday, March 21, 2012

Deployment Error with AS2005

Hey guys,

Love this forum, it has helped so much so far!!

Im new to using Analysis services, although i have experience with OLAP cubes. I have desinged my own cube and when i go to deploy it to the analysis server, i am getting the following errors: Could anyone please help me out!!! I think the errors 2-4 relate back to the first error. I have tried searching MSDN and Google, but i cannot find anything!!!

Thanks.. Scotty

Error 1 Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Could not load file or assembly 'System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Access is denied.. 0 0

Error 2 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Movex', Name of 'Movex'. 0 0


Error 3 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'System Calendar', Name of 'System Calendar' was being processed. 0 0


Error 4 Errors in the OLAP storage engine: An error occurred while the 'Year' attribute of the 'System Calendar' dimension from the 'Gates Australia Sales Analysis' database was being processed. 0 0


What provider are you using to connect to relational database?

What is your relataional database? What version?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I met the same problem as your Error 2. After I changed the data source properties > connection string and point to the correct server name, i managed to process all my cubes sql

Deployment Error with AS2005

Hey guys,

Love this forum, it has helped so much so far!!

Im new to using Analysis services, although i have experience with OLAP cubes. I have desinged my own cube and when i go to deploy it to the analysis server, i am getting the following errors: Could anyone please help me out!!! I think the errors 2-4 relate back to the first error. I have tried searching MSDN and Google, but i cannot find anything!!!

Thanks.. Scotty

Error 1 Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Could not load file or assembly 'System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Access is denied.. 0 0

Error 2 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Movex', Name of 'Movex'. 0 0


Error 3 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'System Calendar', Name of 'System Calendar' was being processed. 0 0


Error 4 Errors in the OLAP storage engine: An error occurred while the 'Year' attribute of the 'System Calendar' dimension from the 'Gates Australia Sales Analysis' database was being processed. 0 0


What provider are you using to connect to relational database?

What is your relataional database? What version?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I met the same problem as your Error 2. After I changed the data source properties > connection string and point to the correct server name, i managed to process all my cubes