I’m hoping someone out there has a sensible suggestion about what might cause the following error
(OPTIMIZE) [Analytic Engine v126.96.36.199.DbMigrationFactory.UnknownKey] 2016-04-04 15:37:57.430 BST ERROR: java.sql.SQLSyntaxErrorException: [SoftwareAG][SQLServer JDBC Driver][SQLServer]Invalid object name ‘INSTALLED_COMPONENT’.
I am running with a 9.9 installation and I have defined my environment with 3 JDBC Pools, the OptimiseDB, the ProcessDB and MWS DB. I have run the DB configurator to make sure the databases are up to date but no avail.
Question: how to unset a DB URL once a deployment has been made successful but the engine fails to start (hence you can’t redeploy to reset)
I have uninstalled the AE and Re-installed to start the engine and i’m now in the process of checking if i have to have everything everywhere in my DBs