Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Can't edit or add workouts. Getting error message

jameslsmith85
over 4 years ago

I was editing some workouts on the website, was going fine. Then I switched to the app to edit some more because I thought it might be easier, it was. It worked fine initially. I edited about 3 or 4 workouts in the app and then suddenly I got an error saying "Failed to update workout. try again later". I thought wtf, and looked on the website again. On checking the last workout I tried to save it was now empty, so not only had the changed not been saved, Garmin connect has decided to clear everything that was once there out!! I tried to edit the workout on the website but I get the error message "The workout could not be saved because of a system error. Please try again."

Seriously not impressed with this sh#t. Can anyone offer any solutions, or is this standard procedure for Garmin software?

  • 0 over 4 years ago

    Doesn't work for me either.

  • 0 over 4 years ago

    Can't edit, add or duplicate workouts. Neither on web nor phone.

    Error message on web:

    {"message":"PreparedStatementCallback; SQL [INSERT INTO workout_step (\nworkout_step_pk,\nworkout_pk,\nwstep_name,\ndescription,\nstep_order,\nparent_step_pk,\nchild_step_pk,\nstep_type_pk,\nintensity_type_pk,\nend_condition_pk,\nend_condition_value,\nend_condition_unit_pk,\nend_condition_compare,\ntarget_type_pk,\ntarget_value_1,\ntarget_value_1_unit_pk,\ntarget_value_2,\ntarget_value_2_unit_pk,\nzone_number,\nworkout_sport_pk,\npreferred_end_unit_pk,\nend_condition_zone,\nis_smart_repeat,\nworkout_stroke_type_pk,\nworkout_equipment_type_pk,\ncategory,\nexercise_name,\nweight,\nweight_unit_pk,\nsource_id,\npower_curve_duration,\npower_curve_scale,\npower_curve_range,\nsecondary_target_type_pk,\nsecondary_target_value_1,\nsecondary_target_value_1_unit_pk,\nsecondary_target_value_2,\nsecondary_target_value_2_unit_pk,\nsecondary_zone_number,\nsecondary_target_power_curve_duration,\nsecondary_target_power_curve_scale,\nsecondary_target_power_curve_range,\nbenchmark_percentage,\nbenchmark_type_id\n) VALUES (\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?)\n]; Arithmetic overflow error converting expression to data type int.; nested exception is java.sql.BatchUpdateException: Arithmetic overflow error converting expression to data type int.","error":"DataIntegrityViolationException"}

    PS. You shouldn't expose your SQL queries and DB structure in error messages

  • 0 over 4 years ago

    Same here, I've been troubleshooting for 2h now, removing my watch, adding it again, rebooting phone, watch, uninstalling the app... Nothing works so I'll just wait.

  • 0 over 4 years ago in reply to 7074918

    What I can't fathom is why their site support section shows that everything is working as it should be. Do they just not check things, or not care enough to update users with issues.

  • 0 over 4 years ago

    It looks like SW problem (error with inserting to database). 

    Error from console: nested exception is java.sql.BatchUpdateException: Arithmetic overflow error converting expression to data type int.

  • 0 over 4 years ago

    Can't edit, add or duplicate workouts. Neither on web nor phone.

    Error message on web:

    {"message":"PreparedStatementCallback; SQL [INSERT INTO workout_step (\nworkout_step_pk,\nworkout_pk,\nwstep_name,\ndescription,\nstep_order,\nparent_step_pk,\nchild_step_pk,\nstep_type_pk,\nintensity_type_pk,\nend_condition_pk,\nend_condition_value,\nend_condition_unit_pk,\nend_condition_compare,\ntarget_type_pk,\ntarget_value_1,\ntarget_value_1_unit_pk,\ntarget_value_2,\ntarget_value_2_unit_pk,\nzone_number,\nworkout_sport_pk,\npreferred_end_unit_pk,\nend_condition_zone,\nis_smart_repeat,\nworkout_stroke_type_pk,\nworkout_equipment_type_pk,\ncategory,\nexercise_name,\nweight,\nweight_unit_pk,\nsource_id,\npower_curve_duration,\npower_curve_scale,\npower_curve_range,\nsecondary_target_type_pk,\nsecondary_target_value_1,\nsecondary_target_value_1_unit_pk,\nsecondary_target_value_2,\nsecondary_target_value_2_unit_pk,\nsecondary_zone_number,\nsecondary_target_power_curve_duration,\nsecondary_target_power_curve_scale,\nsecondary_target_power_curve_range,\nbenchmark_percentage,\nbenchmark_type_id\n) VALUES (\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?,\n?,?,?,?)\n]; Arithmetic overflow error converting expression to data type int.; nested exception is java.sql.BatchUpdateException: Arithmetic overflow error converting expression to data type int.","error":"DataIntegrityViolationException"}

    PS. You shouldn't expose your SQL queries and DB structure in error messages

  • 0 over 4 years ago in reply to 3018102 

    message: "PreparedStatementCallback; SQL [INSERT INTO workout_step (↵workout_step_pk,↵workout_pk,↵wstep_name,↵description,↵step_order,↵parent_step_pk,↵child_step_pk,↵step_type_pk,↵intensity_type_pk,↵end_condition_pk,↵end_condition_value,↵end_condition_unit_pk,↵end_condition_compare,↵target_type_pk,↵target_value_1,↵target_value_1_unit_pk,↵target_value_2,↵target_value_2_unit_pk,↵zone_number,↵workout_sport_pk,↵preferred_end_unit_pk,↵end_condition_zone,↵is_smart_repeat,↵workout_stroke_type_pk,↵workout_equipment_type_pk,↵category,↵exercise_name,↵weight,↵weight_unit_pk,↵source_id,↵power_curve_duration,↵power_curve_scale,↵power_curve_range,↵secondary_target_type_pk,↵secondary_target_value_1,↵secondary_target_value_1_unit_pk,↵secondary_target_value_2,↵secondary_target_value_2_unit_pk,↵secondary_zone_number,↵secondary_target_power_curve_duration,↵secondary_target_power_curve_scale,↵secondary_target_power_curve_range,↵benchmark_percentage,↵benchmark_type_id↵) VALUES (↵?,?,?,?,↵?,?,?,?,↵?,?,?,?,↵?,?,?,?,↵?,?,?,?,↵?,?,?,?,↵?,?,?,?,↵?,?,?,?,↵?,?,?,?,↵?,?,?,?,↵?,?,?,?)↵]; Arithmetic overflow error converting expression to data type int.; nested exception is java.sql.BatchUpdateException: Arithmetic overflow error converting expression to data type int."

  • 0 over 4 years ago in reply to 3018102

    Same here. Tried reinstalling the app before checking the online site to see if that helped... Obviously it didn't.

    Arithmetic overflow error covering expression to int