Portal

Hello,

Even though this topic was solved over on ticket, I still wanted to provide some investigation leads here for other customers that might face the same behavior.

• In order to make sense of the root cause, it is important to retrace your steps to have a clear view on the context after which you are encountering the issue. Because, for example, this is something that can be encountered either after a refresh, upgrade or any other action that previously required to do a schema backup. Resulting in 2 schemas on the same database having the Levenshtein function present, creating a dependency for your system.
• Restarting tomcat with a cache clearing can also help to avoid any inconsistencies left from in-memory kept elements:
  • Stop the tomcat on all instances
  • Delete the folder semarchy under webapps/
  • Delete the folder Catalina under work/
  • Delete all logs under logs/
  • Start tomcat
• If after doing so, you are still facing the issue, please run a check consistency and analyze the resulting pde logs. You can do this by:
  • Open the Application Builder
  • Menu: <Username> -> Error Log
  • Click the Menu Icon 
  • Select Check Consistency 

                    Note: Please delete the contents of the PDE Log first. Then export and send the log to the support team.

• Finally, check your search_path to make sure that it matches what is recommended in our documentation.

I hope this will help.

But if someone's still facing issues after those steps, please open a ticket to the support team for further analysis (by mentioning the steps already taken and the associated results).

Thank you