So we moved our Epicor database/application from one server to another. I am going through testing all customizations, BPMs, and SSRS. Most are fine, but 2 of my SSRS had the same issue.
Seems to be these columns that it error out indicating that it’s invalid column name.
This same report is in another environment and it ran fine. Both environment were moved to new servers. So not sure what would’ve changed. Any ideas?
Assuming these were valid columns I would regenerate your data model.
After a Database Regen also do a Recycle IIS on both the App Server and Rpt Server.
Looks like these UD fields were added recently by another person that I wasn’t aware off. So now it showed up under my customized RDD. I don’t want them to print on my SSRS form anyways. So I went and exclude these fields from the RDD. Do I need to do a data sync from report style to remove them from the SSRS or would just running data regen and restarting application pool fix it? I am waiting for my admin to run the data regen and restart application pool so just wondering if that would fix or I need to do something else.
I think you will be good after the regen. You could check your report datasets after that but it should be good.
Thank you. It worked after doing the data regen and restarting application pool.
