Getting Unable to cast object of type error when generating the report

​@rashmikamudalinayake10 

Did you upgraded the Acumatica to any other version, The report has few changes in 24r1 version I believe.

Nope, I installed the 24.111.0011 Version.

​@rashmikamudalinayake10  Have you installed sales demo or did you use any DB?

Hi ​@rashmikamudalinayake10,

If you have customizations that modifies the report, unpublish and test. Also, enable logging in Request Profiler to collect and check error stack. Please feel free to share the error stack and any questions you may have.

Here is the Trace
 

/* Stack Trace:

   at PX.Common.PXStackTrace.GetStackTrace(Int32 skipFrames, Boolean needFileInfo)
   at PX.SM.PXPerformanceInfo.AddSqlSample(String cmdText, String parameterDeclaration, Boolean queryCache)
   at PX.Data.PXSqlDatabaseProvider.ExecuteReaderInternal(IDbCommand command, CommandBehavior behavior)
   at PX.Data.PXSelectResult.PXSelectResultEnumerator.System.Collections.IEnumerator.MoveNext()
   at PX.Data.PXView.GetResult(Object[] parameters, PXFilterRow[] filters, Boolean reverseOrder, Int32 topCount, PXSearchColumn[] sorts, Boolean& overrideSort, Boolean& extFilter)
   at PX.Data.PXView.Select(Object[] currents, Object[] parameters, Object[] searches, String[] sortcolumns, Boolean[] descendings, PXFilterRow[] filters, Int32& startRow, Int32 maximumRows, Int32& totalRows, String[] sortAsImplicitColumns)
   at PX.Data.PXView.Select(Object[] currents, Object[] parameters, Object[] searches, String[] sortcolumns, Boolean[] descendings, PXFilterRow[] filters, Int32& startRow, Int32 maximumRows, Int32& totalRows)
   at PX.Data.PXView.SelectSingleBound(Object[] currents, Object[] parameters)
   at PX.Data.PXDefaultAttribute.SelectRow(PXCache cache, PXDefaultAttribute attr, Object data)
   at PX.Data.PXDefaultAttribute.Select(PXCache cache, PXDefaultAttribute attr, Object data)
   at PX.Data.PXDefaultAttribute.FieldDefaulting(PXCache sender, PXFieldDefaultingEventArgs e)
   at PX.Data.PXCache.AttributeHandlersSquasher`1.<>c__DisplayClass2_0`1.<To>b__0(PXCache cache, TArgs args)
   at PX.Data.PXCache.OnFieldDefaulting(String name, Object row, Object& newValue)
   at PX.Data.PXCache`1.FillWithValues(TNode copy, TNode& item)
   at PX.Data.PXCache`1.Insert(Object data, Boolean bypassinterceptor)
   at PX.Data.PXCache`1.Insert(TNode data)
   at PX.Data.PXCache`1.Insert()
   at PX.Data.Reports.SoapNavigator.DATA._SelfGetCurrent(PXCache cache)
   at PX.Data.Reports.SoapNavigator._GetCurrent(PXCache cache)
   at PX.Data.Reports.SoapNavigator.GetFieldSchema(Object field)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at PX.Common.Parser.FunctionNode.Eval(Object row)
   at PX.Reports.ReportParameter.(Report , IDataNavigator , String , String , String )
   at PX.Reports.ReportParameter.Process(IDataNavigator , Report )
   at PX.Web.UI.PXReportViewer.ProcessReportParams()
   at PX.Web.UI.PXReportViewer.RegisterScriptProperties(JSObject obj)
   at PX.Web.UI.JSConverter.ConvertCustomObject(Object obj, Control owner, JSObjectDelegate createCallback, Object template)
   at PX.Web.UI.JSConverter.Convert(Object obj, Control owner, JSObjectDelegate createCallback, Object template)
   at PX.Web.UI.JSManager.RegisterControlData()
   at PX.Web.UI.JSManager.Register()
   at PX.Web.UI.PXWebControl.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at PX.Web.UI.PXPage.ProcessRequest(HttpContext context)
 */

Hello ​@rashmikamudalinayake10,

Have you tried to disable the custom version of ap641000 report?

Also, please try to update the report designer version 24.207 and see if this resolves the issue.

Thanks!

Yes I disable the custom version and tried too.
‘ll try report designer version 24.207 then.  
Thanks.

Hi ​@rashmikamudalinayake10,

Error stack doesn’t seem to provide the specifics/cause of the issue. Hopefully using the different version of the report designer might fix the issue. Thanks