AnsweredAssumed Answered

Error following restore from Production

Question asked by CMCN1982 on Jan 16, 2014
Latest reply on Jan 16, 2014 by CMCN1982

Hi all,

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: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?