Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

EDC Profile run fails with Profile Warehouseconnection error: "Error connecting to database...
WRT_8001 EDC_PROREP DB Error -1 523 630 Database driver error"
Problem Description
When executing EDC profile run using native Data Integration Service, all the individual profile jobs fails with the following error:

ErrorMessage: (java.util.concurrent.ExecutionException: com.informatica.sdk.dtm.ExecutionException: [LDTM_0072] WRT_8001 Error connecting to database...  [ DB Error -1 523 630 Database driver error... Function Name : Connect Database driver error... 
Function Name : Connect Database Error: Failed to connect to database using user [username_used_In_profiling_warehouse_connection] and connection string [profiling_warehouse_connection].] )
Cause
This error occurs because the profiling warehouse connection which is an ODBC connection is not successful. The test connection from the administrator console may go through successfully as this test connection happens using the JDBC type.
However, Data Integration Service connects to the profiling warehouse connection using ODBC connection. 

The issue occurs if this ODBC connection has "use DSN" option set to false.
Solution
To resolve this issue, do the following:
  1. Edit the profiling warehouse DB connection with the ODBC provider type and set the "use DSN" option to TRUE. 
  2. Then, make sure that the connect string provided in this connection is part of the entry of the odbc.ini file. 
  3. Make sure that $ODBC_HOME and $ODBCINI environment variables are set accurately.
  4. Rerun the profiling.
More Information
Applies To
Product: Enterprise Data Catalog
Problem Type: Configuration
User Type: Administrator; Developer
Project Phase: Configure
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:10/7/2019 2:07 AMID:579663
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)