I have tried to process a datamining structure in SQL Server 2005 (Developer
Edition) but I receive these messages from Sql Server :
"Errors in the high-level relational engine. A connection could not be
made to the data source with the DataSourceID of 'Dbjao', Name of
'Dbjao'."
"Errors in the OLAP storage engine: An error occurred while the
dimension, with the ID of 'MCredito ~MC-Id', Name of 'MCredito ~MC-Id'
was being processed."
"Errors in the OLAP storage engine: An error occurred while the 'Class'
attribute of the 'MCredito ~MC-Id'
dimension from the 'CreditoAleman' database was being processed."
I generate this model from a relational table and can explore this
table
and build and deploy the project
But I receive these error message when I try to process the mining
structure
Do you have any idea which is the problem ?
Best Whish
Juan AlvaradoThis usually occurs when theres a type conversion issue. Check the datatype of the "Class" attribute both in your datasource, the DSV type, and the Mining Structure bindings - you'll have to dig into the properties of the columns for the DSV and the Mining Structure.|||Firstly, check the impersonation information tab on your data source object (Dbjao). You might have set it to use the credentials of the current user or a specific user/password. This info is used when you're exploring data using this data source in the designer and when you use the data source in a prediction query. However, during processing, the server uses the service account credentials to connect to the data source. Confirm that the service account that your Analysis Services instance is running under has access to the database specified in the data source. That's likely the reason you're seeing this error.
No comments:
Post a Comment