Why am I getting the error "FAILED TRYING TO EXECUTE ON CONNECTION glide.30 (connpid=982133): INSERT INTO task"? when running a transform?

[Mike Grimm]

I am trying to import pm_project records from one instance and insert them into the tsp1_project table of another instance. Whenever I try to run the transform on the Excel file I get this error, "FAILED TRYING TO EXECUTE ON CONNECTION glide.30 (connpid=982133): INSERT INTO task". I've successfully imported records into the tsp1_portfolio, tsp1_program, tsp1_idea, and tsp1_demand tables. Has anyone attempted to do something like this before?

[Maik Skoddow]

Hi Mike,

there are tons of reasons for that error and without more details or having a look on your instance it is impossible to answer that seriously.

Maik

[Mike Grimm]

My apologies, here's the rest of the pertinent information:

FAILED TRYING TO EXECUTE ON CONNECTION glide.30 (connpid=982133): INSERT INTO task (`made_sla`,`assign_to_opened_for`,`name_1`,`upon_reject`,`capital_budget`,`discount_rate`,`chart_field`,`task_effective_number`,`work_effort`,`rollup`,`sla`,`a_ref_33`,`number`,`opened_by`,`u_strategic_initiative`,`acknowledged_on`,`sys_domain`,`recurring_price`,`state`,`a_ref_2`,`knowledge`,`conflict_status`,`work_duration`,`category_1`,`contact_info`,`budget_cost`,`admin_override`,`active`,`priority`,`version`,`a_ref_20`,`opened_at`,`a_bln_1`,`delivery_address`,`npv_value`,`work_end`,`a_bln_4`,`a_num_3`,`u_bundle_request`,`task_percent_complete`,`display_attachments`,`critical_path`,`automated_state_flow`,`category`,`end_date_1`,`direct`,`a_ref_32`,`short_description`,`work_cost`,`work_start`,`a_ref_1`,`time_constraint`,`description`,`effort`,`reject_handling`,`sys_class_name`,`a_str_1`,`u_sensitive`,`duration`,`category_2`,`sys_id`,`contact_type`,`backordered`,`a_ref_31`,`u_number_days_open_category`,`email_address`,`actual_end_date_2`,`reassignment_count`,`actual_travel_duration`,`percent_complete`,`start_date_1`,`assigned_to`,`u_hr_category`,`a_ref_4`,`a_bln_3`,`cost`,`phase`,`approval`,`actual_start_date`,`employee_percent_complete`,`a_num_8`,`estimated_cost`,`percent_complete_1`,`a_ref_5`,`a_flt_1`,`a_str_7`,`a_bln_2`,`auto_request`,`billable`,`escalation`,`upon_approval`,`close_code`) 
Unique Key violation detected by database ((conn=982133) Duplicate entry '8606d8e01ba99990b2132139b04bcb5c' for key 'PRIMARY')
: java.sql.SQLIntegrityConstraintViolationException: (conn=982133) Duplicate entry '8606d8e01ba99990b2132139b04bcb5c' for key 'PRIMARY': org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:229)

I'm not sure how it could be creating duplicate records.

[Yousaf]

Hi Mike,

Please refer to this link and see if this could relate to your problem.

java.sql.SQLIntegrityConstraintViolationException: Duplicate entry 'null' for key 'login.PRIMARY'

Mark Correct or Helpful if it helps.