ERROR - USING EMAILS TO AUTO CREATE TICKET

[N S]

EmailBackgroundProcess: Processing failed, the following exception occured: No result for the single row query: 'SELECT DISTINCT Person_person.id AS Personid, Person_contact.name AS Personname, Person_contact.status AS Personstatus, Person_contact.org_id AS Personorg_id, Organization_org_id_organization.name AS Personorg_name, Person_contact.email AS Personemail, Person_contact.phone AS Personphone, Person_contact.notify AS Personnotify, Person_contact.function AS Personfunction, Person_person.first_name AS Personfirst_name, Person_person.employee_number AS Personemployee_number, Person_person.mobile_phone AS Personmobile_phone, Person_person.location_id AS Personlocation_id, Location_location_id_location.name AS Personlocation_name, Person_person.manager_id AS Personmanager_id, Person_manager_id_contact.name AS Personmanager_name, Person_contact.finalclass AS Personfinalclass, CAST(CONCAT(COALESCE(Person_person.first_name, ''), COALESCE(' ', ''), COALESCE(Person_contact.name, '')) AS CHAR) AS Personfriendlyname, CAST(CONCAT(COALESCE(Organization_org_id_organization.name, '')) AS CHAR) AS Personorg_id_friendlyname, CAST(CONCAT(COALESCE(Location_location_id_location.name, '')) AS CHAR) AS Personlocation_id_friendlyname, CAST(CONCAT(COALESCE(Person_manager_id_person.first_name, ''), COALESCE(' ', ''), COALESCE(Person_manager_id_contact.name, '')) AS CHAR) AS Personmanager_id_friendlyname FROM person AS Person_personLEFT JOIN location AS Location_location_id_location ON Person_person.location_id = Location_location_id_location.idLEFT JOIN (person AS Person_manager_id_person INNER JOIN contact AS Person_manager_id_contact ON Person_manager_id_person.id = Person_manager_id_contact.id) ON Person_person.manager_id = Person_manager_id_person.idINNER JOIN (contact AS Person_contact INNER JOIN organization AS Organization_org_id_organization ON Person_contact.org_id = Organization_org_id_organization.id) ON Person_person.id = Person_contact.id WHERE (Person_person.id = 193) '

[dlp]

Is the email of the sender is related to a team?
On my platform i have these kind of errors in this case.

[N S]

Yes the sender is part of a team. Should I remove the sender from the team?

[dlp]

No that's not what I mean.
Is one of your team has the same email has the sender?

[N S]

Yes

[dlp]

so this the problem.
When itop try to read the mail, it check if the emil send is related to a contact.
It founds a team, but a team is not a person so it generate an error. This is a bug from the extension for me, but anyway, you can try to change or remove the mail of the team.

[N S]

Hi.
Thanks for the assist, it worked
Problem - had one of the teams with an email address like the contact.
Solution - Just Removed the email from the team

[N S]

Hi.

Thanks for the assist, it worked

Problem - had one of the teams with an email address like the contact.

Solution - Just Removed the email from the team