Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Error: OLE DB or ODBC error.Errors in the high-level relational engine.


Symptoms

When attempting to deploy and execute the OLAP server within the Jet Data Manager you encounter the following error message:

OLE DB error: OLE DB or ODBC error.Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWH', Name of 'DWH'.Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Customer', Name of 'Customer' was being processed.Errors in the OLAP storage engine: An error occurred while the 'CountryRegionCode' attribute of the 'Customer' dimension from the 'CronusOLAP' database was being processed.Internal error: T

This error is caused by the service "SQL Server Analysis Services" running under a network account that doesn't have proper permissions.

Resolution

To resolve this error ensure the service "SQL Server Analysis Services" is running with a proper Log On As user. This user should have administrator permission on Analysis Services and the proper permissions on the database engine. See the link below for more detailed information regarding how to set the proper permissions.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments