Search Engine: Elastic

Article ID: 131086, created on Jun 29, 2017, last review on Jun 29, 2017

  • Applies to:
  • Operations Automation 7.1
  • Operations Automation 6.0
  • Business Automation 7.1

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.

7c0b495571a6c1bec50e4f324a20ec14 caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 198398b282069eaf2d94a6af87dcb3ff b2c3b33425dfc50c7d41a2efaa7f84f3 8c199f0ee4305da1a577740620df4a51 5356b422f65bdad1c3e9edca5d74a1ae 1941880841f714e458ae4dc3d9f3062d 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF