Skip to Content
0
Former Member
Jan 08, 2014 at 02:10 PM

Error in connecting BPC10 with SSM10 via FIM

38 Views

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