Showing posts with label second. Show all posts
Showing posts with label second. Show all posts

Friday, February 24, 2012

For Loop container - out of memory condition

Just upgraded to the June CTP and having problems executing packages that loop using a For Loop. The first pass is fine but when trying the second we get:

Error: 0xC0208296 at LeaseFact Update, Sort 2 [5197]: The input buffer could not be cloned. An out-of-memory condition occurred or there was an internal error.

Error: 0xC0047022 at (name of data flow), DTS.Pipeline: The ProcessInput method on component "Sort 2" (5197) failed with error code 0x80004005. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.

Anyone seen this kind of problem ?

Thanks

Known issue, see other post I did WRT this issue please.

Sunday, February 19, 2012

for dgk and anyone else who knows

Thanks a lot dgk. You covered both cases and the second was the case
needed. Although an other problem arised. I got this error message :
"The source of the report definition has not been specified"
I thought that when you set the report in the report viewer control
the work is done but unfortunately this is not the case.
Even more, I don't have a clue of what I am supposed to do.
(I know I have to set the reportviewer to load the report but
I do not know how to do that)
Rookie in RS I suppose...
>
> If you're using a reportviewer control, parameters are done like this:
>
> Dim RptParm As New
> Microsoft.Reporting.WebForms.ReportParameter("FileNumParam",
> lblFileNum.Text) ' name/value pair for a parameter
>
> Dim RptParms As New Generic.List(Of
> Microsoft.Reporting.WebForms.ReportParameter)
>
> RptParms.Add(RptParm)
> ' add more parameters as necessary to RptParams
>
> Reportviewer1.ServerReport.SetParameters(RptParms)On Thu, 12 Oct 2006 11:18:18 +0300, "Nick Hatzis"
<boghatzisn@.panafonet.gr> wrote:
>Thanks a lot dgk. You covered both cases and the second was the case
>needed. Although an other problem arised. I got this error message :
>"The source of the report definition has not been specified"
>I thought that when you set the report in the report viewer control
>the work is done but unfortunately this is not the case.
>Even more, I don't have a clue of what I am supposed to do.
>(I know I have to set the reportviewer to load the report but
>I do not know how to do that)
>Rookie in RS I suppose...
A really good source of info for ReportViewer is
www.gotreportviewer.com. Documentation for RV is not very good and the
tutorials on that site help a lot.
I'm not sure what the error message is about though.