Peer-to-peer Replication Agent Error

Does anyone know why if I setup a p2p replication I get:
"Could not find a valid Agent Id for the subscription to Publisher
XXXServer, ...
Source: MSSQLServer, Error number: 21758"
This message only happens on the replication between SeverA to ServerB...
ServerB replicates to ServerA just fine...
Any help would be appreciated since the link to Microsoft help says the
error is not documented.
Thanks!
Can you post the exact steps you took to configure this? What you are
describing is not peer-to-peer replication, but seems to be bi-directional
transactional instead.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Mick Kowitz" <mkowitz@.cinci.rr.com> wrote in message
news:f%wwf.14644$%D1.9161@.tornado.ohiordc.rr.com.. .
> Does anyone know why if I setup a p2p replication I get:
> "Could not find a valid Agent Id for the subscription to Publisher
> XXXServer, ...
> Source: MSSQLServer, Error number: 21758"
> This message only happens on the replication between SeverA to ServerB...
> ServerB replicates to ServerA just fine...
> Any help would be appreciated since the link to Microsoft help says the
> error is not documented.
> Thanks!
>
|||I actually got it working. The problem was when I was in the peer-to-peer
topology and Adding the SQL Server, I was trying to use Windows
Authentication to connect to the peer, but since I was in a WORKGROUP that
wasn't working. As soon as I made it connect with SQL Authentication it
worked...
I'm wondering if you have any ideas, though, on a new problem...
I have a table in the p2p replication that has an IDENTITY column as the key
and an on INSERT trigger to add a second record. When I replicate, it fails
telling me to turn NOT FOR REPLICATION to NO. I found the MS article
http://support.microsoft.com/?kbid=908711 on this. However, I can't set NOT
FOR REPLICATION to NO in a p2p situation as far as I can tell. It's easily
reproduced. Just create a simple table with primary key as an IDENTITY
column and then an ON INSERT trigger to add a second row. When you create
the publication and try to run the P2P Topology stuff it blows off telling
you that you can't do p2p when set to manual.
Any ideas?
Mick...
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:u9eJiGVFGHA.1028@.TK2MSFTNGP11.phx.gbl...
> Can you post the exact steps you took to configure this? What you are
> describing is not peer-to-peer replication, but seems to be bi-directional
> transactional instead.
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "Mick Kowitz" <mkowitz@.cinci.rr.com> wrote in message
> news:f%wwf.14644$%D1.9161@.tornado.ohiordc.rr.com.. .
>
|||I actually got it working. The problem was when I was in the peer-to-peer
topology and Adding the SQL Server, I was trying to use Windows
Authentication to connect to the peer, but since I was in a WORKGROUP that
wasn't working. As soon as I made it connect with SQL Authentication it
worked...
I'm wondering if you have any ideas, though, on a new problem...
I have a table in the p2p replication that has an IDENTITY column as the key
and an on INSERT trigger to add a second record. When I replicate, it fails
telling me to turn NOT FOR REPLICATION to NO. I found the MS article
http://support.microsoft.com/?kbid=908711 on this. However, I can't set NOT
FOR REPLICATION to NO in a p2p situation as far as I can tell. It's easily
reproduced. Just create a simple table with primary key as an IDENTITY
column and then an ON INSERT trigger to add a second row. When you create
the publication and try to run the P2P Topology stuff it blows off telling
you that you can't do p2p when set to manual.
Any ideas?
Mick...
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:u9eJiGVFGHA.1028@.TK2MSFTNGP11.phx.gbl...
> Can you post the exact steps you took to configure this? What you are
> describing is not peer-to-peer replication, but seems to be bi-directional
> transactional instead.
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "Mick Kowitz" <mkowitz@.cinci.rr.com> wrote in message
> news:f%wwf.14644$%D1.9161@.tornado.ohiordc.rr.com.. .
>

peer to peer replication

Hi,

I set up a peer to peer replication on servers, but only one side seem to be working. I am getting Log Reader Agent job error.

Unable to start execution of step 2 (reason: Error authenticating proxy domain\user, system error: Logon failure: unknown user name or bad password.). The step failed.

I am using the same windows account on both servers, why is one side working and the other side not?

thanks

doublecheck the account and password that starts the job, sqlserver and sqlagent service, and doublecheck their permissions on the machine.

pdssql.dll

I developed small program VB 6.0 and SQL SERVER 2000 but an error happen in displaying any crystal report file with pdssql.dll not found actually this message appear in some of computer, I tried to find this file and copy it in system file but I couldnt found. What the solution of this problem? And is copying pdssql.dll file solution?May check the CD for this file.|||how??|||From FIND FILES utility on Windows.|||Sorry but I can't get your requst|||On Windows from START --> Programs --> Find files and enter the filename and under the lookin specify the CD drive path.

PDF rendering error; log file entries included.

I am having a problem getting a report with many charts to export to PDF.
Currently the report contains 52 line charts (possibility for much more than
that)and fails when the subscription is running. If I only choose data that
returns about 10 or less charts than it will successfully create the PDF.
Is there a file size limitation or another setting I am missing in the
configuration?
Begin of log entries.
ReportingServicesService!reportrendering!f54!02/25/2005-20:37:19:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Threading.ThreadAbortException: Thread was being aborted.
at System.Drawing.SafeNativeMethods.GdipDrawImageRectI(HandleRef
graphics, HandleRef image, Int32 x, Int32 y, Int32 width, Int32 height)
at System.Drawing.Graphics.DrawImage(Image image, Int32 x, Int32 y, Int32
width, Int32 height)
at System.Drawing.Bitmap..ctor(Image original, Int32 width, Int32 height)
at System.Drawing.Bitmap..ctor(Image original)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.Process32bppArgbImages(CanvasImage
image, StringBuilder streamString, StringBuilder imageContentString, Int64&
streamLength)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessImage(CanvasImage
image, Double left, Double top, Double width, Double height, Boolean
scaleImage)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawImage(OutlineObjects
outlines, CanvasImage image, Double left, Double top, Double width, Double
height)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Chart.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ListContent.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.List.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.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)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!runningjobs!f54!02/25/2005-20:37:22:: i INFO:
CancelableJobExecution.Execute caught some other thread abort exception
ReportingServicesService!library!f54!02/25/2005-20:37:22:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!f54!02/25/2005-20:37:24:: Error
sending email. System.Threading.ThreadAbortException: Thread was being
aborted.
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!f54!02/25/2005-20:37:25:: Error thrown
by delivery provider: System.Threading.ThreadAbortException: Thread was being
aborted.
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
at
Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
ReportingServicesService!notification!f54!02/25/2005-20:37:26:: e ERROR:
Error occured processing notification. Thread was being aborted.
ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27::
NotificationPolling no longer processing item
36b6fea8-ebac-4de7-b5ef-74c792df8276, will be requeued
ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27:: Queue worker
thread caught unhandled exception: System.Threading.ThreadAbortException:
Thread was being aborted.
at
Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
at
Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item)
at
Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object
state)Sometimes PDF rendering chews up quite a bit of memory. (Yes, there is room
for optimization if future versions :) You're probably hitting the upper
limits of the machine.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff S." <JeffS@.discussions.microsoft.com> wrote in message
news:FF469815-A1B9-4155-9A62-710DA4EFDBC7@.microsoft.com...
>I am having a problem getting a report with many charts to export to PDF.
> Currently the report contains 52 line charts (possibility for much more
> than
> that)and fails when the subscription is running. If I only choose data
> that
> returns about 10 or less charts than it will successfully create the PDF.
> Is there a file size limitation or another setting I am missing in the
> configuration?
>
> Begin of log entries.
> ReportingServicesService!reportrendering!f54!02/25/2005-20:37:19:: e
> ERROR:
> Throwing
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.Threading.ThreadAbortException: Thread was being
> aborted.
> at System.Drawing.SafeNativeMethods.GdipDrawImageRectI(HandleRef
> graphics, HandleRef image, Int32 x, Int32 y, Int32 width, Int32 height)
> at System.Drawing.Graphics.DrawImage(Image image, Int32 x, Int32 y,
> Int32
> width, Int32 height)
> at System.Drawing.Bitmap..ctor(Image original, Int32 width, Int32
> height)
> at System.Drawing.Bitmap..ctor(Image original)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.Process32bppArgbImages(CanvasImage
> image, StringBuilder streamString, StringBuilder imageContentString,
> Int64&
> streamLength)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessImage(CanvasImage
> image, Double left, Double top, Double width, Double height, Boolean
> scaleImage)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawImage(OutlineObjects
> outlines, CanvasImage image, Double left, Double top, Double width, Double
> height)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.Chart.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ListContent.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.List.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
> theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
> Int32 endPage, Boolean render)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.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)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> -- End of inner exception stack trace --
> ReportingServicesService!runningjobs!f54!02/25/2005-20:37:22:: i INFO:
> CancelableJobExecution.Execute caught some other thread abort exception
> ReportingServicesService!library!f54!02/25/2005-20:37:22:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system
> properties.
> ReportingServicesService!emailextension!f54!02/25/2005-20:37:24:: Error
> sending email. System.Threading.ThreadAbortException: Thread was being
> aborted.
> 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!f54!02/25/2005-20:37:25:: Error
> thrown
> by delivery provider: System.Threading.ThreadAbortException: Thread was
> being
> aborted.
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
> notification)
> at
> Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem
> item)
> ReportingServicesService!notification!f54!02/25/2005-20:37:26:: e ERROR:
> Error occured processing notification. Thread was being aborted.
> ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27::
> NotificationPolling no longer processing item
> 36b6fea8-ebac-4de7-b5ef-74c792df8276, will be requeued
> ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27:: Queue worker
> thread caught unhandled exception: System.Threading.ThreadAbortException:
> Thread was being aborted.
> at
> Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem
> item)
> at
> Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem
> item)
> at
> Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object
> state)
>

PDF printing error

I have a problem on the printing PDF.
I use the printer is HP LeasrJet 5000N.
And I cannont print the report. The error is the following:
Error: limitcheck
Offending command: string
stack: 173155Hi,
I am having this problem with printing PDF.I use the web services to export
the PDF to the client sides. And then open / save the file to print out. This
report have bar-code and chinese fonts.
Case 1:
I try to use the Acrobat Reader 6.0 to print this report is property. But I
use the Acrobat Reader 5.1 to print the reports, then show the error message
as following:
ERROR: limitcheck
OFFENDING COMMAND: string
STACK:
173155
(
(
)
(
)
(
)
......
Case 2:
I also try to use the "HP LaserJet 5000 Series PCL" printer to print the
same report. It is work fine. But I use the "HP Laser Jet 5000 Series PS"
printer to print the report, then the error message is shown:
ERROR: limitcheck
OFFENDING COMMAND: string
STACK:
173155
(
(
)
(
)
(
)
......
*Remark: My company policy is not allow the user to change the basic PC
config.
Does anyone know how to solve this problem? Please help.
Thanks,
Dale Ho

PDF expport and printing problem

Hello -
I am trying to export a report to PDF format and receive this error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Index was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index
When I try to print my report this print error is displayed:
"An error occured during printing. (0x80004005)"
The report exports just fine to Excel and other reports export to PDF &
print just fine.
A previous post from Bruce Johnson referred to report language settings and
I am not sure which setting to verify.
I am running Reporting Services SP2.
Thanks,
PaulHello Paul -
Did you ever figure this error out? I am having the same issue. Thanks.
Mitch
mlake@.3plcorp.com
"Paul Ennamorato" wrote:
> Hello -
> I am trying to export a report to PDF format and receive this error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Index was out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index
> When I try to print my report this print error is displayed:
> "An error occured during printing. (0x80004005)"
> The report exports just fine to Excel and other reports export to PDF &
> print just fine.
> A previous post from Bruce Johnson referred to report language settings and
> I am not sure which setting to verify.
> I am running Reporting Services SP2.
> Thanks,
> Paul|||Mitch -
Thanks for your reply. We have not yet determined what causes this error
message.
Regards,
Paul
"Mitch Lake" wrote:
> Hello Paul -
> Did you ever figure this error out? I am having the same issue. Thanks.
> Mitch
> mlake@.3plcorp.com
> "Paul Ennamorato" wrote:
> > Hello -
> >
> > I am trying to export a report to PDF format and receive this error:
> >
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. (rrRenderingError) Get Online Help
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > Index was out of range. Must be non-negative and less than the size of the
> > collection. Parameter name: index
> >
> > When I try to print my report this print error is displayed:
> >
> > "An error occured during printing. (0x80004005)"
> >
> > The report exports just fine to Excel and other reports export to PDF &
> > print just fine.
> >
> > A previous post from Bruce Johnson referred to report language settings and
> > I am not sure which setting to verify.
> >
> > I am running Reporting Services SP2.
> >
> > Thanks,
> >
> > Paul|||Well, I never did figure out what was happening, but SP2 seems to have fixed
the problem. I was able to isolate it down to a particular group footer and
then got the "bright" idea to check for a service pack. Installed to
development and server and all is good again.
Mitch
"Paul Ennamorato" wrote:
> Mitch -
> Thanks for your reply. We have not yet determined what causes this error
> message.
> Regards,
> Paul
> "Mitch Lake" wrote:
> > Hello Paul -
> >
> > Did you ever figure this error out? I am having the same issue. Thanks.
> >
> > Mitch
> > mlake@.3plcorp.com
> >
> > "Paul Ennamorato" wrote:
> >
> > > Hello -
> > >
> > > I am trying to export a report to PDF format and receive this error:
> > >
> > > Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > > thrown. (rrRenderingError) Get Online Help
> > > Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > > thrown.
> > > Index was out of range. Must be non-negative and less than the size of the
> > > collection. Parameter name: index
> > >
> > > When I try to print my report this print error is displayed:
> > >
> > > "An error occured during printing. (0x80004005)"
> > >
> > > The report exports just fine to Excel and other reports export to PDF &
> > > print just fine.
> > >
> > > A previous post from Bruce Johnson referred to report language settings and
> > > I am not sure which setting to verify.
> > >
> > > I am running Reporting Services SP2.
> > >
> > > Thanks,
> > >
> > > Paul

Pdf Export using WebService- Error

Hi,
I am trying SRS2005 export into pdf using webservices,I got an error msg as below,any suggestions appreciated.

System.Web.Services.Protocols.SoapException: The permissions granted to user 'PPCCWDDC450P81\IUSR_PPCCWDDC450P81' are insufficient for performing this operation. > Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The permissions granted to user 'PPCCWDDC450P81\IUSR_PPCCWDDC450P81' are insufficient for performing this operation. > Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'PPCCWDDC450P81\IUSR_PPCCWDDC450P81' are insufficient for performing this operation.
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& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, 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)
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, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.WebServer.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, Byte[]& Result, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, Byte[]& Result, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds)

Thanks,
Prabu

That means that you are trying to authenticate to reportserver with the user 'PPCCWDDC450P81\IUSR_PPCCWDDC450P81, this is an anonymous user that ASPNET uses for executing applications, you only have to add this user to the reportfolder or report item and give permissions of browser.sql

PDF export problem

Hi,
When I try to export my report to PDF it throws me this error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError)
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Index and length must refer to a location within the string. Parameter name:
length
I'm using Reporting Services with SP1.
Thanks in AdvancePlease verify how you have the report Language property set.
If you do not have Language property set to a language-country pair (i.e.
en-us) you will get this error when exporting to PDF.
If you select Czech in Report Designer it will get serialized as "cs". To
workaround this issue you will need to select Czech (Czech Republic)
in Report Designer. This choice gets serialized as "cs-CZ".
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"VK" <kafkav@.cgcc.cz> wrote in message
news:OQO0WvQsEHA.2688@.TK2MSFTNGP14.phx.gbl...
> Hi,
> When I try to export my report to PDF it throws me this error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError)
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Index and length must refer to a location within the string. Parameter
> name: length
>
> I'm using Reporting Services with SP1.
> Thanks in Advance
>sql

PDF Export Failing after SP1

Am also having a problem exporting to PDF since installing SP1. Error is
"Cannot download format=PDF from <server>"
"Internet Explorer was not able to open this Internet Site. The requested
site is either unavailable or cannot be found. Please try again later".
Micktry to export same report to PDF in visual studio designer
you will recive different error
this error is explained in two of todays posts
HTH,
Kamil
U¿ytkownik "Mick Horne" <mick.horne@.conchango.com> napisa³ w wiadomo¶ci
news:%23bePBQeXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Am also having a problem exporting to PDF since installing SP1. Error is
> "Cannot download format=PDF from <server>"
> "Internet Explorer was not able to open this Internet Site. The requested
> site is either unavailable or cannot be found. Please try again later".
> Mick
>
>|||> try to export same report to PDF in visual studio designer
> you will recive different error
> this error is explained in two of todays posts
As posted before I've got the same problem. And yes, you are right, in the
designer I receive a different error. Unfortunately I can not find the posts
where a solution for this is stated. Can you please explain to me how to fix
it?
Thanks.
Christian|||Workaround solution with following post:
"SP1 - Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown" by Rahul
U¿ytkownik "Christian Anders" <anders.christian@.firemail.de> napisa³ w
wiadomo¶ci news:ewNfcgeXEHA.2388@.TK2MSFTNGP11.phx.gbl...
> > try to export same report to PDF in visual studio designer
> > you will recive different error
> > this error is explained in two of todays posts
> As posted before I've got the same problem. And yes, you are right, in the
> designer I receive a different error. Unfortunately I can not find the
posts
> where a solution for this is stated. Can you please explain to me how to
fix
> it?
> Thanks.
> Christian
>sql

PDF Export error in reporting services 2000

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

amit_800 wrote:

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

|||

I have seen this only once before and reinstalling the Arial font fixed this issue. The error message you see comes from the Windows GDI library. To reinstall Arial, do the following. Note that these instructions are for Windows XP or Windows Server 2003 only.

1. In Windows Explorer, navigate to C:\Windows\Fonts

2. Right-click the Arial (TrueType) font and select delete

3. Reboot

4. Expand Arial.tt_ from the i386 or AMD64 directory on your Windows CD to a directory on your hard drive. To expand, you can use the expand.exe file in the i386/amd64 directory or an application like 7-Zip.

5. In Windows Explorer, navigate to C:\Windows\Fonts

6. From the File menu, choose Install New Font and then select the Arial.TTF file you expanded.

7. Reboot

Thanks.

PDF Export error in reporting services 2000

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

amit_800 wrote:

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

|||

I have seen this only once before and reinstalling the Arial font fixed this issue. The error message you see comes from the Windows GDI library. To reinstall Arial, do the following. Note that these instructions are for Windows XP or Windows Server 2003 only.

1. In Windows Explorer, navigate to C:\Windows\Fonts

2. Right-click the Arial (TrueType) font and select delete

3. Reboot

4. Expand Arial.tt_ from the i386 or AMD64 directory on your Windows CD to a directory on your hard drive. To expand, you can use the expand.exe file in the i386/amd64 directory or an application like 7-Zip.

5. In Windows Explorer, navigate to C:\Windows\Fonts

6. From the File menu, choose Install New Font and then select the Arial.TTF file you expanded.

7. Reboot

Thanks.

PDF export error

I've created a report and it works fine in html,
but when I export to PDF, I receive next error:
Reporting Services Error
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError)
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown
Index and length must refer to a location within the string.
Parameter name: length
Any suggestions please?
Regards,
Miguel.Check what the report language property is set to. If it's not a
language-country pair, you might run into this error. For instance, if you
choose "English", this error might occur. Change it to a language-country
pair (for example en-US).
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Miguel Esteban" <mestebanpt@.yahoo.es> wrote in message
news:eUEQ258cEHA.3420@.TK2MSFTNGP12.phx.gbl...
> I've created a report and it works fine in html,
> but when I export to PDF, I receive next error:
> Reporting Services Error
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError)
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown
> Index and length must refer to a location within the string.
> Parameter name: length
>
> Any suggestions please?
> Regards,
> Miguel.
>

PDF export error

When I try to export a 2400 pages report to pdf get the reporting services
error:
exception of type Microsoft.Reporting.Services.ReportRenderingException was
thrown. index was out of range. Must be non-negative and less than the size
of the collection. Parameter name: index.
The report ran before SP2 fine and after SP2 fine too.
Any help will be greatly appreciated.These are the error I get when debug.
A first chance exception of type 'System.ArgumentOutOfRangeException'
occurred in mscorlib.dll
Additional information: Index was out of range. Must be non-negative and
less than the size of the collection.
--
A first chance exception of type
'Microsoft.ReportingServices.ReportRendering.ReportRenderingException'
occurred in microsoft.reportingservices.imagerendering.dll
--
A first chance exception of type
'Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException' occurred in microsoft.reportingservices.processing.dll
Additional information: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
--
A first chance exception of type
'Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException' occurred in microsoft.reportingservices.processing.dll
Additional information: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
"Ehsan Khan" wrote:
> When I try to export a 2400 pages report to pdf get the reporting services
> error:
> exception of type Microsoft.Reporting.Services.ReportRenderingException was
> thrown. index was out of range. Must be non-negative and less than the size
> of the collection. Parameter name: index.
> The report ran before SP2 fine and after SP2 fine too.
> Any help will be greatly appreciated.

PDF Error: Urgent

When I try to export it to PDF; I get an error "There was an error opening
this document.This file cannot be found."
The same report was working fine last month.
Export To Excel Works FineClear Temporary Internet Folder
"Sudha" wrote:
> When I try to export it to PDF; I get an error "There was an error opening
> this document.This file cannot be found."
> The same report was working fine last month.
> Export To Excel Works Fine
>

PDF error after applying SP1

After applying SP1 i got following error during export to PDF
Export Error:
"Index and lenght must refer to a location within a string.
Parameter name: lenght"Workaround solution with following post:
"SP1 - Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown" by Rahul
U¿ytkownik "kamel" <ddd@.ddd.com> napisa³ w wiadomo¶ci
news:e9gFBIQXEHA.3016@.tk2msftngp13.phx.gbl...
> After applying SP1 i got following error during export to PDF
> Export Error:
> "Index and lenght must refer to a location within a string.
> Parameter name: lenght"
>|||I have a straight forward workaround: Always use a Lang-Country code pair.
For example, in report designer, the language options for Norwegian are
Name Lang-County Code
* Norwegian no
* Norwegian (Bokmal) nb-NO
* Norwegian (Nynorsk) nn-NO
To avoid the error when exporting to PDF always use nb-NO or nn-NO.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"kamel" <ddd@.ddd.com> wrote in message
news:e1TnW%23cXEHA.2364@.TK2MSFTNGP12.phx.gbl...
> Workaround solution with following post:
> "SP1 - Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown" by Rahul
> U¿ytkownik "kamel" <ddd@.ddd.com> napisa³ w wiadomo¶ci
> news:e9gFBIQXEHA.3016@.tk2msftngp13.phx.gbl...
> > After applying SP1 i got following error during export to PDF
> >
> > Export Error:
> > "Index and lenght must refer to a location within a string.
> > Parameter name: lenght"
> >
> >
>

pdf error

When I try to export it to PDF; I get an error "There was an error opening
this document.This file cannot be found."
This happens with Acrobat reader 5.0, 6.0 when the reports are pulled on
the user's machines from the production server. Am I missing something.
The export works well on the staging server.
any help is appreciated.
GaryI have heard of this on other machines. It seems to have something to do
with the browser config / temporary internet files. The file is usually gone
before Acrobat can open it.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gary" <gary@.msn.com> wrote in message
news:eaxxMHMnEHA.2612@.TK2MSFTNGP15.phx.gbl...
> When I try to export it to PDF; I get an error "There was an error opening
> this document.This file cannot be found."
> This happens with Acrobat reader 5.0, 6.0 when the reports are pulled on
> the user's machines from the production server. Am I missing something.
> The export works well on the staging server.
> any help is appreciated.
> Gary
>|||Try After Clearing Temporary Internet Folder
"Gary" wrote:
> When I try to export it to PDF; I get an error "There was an error opening
> this document.This file cannot be found."
> This happens with Acrobat reader 5.0, 6.0 when the reports are pulled on
> the user's machines from the production server. Am I missing something.
> The export works well on the staging server.
> any help is appreciated.
> Gary
>
>sql

PDF Byte Error?

I've been reading through the group and seems like a lot of people
have been trying to display the report as a PDF in IE. However, the
byte stream is wrong so it won't allow it.
Does this happen in both methods that generate the output: the SOAP
Render method, and the URL Access (Format='PDF')?
Also, can someone tell me what the correct btye order/size needs to
be. We will use the render method, and then try to correct it by
writing a program. We'll then use the 'corrected' file and display in
a web browser.
Thanks,
rwiethornActually, it displays correctly in IE (which just launches Acrobat to
display the file).
The problem is that third-party tools for post-processing PDF aren't as
forgiving as Acrobat and might have trouble with our noncompliant format.
(We are, however, aware of the bug and have it in the queue to get fixed...
No estimate on when)
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"rwiethorn" <rwiethorn2002@.yahoo.com> wrote in message
news:553a0349.0408061300.54ad3e7d@.posting.google.com...
> I've been reading through the group and seems like a lot of people
> have been trying to display the report as a PDF in IE. However, the
> byte stream is wrong so it won't allow it.
> Does this happen in both methods that generate the output: the SOAP
> Render method, and the URL Access (Format='PDF')?
> Also, can someone tell me what the correct btye order/size needs to
> be. We will use the render method, and then try to correct it by
> writing a program. We'll then use the 'corrected' file and display in
> a web browser.
> Thanks,
> rwiethorn|||Hello,
I've found in this group that you have to set Language property of your
report to an expression which contains a '-'.
Fr is not supported but Fr-fr is Ok.
This problem occurs only when you want to generate PDF format.
Jerome Berthaud (MCSD)
http://www.winsight.fr
"rwiethorn" <rwiethorn2002@.yahoo.com> wrote in message
news:553a0349.0408061300.54ad3e7d@.posting.google.com...
> I've been reading through the group and seems like a lot of people
> have been trying to display the report as a PDF in IE. However, the
> byte stream is wrong so it won't allow it.
> Does this happen in both methods that generate the output: the SOAP
> Render method, and the URL Access (Format='PDF')?
> Also, can someone tell me what the correct btye order/size needs to
> be. We will use the render method, and then try to correct it by
> writing a program. We'll then use the 'corrected' file and display in
> a web browser.
> Thanks,
> rwiethorn

pb with a trigger

hello,
I've a problem with a trigger :
this trigger update a file with an index field but it's return an error
: UPDATE stop because the Set option : "QUOTED_IDENTIFIER" return bad
parameters
for information, this is my trigger :
CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS
SET NOCOUNT ON
set arithabort on
set concat_null_yields_null on
set quoted_identifier on
set ansi_nulls on
set ansi_padding on
set ansi_warnings on
set numeric_roundabort off
declare @.code varchar(17)
select @.code=ar_ref from inserted
begin
*/ replace if reference = 0 */
if @.code='0'
begin
update f_article set ar_ref='test' from f_article join
inserted on f_article.cbmarq=inserted.cbmarq
end
end
if you ave an idea...
thanks
philnedPerhaps the trigger was created with SET QUOTED_IDENTIFIER OFF. This
setting is remembered for subsequent trigger executions. Try:
SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
GO
CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS
SET NOCOUNT ON
set arithabort on
set concat_null_yields_null on
set quoted_identifier on
set ansi_nulls on
set ansi_padding on
set ansi_warnings on
set numeric_roundabort off
declare @.code varchar(17)
select @.code=ar_ref from inserted
begin
*/ replace if reference = 0 */
if @.code='0'
begin
update f_article set ar_ref='test' from f_article join
inserted on f_article.cbmarq=inserted.cbmarq
end
end
GO
Hope this helps.
Dan Guzman
SQL Server MVP
"philned" <philned@.wanadoo.fr> wrote in message
news:418783e6$0$9305$636a15ce@.news.free.fr...
> hello,
> I've a problem with a trigger :
> this trigger update a file with an index field but it's return an error :
> UPDATE stop because the Set option : "QUOTED_IDENTIFIER" return bad
> parameters
> for information, this is my trigger :
> CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS
> SET NOCOUNT ON
> set arithabort on
> set concat_null_yields_null on
> set quoted_identifier on
> set ansi_nulls on
> set ansi_padding on
> set ansi_warnings on
> set numeric_roundabort off
> declare @.code varchar(17)
> select @.code=ar_ref from inserted
> begin
> */ replace if reference = 0 */
> if @.code='0'
> begin
> update f_article set ar_ref='test' from f_article join
> inserted on f_article.cbmarq=inserted.cbmarq
> end
> end
>
> if you ave an idea...
> thanks
> philnedsql

pb with a trigger

hello,
I've a problem with a trigger :
this trigger update a file with an index field but it's return an error
: UPDATE stop because the Set option : "QUOTED_IDENTIFIER" return bad
parameters
for information, this is my trigger :
CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS
SET NOCOUNT ON
set arithabort on
set concat_null_yields_null on
set quoted_identifier on
set ansi_nulls on
set ansi_padding on
set ansi_warnings on
set numeric_roundabort off
declare @.code varchar(17)
select @.code=ar_ref from inserted
begin
*/ replace if reference = 0 */
if @.code='0'
begin
update f_article set ar_ref='test' from f_article join
inserted on f_article.cbmarq=inserted.cbmarq
end
end
if you ave an idea...
thanks
philnedPerhaps the trigger was created with SET QUOTED_IDENTIFIER OFF. This
setting is remembered for subsequent trigger executions. Try:
SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
GO
CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS
SET NOCOUNT ON
set arithabort on
set concat_null_yields_null on
set quoted_identifier on
set ansi_nulls on
set ansi_padding on
set ansi_warnings on
set numeric_roundabort off
declare @.code varchar(17)
select @.code=ar_ref from inserted
begin
*/ replace if reference = 0 */
if @.code='0'
begin
update f_article set ar_ref='test' from f_article join
inserted on f_article.cbmarq=inserted.cbmarq
end
end
GO
Hope this helps.
Dan Guzman
SQL Server MVP
"philned" <philned@.wanadoo.fr> wrote in message
news:418783e6$0$9305$636a15ce@.news.free.fr...
> hello,
> I've a problem with a trigger :
> this trigger update a file with an index field but it's return an error :
> UPDATE stop because the Set option : "QUOTED_IDENTIFIER" return bad
> parameters
> for information, this is my trigger :
> CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS
> SET NOCOUNT ON
> set arithabort on
> set concat_null_yields_null on
> set quoted_identifier on
> set ansi_nulls on
> set ansi_padding on
> set ansi_warnings on
> set numeric_roundabort off
> declare @.code varchar(17)
> select @.code=ar_ref from inserted
> begin
> */ replace if reference = 0 */
> if @.code='0'
> begin
> update f_article set ar_ref='test' from f_article join
> inserted on f_article.cbmarq=inserted.cbmarq
> end
> end
>
> if you ave an idea...
> thanks
> philned

pb with a trigger

hello,
I've a problem with a trigger :
this trigger update a file with an index field but it's return an error
: UPDATE stop because the Set option : "QUOTED_IDENTIFIER" return bad
parameters
for information, this is my trigger :
CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS
SET NOCOUNT ON
set arithabort on
set concat_null_yields_null on
set quoted_identifier on
set ansi_nulls on
set ansi_padding on
set ansi_warnings on
set numeric_roundabort off
declare @.code varchar(17)
select @.code=ar_ref from inserted
begin
*/ replace if reference = 0 */
if @.code='0'
begin
update f_article set ar_ref='test' from f_article join
inserted on f_article.cbmarq=inserted.cbmarq
end
end
if you ave an idea...
thanks
philned
Perhaps the trigger was created with SET QUOTED_IDENTIFIER OFF. This
setting is remembered for subsequent trigger executions. Try:
SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
GO
CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS
SET NOCOUNT ON
set arithabort on
set concat_null_yields_null on
set quoted_identifier on
set ansi_nulls on
set ansi_padding on
set ansi_warnings on
set numeric_roundabort off
declare @.code varchar(17)
select @.code=ar_ref from inserted
begin
*/ replace if reference = 0 */
if @.code='0'
begin
update f_article set ar_ref='test' from f_article join
inserted on f_article.cbmarq=inserted.cbmarq
end
end
GO
Hope this helps.
Dan Guzman
SQL Server MVP
"philned" <philned@.wanadoo.fr> wrote in message
news:418783e6$0$9305$636a15ce@.news.free.fr...
> hello,
> I've a problem with a trigger :
> this trigger update a file with an index field but it's return an error :
> UPDATE stop because the Set option : "QUOTED_IDENTIFIER" return bad
> parameters
> for information, this is my trigger :
> CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS
> SET NOCOUNT ON
> set arithabort on
> set concat_null_yields_null on
> set quoted_identifier on
> set ansi_nulls on
> set ansi_padding on
> set ansi_warnings on
> set numeric_roundabort off
> declare @.code varchar(17)
> select @.code=ar_ref from inserted
> begin
> */ replace if reference = 0 */
> if @.code='0'
> begin
> update f_article set ar_ref='test' from f_article join
> inserted on f_article.cbmarq=inserted.cbmarq
> end
> end
>
> if you ave an idea...
> thanks
> philned