Randomly getting this error

[ajiragroup]

Information about bug

While processing payroll, I created this entry:

Document was still in draft stage. I made correction to End date then I got a error sound. Upon inspecting the browser console, got this error:

XHRPOST
https://erp.example.com/api/method/frappe.desk.form.save.savedocs
[HTTP/1.1 500 INTERNAL SERVER ERROR 436ms]

	
POST
	https://erp.example.com/api/method/frappe.desk.form.save.savedocs
Status
500
INTERNAL SERVER ERROR
VersionHTTP/1.1
Transferred1.26 kB (720 B size)
Referrer Policystrict-origin-when-cross-origin
Request PriorityHighest
DNS ResolutionSystem

======== arguments ======== request.js:484:12
Object { doc: '{"name":"Sal Slip/AB-EMP-00001/00001","owner":"[email protected]","creation":"2024-08-15 17:12:51.810265","modified":"2024-08-15 17:18:20.198118","modified_by":"[email protected]","docstatus":0,"idx":0,"employee":"AB-EMP-00001","employee_name":"Anup Dhungana","department":"Management - AB","designation":"Executive Director","posting_date":"2024-08-15","letter_head":"Some Company Name","status":"Draft","company":"Some Company Name","currency":"NPR","exchange_rate":1,"payroll_frequency":"Monthly","start_date":"2024-07-16","end_date":"2024-08-13","salary_structure":"nossf1","payroll_entry":"HR-PRUN-2024-00001","mode_of_payment":"Bank","salary_slip_based_on_timesheet":0,"deduct_tax_for_unclaimed_employee_benefits":0,"deduct_tax_for_unsubmitted_tax_exemption_proof":0,"total_working_days":29,"unmarked_days":0,"leave_without_pay":0,"absent_days":0,"payment_days":29,"total_working_hours":0,"hour_rate":0,"base_hour_rate":0,"gross_pay":61500,"base_gross_pay":61500,"gross_year_to_date":61500,"base_gross_year_to_date":0,"total_deduction":4996.15462,"base_total_deduction":4996.15462,"net_pay":56503.84538,"base_net_pay":56503.84538,"rounded_total":56504,"base_rounded_total":56504,"year_to_date":56503.84538,"base_year_to_date":0,"month_to_date":56503.84538,"base_month_to_date":0,"total_in_words":"NPR Fifty Six Thousand, Five Hundred And Four only.","base_total_in_words":"NPR Fifty Six Thousand, Five Hundred And Four only.","ctc":799500,"income_from_other_sources":0,"total_earnings":799500,"non_taxable_earnings":0,"standard_tax_exemption_amount":0,"tax_exemption_declaration":0,"deductions_before_tax_calculation":0,"annual_taxable_amount":799500,"income_tax_deducted_till_date":1996.1546153846155,"current_month_income_tax":1996.1546153846155,"future_income_tax_deductions":23953.855384615388,"total_income_tax":25950.010000000002,"doctype":"Salary Slip","leave_details":[],"timesheets":[],"earnings":[{"name":"new-salary-slip-hddkpbrsgc","docstatus":0,"idx":1,"salary_component":"Basic","abbr":"B","amount":61500,"year_to_date":0,"is_recurring_additional_salary":0,"statistical_component":0,"depends_on_payment_days":0,"exempted_from_income_tax":0,"is_tax_applicable":1,"is_flexible_benefit":0,"variable_based_on_taxable_salary":0,"do_not_include_in_total":0,"deduct_full_tax_on_selected_payroll_date":0,"amount_based_on_formula":0,"default_amount":61500,"additional_amount":0,"tax_on_flexible_benefit":0,"tax_on_additional_salary":0,"parent":"Sal Slip/AB-EMP-00001/00001","parentfield":"earnings","parenttype":"Salary Slip","doctype":"Salary Detail","__islocal":1}],"deductions":[{"name":"new-salary-slip-vznikrxipm","docstatus":0,"idx":1,"salary_component":"Salary Retention","abbr":"SR","amount":3000,"year_to_date":0,"is_recurring_additional_salary":0,"statistical_component":0,"depends_on_payment_days":0,"exempted_from_income_tax":0,"is_tax_applicable":0,"is_flexible_benefit":0,"variable_based_on_taxable_salary":0,"do_not_include_in_total":0,"deduct_full_tax_on_selected_payroll_date":0,"amount_based_on_formula":0,"default_amount":3000,"additional_amount":0,"tax_on_flexible_benefit":0,"tax_on_additional_salary":0,"parent":"Sal Slip/AB-EMP-00001/00001","parentfield":"deductions","parenttype":"Salary Slip","doctype":"Salary Detail","__islocal":1},{"name":"new-salary-slip-jmkpkbxrym","docstatus":0,"idx":2,"salary_component":"Income Tax","abbr":"IT","amount":1996.15462,"year_to_date":0,"is_recurring_additional_salary":0,"statistical_component":0,"depends_on_payment_days":0,"exempted_from_income_tax":0,"is_tax_applicable":1,"is_flexible_benefit":0,"variable_based_on_taxable_salary":1,"do_not_include_in_total":0,"deduct_full_tax_on_selected_payroll_date":0,"amount_based_on_formula":0,"default_amount":1996.1546153846155,"additional_amount":0,"tax_on_flexible_benefit":0,"tax_on_additional_salary":0,"parent":"Sal Slip/AB-EMP-00001/00001","parentfield":"deductions","parenttype":"Salary Slip","doctype":"Salary Detail","__islocal":1}],"__unsaved":1,"__onload":{"load_after_mapping":true}}', action: "Save" }
request.js:485:12
======== debug messages ======== request.js:487:11
Error in query:
('SELECT `tabSalary Withholding`.`employee`,`tabSalary Withholding`.`name` `salary_withholding`,`tabSalary Withholding Cycle`.`name` `salary_withholding_cycle` FROM `tabSalary Withholding` JOIN `tabSalary Withholding Cycle` ON `tabSalary Withholding Cycle`.`parent`=`tabSalary Withholding`.`name` WHERE `tabSalary Withholding Cycle`.`from_date`=%(param1)s AND `tabSalary Withholding Cycle`.`to_date`=%(param2)s AND `tabSalary Withholding Cycle`.`docstatus`=1 AND `tabSalary Withholding Cycle`.`is_salary_released`<>1 AND `tabSalary Withholding`.`employee`=%(param3)s', {'param1': '2024-07-16', 'param2': '2024-08-13', 'param3': 'AB-EMP-00001'}) request.js:489:12
======== response ======== request.js:491:11
Object { exc_type: "ProgrammingError" }
request.js:493:11
======== request.js:494:11

I am not able to identify what triggered the error because upon browser refresh and setting the same End date works while setting another date triggers the error again.

Module

Payroll

Version

erpnext 15.29.3
frappe 15.34.1
hrms 15.25.2

Installation method

manual install

Relevant log output / Stack trace / Full Error Message.

No response

Code of Conduct

• I agree to follow this project's Code of Conduct