The error appears when I select "Impact" or "Urgency":
*No result for the single row query: 'SELECT DISTINCT Service_service.id AS Serviceid, Service_service.name AS Servicename, Service_service.org_id AS Serviceorg_id, Organization_org_id_organization.name AS Serviceorganization_name, Service_service.servicefamily_id AS Serviceservicefamily_id, ServiceFamily_servicefamily_id_servicefamilly.name AS Serviceservicefamily_name, Service_service.description AS Servicedescription, Service_service.status AS Servicestatus, CAST(CONCAT(COALESCE(Service_service.name, '')) AS CHAR) AS Servicefriendlyname, CAST(CONCAT(COALESCE(Organization_org_id_organization.name, '')) AS CHAR) AS Serviceorg_id_friendlyname, CAST(CONCAT(COALESCE(ServiceFamily_servicefamily_id_servicefamilly.name, '')) AS CHAR) AS Serviceservicefamily_id_friendlyname FROM service AS Service_serviceINNER JOIN (organization AS Organization_org_id_organization ) ON Service_service.org_id = Organization_org_id_organization.idLEFT JOIN (servicefamilly AS ServiceFamily_servicefamily_id_servicefamilly ) ON Service_service.servicefamily_id = ServiceFamily_servicefamily_id_servicefamilly.id WHERE ((Service_service.id = '5') AND (Service_service.org_id IN ('3'))) '
The error appears when I select "Impact" or "Urgency":
*No result for the single row query: 'SELECT DISTINCT
Service_service
.id
ASServiceid
,Service_service
.name
ASServicename
,Service_service
.org_id
ASServiceorg_id
,Organization_org_id_organization
.name
ASServiceorganization_name
,Service_service
.servicefamily_id
ASServiceservicefamily_id
,ServiceFamily_servicefamily_id_servicefamilly
.name
ASServiceservicefamily_name
,Service_service
.description
ASServicedescription
,Service_service
.status
ASServicestatus
, CAST(CONCAT(COALESCE(Service_service
.name
, '')) AS CHAR) ASServicefriendlyname
, CAST(CONCAT(COALESCE(Organization_org_id_organization
.name
, '')) AS CHAR) ASServiceorg_id_friendlyname
, CAST(CONCAT(COALESCE(ServiceFamily_servicefamily_id_servicefamilly
.name
, '')) AS CHAR) ASServiceservicefamily_id_friendlyname
FROMservice
ASService_service
INNER JOIN (organization
ASOrganization_org_id_organization
) ONService_service
.org_id
=Organization_org_id_organization
.id
LEFT JOIN (servicefamilly
ASServiceFamily_servicefamily_id_servicefamilly
) ONService_service
.servicefamily_id
=ServiceFamily_servicefamily_id_servicefamilly
.id
WHERE ((Service_service
.id
= '5') AND (Service_service
.org_id
IN ('3'))) 'Debug trace:
0 /home/donighe/domains/... /public_html/core/metamodel.class.php(5088): MetaModel::MakeSingleRow('Service', '5', true, false, NULL)
1 /home/donighe/domains/... /public_html/application/wizardhelper.class.inc.php(116): MetaModel::GetObject('Service', '5')
2 /home/donighe/domains/... /pages/ajax.render.php(560): WizardHelper->GetTargetObject()
3 {main}*
TIA,
Laurentiu
I have the same error with the 2.1 version.
I've seen the query and all the fields query are complete in itop.
same for me :( still have the issue every time a new tiket is created.
hi,
Same problem for me...
This gives a bad image with respect to our customers, someone has an idea to solve this problem?
Hi,
Same problem for me.
nobody has found solution ?
Can be a problem with the access rights: if the service selected is part of an organization which is not allowed to the current user...