Informatica – PowerCenter Express – Error – SEVERE: com.informatica.sdk.dtm.ExecutionException: [LDTM_0072] RR_4036 Error connecting to database

Background

Trying to play around with Informatica Power Center Express on a new box and ran into the error pasted below.

What were we trying to do?

Basically all we were trying to do is review data on a Data Source.

To do so, one will create a project add a data source and access Run \ Ran Data Viewer via the menu.

 

Diagnostic

Server Log

We know that that Job is ran on the server.  And, so we connected to the Administrator Portal via http://localhost:7009/administrator/#monitoring

And, from the left panel, via the Navigator accessed Domain_locahost/DIS/Jobs.

Monitoring \ Domain \ DIS \ Jobs

Domain-DIS-Jobs

Here is what our Jobs log look like:

Monitoring

Monitoring

Unfortunately, it is not possible to copy the actual text of the error message.

 

Server Logs

As it was not possible to capture the text, went googling to determine where the logs are actually kept.

<INFA_HOME> \tomcat\bin\disLogs\ms

Found Help here:

  1. Is anyone using PowerCenter Express on Windows 8?
    https://network.informatica.com/thread/18946

 

Rakshith Jain provided excellent support

IsAnyoneUsingPowerCenterExpressOnWindows8

as he directed us to INFA_HOME\tomcat\bin\dislogs\ms

Folder Structure

FolderStructure

Error

Opening the most current file from INFA_HOME\tomcat\bin\dislogs\ms revealed the error pasted below.

Image

RR_4036-ErrorConnectingToDatabase

Text


2016-03-15 12:20:15 &lt;DTMLoggerThread_6&gt; INFO: DIRECTOR,	TM_6020,	Session [Test_TestTriggers] completed at [Tue Mar 15 12:20:15 2016].
2016-03-15 12:20:15 &lt;DTM-pool-3-thread-5&gt; SEVERE: RR_4036 Error connecting to database [
Error: Failed to create and initialize SQL OLE DB instance. Reason [1008]: [An attempt was made to reference a token that does not exist.
]
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [dbscript] and connection string [].].
2016-03-15 12:20:15 &lt;DTM-pool-3-thread-5&gt; SEVERE: com.informatica.sdk.dtm.ExecutionException: [LDTM_0072] RR_4036 Error connecting to database [
Error: Failed to create and initialize SQL OLE DB instance. Reason [1008]: [An attempt was made to reference a token that does not exist.
]
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [dbscript] and connection string [].].
2016-03-15 12:20:15 &lt;DTM-pool-3-thread-5&gt; INFO: Total LDTM Execution Time: 3,883ms

 

Internet

With a copyable error message went googling and found matches:

  1. ERROR: “Error: Failed to create and initialize SQL OLE DB instance. Reason [1008]: [An attempt was made to reference a token that does not exist” while running a preview on data or running a profile job using a Microsoft SQL Server database connection
    https://kb.informatica.com/solution/23/Pages/_0/160624.aspx?docid=160624&type=external
  2. “ERROR: Failed to create and initialize SQL OLE DB instance” when using Microsoft SQL Server with PowerCenter 9.6
    https://kb.informatica.com/solution/23/Pages/5/159016.aspx?

 

Cause And Solution

Image

CauseAndSolution

Textual

Cause

This issue occurs due to a change in how PowerCenter connects to SQL Server.
Previous versions up to 9.5.1 used the OLEDB mechanism while 9.6 requires the SQL Server Native Client (SNAC).

Solution
SNAC is not part of the default installation of the SQL Server client software and needs to be installed manually.
It is part of the Microsoft SQL Server 2012 Feature Pack, which can be downloaded from the Microsoft website at
http://www.microsoft.com/en-in/download/details.aspx?id=29065

Download

Please follow the link and search for Microsoft® SQL Server® 2012 Native Client.

Download-Details

As we are on a 64-bit platform chose that package.

 

Install Microsoft SQL Server 2012 Native Client ( SNAC )

What SNAC packages are currently installed?

Accessed Programs and Features to determine which Microsoft SQL Server Native Clients are currently installed.

ProgramAndFeatures-Before

We see that the currently installed packages are:

  1. Microsoft SQL Server 2008 Native Client

Installed Microsoft SQL Server 2012 Native Client

Installed the package.

 

What SNAC packages are now installed?

Once the package installed successfully, we now have Microsoft SQL Server 2012 Native Client.

ProgramAndFeatures-After

 

Data Viewer

Let us revisit and see if we can use Data Viewer again.
Same menu items – Run \ Run Data Viewer.

RunDataViewer

 

Output:

DataViewer

 

Applicable

Here is our current version

Informatica Administrator

Version 9.6.1 Hotfix2

Administrator

 

Information Developer For PowerCenter Express

Version 9.6.1 Hotfix2

InformationDeveloperForPowerCenterExpress

 

2 thoughts on “Informatica – PowerCenter Express – Error – SEVERE: com.informatica.sdk.dtm.ExecutionException: [LDTM_0072] RR_4036 Error connecting to database

  1. Very nice article you explained everything in detail manner and neatly very useful and easy to understand also because of images. Thanks for sharing such a nice blog.

    • Thanks Joseph.

      I was very new PowerCenter Express and so I knew I will likely experience a lot of problems and I really felt that I should thread softly and jot down each misstep and remediation path, if I were to find one.

      Thanks for the feedback.

      All the very best,

      Daniel

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s