My Oracle Support Banner

OBIA 7.9.6.4: SQL Server Database Connection Issues In Informatica 10.1 (Doc ID 2323216.1)

Last updated on JUNE 01, 2018

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Symptoms

Intermittent SQL Server 2014 database connection timeout issues in Informatica 10.1.
The failure can occur on any workflow that is connecting to SQL Server 2014 Data Warehouse. This works after  restarting the task .

Error:

WRITER_16_*_1> WRT_8147 Writer: Target is database [@XXXX], user [XXXX], bulk mode [OFF]
WRITER_16_*_1> CMN_1761 Timestamp Event: [Tue Sep 26 01:02:51 2017]
WRITER_16_*_1> WRT_8001 Error connecting to database...
WRT_8001 [Session SIL_PositionDimensionHierarchy_Type1AsIsUpdate Username XXXX DB Error -1800 Microsoft SQL Server Native Client 11.0: Login timeout expired
SQL State: HYT00 Native Error: 0

Microsoft SQL Server Native Client 11.0: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
SQL State: 08001 Native Error: 2

Microsoft SQL Server Native Client 11.0: Named Pipes Provider: Could not open a connection to SQL Server [2].
SQL State: 08001 Native Error: 2
State: 1 Severity: 16
SQL Server Message: Named Pipes Provider: Could not open a connection to SQL Server [2].

Database driver error...Function Name : ConnectDatabase Error: Failed to connect to database using user [XXXX] and connection string [XXXX].]

WRITER_16_*_1> CMN_1761 Timestamp Event: [Tue Sep 26 01:02:51 2017]

 

Tried with the Informatica Integration Service Extended Parameter (MSSQLInitTimeout) and increased this to 120 but still get the same issues.

Informatica Version 10.1.0 Build: 364 - Jun 13, 2016 with EBF463828 applied on top.


Changes

 Upgraded Informatica and the SQL server

 From:

Informatica 9.1 connecting to SQL Server 2008 R2

To: Informatica 10.1 against SQL Server 2014

 

Used OLEDB and it is a deprecated connection and hence changed the connection to ODBC for MS SQL Server.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.