Troubleshooting Informatica Error Messages and Resolution – Part 114

SQLServerF1

DP_90001Invalid target type. Profile mapping targets should either be relational or null.
Cause:The profile mapping contains target definitions that are not relational or null. The targets in the profile mapping might have been modified.
Action:Recreate the profile.
DP_90002All the targets in a profiling mapping should use the same connection and have the same connection attributes.
Cause:There are two or more relational database connections configured for targets in the profile mapping.
Action:Make sure you use the same relational database connection for all targets in a profiling mapping.

DP_90003Create server database connection failed.
Cause:The database driver might not be set up correctly.
Action:Check the database driver configuration.
DP_90004Connection to the database using user <user name>, connect string <database connect string> failed. Reason: <error message>.
Cause:The user name or connect string is invalid.
Action:Verify that the user name and connect string values are valid.
or
Action:See the additional error message for more information.
DP_90005Cannot find the profile object for this mapping.
Cause:You ran a session with a copied or deployed mapping that contains reusable domains. You cannot run a session with a copied or deployed profile mapping that contains reusable domains.
Action:Run a profile session with the original profile mapping.

DP_90007Profile metadata deserialization failed with error <error message>.
Cause:The Data Profiling Client or Integration Service installation might be missing a DTD file. The file may have been moved from the PowerCenter Client or Integration Service installation directory.
Action:If the PowerCenter Client or Integration Service installation directory does not contain the DTD file, reinstall the Integration Service or Client. If the problem persists, contact Informatica Technical Support.
or
Cause:The DTD file does not have read permission.
Action:Verify that you have read permission on the DTD file

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 *