Troubleshooting Informatica Error Messages and Resolution – Part 115

SQLServerF1

DP_90008Commit to the database failed with error <database error>.
Cause:A database error prevents the Integration Service from loading data into Data Profiling warehouse tables.
Action:Fix the database error indicated in the message and run the session again. If Data Profiling warehouse tables are incomplete, recreate the Data Profiling warehouse.

DP_90009 SQL Prepare failed for statement <SQL statement> with error <database error>.
Cause:The SQL query failed.
Action:Fix the database error indicated in the message, and rerun the Data Profiling warehouse script in the Data Profiling installation directory. Commit the SQL script after you run it.
DP_90010SQL Bind failed for statement <SQL statement> with error <database error>.
Cause:The Data Profiling warehouse tables are invalid.
Action:Rerun the Data Profiling warehouse script in the Data Profiling installation directory. Commit the SQL script after you run it.
DP_90011SQL Execute failed for statement <SQL statement> with error <database error>.
Cause:The Data Profiling warehouse tables are invalid.
Action:Rerun the Data Profiling warehouse script in the Data Profiling installation directory. Commit the SQL script after you run it.

DP_90012SQL Fetch failed for statement <SQL statement> with error <database error>.
Cause:The Data Profiling warehouse tables are invalid.
Action:Rerun the Data Profiling warehouse script in the Data Profiling installation directory. Commit the SQL script after you run it.
DP_90013Fetching the key for type <key number> failed.
Cause:A Data Profiling warehouse table is missing surrogate keys. The following surrogate keys correspond to these key types in error messages:
−0 – Profile run key
−1 – Column key
−2 – Source function key
−3 – Column function key
−4 – Referential Integrity Analysis function key
−5 – Join Complexity Evaluation function key
Action:Rerun the Data Profiling warehouse script in the Data Profiling installation directory. Commit the SQL script after you run it.
or
Cause:You attempted to run an existing profile session in an upgraded PowerCenter repository against a new Data Profiling warehouse.
Action:Regenerate the profile mapping and run the profile session again.

Above are list of Informatica Error Messages or Warnings received while performing certain operation against Informatica related products.

What are Informatica Error Messages?

Informatica error codes are a set of error codes for use by all Informatica products. Every Informatica error message returned by Informatica, is self explanatory and contains the object name in cases where required.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Informatica Error Code Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *