SSRS RptParameters - Where do they come from?

Kinetic ERP
1

Hello everyone,

We are on-premise and just updated a testing environment from 2024.2 to 2025.2.

I have been trying to debug a standard SSRS for hours now. Could really use your help!

The issue is with the ARForm report style, the standard one. When we try to print it, we get an error related to a new RptParameter named “DetailCarbonCost” that was added in a recent version. Carbon Cost is a module which we do not have the license.

Ice.Core.SsrsReporting.SsrsCaller.SsrsException: The SSRS server returned the status code 500 (InternalServerError) with the following error text:
System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'RptParameter'. ---> System.Data.SqlClient.SqlException: Invalid column name 'DetailCarbonCost'.

I was wondering, how does Epicor dynamically generates its RptParameter_GUID tables? Where are the columns defined? Can’t find anything in the Report Data Definition. I guess these parameters are not part of the RDD?

SELECT TOP (1000) [Company]
      ,[ARInvFormReportID]
      ,[AssignLegalNumber]
      ,[BeginDate]
      ,[BeginNum]
      ,[CalledFrom]
      ,[CurGroup]
      ,[CustIDList]
      ,[CustList]
      ,[DCList]
      ,[DemandContractList]
      ,[Description]
      **,[DetailCarbonCost]** // Missing parameter here!
      ,[DocTypeOption]
      ,[DraftCopy]
      ,[DspDocCopyNum]
      ,[EnableAssignLegalNumber]
      ,[EnableUseCopyNumInARInv]
      ,[EndDate]
      ,[EndNum]
      ,[InvoiceNum]
      ,[InvoiceStatusOption]
      ,[PrintInventoryAttributes]
      ,[PrintNPost]
      ,[PrintStatusOption]
      ,[TH_IsService]
      ,[THHeadOfficeOrBranch]
      ,[THPlaceOfBusiness]
      ,[TranDocTypeID]
      ,[TransOptions]
      ,[TWCompInvPart1]
      ,[TWCompInvPart2]
      ,[TWCompInvPart3Back]
      ,[TWCompInvPart3Front]
      ,[TWEInvPrizeCollection]
      ,[TWEInvTransDetails]
      ,[Vouchering]
      ,[ReportCultureCode]
      ,[ReportCurrencyCode]
      ,[ThousandsSeparator]
      ,[DecimalSeparator]
      ,[DecimalsGeneral]
      ,[DecimalsCost]
      ,[DecimalsPrice]
      ,[GlbDecimalsGeneral]
      ,[GlbDecimalsCost]
      ,[GlbDecimalsPrice]
      ,[DecimalsQuantity]
      ,[CompanyExecutionTime]
  FROM [DemoUpdate_SSRSData].[dbo].[RptParameter_6063F89B91044AC2A554AA23A0C5E3A9]

As always, I appreciate your help :heart_hands:

1 Like
2

Oh surely that’s a bug…

The fields are in the tables exclude in the rdd so perhaps the definition has it enabled and the report assembly is doing something with licensing and trye to exclude, who knows these days with the SSRS reports today. There has been soo much change and as I understand it there are some underlying, ongoing issues with reports that Epicor are working on, and Carbon cost issues may well be part of this.

As far as the generation of the tables. I believe on execution of the report the unique value is generated for the report execution, that value is concatenated to the table names that are stored in the report tempdb, and passed through to the SSRS report as the parameter. Needless to say why you can use the system monitor to reprint reports (if you archive period is set correctly) and they load really quickly as it bypasses the whole data generating process.

Apologies if this is stuff you already know or I have totally missed the question.

3

Probably a bug as you say. I opened a Epicor Case, though I can’t provide reproduction steps as it does not happen in a fresh Demo database.

We have a similar issue with the Sales Order Acknowledgment Report, this time regarding the PrintCarbonCostDetails column. That is weird since I do see the carbon cost fields in the dataset (network tab). They just don’t get to the RptParameter_GUID table, so the SSRS report is unable to pull the value from it in its SQL query.

System.Data.SqlClient.SqlException: Invalid column name 'PrintCarbonCostDetails'.
4

It kind of reminds me of this post from back when 2025.2 was launched.

2025.2.7 Unable to print Pack Slips - Kinetic ERP - Epicor User Help Forum

5

I’d just modify thee sql on the rdl to remove