Reporting Services Subscriptions / Sharepoint question

I'm trying to create a subscription that places a file (excel or PDF) in sharepoint. I haven't been able to find a path that works. I was wondering if anyone else had had this issue and how they overcame it.

Thanks.Answered my own question.

http://technet.microsoft.com/en-us/library/bb326364.aspx

Reporting Services Snapshots Access Denied

Hi guys,
I've set up a scheduled execution snapshots on a report; however, the
snapshot could only be viewed once. After the snapshot file being created on
rstempfiles directory, it cannot be acessed anymore. The error was 'Access to
path "C:\Program Files\Microsoft SQL Server\RSTempFiles\RSFile_da9ed300-e4a9-
4f7f-8ee7-48edf9ebedcd" is dnied.'
I've checked the security on the RSTempFiles directory and the snapshot file,
they both have users ASP.NET and SYSTEM with all permissions except the Full
Control permission.
Any help is appreciated.
Paul
--
Message posted via http://www.sqlmonster.comI think the login that the Reporting Services Services uses must also be
granted permissions on that directory..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul L via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:54476CB0823F7@.SQLMonster.com...
> Hi guys,
> I've set up a scheduled execution snapshots on a report; however, the
> snapshot could only be viewed once. After the snapshot file being created
> on
> rstempfiles directory, it cannot be acessed anymore. The error was 'Access
> to
> path "C:\Program Files\Microsoft SQL
> Server\RSTempFiles\RSFile_da9ed300-e4a9-
> 4f7f-8ee7-48edf9ebedcd" is dnied.'
> I've checked the security on the RSTempFiles directory and the snapshot
> file,
> they both have users ASP.NET and SYSTEM with all permissions except the
> Full
> Control permission.
> Any help is appreciated.
> Paul
>
> --
> Message posted via http://www.sqlmonster.comsql

Reporting services setup file: where can I get it??

Hi folks!

Do anybody know where is the Reporting Services instalation file for SQL Server 2005?
I already looking for it at the Microsoft site, but I did not find nothing... just the SP2 for Reporting Services (2005) install.

I will appreciate some help!

Tks a lot,
Lant

Hi Lant,

The set up files are on the installation disc for SQL Server 2005. They are not available as separate downloads. When you are installing SQL Server 2005, you can choose to install Reporting Services at the same time.

Regards
Ken

|||SQL Server is a lot of separate independent services so it is best to copy the content of the DVD or CD to disk before installation and when you don't know remember to choose all components. Now just rerun setup and choose add components. Hope this helps.

Reporting Services Project Problem

Hi
Every Time I Try To Start Any Type Of Report Server Project Out Of Visual
Studio 2005 I Get The Following Error:
Could not load file or assembly 'Microsoft.ReportingServices.Designer,
Version=9.0.242.0, Culture=neutral, PublicKeyToken=87987fvf5665vv91' or one
of its dependencies. The system cannot find the file specified.
I'm Running SQL Dev Server 2005
Any idea what I screwed up'
ThanksHello Tom,
If the project was built with an older version (Beta) of the .NET Runtime
then you need to have the version installed in order for your app to run.
The alternative is to rebuild the component using the newer .NET Runtime
and this would be the recommended thing to do. After that you should no
longer be getting this error.
If the issue persists, you may want to consider reinstall .Net 2.0 and
repair VS 2005 to test the situation.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "TomH" <tofoz2@.newsgroups.nospam>
>Subject: Reporting Services Project Problem
>Date: Mon, 23 Jan 2006 09:24:26 -0500
>Lines: 17
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
>X-RFC2646: Format=Flowed; Original
>Message-ID: <#HWDziCIGHA.604@.TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: 66.216.157.250.static.dejazzd.com 66.216.157.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67308
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hi
>Every Time I Try To Start Any Type Of Report Server Project Out Of Visual
>Studio 2005 I Get The Following Error:
>Could not load file or assembly 'Microsoft.ReportingServices.Designer,
>Version=9.0.242.0, Culture=neutral, PublicKeyToken=87987fvf5665vv91' or one
>of its dependencies. The system cannot find the file specified.
>
>I'm Running SQL Dev Server 2005
>Any idea what I screwed up'
>Thanks
>
>|||Tom, I have the same problem. Was wondering if you were able to
resolve this issue?
Thanks,
Adam
TomH wrote:
> Hi
> Every Time I Try To Start Any Type Of Report Server Project Out Of Visual
> Studio 2005 I Get The Following Error:
> Could not load file or assembly 'Microsoft.ReportingServices.Designer,
> Version=9.0.242.0, Culture=neutral, PublicKeyToken=87987fvf5665vv91' or one
> of its dependencies. The system cannot find the file specified.
>
> I'm Running SQL Dev Server 2005
> Any idea what I screwed up'
> Thankssql

Reporting Services PDF Size

Is there any way to shrink the file size of the PDF? When I resave the
file with Acrobat it is much smaller.
I can create the same report with crystal reports and have a much
smaller PDF..
Maybe it is a DPI setting or something?
2Meg 1 page PDFs are just not cutting it for me. There must be a way
to knock the file size down.
Thanks,
Jeff PJeffrae wrote:
> Is there any way to shrink the file size of the PDF? When I resave the
> file with Acrobat it is much smaller.
> I can create the same report with crystal reports and have a much
> smaller PDF..
> Maybe it is a DPI setting or something?
> 2Meg 1 page PDFs are just not cutting it for me. There must be a way
> to knock the file size down.
> Thanks,
> Jeff P
Update:
I have reduced the amount of colors in the images. I have also saved
them with a much lower DPI setting. This does not appear to effect the
PDF that is produced.
Is there a specific image format that Reporting Services thrives on? I
am using JPEGs.. I have tried BMPs also with no luck.
Jeffrae|||Jeffrae wrote:
> Jeffrae wrote:
> > Is there any way to shrink the file size of the PDF? When I resave the
> > file with Acrobat it is much smaller.
> >
> > I can create the same report with crystal reports and have a much
> > smaller PDF..
> >
> > Maybe it is a DPI setting or something?
> >
> > 2Meg 1 page PDFs are just not cutting it for me. There must be a way
> > to knock the file size down.
> >
> > Thanks,
> > Jeff P
> Update:
> I have reduced the amount of colors in the images. I have also saved
> them with a much lower DPI setting. This does not appear to effect the
> PDF that is produced.
> Is there a specific image format that Reporting Services thrives on? I
> am using JPEGs.. I have tried BMPs also with no luck.
> Jeffrae
Am I the only person with this problem? ;)sql

Reporting Services LogFiles location

How can I change the log file location? I need to move the
ReportingServicesService<date>.log files from the default location of
Microsoft SQL Server\MSSQL\Reporting Services\LogFiles to another
drive/location.
I just cannot find the entires. Any help is appreciated.
TIA -
- dave
--
Message posted via http://www.sqlmonster.comFound the answer in another thread on this site:
http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/9563/Change-
location-of-RS-log-files
Thanks CrazyHarryDBA~!
The only trouble I had was I had to add the correct groups/users to the
folder where the logs were moved to.
--
Message posted via http://www.sqlmonster.com

Reporting Services log file roulette - how to tell which log file SSRS is writing to for errors?

I'm sure I'm not the only one frustrated trying to figure out which log file SSRS writes to when an error occurs. Does anybody know a sure way to tell? It doesn't change the date/time of the date modified, so you can't sort by date in windows explorer. There seems to be no rhyme or reason to which file it writes to. For example, I had to go through 6 log files to find which one was being written to. I had thought (hoped) that it would always write to the log files with the latest embedded date/time stamp as part of the file name. It does not.

I'm tempted to start using a file system spy, or resort to other tactics. Does anyone have a sure fired way to see which log file is written to when an error occurs? I'm not talking about SQL Dump files - just "normal" errors when processing reports.

Thanks,

WillyDog

Hi willydog,

If you take a look in the Logfiles folder, you will notice different names for the log files. The first part of the log file name tells you who logged in that file, so you can figure out in what file to look for a specific error. The second part of the log file name contains the time stamp, so if you sort the log files descending by Date Modified, you will have the most recent files in the top of your list.

So, for the first part of the logfile name, this is the meaning:

- file's name starts with ReportServer - the web service logs into that file

- file's name starts with ReportServerService - the Windows service worker appdomain logs into that file

- file's name starts with ReportServerService__main - the Windows service main appdomain logs into that file (only for start/stop the Windows service)

- file's name starts with ReportServerWebApp - ReportManager logs into that file

See also:

http://msdn2.microsoft.com/en-us/ms156500.aspx#

http://blogs.msdn.com/bimusings/archive/2005/06/26/432798.aspx

Mihaela

Reporting services installation error (Error 29525 in RSMSI** log file)

Hi,
I have a problem during installation.
I've got the 1603 error.
Note that http://support.microsoft.com/?kbid=867872 suggestions didn't
help to solve the problem.
Quatation from RSMSI** log file:
"...
Action 13:57:32: Do_sqlScript. Configuring Microsoft SQL Server
Do_sqlScript: Running SQL Script: ...\ReportServer\CatalogTempDB.sql
<Func Name='LoadRSCatalog'>
error parsing script file ...\ReportServer\CatalogTempDB.sql: 87
Error 29525. SQL Setup failed to execute a command for server
configuration. Refer to the Server error logs and setup logs for
detailed error information.
<EndFunc Name='SqlScriptHlpr' Return='1603' GetLastError='0'>
<EndFunc Name='Do_sqlScript' Return='1603' GetLastError='0'>
..."
Thanks in advance for your time and help
Nick JHi,
I experience the same problem, and the 867872 didn't work for me either. My
configuration is SQL Server 2000 (8.00.760) on win2000 SP4. I try to install
the server components and do not have VS.NET 2003 installed. The .NET
framework 1.1 is installed.
The application log only repeats the same message: (MsiInstaller) "Error
29525. SQL Setup failed to execute a command for server configuration. Refer
to the Server error logs and setup logs for detailed information."
The SQL Server log doesn't show any message related to the problem, only the
last succesfull executed action: "index restored for
ReportServerTempDB.sysfilegroups."
Since the RSMSI*.log reports a parsing error to begin with, I tried to run
the script myself (the reportservertempdb is available before you hit cancel
in setup). The scripts runs fine and creates all the objects. So I replaced
the CalatogTempDB.sql script with an empty script and tried again. However
the same error appeared. So it seemes that a parsing error isn't realy the
problem?
Please, has someone a solution to this problem?
Thanx in advance,
Marien
"Nick J" wrote:
> Hi,
> I have a problem during installation.
> I've got the 1603 error.
> Note that http://support.microsoft.com/?kbid=867872 suggestions didn't
> help to solve the problem.
> Quatation from RSMSI** log file:
> "...
> Action 13:57:32: Do_sqlScript. Configuring Microsoft SQL Server
> Do_sqlScript: Running SQL Script: ...\ReportServer\CatalogTempDB.sql
> <Func Name='LoadRSCatalog'>
> error parsing script file ...\ReportServer\CatalogTempDB.sql: 87
> Error 29525. SQL Setup failed to execute a command for server
> configuration. Refer to the Server error logs and setup logs for
> detailed error information.
> <EndFunc Name='SqlScriptHlpr' Return='1603' GetLastError='0'>
> <EndFunc Name='Do_sqlScript' Return='1603' GetLastError='0'>
> ..."
> Thanks in advance for your time and help
> Nick J
>|||Hi, I'm getting the same error that you were getting. Were you ever able to
resolve this? Reporting Services had been running fine but something got
seriously hosed up with the permissions so I uninstalled it. I got that
message on reinstall. I've tried to create a new instance of SQL Server and
install RS to that, but that didn't work, either. I'm thinking that I may
have to reinstall Server 2003, which is definitely NOT cool.|||Are you installing in a location other than the default one?
--
Message posted via http://www.sqlmonster.com

Reporting Services export to Excel

Hey -
does anyone know of a way to export a RS file into Excel and
automatically turn off the the word wrap? Otherwise, the cells get
clipped. Has anyone seen this before?I don't know if this will work or not, but try playing with the Can
Grow, Can Shrink properties.
If that doesn't work, I don't think there will be any other way.
--
Regards
Chris
krister tidics | FOX IT wrote:
> Hey -
> does anyone know of a way to export a RS file into Excel and
> automatically turn off the the word wrap? Otherwise, the cells get
> clipped. Has anyone seen this before?

Reporting Services Error - On Windows 2003 Server

I have Reporting Services, installed on a win 2003 server. For all the report
created with matrix (control) when I try to export as Excell file, I have
this error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Object reference not set to an instance of an object.
Can same body HELPPP'''?
Thanks,
Stefan.If you look in the log file that corresponds to that error in your /Log
Files directory, can you paste the full stack trace? Also, have you applied
Reporting Services 2000 SP1 yet?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stefan" <Stefan@.discussions.microsoft.com> wrote in message
news:861F8C47-2A80-48CA-B390-67DE27F96B63@.microsoft.com...
>I have Reporting Services, installed on a win 2003 server. For all the
>report
> created with matrix (control) when I try to export as Excell file, I have
> this error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Object reference not set to an instance of an object.
> Can same body HELPPP'''?
> Thanks,
> Stefan.
>|||I can't put all the log file is too big (limit of 30000).
Below I put a part from "ReportServer__04_19_2005_09_48_01.log" file:
w3wp!webserver!a88!04/19/2005-09:48:29:: 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.NullReferenceException: Object reference not set to an
instance of an object.
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32 A_0, NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32 A_0, NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32 A_0, NonComputedUniqueNames& A_1, d A_2)
at Microsoft.ReportingServices.ReportProcessing.MatrixInstance.a(Int32
A_0, NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(Int32 A_0,
NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.ReportItemColInstance.a(Int32
A_0, NonComputedUniqueNames& A_1, d A_2)
at Microsoft.ReportingServices.ReportProcessing.ReportInstance.a(Int32
A_0, NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(Int32 A_0,
NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportRendering.RenderingContext.FindReportItemInBody(Int32 uniqueName)
at
Microsoft.ReportingServices.ReportRendering.RenderingContext.GetToggleParent(Int32 uniqueName)
at
Microsoft.ReportingServices.ReportRendering.MatrixMember.get_ToggleParent()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForRowMembers(MatrixMemberCollection
rowMembers, Int32 level, Page verticallySortedItems, Int32 indexOfMatrix,
Double left, Double top, ReportItemStructure cornerStructure, Hashtable&
outlineProhibitedGroups, Hashtable& outlineItems)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForRowMembers(MatrixMemberCollection
rowMembers, Int32 level, Page verticallySortedItems, Int32 indexOfMatrix,
Double left, Double top, ReportItemStructure cornerStructure, Hashtable&
outlineProhibitedGroups, Hashtable& outlineItems)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForMatrixChildren(Matrix
matrix, Page verticallySortedItems, Int32 indexOfMatrix, Page
horizontallySortedItems, Boolean ignorePageBreaks)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForDataRegionChildren(Page
dataRegions, Page verticallySortedItems, Page horizontallySortedItems,
ReportItemCollection reportItemCollection)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutline(Page
verticallySortedItems, ReportItemCollection riCollection, Page containers)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.CollectPages(ReportItemCollection
reportItemCollection, Double relativeLeft, Double relativeTop, Boolean
ignoreAllPageBreaks, Boolean isHeaderBeingProcessed, ArrayList&
pageCollection, Boolean& isPBSPropagated)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection
collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated, Boolean
hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed,
FormulaContext formulaContext, String language, PageReportItems&
firstPageReportItems, PageLayout& firstPageLayout, PageCollection&
pageCollection)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReport()
-- 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 --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at
Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
at
Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effecectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Below I put "ReportServerWebApp__04_19_2005_09_47_54.log" file:
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>E. Europe Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerWebApp__04_19_2005_09_47_54.log</Path>
<SystemName>AJUTOR</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing MaxScheduleWait
to default value of '1' second(s) because it was not specified in
Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing InstanceName to
default value of 'MSSQLSERVER.1' because it was not specified in
Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
RunningRequestsAge to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was not
specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
Yes, we have applied SP1.
Thanks,
Stefan.
"Donovan Smith [MSFT]" wrote:
> If you look in the log file that corresponds to that error in your /Log
> Files directory, can you paste the full stack trace? Also, have you applied
> Reporting Services 2000 SP1 yet?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Stefan" <Stefan@.discussions.microsoft.com> wrote in message
> news:861F8C47-2A80-48CA-B390-67DE27F96B63@.microsoft.com...
> >I have Reporting Services, installed on a win 2003 server. For all the
> >report
> > created with matrix (control) when I try to export as Excell file, I have
> > this error:
> >
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > Object reference not set to an instance of an object.
> > Can same body HELPPP'''?
> >
> > Thanks,
> > Stefan.
> >
>
>|||This looks like something we resolved in SP2 (due out shortly). Would you
please email me a copy of your .rdl and .rdl.data file so I can be sure?
Thank you.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stefan" <Stefan@.discussions.microsoft.com> wrote in message
news:364F8B2E-E741-4109-96F3-F35035508AD7@.microsoft.com...
>I can't put all the log file is too big (limit of 30000).
> Below I put a part from "ReportServer__04_19_2005_09_48_01.log" file:
> w3wp!webserver!a88!04/19/2005-09:48:29:: 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.NullReferenceException: Object reference not set to an
> instance of an object.
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
> A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
> A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
> A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at Microsoft.ReportingServices.ReportProcessing.MatrixInstance.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(Int32
> A_0,
> NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportItemColInstance.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at Microsoft.ReportingServices.ReportProcessing.ReportInstance.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(Int32
> A_0,
> NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportRendering.RenderingContext.FindReportItemInBody(Int32
> uniqueName)
> at
> Microsoft.ReportingServices.ReportRendering.RenderingContext.GetToggleParent(Int32
> uniqueName)
> at
> Microsoft.ReportingServices.ReportRendering.MatrixMember.get_ToggleParent()
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForRowMembers(MatrixMemberCollection
> rowMembers, Int32 level, Page verticallySortedItems, Int32 indexOfMatrix,
> Double left, Double top, ReportItemStructure cornerStructure, Hashtable&
> outlineProhibitedGroups, Hashtable& outlineItems)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForRowMembers(MatrixMemberCollection
> rowMembers, Int32 level, Page verticallySortedItems, Int32 indexOfMatrix,
> Double left, Double top, ReportItemStructure cornerStructure, Hashtable&
> outlineProhibitedGroups, Hashtable& outlineItems)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForMatrixChildren(Matrix
> matrix, Page verticallySortedItems, Int32 indexOfMatrix, Page
> horizontallySortedItems, Boolean ignorePageBreaks)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForDataRegionChildren(Page
> dataRegions, Page verticallySortedItems, Page horizontallySortedItems,
> ReportItemCollection reportItemCollection)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutline(Page
> verticallySortedItems, ReportItemCollection riCollection, Page containers)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.CollectPages(ReportItemCollection
> reportItemCollection, Double relativeLeft, Double relativeTop, Boolean
> ignoreAllPageBreaks, Boolean isHeaderBeingProcessed, ArrayList&
> pageCollection, Boolean& isPBSPropagated)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection
> collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated,
> Boolean
> hasLastPage, Boolean ignorePageBreaks, Boolean isHeaderBeingProcessed,
> FormulaContext formulaContext, String language, PageReportItems&
> firstPageReportItems, PageLayout& firstPageLayout, PageCollection&
> pageCollection)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReport()
> -- 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 --
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
> reportContext, ClientRequest session, RenderingResult& result)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
> Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effecectiveParameters, String[]&
> secondaryStreamNames)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> Below I put "ReportServerWebApp__04_19_2005_09_47_54.log" file:
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>E. Europe Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerWebApp__04_19_2005_09_47_54.log</Path>
> <SystemName>AJUTOR</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
> file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing MaxScheduleWait
> to default value of '1' second(s) because it was not specified in
> Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> DatabaseQueryTimeout to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing InstanceName to
> default value of 'MSSQLSERVER.1' because it was not specified in
> Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> ProcessRecycleOptions to default value of '0' because it was not
> specified
> in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> RunningRequestsScavengerCycle to default value of '30' second(s) because
> it
> was not specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> RunningRequestsDbCycle to default value of '30' second(s) because it was
> not
> specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> RunningRequestsAge to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> CleanupCycleMinutes to default value of '10' minute(s) because it was not
> specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> SecureConnectionLevel to default value of '1' because it was not
> specified
> in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> DisplayErrorLink
> to 'True' as specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it was
> not
> specified in Configuration file.
> Yes, we have applied SP1.
> Thanks,
> Stefan.
> "Donovan Smith [MSFT]" wrote:
>> If you look in the log file that corresponds to that error in your /Log
>> Files directory, can you paste the full stack trace? Also, have you
>> applied
>> Reporting Services 2000 SP1 yet?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Stefan" <Stefan@.discussions.microsoft.com> wrote in message
>> news:861F8C47-2A80-48CA-B390-67DE27F96B63@.microsoft.com...
>> >I have Reporting Services, installed on a win 2003 server. For all the
>> >report
>> > created with matrix (control) when I try to export as Excell file, I
>> > have
>> > this error:
>> >
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown.
>> > Object reference not set to an instance of an object.
>> > Can same body HELPPP'''?
>> >
>> > Thanks,
>> > Stefan.
>> >
>>|||I don't know your e-mail address. So, I give my address stefan.rustin@.cg-gc.ro.
Thanks,
Stefan.
"Donovan Smith [MSFT]" wrote:
> This looks like something we resolved in SP2 (due out shortly). Would you
> please email me a copy of your .rdl and .rdl.data file so I can be sure?
> Thank you.

reporting services email

My log file has an error similar to the following
ReportingServicesService!session!f2c!10/14/2005-03:00:08:: i INFO:
LoadSnapshot: Item with session: iigoz455gctymte3ajhp2q55, reportPath:
/Reports/Order and Shipment Reports/Daily Sales By Qty, userName:
DomainName\administrator not found in the database
However the email was sent successfully accoring to the log file
We have users that say some reports they get and some they dont
The way we are sending the reports is DomainName\administrator is actually
doing the subscriptions and putting multiple email addressess in the To:
field
What does the error DomainName\administrator not found in the database
mean?To add to previous post. The report server web app, report server db and
exchange server are all on different servers
"Will Byron" <will@.maxq.com> wrote in message
news:ulkIqKO0FHA.3180@.TK2MSFTNGP14.phx.gbl...
> My log file has an error similar to the following
>
> ReportingServicesService!session!f2c!10/14/2005-03:00:08:: i INFO:
> LoadSnapshot: Item with session: iigoz455gctymte3ajhp2q55, reportPath:
> /Reports/Order and Shipment Reports/Daily Sales By Qty, userName:
> DomainName\administrator not found in the database
>
> However the email was sent successfully accoring to the log file
> We have users that say some reports they get and some they dont
> The way we are sending the reports is DomainName\administrator is actually
> doing the subscriptions and putting multiple email addressess in the To:
> field
> What does the error DomainName\administrator not found in the database
> mean?
>|||We are actually encoutering the same problem. Does anyone have an explanation ?
Grégory.
"Will Byron" wrote:
> To add to previous post. The report server web app, report server db and
> exchange server are all on different servers
> "Will Byron" <will@.maxq.com> wrote in message
> news:ulkIqKO0FHA.3180@.TK2MSFTNGP14.phx.gbl...
> > My log file has an error similar to the following
> >
> >
> > ReportingServicesService!session!f2c!10/14/2005-03:00:08:: i INFO:
> > LoadSnapshot: Item with session: iigoz455gctymte3ajhp2q55, reportPath:
> > /Reports/Order and Shipment Reports/Daily Sales By Qty, userName:
> > DomainName\administrator not found in the database
> >
> >
> > However the email was sent successfully accoring to the log file
> >
> > We have users that say some reports they get and some they dont
> >
> > The way we are sending the reports is DomainName\administrator is actually
> > doing the subscriptions and putting multiple email addressess in the To:
> > field
> >
> > What does the error DomainName\administrator not found in the database
> > mean?
> >
>
>