report with ssis package as source

The report having SSIS package as source works fine on my local 32 bit windows xp machine from Report Manager. But same doesn't work from 64bit windows 2003 machine... fails with below error... what could be an issue?

An error has occurred during report processing.

Cannot create a connection to data source 'DataSource1'.

is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)

The same works fine when previewed from visual studio on 64 bit machine.

Thanks

Mahesh

If you search for SSIS AND 64 on these forums, you will find a lot of woes and advice. I don't know anything about the driver you're using for the connection to this datasource, but I suspect that this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=610493&SiteID=1

and similar will be helpful....

>L<

|||

I still could not fix the issue.

I have very simple packages which pulls data from flat file to DataReader Destination. (Data reader destination uses ADO.NET )

Let me know how to make use 32 bit OLE DB and ADO.NET connection providers instead of 64 bit.

Thanks

Mahesh

|||

>> Let me know

I'm afraid I can't do your research for you on this one, just point you to resources.

Did you search the forums? For example,

c. For an OLE DB provider to be available only in 32bit (i.e. JET), does not necessarily mean that you cannot run it on 64bit machines. You can, but it will be in WOW64 emulation mode. The only downside to that is if you need the 64bit address space of huge memory (i.e. greater than 4GB). Otherwise, it’s not a problem.

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

... Which also points to a white paper.

YOu will find more information about the emulation mode here http://ssis.wik.is/64-bit_Story

I'm sorry -- this is all I can do for you.

>L<

|||

The problem got automatically resolved after installing SP2.

Thanks Lisa for trying to help.

|||

Oh for goodness' sakes <sigh>. Thanks for posting back with the answer, I'm sure it will help other people...

>L<

report with ssis package as source

The report having SSIS package as source works fine on my local 32 bit windows xp machine from Report Manager. But same doesn't work from 64bit windows 2003 machine... fails with below error... what could be an issue?

An error has occurred during report processing.

Cannot create a connection to data source 'DataSource1'.

is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)

The same works fine when previewed from visual studio on 64 bit machine.

Thanks

Mahesh

If you search for SSIS AND 64 on these forums, you will find a lot of woes and advice. I don't know anything about the driver you're using for the connection to this datasource, but I suspect that this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=610493&SiteID=1

and similar will be helpful....

>L<

|||

I still could not fix the issue.

I have very simple packages which pulls data from flat file to DataReader Destination. (Data reader destination uses ADO.NET )

Let me know how to make use 32 bit OLE DB and ADO.NET connection providers instead of 64 bit.

Thanks

Mahesh

|||

>> Let me know

I'm afraid I can't do your research for you on this one, just point you to resources.

Did you search the forums? For example,

c. For an OLE DB provider to be available only in 32bit (i.e. JET), does not necessarily mean that you cannot run it on 64bit machines. You can, but it will be in WOW64 emulation mode. The only downside to that is if you need the 64bit address space of huge memory (i.e. greater than 4GB). Otherwise, it’s not a problem.

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

... Which also points to a white paper.

YOu will find more information about the emulation mode here http://ssis.wik.is/64-bit_Story

I'm sorry -- this is all I can do for you.

>L<

|||

The problem got automatically resolved after installing SP2.

Thanks Lisa for trying to help.

|||

Oh for goodness' sakes <sigh>. Thanks for posting back with the answer, I'm sure it will help other people...

>L<

report with ssis package as source

The report having SSIS package as source works fine on my local 32 bit windows xp machine from Report Manager. But same doesn't work from 64bit windows 2003 machine... fails with below error... what could be an issue?

An error has occurred during report processing.

Cannot create a connection to data source 'DataSource1'.

is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)

The same works fine when previewed from visual studio on 64 bit machine.

Thanks

Mahesh

If you search for SSIS AND 64 on these forums, you will find a lot of woes and advice. I don't know anything about the driver you're using for the connection to this datasource, but I suspect that this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=610493&SiteID=1

and similar will be helpful....

>L<

|||

I still could not fix the issue.

I have very simple packages which pulls data from flat file to DataReader Destination. (Data reader destination uses ADO.NET )

Let me know how to make use 32 bit OLE DB and ADO.NET connection providers instead of 64 bit.

Thanks

Mahesh

|||

>> Let me know

I'm afraid I can't do your research for you on this one, just point you to resources.

Did you search the forums? For example,

c. For an OLE DB provider to be available only in 32bit (i.e. JET), does not necessarily mean that you cannot run it on 64bit machines. You can, but it will be in WOW64 emulation mode. The only downside to that is if you need the 64bit address space of huge memory (i.e. greater than 4GB). Otherwise, it’s not a problem.

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

... Which also points to a white paper.

YOu will find more information about the emulation mode here http://ssis.wik.is/64-bit_Story

I'm sorry -- this is all I can do for you.

>L<

|||

The problem got automatically resolved after installing SP2.

Thanks Lisa for trying to help.

|||

Oh for goodness' sakes <sigh>. Thanks for posting back with the answer, I'm sure it will help other people...

>L<

Report Viewer Toolbar Style messed up

Hi All,
When I run a report from Report Manager or from a URL using the ReportViewer
the toolbar looses all styling - it runs down over several lines. I am using
RS 2005 and have also got a RS2000 set-up where we don't have this problem. I
have tried to put in the reference to the stylesheet in the URL access but it
hasn't done anything. Anyone know what the problem could be here? Everything
else in RS2005 works fine.
I also have a problem with Dundas Charts. When accessing the reports via a
URL the charts display if I put in &rc:Toolbar=True but if I put
&rc:Toolbar=False then the Charts don't display and I get a box with a red
cross in it. On the report there are also some tables of data and these
display in both cases.
Any answers to the above much appreciated!
Thanks
RichardHi Richard -
Did you ever get this sorted out? I'm having the same problem, too. I do
have a feeling this is a Win2K3 issue, but just want to guidance as to what
it could be.
Microsoft dudes -- any ideas here?
Thanks,
Brent
"Richard" wrote:
> Hi All,
> When I run a report from Report Manager or from a URL using the ReportViewer
> the toolbar looses all styling - it runs down over several lines. I am using
> RS 2005 and have also got a RS2000 set-up where we don't have this problem. I
> have tried to put in the reference to the stylesheet in the URL access but it
> hasn't done anything. Anyone know what the problem could be here? Everything
> else in RS2005 works fine.
> I also have a problem with Dundas Charts. When accessing the reports via a
> URL the charts display if I put in &rc:Toolbar=True but if I put
> &rc:Toolbar=False then the Charts don't display and I get a box with a red
> cross in it. On the report there are also some tables of data and these
> display in both cases.
> Any answers to the above much appreciated!
> Thanks
> Richardsql

Report updates not Saving

Hi,

I have a problem when uploading changes/ new reports to the report manager. I can get to the upload file screen, I can even browse to the .rdl file that I want to upload, but then the "OK" button seems to be disabled. I cannot seem to get the Report manager to accept any new reports or changes to the old ones.

I have System Administrator access and everything was working perfectly untill about a week or two ago, no changes were made that I can see.

Please help!

See this tread.

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

Report updates not Saving

Hi,

I have a problem when uploading changes/ new reports to the report manager. I can get to the upload file screen, I can even browse to the .rdl file that I want to upload, but then the "OK" button seems to be disabled. I cannot seem to get the Report manager to accept any new reports or changes to the old ones.

I have System Administrator access and everything was working perfectly untill about a week or two ago, no changes were made that I can see.

Please help!

See this tread.

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

Report Title in Report manager Subscription

Hi,

Is there a way of passing a default parameter value into the subject title on a report subscription?

Currently there are std global variables i.e. @.ReportName was executed at @.ExecutionTime, but what other variables can be passed here to make it more relevant to the recipient?

Thx

so....could do with some help on this, but no replies as yet...

What I have found out is that only some of the global variables can be used such as the ones above, but not all of them.

What other options are there?

Has anyone tried modifying this or is it restricted to @.ReportName and @.ExecutionTime?

any help appreciated.

Thx

Report Timeout Issue

I have a report timeout issue when I view the reports from report manager.
According to execution logs my report ran in about 8 minutes. However,
during the execution the report manager times out after the first minute and
displays action canceled. (The task bar changes from long report link to
"connecting to server bla bla bla". After that, in a few seconds, the error
message pops up.)
While digging through the list, I have found these as possible causes.
1. Set the http connection timeout in IIS where reporting server is
installed.
2. Set Query timeout in RDL
3. Set Web service client timeout.
4. Set reportProcessingTimeout as system level property or report level
property.
In config IIS and RDL time out are set to 600 and 1800 secs respectively.
How can I check web service client timeout and how can I set
reportProcessingTimeout? Are there any other settings I should check for
this issue?
Thanks.
CDIt tooks exactly 60 seconds to RS time out. First the task bar changes from
the address to connecting to server bla bla bla after another minute, Action
Cancelled message popsup.
I was playing with RSReportServer.config file. I changed a few parameters,
which didn't help of course. Is it sufficient to restart RS services and www
service on win 2003 machine to apply the new config settings or do I have to
do something else?
Thanks a lot
CD
"DC" <DC@.yahoo.com> wrote in message
news:u9d2WCBnEHA.1800@.TK2MSFTNGP15.phx.gbl...
> I have a report timeout issue when I view the reports from report manager.
> According to execution logs my report ran in about 8 minutes. However,
> during the execution the report manager times out after the first minute
and
> displays action canceled. (The task bar changes from long report link to
> "connecting to server bla bla bla". After that, in a few seconds, the
error
> message pops up.)
> While digging through the list, I have found these as possible causes.
> 1. Set the http connection timeout in IIS where reporting server is
> installed.
> 2. Set Query timeout in RDL
> 3. Set Web service client timeout.
> 4. Set reportProcessingTimeout as system level property or report level
> property.
> In config IIS and RDL time out are set to 600 and 1800 secs respectively.
> How can I check web service client timeout and how can I set
> reportProcessingTimeout? Are there any other settings I should check for
> this issue?
> Thanks.
> CD
>|||Some more info about my timeout issue. When I run the report from VS,
without restricting parameters, I receive outofmemory error after 10
minutes. If I run the query with a few restricting parameters, the report
shows up properly after 4 minutes, which doesn't happen on report manager.
Here are my config and log files - another wierd thing I realize in my log
files is WebApp log says DatabaseQueryTimeout is not set so default to 30
sec. The other hand report server log file says DatabaseQueryTimeout is set
to '1200' as specified at config file. Any help would be really appriciated.
Thanks.
CD
<Configuration>
<Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAyJKMRfN3j0yU3k4Y0TdabAQAAAAiAAAAUgBlAHA
AbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAO8FzVdcu5BIKubzECnNHiIAAAAA
BIAAAKAAAAAQAAAABnuEnlJ6HCYNdxFNukwafSgBAACS3ffr9Zc2xw/odaxolOYJPVwbU4ypb4/5
gcU64sVF2JxKZtWkmLOZmNQhLimhxd2/rG1O2Cki3apdyDqTkhgrzMRhypP3S8lOY/4Q5Oy2u4RG
ZhMkw/XLkU9qXA5hY6hpOqjIq2B+7gQ2nApDxLhJ/Hxy8SBVqGX/tx5PesCH07v3XAJR0No9Sf0Q
SrvaQMcms1dQ8R+5tPi8yeshK1m0YlFGtFE7AzN9HSQehPC9K5BOZdngTLVgFiYnUq6yFZzChfK0
DafRrp31cMRQoP/lDN0qKg+76OfqyHGQ7dX3Nq3wF+l5x0TbhseBdHYInFHMGTfCO+50yWHPZFJh
QROOcN6dIHOyxdbOlDaVfmqAHW9RWyQo1QaTbYpESZ8yGAuoNcct+MRzYBQAAAD2NINjB49+UjeL
TM/32cM+tm2Efw==</Dsn>
<ConnectionType>Impersonate</ConnectionType>
<LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAyJKMRfN3j0yU3k4Y0TdabAQAAAAiAAAAU
gBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAOINUpgdIZeEXU3n8qnQYtcAAAAA
BIAAAKAAAAAQAAAAsbOR9m0262nd6XCybTV/AiAAAABvYXDGqkvg5P2Zd55SPP6heZyNvw+jyQ+r
Lx6Qmhy7nhQAAAAEvamqoaAIum7GC7mn2c3IiMcUtA==</LogonUser>
<LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAyJKMRfN3j0yU3k4Y0TdabAQAAAAiAAA
AUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAEj5jp/Vyo7KnomNyHH0VwMAAAAA
BIAAAKAAAAAQAAAAuHejR1tO5W9Gf4JKYmy+dRAAAAAQ73ovMYnFVRfG5zOoUQfJFAAAAFuQzeMP
ZLNXEZQEpCbBr6McvXyD
</LogonDomain>
<LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAyJKMRfN3j0yU3k4Y0TdabAQAAAAiAAAAU
gBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAFEWJL8iLEIAFj7aVXNTX5wAAAAA
BIAAAKAAAAAQAAAAToDz75beiDZy9QrFubtrjiAAAADLxPycsLUM9WpDvQhs1fpBWiy9U2RD2eNh
gDQnPgdzfhQAAAC5rw7ykRDPFF4023KVrSatgcBgfQ==</LogonCred>
<InstanceId>MSSQL.1</InstanceId>
<InstallationID>{7a490394-c71b-41a1-982b-c4ad17dc026a}</InstallationID>
<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="InstanceName" Value="MSSQLSERVER"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="600"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="1200"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<MemoryLimit>60</MemoryLimit>
<RecycleTime>720</RecycleTime>
<MaximumMemoryLimit>80</MaximumMemoryLimit>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://10.1.1.61/ReportServer2</UrlRoot>
<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
</Service>
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvide
r,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,Report
ingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>10.1.1.245</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>cem@.hirzel.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,Reportin
gServicesNullDeliveryProvider"/>
</Delivery>
<Render>
<Extension Name="XML"
Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Mi
crosoft.ReportingServices.XmlRendering"/>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsof
t.ReportingServices.NullRendering" Visible="false"/>
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.
ReportingServices.CsvRendering"/>
<Extension Name="IMAGE"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Micros
oft.ReportingServices.ImageRendering"/>
<Extension Name="PDF"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsof
t.ReportingServices.ImageRendering"/>
<Extension Name="HTML4.0"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExte
nsion,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="HTML3.2"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExte
nsion,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="MHTML"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExten
sion,Microsoft.ReportingServices.HtmlRendering"/>
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Micr
osoft.ReportingServices.ExcelRendering"/>
<Extension Name="HTMLOWC"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExt
ension,Microsoft.ReportingServices.HtmlRendering">
<Configuration>
<OWCConfiguration>
<OWCDownloadLocation
language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx<
/OWCDownloadLocation>
<OWCDownloadLocation
language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDown
loadLocation>
<OWCDownloadLocation
language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</O
WCDownloadLocation>
<OWCDownloadLocation
language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.asp
x</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.asp
x</OWCDownloadLocation>
<OWCDownloadLocation
language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</O
WCDownloadLocation>
<OWCDownloadLocation
language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</O
WCDownloadLocation>
<OWCDownloadLocation
language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</
OWCDownloadLocation>
<OWCDownloadLocation
language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</O
WCDownloadLocation>
</OWCConfiguration>
</Configuration>
</Extension>
</Render>
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
oft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
osoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
er,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
soft.ReportingServices.DataExtensions"/>
</Data>
<Security>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,
Microsoft.ReportingServices.Authorization"/>
</Security>
<Authentication>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,
Microsoft.ReportingServices.Authorization"/>
</Authentication>
<EventProcessing>
<Extension Name="SnapShot Extension"
Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,Repo
rtingServicesLibrary">
<Event>
<Type>ReportHistorySnapshotCreated</Type>
</Event>
</Extension>
<Extension Name="Timed Subscription Extension"
Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,Reporting
ServicesLibrary">
<Event>
<Type>TimedSubscription</Type>
</Event>
</Extension>
<Extension Name="Cache Update Extension"
Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEvent
Handler,ReportingServicesLibrary">
<Event>
<Type>SnapshotUpdated</Type>
</Event>
</Extension>
</EventProcessing>
</Extensions>
</Configuration>
----
--
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__09_17_2004_10_24_27.log</Path>
<SystemName>DELL04-02</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!bac!9/17/2004-10:24:27:: i INFO: Reporting Web Server started
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing ConnectionType to
'1' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing IsEventService to
'True' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing PollingInterval
to '10' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing MemoryLimit to
'60' percent as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing MaxQueueThreads
to '0' thread(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing MaxScheduleWait
to '5' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
DatabaseQueryTimeout to '1200' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing InstanceName to
'MSSQLSERVER' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was
not specified in Configuration file.
w3wp!resourceutilities!bac!9/17/2004-10:24:27:: i INFO: Running on 1
physical processors, 2 logical processors
w3wp!resourceutilities!bac!9/17/2004-10:24:27:: i INFO: Reporting Services
starting SKU: Developer
w3wp!runningjobs!bac!9/17/2004-10:24:27:: i INFO: Database Cleanup (Web
Service) timer enabled: Cycle: 600 seconds
w3wp!runningjobs!bac!9/17/2004-10:24:27:: i INFO: Running Requests Scavenger
timer enabled: Cycle: 60 seconds
w3wp!runningjobs!bac!9/17/2004-10:24:27:: i INFO: Running Requests DB timer
enabled: Cycle: 60 seconds
w3wp!runningjobs!bac!9/17/2004-10:24:27:: i INFO: Memory stats update timer
enabled: Cycle: 60 seconds
w3wp!library!c84!09/17/2004-10:24:31:: i INFO: Call to GetPermissions:/
w3wp!crypto!c84!09/17/2004-10:24:31:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!c84!09/17/2004-10:24:31:: i INFO: Exporting public key
w3wp!crypto!c84!09/17/2004-10:24:31:: i INFO: Performing sku validation
w3wp!crypto!c84!09/17/2004-10:24:31:: i INFO: Importing existing encryption
key
w3wp!library!c84!09/17/2004-10:24:32:: i INFO: Call to GetSystemPermissions
w3wp!library!c84!09/17/2004-10:24:37:: i INFO: Call to
GetPermissions:/SalesReport
w3wp!library!c84!09/17/2004-10:24:37:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-10:24:45:: i INFO: Call to
GetPermissions:/SalesReport/BrokerSalesCaseAvgPrice
w3wp!library!bac!09/17/2004-10:24:45:: i INFO: Initializing
EnableIntegratedSecurity to 'True' as specified in Server system
properties.
w3wp!library!c84!09/17/2004-10:24:45:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-10:24:45:: i INFO: Initializing
ResponseBufferSizeKb to default value of '64' KB because it was not
specified in Server system properties.
w3wp!library!bac!09/17/2004-10:24:46:: i INFO: Initializing
UseSessionCookies to 'True' as specified in Server system properties.
w3wp!library!fa4!09/17/2004-10:24:47:: i INFO: Initializing SessionTimeout
to '600' second(s) as specified in Server system properties.
w3wp!library!fa4!09/17/2004-10:24:47:: i INFO: Initializing
SessionAccessTimeout to default value of '600' seconds because it was not
specified in Server system properties.
w3wp!session!fa4!09/17/2004-10:24:47:: i INFO: LoadSnapshot: Item with
session: rvoibn45odxph345gud0ok2d, reportPath:
/SalesReport/BrokerSalesCaseAvgPrice, userName: HIRZEL\cem not found in the
database
w3wp!library!fa4!09/17/2004-10:24:47:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!fa4!09/17/2004-10:24:48:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-10:24:57:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!bac!09/17/2004-10:24:58:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!runningjobs!c84!9/17/2004-10:25:27:: i INFO: Adding: 2 running jobs to
the database
w3wp!library!c84!09/17/2004-10:25:58:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!c84!09/17/2004-10:25:59:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!9/17/2004-10:26:49:: i INFO: Initializing
SqlStreamingBufferSize to default value of '64640' Bytes because it was not
specified in Server system properties.
w3wp!library!bac!9/17/2004-10:26:49:: i INFO: Initializing
SnapshotCompression to 'SQL' as specified in Server system properties.
w3wp!library!bac!09/17/2004-10:26:51:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!bac!09/17/2004-10:26:51:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice', Stream=''
w3wp!runningjobs!434!9/17/2004-10:27:27:: i INFO: Adding: 1 running jobs to
the database
w3wp!library!c84!09/17/2004-10:28:12:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!c84!09/17/2004-10:28:12:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice', Stream=''
w3wp!library!fa4!09/17/2004-10:34:26:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!fa4!09/17/2004-10:34:27:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice', Stream=''
w3wp!library!bac!9/17/2004-10:34:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!9/17/2004-10:44:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-10:54:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-11:04:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-11:14:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!09/17/2004-11:18:56:: i INFO: Call to GetPermissions:/
w3wp!library!c84!09/17/2004-11:18:56:: i INFO: Call to GetSystemPermissions
w3wp!library!c84!9/17/2004-11:24:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-11:34:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-11:44:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-11:54:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-12:04:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-12:14:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!9/17/2004-12:24:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-12:34:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-12:44:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-12:54:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!9/17/2004-13:04:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!9/17/2004-13:14:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!09/17/2004-13:22:31:: i INFO: Call to GetPermissions:/
w3wp!library!fa4!09/17/2004-13:22:31:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-13:22:38:: i INFO: Call to
GetPermissions:/SalesReport
w3wp!library!bac!09/17/2004-13:22:38:: i INFO: Call to GetSystemPermissions
w3wp!library!fa4!09/17/2004-13:22:43:: i INFO: Call to
GetPermissions:/SalesReport/BrokerSalesCaseAvgPrice
w3wp!library!fa4!09/17/2004-13:22:43:: i INFO: Call to GetSystemPermissions
w3wp!library!fa4!09/17/2004-13:22:47:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!fa4!09/17/2004-13:22:47:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-13:22:55:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!bac!09/17/2004-13:22:55:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-13:23:07:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!bac!09/17/2004-13:23:07:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice', Stream=''
w3wp!webserver!bac!09/17/2004-13:23:08:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice',
Stream='b6e1061c-d8bd-46da-a12f-bc592acf8a64'
w3wp!webserver!8c!09/17/2004-13:23:09:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice',
Stream='ad1c7113-7c0f-4fe4-9cbe-c8cc01f79e68'
w3wp!webserver!8c!09/17/2004-13:23:09:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice',
Stream='ad1c7113-7c0f-4fe4-9cbe-c8cc01f79e68'
w3wp!library!bac!09/17/2004-13:23:16:: i INFO: Call to
GetPermissions:/SalesReport
w3wp!library!bac!09/17/2004-13:23:16:: i INFO: Call to GetSystemPermissions
w3wp!library!8c!09/17/2004-13:23:18:: i INFO: Call to
GetPermissions:/SalesReport/BrokerSalesInCases
w3wp!library!8c!09/17/2004-13:23:19:: i INFO: Call to GetSystemPermissions
w3wp!library!8c!09/17/2004-13:23:27:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesInCases' )
w3wp!runningjobs!bac!9/17/2004-13:23:27:: i INFO: Adding: 1 running jobs to
the database
w3wp!library!8c!09/17/2004-13:23:28:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!8c!09/17/2004-13:23:33:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!8c!09/17/2004-13:23:33:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases', Stream=''
w3wp!webserver!8c!09/17/2004-13:23:34:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!webserver!bac!09/17/2004-13:23:34:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='e047512a-ef5d-4b99-b028-d5393752f24f'
w3wp!webserver!8c!09/17/2004-13:23:34:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!library!8c!09/17/2004-13:23:38:: i INFO: Call to RenderNext(
'/SalesReport/BrokerSalesInCases' )
w3wp!cache!8c!09/17/2004-13:23:38:: i INFO: Session live:
/SalesReport/BrokerSalesInCases
w3wp!webserver!8c!09/17/2004-13:23:38:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases', Stream=''
w3wp!webserver!8c!09/17/2004-13:23:39:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='e047512a-ef5d-4b99-b028-d5393752f24f'
w3wp!webserver!bac!09/17/2004-13:23:39:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!webserver!8c!09/17/2004-13:23:39:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!library!8c!09/17/2004-13:23:40:: i INFO: Call to RenderNext(
'/SalesReport/BrokerSalesInCases' )
w3wp!cache!8c!09/17/2004-13:23:40:: i INFO: Session live:
/SalesReport/BrokerSalesInCases
w3wp!webserver!8c!09/17/2004-13:23:40:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases', Stream=''
w3wp!webserver!8c!09/17/2004-13:23:41:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!webserver!bac!09/17/2004-13:23:41:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='e047512a-ef5d-4b99-b028-d5393752f24f'
w3wp!webserver!8c!09/17/2004-13:23:41:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!library!8c!09/17/2004-13:23:42:: i INFO: Call to RenderNext(
'/SalesReport/BrokerSalesInCases' )
w3wp!cache!8c!09/17/2004-13:23:43:: i INFO: Session live:
/SalesReport/BrokerSalesInCases
w3wp!webserver!8c!09/17/2004-13:23:43:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases', Stream=''
w3wp!webserver!bac!09/17/2004-13:23:43:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!webserver!8c!09/17/2004-13:23:43:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='e047512a-ef5d-4b99-b028-d5393752f24f'
w3wp!webserver!8c!09/17/2004-13:23:43:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!library!bac!09/17/2004-13:23:49:: i INFO: Call to
GetPermissions:/SalesReport
w3wp!library!bac!09/17/2004-13:23:50:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-13:23:52:: i INFO: Call to
GetPermissions:/SalesReport/CustomerSalesByBillingAccount
w3wp!library!bac!09/17/2004-13:23:53:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-13:24:07:: i INFO: Call to RenderFirst(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!library!bac!09/17/2004-13:24:08:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-13:24:19:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!bac!09/17/2004-13:24:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!webserver!8c!09/17/2004-13:24:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!webserver!bac!09/17/2004-13:24:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='9c7edb88-15f2-4934-9b0a-c5ba442891b8'
w3wp!webserver!8c!09/17/2004-13:24:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!library!934!09/17/2004-13:24:22:: i INFO: Call to RenderNext(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!cache!934!09/17/2004-13:24:22:: i INFO: Session live:
/SalesReport/CustomerSalesByBillingAccount
w3wp!webserver!934!09/17/2004-13:24:22:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!webserver!bac!09/17/2004-13:24:23:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='9c7edb88-15f2-4934-9b0a-c5ba442891b8'
w3wp!webserver!934!09/17/2004-13:24:23:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!webserver!bac!09/17/2004-13:24:23:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!library!934!9/17/2004-13:24:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!09/17/2004-13:24:53:: i INFO: Call to RenderFirst(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!library!bac!09/17/2004-13:24:54:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-13:25:03:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!bac!09/17/2004-13:25:03:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!webserver!934!09/17/2004-13:25:03:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='9c7edb88-15f2-4934-9b0a-c5ba442891b8'
w3wp!webserver!bac!09/17/2004-13:25:03:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!webserver!934!09/17/2004-13:25:03:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!library!8c!09/17/2004-13:25:08:: i INFO: Call to RenderNext(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!cache!8c!09/17/2004-13:25:08:: i INFO: Session live:
/SalesReport/CustomerSalesByBillingAccount
w3wp!webserver!8c!09/17/2004-13:25:08:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!webserver!8c!09/17/2004-13:25:08:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='9c7edb88-15f2-4934-9b0a-c5ba442891b8'
w3wp!webserver!bac!09/17/2004-13:25:08:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!webserver!8c!09/17/2004-13:25:09:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!library!8c!09/17/2004-13:25:15:: i INFO: Call to RenderNext(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!chunks!8c!09/17/2004-13:25:15:: i INFO: ###
GetReportChunk('RenderingInfo_EXCEL', 2), chunk was not found!
this=4a2b5a60-bf8e-4e04-8652-7435411127e1
w3wp!cache!8c!09/17/2004-13:25:19:: i INFO: Session live:
/SalesReport/CustomerSalesByBillingAccount
w3wp!webserver!8c!09/17/2004-13:25:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!library!8c!09/17/2004-13:32:59:: i INFO: Call to CreateReport(
'CustomerSalesByBillingAccount', '/SalesReport', def)
w3wp!library!8c!09/17/2004-13:32:59:: i INFO: Call to SetReportDefinition(
'/SalesReport/CustomerSalesByBillingAccount', def )
w3wp!library!8c!9/17/2004-13:34:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
---
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerWebApp__09_17_2004_10_24_17.log</Path>
<SystemName>DELL04-02</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing MaxScheduleWait
to default value of '1' second(s) because it was not specified in
Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing InstanceName to
default value of 'MSSQLSERVER.1' because it was not specified in
Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
RunningRequestsAge to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was not
specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was
not specified in Configuration file.|||Check the IIS timeout for the Report Manager website.

Report Subscription with Attachement

Hi there.
I have the following issue with all report subscriptions that I setup from
the Report manager that have attached the report files, regardless the format.
The e-mail is properly sent with a file of the proper name but of zero file
size.
It seems to work when I set the render format to Web Archive.( I saw this
tip from this newsgroup).
Any ideas on how to make the attachments work properly?
Thanks
MPIf you are using a Lotus email server this is a known issue and there is a
fix for it here:
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Minas Papageorgiou" <MinasPapageorgiou@.discussions.microsoft.com> wrote in
message news:734CF1A0-9302-4B94-A80E-D4EF5427C9CA@.microsoft.com...
> Hi there.
> I have the following issue with all report subscriptions that I setup from
> the Report manager that have attached the report files, regardless the
format.
> The e-mail is properly sent with a file of the proper name but of zero
file
> size.
> It seems to work when I set the render format to Web Archive.( I saw this
> tip from this newsgroup).
> Any ideas on how to make the attachments work properly?
> Thanks
> MP
>

Report Services Manager Permissions

I have an issue with setting up permissions on report services manager. I
have four folders that represent different companies, and I have created
users on this server, that are set up to be browsers on selected folders.
None of theses users should have rights to view the other folders, unless
being added on the security permissions.
The problem we are having is when a user logs on, they can still view the
other folders, and change their own and others permission settings to
something else.
Any help would be much appreciated.
Thanks,Did you turn anonymous access on? If so then all users will look like the
same user and you would have no security.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonas Avellana"
<jonas.a@.REMOVECAPS_ANDCHANGEINVALIDETOCOMsoftworksgroup.invalid> wrote in
message news:6F2FA64A-69B3-4338-A956-0356CA1EB27F@.microsoft.com...
> I have an issue with setting up permissions on report services manager. I
> have four folders that represent different companies, and I have created
> users on this server, that are set up to be browsers on selected folders.
> None of theses users should have rights to view the other folders, unless
> being added on the security permissions.
> The problem we are having is when a user logs on, they can still view the
> other folders, and change their own and others permission settings to
> something else.
> Any help would be much appreciated.
> Thanks,|||No i turned it off. so when i go on the the report services site, i get
prompted for a logon
"Daniel Reib [MSFT]" wrote:
> Did you turn anonymous access on? If so then all users will look like the
> same user and you would have no security.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jonas Avellana"
> <jonas.a@.REMOVECAPS_ANDCHANGEINVALIDETOCOMsoftworksgroup.invalid> wrote in
> message news:6F2FA64A-69B3-4338-A956-0356CA1EB27F@.microsoft.com...
> > I have an issue with setting up permissions on report services manager. I
> > have four folders that represent different companies, and I have created
> > users on this server, that are set up to be browsers on selected folders.
> > None of theses users should have rights to view the other folders, unless
> > being added on the security permissions.
> >
> > The problem we are having is when a user logs on, they can still view the
> > other folders, and change their own and others permission settings to
> > something else.
> >
> > Any help would be much appreciated.
> >
> > Thanks,
>
>|||Are you using NT logins? Otherwise, you will have to authenticate to get a
valid user.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonas Avellana"
<jonas.a@.REMOVECAPS_ANDCHANGEINVALIDETOCOMsoftworksgroup.invalid> wrote in
message news:C75EAC14-10EC-4FED-A290-BAA763454E6A@.microsoft.com...
> No i turned it off. so when i go on the the report services site, i get
> prompted for a logon
> "Daniel Reib [MSFT]" wrote:
>> Did you turn anonymous access on? If so then all users will look like
>> the
>> same user and you would have no security.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Jonas Avellana"
>> <jonas.a@.REMOVECAPS_ANDCHANGEINVALIDETOCOMsoftworksgroup.invalid> wrote
>> in
>> message news:6F2FA64A-69B3-4338-A956-0356CA1EB27F@.microsoft.com...
>> > I have an issue with setting up permissions on report services manager.
>> > I
>> > have four folders that represent different companies, and I have
>> > created
>> > users on this server, that are set up to be browsers on selected
>> > folders.
>> > None of theses users should have rights to view the other folders,
>> > unless
>> > being added on the security permissions.
>> >
>> > The problem we are having is when a user logs on, they can still view
>> > the
>> > other folders, and change their own and others permission settings to
>> > something else.
>> >
>> > Any help would be much appreciated.
>> >
>> > Thanks,
>>|||Yes I am, the user is an NT user.
"Brian Welcker [MSFT]" wrote:
> Are you using NT logins? Otherwise, you will have to authenticate to get a
> valid user.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Jonas Avellana"
> <jonas.a@.REMOVECAPS_ANDCHANGEINVALIDETOCOMsoftworksgroup.invalid> wrote in
> message news:C75EAC14-10EC-4FED-A290-BAA763454E6A@.microsoft.com...
> > No i turned it off. so when i go on the the report services site, i get
> > prompted for a logon
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Did you turn anonymous access on? If so then all users will look like
> >> the
> >> same user and you would have no security.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Jonas Avellana"
> >> <jonas.a@.REMOVECAPS_ANDCHANGEINVALIDETOCOMsoftworksgroup.invalid> wrote
> >> in
> >> message news:6F2FA64A-69B3-4338-A956-0356CA1EB27F@.microsoft.com...
> >> > I have an issue with setting up permissions on report services manager.
> >> > I
> >> > have four folders that represent different companies, and I have
> >> > created
> >> > users on this server, that are set up to be browsers on selected
> >> > folders.
> >> > None of theses users should have rights to view the other folders,
> >> > unless
> >> > being added on the security permissions.
> >> >
> >> > The problem we are having is when a user logs on, they can still view
> >> > the
> >> > other folders, and change their own and others permission settings to
> >> > something else.
> >> >
> >> > Any help would be much appreciated.
> >> >
> >> > Thanks,
> >>
> >>
> >>
>
>|||Jonas,
did you get a resolution to your problem? I am having the same problem with
users having general access to everything.
"Jonas Avellana" wrote:
> Yes I am, the user is an NT user.
> "Brian Welcker [MSFT]" wrote:
> > Are you using NT logins? Otherwise, you will have to authenticate to get a
> > valid user.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Jonas Avellana"
> > <jonas.a@.REMOVECAPS_ANDCHANGEINVALIDETOCOMsoftworksgroup.invalid> wrote in
> > message news:C75EAC14-10EC-4FED-A290-BAA763454E6A@.microsoft.com...
> > > No i turned it off. so when i go on the the report services site, i get
> > > prompted for a logon
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > >> Did you turn anonymous access on? If so then all users will look like
> > >> the
> > >> same user and you would have no security.
> > >>
> > >> --
> > >> -Daniel
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >> "Jonas Avellana"
> > >> <jonas.a@.REMOVECAPS_ANDCHANGEINVALIDETOCOMsoftworksgroup.invalid> wrote
> > >> in
> > >> message news:6F2FA64A-69B3-4338-A956-0356CA1EB27F@.microsoft.com...
> > >> > I have an issue with setting up permissions on report services manager.
> > >> > I
> > >> > have four folders that represent different companies, and I have
> > >> > created
> > >> > users on this server, that are set up to be browsers on selected
> > >> > folders.
> > >> > None of theses users should have rights to view the other folders,
> > >> > unless
> > >> > being added on the security permissions.
> > >> >
> > >> > The problem we are having is when a user logs on, they can still view
> > >> > the
> > >> > other folders, and change their own and others permission settings to
> > >> > something else.
> > >> >
> > >> > Any help would be much appreciated.
> > >> >
> > >> > Thanks,
> > >>
> > >>
> > >>
> >
> >
> >

Report Services Instance not found

after re-installing sql server 2005 server reporting services when i start the Reporting Services Configuration Manager a message pops up saying "Not Found", at the instance selection screen. when i type in the name of the server and click find i get the same message.. what am i doing wrong?

THe next steps would be:

-Is the Reporting Service started properly ?
-Which port is Reporting Manager using ? (see in the IIS configuration)
-Do you have Sharepoint installed on the machine ?
-Is the Report Service available ? (e.g. http://localhost/ReportServer)

HTH, Jens Suessmeyer.

http://www.sqslerver2005.de

|||When i go to sql server 2005 surface area to check if the report service is running i see the service listed under Surface area configuration for Services and Connection and it is started by local system. when i go to Surface Area configuration for features and i click on reporting services a message pops up that says Not Found (System.Management) why is this?

Report Server Windows Service

Why does this windows sevice fails in attempt to turn on?
but when i access the rs manager all is fine. when i query the reportservice.asmx?wsdl all is fine.
i access via a seperate app all is fine.
i'm puzzled.Look at the ReportingServicesServer[datetime].log in Reporting
Services\LogFiles directory.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"mg" <mg@.discussions.microsoft.com> wrote in message
news:C9E5654B-75BB-4B99-9132-E05B64D4A7CF@.microsoft.com...
> Why does this windows sevice fails in attempt to turn on?
> but when i access the rs manager all is fine. when i query the
reportservice.asmx?wsdl all is fine.
> i access via a seperate app all is fine.
> i'm puzzled.
>

Report Server URL vs Report Manager URL

What is the difference between Report Server URL and Report Manager URL?
What does the URL's look like when displayed?
Thank you.http://<servername>/reports is basically Report Manager URL
http://<servername>/reportserver is for report server URL, where you deploy.
Is this you had asked for ? let me know if not.
Amarnath, MCTS
"Terry" wrote:
> What is the difference between Report Server URL and Report Manager URL?
> What does the URL's look like when displayed?
> Thank you.|||Thank you very much for your speedy response and assistance.
However, where can I find technical documents using filters with reports in
CRM?
"Amarnath" wrote:
> http://<servername>/reports is basically Report Manager URL
> http://<servername>/reportserver is for report server URL, where you deploy.
> Is this you had asked for ? let me know if not.
> Amarnath, MCTS
> "Terry" wrote:
> > What is the difference between Report Server URL and Report Manager URL?
> >
> > What does the URL's look like when displayed?
> >
> > Thank you.|||Not sure what you are wanting but if what you want to do is to create a URL
that passes the appropriate parameters to a report then what you want is URL
Access (Search on URL phrase in Books Online).
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsprg9/html/52c3f2a3-3d6d-4fee-9c46-83f366919398.htm
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:97149427-8A5F-47AA-8BDF-5595419C9863@.microsoft.com...
> Thank you very much for your speedy response and assistance.
> However, where can I find technical documents using filters with reports
> in
> CRM?
> "Amarnath" wrote:
>> http://<servername>/reports is basically Report Manager URL
>> http://<servername>/reportserver is for report server URL, where you
>> deploy.
>> Is this you had asked for ? let me know if not.
>> Amarnath, MCTS
>> "Terry" wrote:
>> > What is the difference between Report Server URL and Report Manager
>> > URL?
>> >
>> > What does the URL's look like when displayed?
>> >
>> > Thank you.

report server problem

I have installed SQL 2005 reporting services and I configured it using
Reporting Services Configuration. Now I tried to access to report manager
using http://servername/Reports with login I used to start reporting
services. It doesn't work and keep prompting me for login and password. But
no use and I am sure this login is correct and password correct and it
started the reportings services successfully. Can anyone please help how to
solve this problem. Thanks.On Oct 24, 9:06 pm, "Andrew Backer" <a...@.b.com> wrote:
> I have installed SQL 2005 reporting services and I configured it using
> Reporting Services Configuration. Now I tried to access to report manager
> usinghttp://servername/Reportswith login I used to start reporting
> services. It doesn't work and keep prompting me for login and password. But
> no use and I am sure this login is correct and password correct and it
> started the reportings services successfully. Can anyone please help how to
> solve this problem. Thanks.
If you are using a browser other than Internet Explorer, this is the
default behavior. Otherwise, you will want to make sure that you do
not have the either the Reports or ReportServer virtual directory set
to anonymous access (via: right-click My Computer >> select Manage >>
select Services and Applications >> Internet Information Services >>
Web Sites >> Default Web Site >> right-click Reports/ReportServer >>
select Properties >> select the Directory Security tab >> select the
Edit... button). also, make sure that the login you are using has
Browser rights/privileges in the Report Manager. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
In fact, I am using IE. When I use IE in the server, it asked
me to login and always fails me. When I use IE in the client PC, it don't
ask me for login and just gives me "HTTP status 400: Bad reqeust" directly.
Can you please tell me what user login being used in client PC and what in
server? Please help. Thanks.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1193279009.940293.80780@.v23g2000prn.googlegroups.com...
> On Oct 24, 9:06 pm, "Andrew Backer" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report manager
>> usinghttp://servername/Reportswith login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>
> If you are using a browser other than Internet Explorer, this is the
> default behavior. Otherwise, you will want to make sure that you do
> not have the either the Reports or ReportServer virtual directory set
> to anonymous access (via: right-click My Computer >> select Manage >>
> select Services and Applications >> Internet Information Services >>
> Web Sites >> Default Web Site >> right-click Reports/ReportServer >>
> select Properties >> select the Directory Security tab >> select the
> Edit... button). also, make sure that the login you are using has
> Browser rights/privileges in the Report Manager. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Oct 24, 9:52 pm, "Andrew Backer" <a...@.b.com> wrote:
> Enrique,
> In fact, I am using IE. When I use IE in the server, it asked
> me to login and always fails me. When I use IE in the client PC, it don't
> ask me for login and just gives me "HTTP status 400: Bad reqeust" directly.
> Can you please tell me what user login being used in client PC and what in
> server? Please help. Thanks.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1193279009.940293.80780@.v23g2000prn.googlegroups.com...
> > On Oct 24, 9:06 pm, "Andrew Backer" <a...@.b.com> wrote:
> >> I have installed SQL 2005 reporting services and I configured it using
> >> Reporting Services Configuration. Now I tried to access to report manager
> >> usinghttp://servername/Reportswithlogin I used to start reporting
> >> services. It doesn't work and keep prompting me for login and password.
> >> But
> >> no use and I am sure this login is correct and password correct and it
> >> started the reportings services successfully. Can anyone please help how
> >> to
> >> solve this problem. Thanks.
> > If you are using a browser other than Internet Explorer, this is the
> > default behavior. Otherwise, you will want to make sure that you do
> > not have the either the Reports or ReportServer virtual directory set
> > to anonymous access (via: right-click My Computer >> select Manage >>
> > select Services and Applications >> Internet Information Services >>
> > Web Sites >> Default Web Site >> right-click Reports/ReportServer >>
> > select Properties >> select the Directory Security tab >> select the
> > Edit... button). also, make sure that the login you are using has
> > Browser rights/privileges in the Report Manager. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
Generally speaking, it normally uses the service acct that the
Reporting Services is running under (right-click My Computer >> Manage
>> Services and Applications >> Services >> SQL Server Reporting
Services (MSSQLSERVER) >> right-click the service >> select Properties
>> Logon tab >> look below: Logon as: This account). Also, if you have
the virtual directories security set to Anonymous (via using my
previous posting's directions), you will want to check Properties. It
will say: Anonymous access >> User Account IUSR_... Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Report Server First Time Configuration: Provider Load Failure

I'm trying to do the above using the Reporting Services Configuration Manager and I can't even connect. I get the error Provider Load Failure.

Anyone got any pointers?

You're using Express?|||Yes|||

Moving to RS forum.

Mike

|||Can anyone help me out on this?|||

This maybe due to issues with the Reporting Services WMI Provider.

Can you make sure you have a ReportingServicesWMI.dll present and of the appropriate version wrt to the config tool?

thanx,
Prash

|||I have the same issue on SQL Server 2005 SP2 - the dll version is correct - I re-installed SQL Server and it's still broken.

WMI service is running - everything else works.|||

Well I figured out my problem, the System PATH variable was missing

C:\windows\system32\wbem

I added it and rebooted and it works properly. It looks like reportingserviceswmi.dll depends on framedyn.dll which is located in the above path.

|||Can you please provide more detail about the solution. I am also facing this problem.|||

Well, there isn't much more to say - make sure %WINDIR%\system32\WBEM is in your PATH. If it is not, the WMI provider library (which depends on FRAMEDYN.DLL) cannot be loaded. (the alternative would be to copy FRAMEDYN.DLL into the directory that has reportingserviceswmi.dll but I would not recommend it)

Some application messed up my PATH variable and the Reporting Services WMI provider would not load. The error handling could be better so we don't have to debug the process to figure it out...

|||

Remill: Thanx, I have spent over half the day looking for the problem, and now it is fixed. You would have thought that MS could have gotten rid of the PATH thing along time ago. Oh Well.

Thanx

Report Server First Time Configuration: Provider Load Failure

I'm trying to do the above using the Reporting Services Configuration Manager and I can't even connect. I get the error Provider Load Failure.

Anyone got any pointers?

You're using Express?|||Yes|||

Moving to RS forum.

Mike

|||Can anyone help me out on this?|||

This maybe due to issues with the Reporting Services WMI Provider.

Can you make sure you have a ReportingServicesWMI.dll present and of the appropriate version wrt to the config tool?

thanx,
Prash

|||I have the same issue on SQL Server 2005 SP2 - the dll version is correct - I re-installed SQL Server and it's still broken.

WMI service is running - everything else works.
|||

Well I figured out my problem, the System PATH variable was missing

C:\windows\system32\wbem

I added it and rebooted and it works properly. It looks like reportingserviceswmi.dll depends on framedyn.dll which is located in the above path.

|||Can you please provide more detail about the solution. I am also facing this problem.|||

Well, there isn't much more to say - make sure %WINDIR%\system32\WBEM is in your PATH. If it is not, the WMI provider library (which depends on FRAMEDYN.DLL) cannot be loaded. (the alternative would be to copy FRAMEDYN.DLL into the directory that has reportingserviceswmi.dll but I would not recommend it)

Some application messed up my PATH variable and the Reporting Services WMI provider would not load. The error handling could be better so we don't have to debug the process to figure it out...

|||

Remill: Thanx, I have spent over half the day looking for the problem, and now it is fixed. You would have thought that MS could have gotten rid of the PATH thing along time ago. Oh Well.

Thanx

Report Server First Time Configuration: Provider Load Failure

I'm trying to do the above using the Reporting Services Configuration Manager and I can't even connect. I get the error Provider Load Failure.

Anyone got any pointers?

You're using Express?|||Yes|||

Moving to RS forum.

Mike

|||Can anyone help me out on this?|||

This maybe due to issues with the Reporting Services WMI Provider.

Can you make sure you have a ReportingServicesWMI.dll present and of the appropriate version wrt to the config tool?

thanx,
Prash

|||I have the same issue on SQL Server 2005 SP2 - the dll version is correct - I re-installed SQL Server and it's still broken.

WMI service is running - everything else works.|||

Well I figured out my problem, the System PATH variable was missing

C:\windows\system32\wbem

I added it and rebooted and it works properly. It looks like reportingserviceswmi.dll depends on framedyn.dll which is located in the above path.

|||Can you please provide more detail about the solution. I am also facing this problem.|||

Well, there isn't much more to say - make sure %WINDIR%\system32\WBEM is in your PATH. If it is not, the WMI provider library (which depends on FRAMEDYN.DLL) cannot be loaded. (the alternative would be to copy FRAMEDYN.DLL into the directory that has reportingserviceswmi.dll but I would not recommend it)

Some application messed up my PATH variable and the Reporting Services WMI provider would not load. The error handling could be better so we don't have to debug the process to figure it out...

|||

Remill: Thanx, I have spent over half the day looking for the problem, and now it is fixed. You would have thought that MS could have gotten rid of the PATH thing along time ago. Oh Well.

Thanx

Report Server FileShare Subscription example

I write .net code to create subsciption instead of report manager. Is there
any example talking about Subscription using Report Server FileShare ? I
only find the example of Report Server Email subscription in Books online. I
try the following code and I successfully create subscription. But when I
try to edit it, error is shown - "Object reference not set to an instance of
an object"
The code is as follows:
Dim FileNamePara As New ParameterValue
FileNamePara.Name = "File Name"
FileNamePara.Value = "Invoice Summary "
extensionParams(0) = FileNamePara
Dim PathPara As New ParameterValue
PathPara.Name = "Path"
PathPara.Value = "\\shkg013devfs\temp\may"
extensionParams(1) = PathPara
Dim renderPara As New ParameterValue
renderPara.Name = "RenderFormat"
renderPara.Value = "PDF"
extensionParams(2) = renderPara
settings.ParameterValues = extensionParams
Dim datRptGenTime As Date
datRptGenTime = DateAdd(DateInterval.Day, 1, Now)
Dim eventType As String = "TimedSubscription"
Dim matchData As String = "<ScheduleDefinition>" & _
"<StartDateTime>" & datRptGenTime.Year & "-" & _
IIf(datRptGenTime.Month < 10, "0" & datRptGenTime.Month,
datRptGenTime.Month) & "-" & _
IIf(datRptGenTime.Day < 10, "0" & datRptGenTime.Day, datRptGenTime.Day) &
"T08:00:00" & _
"+08:00</StartDateTime>" & _
"</ScheduleDefinition>"
Try
mRSProxyUtil.rs.CreateSubscription(ReportName, settings, sEmaiDesc,
eventType, matchData, parameters)
Catch e As SoapException
Console.WriteLine(e.Detail.InnerText.ToString())
End TryI'm not sure why you are getting the object reference error. Is RS
returning it?
Anyway, you are not using the correct setting names. To find the correct
names call GetExtensionSettings. This will return a list of extension names
that the extension excepts. There is a flag that will tell you if the
setting is required or not.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:E022B2B3-B882-4E6D-A836-03CC0AE19675@.microsoft.com...
>I write .net code to create subsciption instead of report manager. Is
>there
> any example talking about Subscription using Report Server FileShare ?
> I
> only find the example of Report Server Email subscription in Books online.
> I
> try the following code and I successfully create subscription. But when I
> try to edit it, error is shown - "Object reference not set to an instance
> of
> an object"
> The code is as follows:
> Dim FileNamePara As New ParameterValue
> FileNamePara.Name = "File Name"
> FileNamePara.Value = "Invoice Summary "
> extensionParams(0) = FileNamePara
> Dim PathPara As New ParameterValue
> PathPara.Name = "Path"
> PathPara.Value = "\\shkg013devfs\temp\may"
> extensionParams(1) = PathPara
> Dim renderPara As New ParameterValue
> renderPara.Name = "RenderFormat"
> renderPara.Value = "PDF"
> extensionParams(2) = renderPara
> settings.ParameterValues = extensionParams
> Dim datRptGenTime As Date
> datRptGenTime = DateAdd(DateInterval.Day, 1, Now)
> Dim eventType As String = "TimedSubscription"
> Dim matchData As String = "<ScheduleDefinition>" & _
> "<StartDateTime>" & datRptGenTime.Year & "-" & _
> IIf(datRptGenTime.Month < 10, "0" & datRptGenTime.Month,
> datRptGenTime.Month) & "-" & _
> IIf(datRptGenTime.Day < 10, "0" & datRptGenTime.Day, datRptGenTime.Day) &
> "T08:00:00" & _
> "+08:00</StartDateTime>" & _
> "</ScheduleDefinition>"
> Try
> mRSProxyUtil.rs.CreateSubscription(ReportName, settings, sEmaiDesc,
> eventType, matchData, parameters)
> Catch e As SoapException
> Console.WriteLine(e.Detail.InnerText.ToString())
> End Try

Report Server Configuration Manager 100% CPU

SQL2K8 July CTP. After installing and selecting self-configure option openned RS Configuration Manager UI and selected Instance. Report Server Status page appears ok. 10.0.1049.14 in native mode.

Clicked on "Web Service URL" and CPU pegged at 100%. WmiPrvSE.exe consuming approx 85% CPU. Running on Windows Server 2008 Beta 3 within a single VPC 2007 684MB session - hardware is recent Centrino Duo HP laptop with 2GB RAM. After 30 mins Config Manager still unresponsive.

Is this a known bug?

I had exact same problem, but later i found out that Longhorn is not supported with SQL 2008?!! So i installed on a 2003 server and everything seems to be OK. This sure looks like a bug.|||

We are still working out some bugs in LH support and expect this to be supported in the next CTP.

Report Server Configuration Manager 100% CPU

SQL2K8 July CTP. After installing and selecting self-configure option openned RS Configuration Manager UI and selected Instance. Report Server Status page appears ok. 10.0.1049.14 in native mode.

Clicked on "Web Service URL" and CPU pegged at 100%. WmiPrvSE.exe consuming approx 85% CPU. Running on Windows Server 2008 Beta 3 within a single VPC 2007 684MB session - hardware is recent Centrino Duo HP laptop with 2GB RAM. After 30 mins Config Manager still unresponsive.

Is this a known bug?

I had exact same problem, but later i found out that Longhorn is not supported with SQL 2008?!! So i installed on a 2003 server and everything seems to be OK. This sure looks like a bug.|||

We are still working out some bugs in LH support and expect this to be supported in the next CTP.