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

Here is what our Jobs log look like:

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

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

Folder Structure

Error

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

Image

Text

2016-03-15 12:20:15 <DTMLoggerThread_6> INFO: DIRECTOR,	TM_6020,	Session [Test_TestTriggers] completed at [Tue Mar 15 12:20:15 2016].
2016-03-15 12:20:15 <DTM-pool-3-thread-5> 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 <DTM-pool-3-thread-5> 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 <DTM-pool-3-thread-5> 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

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).

Download

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

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.

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.

Data Viewer

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

Output:

Applicable

Here is our current version

Informatica Administrator

Version 9.6.1 Hotfix2

Information Developer For PowerCenter Express

Version 9.6.1 Hotfix2