Troubleshooting Informatica Error Messages and Resolution – Part 117

SQLServerF1_Header_Small

DP_90022 Profile has some invalid functions. Session run failed.
Cause:You tried to run a profile session for a data profile. The data profile contains invalid functions.
Action:Edit the data profile to modify or remove the invalid functions.
DP_90023Warehouse table PMDP_WH_VERSION is missing. The target warehouse version is incorrect. You may need to upgrade the warehouse.
Cause:The version of the Data Profiling warehouse does not match the version of PowerCenter.
Action:Upgrade the Data Profiling warehouse using the upgrade script for the database type.

DP_90024 The target warehouse uses schema version <version> and data version <version>. You may need to upgrade the warehouse.
Cause:The version of the Data Profiling warehouse does not match the version of PowerCenter.
Action:Upgrade the Data Profiling warehouse using the upgrade script for the database type.
DP_90026 Warehouse table PMDP_WH_VERSION is missing or column SCHEMA_VERSION/DATA_VERSION/DATABASE_TYPE is missing. You need to upgrade the warehouse.
Cause:The version of the Data Profiling warehouse does not match the version of PowerCenter.
Action:Upgrade the Data Profiling warehouse using the upgrade script for the database type.

DP_90029Source index of mapping parameter <mapping parameter> is invalid.
Cause:The profile mapping is modified.
Action:Regenerate the profile mapping.
DP_90030Missing mapping parameter(s) for source with index <index>.
Cause:The profile mapping is modified.
Action:Regenerate the profile mapping.
DP_90031 Source Qualifier transformation <transformation> was not found in this mapping.
Cause:The profile mapping is modified.
Action:Regenerate the profile mapping.

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 *