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