Can't Add New Report

In Visual Studio when I create a new Report Project, once it's created I go
into Solution Explorer, right click on the "Reports" folder and select "Add
New Report", and I get the following error:
Exception from HRESULT: 0x8013141A
I've re-installed Visual Studio, the .NET framework, and Reporting Services,
and after all that it still gives me the error.
Any suggestions?
Michael BodnarSome DLL is failing to load. The only sure way to diagnose the problem is
to attach a debugger and see what exceptions it's throwing.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Bodnar" <blah@.blah.com> wrote in message
news:eX63pJHWEHA.4064@.TK2MSFTNGP11.phx.gbl...
> In Visual Studio when I create a new Report Project, once it's created I
go
> into Solution Explorer, right click on the "Reports" folder and select
"Add
> New Report", and I get the following error:
> Exception from HRESULT: 0x8013141A
> I've re-installed Visual Studio, the .NET framework, and Reporting
Services,
> and after all that it still gives me the error.
> Any suggestions?
> Michael Bodnar
>|||Can you dump out a list of DLLs that are loaded into the VS process when the
error occurs? You can either use a tool like procexp.exe
(http://www.sysinternals.com/ntw2k/freeware/procexp.shtml) or attach another
instance of VS as a debugger. Using VS, display the Modules window, select
all rows, copy, and paste into a text file.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Bodnar" <blah@.blah.com> wrote in message
news:eX63pJHWEHA.4064@.TK2MSFTNGP11.phx.gbl...
> In Visual Studio when I create a new Report Project, once it's created I
go
> into Solution Explorer, right click on the "Reports" folder and select
"Add
> New Report", and I get the following error:
> Exception from HRESULT: 0x8013141A
> I've re-installed Visual Studio, the .NET framework, and Reporting
Services,
> and after all that it still gives me the error.
> Any suggestions?
> Michael Bodnar
>|||The whole problem was I was trying to install it off a network drive. It
must not have been seeing some files over the network or something, or maybe
some files got corrupt. I installed it with the CD and it works fine now.
"Michael Bodnar" <blah@.blah.com> wrote in message
news:eX63pJHWEHA.4064@.TK2MSFTNGP11.phx.gbl...
> In Visual Studio when I create a new Report Project, once it's created I
go
> into Solution Explorer, right click on the "Reports" folder and select
"Add
> New Report", and I get the following error:
> Exception from HRESULT: 0x8013141A
> I've re-installed Visual Studio, the .NET framework, and Reporting
Services,
> and after all that it still gives me the error.
> Any suggestions?
> Michael Bodnar
>

Can't access reports by server name

I am trying to set up Reporting Services on one of our servers. It is set up
and I can get to the reports by typing in http://localhost/reports but when
I try http://<servername>/reports I get page not found - this also applies
to any files in the default website. I think it is something straight
forward in IIS but I don't what it is - I am a programmer and a bit clueless
with IIS. Regards, Chris.Are you sure your <servername> is where the reports are located? The
<localhost> is an alias for 127.0.0.1 or the local loopback address. It
sounds like I would check to see also if the server has more than one address
on it. The /reports URL may not be listening on the address for <servername>.
Regards,
Norm Hill
"Fresno Bob" wrote:
> I am trying to set up Reporting Services on one of our servers. It is set up
> and I can get to the reports by typing in http://localhost/reports but when
> I try http://<servername>/reports I get page not found - this also applies
> to any files in the default website. I think it is something straight
> forward in IIS but I don't what it is - I am a programmer and a bit clueless
> with IIS. Regards, Chris.
>
>

can't access report through report manager...

Here is what is happening.
I have a working project PROG created using VS.Net. I create a new
project for reports RPTPROJ under PROJ.
I create several reports RPT1.RDL, RPT2.RDL under the new project
RPTPROJ.
Now I start the REPORT MANAGER and create a new folder (MYREPORTS) and
upload all my reports (RDLs) into this new folder. Now when I click on
any of the reports from here, it doesn't show up. Only shows up an
"Action Canceled" message.
Here is the URL, it generates for one of the reports:
http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fRPTPROJ%2fRPT1
But when I goto,
http://localhost/reportserver?%2fPROJ%2fRPTPROJ
I can see all my reports and run them.
Please can someone explain what I should do to run them from the
report manager?
ThanksWhen you publish to the report server in Report Designer, in the project
properties dialog (where you set your URL to the report server), there is a
target folder property. Set that to MYREPORTS. By default it is the
project name, which is why you're getting link s containing /RPTPROJ/RPT1
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roy" <nroy@.iastate.edu> wrote in message
news:ad20302f.0408091310.6e20c373@.posting.google.com...
> Here is what is happening.
> I have a working project PROG created using VS.Net. I create a new
> project for reports RPTPROJ under PROJ.
> I create several reports RPT1.RDL, RPT2.RDL under the new project
> RPTPROJ.
> Now I start the REPORT MANAGER and create a new folder (MYREPORTS) and
> upload all my reports (RDLs) into this new folder. Now when I click on
> any of the reports from here, it doesn't show up. Only shows up an
> "Action Canceled" message.
> Here is the URL, it generates for one of the reports:
> http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fRPTPROJ%2fRPT1
> But when I goto,
> http://localhost/reportserver?%2fPROJ%2fRPTPROJ
> I can see all my reports and run them.
> Please can someone explain what I should do to run them from the
> report manager?
> Thanks|||Lukasz,
I made the changes suggested by you but still the same problem. The URL it shows is:
http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fMYREPORTS%2fRPT1
What am I doing wrong?
nroy@.iastate.edu (Roy) wrote in message news:<ad20302f.0408091310.6e20c373@.posting.google.com>...
> Here is what is happening.
> I have a working project PROG created using VS.Net. I create a new
> project for reports RPTPROJ under PROJ.
> I create several reports RPT1.RDL, RPT2.RDL under the new project
> RPTPROJ.
> Now I start the REPORT MANAGER and create a new folder (MYREPORTS) and
> upload all my reports (RDLs) into this new folder. Now when I click on
> any of the reports from here, it doesn't show up. Only shows up an
> "Action Canceled" message.
> Here is the URL, it generates for one of the reports:
> http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fRPTPROJ%2fRPT1
> But when I goto,
> http://localhost/reportserver?%2fPROJ%2fRPTPROJ
> I can see all my reports and run them.
> Please can someone explain what I should do to run them from the
> report manager?
> Thanks

Can't Access http://MyServer/Reports -- 401 Error

Not sure if this is the place to post this or over at the IIS group so
I'll try both!
Although I've never seen it, I've been told that our Reporting Service
used to work until I changed the permissions on a TOTALLY unrelated
virtual directory and file folder. Using IE, when I try to go to the
site I get that nasty message, "The request failed with HTTP status
401: Unauthorized." I've researched here, looked at several MSDN
knowledge base articles (the ones about negotiating Kerebos logins),
and tried everything else I could think of. Interestingly, when I use
FireFox, I at least get a dialog box asking me for my user name and
password although it doesn't accept login.
Any suggestions would be most appreciated.
Thanks.
RandyIt sounds like it was broken before you made changes but no one knew
about it, and since you were the last one making server changes that
anyone knew about... you got stuck with having to fix something you did
not break.
By default, IIS does not return any 401 message that looks like "The
request failed with HTTP status 401: Unauthorized". IE does not
translate any errors into that, either.
So, I believe you are getting 401 from some non-IIS-related custom
authentication component, in which case you need to identify that
component and obtain configuration support for it. It is important for
you to obtain support from the component having problems and not just
generic assistance because there are unknown details that can be
important.
I did a search on those words, and it appears to come from a .NET
Client. Probably used by the Reporting Service application itself. So
you want to start your questions from them.
FYI: IE skipped to the 401 message because it already automatically
tried several logons over different allowed protocols on your behalf
and decided to stop trying. FireFox assumes you can retry yourself so
it pops up the login. But they both fail to login, of course.
//David
http://w3-4u.blogspot.com
//
EoRaptor013 wrote:
> Not sure if this is the place to post this or over at the IIS group so
> I'll try both!
> Although I've never seen it, I've been told that our Reporting Service
> used to work until I changed the permissions on a TOTALLY unrelated
> virtual directory and file folder. Using IE, when I try to go to the
> site I get that nasty message, "The request failed with HTTP status
> 401: Unauthorized." I've researched here, looked at several MSDN
> knowledge base articles (the ones about negotiating Kerebos logins),
> and tried everything else I could think of. Interestingly, when I use
> FireFox, I at least get a dialog box asking me for my user name and
> password although it doesn't accept login.
> Any suggestions would be most appreciated.
> Thanks.
> Randy

Cant able to exprot data to excel formate

Hi,...

I ma using reproting service tools fpr my reports.

And when I export large data to excel format what i get isSERVER NOT AVALIBLE eroor.

and the same export works fine when the size of data is less.

i want to export 13-17k of rows to excel format...

and i am using 2 GB of Ram.

pls help ...

waiting for ur rply

On the client, in Internet Explorer options, try increasing the size of your Temporary Internet File setting to over 100MB and see if you continue to get the error. If not, then it is related to the size of the temp file that reporting services creates in the temporary internet files in the windows folder.

Cannot view reports, SSRS on Vista

Hello!
I have installed/configured SSRS on a Vista-laptop but I cannot view reports
in IE.
Finally, I got the reportserver running under IIS 7.0.The report works fine
in VS2005 and deployment (finally!!) works fine from the editor.
But the infamous 'rsReportNotReady'-error shows once I try to view a report.
Other strange stuff: When I click on the link "ReportViewer.aspx" IE only
shows the reportServer root-directory. And the same thing happens if I
create a dumb .aspx-file and put into the reportServer/Pages directory.
The installation has been hellish so far, and I have read SO many blogs and
tips but nothing works...
* Yes, I have tried to turn off database snapshot isolation level for the
SSRS-databases
* Yes, I have installed Service Pack 2 (twice)
Im hoping for your help, as I see no path to a solution for this mystery!
Cheers DavidTwo things to try (I have never done this, this is from the newsgroup).
1) Control Panel / User Accounts / Turn User Account Control - off
2) run "%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i
My advice is to try #1 first. I have seen this multiple times. As far as #2,
that I have only seen once in the newsgroup.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <david_sundstrom_sandegard.nospam@.hotmail.com> wrote in message
news:OW%23s1iLbIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Hello!
> I have installed/configured SSRS on a Vista-laptop but I cannot view
> reports in IE.
> Finally, I got the reportserver running under IIS 7.0.The report works
> fine in VS2005 and deployment (finally!!) works fine from the editor.
> But the infamous 'rsReportNotReady'-error shows once I try to view a
> report.
> Other strange stuff: When I click on the link "ReportViewer.aspx" IE only
> shows the reportServer root-directory. And the same thing happens if I
> create a dumb .aspx-file and put into the reportServer/Pages directory.
> The installation has been hellish so far, and I have read SO many blogs
> and tips but nothing works...
> * Yes, I have tried to turn off database snapshot isolation level for the
> SSRS-databases
> * Yes, I have installed Service Pack 2 (twice)
> Im hoping for your help, as I see no path to a solution for this mystery!
> Cheers David|||I managed to get thíngs running by un-installing the whole SQL-server package.
(I believe that I might have had a mix-up of editions installed)
Took me anothier full two hours, but now the thing works!
Thx for helping out!
David
"Bruce L-C [MVP]" wrote:
> Two things to try (I have never done this, this is from the newsgroup).
> 1) Control Panel / User Accounts / Turn User Account Control - off
> 2) run "%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i
> My advice is to try #1 first. I have seen this multiple times. As far as #2,
> that I have only seen once in the newsgroup.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "David" <david_sundstrom_sandegard.nospam@.hotmail.com> wrote in message
> news:OW%23s1iLbIHA.4476@.TK2MSFTNGP06.phx.gbl...
> > Hello!
> >
> > I have installed/configured SSRS on a Vista-laptop but I cannot view
> > reports in IE.
> >
> > Finally, I got the reportserver running under IIS 7.0.The report works
> > fine in VS2005 and deployment (finally!!) works fine from the editor.
> >
> > But the infamous 'rsReportNotReady'-error shows once I try to view a
> > report.
> >
> > Other strange stuff: When I click on the link "ReportViewer.aspx" IE only
> > shows the reportServer root-directory. And the same thing happens if I
> > create a dumb .aspx-file and put into the reportServer/Pages directory.
> >
> > The installation has been hellish so far, and I have read SO many blogs
> > and tips but nothing works...
> >
> > * Yes, I have tried to turn off database snapshot isolation level for the
> > SSRS-databases
> > * Yes, I have installed Service Pack 2 (twice)
> >
> > Im hoping for your help, as I see no path to a solution for this mystery!
> >
> > Cheers David
>
>

Cannot View Reports in Report Manager

Alrighty... This has been a bugger of a pain all day.
We have Enterprise RS on our test server - only the web part. The databases are located on the test sql server, and both servers are more than happy to talk to each other just fine. On the webserver where report manager is, we have tossed the default website and relocated the virtual directories to a different website, which is accesible over the network via an ip address. I can get into the report manager just fine.
Here's the problem: when I click on a report in the report manager, I cannot view the report. Initially the problem was that it would give a 403 access forbidden message, which doesn't make sense since the user was a content manager and full rights were available across the board. Now after several hours of playing it gives an action cancelled, cannot link to the requested webpage error. It gives it on any report, but I can access the report properties just fine. I can get into data sources just fine as well.
Upon reading something in here, I've tried editing the RSWebApplication.config file to change the
<ReportServerUrl>http://TestWWW/ReportServer</ReportServerUrl>
value to
<ReportServerUrl>http://10.1.1.74/ReportServer</ReportServerUrl>
which is the address of the site it should be located at. When I do that and save it, it get's kinda interesting - when I try to view any report, I get a directory listing (with it enabled for the directory) of 10.1.1.74 - /ReportServer/. Then when I click any of the directories, it takes me to 10.1.1.74/ReportServer/ - (note the change in hyphens) which displays all the uploaded files on the report server. If I click on a report, it displays the report!
What the heck is going on? Anyone seen this and fixed it?
- TCorrection: when I said it displayed the report, I spoke too soon. It brings up the window with the standard report bars, but hangs with the green spinning generation graphic.

Cannot view reports but able to see ReportManager from different

My RS was installed on server which is accessed from 2 domains (lets
named Domain1 and Domain2).
Server belongs to Domain1 and RS service has admin privileges on
Domain1 as well. Viewing reports on Domain1 cause no problem. But I
have users in Domain2. They have got RUSER server role to access to RS
with Windows Auth.
When I open reports on Domain2 I could see Report Manager home page,
but when I click report I get "Internet Explorer cannot display the
webpage".
Is it possible to have access from 2 different domains to RS?
Any help appreciate.
Regards,
BartekAre the domains trusted? Does Domain1 trust Domain2?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bartolo" <andrew.osa@.gmail.com> wrote in message
news:44bafaf7-1f58-4387-9014-2bec3a3caaa5@.8g2000hsu.googlegroups.com...
> My RS was installed on server which is accessed from 2 domains (lets
> named Domain1 and Domain2).
> Server belongs to Domain1 and RS service has admin privileges on
> Domain1 as well. Viewing reports on Domain1 cause no problem. But I
> have users in Domain2. They have got RUSER server role to access to RS
> with Windows Auth.
> When I open reports on Domain2 I could see Report Manager home page,
> but when I click report I get "Internet Explorer cannot display the
> webpage".
> Is it possible to have access from 2 different domains to RS?
> Any help appreciate.
> Regards,
> Bartek|||Yes, both domains are trusted.
Bartek
On 4 Kwi, 17:50, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Are the domains trusted? Does Domain1 trust Domain2?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bartolo" <andrew...@.gmail.com> wrote in message
> news:44bafaf7-1f58-4387-9014-2bec3a3caaa5@.8g2000hsu.googlegroups.com...
> > My RS was installed on server which is accessed from 2 domains (lets
> > named Domain1 and Domain2).
> > Server belongs to Domain1 and RS service has admin privileges on
> > Domain1 as well. Viewing reports on Domain1 cause no problem. But I
> > have users in Domain2. They have got RUSER server role to access to RS
> > with Windows Auth.
> > When I open reports on Domain2 I could see Report Manager home page,
> > but when I click report I get "Internet Explorer cannot display the
> > webpage".
> > Is it possible to have access from 2 different domains to RS?
> > Any help appreciate.
> > Regards,
> > Bartek

Cannot view reports after upgrading to SSRS 2005

Hello,

We recently did an "in place" upgrade of SQL Server and SSRS 2000 to 2005.

After the upgrade we cannot view the exisiting reports. (although we can publish new reports using the VS2005 Designer and they show up just fine.)

We have SP2 installed for SSRS2005 and all SPs for SQL are up to date.

When we navigate to an existing report via the reporting services website, the report acts like it is trying to run and then returns and error message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

When we look at the logs we see that the report server cannot initialize the stream from the Catalog table.

aspnet_wp!library!1!08/28/2007-16:52:29:: Call to GetPropertiesAction(/Report Administration/All Process Dates, PathBased).
aspnet_wp!chunks!1!08/28/2007-16:52:29:: i INFO: Returning old chunk for: (fd690975-ec5b-4033-9664-81335e3990c0, 'CompiledDefinition', 0)
aspnet_wp!library!1!08/28/2007-16:52:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Could not initialize stream;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!chunks!1!08/28/2007-16:53:01:: e ERROR: ### SnapshotConverter(fd690975-ec5b-4033-9664-81335e3990c0, True), Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: Call to GetSystemPropertiesAction()

We welcome any suggestions.

Check the XML for those reports that don't work. Possibly the XML was not upgraded properly?

Check this thread for what the XML should be for 2005 reports:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=997796&SiteID=1

|||

We manually extracted an RDL from the Catalog table and examined it. The RDL still has a reference to the 2003 namespace and doesn't appear to have been altered during the upgrade to 2005.

We opened this same RDL in VS2005 and chose NOT to convert the RDL to 2005 and then we republished the report to the server and amazingly enough it works perfectly. (we didn't change anything other than republish the file)

The problem with this method is that we have 600 reports and it will take a while to manually extract each RDL from the Catalog table, open them in VS and then republish to the server.

Is there any sort of automated way to "recompile" all of the reports on the server? It seems like they need a jump start after the conversion to 2005 before they will work.

|||

We were able to create a solution to fix our corrupted reports.

What we did was create an application that would:

1. Read each row of the "Catalog" table.

2. Extract the "Content" field and stream the binary image data to an "ascii" text file. (not "utf-8"?)

3. Connect to the ReportingService.asmx XML web service.

4. Stream-in the newly created ascii RDL file.

5. Publish the text stream using the "SetReportDefinition" method. (apparently converts back to utf-8?)

It took our application about 15 minutes to "republish" 600 reports. The application worked like a charm and our SSRS 2000 reports now work perfectly on SSRS 2005.

This solved the problem of SSRS 2005 not being able to "initialize the stream" after performing an in-place upgrade from SSRS 2000.

"Good Luck" to anyone facing the same problem!

Cannot view reports after upgrading to SSRS 2005

Hello,

We recently did an "in place" upgrade of SQL Server and SSRS 2000 to 2005.

After the upgrade we cannot view the exisiting reports. (although we can publish new reports using the VS2005 Designer and they show up just fine.)

We have SP2 installed for SSRS2005 and all SPs for SQL are up to date.

When we navigate to an existing report via the reporting services website, the report acts like it is trying to run and then returns and error message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

When we look at the logs we see that the report server cannot initialize the stream from the Catalog table.

aspnet_wp!library!1!08/28/2007-16:52:29:: Call to GetPropertiesAction(/Report Administration/All Process Dates, PathBased).
aspnet_wp!chunks!1!08/28/2007-16:52:29:: i INFO: Returning old chunk for: (fd690975-ec5b-4033-9664-81335e3990c0, 'CompiledDefinition', 0)
aspnet_wp!library!1!08/28/2007-16:52:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Could not initialize stream;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!chunks!1!08/28/2007-16:53:01:: e ERROR: ### SnapshotConverter(fd690975-ec5b-4033-9664-81335e3990c0, True), Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: Call to GetSystemPropertiesAction()

We welcome any suggestions.

Check the XML for those reports that don't work. Possibly the XML was not upgraded properly?

Check this thread for what the XML should be for 2005 reports:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=997796&SiteID=1

|||

We manually extracted an RDL from the Catalog table and examined it. The RDL still has a reference to the 2003 namespace and doesn't appear to have been altered during the upgrade to 2005.

We opened this same RDL in VS2005 and chose NOT to convert the RDL to 2005 and then we republished the report to the server and amazingly enough it works perfectly. (we didn't change anything other than republish the file)

The problem with this method is that we have 600 reports and it will take a while to manually extract each RDL from the Catalog table, open them in VS and then republish to the server.

Is there any sort of automated way to "recompile" all of the reports on the server? It seems like they need a jump start after the conversion to 2005 before they will work.

|||

We were able to create a solution to fix our corrupted reports.

What we did was create an application that would:

1. Read each row of the "Catalog" table.

2. Extract the "Content" field and stream the binary image data to an "ascii" text file. (not "utf-8"?)

3. Connect to the ReportingService.asmx XML web service.

4. Stream-in the newly created ascii RDL file.

5. Publish the text stream using the "SetReportDefinition" method. (apparently converts back to utf-8?)

It took our application about 15 minutes to "republish" 600 reports. The application worked like a charm and our SSRS 2000 reports now work perfectly on SSRS 2005.

This solved the problem of SSRS 2005 not being able to "initialize the stream" after performing an in-place upgrade from SSRS 2000.

"Good Luck" to anyone facing the same problem!

Cannot view reports after upgrading to SSRS 2005

Hello,

We recently did an "in place" upgrade of SQL Server and SSRS 2000 to 2005.

After the upgrade we cannot view the exisiting reports. (although we can publish new reports using the VS2005 Designer and they show up just fine.)

We have SP2 installed for SSRS2005 and all SPs for SQL are up to date.

When we navigate to an existing report via the reporting services website, the report acts like it is trying to run and then returns and error message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

When we look at the logs we see that the report server cannot initialize the stream from the Catalog table.

aspnet_wp!library!1!08/28/2007-16:52:29:: Call to GetPropertiesAction(/Report Administration/All Process Dates, PathBased).
aspnet_wp!chunks!1!08/28/2007-16:52:29:: i INFO: Returning old chunk for: (fd690975-ec5b-4033-9664-81335e3990c0, 'CompiledDefinition', 0)
aspnet_wp!library!1!08/28/2007-16:52:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Could not initialize stream;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!chunks!1!08/28/2007-16:53:01:: e ERROR: ### SnapshotConverter(fd690975-ec5b-4033-9664-81335e3990c0, True), Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: Call to GetSystemPropertiesAction()

We welcome any suggestions.

Check the XML for those reports that don't work. Possibly the XML was not upgraded properly?

Check this thread for what the XML should be for 2005 reports:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=997796&SiteID=1

|||

We manually extracted an RDL from the Catalog table and examined it. The RDL still has a reference to the 2003 namespace and doesn't appear to have been altered during the upgrade to 2005.

We opened this same RDL in VS2005 and chose NOT to convert the RDL to 2005 and then we republished the report to the server and amazingly enough it works perfectly. (we didn't change anything other than republish the file)

The problem with this method is that we have 600 reports and it will take a while to manually extract each RDL from the Catalog table, open them in VS and then republish to the server.

Is there any sort of automated way to "recompile" all of the reports on the server? It seems like they need a jump start after the conversion to 2005 before they will work.

|||

We were able to create a solution to fix our corrupted reports.

What we did was create an application that would:

1. Read each row of the "Catalog" table.

2. Extract the "Content" field and stream the binary image data to an "ascii" text file. (not "utf-8"?)

3. Connect to the ReportingService.asmx XML web service.

4. Stream-in the newly created ascii RDL file.

5. Publish the text stream using the "SetReportDefinition" method. (apparently converts back to utf-8?)

It took our application about 15 minutes to "republish" 600 reports. The application worked like a charm and our SSRS 2000 reports now work perfectly on SSRS 2005.

This solved the problem of SSRS 2005 not being able to "initialize the stream" after performing an in-place upgrade from SSRS 2000.

"Good Luck" to anyone facing the same problem!

Cannot view http://webserver/Reports/Pages/Folder.aspx page from my system

Hi,
I am trying to view http://webserver/Reports/Pages/Folder.aspx page that resides on my collegues system as he has got SQL Reporting Services installed on it, but what all i can see is the title 'SQL Server Reporting Services' and 'Home' written on it. I am not able to view tabs like 'Contents', 'properties' which my collegue can when he browses for the page from his system.

Is there any problem with the rights. Please suggest how can I view these options like 'Contents' etc.

Ashu

Report server out of the box only gives local admins any rights. All other rights must be granted by a local admin.

Have a local admin click on the properties tab on the home page and then on the security tab. From there they can add new users and give them the desired permissions.

You can find more information on the predefined roles here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_security_v1_01h4.asp

cannot upload reports: pls help

Hi,
I just installed reporting service on a new box and it contains SQL server
2000 also. But, when I get into the manager screen, the options such as New
folder, Upload files etc are all disabled. The hyperlink appears but nothing
happens when i click on them..
Any suggestions?
Thanks in advance for your help.
-sDid you ever figure this out? I too have the same problem.
Thanks.
"San" wrote:
> Hi,
> I just installed reporting service on a new box and it contains SQL server
> 2000 also. But, when I get into the manager screen, the options such as New
> folder, Upload files etc are all disabled. The hyperlink appears but nothing
> happens when i click on them..
> Any suggestions?
> Thanks in advance for your help.
> -s
>
>

cannot start report server on local computer

HI,

I tried to deploy reports on locahost. Yet, I still need to start the mssqlserver service on local computer. I tried all the possibilities shown from the help but still i can't have it started. How will i start mssqlserver service on local computer alone?

thanks

soWillingToLearn,

What are your settings for the msSQLserver service LogOn? Can you check your application log file under Event Viewer to see what error message is being generated.

Ham

Cannot restore database

I have a couple of sql servers 2000 enterprise edition, that are giving me
trouble when I want to restore some databases. The server reports that the
database is in use but when I check using sp_who the specific databases are
not in use. The problem is solved when the server is stopped and restrated,
but I cannot imagine that this is the solution.
One server is an enterprise edition sp3
the other is a virtual server part of a win2000 cluster also sp3.
any ideas?
Thanks.
Ahmad El-Kays
Systems Developer
Maritz Canada Inc.
elkaysaz@.maritz.com
aelkays@.hotmail.comHow are you performing the restore? Via Query Analyzer or
Enterprise Manager?
In QA, make sure that you are not in the database your are
trying to restore. This is seen by the pull down menu. You
should choose to be in the master database.
In EM, do not select the database you are restoring. You
can right click on 'database' without expanding the tree
or expand the tree and right click on the master database
and choose to do the restore.
HTH
DeeJay
>--Original Message--
>I have a couple of sql servers 2000 enterprise edition,
that are giving me
>trouble when I want to restore some databases. The server
reports that the
>database is in use but when I check using sp_who the
specific databases are
>not in use. The problem is solved when the server is
stopped and restrated,
>but I cannot imagine that this is the solution.
>One server is an enterprise edition sp3
>the other is a virtual server part of a win2000 cluster
also sp3.
>any ideas?
>Thanks.
>
>Ahmad El-Kays
>Systems Developer
>Maritz Canada Inc.
>elkaysaz@.maritz.com
>aelkays@.hotmail.com
>
>.
>|||This is not the case. The database is not used at all. when sp_who is run
the database does not show up in the list at all. and YES the restore is
done in QA in the master db!
"DeeJay Puar" <deejaypuar@.yahoo.com> wrote in message
news:0dad01c368bc$d3b0b720$a301280a@.phx.gbl...
> How are you performing the restore? Via Query Analyzer or
> Enterprise Manager?
> In QA, make sure that you are not in the database your are
> trying to restore. This is seen by the pull down menu. You
> should choose to be in the master database.
> In EM, do not select the database you are restoring. You
> can right click on 'database' without expanding the tree
> or expand the tree and right click on the master database
> and choose to do the restore.
> HTH
> DeeJay
> >--Original Message--
> >I have a couple of sql servers 2000 enterprise edition,
> that are giving me
> >trouble when I want to restore some databases. The server
> reports that the
> >database is in use but when I check using sp_who the
> specific databases are
> >not in use. The problem is solved when the server is
> stopped and restrated,
> >but I cannot imagine that this is the solution.
> >
> >One server is an enterprise edition sp3
> >the other is a virtual server part of a win2000 cluster
> also sp3.
> >
> >any ideas?
> >
> >Thanks.
> >
> >
> >Ahmad El-Kays
> >Systems Developer
> >Maritz Canada Inc.
> >elkaysaz@.maritz.com
> >aelkays@.hotmail.com
> >
> >
> >.
> >

Cannot resolve the collation conflict between

Hi
Your report's query contains JOIN on varchar/nvarchar columns which have
different collation
Try
select * from table join anothertable on table.col =anothertable.column
COLLATE danish_norwegian_ci_as
"H.Gjerde" <hg@.norspace.no> wrote in message
news:%23zJ%23Lv5PHHA.2468@.TK2MSFTNGP06.phx.gbl...
> Hi
> I have a new DB, in this new DB I have import and copy some data from the
> old DB, among others, a report
> When i try to open the report, I get this message
> - Cannot resolve the collation conflict between
> "SQL_Latin1_General_CP1_CI_AS" and "danish_norwegian_ci_as" in the equal
>
> Any ideas.
> Thanks
>
Hi
I have no idea. I don't know Crystal Report
"H.Gjerde" <hg@.norspace.no> wrote in message
news:eeyQ5F6PHHA.3344@.TK2MSFTNGP02.phx.gbl...
> Thank you
> It help, in my plain sql script
> But I stil have the problem, because I not realy sure where to put it in
> my CrystalReport. The report is predefined.
> ...? :|
>
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uHN$g25PHHA.3268@.TK2MSFTNGP03.phx.gbl...
>
|||can you create SP and call it in Crystal Report
Regards
Amish shah
http://shahamishm.tripod.com
On Jan 24, 3:31 pm, "Uri Dimant" <u...@.iscar.co.il> wrote:[vbcol=seagreen]
> Hi
> I have no idea. I don't know Crystal Report
> "H.Gjerde" <h...@.norspace.no> wrote in messagenews:eeyQ5F6PHHA.3344@.TK2MSFTNGP02.phx.gbl. ..
>
>
>
>