Showing posts with label settings. Show all posts
Showing posts with label settings. Show all posts

Thursday, March 8, 2012

Cache-ing problem

I have a report that renders ok.
When I chenge the executuion settings to "Cache a temporary copy of the
report. Expire copy of report on the following schedule:"
I can render the report once, when I than ask for the report (and should get
the cached verision) I get an error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Index was outside the bounds of the array.
Any suggestions?Apparently, this has somthing to do with the fact that I used the global
parameter UserID.
Once I left that out of the report it works fine.
Why? Beats me.
I even have other reports that chache fine with the UserID-parameter...
Can you immagine how long it took me to find that
"Antoon" wrote:
> I have a report that renders ok.
> When I chenge the executuion settings to "Cache a temporary copy of the
> report. Expire copy of report on the following schedule:"
> I can render the report once, when I than ask for the report (and should get
> the cached verision) I get an error:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Index was outside the bounds of the array.
> Any suggestions?

Friday, February 10, 2012

BulkCopy failes for Dist Agent

Hello,
I'm getting an error message when running Dist
agen "Cannot bulkcopy into Customer". I have checked the
database settings on both Publisher and Subsrciber for
selectInto/BulkCopy option. Cannot seem to find the
problem. Any help would be appreciated.
-R
Rogers,
in current activity, please can you check to see if the subscriber table is locked.
Regards,
Paul Ibison
|||Paul,
Thanks for your reply. I checked the locks and it doesn't
appear that the table is locked. I looked on both
publisher and subscriber. If you think of anything else,
let me know.
Thanks!

>--Original Message--
>Rogers,
>in current activity, please can you check to see if the
subscriber table is locked.
>Regards,
>Paul Ibison
>.
>
|||You could enable logging to try to get some more info
(http://support.microsoft.com/?id=312292).
Also, you might try doing a bulk insert manually from QA on the subscriber,
just to see if the (same?) error message is reproduced there.
Regards,
Paul Ibison