all groups > sql server reporting services > august 2004 >
You're in the

sql server reporting services

group:

SUBSCRIPTION PROBLEMS


Re: SUBSCRIPTION PROBLEMS Daniel Reib [MSFT]
8/11/2004 9:56:32 AM
sql server reporting services:
How does it fail? Does the report not run or can you not create the
subscription?

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Re: SUBSCRIPTION PROBLEMS Daniel Reib [MSFT]
8/11/2004 10:47:14 AM
If you can view the report via the web then your connection is still good.
Can you look in the reportserverservice<date>.log file and try and find the
error that is being thrown when the subscription fires.

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

SUBSCRIPTION PROBLEMS Estefania
8/11/2004 6:52:16 PM
I have a report that works correctly in interactive mode and fails when I
program a subscription. I think it works perfectly until I modified the
rsreportserver.config. with the rsconfig.exe utility and I haven't a backup
of the file. Any idea?

Re: SUBSCRIPTION PROBLEMS Estefania
8/11/2004 7:11:36 PM
I can create the suscription but the report doesn´t run. I have a
subscription to receive the report by mail, but it doesn't work and with the
same parameters works in interactive mode. I think that could be
permissions problems because I executed the rsconfig.exe utility without
parameters by error and I'm afraid that this modified the configuration
file.




"Daniel Reib [MSFT]" <danreib@online.microsoft.com> escribió en el mensaje
news:%23GUkxQ8fEHA.3916@TK2MSFTNGP11.phx.gbl...
[quoted text, click to view]

Re: SUBSCRIPTION PROBLEMS Daniel Reib [MSFT]
8/12/2004 9:50:19 AM
Hmm, I'm not really sure what could be going on here. My guess is that
perhaps CDO is not installed correctly. Can you verify that cdosys.dll and
cdo.dll are on the machine an registered?

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]
Re: SUBSCRIPTION PROBLEMS Estefania
8/12/2004 10:03:38 AM
I send you the part of the logs
(ReportServerService__08_12_2004_04_51_30.log,ReportServer__08_12_2004_09_34
_02.log ) thrown when the subscription fires and fails.I don't know what's
going on? The subscription was programmed to fires at 9:43.

************************************************************************
ReportServer__08_12_2004_09_34_02.log
w3wp!library!86c!08/12/2004-09:44:57:: i INFO: Call to GetPermissions:/
w3wp!library!ce4!08/12/2004-09:44:57:: i INFO: Call to GetSystemPermissions
w3wp!library!cd4!08/12/2004-09:44:59:: i INFO: Call to
GetPermissions:/Informes
w3wp!library!cd4!08/12/2004-09:44:59:: i INFO: Call to GetSystemPermissions
w3wp!library!8c4!08/12/2004-09:45:00:: i INFO: Call to
GetPermissions:/Informes/Ventas
w3wp!library!cd4!08/12/2004-09:45:00:: i INFO: Call to GetSystemPermissions
w3wp!library!86c!08/12/2004-09:45:05:: i INFO: Call to
GetPermissions:/Informes/Ventas/Informe telefonicoEspana
w3wp!library!ce4!08/12/2004-09:45:05:: i INFO: Call to GetSystemPermissions
w3wp!library!8c4!08/12/2004-09:45:06:: i INFO: Call to RenderFirst(
'/Informes/Ventas/Informe telefonicoEspana' )
w3wp!library!86c!08/12/2004-09:45:06:: i INFO: Call to
GetPermissions:/Informes/Ventas/Informe telefonicoEspana
w3wp!library!86c!08/12/2004-09:45:06:: i INFO: Call to GetSystemPermissions
w3wp!runningjobs!554!8/12/2004-09:46:02:: i INFO:
RunningJobContext.IsClientConnected; found orphaned request
w3wp!runningjobs!ce4!8/12/2004-09:46:02:: i INFO: Adding: 1 running jobs to
the database
w3wp!processing!554!8/12/2004-09:46:02:: i INFO: Merge abort handler called.
Aborting data sources ...
w3wp!processing!554!8/12/2004-09:46:02:: i INFO: Data source 'Maestros':
Abort handler called. CanAbort = False.
w3wp!processing!554!8/12/2004-09:46:02:: i INFO: Data source 'Almacen':
Abort handler called. CanAbort = True.
w3wp!processing!554!8/12/2004-09:46:02:: i INFO: Data source 'Ventas': Abort
handler called. CanAbort = True.
w3wp!processing!554!8/12/2004-09:46:02:: i INFO: Data set 'Consulta':
Cancelling command.
w3wp!processing!554!8/12/2004-09:46:02:: i INFO: Abort callback successful.
w3wp!processing!86c!12/08/2004-09:46:49:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
Report processing has been canceled by the user. , ;
Info:
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
Report processing has been canceled by the user.
w3wp!processing!86c!12/08/2004-09:46:49:: w WARN: Data set 'Consulta':
Report processing has been aborted.
w3wp!processing!86c!12/08/2004-09:46:49:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
Report processing has been canceled by the user. , ;
Info:
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
Report processing has been canceled by the user.
w3wp!processing!86c!12/08/2004-09:46:49:: e ERROR: Data source 'Ventas': An
error has occurred. Details:
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
Report processing has been canceled by the user.
at Microsoft.ReportingServices.ReportProcessing.b.c()
at Microsoft.ReportingServices.ReportProcessing.z.af()
at Microsoft.ReportingServices.ReportProcessing.s.a()
w3wp!processing!86c!12/08/2004-09:46:49:: w WARN: Data source 'Ventas':
Report processing has been aborted.
w3wp!processing!8c4!12/08/2004-09:46:49:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: El
usuario ha cancelado el procesamiento del informe. , ;
Info:
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: El
usuario ha cancelado el procesamiento del informe.
w3wp!library!8c4!08/12/2004-09:46:49:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!8c4!08/12/2004-09:46:56:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: El usuario ha
cancelado el procesamiento del informe. --->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: El
usuario ha cancelado el procesamiento del informe.



************************************************************************
ReportServerService__08_12_2004_04_51_30.log
ReportingServicesService!dbpolling!b20!8/12/2004-09:43:09:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!b6c!8/12/2004-09:43:09:: EventPolling
processing item 37b82838-053a-44c3-befd-69fd06b3b6c0
ReportingServicesService!library!b6c!8/12/2004-09:43:09:: Schedule
e4480eec-8290-4009-8c5b-0468dc70adea executed at 8/12/2004 9:43:09 AM.
ReportingServicesService!schedule!b6c!8/12/2004-09:43:09:: Creating Time
based subscription notification for subscription:
683bba37-6b6e-4654-ba6f-57196ee8e8bd
ReportingServicesService!library!b6c!8/12/2004-09:43:09:: Schedule
e4480eec-8290-4009-8c5b-0468dc70adea execution completed at 8/12/2004
9:43:09 AM.
ReportingServicesService!dbpolling!b20!8/12/2004-09:43:09:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!bec!8/12/2004-09:43:09:: EventPolling
processing item ecf01862-0df0-4ae3-8b5d-0a73d8feed2c
ReportingServicesService!dbpolling!b6c!8/12/2004-09:43:09:: EventPolling
finished processing item 37b82838-053a-44c3-befd-69fd06b3b6c0
ReportingServicesService!dbpolling!bec!8/12/2004-09:43:09:: EventPolling
finished processing item ecf01862-0df0-4ae3-8b5d-0a73d8feed2c
ReportingServicesService!library!b6c!08/12/2004-09:43:10:: i INFO:
Initializing SqlStreamingBufferSize to default value of '65536' Bytes
because it was not specified in Server system properties.
ReportingServicesService!dbpolling!b6c!08/12/2004-09:43:11::
NotificationPolling processing item bc4b36c1-4ff5-459f-afcb-5c636d935590
ReportingServicesService!dbpolling!bec!8/12/2004-09:43:11::
NotificationPolling processing item 1d3fc2ed-9d92-467e-9d33-dd217de7e686
ReportingServicesService!dbpolling!b40!8/12/2004-09:43:11::
NotificationPolling processing item 3e60f018-2190-4d09-9eb8-67edca0b6ee1
ReportingServicesService!dbpolling!b20!8/12/2004-09:43:11::
NotificationPolling processing 4 more items. 4 Total items in internal
queue.
ReportingServicesService!dbpolling!eb0!8/12/2004-09:43:11::
NotificationPolling processing item a18725d9-63b9-4d2e-8c8a-e09a9b639afc
ReportingServicesService!emailextension!bec!08/12/2004-09:43:11:: Error
sending email. System.NullReferenceException: Object reference not set to an
instance of an object.
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
e(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
ReportingServicesService!emailextension!b6c!08/12/2004-09:43:11:: Error
Re: SUBSCRIPTION PROBLEMS Estefania
8/13/2004 10:24:19 AM
I found cdosys.dll in c:\windows\system32 and it's correctly registered but
i didn't found cdo.dll. However I found in the next folders:
c:\program files\microsoft SQL Server\MSSQL\Reporting
Services\REportServer\bin
c:\program files\microsoft SQL Server\MSSQL\Reporting
Services\REportManager\bin
c:\windows\Microsoft.NET\Framework\v1.1.4322 \Temporary ASP.NET
Files\reports....
c:\windows\Microsoft.NET\Framework\v1.1.4322 \Temporary ASP.NET
Files\reportserver......
ReportingServicesCDOInterop.dll I tried to unregister and register again but
I couldn't. It shows me the error message: "Reporting ServicesCDOInterop.dll
was loaded, but the DllUnregisterServer entry point was not found. This file
can not be registerd"

Thanks for your answer, I have no idea of what's hapening...


"Daniel Reib [MSFT]" <danreib@online.microsoft.com> escribió en el mensaje
news:OMzy0xIgEHA.3988@tk2msftngp13.phx.gbl...
[quoted text, click to view]
AddThis Social Bookmark Button