Error in Processing Cubes SSAS2005

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.

Error in metadata manager processing sample database/cubes

I've just installed SQL Server 2005 with Analysis Services and the sample AdventureWorks databases. When I try to process the database via SQL Server Management Studio, I get the following error - see below. I did check the xml file referenced by the name of the error and I do see the dimension listed Order Date key but not any attribute called Name of Date. Is there any workaround to enable processing of the database and cubes?

I did bump up to Sp1 and this did not fix my problem. I also tried installing the samples from the downloads section of microsoft.com. Alas, no success.

Any help appreciated,

Mairead

Errors in the metadata manager. The dimension with ID of 'Order Date Key - Dim Time', Name of 'Date' referenced by the 'Adventure Works' cube, does not exist.
Errors in the metadata manager. An error occurred when loading the Adventure Works cube, from the file, '\\?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Adventure Works DW.2.cub.xml'.
(Microsoft.AnalysisServices)

Program Location:

at Microsoft.AnalysisServices.XmlaClient.CheckForException(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Discover(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.Refresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.SendRefresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.MajorObject.Refresh()
at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)
at Microsoft.AnalysisServices.Server.Connect(String connectionString)
at Microsoft.SqlServer.Management.SqlMgmt.CDataContainer.Init(XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.CDataContainer.Init(XmlDocument doc, IServiceProvider site)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDataContainer(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

Here is simple way out of your situation

1. Stop Analysis Service.
2. Delete everything in your D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db folder.
3. Start the service
4. Re-deploy your sample project.

Hope that helps

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

|||

Thanks Edward, I finally did get everything working again by completely uninstalling/reinstalling and redeploying the samples again. I did try your workaround but still could not get the samples processed successfully.

Mairead

Error in Aggregation wizard - AS2005 cubes

Hi,

I got the following error message while i was trying to do the aggregation wizard for SSAS 2005 cubes. I chose the storage setting as MOLAP then in the next screen , when i hit on the count objects, i am getting this error message.

'IBMDADB2.1' failed with no error message available, result code: DB_E_OBJECTOPEN(0x80040E05). (Microsoft Visual Studio)

Please let me know any one has got this error before and hot to fix it?

Thanks

Srinivas

Looks like the failrue is happening at the point where BI Dev studio is trying to count number of members in attributes in your dimensions.

At this point BI Dev studio will issue as query to relational database to get these counts.

You need to make sure you have permissions to access underlineed relational data from BI Dev studio.

As a workaround you can take a look at which attributes are missing counts and you change the EstimatedSize property of the attribute yourself.
If you provide the counts yourself you will be able to advance further in the aggregation design wizard.

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