Hi All,
I am getting the below after creating partition table by range wise while inserting job
Exception in component tDBOutput_8 (I120_core_contact_session_history)
java.sql.SQLException: Batch entry 0 INSERT INTO "core"."contact_transaction_history" ("contact_transaction_id","mdm_contact_id","contact_id","opportunity_id","legacy_crm_id","idp_id","activity_datetime","unique_reference_number","utm_campaign_text","utm_content_text","utm_mdm_text","utm_referenced_text","utm_source_text","utm_trm_text","registration_verification_datetime","arrival_date","departure_date","priority_code","purchasing_budget","file_upload_url","source_description","transaction_status_id","registration_method_id","edition_id","source_system_id","email_address","hash_email_address","record_insert_datetime","record_insert_by","record_update_datetime","record_update_by","source_create_datetime","source_update_datetime","websiteurl","customfield1","customfield2","customfield3","customfield4","customfield5","probability","hotel_booking","crm_contact_type_id") VALUES (38407428,'7212a1f9-fe5a-4245-bfba-47a3fab3ccb0',111037164,'0067A000009sUunQAE',NULL,NULL,'2021-03-09 11:27:21+00'::timestamp,'','','','','','','',NULL,NULL,NULL,'','','','',14324,NULL,3374,31,'haribhajan.saini@xxxxxxxxxxx','1f1076a54571e0b5afb2829309ed7ced','2021-03-09 11:27:24+00'::timestamp,'MULE','2021-03-10 15:17:05+00'::timestamp,'MULE','2021-03-09 11:27:23+00'::timestamp,'2021-03-09 11:27:23+00'::timestamp,'','','','','','','',NULL,14438) was aborted: ERROR: duplicate key value violates unique constraint "contact_transaction_history_2_contact_transaction_id_recor_key4" Call getNextException to see other errors in the batch.
caused by: ERROR: duplicate key value violates unique constraint "contact_transaction_history_2_contact_transaction_id_recor_key4"
at touchstone.i120_core_contact_session_history_0_8.I120_core_contact_session_history$1tAsyncIn_tDBOutput_8_ParallelThread.run(I120_core_contact_session_history.java:40806)
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "contact_transaction_history_2_contact_transaction_id_recor_key4"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:481)
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:840)
at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1538)
caused by: ERROR: duplicate key value violates unique constraint "contact_transaction_history_2_contact_transaction_id_recor_key4"
at touchstone.i120_core_contact_session_history_0_8.I120_core_contact_session_history$1tAsyncIn_tDBOutput_8_ParallelThread.run(I120_core_contact_session_history.java:40806)
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "contact_transaction_history_2_contact_transaction_id_recor_key4"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:481)
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:840)
at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1538)
at touchstone.i120_core_contact_session_history_0_8.I120_core_contact_session_history$1tAsyncIn_tDBOutput_8_ParallelThread.run(I120_core_contact_session_history.java:40792)
