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 DECEMBER 11, 2019

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 [<DB>], user [<USER>], bulk mode [OFF]
WRITER_16_*_1> WRT_8001 Error connecting to database...
WRT_8001 [Session SIL_PositionDimensionHierarchy_Type1AsIsUpdate Username <USER> 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.

Microsoft SQL Server Native Client 11.0: Named Pipes Provider: Could not open a connection to SQL Server [2].
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 [<USER>] and connection string [<CONNECTSTRING>].]

 

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




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!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.