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.