on 03-22-2016 3:18 PM
Buen día, tengo un problema con la actualización de un contrato, se crearon llamadas de servicio a una serie que no estaba ligada con un contrato, ahora he tratado de ligar esa serie a un contrato y me muestra el siguiente mensaje:
No es posible borrar el artículo de un contrato de servicio enlazado a una llamada de servicio. [Contrato de servicios - Partidas - Número de artículo]
Les agradezco si alguien me puede ayudar.
Saludos!
Hola
comprueba la nota 1020488 - Error message while updating service contracts.
Un saludo
Agustín Marcos Cividanes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1020488 - Error message while updating service contracts
Symptom
While attempting to update service contracts, the application may display the following error messages:
"Not possible to delete items with a service call"
"Cannot update item with service call"
There are two cases in which this can occur:
1. The service call linked to the service contract involves an item whose internal serial number does not exist in the item list of the service contract. To identify the service contracts affected by this case, run the following select query:
SELECT T0.CONTRACTID,T0.CALLID, T0.itemCode, T0.INTERNALSN FROM OSCL T0 WHERE NOT EXISTS
(SELECT 1 FROM CTR1 WHERE CONTRACTID=T0.CONTRACTID and itemcode=t0.itemcode and internalsn=t0.internalsn)
GROUP BY T0.CONTRACTID ,T0.CALLID, T0.itemCode , T0.INTERNALSN
HAVING T0.CONTRACTID IS NOT NULL AND T0.INTERNALSN IS NOT NULL
ORDER BY T0.CONTRACTID
You can update the service contract by adding the item with the serial number that appears in the linked service call, according to the query above.
2. A service call linked to the service contract contains an item without a serial number. To identify the service contracts affected by this case, run the following select query:
SELECT T0.CONTRACTID,T0.CALLID, T0.INTERNALSN FROM OSCL T0 inner join OCTR t1 on t0.contractid=t1.ContractID and t1.CntrcType = 'S' where NOT EXISTS
(SELECT 1 FROM CTR1 c inner join OCTR o on c.ContractID=o.ContractID WHERE c.CONTRACTID=T0.CONTRACTID and c.internalsn=t0.internalsn and o.CntrcType = 'S')
GROUP BY T0.CONTRACTID ,T0.CALLID, T0.INTERNALSN
HAVING T0.CONTRACTID IS NOT NULL AND T0.INTERNALSN IS NULL
ORDER BY T0.CONTRACTID
You can update the service contract by unlinking the service call from the service contract. To do so, contact your support center.
Cause
Specific Solution
Solution
If your database is affected by the second symptom, contact your support center.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.