Showing posts with label occured. Show all posts
Showing posts with label occured. Show all posts

Thursday, March 29, 2012

Error from Distribution clean up

Hi all,
last 9 april 2004 is occured this error:
"Event Type:Warning
Event Source:SQLServerAgent$SQLQRS
Event Category:Printers
Event ID:208
Date:4/9/2004
Time:6:10:06 AM
User:N/A
Computer:
Description:
The description for Event ID ( 208 ) in Source (
SQLServerAgent$SQLQRS ) cannot be found.
The local computer may not have the necessary registry
information or message DLL files to display messages from
a remote computer.
The following information is part of the event:
Distribution clean up: Stride3Distribution,
0xAF771833463E8642AD563AA9C8901B99, Failed, 4/9/2004
6:10:00 AM, The job failed.
Unable to determine if the owner (OTP\sysadmin19) of job
Distribution clean up: Stride3Distribution has server
access (reason: Violation of PRIMARY KEY
constraint 'PK__syscachedcredent__3F9B6DFF'.
Cannot insert duplicate key in
object 'syscachedcredentials'. [SQLSTATE 23000] (Error
2627) The statement has been terminated. [SQLSTATE 01000]
(Error 3621)).."
I need of help, someone can help me, please
EmSga
I have seen part of this error message before:
"Unable to determine if the owner (OTP\sysadmin19) of job
Distribution clean up: Stride3Distribution has server
access."
In this case you can set the job to be owned by sa and avoid the active directory lookup.
As for the rest, can you check that the sql agent running the replication job has the correct rights on the other server.
Regards,
Paul Ibison
sql

Monday, March 26, 2012

Error during printing

I have a report that when I view it in IE works fine. But I try to print it
using custom report printing I am getting an error: An error occured diring
printing. Here is a log entry for that:
aspnet_wp!cache!f28!06/22/2007-15:40:54:: i INFO: Item not cacheable: -
PersistStreams /Accident Reports/AccidentReport
aspnet_wp!chunks!f28!06/22/2007-15:40:54:: i INFO: ###
GetReportChunk('RenderingInfo_IMAGE', 2), chunk was not found!
this=5c9a3ba2-add9-4dcf-b40d-162ec96e65ca
aspnet_wp!reportrendering!f28!06/22/2007-15:40:54:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
An unexpected error has occurred trying to parse the device information XML
structure. Details: The value of the parameter 'OutputFormat' is invalid., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
An unexpected error has occurred trying to parse the device information XML
structure. Details: The value of the parameter 'OutputFormat' is
invalid. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An
unexpected error has occurred trying to parse the device information XML
structure. Details: The value of the parameter 'OutputFormat' is invalid.
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ContextSettings.ParseFormat(String
enumValue, FormatEncoding defaultValue)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ContextSettings.ParseDeviceInfo(NameValueCollection
deviceInfo)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
aspnet_wp!library!f28!06/22/2007-15:40:54::
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
An unexpected error has occurred trying to parse the device information XML
structure. Details: The value of the parameter 'OutputFormat' is
invalid. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An
unexpected error has occurred trying to parse the device information XML
structure. Details: The value of the parameter 'OutputFormat' is invalid.
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ContextSettings.ParseFormat(String
enumValue, FormatEncoding defaultValue)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ContextSettings.ParseDeviceInfo(NameValueCollection
deviceInfo)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Library.RenderAsyncExecutionBase.PerformAsyncWork()
at
Microsoft.ReportingServices.Library.AsyncExecution.AsyncStartMain(Object
state)
aspnet_wp!webserver!154c!06/22/2007-15:40:54:: e ERROR: Reporting Services
error
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
An unexpected error has occurred trying to parse the device information XML
structure. Details: The value of the parameter 'OutputFormat' is
invalid. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An
unexpected error has occurred trying to parse the device information XML
structure. Details: The value of the parameter 'OutputFormat' is invalid.
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ContextSettings.ParseFormat(String
enumValue, FormatEncoding defaultValue)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ContextSettings.ParseDeviceInfo(NameValueCollection
deviceInfo)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
at Microsoft.ReportingServices.Library.AsyncExecution.StartAsyncThread()
at
Microsoft.ReportingServices.Library.RenderAsyncExecutionBase.StartAsyncRender(RSService
rs, CatalogItemContext reportContext, ClientRequest session)
at
Microsoft.ReportingServices.Library.RenderNextAsyncExecution.RenderNext(RSService
rs, CatalogItemContext reportContext, ClientRequest session)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Any idea what the problem is?I fixed it removing RS Print AcitveX. First print will install it. After
that it worked.
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:uGvqU5QtHHA.4916@.TK2MSFTNGP04.phx.gbl...
>I have a report that when I view it in IE works fine. But I try to print it
>using custom report printing I am getting an error: An error occured diring
>printing. Here is a log entry for that:
> aspnet_wp!cache!f28!06/22/2007-15:40:54:: i INFO: Item not cacheable: -
> PersistStreams /Accident Reports/AccidentReport
> aspnet_wp!chunks!f28!06/22/2007-15:40:54:: i INFO: ###
> GetReportChunk('RenderingInfo_IMAGE', 2), chunk was not found!
> this=5c9a3ba2-add9-4dcf-b40d-162ec96e65ca
> aspnet_wp!reportrendering!f28!06/22/2007-15:40:54:: e ERROR: Throwing
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> An unexpected error has occurred trying to parse the device information
> XML structure. Details: The value of the parameter 'OutputFormat' is
> invalid., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> An unexpected error has occurred trying to parse the device information
> XML structure. Details: The value of the parameter 'OutputFormat' is
> invalid. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An
> unexpected error has occurred trying to parse the device information XML
> structure. Details: The value of the parameter 'OutputFormat' is invalid.
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ContextSettings.ParseFormat(String
> enumValue, FormatEncoding defaultValue)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ContextSettings.ParseDeviceInfo(NameValueCollection
> deviceInfo)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
> report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> evaluateHeaderFooterExpressions, CreateAndRegisterStream
> createAndRegisterStreamCallback)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> -- End of inner exception stack trace --
> aspnet_wp!library!f28!06/22/2007-15:40:54::
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> An unexpected error has occurred trying to parse the device information
> XML structure. Details: The value of the parameter 'OutputFormat' is
> invalid. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An
> unexpected error has occurred trying to parse the device information XML
> structure. Details: The value of the parameter 'OutputFormat' is invalid.
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ContextSettings.ParseFormat(String
> enumValue, FormatEncoding defaultValue)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ContextSettings.ParseDeviceInfo(NameValueCollection
> deviceInfo)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
> report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> evaluateHeaderFooterExpressions, CreateAndRegisterStream
> createAndRegisterStreamCallback)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.RenderAsyncExecutionBase.PerformAsyncWork()
> at
> Microsoft.ReportingServices.Library.AsyncExecution.AsyncStartMain(Object
> state)
> aspnet_wp!webserver!154c!06/22/2007-15:40:54:: e ERROR: Reporting Services
> error
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> An unexpected error has occurred trying to parse the device information
> XML structure. Details: The value of the parameter 'OutputFormat' is
> invalid. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An
> unexpected error has occurred trying to parse the device information XML
> structure. Details: The value of the parameter 'OutputFormat' is invalid.
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ContextSettings.ParseFormat(String
> enumValue, FormatEncoding defaultValue)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ContextSettings.ParseDeviceInfo(NameValueCollection
> deviceInfo)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
> report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> evaluateHeaderFooterExpressions, CreateAndRegisterStream
> createAndRegisterStreamCallback)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> -- End of inner exception stack trace --
> at Microsoft.ReportingServices.Library.AsyncExecution.StartAsyncThread()
> at
> Microsoft.ReportingServices.Library.RenderAsyncExecutionBase.StartAsyncRender(RSService
> rs, CatalogItemContext reportContext, ClientRequest session)
> at
> Microsoft.ReportingServices.Library.RenderNextAsyncExecution.RenderNext(RSService
> rs, CatalogItemContext reportContext, ClientRequest session)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> Any idea what the problem is?
>sql