Коллеги, всем доброго времени. Имеется потребность в дополнительном статусе “запрос информации”. Он должен быть аналогичен статусу “решеный” в той части что так же попадает в раздел решенные на пользовательском портале, его так же можно закрыть либо переоткрыть.
Подскажите в каких файлах нужно вносить правки?
внес изменения в файл datamodel.itop-request-mgmt-itil.XML. Этот статус “info” отображается в раскрывающемся меню, можно его выбрать, указать причину. Но далее я получаю ошибку.
Объект не может быть записан: Failed to issue SQL query: query = UPDATE ticket AS UserRequest_ticketLEFT JOIN contact AS Person_caller_id_contact ON UserRequest_ticket.caller_id = Person_caller_id_contact.idLEFT JOIN contact AS Team_team_id_contact ON UserRequest_ticket.team_id = Team_team_id_contact.idLEFT JOIN contact AS Person_agent_id_contact ON UserRequest_ticket.agent_id = Person_agent_id_contact.idINNER JOIN (ticket_request AS UserRequest_ticket_request LEFT JOIN contact AS Person_approver_id_contact ON UserRequest_ticket_request.approver_id = Person_approver_id_contact.idLEFT JOIN ticket AS UserRequest_parent_request_id_ticket ON UserRequest_ticket_request.parent_request_id = UserRequest_parent_request_id_ticket.idLEFT JOIN ticket AS Incident_parent_incident_id_ticket ON UserRequest_ticket_request.parent_incident_id = Incident_parent_incident_id_ticket.idLEFT JOIN ticket AS Problem_parent_problem_id_ticket ON UserRequest_ticket_request.parent_problem_id = Problem_parent_problem_id_ticket.idLEFT JOIN ticket AS Change_parent_change_id_ticket ON UserRequest_ticket_request.parent_change_id = Change_parent_change_id_ticket.id) ON UserRequest_ticket.id = UserRequest_ticket_request.id SET UserRequest_ticket.last_update = ‘2020-03-29 10:18:38’, UserRequest_ticket_request.status = ‘info’, UserRequest_ticket_request.resolution_date = ‘2020-03-29 10:18:38’, UserRequest_ticket_request.time_spent = 2609 WHERE ((((((((((UserRequest_ticket.id = ‘420’) AND COALESCE((Person_caller_id_contact.finalclass IN (‘Person’)), 1)) AND COALESCE((Team_team_id_contact.finalclass IN (‘Team’)), 1)) AND COALESCE((Person_agent_id_contact.finalclass IN (‘Person’)), 1)) AND COALESCE((UserRequest_ticket.finalclass IN (‘UserRequest’)), 1)) AND COALESCE((Person_approver_id_contact.finalclass IN (‘Person’)), 1)) AND COALESCE((UserRequest_parent_request_id_ticket.finalclass IN (‘UserRequest’)), 1)) AND COALESCE((Incident_parent_incident_id_ticket.finalclass IN (‘Incident’)), 1)) AND COALESCE((Problem_parent_problem_id_ticket.finalclass IN (‘Problem’)), 1)) AND COALESCE((Change_parent_change_id_ticket.finalclass IN (‘Change’)), 1)), mysql_errno = 1265, mysql_error = Data truncated for column ‘status’ at row 1: id = 420, class = UserRequest, issues = {0=>Failed to issue SQL query: query = UPDATE ticket AS UserRequest_ticketLEFT JOIN contact AS Person_caller_id_contact ON UserRequest_ticket.caller_id = Person_caller_id_contact.idLEFT JOIN contact AS Team_team_id_contact ON UserRequest_ticket.team_id = Team_team_id_contact.idLEFT JOIN contact AS Person_agent_id_contact ON UserRequest_ticket.agent_id = Person_agent_id_contact.idINNER JOIN (ticket_request AS UserRequest_ticket_request LEFT JOIN contact AS Person_approver_id_contact ON UserRequest_ticket_request.approver_id = Person_approver_id_contact.idLEFT JOIN ticket AS UserRequest_parent_request_id_ticket ON UserRequest_ticket_request.parent_request_id = UserRequest_parent_request_id_ticket.idLEFT JOIN ticket AS Incident_parent_incident_id_ticket ON UserRequest_ticket_request.parent_incident_id = Incident_parent_incident_id_ticket.idLEFT JOIN ticket AS Problem_parent_problem_id_ticket ON UserRequest_ticket_request.parent_problem_id = Problem_parent_problem_id_ticket.idLEFT JOIN ticket AS Change_parent_change_id_ticket ON UserRequest_ticket_request.parent_change_id = Change_parent_change_id_ticket.id) ON UserRequest_ticket.id = UserRequest_ticket_request.id SET UserRequest_ticket.last_update = ‘2020-03-29 10:18:38’, UserRequest_ticket_request.status = ‘info’, UserRequest_ticket_request.resolution_date = ‘2020-03-29 10:18:38’, UserRequest_ticket_request.time_spent = 2609 WHERE ((((((((((UserRequest_ticket.id = ‘420’) AND COALESCE((Person_caller_id_contact.finalclass IN (‘Person’)), 1)) AND COALESCE(( Team_team_id_contact.finalclass IN ('Team')), 1)) AND COALESCE((Person_agent_id_contact.finalclass IN ('Person')), 1)) AND COALESCE((UserRequest_ticket.finalclass IN ('UserRequest')), 1)) AND COALESCE((Person_approver_id_contact.finalclass IN ('Person')), 1)) AND COALESCE((UserRequest_parent_request_id_ticket.finalclass IN ('UserRequest')), 1)) AND COALESCE((Incident_parent_incident_id_ticket.finalclass IN ('Incident')), 1)) AND COALESCE((Problem_parent_problem_id_ticket.finalclass IN ('Problem')), 1)) AND COALESCE((Change_parent_change_id_ticket.finalclass IN (‘Change’)), 1)), mysql_errno = 1265, mysql_error = Data truncated for column ‘status’ at row 1}
Все решил. Тема не актуальна
За такие вещи скоро банить начнем)
