Peculiar Replication (Could be OT)

We have 2 types of Production Database. One is an OLTP database another contains all the Master Tables. We also have 2 copies of each and this repeats itself for each country where the plant is located. Is there someone who can explain to me how we might
setup this Replication so that the Master tables which are maintained in one location gets replicated over to the other places and also the updated from those locations are also propogated to all locations. We had MS come into the picture and they have cr
eated triggers such that the data is copied over but they seem to delete the record and insert it back again for an Update and sometimes inbetween the delete and insert the leased line goes down and the result is a total failure.
Regards,
Trevor Benedict R
Trevor,
this is typically implemented using merge replication. You'll need to consider partitioning of data for each subscriber, or the posibility of conflicts and how they should be resolved. There's a good set of explanations of general concepts in BOL.
The network failures you experience are usually solved in merge by simply restarting the merge agent.
HTH,
Paul Ibison

PDF Export Prompts for Authentication

I am having a weird problem with just one report in production. When
exporting to PDF format only, the browser prompts for user authentication.
No matter what you type in the window (even admin for server) it just keeps
popping up. When you click cancel you see the following error.
HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)
The log file shows the following
w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: 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.StackOverflowException: Exception of type
System.StackOverflowException was thrown.
-- 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.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services error
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.StackOverflowException: Exception of type
System.StackOverflowException was thrown.
w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query
execution failed for data set 'dsChangesInLargeLoss'. -->
System.Data.SqlClient.SqlException: The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value.
w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
System.StackOverflowException exception:
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.StackOverflowException: Exception of type
System.StackOverflowException was thrown.
w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker process
Other reports in production export to PDF without a problem, just this one
report is causing issues.
Any idea what might be causing this issue? The report exports to PDF fine
in development for this report. Has anyone else seen this issue before?Does this report render correctly in other formats like HTML? Can you help
me understand this error:
Query execution failed for data set 'dsChangesInLargeLoss'. -->
System.Data.SqlClient.SqlException: The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value.
If it isn't an obvious place in your report that's doing this and leading to
us blowing up, can you email me a copy of your .rdl and .rdl.data file so I
can investigate?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"spindlej" <spindlej@.discussions.microsoft.com> wrote in message
news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
>I am having a weird problem with just one report in production. When
> exporting to PDF format only, the browser prompts for user authentication.
> No matter what you type in the window (even admin for server) it just
> keeps
> popping up. When you click cancel you see the following error.
> HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
> credentials.
> Internet Information Services (IIS)
> The log file shows the following
>
> w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
> GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
> this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
> w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: 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.StackOverflowException: Exception of type
> System.StackOverflowException was thrown.
> -- 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.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> -- End of inner exception stack trace --
> w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services
> error
> 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.StackOverflowException: Exception of type
> System.StackOverflowException was thrown.
> w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
> error
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
> has
> occurred during report processing. -->
> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
> An
> error has occurred during report processing. -->
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> Query
> execution failed for data set 'dsChangesInLargeLoss'. -->
> System.Data.SqlClient.SqlException: The conversion of a char data type to
> a
> datetime data type resulted in an out-of-range datetime value.
> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
> System.StackOverflowException exception:
> 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.StackOverflowException: Exception of type
> System.StackOverflowException was thrown.
> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
> process
> Other reports in production export to PDF without a problem, just this one
> report is causing issues.
> Any idea what might be causing this issue? The report exports to PDF fine
> in development for this report. Has anyone else seen this issue before?
>|||It would be really creepy if this renders in HTML but not in PDF (makes no
sense)
I am looking forward getting the rdl ;-)
Jens Süßmeyer.
"Donovan Smith [MSFT]" <donovans@.online.microsoft.com> schrieb im
Newsbeitrag news:emN7AkRQFHA.3140@.tk2msftngp13.phx.gbl...
> Does this report render correctly in other formats like HTML? Can you
> help me understand this error:
> Query execution failed for data set 'dsChangesInLargeLoss'. -->
> System.Data.SqlClient.SqlException: The conversion of a char data type to
> a
> datetime data type resulted in an out-of-range datetime value.
> If it isn't an obvious place in your report that's doing this and leading
> to us blowing up, can you email me a copy of your .rdl and .rdl.data file
> so I can investigate?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "spindlej" <spindlej@.discussions.microsoft.com> wrote in message
> news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
>>I am having a weird problem with just one report in production. When
>> exporting to PDF format only, the browser prompts for user
>> authentication.
>> No matter what you type in the window (even admin for server) it just
>> keeps
>> popping up. When you click cancel you see the following error.
>> HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
>> credentials.
>> Internet Information Services (IIS)
>> The log file shows the following
>>
>> w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
>> GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
>> this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
>> w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: 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.StackOverflowException: Exception of type
>> System.StackOverflowException was thrown.
>> -- 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.RenderSnapshot(CreateReportChunk
>> createChunkCallback, RenderingContext rc, GetResource
>> getResourceCallback)
>> -- End of inner exception stack trace --
>> w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> error
>> 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.StackOverflowException: Exception of type
>> System.StackOverflowException was thrown.
>> w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> error
>> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
>> has
>> occurred during report processing. -->
>> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
>> An
>> error has occurred during report processing. -->
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> Query
>> execution failed for data set 'dsChangesInLargeLoss'. -->
>> System.Data.SqlClient.SqlException: The conversion of a char data type to
>> a
>> datetime data type resulted in an out-of-range datetime value.
>> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
>> System.StackOverflowException exception:
>> 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.StackOverflowException: Exception of type
>> System.StackOverflowException was thrown.
>> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
>> process
>> Other reports in production export to PDF without a problem, just this
>> one
>> report is causing issues.
>> Any idea what might be causing this issue? The report exports to PDF
>> fine
>> in development for this report. Has anyone else seen this issue before?
>|||We tested the report on another server and duplicated the problem. Once we
upgraded to SP1, the problem went away.
"Donovan Smith [MSFT]" wrote:
> Does this report render correctly in other formats like HTML? Can you help
> me understand this error:
> Query execution failed for data set 'dsChangesInLargeLoss'. -->
> System.Data.SqlClient.SqlException: The conversion of a char data type to a
> datetime data type resulted in an out-of-range datetime value.
> If it isn't an obvious place in your report that's doing this and leading to
> us blowing up, can you email me a copy of your .rdl and .rdl.data file so I
> can investigate?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "spindlej" <spindlej@.discussions.microsoft.com> wrote in message
> news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
> >I am having a weird problem with just one report in production. When
> > exporting to PDF format only, the browser prompts for user authentication.
> > No matter what you type in the window (even admin for server) it just
> > keeps
> > popping up. When you click cancel you see the following error.
> >
> > HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
> > credentials.
> > Internet Information Services (IIS)
> >
> > The log file shows the following
> >
> >
> > w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
> > GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
> > this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
> > w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: 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.StackOverflowException: Exception of type
> > System.StackOverflowException was thrown.
> > -- 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.RenderSnapshot(CreateReportChunk
> > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> > -- End of inner exception stack trace --
> > w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services
> > error
> > 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.StackOverflowException: Exception of type
> > System.StackOverflowException was thrown.
> > w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
> > error
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
> > has
> > occurred during report processing. -->
> > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
> > An
> > error has occurred during report processing. -->
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> > Query
> > execution failed for data set 'dsChangesInLargeLoss'. -->
> > System.Data.SqlClient.SqlException: The conversion of a char data type to
> > a
> > datetime data type resulted in an out-of-range datetime value.
> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
> > System.StackOverflowException exception:
> > 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.StackOverflowException: Exception of type
> > System.StackOverflowException was thrown.
> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
> > process
> >
> > Other reports in production export to PDF without a problem, just this one
> > report is causing issues.
> >
> > Any idea what might be causing this issue? The report exports to PDF fine
> > in development for this report. Has anyone else seen this issue before?
> >
>
>|||Well, that was an easier answer than I expected. Good to know it's working.
:)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"spindlej" <spindlej@.discussions.microsoft.com> wrote in message
news:6FFDE7FB-5525-469A-AEC4-4189555A94E8@.microsoft.com...
> We tested the report on another server and duplicated the problem. Once
> we
> upgraded to SP1, the problem went away.
> "Donovan Smith [MSFT]" wrote:
>> Does this report render correctly in other formats like HTML? Can you
>> help
>> me understand this error:
>> Query execution failed for data set 'dsChangesInLargeLoss'. -->
>> System.Data.SqlClient.SqlException: The conversion of a char data type to
>> a
>> datetime data type resulted in an out-of-range datetime value.
>> If it isn't an obvious place in your report that's doing this and leading
>> to
>> us blowing up, can you email me a copy of your .rdl and .rdl.data file so
>> I
>> can investigate?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "spindlej" <spindlej@.discussions.microsoft.com> wrote in message
>> news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
>> >I am having a weird problem with just one report in production. When
>> > exporting to PDF format only, the browser prompts for user
>> > authentication.
>> > No matter what you type in the window (even admin for server) it just
>> > keeps
>> > popping up. When you click cancel you see the following error.
>> >
>> > HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
>> > credentials.
>> > Internet Information Services (IIS)
>> >
>> > The log file shows the following
>> >
>> >
>> > w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
>> > GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
>> > this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
>> > w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: 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.StackOverflowException: Exception of type
>> > System.StackOverflowException was thrown.
>> > -- 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.RenderSnapshot(CreateReportChunk
>> > createChunkCallback, RenderingContext rc, GetResource
>> > getResourceCallback)
>> > -- End of inner exception stack trace --
>> > w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> > error
>> > 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.StackOverflowException: Exception of type
>> > System.StackOverflowException was thrown.
>> > w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> > error
>> > Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
>> > has
>> > occurred during report processing. -->
>> > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
>> > An
>> > error has occurred during report processing. -->
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> > Query
>> > execution failed for data set 'dsChangesInLargeLoss'. -->
>> > System.Data.SqlClient.SqlException: The conversion of a char data type
>> > to
>> > a
>> > datetime data type resulted in an out-of-range datetime value.
>> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
>> > System.StackOverflowException exception:
>> > 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.StackOverflowException: Exception of type
>> > System.StackOverflowException was thrown.
>> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
>> > process
>> >
>> > Other reports in production export to PDF without a problem, just this
>> > one
>> > report is causing issues.
>> >
>> > Any idea what might be causing this issue? The report exports to PDF
>> > fine
>> > in development for this report. Has anyone else seen this issue
>> > before?
>> >
>>

Pathing Error: Subreport(s) could not be shown

Hi Folks
I have a working report with 5 additional subreports on my PC. Also, works
fine on the development server.
The issue is with PRODUCTION.
Our networking folks are disabling 127.0.0.1 and localhost in PRODUCTION.
Can anyone tell me if suppling the 'path' in the main report .rdl for all of
the subreports will fix the issue. Tried several permuations and have not
been able to have a subreport shown.
robjust doublechecked:
1. CAN deploy from VB.NET into the 'Home' directory in PRODUCTION and the
report/subreports work just fine :)
2. However, our 'normal' mode of operations is to copy the .RDLs from
DEVELOPMENT and upload them.
3. Attempting to deploy to any of the subdirectories/folders throws up an
authentication dialog.
4. My TargetServerURL: http://myproductionserver.here.mycompany.com/Reports
This needs to be something like:
http://myproductionserver.here.mycompany.com/Reports/thisapplicationreportsdir/reportnumber123
thanks
rob
"RobKaratzas" wrote:
> Hi Folks
> I have a working report with 5 additional subreports on my PC. Also, works
> fine on the development server.
> The issue is with PRODUCTION.
> Our networking folks are disabling 127.0.0.1 and localhost in PRODUCTION.
> Can anyone tell me if suppling the 'path' in the main report .rdl for all of
> the subreports will fix the issue. Tried several permuations and have not
> been able to have a subreport shown.
> rob|||sorry...
Finally, when deployed by hand (uploaded from .RDLs into where the reports
need to be) the subreports INDIVIDUALLY work just fine (so I'm pretty sure
it's a simply pathing related issue in the MAIN report).
Now, just how to modify the main report with the specific paths needed for
each subreport.
rob
"RobKaratzas" wrote:
> just doublechecked:
> 1. CAN deploy from VB.NET into the 'Home' directory in PRODUCTION and the
> report/subreports work just fine :)
> 2. However, our 'normal' mode of operations is to copy the .RDLs from
> DEVELOPMENT and upload them.
> 3. Attempting to deploy to any of the subdirectories/folders throws up an
> authentication dialog.
> 4. My TargetServerURL: http://myproductionserver.here.mycompany.com/Reports
> This needs to be something like:
> http://myproductionserver.here.mycompany.com/Reports/thisapplicationreportsdir/reportnumber123
> thanks
> rob
> "RobKaratzas" wrote:
> > Hi Folks
> >
> > I have a working report with 5 additional subreports on my PC. Also, works
> > fine on the development server.
> >
> > The issue is with PRODUCTION.
> >
> > Our networking folks are disabling 127.0.0.1 and localhost in PRODUCTION.
> >
> > Can anyone tell me if suppling the 'path' in the main report .rdl for all of
> > the subreports will fix the issue. Tried several permuations and have not
> > been able to have a subreport shown.
> >
> > rob|||Used the 'move' option to move all the reports to the proper location in the
SSRS tree.
The reports run just fine, however, this isn't the optimal way we want to
have to deploy our reports (preference is to upload the .rdls by hand).
rob
"RobKaratzas" wrote:
> sorry...
> Finally, when deployed by hand (uploaded from .RDLs into where the reports
> need to be) the subreports INDIVIDUALLY work just fine (so I'm pretty sure
> it's a simply pathing related issue in the MAIN report).
> Now, just how to modify the main report with the specific paths needed for
> each subreport.
> rob
> "RobKaratzas" wrote:
> > just doublechecked:
> >
> > 1. CAN deploy from VB.NET into the 'Home' directory in PRODUCTION and the
> > report/subreports work just fine :)
> >
> > 2. However, our 'normal' mode of operations is to copy the .RDLs from
> > DEVELOPMENT and upload them.
> >
> > 3. Attempting to deploy to any of the subdirectories/folders throws up an
> > authentication dialog.
> >
> > 4. My TargetServerURL: http://myproductionserver.here.mycompany.com/Reports
> > This needs to be something like:
> > http://myproductionserver.here.mycompany.com/Reports/thisapplicationreportsdir/reportnumber123
> >
> > thanks
> > rob
> >
> > "RobKaratzas" wrote:
> >
> > > Hi Folks
> > >
> > > I have a working report with 5 additional subreports on my PC. Also, works
> > > fine on the development server.
> > >
> > > The issue is with PRODUCTION.
> > >
> > > Our networking folks are disabling 127.0.0.1 and localhost in PRODUCTION.
> > >
> > > Can anyone tell me if suppling the 'path' in the main report .rdl for all of
> > > the subreports will fix the issue. Tried several permuations and have not
> > > been able to have a subreport shown.
> > >
> > > rob|||Rob,
Can I ask why you're not developing and deploying all your rdl's at
once, inside a single report project? It seems logical to keep
associated reports in the same "container", especially when you have 6
reports to keep track of.|||hi toolman
this is just how this company operates...
operations folks don't have access to/use any IDEs to deploy
in this case, I ended deploying this for them into production (Home
directory) and then had to use the 'MOVE' to move all reports.
not an ideal situation, but since I was the person who initially setup the
system(s), I still have access to them still. but typically, this would have
caused issues in this environment.
thanks rob
"toolman" wrote:
> Rob,
> Can I ask why you're not developing and deploying all your rdl's at
> once, inside a single report project? It seems logical to keep
> associated reports in the same "container", especially when you have 6
> reports to keep track of.
>