Oracle Enterprise Metadata Manager Harvests Fail Without Reporting Any Error

(Doc ID 2392464.1)

Last updated on MAY 02, 2018

Applies to:

Oracle Enterprise Metadata Management - Version 12.2.1.1 and later
Information in this document applies to any platform.

Symptoms

On Oracle Enterprise Metadata Management (OEMM), while harvesting (or importing) from a source, the harvest just fails without reporting any java stack trace that could indicate the underlining error. 

When this occurs, the import log will contain content similar to the following:

[17758/Thread-10] 2018-04-04 14:39:58 BLIB_D0029 Loaded 145238 Synonyms statistic in 184.654.
[17758/Thread-10] 2018-04-04 14:39:58 BLIB_D0029 Loaded 145238 Synonyms statistic in 0.0.
[17758/Thread-10] 2018-04-04 14:39:58 MBI_JDBC4_I0269 Finished loading of 145238 synonyms
[17758/pool-3-thread-1] 2018-04-04 14:41:48 MBI_JDBC4_I0254 Loaded 0 features
[17758/pool-11-thread-1] 2018-04-04 14:41:48 MBI_JDBC4_I0278 Loaded 0 dependencies
[17758/Thread-12] 2018-04-04 14:43:19 BLIB_D0029 Loaded 91238 Dependencies statistic in 383.303.
[17758/Thread-12] 2018-04-04 14:43:19 MBI_JDBC4_I0279 Finished loading of 0 dependencies
[17758/pool-3-thread-1] 2018-04-04 14:46:48 MBI_JDBC4_I0254 Loaded 0 features
[17758/pool-3-thread-1] 2018-04-04 14:51:48 MBI_JDBC4_I0254 Loaded 0 features
[17758/pool-3-thread-1] 2018-04-04 14:56:48 MBI_JDBC4_I0254 Loaded 0 features

Another example of what may be seen in the log when the import finishes without error:

[3007/pool-9-thread-1] 2018-02-25 12:52:57 MBI_JDBC4_I0254 Loaded 219331 features
[3007/pool-2-thread-1] 2018-02-25 12:52:57 MBI_JDBC4_I0258 Loaded 225995 arguments
[3007/pool-2-thread-1] 2018-02-25 12:57:57 MBI_JDBC4_I0258 Loaded 244263 arguments
[3007/pool-9-thread-1] 2018-02-25 12:57:57 MBI_JDBC4_I0254 Loaded 237658 features
[3007/pool-2-thread-1] 2018-02-25 13:02:56 MBI_JDBC4_I0258 Loaded 263009 arguments
[3007/pool-9-thread-1] 2018-02-25 13:02:56 MBI_JDBC4_I0254 Loaded 256704 features
[3007/pool-2-thread-1] 2018-02-25 13:07:56 MBI_JDBC4_I0258 Loaded 282131 arguments
[3007/pool-9-thread-1] 2018-02-25 13:07:56 MBI_JDBC4_I0254 Loaded 275675 features
[3007/pool-2-thread-1] 2018-02-25 13:12:56 MBI_JDBC4_I0258 Loaded 301312 arguments
[3007/pool-9-thread-1] 2018-02-25 13:12:56 MBI_JDBC4_I0254 Loaded 294521 features

 

As a comparison, it is expected for an error import to have some information indicating the reason that the import fails, something like:

[16065/main] 2018-03-29 11:16:36 MBCM_F0029 java.lang.NullPointerException
java.lang.NullPointerException
at MITI.bridges.jdbc4.Import.database.ModelProcessor.createSqlText(ModelProcessor.java:1068)
at MITI.bridges.jdbc4.Import.database.ModelProcessor.importMetadata(ModelProcessor.java:1684)
at MITI.bridges.jdbc4.Import.database.ImportBridge.createModel(ImportBridge.java:133)
at MITI.bridges.jdbc4.Import.database.ImportBridge.run(ImportBridge.java:104)
at MITI.bridges.javabridge.JavaBridge.runImport(JavaBridge.java:101)
at MITI.bridges.javabridge.JavaBridge.main(JavaBridge.java:475)

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms