Troubleshooting Informatica Error Messages and Resolution – Part 390

SQLServerF1_Header_Small

TM_6796Error: Failed to expand owner name <name> for transformation <transformation name>.
Cause:The Integration Service cannot expand a parameter or variable in the table owner name or table name prefix.
Action:Verify that the parameter or variable is defined properly in the parameter file and that its value in the parameter file matches the parameter or variable datatype. For example, you cannot set an integer mapping variable to a text string in the parameter file.
or
Cause:The Integration Service cannot expand a parameter or variable in the table owner name or table name prefix due to an internal error.
Action:Contact Informatica Technical Support.

TM_6797Error: Failed to expand environment SQL <text> for connection <name>.
Cause:The Integration Service cannot expand a parameter or variable in the environment SQL.
Action:Verify that the parameter or variable is defined properly in the parameter file and that its value in the parameter file matches the parameter or variable datatype. For example, you cannot set an integer mapping variable to a text string in the parameter file.
or
Cause:The Integration Service cannot expand a parameter or variable in the environment SQL due to an internal error.
Action:Contact Informatica Technical Support.
TM_6798Error: Failed to expand table name prefix <prefix> for error log.
Cause:The Integration Service cannot expand a parameter or variable in the table name prefix for relational error logs.
Action:Verify that the parameter or variable is defined properly in the parameter file and that its value in the parameter file matches the parameter or variable datatype. For example, you cannot set an integer mapping variable to a text string in the parameter file.
or
Cause:The Integration Service cannot expand a parameter or variable in the table name prefix for relational error logs due to an internal error.
Action:Contact Informatica Technical Support.

TM_6828An error was encountered while trying to save statistical information to the repository.
Cause:There was an error saving statistics to the repository. For example, the database connection may be broken.
Action:Errors are sent to the Repository Service log. Review the Repository Service log for more information about the error.

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 *