Memory leak in creating RLDC Reports in .Net 4.0

There is a huge memory leak in Microsofts LocalReport implementation in .Net 4.0

The work around to make it a small memory leak is here,
and in the comments is how to make it go away...


Though I'll warn you it's a pain.



http://stackoverflow.com/questions/6220915/very-high-memory-usage-in-net-4-0

Are you having a memory leak because of Strucutre map?

So here's the situation....


(My parents went away for a weeks vacation...(Soory, can't help myself, child of the 80s...))



Running a winforms app using a Library that has structure map all through it, and it uses ObjectFactory directly instead of IContainer....


So we get memory leaks that we can't get rid of as Structure map is hanging on to instances of the objects so they can't be garbage collected...



Here's the quick hack to fix in,



Since what I'm doing is in a loop, at the bottom of the loop construct I just type:



// strucutre map memory leak hack, works okay i guess, it's slower as expected - EWB
ObjectFactory.ResetDefaults();



and it flushes all the objects out of Structure map...

Of course it's slower because all the objects get re init-ed in each loop, but the memory
got tons better...

Also note that in an upcoming release,



ObjectFactory.ResetDefaults();



will get changed to



ObjectFactory.Reset();

The parameter of type 61 did not have a valid value

The parameter of type 61 did not have a valid value

This is an error from the Sybade Database.

It means that a variable of type 61 (Date) does not have a valid value.

This is ususally caused by your Date time not being Nullable in your EO or you CV and because
Microsoft and Sybase have different Epochs, or Minimum Dates values.

Microsofts EPOCH for a DateTime is: 00:00:00.0000000, January 1, 0001
and Sybases depends on the exat type in your DB see the chart here:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc35400.1550/html/osref/osref281.htm

But in essence here is what happens.

In the DB the Date is null,
In your EO the dateTime is not nullable
Net converts the null to DateTime.Min (01/01/01)
during an update this value is smaller than the allowed (for us ususally 01/01/1900)

Best fix, it to change the Datetimes in your EO & CV toall  be nullable, OR to use a CV that does not contain any of the date fields for updating, and let JCDCHelper deal with it..

See here for the codes of all Sybase datatypes : http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.tables/html/tables/tables69.htm

An error occurred during local report processing. ->An error occurred during local report processing. ->ClassName

So I was Moving an RDLC Report from one applicaiton to another,

I was getting this excpetion..

(summary of the messages of the exception and it's inner exceptions:
An error occurred during local report processing. --->
 An error has occurred during report processing. --->
  StudTarReportCV

Where StudTarReportCV is the name of the class I'm passign in a list of with the reprot Data.

Not alot to go on, basically it says "Something Bad Happned with the CV class"

The Actual Problem was that the DataSet Name I was Passing it didnt' match the one defined in the RDLC.

RDLC-> StudTarReportCV
PassedToReportViewer->EFolderReportGenerator3G_CV_StudTarReportCV


So how I fixed it was to modify the XML in thie RDLC file so that the dataSet Definition matched the value i was passing in:

<DataSetName>EFolderReportGenerator3G_CV_StudTarReportCV</DataSetName>

and then modified the use of the data set in the Tablix to match there:

<DataSet Name="EFolderReportGenerator3G_CV_StudTarReportCV">
Voilia, it's all working now...Full Text of Exception, incase anyone else runs into it:

Exception in StudentTar Ex = Microsoft.Reporting.WinForms.LocalProcessingException: An error occurred during local report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: StudTarReportCV
   at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery()
   at Microsoft.ReportingServices.OnDemandProcessing.TablixProcessing.RuntimeOnDemandDataSet.Process()
   at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet)
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.OnDemandProcessing.OnDemandProcessingContext.AbortHelper.ThrowAbortException(String reportUniqueName)
   at Microsoft.ReportingServices.OnDemandProcessing.OnDemandProcessingContext.CheckAndThrowIfAborted()
   at Microsoft.ReportingServices.OnDemandProcessing.RetrievalManager.FetchData(Boolean mergeTran)
   at Microsoft.ReportingServices.OnDemandProcessing.RetrievalManager.PrefetchData(ReportInstance reportInstance, ParameterInfoCollection parameters, Boolean mergeTran)
   at Microsoft.ReportingServices.OnDemandProcessing.Merge.FetchData(ReportInstance reportInstance, Boolean mergeTransaction)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessOdpReport(Report report, OnDemandMetadata odpMetadataFromSnapshot, ProcessingContext pc, Boolean snapshotProcessing, Boolean reprocessSnapshot, Boolean processUserSortFilterEvent, Boolean processWithCachedData, ErrorContext errorContext, DateTime executionTime, IChunkFactory cacheDataChunkFactory, StoreServerParameters storeServerParameters, GlobalIDOwnerCollection globalIDOwnerCollection, SortFilterEventInfoMap oldUserSortInformation, EventInformation newUserSortInformation, String oldUserSortEventSourceUniqueName, ExecutionLogContext executionLogContext, OnDemandProcessingContext& odpContext)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory cacheDataChunkFactory, IChunkFactory yukonCompiledDefinition, Boolean& dataCached)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory yukonCompiledDefinition)
   at Microsoft.Reporting.LocalService.CreateSnapshotAndRender(CatalogItemContextBase itemContext, ReportProcessing repProc, IRenderingExtension renderer, ProcessingContext pc, RenderingContext rc, SubreportCallbackHandler subreportHandler, ParameterInfoCollection parameters, DatasourceCredentialsCollection credentials)
   at Microsoft.Reporting.LocalService.Render(CatalogItemContextBase itemContext, Boolean allowInternalRenderers, ParameterInfoCollection reportParameters, IEnumerable dataSources, DatasourceCredentialsCollection credentials, CreateAndRegisterStream createStreamCallback, ReportRuntimeSetup runtimeSetup)
   at Microsoft.Reporting.WinForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, PageCountMode pageCountMode, CreateAndRegisterStream createStreamCallback, Warning[]& warnings)
   --- End of inner exception stack trace ---
   at Microsoft.Reporting.WinForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, PageCountMode pageCountMode, CreateAndRegisterStream createStreamCallback, Warning[]& warnings)
   at Microsoft.Reporting.WinForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, PageCountMode pageCountMode, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings)
   at Microsoft.Reporting.WinForms.LocalReport.Render(String format, String deviceInfo, PageCountMode pageCountMode, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings)
   at Microsoft.Reporting.WinForms.Report.Render(String format, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings)
   at EFolderReportGenerator3G.Reporting.WinForms.ReportGenerator.GetReportResult(ReportRenderParameters reportRenderParameters) in D:\Project Files\EFolderReportGenerator3G\WinForm\EFolderReportGenerator3G.Reporting\Web\ReportGenerator.cs:line 206
   at EFolderReportGenerator3G.Reporting.WinForms.ReportGenerator.GetReportResult[T](String reportType, String dataSourceName, List`1 data, String reportFileName, List`1 reportParameters) in D:\Project Files\EFolderReportGenerator3G\WinForm\EFolderReportGenerator3G.Reporting\Web\ReportGenerator.cs:line 74
   at EFolderReportGenerator3G.BLL.BusinessObjects.ETarBLL.GetStudTarReportNew(StudTarReportArgumentCV criteria) in D:\Project Files\EFolderReportGenerator3G\WinForm\EFolderReportGenerator3G.BLL\BusinessObjects\ETarBLL.cs:line 1398
   at EFolderReportGenerator3G.BLL.BusinessObjects.ETarBLL.SaveStudTarReportNew(String& fnameExt, String& mineType, String rollingOrPy, EFolderReportArgCV args, StudentCV studentCv) in D:\Project Files\EFolderReportGenerator3G\WinForm\EFolderReportGenerator3G.BLL\BusinessObjects\ETarBLL.cs:line 1460

JCDCHelper code to return one column of one row cleanly

lots of us when returning one column, return an object and then have to cast that to a <T>

This fixes that to work more cleanly.

public T JcdcAdoGetOneColumn<T>(string mainSql){

 object answer;
 using (IAdoHelper ado = ObjectFactory.GetNamedInstance<IAdoHelper>("JCDC")) {

  answer = ado.GetOneColumn<T>(mainSql, null); }


 return ConvertObjectToT<T>( answer );}

  private T ConvertObjectToT<T>( object answer )
{

 // handle the cast for both primitive and non primitive types - EWB if ( answer is T ) {

  return ( T ) answer; }

 else {
 try {
  return ( T ) Convert.ChangeType( answer, typeof ( T ) ); }

 catch ( InvalidCastException ) {

  return default( T ); }
}
　

How to get Vs2010 RDLC tablix to repeat group headers on each page

Go here do this:

http://www.codeease.com/how-to-repeat-table-header-on-every-page-in-rdlc-report.html

Incase it disappears here is the text of the workaround:

1. Go to your Visual Studio RDLC design screen, please look at the right bottom corner in design part. There is a small black rectangle there. Click it and check what you can see:
2. Yes, you can see “Advanced Mode”, please check on it.
3. After you check on Advanced Mode, you will see Row Groups and Column Groups like below:
4. Click “Static” in Row Groups list, and check the properties on the right side:
5. Set “RepeatOnNewPage” to “True”.

Cascading Dropdowns in JcdcHelper

(Post by Lloyd Bates)

In this example, the parent Drop list is named "SepTypeCd" and the child is "SepReason".

When an item is selected in the parent the change event looks to see if a child list is required to be available, if a child menu is needed, it populates it, if not it disables the child dropdown control.

With this pattern, we get to use the Ajax Wrapper function to allow getting all the error handling built in as a bonus.

This example has the "if" statement in it, but it doesn’t have to have it.

　

　　　　　　　 $(document).ready(function () {

　　　　　　　　　　 … …

　　　　　　　　　　　 $(

"#SepTypeCd").change(SepTypeCdChange);

　　　　　　　　　　 … …

　　　　　　　 });

　

　　　　　　　

function SepTypeCdChange() {

　　　　　　　　　　　

//Get selected item from parent drop list

　　　　　　　　　　　

var sepTypeCd = $('select[name=SepTypeCd] option:selected').val();

　　　　　　　　　　　

　　　　　　　　　　　　

//Check if selected item should fire load of child drop.　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　

　　　　　　　　　　　　

if ((sepTypeCd == "538") || (sepTypeCd == "540)

　　　　　　　　　　　 {

　　　　　　　　　　　　　　　

//Set action url

　　　　　　　　　　　　　　　

var actionMethodUrl = '@Url.Action("GetSepReasonDD","StudentLookup")';

　　　　　　　　　　　　　　　

　　　　　　　　　　　　　　　　

//make Ajax call to Get JSON, note: the param "Id" matches the param in the MethodAction.

　 　　　　　　　　　　　　　　JcdcAjaxDoGetRetrieveJson(actionMethodUrl, GetDDLDataSuccess, {

"Id" : sepTypeCd } );

　　　　　　　　　　　 }

　　　　　　　　　　　

else {

　　　　　　　　　　　　　　　

//If child is not to be used, clear options and disable it.

　　　　　　　　　　　　　　　 $(

"#SepReasonCd").empty().end();

　　　　　　　　　　　　　　　 $(

"#SepReasonCd").attr("disabled", "disabled");

　　　　　　　　　　　 }

　　　　　　　 }

　　　　　　　

//Success function can hold all your business logic for before and after drop list is loaded.

　　　　　　　

function GetDDLDataSuccess(jsonDDLDispValueCV) {

　　　　　　　　　　　

//Load all the options to the dropdown.

　　　　　　　　　　　 LoadOptions(jsonDDLDispValueCV,

"SepReasonCd");

　　　　　　　 }

　　　　　　　

//This function could be moved to JCDCAjax.js

　　　　　　　

function LoadOptions(jsonDDLDispValueCV, passedInSelectId) {

　　 　　　　　　　　　

//clear old options from drop list

　　　　　　　　　　　

var reasons = $("#" + passedInSelectId).empty();

　　　　　　　　　　　　　　　　　　　　　　　

　　　　　　　　　　　　

//Load new items in drop list from Ajax data

　　　　　　　　　　　 $.each(jsonDDLDispValueCV,

function(index, option) {

　　　 　　　　　　　　　　　　reasons.append($(

'<option/>', { value: option.Value, text: option.Disp } ));

　　　　　　　　　　　 });

　　　　　　　　　　　

//enable drop down

　　　　　　　　　　　 reasons.removeAttr(

"disabled").end();

　　　　　　　 }

How to get VS2010 Group Headers to repeat on each page.

How to get VS2010 Group Headers to repeat on each page.

Do this:

http://www.jasinskionline.com/technicalwiki/(S(hludmc45qohv1i45zwzg4445))/Repeating-Row-Headers-SSRS-2010.ashx?AspxAutoDetectCookieSupport=1

Note that all statis fir a give group have to ahve all 3 settings set or it errors
(it still give warnings after but it works).


How to find advanced mode (this fix does not work but it has pics to help you find it.)
http://www.codeease.com/how-to-repeat-table-header-on-every-page-in-rdlc-report.html

Connection is busy. Use larger FetchBufferSize or enable connection cloning

Connection is busy. Use larger FetchBufferSize or enable connection cloning

　

Looks like Pooling is a setting on the ConnectionString in the web.config…

More things to try/ check (in order of how easy/likely they are). In case this doesn’t’ help. Take a look at #2 , #3 and #5 they are the most likely to start happening After a long time of things working correctly..

#1 Different Possible web.config workaround: (easy to try)

<

add name="SybaseDB" connectionString="host='******';Pooling=true;Port='5100';UID='*******';Password='******';Database='****';Min Pool Size=5;Load Balance Timeout=30;Max Pool Size=50;Workstation ID='CIS3G';Fetch Buffer Size=4096;Clone Connection If Needed=True" />

#2 Other application consuming to many resources can cause it:

https://knowledgebase.progress.com/articles/Article/Usersunabletoconnectafterrestartingtheapplicationserver

　

#3 Router issue

Its from the oracle boards but it’s about the same error using the same brand of drivers.

Router/switch reset and　 /PAE tags in

　might be the cause …

 

https://software.databasedevelop.com/article/10824330/Connection+is+busy.+Use+larger+FetchBufferSize+or+enable+connection+cloning

#4 New drivers from DDtek

#5 Badly handled Fk　 error from Sybase

http://uxforums.progress.com/ddforums/message.jspa?messageID=1098

http://forums.datadirect.com/ddforums/thread.jspa?messageID=5105https://forums.oracle.com/forums/thread.jspa?threadID=822330&tstart=15portal servers boot.ini http://www.datadirect.com/resources/ado-net/connection-pooling/index.html

#6 There is a bug in the driver that can cause this error, turn off pooling to fix it

https://knowledgebase.progress.com/articles/Article/3543

Another Bug

http://jcdcericb.blogspot.com/2012/07/connection-is-busy-use-larger.html?_sm_au_=iHVqJRT0RJFWJrPQ270cvKQMMp3Ct

 

 
7# IT group set idle connection timeout on the fire wall to 1 hr, from 8, set it back to 8 , and it fixed  it(8/13/2020- EWB)

In an RDLC formatting the date to shortDate sometimes fails and s#Error, even when the data looks perfectly good.

Change this:

=Format(Fields!SurveyCompDt.Value,"dd.MM.yyyy HH:mm:ss")

To This:

=IIf(CDate(Fields!SurveyCompDt.Value)=CDate("1/1/0001"),Nothing,CDate(Fields!SurveyCompDt.Value).ToShortDateString())
and it should go away.

The bug appears to have to do with the conversion of the dates.

A quick and dirty way to diagnose a thread collision problem in c#

If you are having a problem that looks like it might be a rcing condition or other threading type issue, here is a quick and dirty test to determine if it's threading or not. Set up a scenerio that reproduces the error (say running it in several (10) threads in a constant loop overnight) Apply this attribute to your class [Synchronization] That forces all the instances of the class to run on a single thread (way slower). Re run your test. If your problem goes away, you have a threading issue. If speed is a concern, you need to go back and do all the locking around the code that touches that object. If you convert everything to use properties for the objects in question you can just lock the getter and setter. If the quick and dirty test fails to fix the issue, it's probabaly something else. For instance if you're using unsafe code or unsafe dlls (ie stuff written in non .Net c++), it might be a memory corruption problem.

Sybase Datatype numerical code tables for "variable of type 61" type errors

go here to look to determine whichi type is which

Nuget Commands to remember

Get packagge by Verison
Install-Package JCDCHelper.BLL -Version 3.2.2.2

Uninstall all dependances
Uninstall-Package JCDCHelper. –RemoveDependencies –Force


Try to re-install the packages. Fixes bad references
At the NuGet console say:

Update-Package -Reinstall -ProjectName Your.Project.Name

Omit '-Project' parameter if you want to re-install packages and restore references for the whole solution.