Troubleshooting Informatica Error Messages and Resolution – Part 383

SQLServerF1

TM_6317Error: <database error message> in creating recovery table PM_RECOVERY.
Cause:The user name specified in the target database connection does not have table creation privileges on the target database. As a result, the Integration Service could not create the PM_RECOVERY recovery table.
Action:Grant table creation privileges to the database user name specified in the target database connection.
or
Cause:The Integration Service could not create the PM_RECOVERY recovery table due to a database error.
Action:Check the database error message to determine the cause of the error, and contact the database administrator.

TM_6318Error: <database error message> in preparing to fetch target run id from recovery table PM_RECOVERY.
Cause:The Integration Service could not retrieve information from the PM_RECOVERY recovery table due to a database error.
Action:Check the database error message to determine the cause of the error, and contact the database administrator.
TM_6319Error: <database error message> in fetching target run id from recovery table PM_RECOVERY.
Cause:The user name specified in the target database connection does not have permission to select information from the target database. As a result, the Integration Service could not retrieve information from the PM_RECOVERY recovery table.
Action:Grant select privileges to the user name specified in the target database connection.
or
Cause:The Integration Service could not retrieve information from the PM_RECOVERY recovery table due to a database error.
Action:Check the database error message to determine the cause of the error, and contact the database administrator.

TM_6320Error: <database error message> in inserting a new target run id from recovery table PM_RECOVERY.
Cause:The user name specified in the target database connection does not have permission to insert information into the PM_RECOVERY recovery table. As a result, the Integration Service could not insert information into the table.
Action:Grant the database user name specified in the target database connection permission to insert data into the PM_RECOVERY recovery table.
or
Cause:The Integration Service could not insert information into PM_RECOVERY due to a database error.
Action:Check the database error message for the cause of the error, and contact the database administrator.

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 *