SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Error in pocessing cubes


Error in pocessing cubes

Author
Message
Avik Roy
Avik Roy
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 56
Hi All,

As part of our migration project our application is migrating from SQL server 2005 SP1(Windows Server 2003) to SQL server 2008 R2(Windows server 2008) - Background

But as per cube processing is concerned it processed by executing a .exe filein old servers and its working fine their with the configuration.

But in the new servers it is not able to execute as it is giving error related to kernel files

When I try to debug it I found a error like below image:

Now the version and all it is referring it is referring it is for like sql server 2005 but currently we have sql server 2008.

And in google I found that this is related to installing some standalone installer packages like ADOMD.NET client package not installed.

Still I am not sure whether installing SQL server 2005 will solve this issue or not but i would definitely would like to know if it can be solved in changing some setting in sql server 2008 or not.

Your help is much appreciated.

Thanks in advance
Attachments
error.jpg (8 views, 11.00 KB)
Ells
Ells
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1218 Visits: 931
Ok
not too clear hear what you are trying to do but

In that error message it refers to Analysis Services 9.0.242.0 . This is 2005 version so that does not look too good.

If you are using 2005 to process 2008 cubes that will not work.

Would need more info on what the exe is doing and which exe

Hope that helps
E
Avik Roy
Avik Roy
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 56
The exe file name is OLAPdriver.exe which is responsible for processing cubes...

I am trying to run cubes built in 2005 in 2008 sql server.

So ,as such there is no issue.

But that exe file is looking for something which is Microsoft Analysis Services SP1 2005 version thats the reason I dont know whether i can make the exe work
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search