Showing posts with label reporting. Show all posts

Thursday, March 29, 2012

Error when trying to save report in pdf

I developed a report using sql server reporting services and the vs.net
designer. Then I wrote another class that downloads the result into
pdf and excel formats. When I run the program, the excel file opens
fine but the pdf says "there was an error opening this document. the
file is damaged and cannot be repaired". I have seen other forums with
the same issue and microsoft is yet to provide an answer to this
problem. Can someone help please? Any suggestions are well appreciated.
Thanks.There are a variety of reasons this could happen. I'd start by first
looking at the Report Server log file and see what exception (if any) occurs
when you render to PDF. Secondly, I'd dump the PDF into notepad and see if
there are any errors embedded at the end of the stream.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<csuman@.gmail.com> wrote in message
news:1130708307.146769.204230@.g49g2000cwa.googlegroups.com...
>I developed a report using sql server reporting services and the vs.net
> designer. Then I wrote another class that downloads the result into
> pdf and excel formats. When I run the program, the excel file opens
> fine but the pdf says "there was an error opening this document. the
> file is damaged and cannot be repaired". I have seen other forums with
> the same issue and microsoft is yet to provide an answer to this
> problem. Can someone help please? Any suggestions are well appreciated.
> Thanks.
>|||I am having the same problem - just upgraded Adobe Reader to 7.0.5.
Looking at the pdf created in NotePad: Starts with
%PDF-1.3%
1 0 obj [/PDF /Text /ImageB /ImageC /ImageI] . . . has a bunch of stuff . . .
"ends" trailer << /Size 10 /Root 8 0 R/Info 9 0 R >>
startxref
3893
%%EOF
then after the EOF is a full dump of the HTML code:
%%EOF
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title> . . .
I've asked the database manager to look at the reporting services logs but
if this gives anyone a clue to the cause/solution . . .
--
gwf
"Donovan Smith [MSFT]" wrote:
> There are a variety of reasons this could happen. I'd start by first
> looking at the Report Server log file and see what exception (if any) occurs
> when you render to PDF. Secondly, I'd dump the PDF into notepad and see if
> there are any errors embedded at the end of the stream.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> <csuman@.gmail.com> wrote in message
> news:1130708307.146769.204230@.g49g2000cwa.googlegroups.com...
> >I developed a report using sql server reporting services and the vs.net
> > designer. Then I wrote another class that downloads the result into
> > pdf and excel formats. When I run the program, the excel file opens
> > fine but the pdf says "there was an error opening this document. the
> > file is damaged and cannot be repaired". I have seen other forums with
> > the same issue and microsoft is yet to provide an answer to this
> > problem. Can someone help please? Any suggestions are well appreciated.
> >
> > Thanks.
> >
>
>sql

Error when trying to deploy report

Hi,
I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report
to our reporting server I get the following error:
"A connection could not be made to the report server
http://sqlreportserver/ReportServer"
I can browse to the Report Manager and view reports. I am also able to debug
reports in VS.NET 2003. I've double checked the TargetFolder and
TargetServerURL in the project properties.
I am on a different domain than the report server. Could this be why I am
unable to deploy? If so, does anybody know how I can work around this.
Thanks
John a.k.a.HansHi again,
I'm still having problems with this. If anyone could give me a few pointers
that would be much appreciated.
Thanks
J
"Hans Gruber" wrote:
> Hi,
> I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report
> to our reporting server I get the following error:
> "A connection could not be made to the report server
> http://sqlreportserver/ReportServer"
> I can browse to the Report Manager and view reports. I am also able to debug
> reports in VS.NET 2003. I've double checked the TargetFolder and
> TargetServerURL in the project properties.
> I am on a different domain than the report server. Could this be why I am
> unable to deploy? If so, does anybody know how I can work around this.
> Thanks
> John a.k.a.Hans
>|||OK. I've made some progress. Hopefully this may help other people with the
same problem.
1) In IE. Tools --> Internet Options --> Connections --> LAN Settings.
Uncheck the 'Use a proxy server for your LAN (These.....' box.
2) Restart VS.NET 2003
3) I can now deploy reports.
Still frustrating because my colleague does not have to uncheck this box in
order to deploy...so any pointers would be much appreciated.
J
> > Hi,
> >
> > I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report
> > to our reporting server I get the following error:
> >
> > "A connection could not be made to the report server
> > http://sqlreportserver/ReportServer"
> >
> > I can browse to the Report Manager and view reports. I am also able to debug
> > reports in VS.NET 2003. I've double checked the TargetFolder and
> > TargetServerURL in the project properties.
> >
> > I am on a different domain than the report server. Could this be why I am
> > unable to deploy? If so, does anybody know how I can work around this.
> >
> > Thanks
> > John a.k.a.Hans
> >
> >

Error when trying to deploy a report using Oracle data source

We use SQL Server Reporting Services, My SQL box is on Win2k3. The developer
is able to run the report on his Windows XP box but when he deploys the
reports to the SQL Server where Reporting Services is running, he gets the
following error:
"An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'WMS'. (rsErrorOpeningConnection)
Get Online Help
System.Data.OracleClient requires Oracle client software version 8.1.7 or
greater
He develped this report on his XP box using Visual Studio .NET and is trying
to deploy it to our SQL server production box where Reporting Services is
installed. I have installed Oracle 9.2 client on the SQL Server box and can
make successful connections to our Oracle Database (where the report is
pulling data from). What else am I missing?
Thanks!
Bea Isabelle, Database AdministratorI used the google groups search.
Look at this link:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/8eb65eca58e11586/05b5299775c955b9?q=oracle+8.1.7+group:microsoft.public.sqlserver.reportingsvcs&rnum=1&hl=en#05b5299775c955b9
Basically reboot after installing. Link has other things to try.
Here is the search I used:
http://groups-beta.google.com/groups?hl=en&lr=&safe=off&num=10&q=oracle+8.1.7+group%3Amicrosoft.public.sqlserver.reportingsvcs&safe=off&qt_s=Search
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"isabelle" <isabelle@.discussions.microsoft.com> wrote in message
news:66AE92CA-13A2-4FB2-96B4-9CE0464D141E@.microsoft.com...
> We use SQL Server Reporting Services, My SQL box is on Win2k3. The
> developer
> is able to run the report on his Windows XP box but when he deploys the
> reports to the SQL Server where Reporting Services is running, he gets the
> following error:
> "An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'WMS'.
> (rsErrorOpeningConnection)
> Get Online Help
> System.Data.OracleClient requires Oracle client software version 8.1.7 or
> greater
> He develped this report on his XP box using Visual Studio .NET and is
> trying
> to deploy it to our SQL server production box where Reporting Services is
> installed. I have installed Oracle 9.2 client on the SQL Server box and
> can
> make successful connections to our Oracle Database (where the report is
> pulling data from). What else am I missing?
> Thanks!
> Bea Isabelle, Database Administrator
>|||Unfortunately, my server access won't allow me to go to those links here from
work. The only
that we haven't tried is rebooting the IIS services as the documentation
noted. I've also installed the ODP .Net
driver on the FFSQL box and he still gets the error. We will try a reboot
later today and see if that clears up the error.
Thanks!
"Bruce L-C [MVP]" wrote:
> I used the google groups search.
> Look at this link:
> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/8eb65eca58e11586/05b5299775c955b9?q=oracle+8.1.7+group:microsoft.public.sqlserver.reportingsvcs&rnum=1&hl=en#05b5299775c955b9
> Basically reboot after installing. Link has other things to try.
> Here is the search I used:
> http://groups-beta.google.com/groups?hl=en&lr=&safe=off&num=10&q=oracle+8.1.7+group%3Amicrosoft.public.sqlserver.reportingsvcs&safe=off&qt_s=Search
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "isabelle" <isabelle@.discussions.microsoft.com> wrote in message
> news:66AE92CA-13A2-4FB2-96B4-9CE0464D141E@.microsoft.com...
> > We use SQL Server Reporting Services, My SQL box is on Win2k3. The
> > developer
> > is able to run the report on his Windows XP box but when he deploys the
> > reports to the SQL Server where Reporting Services is running, he gets the
> > following error:
> >
> > "An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'WMS'.
> > (rsErrorOpeningConnection)
> > Get Online Help
> > System.Data.OracleClient requires Oracle client software version 8.1.7 or
> > greater
> >
> > He develped this report on his XP box using Visual Studio .NET and is
> > trying
> > to deploy it to our SQL server production box where Reporting Services is
> > installed. I have installed Oracle 9.2 client on the SQL Server box and
> > can
> > make successful connections to our Oracle Database (where the report is
> > pulling data from). What else am I missing?
> >
> > Thanks!
> >
> > Bea Isabelle, Database Administrator
> >
>
>

Tuesday, March 27, 2012

Error when trying to access http://localhost/Reports

Hello,

I just recently installed SQL Express 2005 Reporting Services on a new OS "Vista Ultimate". I used for reference the video # 10 Getting Started with Reporting Services found in

SQL Server Videos - SQL Server 2005 Express for Beginners. I was finally able to install everthing, including creating a new project using Report Server Project Wizard.

The only problem I recieve when fallowing the video is opening IE and enteringhttp://localhost/Reports. What I recieve is an error"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

I checked to see if the SQL Server Reporting Services was running which it was. I also checked the Default Web Site in IIS manger which was also running.

Any help would be much appreciated

Regards

Karl

May be the problem is just configuration check this link it might help you

http://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx

error when running reports

Hi all
Has anyone seen the following error - cannot run any reports - start then
crashes
Reporting Services Error
----
a.. An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help
a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
----
Microsoft Reporting Services
PeterThere seems to be a corruption with your temp DB. First check to see if
there is a ReportServerTempDB database. If so then check for the
ExecutionCache table, if it exist make sure the owner is dbo. If the DB
does not exist you can run the CatalogTempDB.sql script to create it. Make
sure to first create the DB as ReportServerTempDB and then create a Role
called RSExecRole, then you can run the script. You will also need to make
sure all the users that are in the RSExecRole in the ReportServer Database
are in the ReportServerTempDB's RSExecRole.
I hope that helps.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pete" <p0911@.hotmail.com> wrote in message
news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi all
> Has anyone seen the following error - cannot run any reports - start
> then crashes
> Reporting Services Error
> ----
> a.. An internal error occurred on the report server. See the error log
> for more details. (rsInternalError) Get Online Help
> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
> ----
> Microsoft Reporting Services
>
> Peter
>|||Daniel
Thank you for your suggestions - I will try them out and post back
Pete
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
> There seems to be a corruption with your temp DB. First check to see if
> there is a ReportServerTempDB database. If so then check for the
> ExecutionCache table, if it exist make sure the owner is dbo. If the DB
> does not exist you can run the CatalogTempDB.sql script to create it.
> Make sure to first create the DB as ReportServerTempDB and then create a
> Role called RSExecRole, then you can run the script. You will also need
> to make sure all the users that are in the RSExecRole in the ReportServer
> Database are in the ReportServerTempDB's RSExecRole.
>
> I hope that helps.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Pete" <p0911@.hotmail.com> wrote in message
> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports - start
>> then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>|||Daniel
Tried your suggestions - DB was missing - created , added user , added
role , ran script - all seemed to run ok - thought I was home
However I now get this and can't seem to find where to fix it
Reporting Services Error
----
a.. An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help
a.. Cannot resolve collation conflict for equal to operation.
----
Microsoft Reporting Services
Also , there appears o be multiple scripts for Service packs etc where the
create script is - any idea what order to run them if necessary - I had
installed SSRS SP2 initially
Thank you
Pete
"Pete" <p0911@.hotmail.com> wrote in message
news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
> Daniel
> Thank you for your suggestions - I will try them out and post back
> Pete
>
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see if
>> there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the DB
>> does not exist you can run the CatalogTempDB.sql script to create it.
>> Make sure to first create the DB as ReportServerTempDB and then create a
>> Role called RSExecRole, then you can run the script. You will also need
>> to make sure all the users that are in the RSExecRole in the ReportServer
>> Database are in the ReportServerTempDB's RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports - start
>> then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>>
>|||Where do you see this error? When running a report or in the log files?
You only need to run the catalogtemp.sql script, non of the upgrade scripts.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pete" <p0911@.hotmail.com> wrote in message
news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
> Daniel
> Tried your suggestions - DB was missing - created , added user , added
> role , ran script - all seemed to run ok - thought I was home
> However I now get this and can't seem to find where to fix it
> Reporting Services Error
> ----
> a.. An internal error occurred on the report server. See the error log
> for more details. (rsInternalError) Get Online Help
> a.. Cannot resolve collation conflict for equal to operation.
> ----
> Microsoft Reporting Services
>
> Also , there appears o be multiple scripts for Service packs etc where the
> create script is - any idea what order to run them if necessary - I had
> installed SSRS SP2 initially
> Thank you
> Pete
>
> "Pete" <p0911@.hotmail.com> wrote in message
> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see if
>> there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the DB
>> does not exist you can run the CatalogTempDB.sql script to create it.
>> Make sure to first create the DB as ReportServerTempDB and then create a
>> Role called RSExecRole, then you can run the script. You will also need
>> to make sure all the users that are in the RSExecRole in the
>> ReportServer Database are in the ReportServerTempDB's RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports - start
>> then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>>
>>
>|||Daniel
It happens when I run a report from Report Manager (or from within
RM3.0) - it starts off ok (view report) and then come up with this error -
If I create a new report in Visual Studio and run preview from there
everything is fine !!! - if I then import this into ReportManager and try to
run it comes up with this error - along with all the other reports currently
in ReportManager
Everything was working fine until the other day and as far as I know I've
done nothing to the server (don't even touch it) although we did have a
power outage when I wasn't here and the UPS expired - don't even know how
the TempDb went missing ( ps I'm the only one who uses the system - it is
my dev network etc )
I thought the collating seq may have been wrong so I checked with a VPC that
works and changed it to the same as the Report Server
Latin1_General_CI_Ai_KS_WS but made no difference
This box is SBS 2003 with SQL 2000 plus MS CRM 3.0 plus SSRS 2000 plus SP2
plus Visual Studio 2003
Peter
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:uS%23qQdE$FHA.984@.tk2msftngp13.phx.gbl...
> Where do you see this error? When running a report or in the log files?
> You only need to run the catalogtemp.sql script, non of the upgrade
> scripts.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Pete" <p0911@.hotmail.com> wrote in message
> news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
>> Daniel
>> Tried your suggestions - DB was missing - created , added user , added
>> role , ran script - all seemed to run ok - thought I was home
>> However I now get this and can't seem to find where to fix it
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Cannot resolve collation conflict for equal to operation.
>> ----
>> Microsoft Reporting Services
>>
>> Also , there appears o be multiple scripts for Service packs etc where
>> the create script is - any idea what order to run them if necessary - I
>> had installed SSRS SP2 initially
>> Thank you
>> Pete
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see
>> if there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the
>> DB does not exist you can run the CatalogTempDB.sql script to create
>> it. Make sure to first create the DB as ReportServerTempDB and then
>> create a Role called RSExecRole, then you can run the script. You will
>> also need to make sure all the users that are in the RSExecRole in the
>> ReportServer Database are in the ReportServerTempDB's RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports -
>> start then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error
>> log for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>>
>>
>>
>|||Do the log files have more of a call stack? Perhaps that will lead us to
where the problem is occurring.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pete" <p0911@.hotmail.com> wrote in message
news:O$HJsEF$FHA.3800@.TK2MSFTNGP10.phx.gbl...
> Daniel
> It happens when I run a report from Report Manager (or from within
> M3.0) - it starts off ok (view report) and then come up with this
> error - If I create a new report in Visual Studio and run preview from
> there everything is fine !!! - if I then import this into ReportManager
> and try to run it comes up with this error - along with all the other
> reports currently in ReportManager
> Everything was working fine until the other day and as far as I know I've
> done nothing to the server (don't even touch it) although we did have a
> power outage when I wasn't here and the UPS expired - don't even know
> how the TempDb went missing ( ps I'm the only one who uses the system -
> it is my dev network etc )
> I thought the collating seq may have been wrong so I checked with a VPC
> that works and changed it to the same as the Report Server
> Latin1_General_CI_Ai_KS_WS but made no difference
> This box is SBS 2003 with SQL 2000 plus MS CRM 3.0 plus SSRS 2000 plus SP2
> plus Visual Studio 2003
> Peter
>
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:uS%23qQdE$FHA.984@.tk2msftngp13.phx.gbl...
>> Where do you see this error? When running a report or in the log files?
>> You only need to run the catalogtemp.sql script, non of the upgrade
>> scripts.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
>> Daniel
>> Tried your suggestions - DB was missing - created , added user , added
>> role , ran script - all seemed to run ok - thought I was home
>> However I now get this and can't seem to find where to fix it
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Cannot resolve collation conflict for equal to operation.
>> ----
>> Microsoft Reporting Services
>>
>> Also , there appears o be multiple scripts for Service packs etc where
>> the create script is - any idea what order to run them if necessary -
>> I had installed SSRS SP2 initially
>> Thank you
>> Pete
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see
>> if there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the
>> DB does not exist you can run the CatalogTempDB.sql script to create
>> it. Make sure to first create the DB as ReportServerTempDB and then
>> create a Role called RSExecRole, then you can run the script. You
>> will also need to make sure all the users that are in the RSExecRole
>> in the ReportServer Database are in the ReportServerTempDB's
>> RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports -
>> start then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error
>> log for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>>
>>
>>
>>
>|||Daniel
I'm going to delete the tempDB again and recreate it and make sure it has
exactly the same collating sequence and see what happens and let you know -
Peter Yang (MSFT)suggested checking that on the private newsgroup ( i
wasn't subscribed there before but I am now
ReportServer is Latin1_General CI_AS_KS_WS and the TempDB
Latin1_General_CI_AI_KS_WS -
I obviously made a mistake when I recreatedthe TempDB
Thank yuo for you help and assistance
Peter
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:OniKgWaAGHA.3436@.TK2MSFTNGP10.phx.gbl...
> Do the log files have more of a call stack? Perhaps that will lead us to
> where the problem is occurring.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Pete" <p0911@.hotmail.com> wrote in message
> news:O$HJsEF$FHA.3800@.TK2MSFTNGP10.phx.gbl...
>> Daniel
>> It happens when I run a report from Report Manager (or from within
>> 3.0) - it starts off ok (view report) and then come up with this
>> error - If I create a new report in Visual Studio and run preview from
>> there everything is fine !!! - if I then import this into ReportManager
>> and try to run it comes up with this error - along with all the other
>> reports currently in ReportManager
>> Everything was working fine until the other day and as far as I know I've
>> done nothing to the server (don't even touch it) although we did have a
>> power outage when I wasn't here and the UPS expired - don't even know
>> how the TempDb went missing ( ps I'm the only one who uses the system -
>> it is my dev network etc )
>> I thought the collating seq may have been wrong so I checked with a VPC
>> that works and changed it to the same as the Report Server
>> Latin1_General_CI_Ai_KS_WS but made no difference
>> This box is SBS 2003 with SQL 2000 plus MS CRM 3.0 plus SSRS 2000 plus
>> SP2 plus Visual Studio 2003
>> Peter
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:uS%23qQdE$FHA.984@.tk2msftngp13.phx.gbl...
>> Where do you see this error? When running a report or in the log files?
>> You only need to run the catalogtemp.sql script, non of the upgrade
>> scripts.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
>> Daniel
>> Tried your suggestions - DB was missing - created , added user ,
>> added role , ran script - all seemed to run ok - thought I was home
>> However I now get this and can't seem to find where to fix it
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Cannot resolve collation conflict for equal to operation.
>> ----
>> Microsoft Reporting Services
>>
>> Also , there appears o be multiple scripts for Service packs etc where
>> the create script is - any idea what order to run them if necessary -
>> I had installed SSRS SP2 initially
>> Thank you
>> Pete
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see
>> if there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the
>> DB does not exist you can run the CatalogTempDB.sql script to create
>> it. Make sure to first create the DB as ReportServerTempDB and then
>> create a Role called RSExecRole, then you can run the script. You
>> will also need to make sure all the users that are in the RSExecRole
>> in the ReportServer Database are in the ReportServerTempDB's
>> RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>>> Hi all
>>>
>>> Has anyone seen the following error - cannot run any reports -
>>> start then crashes
>>>
>>> Reporting Services Error
>>> ----
>>>
>>> a.. An internal error occurred on the report server. See the error
>>> log for more details. (rsInternalError) Get Online Help
>>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>>>
>>> ----
>>> Microsoft Reporting Services
>>>
>>>
>>> Peter
>>>
>>
>>
>>
>>
>>
>|||Daniel
Have managed to fix problem by recreating ReportServerTempDB with the
correct collating sequence this time
Thank you for you assistance - maybe well talk again in the future
Peter Hale
"Pete" <p0911@.hotmail.com> wrote in message
news:%23IIJp1tBGHA.4012@.TK2MSFTNGP10.phx.gbl...
> Daniel
> I'm going to delete the tempDB again and recreate it and make sure it has
> exactly the same collating sequence and see what happens and let you
> now - Peter Yang (MSFT)suggested checking that on the private newsgroup
> ( i wasn't subscribed there before but I am now
> ReportServer is Latin1_General CI_AS_KS_WS and the TempDB
> Latin1_General_CI_AI_KS_WS -
> I obviously made a mistake when I recreatedthe TempDB
> Thank yuo for you help and assistance
> Peter
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:OniKgWaAGHA.3436@.TK2MSFTNGP10.phx.gbl...
>> Do the log files have more of a call stack? Perhaps that will lead us to
>> where the problem is occurring.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:O$HJsEF$FHA.3800@.TK2MSFTNGP10.phx.gbl...
>> Daniel
>> It happens when I run a report from Report Manager (or from within
>> .0) - it starts off ok (view report) and then come up with this
>> error - If I create a new report in Visual Studio and run preview from
>> there everything is fine !!! - if I then import this into ReportManager
>> and try to run it comes up with this error - along with all the other
>> reports currently in ReportManager
>> Everything was working fine until the other day and as far as I know
>> I've done nothing to the server (don't even touch it) although we did
>> have a power outage when I wasn't here and the UPS expired - don't
>> even know how the TempDb went missing ( ps I'm the only one who uses
>> the system - it is my dev network etc )
>> I thought the collating seq may have been wrong so I checked with a VPC
>> that works and changed it to the same as the Report Server
>> Latin1_General_CI_Ai_KS_WS but made no difference
>> This box is SBS 2003 with SQL 2000 plus MS CRM 3.0 plus SSRS 2000 plus
>> SP2 plus Visual Studio 2003
>> Peter
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:uS%23qQdE$FHA.984@.tk2msftngp13.phx.gbl...
>> Where do you see this error? When running a report or in the log
>> files?
>> You only need to run the catalogtemp.sql script, non of the upgrade
>> scripts.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
>> Daniel
>> Tried your suggestions - DB was missing - created , added user ,
>> added role , ran script - all seemed to run ok - thought I was home
>> However I now get this and can't seem to find where to fix it
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error
>> log for more details. (rsInternalError) Get Online Help
>> a.. Cannot resolve collation conflict for equal to operation.
>> ----
>> Microsoft Reporting Services
>>
>> Also , there appears o be multiple scripts for Service packs etc where
>> the create script is - any idea what order to run them if necessary -
>> I had installed SSRS SP2 initially
>> Thank you
>> Pete
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>>> There seems to be a corruption with your temp DB. First check to
>>> see if there is a ReportServerTempDB database. If so then check for
>>> the ExecutionCache table, if it exist make sure the owner is dbo.
>>> If the DB does not exist you can run the CatalogTempDB.sql script to
>>> create it. Make sure to first create the DB as ReportServerTempDB
>>> and then create a Role called RSExecRole, then you can run the
>>> script. You will also need to make sure all the users that are in
>>> the RSExecRole in the ReportServer Database are in the
>>> ReportServerTempDB's RSExecRole.
>>>
>>>
>>> I hope that helps.
>>>
>>> --
>>> -Daniel
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>>
>>>
>>> "Pete" <p0911@.hotmail.com> wrote in message
>>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>>> Hi all
>>>
>>> Has anyone seen the following error - cannot run any reports -
>>> start then crashes
>>>
>>> Reporting Services Error
>>> ----
>>>
>>> a.. An internal error occurred on the report server. See the error
>>> log for more details. (rsInternalError) Get Online Help
>>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>>>
>>> ----
>>> Microsoft Reporting Services
>>>
>>>
>>> Peter
>>>
>>>
>>>
>>
>>
>>
>>
>>
>

Monday, March 26, 2012

Error when RowNumber is 0

Or is it when the dataset is null? Either way, my report is reporting a
Javasript error when my stored procedure returns no records. I isolated the
expression that is causing the problem. It is:
=iif( RowNumber("DataRecords") Mod 2, "WhiteSmoke", "White")
which I had in the table row Background property to alternate my background
color of the rows. It works fine, except when there are no records.
Can someone tell me how to fix it without removing the expression, which is
what I did to get around it for now. I would like to have the alternating row
colors back if I can. Basically I need to be able to determine that
RowNumber is 0 or that DataRecords, which is my dataset, is null.
BTW, the error did not show up while I was testing under Visual Studio 2005
Pro in Debug mode. Everything appeared fine until I deployed to the server.
If anyone knows how I can catch this type of problem BEFORE I deploy I would
like to know also.
TIA
URW
PS: I had accidentally posted this in the SQL Server Replication Group this
morning. I hope I have the right place (Reporting Services) this time. :-)I found the answer in another post, so the problem has been solved. I should
have searched first and I apologze for not doing that. I guess after I
realized I had posted to the wrong group earlier, I was a bit flustered
Thanks
"URW" wrote:
> Or is it when the dataset is null? Either way, my report is reporting a
> Javasript error when my stored procedure returns no records. I isolated the
> expression that is causing the problem. It is:
> =iif( RowNumber("DataRecords") Mod 2, "WhiteSmoke", "White")
> which I had in the table row Background property to alternate my background
> color of the rows. It works fine, except when there are no records.
> Can someone tell me how to fix it without removing the expression, which is
> what I did to get around it for now. I would like to have the alternating row
> colors back if I can. Basically I need to be able to determine that
> RowNumber is 0 or that DataRecords, which is my dataset, is null.
> BTW, the error did not show up while I was testing under Visual Studio 2005
> Pro in Debug mode. Everything appeared fine until I deployed to the server.
> If anyone knows how I can catch this type of problem BEFORE I deploy I would
> like to know also.
> TIA
> URW
> PS: I had accidentally posted this in the SQL Server Replication Group this
> morning. I hope I have the right place (Reporting Services) this time. :-)|||Could you tell us the solution ;-)?
"URW" <URW@.discussions.microsoft.com> escribió en el mensaje
news:B817A72E-446F-43BF-9B7E-C0A4D2553C15@.microsoft.com...
>I found the answer in another post, so the problem has been solved. I
>should
> have searched first and I apologze for not doing that. I guess after I
> realized I had posted to the wrong group earlier, I was a bit flustered
> Thanks
> "URW" wrote:
>> Or is it when the dataset is null? Either way, my report is reporting a
>> Javasript error when my stored procedure returns no records. I isolated
>> the
>> expression that is causing the problem. It is:
>> =iif( RowNumber("DataRecords") Mod 2, "WhiteSmoke", "White")
>> which I had in the table row Background property to alternate my
>> background
>> color of the rows. It works fine, except when there are no records.
>> Can someone tell me how to fix it without removing the expression, which
>> is
>> what I did to get around it for now. I would like to have the alternating
>> row
>> colors back if I can. Basically I need to be able to determine that
>> RowNumber is 0 or that DataRecords, which is my dataset, is null.
>> BTW, the error did not show up while I was testing under Visual Studio
>> 2005
>> Pro in Debug mode. Everything appeared fine until I deployed to the
>> server.
>> If anyone knows how I can catch this type of problem BEFORE I deploy I
>> would
>> like to know also.
>> TIA
>> URW
>> PS: I had accidentally posted this in the SQL Server Replication Group
>> this
>> morning. I hope I have the right place (Reporting Services) this time.
>> :-)|||Sure.
I just change the expression to
=iif( RowNumber(Nothing)Mod 2, "WhiteSmoke", "White")
I think by defaulting the scope of RowNumber, I am actually counting the
number of rows in the table, rather than the number of rows in the Dataset,
like I was before. Since the dataset can be null, I had problems when I tried
to get the row count for a null object. But the table is never null, and thus
the row count is always save to access and thus no crash. I am not sure if my
explanaition is correct, but that is how I could explain to myself why
getting the row number of a null object worked.
If you search for RowNumber in this group you will find several posts that
refer to this problem. They all show the same solution, but no explanaition
why it works. I hope mine helps but if not at least you have the answer for
my problem.
"MÃ³nica" wrote:
> Could you tell us the solution ;-)?
>
> "URW" <URW@.discussions.microsoft.com> escribiÃ³ en el mensaje
> news:B817A72E-446F-43BF-9B7E-C0A4D2553C15@.microsoft.com...
> >I found the answer in another post, so the problem has been solved. I
> >should
> > have searched first and I apologze for not doing that. I guess after I
> > realized I had posted to the wrong group earlier, I was a bit flustered
> >
> > Thanks
> >
> > "URW" wrote:
> >
> >> Or is it when the dataset is null? Either way, my report is reporting a
> >> Javasript error when my stored procedure returns no records. I isolated
> >> the
> >> expression that is causing the problem. It is:
> >>
> >> =iif( RowNumber("DataRecords") Mod 2, "WhiteSmoke", "White")
> >>
> >> which I had in the table row Background property to alternate my
> >> background
> >> color of the rows. It works fine, except when there are no records.
> >>
> >> Can someone tell me how to fix it without removing the expression, which
> >> is
> >> what I did to get around it for now. I would like to have the alternating
> >> row
> >> colors back if I can. Basically I need to be able to determine that
> >> RowNumber is 0 or that DataRecords, which is my dataset, is null.
> >>
> >> BTW, the error did not show up while I was testing under Visual Studio
> >> 2005
> >> Pro in Debug mode. Everything appeared fine until I deployed to the
> >> server.
> >> If anyone knows how I can catch this type of problem BEFORE I deploy I
> >> would
> >> like to know also.
> >>
> >> TIA
> >>
> >> URW
> >>
> >> PS: I had accidentally posted this in the SQL Server Replication Group
> >> this
> >> morning. I hope I have the right place (Reporting Services) this time.
> >> :-)
>
>sql

Friday, March 23, 2012

Error when installing Reporting Services in Virtual PC 2004

When I tried installing Reporting Services in Windows Server 2003 under
Virtual PC 2004 it displays a message "Error!". I have already installed
VS.NET 2003 and SQL Server 2000 with SP3. Please help.Hi Randy:
I've installed RS on a couple VPCs, so I don't think it would be a
general problem with VPC. I'm wondering what the problem could be. Do
you have 2003 configured as an application server (IIS, ASP.NET
enabled) before the install?
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Wed, 3 Nov 2004 19:23:02 -0800, "Randy Gadingan" <Randy
Gadingan@.discussions.microsoft.com> wrote:
>When I tried installing Reporting Services in Windows Server 2003 under
>Virtual PC 2004 it displays a message "Error!". I have already installed
>VS.NET 2003 and SQL Server 2000 with SP3. Please help.|||Hi Scott:
I have configured Windows Server 2003 as an application server before
installing VS NET 2003 and SQL Reporting Services.
"Scott Allen" wrote:
> Hi Randy:
> I've installed RS on a couple VPCs, so I don't think it would be a
> general problem with VPC. I'm wondering what the problem could be. Do
> you have 2003 configured as an application server (IIS, ASP.NET
> enabled) before the install?
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
> On Wed, 3 Nov 2004 19:23:02 -0800, "Randy Gadingan" <Randy
> Gadingan@.discussions.microsoft.com> wrote:
> >When I tried installing Reporting Services in Windows Server 2003 under
> >Virtual PC 2004 it displays a message "Error!". I have already installed
> >VS.NET 2003 and SQL Server 2000 with SP3. Please help.
>

Thursday, March 22, 2012

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005, I can connect and browse to Reporting Services through any management console and even to my site through //ServerName/Reports but when i try to deploy any of my reports to the Reporting Services through my VS2005 solution i get this error

A connection could not be made to the report server http://Forge/Reports.

Additional Information:

The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The status of all of my things in Reporting Services Configuration is Green and i can see my site in the IIS, i can also browse my site, it just doesn't want2 deploy.

Please HELP!!!

I suspect the problem lies here:

>I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005

and, considering the error:

>that the report server is a compatible version

I am thinking there is a problem with your deploying RS 2005 reports to a 2000 RS database. I wasn't aware you could deploy 2005 reports to a 2000 RS database. Maybe you can do it if you don't convert (existing 2000) reports, I am not sure; but I doubt you'll be able to deploy them if you have converted them from 2000 to 2005. I especially think and new reports will bomb out since they would be native 2005.

There are threads in this forum that talk about this subject.

|||Try deploying to http://forge/reportserver instead.|||wow. good eye!|||

Thanks for th information but it still gives me the same error, but don't worry too much about it, i'm just going to reinstall SQL 2000 RS with Visual Studio 2003. apparently there is some incompatibility issue between .Net Framework 2.0 and 1.1 that prevent my solutions from working properly, so until i figure out the exact problem and link the Frameworks manually in my solution i doubt that it will work.

Thanks a lot for your effort guys!

|||

I traced down my problem, but i'll post my solution here just incase some else might battle with the same problem.

When i installed the RS i changed the Virtual Directory Name to Forge too, so when i deployed them i had to deploy them to Forge/Forge instead of Forge/ReportServer which it suppose to be by default. ->PC Name / ReportServer Virtual Directory<--

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

A connection could not be made to the report server http://Forge/Reports.

Additional Information:

The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The status of all of my things in Reporting Services Configuration is Green and i can see my site in the IIS, i can also browse my site, it just doesn't want2 deploy.

Please HELP!!!

I suspect the problem lies here:

>I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005

and, considering the error:

>that the report server is a compatible version

There are threads in this forum that talk about this subject.

|||Try deploying to http://forge/reportserver instead.|||wow. good eye!|||

Thanks a lot for your effort guys!

|||

I traced down my problem, but i'll post my solution here just incase some else might battle with the same problem.

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

A connection could not be made to the report server http://Forge/Reports.

Additional Information:

The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The status of all of my things in Reporting Services Configuration is Green and i can see my site in the IIS, i can also browse my site, it just doesn't want2 deploy.

Please HELP!!!

I suspect the problem lies here:

>I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005

and, considering the error:

>that the report server is a compatible version

There are threads in this forum that talk about this subject.

|||Try deploying to http://forge/reportserver instead.|||wow. good eye!|||

Thanks a lot for your effort guys!

|||

I traced down my problem, but i'll post my solution here just incase some else might battle with the same problem.

Wednesday, March 21, 2012

Error when generating in Excel

I am currently having a problem in production when generating a report in
Excel. I get the following error:
Reporting Services Erro
----
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Excel Rendering Extension : Invalid index in the index path.
----
Microsoft Reporting Services
I would certainly appreciate if any one has a solution to this issue. One
thing I have found on the web is that they talk about Office version.(i.e. we
should have Office 2003 or XP on the reporting services machine & we do have
it in production) This report was working fine in production off recent
without any problems. But now I get this error on generating a report. The
other reports are working fine in terms of generating to excel.
Any inputs is greatly appreciated.
Thanks
MukundI got to view the log files in the Reporting Services directory & found the
following details. May be it will help to find the solution to this problem.
Please let me know if anyone has a solution to this issue.
Mukund
-----aspnet_wp!chunks!998!12/22/2004-15:01:24::
i INFO: ### GetReportChunk('RenderingInfo_EXCEL', Other), chunk was not
found! this=f881b8dc-4271-49a8-aed4-4b1a9f0d1620
aspnet_wp!reportrendering!998!12/22/2004-15:01:24:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Exception: Excel Rendering Extension : Invalid index in
the index path.
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CollectHiddenReportItems(IntList indexPath, PageReportItems& pageRI)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreScanPage(ReportItem
parentDataRegion, Boolean isPageNeedsEvaluation, Hashtable& riReferenceTable,
PageLayout& pageLayout, PageReportItems& pageRIItems, Stack&
dynamicLayoutStack, Hashtable& dataRegionsTable, Boolean[]& reduceRowGapList,
OutlineRenderStates[]& verticalOutlineStates, OutlineRenderStates[]&
horizontalOutlineStates)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderStaticPage(StreamWriter
streamWriter, ReportItem parentDataRegion, PageLayout pageLayout, Hashtable
formulaRIMap, Int32 currentPageNumber, PageReportItems& pageRIItems, Boolean&
isPageNeedsHeader, ExcelStyle& footerStyle, Stack& dynamicLayoutStack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
aspnet_wp!webserver!998!12/22/2004-15:01:27:: e ERROR: Reporting Services
error
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Exception: Excel Rendering Extension : Invalid index in
the index path.
aspnet_wp!library!9bc!12/22/2004-15:11:13:: i INFO: Cleaned 0 batch records,
0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
-----
"Mukund" wrote:
> I am currently having a problem in production when generating a report in
> Excel. I get the following error:
> Reporting Services Error
> ----
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Excel Rendering Extension : Invalid index in the index path.
> ----
> Microsoft Reporting Services
> I would certainly appreciate if any one has a solution to this issue. One
> thing I have found on the web is that they talk about Office version.(i.e. we
> should have Office 2003 or XP on the reporting services machine & we do have
> it in production) This report was working fine in production off recent
> without any problems. But now I get this error on generating a report. The
> other reports are working fine in terms of generating to excel.
> Any inputs is greatly appreciated.
> Thanks
> Mukund
>|||I am aslo getting the same error. Its works for other reports. Only one report i cant export to excel and html. if any one know the solution pls reply...
From http://www.developmentnow.com/g/115_2004_12_0_0_454135/Error-when-generating-in-Excel.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Monday, March 19, 2012

Error when deploying a report

I hope someone can help. I'm new to reporting services 2005, and I'm currently going through Microsoft's tutorial.

I can build a report no problem. But when it comes to deploying the report to a web page, the following message appears:

Build started: Project: Reporting Services Tutorial, Configuration: Production
Build complete -- 0 errors, 0 warnings
Deploy started: Project: Reporting Services Tutorial, Configuration: Production
Deploying to http://localhost/reportserver
Error : Response is not well-formed XML.
Deploy complete -- 1 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

This "reponse is not well-formed XML" error also occurs when I try to expand any of the folders from a "reporting services" server type in management studio.

Any ideas would be greatly appreciated!

Cheers

Richard Powell

are you able to view the xml of the report in Visual Studio?

(right click on the file in solution explorer and select 'view code')

at least this will confirm that the report is well formed.

have you managed to corrupt the css for report manager?

I can but empathise, i'm getting mighty sick of this product..|||

Hello Adolf

I am able to view the XML code after choosing "view code" in solution explorer.

What do you mean by a css in report manager? I did say I was new to this.

Richard

|||

For future reference, I have got this working now. When deploying the same report another time, a different error message appeared. Which was something like "The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server".

To stop this appearing, run "reporting services configuration" and connect to the appropriate server. Then click on "encryption keys" and click on the delete button that is under "delete encrypted content". After doing that, I am now able to deploy reports.

Error when deploying a report

I hope someone can help. I'm new to reporting services 2005, and I'm currently going through Microsoft's tutorial.

I can build a report no problem. But when it comes to deploying the report to a web page, the following message appears:

This "reponse is not well-formed XML" error also occurs when I try to expand any of the folders from a "reporting services" server type in management studio.

Any ideas would be greatly appreciated!

Cheers

Richard Powell

are you able to view the xml of the report in Visual Studio?

(right click on the file in solution explorer and select 'view code')

at least this will confirm that the report is well formed.

have you managed to corrupt the css for report manager?

I can but empathise, i'm getting mighty sick of this product..|||

Hello Adolf

I am able to view the XML code after choosing "view code" in solution explorer.

What do you mean by a css in report manager? I did say I was new to this.

Richard

|||

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.
> >
> >

Wednesday, March 7, 2012

Error using Reporting Services On windows 64 bit

I get the following error when i try to acces to the reporting services web
site.
Attempted to load a 64-bit assembly on a 32-bit platform. Use
ReflectionOnlyLoad() instead if trying to load for reflection purposes.
I have no idea of the source of the error (it is really a 64 bit edition of
windows)
If you have an idea,
ThanksAre you sure that you are not using a 32 bits version of SQRS on a 64 bits
machine?
In this case, have a look to this article
http://msdn2.microsoft.com/ms143293.aspx
Med Bouchenafa
"Cyprien Autexier" <autexi_c@.3ie.org> a écrit dans le message de news:
uqBrolOJGHA.3224@.TK2MSFTNGP09.phx.gbl...
>I get the following error when i try to acces to the reporting services web
>site.
> Attempted to load a 64-bit assembly on a 32-bit platform. Use
> ReflectionOnlyLoad() instead if trying to load for reflection purposes.
> I have no idea of the source of the error (it is really a 64 bit edition
> of windows)
> If you have an idea,
> Thanks
>

Error using Reporting services

Greetings,

Iam new to reporting services. When I try to launch http:\\localhost\reports

I get the following error

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

Please help

Thanks/Regards

I get the same message. Only the version is different.

ReportServicesConfigUI.WMIProvider.WMIProviderException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

By profiler I saw the trying to use of SP GetDBVersion, but this SP not present.

What is it and where can I download the update?

Thanks/Regards

|||This is usually an issue where RS is configured to the wrong DB. You should use the config tool to configure RS to a ReportServer DB.|||What is "wrong DB"? I create NEW DB for RS from RS config.|||Did you ensure that RS is configured to use that DB? Just creating the DB does not configure RS to use it.|||So how do we do that? Pardon my ignorance with SQL, it's my weakest point. The error I personally get is: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) In the Configure Report Server SSRS is configured properly, & I can log into that account in the Management Studio, but I cannot open http://localhost/reports. Any ideas? Thanks!|||In the ReportServer Configuration tool, does the Database tab have a green check? If not you need to go to that tab and choose the Report Server Database that you want to use.|||Thank you for your kind reply. Yes, I have a successful connection in the Report Server Configuration. I think I may have 2 instances of Reporting Server, however, & one didn't get the green icon. I figured when I re-installed, it overwrote the existing files, but as I'm poking around I see 2 instances. Would this be causing the problem?|||

Daniel,

Your last post asking if I got the green icon for the database connection made me think about the fact that perhaps I was trying to connect to the old instance of ssrs (as you can see in my post made about a half hour ago). Thanks for leading me in the right direction, because that was it!! It didn't make sense that it wasn't connecting to the database if that connection was configured properly in the Configuration Manager. I now can view the Report page.

Thanks again,

Kim

|||

I did step by step in RS config. When I came to configure DB, RS created DB, but coundn't configure it. By first it coundn't create RSRoleExec, I did this. Next it began show the message about virsion. But the left mark is green, and "Initialization" is not enabled.

|||

Sir ,

I get the same error and i use the SQL server 2000 version. Where can i find the configuration tool. I tried to run the rsconfig.exe with the requisite details but it did not work. Please let me know what is to be done.

Thanks a lot

Vijay

|||This issue can be also due to Report Server is configured to the wrong Database, choose Report Server Database that you want to use with the help of Report Server Configuration tool.

Error using Reporting services

Greetings,

Iam new to reporting services. When I try to launch http:\\localhost\reports

I get the following error

Please help

Thanks/Regards

I get the same message. Only the version is different.

By profiler I saw the trying to use of SP GetDBVersion, but this SP not present.

What is it and where can I download the update?

Thanks/Regards

Daniel,

Thanks again,

Kim

|||

Sir ,

Thanks a lot

Vijay

|||This issue can be also due to Report Server is configured to the wrong Database, choose Report Server Database that you want to use with the help of Report Server Configuration tool.

Error using Reporting services

Greetings,

Iam new to reporting services. When I try to launch http:\\localhost\reports

I get the following error

Please help

Thanks/Regards

I get the same message. Only the version is different.

By profiler I saw the trying to use of SP GetDBVersion, but this SP not present.

What is it and where can I download the update?

Thanks/Regards

Daniel,

Thanks again,

Kim

|||

Sir ,

Thanks a lot

Vijay

|||This issue can be also due to Report Server is configured to the wrong Database, choose Report Server Database that you want to use with the help of Report Server Configuration tool.

Sunday, February 26, 2012

error uploading sample reports

Every time I goto upload the sample reports that come with Reporting Services (AdventureWorks), I get the following error message. I have built a simple report from scratch and uploaded it to the report server and it was OK. I only get the error with the sample reports. Anyone have a fix for this.I can't figure it out.

Reporting Services Error

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'AdventureWorks'. (rsErrorOpeningConnection) Get Online Help SQL Server does not exist or access denied.Are you sure the AdventureWorks2000 database got installed during setup? The reports use a database connection string of server=(local).

Thursday, March 29, 2012

Error when trying to save report in pdf

Error when trying to deploy report

Error when trying to deploy a report using Oracle data source

Tuesday, March 27, 2012

Error when trying to access http://localhost/Reports

error when running reports

Monday, March 26, 2012

Error when RowNumber is 0

Error when RowNumber is 0

Friday, March 23, 2012

Error when installing Reporting Services in Virtual PC 2004

Thursday, March 22, 2012

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

Wednesday, March 21, 2012

Error when generating in Excel

Monday, March 19, 2012

Error when deploying a report

Error when deploying a report

Monday, March 12, 2012

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

Wednesday, March 7, 2012

Error using Reporting Services On windows 64 bit

Error using Reporting services

Error using Reporting services

Error using Reporting services

Sunday, February 26, 2012

error uploading sample reports

Reporting Services Error

Error running report

Blog Archive

About Me