Unable to log on to the ePO console (Invalid object name 'orionconfiguration')

技术文章 ID: KB94431
上次修改时间: 4/20/2021

环境

McAfee ePolicy Orchestrator (ePO) 5.10.x

问题

You are unable to log on to the ePO console.

You see the following error on the ePO console logon page:

Unable to connect to the database. Try again. If the issue reoccurs, notify your product administrator to navigate to https://localhost:8443/core/config on the application server system and verify the database connection settings.

The errors below are recorded in the Orion.log:

2021-04-17 13:49:36,722 WARN [main] base.Database - database startup attempt (9 of 12) failed; sleeping for 10000 milliseconds and will try again...
2021-04-17 13:49:46,732 WARN [main] base.Database - database startup attempt (10 of 12) failed; sleeping for 10000 milliseconds and will try again...
2021-04-17 13:49:56,741 WARN [main] base.Database - database startup attempt (11 of 12) failed; sleeping for 10000 milliseconds and will try again...
2021-04-17 13:50:06,747 ERROR [main] core.OrionCore - Failed to establish a database connection
java.sql.SQLException: Invalid object name 'OrionConfiguration'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:373)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2999)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2432)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:672)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:540)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1461)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:428)
2021-04-17 13:50:06,747 ERROR [main] core.OrionCore - Failed to read the server's allow-frames mode property (is there a problem connecting to the db or reading the db config file?)
java.lang.IllegalStateException: Cannot initialize database object: check database configuration in /core/config
at com.mcafee.orion.core.db.base.Database.init(Database.java:887)
at com.mcafee.orion.core.db.base.Database.<init>(Database.java:432)
at com.mcafee.orion.core.db.base.Database.<init>(Database.java:293)
at com.mcafee.orion.core.db.base.Database.<init>(Database.java:442)
at com.mcafee.orion.core.db.base.Database.<init>(Database.java:471)
at com.mcafee.orion.core.OrionCore.initAllowFramesModeOrFailStartup(OrionCore.java:789)
at com.mcafee.orion.core.OrionCore.init(OrionCore.java:1077)

2021-04-17 13:50:35,353 WARN [localhost-startStop-1] spring.SpringResourcePreprocessor - XML file provides no validation information. Adding default namespace to <beans> element.
2021-04-17 13:50:36,539 ERROR [localhost-startStop-1] core.OrionCore - Unable to determine whether server is in multi-tenant mode. Assuming false.
java.lang.IllegalStateException: Cannot initialize database object: check database configuration in /core/config
at com.mcafee.orion.core.db.base.Database.init(Database.java:887)
at com.mcafee.orion.core.db.base.Database.<init>(Database.java:432)
at com.mcafee.orion.core.db.base.Database.<init>(Database.java:293)

at java.lang.Thread.run(Thread.java:748)
2021-04-17 13:50:36,727 ERROR [localhost-startStop-1] servlet.OrionPluginContextListener - MFS Context "Orion Server" exception: Error creating bean with name 'core.pluginManager' defined in resource loaded from byte array: Cannot resolve reference to bean 'core.EventDispatchService' while setting bean property 'eventService'; nested exception is

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'core.EventDispatchService' defined in resource loaded from byte array: Cannot resolve reference to bean 'core.EventDispatchService.cluster' while setting bean property 'services' with key [1]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'core.EventDispatchService.cluster' defined in resource loaded from byte array: Cannot resolve reference to bean 'core.cluster' while setting bean property 'cluster'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'core.cluster.factory' defined in resource loaded from byte array: Cannot resolve reference to bean 'core.db' while setting bean property 'db'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'core.db' defined in resource loaded from byte array: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.mcafee.orion.core.db.base.MfsDatabase]: Constructor threw exception; nested exception is java.lang.IllegalStateException: Cannot initialize database object: check database configuration in /core/config

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'core.pluginManager' defined in resource loaded from byte array: Cannot resolve reference to bean 'core.EventDispatchService' while setting bean property 'eventService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'core.EventDispatchService' defined in resource loaded from byte array: Cannot resolve reference to bean 'core.EventDispatchService.cluster' while setting bean property 'services' with key [1]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'core.EventDispatchService.cluster' defined in resource loaded from byte array: Cannot resolve reference to bean 'core.cluster' while setting bean property 'cluster'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'core.cluster.factory' defined in resource loaded from byte array: Cannot resolve reference to bean 'core.db' while setting bean property 'db'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'core.db' defined in resource loaded from byte array: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.mcafee.orion.core.db.base.MfsDatabase]: Constructor threw exception; nested exception is java.lang.IllegalStateException: Cannot initialize database object: check database configuration in /core/config.

原因

The OrionConfiguration table is missing from the ePO database, where this table contains the Schema Version with AUtoID.

Example of the working table:

AutoId SchemaVersion
1 182

To confirm that the table is missing or contains invalid content, run the following SQL script:

Select * from orionconfiguration

If the table is missing, you see the results below.

Invalid Object name 'orionconfiguration'

解决方案

Restore the ePO database from a known good full backup. See the related article below for details:

KB52126 - How to back up and restore the ePolicy Orchestrator database using SQL Server Management Studio

受影响的产品

ePolicy Orchestrator 5.10.x

语言:

此文章有以下语言版本：

English United States
Spanish Spain
French
Italian
Japanese
Portuguese Brasileiro
Chinese Simplified

技术术语词汇表

突出显示词汇表术语

请花点时间浏览一下我们的技术术语词汇表。

Knowledge Center

Unable to log on to the ePO console (Invalid object name 'orionconfiguration')

环境

问题

原因

解决方案

受影响的产品

语言:

技术术语词汇表

Title

Title

Knowledge Center

Unable to log on to the ePO console (Invalid object name 'orionconfiguration')

环境

问题

原因

解决方案

受影响的产品

语言:

技术术语词汇表

选择您的区域

Title

Title