Analytic Engine does not START after bad deploy

, ,
1

Hi every body!

I have a problem with my Analytic Engine. I can´t start it. The problem arose after a wrong deployment.

I did it:

  1. Remove all endpoints with the exception of the Configuration Agent.
  2. Example of what file should look like after it’s been edited:
<?xml version="1.0" encoding="UTF-8"?>
  1. Start the AE from the \optimize\analysis\bin\startup.bat
  2. Once the AE has started, in MWS, Administrator, Define Environments

But when i go to “My webMethods>System Settings>Servers” Analytic Engine is shown in red dot.

The first error on logs was

(OPTIMIZE) [Analytic Engine v9.8.0.0.Stack.UnknownKey] 2016-12-08 15:32:49.115 CST ERROR: Unable to start the engine.
(OPTIMIZE) [Analytic Engine v9.8.0.0.Stack.UnknownKey] 2016-12-08 15:32:49.115 CST ERROR: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘dimensionStateProvider’ defined in file [C:\SoftwareAG\optimize\analysis\conf\spring\core.spring.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: DimensionStateLoader load failed.
(OPTIMIZE) [Analytic Engine v9.8.0.0.Stack.UnknownKey] 2016-12-08 15:32:49.115 CST ERROR: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
(OPTIMIZE) [Analytic Engine v9.8.0.0.Stack.UnknownKey] 2016-12-08 15:32:49.115 CST ERROR: wraps: java.lang.RuntimeException: DimensionStateLoader load failed.
(OPTIMIZE) [Analytic Engine v9.8.0.0.Stack.UnknownKey] 2016-12-08 15:32:49.115 CST ERROR: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
(OPTIMIZE) [Analytic Engine v9.8.0.0.Stack.UnknownKey] 2016-12-08 15:32:49.115 CST ERROR: wraps: java.util.concurrent.ExecutionException: java.lang.RuntimeException: DimensionStateLoader load failed.
(OPTIMIZE) [Analytic Engine v9.8.0.0.Stack.UnknownKey] 2016-12-08 15:32:49.115 CST ERROR: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
(OPTIMIZE) [Analytic Engine v9.8.0.0.Stack.UnknownKey] 2016-12-08 15:32:49.115 CST ERROR: wraps: java.lang.RuntimeException: DimensionStateLoader load failed.
(OPTIMIZE) [Analytic Engine v9.8.0.0.Stack.UnknownKey] 2016-12-08 15:32:49.115 CST ERROR: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
(OPTIMIZE) [Analytic Engine v9.8.0.0.Stack.UnknownKey] 2016-12-08 15:32:49.115 CST ERROR: wraps: java.lang.RuntimeException: Error loading dimension instances for definition [PSsiniestro2]
(OPTIMIZE) [Analytic Engine v9.8.0.0.Stack.UnknownKey] 2016-12-08 15:32:49.115 CST ERROR: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
(OPTIMIZE) [Analytic Engine v9.8.0.0.Stack.UnknownKey] 2016-12-08 15:32:49.115 CST ERROR: wraps: java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00904: “PSSINIESTRO2_COL”: invalid identifier

                                                                                        at com.wm.dd.jdbc.oraclebase.ddcr.b(Unknown Source)
                                                                                        at com.wm.dd.jdbc.oraclebase.ddcr.a(Unknown Source)
                                                                                        at com.wm.dd.jdbc.oraclebase.ddcq.b(Unknown Source)
                                                                                        at com.wm.dd.jdbc.oraclebase.ddcq.a(Unknown Source)
                                                                                        at com.wm.dd.jdbc.oracle.ddal.a(Unknown Source)
                                                                                        at com.wm.dd.jdbc.oracle.ddal.a(Unknown Source)
                                                                                        at com.wm.dd.jdbc.oracle.ddam.t(Unknown Source)
                                                                                        at com.wm.dd.jdbc.oraclebase.dde3.x(Unknown Source)
                                                                                        at com.wm.dd.jdbc.oraclebase.dde3.w(Unknown Source)
                                                                                        at com.wm.dd.jdbc.oraclebase.dddz.executeQuery(Unknown Source)
                                                                                        at com.webmethods.optimize.datamodel.common.DimensionInstanceStorage.getDimensionStateForType(DimensionInstanceStorage.java:517)
                                                                                        at com.webmethods.optimize.datamodel.common.DimensionStateLoader.loadDimensionInstancesForDefinition(DimensionStateLoader.java:120)
                                                                                        at com.webmethods.optimize.datamodel.common.DimensionStateLoader.access$000(DimensionStateLoader.java:31)
                                                                                        at com.webmethods.optimize.datamodel.common.DimensionStateLoader$DimensionInstancesLoader.call(DimensionStateLoader.java:266)
                                                                                        at com.webmethods.optimize.datamodel.common.DimensionStateLoader$DimensionInstancesLoader.call(DimensionStateLoader.java:245)
                                                                                        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
                                                                                        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
                                                                                        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
                                                                                        at java.lang.Thread.run(Thread.java:745)

(OPTIMIZE) [Analytic Engine v9.8.0.0.DimensionStateLoader$DimensionInstancesLoader.UnknownKey] 2016-12-08 15:33:31.975 CST ERROR:
(OPTIMIZE) [Analytic Engine v9.8.0.0.DimensionStateLoader$DimensionInstancesLoader.UnknownKey] 2016-12-08 15:33:31.975 CST ERROR: java.lang.RuntimeException: Error loading dimension instances for definition [PSsiniestro2]
(OPTIMIZE) [Analytic Engine v9.8.0.0.DimensionStateLoader$DimensionInstancesLoader.UnknownKey] 2016-12-08 15:33:31.975 CST ERROR: at com.webMethods.optimize.datamodel.common.DimensionStateLoader.loadDimensionInstancesForDefinition(DimensionStateLoader.java:137)
(OPTIMIZE) [Analytic Engine v9.8.0.0.DimensionStateLoader$DimensionInstancesLoader.UnknownKey] 2016-12-08 15:33:31.975 CST ERROR: wraps: java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00904: “PSSINIESTRO2_COL”: invalid identifier

                                                                                                                                at com.wm.dd.jdbc.oraclebase.ddcr.b(Unknown Source)
                                                                                                                                at com.wm.dd.jdbc.oraclebase.ddcr.a(Unknown Source)
                                                                                                                                at com.wm.dd.jdbc.oraclebase.ddcq.b(Unknown Source)
                                                                                                                                at com.wm.dd.jdbc.oraclebase.ddcq.a(Unknown Source)
                                                                                                                                at com.wm.dd.jdbc.oracle.ddal.a(Unknown Source)
                                                                                                                                at com.wm.dd.jdbc.oracle.ddal.a(Unknown Source)
                                                                                                                                at com.wm.dd.jdbc.oracle.ddam.t(Unknown Source)
                                                                                                                                at com.wm.dd.jdbc.oraclebase.dde3.x(Unknown Source)
                                                                                                                                at com.wm.dd.jdbc.oraclebase.dde3.w(Unknown Source)
                                                                                                                                at com.wm.dd.jdbc.oraclebase.dddz.executeQuery(Unknown Source)
                                                                                                                                at com.webmethods.optimize.datamodel.common.DimensionInstanceStorage.getDimensionStateForType(DimensionInstanceStorage.java:517)
                                                                                                                                at com.webmethods.optimize.datamodel.common.DimensionStateLoader.loadDimensionInstancesForDefinition(DimensionStateLoader.java:120)
                                                                                                                                at com.webmethods.optimize.datamodel.common.DimensionStateLoader.access$000(DimensionStateLoader.java:31)
                                                                                                                                at com.webmethods.optimize.datamodel.common.DimensionStateLoader$DimensionInstancesLoader.call(DimensionStateLoader.java:266)
                                                                                                                                at com.webmethods.optimize.datamodel.common.DimensionStateLoader$DimensionInstancesLoader.call(DimensionStateLoader.java:245)
                                                                                                                                at java.util.concurrent.FutureTask.run(FutureTask.java:266)
                                                                                                                                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
                                                                                                                                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
                                                                                                                                at java.lang.Thread.run(Thread.java:745)

(OPTIMIZE) [Analytic Engine v9.8.0.0.DimensionStateLoader.UnknownKey] 2016-12-08 15:33:32.147 CST ERROR:
(OPTIMIZE) [Analytic Engine v9.8.0.0.DimensionStateLoader.UnknownKey] 2016-12-08 15:33:32.147 CST ERROR: java.util.concurrent.ExecutionException: java.lang.RuntimeException: DimensionStateLoader load failed.
(OPTIMIZE) [Analytic Engine v9.8.0.0.DimensionStateLoader.UnknownKey] 2016-12-08 15:33:32.147 CST ERROR: at java.util.concurrent.FutureTask.report(FutureTask.java:122)
(OPTIMIZE) [Analytic Engine v9.8.0.0.DimensionStateLoader.UnknownKey] 2016-12-08 15:33:32.147 CST ERROR: wraps: java.lang.RuntimeException: DimensionStateLoader load failed.
(OPTIMIZE) [Analytic Engine v9.8.0.0.DimensionStateLoader.UnknownKey] 2016-12-08 15:33:32.147 CST ERROR: at java.util.concurrent.FutureTask.report(FutureTask.java:122)
(OPTIMIZE) [Analytic Engine v9.8.0.0.DimensionStateLoader.UnknownKey] 2016-12-08 15:33:32.147 CST ERROR: wraps: java.lang.RuntimeException: Error loading dimension instances for definition [PSsiniestro2]
(OPTIMIZE) [Analytic Engine v9.8.0.0.DimensionStateLoader.UnknownKey] 2016-12-08 15:33:32.147 CST ERROR: at java.util.concurrent.FutureTask.report(FutureTask.java:122)
(OPTIMIZE) [Analytic Engine v9.8.0.0.DimensionStateLoader.UnknownKey] 2016-12-08 15:33:32.147 CST ERROR: wraps: java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00904: “PSSINIESTRO2_COL”: invalid identifier

                                                                                                       at com.wm.dd.jdbc.oraclebase.ddcr.b(Unknown Source)
                                                                                                       at com.wm.dd.jdbc.oraclebase.ddcr.a(Unknown Source)
                                                                                                       at com.wm.dd.jdbc.oraclebase.ddcq.b(Unknown Source)
                                                                                                       at com.wm.dd.jdbc.oraclebase.ddcq.a(Unknown Source)
                                                                                                       at com.wm.dd.jdbc.oracle.ddal.a(Unknown Source)
                                                                                                       at com.wm.dd.jdbc.oracle.ddal.a(Unknown Source)
                                                                                                       at com.wm.dd.jdbc.oracle.ddam.t(Unknown Source)
                                                                                                       at com.wm.dd.jdbc.oraclebase.dde3.x(Unknown Source)
                                                                                                       at com.wm.dd.jdbc.oraclebase.dde3.w(Unknown Source)
                                                                                                       at com.wm.dd.jdbc.oraclebase.dddz.executeQuery(Unknown Source)
                                                                                                       at com.webmethods.optimize.datamodel.common.DimensionInstanceStorage.getDimensionStateForType(DimensionInstanceStorage.java:517)
                                                                                                       at com.webmethods.optimize.datamodel.common.DimensionStateLoader.loadDimensionInstancesForDefinition(DimensionStateLoader.java:120)
                                                                                                       at com.webmethods.optimize.datamodel.common.DimensionStateLoader.access$000(DimensionStateLoader.java:31)
                                                                                                       at com.webmethods.optimize.datamodel.common.DimensionStateLoader$DimensionInstancesLoader.call(DimensionStateLoader.java:266)
                                                                                                       at com.webmethods.optimize.datamodel.common.DimensionStateLoader$DimensionInstancesLoader.call(DimensionStateLoader.java:245)
                                                                                                       at java.util.concurrent.FutureTask.run(FutureTask.java:266)
                                                                                                       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
                                                                                                       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
                                                                                                       at java.lang.Thread.run(Thread.java:745)
2

Hi Erick,

is there a database schema setup for product optimize which your analytic engine will refer to?

Define a database pool for this schema before creating the environment.
Assign this db pool in the right tab when defining the environment.

After that redeploy the complete environment and restart AE.

Eventually you might want to uninstall and reinstall the optimize installation in a clean state before trying the next deployment of the environment.

When applying Fixes to optimize make sure that the optimize installation and the MWS installation have the same optimize fix level applied.

Regards,
Holger

3

Hi Thomsen,

Yes I have a Database Schema.
I did anothes tests and I could check that the problem is this DB, I think that it is corrupted. So, I am researching how to reinstall the DB sheme to drop the Tables of DImensions and Even Map that I tried to create with the bad deploy, because these are the problem.
In logs I could see when AE tried to read “analytic.enging” pool but AE can not read some dimension tables.

I am not sure if I need to reinstall all the Optimize DB scheme, or I could delete only the Dimension and Even Map tables.

I did another test:

  1. Remove all endpoints with the exception of the Configuration Agent.
  2. Example of what file should look like after it’s been edited:
<?xml version="1.0" encoding="UTF-8"?>
  1. Start the AE from the \optimize\analysis\bin\startup.bat
  2. Once the AE has started, in MWS, Administrator, Define Environments but in this case y use other DB scheme that it is OK.

The result was successful.

4

HI,

The simplest way could be simply using the DBconfigurator to drop+create the analytic engine components so you can start from a clean DB.

I think that the AE creates specific tables for each event map and/or KPI, which are still present after the DROP. They should be easy to spot.

If you are confident the database is specific and only used for AE, you can delete everything (including tables, sequences, triggers, stored procedures and indexes) and create the DB components again.

Good Luck.

Season’s Greetings.

5

Hi Gerardo,

I applied DBconfiguration recreate Optimize product, but It delete no only Analityc Tables also delete ProcessAudit and ProcessTracker.

Do you know if analytic engine components only delete BAM Tables?

6

Hi
BAM tales represents Optimize for process, there are other tables associated as well like optimize for infra.

7

At the moment we have a similar problem. After the monitor database was broken. We tried to reinstall everything. Now we get the following error.
:!: :?:

After re-Installation of Optimize components (file system and database) along with the MWS server (database and instance recreation) and deployment of the environment we are no longer able to start analytic engine. It is running into following errors and crashes:

(OPTIMIZE) [Analytic Engine v9.12.0.0.HttpWSServer$ConfigListener$1.UnknownKey] 2017-04-07 11:44:05.621 CEST ERROR: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘dimensionStateProvider’ defined in file [D:\wm912\optimize\analysis\conf\spring\core.spring.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: DimensionStateLoader load failed.
(OPTIMIZE) [Analytic Engine v9.12.0.0.HttpWSServer$ConfigListener$1.UnknownKey] 2017-04-07 11:44:05.621 CEST ERROR: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1514)
(OPTIMIZE) [Analytic Engine v9.12.0.0.HttpWSServer$ConfigListener$1.UnknownKey] 2017-04-07 11:44:05.621 CEST ERROR: wraps: java.lang.RuntimeException: DimensionStateLoader load failed.
(OPTIMIZE) [Analytic Engine v9.12.0.0.HttpWSServer$ConfigListener$1.UnknownKey] 2017-04-07 11:44:05.621 CEST ERROR: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1514)
(OPTIMIZE) [Analytic Engine v9.12.0.0.HttpWSServer$ConfigListener$1.UnknownKey] 2017-04-07 11:44:05.621 CEST ERROR: wraps: java.util.concurrent.ExecutionException: java.lang.RuntimeException: DimensionStateLoader load failed.
(OPTIMIZE) [Analytic Engine v9.12.0.0.HttpWSServer$ConfigListener$1.UnknownKey] 2017-04-07 11:44:05.621 CEST ERROR: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1514)
(OPTIMIZE) [Analytic Engine v9.12.0.0.HttpWSServer$ConfigListener$1.UnknownKey] 2017-04-07 11:44:05.621 CEST ERROR: wraps: java.lang.RuntimeException: DimensionStateLoader load failed.
(OPTIMIZE) [Analytic Engine v9.12.0.0.HttpWSServer$ConfigListener$1.UnknownKey] 2017-04-07 11:44:05.621 CEST ERROR: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1514)
(OPTIMIZE) [Analytic Engine v9.12.0.0.HttpWSServer$ConfigListener$1.UnknownKey] 2017-04-07 11:44:05.621 CEST ERROR: wraps: java.lang.RuntimeException: Error loading dimension instances for definition [ProcessError]
(OPTIMIZE) [Analytic Engine v9.12.0.0.HttpWSServer$ConfigListener$1.UnknownKey] 2017-04-07 11:44:05.621 CEST ERROR: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1514)
(OPTIMIZE) [Analytic Engine v9.12.0.0.HttpWSServer$ConfigListener$1.UnknownKey] 2017-04-07 11:44:05.621 CEST ERROR: wraps: java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

at com.wm.dd.jdbc.oraclebase.ddcr.b(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddcr.a(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddcq.b(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddcq.a(Unknown Source)
at com.wm.dd.jdbc.oracle.ddal.a(Unknown Source)
at com.wm.dd.jdbc.oracle.ddal.a(Unknown Source)
at com.wm.dd.jdbc.oracle.ddam.t(Unknown Source)
at com.wm.dd.jdbc.oraclebase.dde3.y(Unknown Source)
at com.wm.dd.jdbc.oraclebase.dde3.x(Unknown Source)
at com.wm.dd.jdbc.oraclebase.dddz.executeQuery(Unknown Source)
at com.webMethods.optimize.datamodel.common.DimensionInstanceStorage.getDimensionStateForType(DimensionInstanceStorage.java:516)
at com.webMethods.optimize.datamodel.common.DimensionStateLoader.loadDimensionInstancesForDefinition(DimensionStateLoader.java:121)
at com.webMethods.optimize.datamodel.common.DimensionStateLoader.access$000(DimensionStateLoader.java:31)
at com.webMethods.optimize.datamodel.common.DimensionStateLoader$DimensionInstancesLoader.call(DimensionStateLoader.java:270)
at com.webMethods.optimize.datamodel.common.DimensionStateLoader$DimensionInstancesLoader.call(DimensionStateLoader.java:249)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘dimensionStateProvider’ defined in file [D:\wm912\optimize\analysis\conf\spring\core.spring.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: DimensionStateLoader load failed.
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1514)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:636)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:938)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
at com.webMethods.optimize.service.external.spring.SpringLoader.createApplicationContext(SpringLoader.java:43)
at com.webMethods.optimize.service.external.util.HttpWSServer.startEngineServices(HttpWSServer.java:186)
at com.webMethods.optimize.service.external.util.HttpWSServer.access$200(HttpWSServer.java:40)
at com.webMethods.optimize.service.external.util.HttpWSServer$ConfigListener$1.run(HttpWSServer.java:520)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: DimensionStateLoader load failed.
at com.webMethods.optimize.datamodel.common.DimensionStateLoader.loadAllDimensions(DimensionStateLoader.java:82)
at com.webMethods.optimize.datamodel.common.DimensionStateProvider.start(DimensionStateProvider.java:111)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1640)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1581)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1511)
… 14 more
Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: DimensionStateLoader load failed.
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:192)
at com.webMethods.optimize.datamodel.common.DimensionStateLoader.loadAllDimensions(DimensionStateLoader.java:70)
… 22 more
Caused by: java.lang.RuntimeException: DimensionStateLoader load failed.
at com.webMethods.optimize.datamodel.common.DimensionStateLoader$DimensionInstancesLoader.call(DimensionStateLoader.java:274)
at com.webMethods.optimize.datamodel.common.DimensionStateLoader$DimensionInstancesLoader.call(DimensionStateLoader.java:249)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)#
Caused by: java.lang.RuntimeException: Error loading dimension instances for definition [ProcessError]
at com.webMethods.optimize.datamodel.common.DimensionStateLoader.loadDimensionInstancesForDefinition(DimensionStateLoader.java:137)
at com.webMethods.optimize.datamodel.common.DimensionStateLoader.access$000(DimensionStateLoader.java:31)
at com.webMethods.optimize.datamodel.common.DimensionStateLoader$DimensionInstancesLoader.call(DimensionStateLoader.java:270)
… 5 more
Caused by: java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

at com.wm.dd.jdbc.oraclebase.ddcr.b(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddcr.a(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddcq.b(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddcq.a(Unknown Source)
at com.wm.dd.jdbc.oracle.ddal.a(Unknown Source)
at com.wm.dd.jdbc.oracle.ddal.a(Unknown Source)
at com.wm.dd.jdbc.oracle.ddam.t(Unknown Source)
at com.wm.dd.jdbc.oraclebase.dde3.y(Unknown Source)
at com.wm.dd.jdbc.oraclebase.dde3.x(Unknown Source)
at com.wm.dd.jdbc.oraclebase.dddz.executeQuery(Unknown Source)
at com.webMethods.optimize.datamodel.common.DimensionInstanceStorage.getDimensionStateForType(DimensionInstanceStorage.java:516)
at com.webMethods.optimize.datamodel.common.DimensionStateLoader.loadDimensionInstancesForDefinition(DimensionStateLoader.java:121)
… 7 more

Following actions have already been performed in order to troubleshoot this issue:

→ Restart of optimize and MWS components and physical server
→ Re-create optimize components (AE, IDC, WDC)
→ Re-create optimize components along with the database components
→ Re-create optimize and MWS components along with the corresponding database components
→ Complete re-installation of all webMethods components (including common) and corresponding database components
→ Changing database user and recreate MWS and optimize including databse components

→ Connecting AE to development database (optimize works properly)
→ When environment is deployed after startup, no KPI instances are created
→ Manually creating tables that are present in dev environment and missing in current environment