Hello,
I am having some subscription problems.
Some background information.
I am using forms authentication and it works without any problems
except for subscriptions.
I can create the subscriptions but when it comes time for them to
deploy themselves they fail with an "Object reference not set to an
instance of an object." error. I have posted my error log and
reportserver.config files below
Error Log
==================================================================
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration
file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as
specified in Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing SecureConnectionLevel to '3' as specified in
Configuration file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration
file.
ReportingServicesService!library!1294!11/8/2005-09:09:21:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!1294!11/8/2005-09:09:21:: i
INFO: Running on 4 physical processors, 8 logical processors
ReportingServicesService!resourceutilities!1294!11/8/2005-09:09:21:: i
INFO: Reporting Services starting SKU: Enterprise
ReportingServicesService!runningjobs!1294!11/8/2005-09:09:21:: i INFO:
Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds.
Cycle: 600 seconds
ReportingServicesService!runningjobs!1294!11/8/2005-09:09:21:: i INFO:
Running Requests Scavenger timer enabled: Next Event: 60 seconds.
Cycle: 60 seconds
ReportingServicesService!runningjobs!1294!11/8/2005-09:09:21:: i INFO:
Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60
seconds
ReportingServicesService!runningjobs!1294!11/8/2005-09:09:21:: i INFO:
Execution Log Entry Expiration timer enabled: Next Event: 60638
seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!1294!11/8/2005-09:09:21:: i INFO:
Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60
seconds
ReportingServicesService!crypto!1d68!11/8/2005-09:09:21:: i INFO:
Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!1d68!11/8/2005-09:09:21:: i INFO:
Exporting public key
ReportingServicesService!crypto!1d68!11/8/2005-09:09:21:: i INFO:
Performing sku validation
ReportingServicesService!crypto!1d68!11/8/2005-09:09:21:: i INFO:
Importing existing encryption key
ReportingServicesService!dbpolling!1d68!11/08/2005-09:09:21::
EventPolling polling service started
ReportingServicesService!dbpolling!1d68!11/08/2005-09:09:21::
NotificationPolling polling service started
ReportingServicesService!dbpolling!1d68!11/08/2005-09:09:21::
SchedulePolling polling service started
ReportingServicesService!dbpolling!1774!11/8/2005-09:09:21::
EventPolling heartbeat thread started.
ReportingServicesService!dbpolling!1d28!11/8/2005-09:09:21::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!1abc!11/8/2005-09:09:21:: Polling
started
ReportingServicesService!dbpolling!1abc!11/8/2005-09:10:04::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1dc4!11/8/2005-09:10:04::
EventPolling processing item 5c39fcf6-cb0e-4031-bf1f-f2bb23d8d529
ReportingServicesService!library!1dc4!11/8/2005-09:10:04:: Schedule
12593999-14ca-4d36-ae9b-0ac4dae3212e executed at 11/8/2005 9:10:04 AM.
ReportingServicesService!schedule!1dc4!11/8/2005-09:10:04:: Creating
Time based subscription notification for subscription:
a2bda3e2-1c59-4af1-a9de-e8fee833402b
ReportingServicesService!library!1dc4!11/8/2005-09:10:04:: Schedule
12593999-14ca-4d36-ae9b-0ac4dae3212e execution completed at 11/8/2005
9:10:04 AM.
ReportingServicesService!dbpolling!1dc4!11/8/2005-09:10:04::
EventPolling finished processing item
5c39fcf6-cb0e-4031-bf1f-f2bb23d8d529
ReportingServicesService!dbpolling!1abc!11/8/2005-09:10:04::
NotificationPolling processing 1 more items. 1 Total items in internal
queue.
ReportingServicesService!dbpolling!1dc4!11/8/2005-09:10:04::
NotificationPolling processing item
b6790fa9-9631-41b9-a6a8-6da92a58fa41
ReportingServicesService!notification!1dc4!11/08/2005-09:10:04:: e
ERROR: Error occured processing notification. Object reference not set
to an instance of an object.
ReportingServicesService!notification!1dc4!11/08/2005-09:10:04::
Notification b6790fa9-9631-41b9-a6a8-6da92a58fa41 completed. Success:
True, Status: Object reference not set to an instance of an object.,
DeliveryExtension: Report Server Email, Report: Community
Participation, Attempt 0
ReportingServicesService!dbpolling!1dc4!11/08/2005-09:10:04::
NotificationPolling finished processing item
b6790fa9-9631-41b9-a6a8-6da92a58fa41
ReportingServicesService!dbpolling!1abc!11/8/2005-09:15:11::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!18c4!11/8/2005-09:15:11::
EventPolling processing item 87302473-85e9-4aa5-8981-c649a9c9bf95
ReportingServicesService!library!18c4!11/8/2005-09:15:11:: Schedule
12593999-14ca-4d36-ae9b-0ac4dae3212e executed at 11/8/2005 9:15:11 AM.
ReportingServicesService!schedule!18c4!11/8/2005-09:15:11:: Creating
Time based subscription notification for subscription:
a2bda3e2-1c59-4af1-a9de-e8fee833402b
ReportingServicesService!library!18c4!11/8/2005-09:15:11:: Schedule
12593999-14ca-4d36-ae9b-0ac4dae3212e execution completed at 11/8/2005
9:15:11 AM.
ReportingServicesService!dbpolling!18c4!11/8/2005-09:15:11::
EventPolling finished processing item
87302473-85e9-4aa5-8981-c649a9c9bf95
ReportingServicesService!dbpolling!1abc!11/8/2005-09:15:11::
NotificationPolling processing 1 more items. 1 Total items in internal
queue.
ReportingServicesService!dbpolling!18c4!11/8/2005-09:15:11::
NotificationPolling processing item
f2d0d694-77aa-4c6e-ba3c-d07d4d126df8
ReportingServicesService!notification!18c4!11/08/2005-09:15:11:: e
ERROR: Error occured processing notification. Object reference not set
to an instance of an object.
ReportingServicesService!notification!18c4!11/08/2005-09:15:11::
Notification f2d0d694-77aa-4c6e-ba3c-d07d4d126df8 completed. Success:
True, Status: Object reference not set to an instance of an object.,
DeliveryExtension: Report Server Email, Report: Community
Participation, Attempt 0
ReportingServicesService!dbpolling!18c4!11/08/2005-09:15:11::
NotificationPolling finished processing item
f2d0d694-77aa-4c6e-ba3c-d07d4d126df8
ReportingServicesService!dbpolling!1294!11/8/2005-09:15:18::
EventPolling polling service stopped
ReportingServicesService!dbpolling!1774!11/8/2005-09:15:18::
EventPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!1294!11/8/2005-09:15:18::
NotificationPolling polling service stopped
ReportingServicesService!dbpolling!1d28!11/8/2005-09:15:18::
NotificationPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!1294!11/8/2005-09:15:18::
SchedulePolling polling service stopped
ReportingServicesService!servicecontroller!1294!11/8/2005-09:15:18::
Service controller exiting.
===================================================================
Report Server.config file
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<Configuration>
<Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAALqCSKyGy50uybz5o87etZAQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAFkZ6kisw6+JGH5X7xgL6O0AAAAA
BIAAAKAAAAAQAAAApToFH/QSkmPiAsJwZBHepyABAAAUpIZt13uhvdUpGvnyyj8i5xHaMDhJCOXI
yQoo6J2Yl5T83RPcNqY95Gj1kSAKXS1NMNCa0kOjSIBfqrWWru1TgjwWQEuOod9V/8gv1SlPy7R4
59xJ4P5twSFWCWAfGrCOugmYEX7k6xnXFZDp5AxNirELSd8+omsQYFmmLeilxwjlh5lq8N3I3Kyw
qhVPf89wgwRKPYaoJd27QPoi1vtpd0uzczOJvOG1GQ1Ysr/16b7hS7TmWp4jkm/Y7vavuU+t0K5v
sUD/de/B1V0ZXL4Mv4UPac+469Gt84uSMyvJcXRRATKaTlTps0aQk2NfvMsnvBU1ejXxcdSsEoWO
gZY1bcp4hFdJfDotgEtMtkkJzYyhZezHJYIVojSjolQrsxEUAAAAhdDEzPaJ1NNuMilDRM+DkRna
6vc=</Dsn>
<ConnectionType>Default</ConnectionType>
<LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAALqCSKyGy50uybz5o87etZAQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAF4s06iMzeIzoqOnsWBVhuYAAAAA
BIAAAKAAAAAQAAAANyOJ5ZNPeYoXzpsz0RIw+AgAAADJ5Vl8p33lpBQAAAC2vUJBWqHHI+KrF2zc
L2RaqG1dgQ==</LogonUser>
<LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAALqCSKyGy50uybz5o87etZAQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAOhVyWDz3CWAjVPHDbhci2kAAAAA
BIAAAKAAAAAQAAAAWUo5Z6PzuzbPY+0KZMoPGQgAAAC1gfw/sjgPmBQAAAC8RlBM9mNMtHbyD/dx
YyhYKQEmqA==</LogonDomain>
<LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAALqCSKyGy50uybz5o87etZAQAAAAiAAAAUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAALd+s6akF4aGqer/gGNIof4AAAAA
BIAAAKAAAAAQAAAAe4JoefEVmQuyKMjqaH2/RggAAACzCK0MqD0jyBQAAAAyYC1ndjRrVCF3VN7Z
lX7mIG4vKw==</LogonCred>
<InstanceId>MSSQL.1</InstanceId>
<InstallationID>{f57e456a-b491-4349-903f-c7889109f7ca}</InstallationID>
<Add Key="SecureConnectionLevel" Value="3"/>
<Add Key="InstanceName" Value="MSSQLSERVER"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="60"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="120"/>
<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>https://xxxx.xxx.xxx/ReportServer</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.FileShareProvider,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,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>127.0.0.1</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory>C:\Inetpub\mailroot\Pickup</SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>1</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>devteam@cvm.msu.edu</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>False</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts>127.0.0.1</PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
<Render>
<Extension Name="XML"
Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.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,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="PDF"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="HTML4.0"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRenderi
ng" Visible="false"/>
<Extension Name="HTML3.2"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRenderi
ng" Visible="false"/>
<Extension Name="MHTML"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRenderin
g"/>
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
<Extension Name="HTMLOWC"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRender
ing">
<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</OWCDownloadLocation>
<OWCDownloadLocation
language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</OWCDownloadLocation>
<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</OWCDownloadLocation>
</OWCConfiguration>
</Configuration>
</Extension>
</Render>
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions
"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
</Data>
<Security>
<Extension Name="Forms"
Type="CVM.SQLReportingSecurity.Authorization,
CVM.SQLReportingSecurity">
<Configuration>
<AdminConfiguration>
<UserName>xxxxxxx</UserName>
</AdminConfiguration>
</Configuration>
</Extension>
</Security>
<Authentication>
<Extension Name="Forms"
Type="CVM.SQLReportingSecurity.AuthenticationExtension,
CVM.SQLReportingSecurity"/>
</Authentication>
<EventProcessing>
<Extension Name="SnapShot Extension"
Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
<Event>
<Type>ReportHistorySnapshotCreated</Type>
</Event>
</Extension>
<Extension Name="Timed Subscription Extension"
Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
<Event>
<Type>TimedSubscription</Type>
</Event>
</Extension>
<Extension Name="Cache Update Extension"
Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
<Event>
<Type>SnapshotUpdated</Type>
</Event>
</Extension>
</EventProcessing>
</Extensions>
</Configuration>
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
I have blocked out some of the information with x's. Any help would be
much appreciated.
Thanks
Mo
M0 - 17 Nov 2005 17:25 GMT
I am still having problems with this any help would be appreciated.
THanks
Mo
M0 - 29 Nov 2005 15:43 GMT
Anyone get forms authentication with subscriptions to work? Everything
else works for me except the subscription part. I can add users,
manage users, login but I can't get a subscription to work.
TIA
Mo
WillG - 30 Dec 2005 02:49 GMT
Did you ever get this to work?
I got the sample to work but never got roles figured out.
Any code you have would be usefull.
-Will
It's amazing how many thousands of questions I've seen on the internet about
this topic. Yet I've not seen one post that can answer all the questions,
just pieces.
Is there anyone out there that has a COMPLETE forms auth sample, or the
corrected MSDN forms auth sample that works as a real replacement to WIndows
Auth????
> Anyone get forms authentication with subscriptions to work? Everything
> else works for me except the subscription part. I can add users,
[quoted text clipped - 3 lines]
>
> Mo