Hello everyone!
We have a small problem with one report ,that include VB code.
The code - Vb function ,that connect to Active Directory and return some
value
from DB
When I run my report in local machine I got correctly results,
when I deploy the report - I have #Error.
In the custom code I did all necessary references .
Please help me and sorry for my EnglishOn the server, by default, all code has execute-only privileges. You need to
create a custom assembly to hold this code and then grant addition
permissions to it. See
http://msdn.microsoft.com/SQL/sqlwarehouse/ReportingServices/default.aspx?pull=/library/en-us/dnsql2k/html/dngrfcodeaccesssecurityinsqlserver2000reportingservices.asp.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Vikont" <Vikont@.discussions.microsoft.com> wrote in message
news:2328E5C7-7A39-45D4-953E-A79B9B2FF1FD@.microsoft.com...
> Hello everyone!
> We have a small problem with one report ,that include VB code.
> The code - Vb function ,that connect to Active Directory and return some
> value
> from DB
> When I run my report in local machine I got correctly results,
> when I deploy the report - I have #Error.
> In the custom code I did all necessary references .
> Please help me and sorry for my English|||Did you follow the guidance in
http://msdn.microsoft.com/SQL/sqlwarehouse/ReportingServices/default.aspx?pull=/library/en-us/dnsql2k/html/dngrfcodeaccesssecurityinsqlserver2000reportingservices.asp?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Vikont" <Vikont@.discussions.microsoft.com> wrote in message
news:2328E5C7-7A39-45D4-953E-A79B9B2FF1FD@.microsoft.com...
> Hello everyone!
> We have a small problem with one report ,that include VB code.
> The code - Vb function ,that connect to Active Directory and return some
> value
> from DB
> When I run my report in local machine I got correctly results,
> when I deploy the report - I have #Error.
> In the custom code I did all necessary references .
> Please help me and sorry for my English
Showing posts with label include. Show all posts
Showing posts with label include. Show all posts
Tuesday, March 27, 2012
Thursday, March 22, 2012
Email Subscriptions
I have my email set up and it works fine when I email the link, however when
I try to include the report in the email I get the following error message.
Failure sending mail: An internal error occurred on the report server. See
the error log for more details. Is this a set up issue?
Thanks.Not necessarily. Can you post the log file. At least the relevant part.
The log file is called ReportServerService<timestamp>.log
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"nscotia17" <nscotia17@.discussions.microsoft.com> wrote in message
news:81B6C46C-CD66-4721-9BB1-6454D9C4F85D@.microsoft.com...
>I have my email set up and it works fine when I email the link, however
>when
> I try to include the report in the email I get the following error
> message.
> Failure sending mail: An internal error occurred on the report server. See
> the error log for more details. Is this a set up issue?
> Thanks.|||Here is the log file when trying to email an attached report through
subscriptions.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Mountain Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__03_07_2005_15_19_09.log</Path>
<SystemName>NAVSUAPP702</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!1c48!3/7/2005-15:19:10:: i INFO:
Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!1c48!3/7/2005-15:19:10:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 38449 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO: Memory
stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Initializing
crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Exporting
public key
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Performing
sku validation
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!e00!03/07/2005-15:19:10:: EventPolling
polling service started
ReportingServicesService!dbpolling!e00!03/07/2005-15:19:10::
NotificationPolling polling service started
ReportingServicesService!dbpolling!e00!03/07/2005-15:19:10:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!c20!3/7/2005-15:19:10:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!1e9c!3/7/2005-15:19:10::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!1fb0!3/7/2005-15:19:10:: Polling started
ReportingServicesService!library!1c48!3/7/2005-15:29:10:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 1
chunks, 0 running jobs
ReportingServicesService!dbpolling!1fb0!3/7/2005-15:30:05:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1c48!3/7/2005-15:30:05:: EventPolling
processing item 9872c0b5-f8dc-4387-97dd-d206e5819124
ReportingServicesService!library!1c48!3/7/2005-15:30:05:: Schedule
dceba956-d832-453e-b603-b735093c283e executed at 3/7/2005 3:30:05 PM.
ReportingServicesService!schedule!1c48!3/7/2005-15:30:05:: Creating Time
based subscription notification for subscription:
5acf26d9-5330-466d-8b5d-32a563bd8c51
ReportingServicesService!library!1c48!3/7/2005-15:30:05:: Schedule
dceba956-d832-453e-b603-b735093c283e execution completed at 3/7/2005 3:30:05
PM.
ReportingServicesService!dbpolling!1c48!3/7/2005-15:30:05:: EventPolling
finished processing item 9872c0b5-f8dc-4387-97dd-d206e5819124
ReportingServicesService!dbpolling!1fb0!3/7/2005-15:30:05::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1c48!3/7/2005-15:30:05::
NotificationPolling processing item f391b132-a040-4f87-ab13-f53ffe36096a
ReportingServicesService!library!1c48!03/07/2005-15:30:05:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!1c48!03/07/2005-15:30:06:: i INFO: Call to
RenderFirst( '/PMAC Test/Net SalesC6' )
ReportingServicesService!library!1c48!03/07/2005-15:30:06:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.InvalidOperationException: The key 'RsDbPassword' does
not exist in the appSettings configuration section.
at System.Configuration.AppSettingsReader.GetValue(String key, Type type)
at Navitaire.dotRez.Reporting.Extensions.Security.Utils.getAppSettings()
at
Navitaire.dotRez.Reporting.Extensions.Security.Utils.GetConfigurationInfo(String settingName)
at
Navitaire.dotRez.Reporting.Extensions.Security.Authorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
-- End of inner exception stack trace --
ReportingServicesService!library!1c48!03/07/2005-15:30:06:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1c48!03/07/2005-15:30:06:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
An internal error occurred on the report server. See the error log for more
details. -->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.InvalidOperationException: The key 'RsDbPassword' does
not exist in the appSettings configuration section.
at System.Configuration.AppSettingsReader.GetValue(String key, Type type)
at Navitaire.dotRez.Reporting.Extensions.Security.Utils.getAppSettings()
at
Navitaire.dotRez.Reporting.Extensions.Security.Utils.GetConfigurationInfo(String settingName)
at
Navitaire.dotRez.Reporting.Extensions.Security.Authorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!1c48!03/07/2005-15:30:06::
Notification f391b132-a040-4f87-ab13-f53ffe36096a completed. Success: False,
Status: Failure sending mail: An internal error occurred on the report
server. See the error log for more details., DeliveryExtension: Report Server
Email, Report: Net SalesC6, Attempt 0
ReportingServicesService!dbpolling!1c48!03/07/2005-15:30:06::
NotificationPolling finished processing item
f391b132-a040-4f87-ab13-f53ffe36096a
ReportingServicesService!library!1c48!03/07/2005-15:39:10:: Using folder
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles
for temporary files.
ReportingServicesService!library!1c48!03/07/2005-15:39:10:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 2 snapshots, 6
chunks, 0 running jobs
Thanks.
"Daniel Reib [MSFT]" wrote:
> Not necessarily. Can you post the log file. At least the relevant part.
> The log file is called ReportServerService<timestamp>.log
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "nscotia17" <nscotia17@.discussions.microsoft.com> wrote in message
> news:81B6C46C-CD66-4721-9BB1-6454D9C4F85D@.microsoft.com...
> >I have my email set up and it works fine when I email the link, however
> >when
> > I try to include the report in the email I get the following error
> > message.
> > Failure sending mail: An internal error occurred on the report server. See
> > the error log for more details. Is this a set up issue?
> > Thanks.
>
>
I try to include the report in the email I get the following error message.
Failure sending mail: An internal error occurred on the report server. See
the error log for more details. Is this a set up issue?
Thanks.Not necessarily. Can you post the log file. At least the relevant part.
The log file is called ReportServerService<timestamp>.log
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"nscotia17" <nscotia17@.discussions.microsoft.com> wrote in message
news:81B6C46C-CD66-4721-9BB1-6454D9C4F85D@.microsoft.com...
>I have my email set up and it works fine when I email the link, however
>when
> I try to include the report in the email I get the following error
> message.
> Failure sending mail: An internal error occurred on the report server. See
> the error log for more details. Is this a set up issue?
> Thanks.|||Here is the log file when trying to email an attached report through
subscriptions.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Mountain Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__03_07_2005_15_19_09.log</Path>
<SystemName>NAVSUAPP702</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!1c48!3/7/2005-15:19:09:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!1c48!3/7/2005-15:19:10:: i INFO:
Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!1c48!3/7/2005-15:19:10:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 38449 seconds
ReportingServicesService!runningjobs!1c48!3/7/2005-15:19:10:: i INFO: Memory
stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Initializing
crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Exporting
public key
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Performing
sku validation
ReportingServicesService!crypto!e00!3/7/2005-15:19:10:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!e00!03/07/2005-15:19:10:: EventPolling
polling service started
ReportingServicesService!dbpolling!e00!03/07/2005-15:19:10::
NotificationPolling polling service started
ReportingServicesService!dbpolling!e00!03/07/2005-15:19:10:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!c20!3/7/2005-15:19:10:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!1e9c!3/7/2005-15:19:10::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!1fb0!3/7/2005-15:19:10:: Polling started
ReportingServicesService!library!1c48!3/7/2005-15:29:10:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 1
chunks, 0 running jobs
ReportingServicesService!dbpolling!1fb0!3/7/2005-15:30:05:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1c48!3/7/2005-15:30:05:: EventPolling
processing item 9872c0b5-f8dc-4387-97dd-d206e5819124
ReportingServicesService!library!1c48!3/7/2005-15:30:05:: Schedule
dceba956-d832-453e-b603-b735093c283e executed at 3/7/2005 3:30:05 PM.
ReportingServicesService!schedule!1c48!3/7/2005-15:30:05:: Creating Time
based subscription notification for subscription:
5acf26d9-5330-466d-8b5d-32a563bd8c51
ReportingServicesService!library!1c48!3/7/2005-15:30:05:: Schedule
dceba956-d832-453e-b603-b735093c283e execution completed at 3/7/2005 3:30:05
PM.
ReportingServicesService!dbpolling!1c48!3/7/2005-15:30:05:: EventPolling
finished processing item 9872c0b5-f8dc-4387-97dd-d206e5819124
ReportingServicesService!dbpolling!1fb0!3/7/2005-15:30:05::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1c48!3/7/2005-15:30:05::
NotificationPolling processing item f391b132-a040-4f87-ab13-f53ffe36096a
ReportingServicesService!library!1c48!03/07/2005-15:30:05:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!1c48!03/07/2005-15:30:06:: i INFO: Call to
RenderFirst( '/PMAC Test/Net SalesC6' )
ReportingServicesService!library!1c48!03/07/2005-15:30:06:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.InvalidOperationException: The key 'RsDbPassword' does
not exist in the appSettings configuration section.
at System.Configuration.AppSettingsReader.GetValue(String key, Type type)
at Navitaire.dotRez.Reporting.Extensions.Security.Utils.getAppSettings()
at
Navitaire.dotRez.Reporting.Extensions.Security.Utils.GetConfigurationInfo(String settingName)
at
Navitaire.dotRez.Reporting.Extensions.Security.Authorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
-- End of inner exception stack trace --
ReportingServicesService!library!1c48!03/07/2005-15:30:06:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1c48!03/07/2005-15:30:06:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
An internal error occurred on the report server. See the error log for more
details. -->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.InvalidOperationException: The key 'RsDbPassword' does
not exist in the appSettings configuration section.
at System.Configuration.AppSettingsReader.GetValue(String key, Type type)
at Navitaire.dotRez.Reporting.Extensions.Security.Utils.getAppSettings()
at
Navitaire.dotRez.Reporting.Extensions.Security.Utils.GetConfigurationInfo(String settingName)
at
Navitaire.dotRez.Reporting.Extensions.Security.Authorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!1c48!03/07/2005-15:30:06::
Notification f391b132-a040-4f87-ab13-f53ffe36096a completed. Success: False,
Status: Failure sending mail: An internal error occurred on the report
server. See the error log for more details., DeliveryExtension: Report Server
Email, Report: Net SalesC6, Attempt 0
ReportingServicesService!dbpolling!1c48!03/07/2005-15:30:06::
NotificationPolling finished processing item
f391b132-a040-4f87-ab13-f53ffe36096a
ReportingServicesService!library!1c48!03/07/2005-15:39:10:: Using folder
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles
for temporary files.
ReportingServicesService!library!1c48!03/07/2005-15:39:10:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 2 snapshots, 6
chunks, 0 running jobs
Thanks.
"Daniel Reib [MSFT]" wrote:
> Not necessarily. Can you post the log file. At least the relevant part.
> The log file is called ReportServerService<timestamp>.log
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "nscotia17" <nscotia17@.discussions.microsoft.com> wrote in message
> news:81B6C46C-CD66-4721-9BB1-6454D9C4F85D@.microsoft.com...
> >I have my email set up and it works fine when I email the link, however
> >when
> > I try to include the report in the email I get the following error
> > message.
> > Failure sending mail: An internal error occurred on the report server. See
> > the error log for more details. Is this a set up issue?
> > Thanks.
>
>
Friday, March 9, 2012
Email a DB - supplementary question
Thanks guys
Thats really helpful.
What if I wanted to include data from some of the tables (such as lookup
tables).
Kind regards
Ross Petersen
"Chandra" wrote:
> hi
> you can generate the script and then e-mail the script to the destination
> please let me know if u have any questions
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://groups.msn.com/SQLResource/
> ---
>
> "Ross" wrote:
>You can include INSERT Scripts for that table.
See http://vyaskn.tripod.com/code.htm#inserts
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
"Ross" <Ross@.discussions.microsoft.com> wrote in message
news:D6FD9EFA-59A4-4AA9-B46A-D62420A4AEBF@.microsoft.com...
> Thanks guys
> Thats really helpful.
> What if I wanted to include data from some of the tables (such as lookup
> tables).
> Kind regards
> Ross Petersen
>
> "Chandra" wrote:
>|||Hi Ross
You can add INSERT .. statement in the script file. once the script is
executed, you will have all the objects with data in lookup tables
please let me know if you have any questions
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Ross" wrote:
> Thanks guys
> Thats really helpful.
> What if I wanted to include data from some of the tables (such as lookup
> tables).
> Kind regards
> Ross Petersen
>
> "Chandra" wrote:
>|||Hi fellers
Many thanks for your help.
Kind regards
Ross Petersen
"Chandra" wrote:
> Hi Ross
> You can add INSERT .. statement in the script file. once the script is
> executed, you will have all the objects with data in lookup tables
> please let me know if you have any questions
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://groups.msn.com/SQLResource/
> ---
>
> "Ross" wrote:
>
Thats really helpful.
What if I wanted to include data from some of the tables (such as lookup
tables).
Kind regards
Ross Petersen
"Chandra" wrote:
> hi
> you can generate the script and then e-mail the script to the destination
> please let me know if u have any questions
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://groups.msn.com/SQLResource/
> ---
>
> "Ross" wrote:
>You can include INSERT Scripts for that table.
See http://vyaskn.tripod.com/code.htm#inserts
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
"Ross" <Ross@.discussions.microsoft.com> wrote in message
news:D6FD9EFA-59A4-4AA9-B46A-D62420A4AEBF@.microsoft.com...
> Thanks guys
> Thats really helpful.
> What if I wanted to include data from some of the tables (such as lookup
> tables).
> Kind regards
> Ross Petersen
>
> "Chandra" wrote:
>|||Hi Ross
You can add INSERT .. statement in the script file. once the script is
executed, you will have all the objects with data in lookup tables
please let me know if you have any questions
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Ross" wrote:
> Thanks guys
> Thats really helpful.
> What if I wanted to include data from some of the tables (such as lookup
> tables).
> Kind regards
> Ross Petersen
>
> "Chandra" wrote:
>|||Hi fellers
Many thanks for your help.
Kind regards
Ross Petersen
"Chandra" wrote:
> Hi Ross
> You can add INSERT .. statement in the script file. once the script is
> executed, you will have all the objects with data in lookup tables
> please let me know if you have any questions
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://groups.msn.com/SQLResource/
> ---
>
> "Ross" wrote:
>
Subscribe to:
Posts (Atom)