Good Morning,
I’ve found a couple topics similar to this, but the fixes do not help. I have not added any UD fields, but suddenly I am getting this error SPORADICALLY, when running a custom SSRS version of the Edit List. Just wondering if beyond UD fields and possible a datasync issue, what could be the cause of this?
Program Ice.Services.Lib.RunTask raised an unexpected
exception with the following message: RunTask:
Column ‘Calc_Rpt1ExtTransValue’ does not belong to table
RcvDtl.
Thanks Jason.
It looks like the rcvdtl.ExtTransValue field is not used anywhere in the SSRS report. I excluded it in the RDD and the report works fine now, but I want to be sure I am not screwing anything up. I did not build this custom version and nothing has been changed, but we started to get this error last week. It also seemed to resolve itself at one point, but now happens sporadically. Is there somewhere I can see the entire Query for the report, including the calculated values to make sure I am not missing it somewhere?
Eric
If you have SQL access, you can see the generated output tables. However, if this is a minor customization, you may want to revert back to the standard SSRS and make the changes again.
Also, if your Report Data Definition had any fields deleted, you may want to revert that as well and start over.
So after reviewing the RDD for both the system AP_Edit and the custom, this field was missing. Wonder if copying the report before customizing leaves out calculated fields? Even if it is not using that field, there was a call to it causing it to error. Once I created the calculated fields that were missing, the error stopped.