Yesterday I was asked to restore a copy of Production to our Test environment. The restore completed successfully.
Today, when users try to open a project they get an error message.
"Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.
I checked the app logs and see this message recurring:
Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find either column "NIKU" or the user-defined function or aggregate "NIKU.CMN_DATE_TIME_DIFF_FCT", or the name is ambiguous"
Another point to possibly consider is that while both environments are on version 13.1, our Test environment has patch 8 applied, whereas our Production environment is on Patch 6. Might this be the cause of our issue?