In the last months I have been working for a customer with a huge ETL logic built with Informatica Power Center.

Many times I had to import/export the repository in different environments and I faced the following issue at least once: after an import action I have found a duplicated Integration Service entry. One Integration Service was working and the other one was invalid.

Googling around for the solution, I have found useful the following information.

As first action, try to truncate the  repository log files by running the following command:

pmrep truncatelog -t all

If this doesn’t fix the problem, follow these steps:

1. Check the OPB_SERVER_INFO Informatica repository database schema table for any duplicated rows. If any, execute the following sql command:

DELETE FROM OPB_SERVER_INFO WHERE SERVER_ID = [ID];
COMMIT;

Where [ID] identifies the old Integration Service that has been duplicated.

2. In Workflow Manager, right click on the invalid Integration Service and then delete.

3. Restart the Informatica services.