Error in connecting BPC10 with SSM10 via FIM

[Former Member]

Hi All ,

we are trying to move data from BPC 10 to SSM 10 via FIM 10. The data stores were created successfully but the job creation is failing with the following error.

com.sap.fpm.fim.common.webservice.WSException: Error during the action: 'Add job-user entries' - while executing an SQL statement against the 'FIM_JOB_TO_USER' table.

org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO "FIM_JOB_TO_USER" ("job_name", "user_name") VALUES (?, ?)]; Violation of PRIMARY KEY constraint 'FIM_JOB_TO_USERK'. Cannot insert duplicate key in object 'dbo.FIM_JOB_TO_USER'. The duplicate key value is (test2, VIJAY).; nested exception is java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'FIM_JOB_TO_USERK'. Cannot insert duplicate key in object 'dbo.FIM_JOB_TO_USER'. The duplicate key value is (test2, VIJAY).

I feel that the issue lies with the FIM_JOB_TO_USER table . How can this be rectified ? if not , what is the solution to this issue ?

Thanks

Vijay

[Former Member]

I'm facing the same error as well but from ECC to Intercompany.

Is anyone able to assist?