KB486166: MicroStrategy Enterprise Manager Can't Start When a 'java.lang.NullPointerException' Error Occurs

The following error explains the error that users may encounter when attempting to start the Strategy Enterprise Manager Service after configuring a repository with MySQL database for the first time.

Symptom

When you attempt to start the Strategy Enterprise Manager service after you configure the Enterprise Manager repository with a MySQL database, the service can't be restarted, and the following error message appears:

com.Strategy.maem.exceptions.EMException: javax.management.RuntimeMBeanException:java.lang.NullPointerException        at com.Strategy.maem.remote.EMRemotelmpl.invokeFunction(EMRemoreImpl.java:143)        at com.Strategy.maem.remoteEMRemoteImpl.start(EMRemoteImpl.java:239)        at com.Strategy.maem.emservice.EMServiceLauncher$1.run(Unknown Source)        at java.base/java.lang.Thread.run(Thread.java:829)Caused by: javax.management.RuntimeMBeanException: java.lang.NullPointerException        ...Caused by: java.lang.NullPointerException        at com.Strategy.maem.configuration.XSDConfigurationDelegate.load(Unknown Source)        at com.Strategy.maem.configuration.ConfigurationEM.getDefaultLogging(Unknown Source)        at com.Strategy.maem.emservice.EMService.start(Unknown Source)        ...MSTRExec Error: Exiting with error -1 (0xFFFFFFFF): MExec::ApplicationProxy_Impl::Run: Attempt to 'start' failed with error code -1 (0xFFFFFFFF)

 

Cause

This issue is caused by the MySQl driver ANSI version. Strategy recommends using the Unicode version of MySQL ODBC Driver. For more information and the download link, see https://www.microstrategy.com/en/support/drivers-and-connectors .
The different drivers are identified at the end of the library names using a "w" (for wide characters) for the Unicode driver and an "a" for the ANSI driver. For example,

libmyodbc8w.so

vs.

libmyodbc8a.so

. For more information, see https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation.html .

Action

Install MySQL ODBC driver Unicode version and recreate the DSN for the Enterprise Manager repository

Additional Notes

This issue is not related to the issues discussed in the following Strategy Knowledge Base articles:

• https://community.strategy.com/article/KB317023-MicroStrategy-Enterprise-Manager-10-x-fails-to-start?language=en_US
• https://community.strategy.com/article/KB322824-MicroStrategy-Enterprise-Manager-Dataload-Service-fails
• https://community.strategy.com/article/KB425133-Unable-to-start-Enterprise-Manager-Service-on-MicroStrategy-Secure-Enterprise-10-x?language=en_US