OEMM Could Not Import Teredata Metadata With '[MBI_JDBC4_E0014] The JDBC Driver Could Not Be Loaded' (Doc ID 2118955.1)

Last updated on MARCH 28, 2016

Applies to:

Oracle Enterprise Metadata Management - Version 12.1.3 to 12.1.3
Information in this document applies to any platform.

Symptoms

OEMM fails to import Teredata Metadata with the following errors:

When testing the OEMM Teradata Bridge connection:

Connection test failed.
Information [2016-03-08 15:22:33] MIMB process ID=27592
Information [2016-03-08 15:22:33] System Hardware: Intel64 Family 6 Model 26 Stepping 5, GenuineIntel at 4 CPU(s)/Core(s) with 16373 RAM
Information [2016-03-08 15:22:33] System Software: Windows Server 2008 R2 6.1 amd64 on habo_etl_test with Office:
Information [2016-03-08 15:22:33] System encoding: GBK
Information [2016-03-08 15:22:33] Using OEM license MIR_WEB
Information [2016-03-08 15:22:33] Import tool: Teradata Teradata Database 12.x to 15.x (http://www.teradata.com/t/page/44083/index/html)
Information [2016-03-08 15:22:33] Import interface: [Database] Data Store (Physical Data Model, Stored Procedure Expression Parsing) via JDBC API from JdbcTeradata <2016-03-08 07:22:33>
Information [2016-03-08 15:22:33] Import bridge: 'JdbcTeradata' MIRJdbc4: 9.0.1 - 2016-01-12 15:36:01
Information [2016-03-08 15:22:33] Driver location =
Information [2016-03-08 15:22:33] Host = 11.22.333.888
Information [2016-03-08 15:22:33] User = PU_DBC_VIEW
Information [2016-03-08 15:22:33] Password = ******
Information [2016-03-08 15:22:33] Schema =
Information [2016-03-08 15:22:33] Stored procedure details = Signature
Information [2016-03-08 15:22:33] Import indexes = False
Information [2016-03-08 15:22:33] Miscellaneous =
Information [2016-03-08 15:22:33] Testing bridge...
Information [2016-03-08 15:22:33] Loading jar files from 'D:\OracleMetadataManagement\java\Jdbc\teradata'
Information [2016-03-08 15:22:34] Started Java Oracle Corporation version 1.8.0_66-b17 in 'D:\OracleMetadataManagement\jre' using 1820 MB RAM. Custom options: -Xms256m, -Xmx2048m
Information [2016-03-08 15:22:34] MITI component(s) with build version '9.0.1 - 2015-12-18': MIRBridgeConstants.jar
Information [2016-03-08 15:22:34] MITI component(s) with build version '9.0.1 - 2016-01-12': MIRJdbc4.jar
Information [2016-03-08 15:22:34] MITI component(s) with build version '9.0.1 - 2016-01-14': MIRModelBridge.jar, MIR.jar, MIRUtil.jar, MIRExpressionLib.jar, MIREtlBridgeLib.jar
Information [2016-03-08 15:22:34] Testing the database connection
Error [2016-03-08 15:22:34] [MBI_JDBC4_E0014] The JDBC driver could not be loaded. Please see the bridge information.
Error [2016-03-08 15:22:34] [JBDG_F0006] The java process did not complete successfully
Information [2016-03-08 15:22:34] MITI component(s) with build version '9.0.1 - 2016-01-14': Mimb.jar, MIRModelConverter.jar, MIRModelBridge.jar, MIRUtil.jar, MIR.jar
Information [2016-03-08 15:22:34] MITI component(s) with build version '9.0.1 - 2016-01-14': MIRUtil.jar, MIR.jar, MIRModelBridge.jar, ConfigServiceProvider.jar, FileAccessServiceProvider.jar, FileBrowseServiceProvider.jar, LicenseServiceProvider.jar, LogServiceProvider.jar, MimbServiceProvider.jar

 

Trying to import via the Teradata Bridge, the OEMM fails with the following errors:

[88/Import model version] 2016-03-09 13:18:15 OPERI_S0002 Started operation: Import model version

[88/Import model version] 2016-03-09 13:18:15 OPER_I0077 Integration server URL: [-1,6] Default Server [IntegrationServer]

[88/] 2016-03-09 13:18:16 MIMB_I0064 MIMB process ID=15068

[88/] 2016-03-09 13:18:16 MIMB_I0032 System Hardware: Intel64 Family 6 Model 26 Stepping 5, GenuineIntel at 4 CPU(s)/Core(s) with 16373 RAM

[88/] 2016-03-09 13:18:16 MIMB_I0033 System Software: Windows Server 2008 R2 6.1 amd64 on habo_etl_test with Office:

[88/] 2016-03-09 13:18:16 MIMB_I0058 System encoding: GBK

[88/] 2016-03-09 13:18:16 MIMB_I0066 Using OEM license MIR_WEB

[88/] 2016-03-09 13:18:16 MIMB_I0028 Import bridge: 'JdbcTeradata'

[88/] 2016-03-09 13:18:16 MIMB_I0030 Export bridge: 'MetaIntegrationMultiModelXml'

[88/] 2016-03-09 13:18:16 MIMB_I0027 Import tool: Teradata Teradata Database 12.x to 15.x (http://www.teradata.com/t/page/44083/index/html)

[88/] 2016-03-09 13:18:16 MIMB_I0013 Import interface: [Database] Data Store (Physical Data Model, Stored Procedure Expression Parsing) via JDBC API from JdbcTeradata <2016-03-09 05:18:16>

[88/] 2016-03-09 13:18:16 MIMB_I0028 Import bridge: 'JdbcTeradata' MIRJdbc4: 9.0.1 - 2016-01-12 15:36:01

[88/] 2016-03-09 13:18:16 MIMB_I0031 Driver location =

[88/] 2016-03-09 13:18:16 MIMB_I0031 Host = 11.22.333.888

[88/] 2016-03-09 13:18:16 MIMB_I0031 User = PU_DBC_VIEW

[88/] 2016-03-09 13:18:16 MIMB_I0031 Password = ******

[88/] 2016-03-09 13:18:16 MIMB_I0031 Schema = DBC

[88/] 2016-03-09 13:18:16 MIMB_I0031 Stored procedure details = Signature

[88/] 2016-03-09 13:18:16 MIMB_I0031 Import indexes = False

[88/] 2016-03-09 13:18:16 MIMB_I0031 Miscellaneous =

[88/] 2016-03-09 13:18:16 MIMB_I0074 Running bridge...

[88/] 2016-03-09 13:18:16 BLIB_S0139 Loading jar files from 'D:\OracleMetadataManagement\java\Jdbc\teradata'

[88/] 2016-03-09 13:18:17 MBCM_I0036 Started Java Oracle Corporation version 1.8.0_66-b17 in 'D:\OracleMetadataManagement\jre' using 1820 MB RAM. Custom options: -Xms256m, -Xmx2048m

[88/] 2016-03-09 13:18:17 BLIB_I0118 MITI component(s) with build version '9.0.1 - 2015-12-18': MIRBridgeConstants.jar

[88/] 2016-03-09 13:18:17 BLIB_I0118 MITI component(s) with build version '9.0.1 - 2016-01-12': MIRJdbc4.jar

[88/] 2016-03-09 13:18:17 BLIB_I0118 MITI component(s) with build version '9.0.1 - 2016-01-14': MIRModelBridge.jar, MIR.jar, MIRUtil.jar, MIRExpressionLib.jar, MIREtlBridgeLib.jar

[88/] 2016-03-09 13:18:19 MBI_JDBC4_I0235 Loaded JDBC driver 'com.teradata.jdbc.TeraDriver'. Version: '14.00.00.04' (major:14 minor:0)

[88/] 2016-03-09 13:18:20 MBCM_F0029 SELECT TRIM(DatabaseName), CommentString FROM dbc.DatabasesV WHERE TRIM(DatabaseName) IN (SELECT DISTINCT d.DatabaseName FROM DBC.TVM m INNER JOIN dbc.dbase d ON(m.DatabaseId=d.DatabaseId)) AND (DatabaseName IN('DBC'))
MITI.MIRException: SELECT TRIM(DatabaseName), CommentString FROM dbc.DatabasesV WHERE TRIM(DatabaseName) IN (SELECT DISTINCT d.DatabaseName FROM DBC.TVM m INNER JOIN dbc.dbase d ON(m.DatabaseId=d.DatabaseId)) AND (DatabaseName IN('DBC'))
at MITI.bridges.jdbc4.Import.database.DatabaseImporter.handleLoadingDbObjectException(DatabaseImporter.java:787)
at MITI.bridges.jdbc4.Import.database.DatabaseImporter.getSchemaNames(DatabaseImporter.java:213)
at MITI.bridges.jdbc4.Import.database.ImportBridge.validateSchemaOption(ImportBridge.java:162)
at MITI.bridges.jdbc4.Import.database.ImportBridge.loadMetadata(ImportBridge.java:111)
at MITI.bridges.jdbc4.Import.database.ImportBridge.run(ImportBridge.java:96)
at MITI.bridges.javabridge.JavaBridge.runImport(JavaBridge.java:103)
at MITI.bridges.javabridge.JavaBridge.main(JavaBridge.java:480)
Caused by: MITI.MIRException: SELECT TRIM(DatabaseName), CommentString FROM dbc.DatabasesV WHERE TRIM(DatabaseName) IN (SELECT DISTINCT d.DatabaseName FROM DBC.TVM m INNER JOIN dbc.dbase d ON(m.DatabaseId=d.DatabaseId)) AND (DatabaseName IN('DBC'))
at MITI.bridges.jdbc4.Import.database.DatabaseImporter.prepareLoadDbObjectsException(DatabaseImporter.java:934)
at MITI.bridges.jdbc4.Import.database.teradata.TeradataDatabaseImporter.loadSchemas(TeradataDatabaseImporter.java:161)
at MITI.bridges.jdbc4.Import.database.DatabaseImporter.getSchemaNames(DatabaseImporter.java:211)
... 5 more
Caused by: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.00.00.04] [Error 5315] [SQLState HY000] The user does not have SELECT access to DBC.TVM.DatabaseId.
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:307)
at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:102)
at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:298)
at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:179)
at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:120)
at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:111)
at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:372)
at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:314)
at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:302)
at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1072)
at MITI.bridges.jdbc4.Import.database.teradata.TeradataDatabaseImporter.loadSchemas(TeradataDatabaseImporter.java:149)
... 6 more

[88/] 2016-03-09 13:18:20 MIMB_E0042 [JBDG_F0006] The java process did not complete successfully
MITI.MIRException: [JBDG_F0006] The java process did not complete successfully
at MITI.bridges.javabridgeinterface.JavaBridgeExec.exec(JavaBridgeExec.java:464)
at MITI.bridges.javabridgeinterface.JavaBridgeExec.javaImport(JavaBridgeExec.java:120)
at MITI.bridges.jdbc4.Import.database.teradata.TeradataImportBridgeInterface.run(TeradataImportBridgeInterface.java:66)
at MITI.mimb.executable.actions.ImportAction.run(ImportAction.java:241)
at MITI.mimb.executable.MimbExecutable.executeRequest(MimbExecutable.java:585)
at MITI.mimb.executable.MimbExecutable.executeRequest(MimbExecutable.java:510)
at MITI.mimb.executable.MimbExecutable.executeRequest(MimbExecutable.java:491)
at MITI.providers.mimb.MimbExecutionThread.run(MimbExecutionThread.java:178)

[88/] 2016-03-09 13:18:21 BLIB_I0118 MITI component(s) with build version '9.0.1 - 2016-01-14': Mimb.jar, MIRModelConverter.jar, MIRModelBridge.jar, MIRUtil.jar, MIR.jar

[88/] 2016-03-09 13:18:21 BLIB_I0118 MITI component(s) with build version '9.0.1 - 2016-01-14': MIRUtil.jar, MIR.jar, MIRModelBridge.jar, ConfigServiceProvider.jar, FileAccessServiceProvider.jar, FileBrowseServiceProvider.jar, LicenseServiceProvider.jar, LogServiceProvider.jar, MimbServiceProvider.jar

[88/Import model version] 2016-03-09 13:18:21 OPERI_S0003 Operation completed.

 

 

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