Error running report: browsing

Showing posts with label browsing. Show all posts

Monday, March 12, 2012

Error when browsing the page http://localhost/reports

I have installed SQL Server Reporting service 2005 and when I am trying to
browse the page http://localhost/reports, it is giving me following error:
System.Web.Services.Protocols.SoapException: Server was unable to process
request. --> System.IO.FileNotFoundException:
C:\WINDOWS\assembly\GAC_32\Microsoft.ReportingServices.Diagnostics\9.0.242.0__89845dcd8080cc91\ReportingServicesNativeServer.dll
at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.GetNativeProductVersion()
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_NativeServerProductVersion()
at
Microsoft.ReportingServices.WebServer.ReportingService2005.ServerInfoHeader..ctor()
at
Microsoft.ReportingServices.WebServer.ReportingService2005.get_ServerInfoHeaderValue() -- End of inner exception stack trace --
SQL Server 2005 is installed on different machine. I am installing SQL
Server Reporting service 2005 on CRM server. I have install/uninstall for a
number of times. Previously, it was working properly and after some
installaion/uninstallation, it has started giving the above error.Just to be sure where is can be the problem (network config, or installation
issue), have you tried to use the IP Address of the machine instead of
localhost?
http://yourip/reports
or
http://127.0.0.1/Reports
Good luck
Braulio
/// --
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// --
"Bhumit" wrote:
> I have installed SQL Server Reporting service 2005 and when I am trying to
> browse the page http://localhost/reports, it is giving me following error:
> System.Web.Services.Protocols.SoapException: Server was unable to process
> request. --> System.IO.FileNotFoundException:
> C:\WINDOWS\assembly\GAC_32\Microsoft.ReportingServices.Diagnostics\9.0.242.0__89845dcd8080cc91\ReportingServicesNativeServer.dll
> at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.GetNativeProductVersion()
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_NativeServerProductVersion()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.ServerInfoHeader..ctor()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.get_ServerInfoHeaderValue() -- End of inner exception stack trace --
> SQL Server 2005 is installed on different machine. I am installing SQL
> Server Reporting service 2005 on CRM server. I have install/uninstall for a
> number of times. Previously, it was working properly and after some
> installaion/uninstallation, it has started giving the above error.
>|||Another thing to do is go to your Reporting Services Configuration Tool and
make sure all your Settings are pointing to the correct location. I found
this area to be extremely sensitive.
"Braulio Diez" wrote:
> Just to be sure where is can be the problem (network config, or installation
> issue), have you tried to use the IP Address of the machine instead of
> localhost?
> http://yourip/reports
> or
> http://127.0.0.1/Reports
> Good luck
> Braulio
> /// --
> /// Braulio Diez
> ///
> /// http://www.tipsdotnet.com
> /// --
>
>
> "Bhumit" wrote:
> > I have installed SQL Server Reporting service 2005 and when I am trying to
> > browse the page http://localhost/reports, it is giving me following error:
> >
> > System.Web.Services.Protocols.SoapException: Server was unable to process
> > request. --> System.IO.FileNotFoundException:
> > C:\WINDOWS\assembly\GAC_32\Microsoft.ReportingServices.Diagnostics\9.0.242.0__89845dcd8080cc91\ReportingServicesNativeServer.dll
> > at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.GetNativeProductVersion()
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_NativeServerProductVersion()
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005.ServerInfoHeader..ctor()
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005.get_ServerInfoHeaderValue() -- End of inner exception stack trace --
> >
> > SQL Server 2005 is installed on different machine. I am installing SQL
> > Server Reporting service 2005 on CRM server. I have install/uninstall for a
> > number of times. Previously, it was working properly and after some
> > installaion/uninstallation, it has started giving the above error.
> >
> >

Error when browsing the cube

I installed Analysis Services and then I installed
SP3 for SqlServer2k and
SP3 for Analysis Services
But I am still getting an error when browsing the cube
Errors like
"Provider not found. not properly installed
and then
"Unspecified error"
and some times
"Unable to connect to the registry on the server you are not a member of olap administartors group on this server"
Any help/suggestions?
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
We create a single user/group, add the user/group to the olap admin
group via Control Pannel-->Admin Tools-->Comp Mgmt-->Local Users and
Groups-->Olap Administrators
SqlJunkies User wrote:
> *I installed Analysis Services and then I installed
> SP3 for SqlServer2k and
> SP3 for Analysis Services
> But I am still getting an error when browsing the cube
> Errors like
> "Provider not found. not properly installed
> and then
> "Unspecified error"
> and some times
> "Unable to connect to the registry on the server you are not a member
> of olap administartors group on this server"
> Any help/suggestions?
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup
> engine supports Post Alerts, Ratings, and Searching. *
RaiderD
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message479867.html

Error when browsing the cube

quote:
Originally posted by SqlJunkies User
I installed Analysis Services and then I installed
SP3 for SqlServer2k and
SP3 for Analysis Services
But I am still getting an error when browsing the cube
Errors like
"Provider not found. not properly installed
and then
"Unspecified error"
and some times
"Unable to connect to the registry on the server you are not a member of ola
p administartors group on this server"
Any help/suggestions?
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post A
lerts, Ratings, and Searching.

Error when browsing processed Cube

Hi,

I get an error after making calculation changes to a cube.The AS solution builds and processes fine, but when I browse to the region of the cube where the MDX change has impacted I get the following error: "An Error 0xE0040200 occurred. No Further information was provided." The popup box is titled as: Microsoft Pivottable List. I've got this same error on my PC running the September CTP, and a development server running the RTM.

i.e. if I change the following working piece of MDX in a calc

Aggregate(

{ [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc BSC Time Dim Calculations].DefaultMember } * PeriodsToDate( [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember.Level, [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember )

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

I also get this error when the browser shows a three level time dimension (Year / Period / Week) on the rows and a Cumulative dimension with three members (Total / YTD / PTD) on the columns. The common denominator with the original error reported is the use of the PeriodsToDate function which is used in the two calculated members YTD and PTD shown below:

CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[YTD]
AS Sum(PeriodstoDate([d Time].[Time].[Year],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[PTD]
AS Sum(PeriodstoDate([d Time].[Time].[Period],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

There appears to be nothing wrong with the cube since I can view it through Panorama Novaview with no problem. The view that causes the error in the Visual Studio browser can be produced without error.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I was also getting this error when using the Visual Studio SQL2005 Ananlysis Service project cube browser. But when I use MDX query in Microsoft SQL Server Management Studio and then browse the given cube and caluclated members and hand write the code in I don't get the error.

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error when browsing processed Cube

Hi,

i.e. if I change the following working piece of MDX in a calc

Aggregate(

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error when browsing processed Cube

Hi,

i.e. if I change the following working piece of MDX in a calc

Aggregate(

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error when browsing processed Cube

Hi,

i.e. if I change the following working piece of MDX in a calc

Aggregate(

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error when browsing processed Cube

Hi,

i.e. if I change the following working piece of MDX in a calc

Aggregate(

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error when browsing processed Cube

Hi,

i.e. if I change the following working piece of MDX in a calc

Aggregate(

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error when browsing processed Cube

Hi,

i.e. if I change the following working piece of MDX in a calc

Aggregate(

)

to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

Error when browsing data

Hi Guys,
I am novice to AS. I install the Analysis Services to my Windows 2000 Professional. But in the places where to display or browsing data, it always encounters an Unspecific Error. For example:
a) In a cube - HR, if i select Browsing Data menu, the error 'Unspecific Error' displayed.
b) In a Dimensions, select Brows Dimensions Data, the error message in the windows said: Unable to brows the Dimension '*******', Unspecific Error.

Please help me to fix this problem
Thanks
PatrickMore info.:
The error happens at first time on clicking the data tab, the error message said:
'Provider cannot be found. It may not be properly installed'
I am not sure which Provider should i install?
Thanks|||Bug Fixed by installing the SQL Service SP

Monday, March 12, 2012

Error when browsing the page http://localhost/reports

Error when browsing the cube

Error when browsing the cube

Error when browsing processed Cube

Error when browsing processed Cube

Error when browsing processed Cube

Error when browsing processed Cube

Error when browsing processed Cube

Error when browsing processed Cube

Error when browsing processed Cube

Error when browsing data

Error running report

Blog Archive

About Me