Symptoms

The following error appears on attempt to deactivate Service Template:

An unforeseen error occurred.

On attempt to use pem.deactivateST API request:

Error: -1, ERROR:  canceling statement due to statement timeout
CONTEXT:  while locking tuple (10,8) in relation "ServiceTemplate"

BA problem report error statement:

[RDBMS       RQ205715 TH27487 NTE] Code: 1000. ERROR:  canceling statement due to statement timeout
CONTEXT:  while locking tuple (10,8) in relation "ServiceTemplate"

[RDBMS       RQ205715 TH27487 INF] can't retry. Transaction is in progress
[PEMGATE_Obj RQ205715 TH27487 TRC] ...[0] *** INTERRUPTED BY EXCEPTION *** ErrorMessage*     PEMGATE::ServiceTemplateUpdate(Int, Str, Int, Int)

Cause

Software-related issue #POA-111867: "Impossible to deactivate service template with lots of plans".

Resolution

Contact pta@odin.com or TAM to trace the status of the request.

Internal content

Link on internal Article