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.