SAP Knowledge Base Article - Preview

3022824 - MDS fails to connect to DB. Error 0x80004005/0 or 0x84020007

Symptom

  1. Creating, Unarchiving, Connecting to a repository fails
  2. DBMS connection test in MDM Console fails

The connection from MDM to DBMS using TLS 1.2.

 

  • In the MDS_Log errors similar to these appear:

In OLEDB_DB_Connection::Exec, got RC 0x84020007 , last SQL command was: CREATE TABLE A2i_Catalogs (Catalog_Tag NVARCHAR(128) NOT NULL, MainDB NVARCHAR(128) NOT NULL, OrigDB NVARCHAR(128) NOT NULL, ThumbDB NVARCHAR(128) NOT NULL, VariantDB NVARCHAR(128) NOT NULL, Status INT DEFAULT 0 NOT NULL, Description NVARCHAR(255) NULL)

[...]

ErrorRecord->HResult/NativeErr: 0x80004005/0

Description:
Source/File/Line: Microsoft OLE DB Provider for SQL Server/.\OLEDB_DBConnection.cpp/2440
",MDSAdminServer@CreateRep,OLEDB_DBConnection.cpp,6635,MDSAdminServerCommand_CreateRep,,,server_user,jsgx_gg <MDM [SQL_Server]>,,,

[...]

Description: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

 

  • In MDM Console popup error:

Database command excecution error, an SQL statement could not be executed.

[...]

The client has not yet established a connection with the server.


Read more...

Environment

SAP NetWeaver Master Data Management

Product

SAP NetWeaver Master Data Management 5.5 ; SAP NetWeaver Master Data Management 7.1 ; SAP NetWeaver Master Data Management for catalog management 3.0 ; SAP NetWeaver Master Data Management for catalog management 3.0 for SAP NetWeaver 7.01 ; SAP NetWeaver Master Data Management for catalog management 7.01 ; SAP NetWeaver Master Data Management for catalog management 7.02

Keywords

oracle, ms sql, ase, mssql, sybase, db2, ibm db2 , KBA , MDM-FN-CON , Admin Console , MDM-FN-MDS , Master Data Server , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.