Error during browsing the cube

Hi,

I have migrated the anaysis service 2000 cubes to 2005.

In the database i have two cubes say A and B and one virtual cube say C.While migrating the virtual cube C got migrated as a real cube with two linked measure groups for the cubes A and B. I have not processed the cube B.But i have processed the cube A.It succeded and i could browse it once .But when i tried browsing the virual cube C (which migrated as real cube with linked measure group) is not available for browsing .This is because i didnt process the cube B whose measure is also present in C.

But the problem is when i tried to browse cube A which i could browse earlier is giving me error when i try to browse it again.

The error which i found is somethinf like this:Error in the OLAP storage engine:The version of the linked measure group with the name of 'A',on the remote instance has changed.Repeat the operation the resolve the issue.

Please help me to solve this issue ASAP.

Thanks in advance

Regards

Latha

Hi Latha. I have received the same error in the same situation from the SQL Manager when writing my own MDX query. I try the query again (as suggested) and it works. You should try a simple MDX query from SQL Manager and see if the same scenario occurs.

Hope this helps.

PGoldy

|||

Hi,

Since it is a migration from AS 2000 to AS 2005 .

I dont want to make any changes in the query and my AS 2000 cube works fine.

Please tell me, is the error because of the unprocessed cube 'C'(virtual cube migrated with linked measures).

Is it enough if i process the cube C along with Cube A?

Regards

Latha

|||

Hi Latha. Yes, processing the cubes should take care of the error you received.

PGoldy

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specifiedProbably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!sql

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specified
Probably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specified
Probably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specified
Probably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!

Error CS2001 & CS2008

After installing and configuring RS June CTP, when attempting to deploy a new report or when browsing http://localhost/reports

I'm getting error:

Error 1 Server was unable to process request. > Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\9a1mhqzb.0.cs' could not be found error CS2008: No inputs specified
Probably ASP.net does not have permissions to the asp.net temporrary files folder.

Try running "aspnet_regiis.exe -ga <username>" from the Windows\Microsoft.Net\Framework\v2.xxxx folder where <username> is replaced with the account that asp.net is to run under. This would mean it is the account set for report server virtual directory application pool (default is Network Service).

-Lukasz|||Hi,

I am having same problem. I tried the solution that Lukasz suggested. i.e. I executed aspnet_regiis.exe -ga "NT AUTHORITY\NETWORK SERVICE" from the command prompt and tried to deploy the report as well as browse http://localhost/Reports and I am still getting CS2001 and CS2008 errors.

How do I find which account is set for report server virtual directory app pool?

I have just used default installation of SQL Server 2005 so I thought NETWORK SERVICE would work. Any ideas?

Regards,
Ketan|||just simply go to c: > windows > temp
right clik and click on properties > Security >
here Click on Add and find out the ASP.Net user, add and then allow full control
and now Debug and run your application again.
it will (Insha Allah) work if this is the problem....enjoy|||You're right this is caused by the permissions on the windows temp folder. You should only need to grant Read, Write, Modify, and Delete, rather than full control.

-Lukasz|||I had a similar issue, but had to add the NETOWRK SERVICE account with the same privileges to the windows\temp directory.|||

This is sometimes required as a manual step when using SQL Server 2000 Reporting Services.

When using SQL 2005 RS, you should be able to use the aspnet_regiss -ga command to grant sufficient rights to the appropriate account.

[revision] Based on comments lower in the thread: You need to ensure the report server has access to the windows\temp folder on the report server computer.

-Lukasz

|||

I tried all three solutions and am still seeing the error. I am using a domain account.

1) aspnet_regiis -ga testdomain\myalias, "NETWORK SERVICE", and "ASPNET"

2) Gave both the ASPNET user and the NETWORK SERVICE Full Control over my C:\WINNT\Temp folder (where the error is showing up)

3) Restarted my application, and still I get the same error.

Could my user context have anything to do with this?

|||

Ok, found out my mistake. This is happening on the web server, not my client where I'm running my test application. Duh... Adding the correct permissions to the C:\Winnt\temp folder on the IIS server did the trick.

Thanks for the 411 everyone.

|||

I also had an similar issue after installation of Microsoft SQL Server 2005 Express Edition with SP1 (needed for Symantec Backup Exec) on an Windows Server 2003 R2 with SP2.

The error at my environement was, that WSUS dont work and displays the CS2001 & CS2008 errors.

It works now fine after given the Network Service Account the standard rights which Windows adds when the Account is added to the list of users in security page.

|||This is an OLD post but I think I'll try anyways...Now I'm getting this error...seems to be server related, not client. Can you let me know the 'minimum' permissions you applied to C:\windows\temp for this? This server is in production so I dont want to jeopardize anything currently running...thanks!

Error connecting Excel to Analysis Service for browsing cube

I have created a cube. Now when I open excel so that to browse the cube in the excel pivot table i am getting connection refused error? I am using olap 9.0 to connect to my cube which is deployed on the sqlserver 2005 analysis server. server is up and running.ok i found the solution. we need to reregister the olap 9.0 provider before we can use it to connect SQL Server 2005 Analysis Service Cube with Excel Pivot Table :
regsvr32 "c:\program files\common files\system\ole db\msolap90.dll"|||

Hi,

I having the similar problem with you. But no sure whether your error message is same with me. Here i get the error message as below:

Connection Failed

SQL State: '28000'

SQL Server Error: 18456

[Microsoft][ODBC SQL Server][SQL Server] Login failed for user 'domain\userida'

I am using olap services 8.0 & sqlserver 2000.

I checked this userida is properly created in the cube under a cube role said 'Accounts'. This role contain of abt 6 user id. Others user id is work fine except for this userida.

Any ideas to solve this issue.

Thanks in advance.

Error browsing cube data

I was trying to browse a cube that i had created. It however tells me its unable to browse cube data. Unspecified error. When i am creating the dimension i cannot also preview the data. How can i have thes resolved?

Are you a new user of Analysis Services. Did you deployed your cube to Analysis Server? What exactly the error you getting?

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

Error browsing Analysis Services Tutorial cube

Hi. I have two instances of SQL Server installed. One is unnamed and refers to a SQL Server 2000 installation. The other one is named PEDRO\SQLDEV2005 and refers to a SQL Server 2005 installation. I was going through the MSAS tutorial and when I was trying to browse the cube the following error occurred:

The query could not be processed: o Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'PEDRO' server. o Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the 'PEDRO' server.

The problem is that my server name isn't PEDRO, but PEDRO\SQLDEV2005. Where do I change the server name?

Pedro Martins

Portugal

The error message is correct. You might be running several instances of Analysis Sever on your machine. But you have a single SQL Browserver service that serves them all.

Try and see if SQL Browser service is started. Do you have connectivity to the Domain controller? There is known issue with accessing named instace is case if domain controller is unavailable.

See if you can connect to Analysis Server using SQL Management studio.

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