Search Engine: Elastic

Article ID: 132117, created on Jan 23, 2018, last review on Jun 19, 2018

  • Applies to:
  • Operations Automation 7.0
  • Operations Automation 7.1
  • Operations Automation 7.2
  • Operations Automation 7.3
  • Operations Automation 7.4

Symptoms

  1. Attempt to upload SSL certificate fails with error:

    An unforeseen error occurred. Please contact admin@example.com.
    Error ID: 1516232603880
    
  2. OA log /var/log/pa/core.log contains the exception:

    Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "user_repo_uni_0"
      Detail: Key (account_id, type, name)=(2, ca_certificate, List of CA SSL certificates at IIS virtual Web Server #00001) already exists.
    

Cause

When replacing the SSL certificate OA, prior to removing, inserts the corresponding records to the table that already contains the records related to that webspace thus violating PostgreSQL constraints.

Corresponding software issue #POA-114480. Contact your Technical Account Manager or PTA team (pta@odin.com) to trace the status of #POA-114480.

Workaround

Disable SSL support for webpace and enable again having uploaded required certificate.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 8c199f0ee4305da1a577740620df4a51 1941880841f714e458ae4dc3d9f3062d dd79f16c76b9dca75205ab5e9f5465ea 55fe109b4b4fe3fbb893f22dbb85a41a 0871c0b47b3b86ae3b1af4c2942cd0ce 31987597efff5a3a9ce779cc203bbe5e

Email subscription for changes to this article
Save as PDF