Error "[MBC_SSRAS_E0020] Failed to initialize SQL Server API" Encountered While Harvesting Using the SQL Server Analysis and Reporting Services (SSAS) Bridge (Doc ID 2301703.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

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

Symptoms

On any version of Oracle Enterprise Metadata Manager (OEMM), the following error may occur while harvesting using the "SQL Server Analysis and Reporting Services (SSAS, SSRS)" bridge:

[18683/Import model version] 2017-06-27 12:06:21 OPERI_S0002 Started operation: Import model version
[18683/Import model version] 2017-06-27 12:06:21 OPER_I0077 Integration server URL: [-1,6] Default Server [IntegrationServer]
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_D0065 Setting the MIMB log level to 6
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_I0064 MIMB process ID=2516
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_I0032 System Hardware: Intel64 Family 6 Model 15 Stepping 1, GenuineIntel at 4 CPU(s)/Core(s) with 32767 RAM
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_I0033 System Software: Windows Server 2012 R2 6.3 amd64 on hostname with Office:
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_I0058 System encoding: windows-1252
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_I0078 Data directory: D:\OEMM\OracleMetadataManagement\tomcat\bin\..\..\data
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_D0056 MIMB is validating request.
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_D0057 MIMB is checking the license.
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_D0073 The hostid is xxxxxxxxxx
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_D0077 The mac address is 00:00:00:00:00:00(VMware?)
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_I0066 Using OEM license MIR_WEB
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_I0028 Import bridge: 'MicrosoftSqlServerRepositoryAs'
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_I0030 Export bridge: 'MetaIntegrationMultiModelXml'
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_D0053 MIMB is ready to execute request.
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 MIMB_D0070 Created temporary directory: 'D:\OEMM\OracleMetadataManagement\tomcat\bin\..\..\data\temp\MicrosoftSqlServerRepositoryAsxxxxxxxxxxxxxxxx'
[18683/[MicrosoftSqlServerRepositoryAsI] 2017-06-27 12:06:23 DBUG_D0001 "D:\OEMM\OracleMetadataManagement\tomcat\bin\..\..\bin\MIMB.exe" "-r" "STDIN" "-y" "D:\OEMM\OracleMetadataManagement\bin\..\data\temp\mimbResponsexxxxxxxxxxxxxxx.xml" "-X" "1"
[18683/] 2017-06-27 12:06:23 MIMB_D0065 Setting the MIMB log level to DEBUG
[18683/] 2017-06-27 12:06:23 MIMB_D0052 MIMB request is parsed.
[18683/] 2017-06-27 12:06:23 MIMB_I0064 MIMB process ID=####
[18683/] 2017-06-27 12:06:23 MIMB_D0056 MIMB is validating request.
[18683/] 2017-06-27 12:06:23 MIMB_D0053 MIMB is ready to execute request.
[18683/] 2017-06-27 12:06:23 MIMB_D0070 Created temporary directory: 'D:\OEMM\OracleMetadataManagement\data\temp\MicrosoftSqlServerRepositoryAsa######'
[18683/] 2017-06-27 12:06:23 MIMB_I0032 System Hardware: Intel(R) Xeon(R) CPU E5-4657L v2 @ 2.40GHz at 2400 MHz with 4095 MB RAM
[18683/] 2017-06-27 12:06:23 MIMB_I0033 System Software: Windows Server 2012 R2 Standard 6.2 x86 on servername with Office: not installed
[18683/] 2017-06-27 12:06:23 MIMB_I0058 System encoding: Western European (windows-1252)
[18683/] 2017-06-27 12:06:23 MIMB_I0027 Import tool: Microsoft SQL Server Analysis Services (SSAS) 9.0 (2005) to 11.0 (2012) (http://msdn2.microsoft.com/en-us/library/ms175609.aspx)
[18683/] 2017-06-27 12:06:23 MIMB_I0013 Import interface: [Business Intelligence] Metadata Repository, Data Store (Physical Data Model, OLAP Dimensional Model, Stored Procedure Expression Parsing), BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Parsing) via AMO.Net API from MicrosoftSqlServerRepositoryAs <2017-06-27 12:06:23>
[18683/] 2017-06-27 12:06:23 MIMB_I0028 Import bridge: 'MicrosoftSqlServerRepositoryAs' 9.0.2 - 2016-05-23 14:39:16
[18683/] 2017-06-27 12:06:23 MIMB_I0031 SQL Server Version = SQL Server 2012 (2012)
[18683/] 2017-06-27 12:06:23 MIMB_I0031 Host = servername
[18683/] 2017-06-27 12:06:23 MIMB_I0031 Database = TEST_INTERNAL
[18683/] 2017-06-27 12:06:23 MIMB_I0074 Running bridge...
[18683/] 2017-06-27 12:06:23 MBC_SSRAS_S0030 Connecting to AS service: hostname
[18683/] 2017-06-27 12:06:23 3 [MBC_SSRAS_E0020] Failed to initialize SQL Server API. Check the chosen version and make sure that SQL Server is properly installed.

 

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