Search Engine: Elastic

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

  • Applies to:
  • Operations Automation 7.1

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

Email subscription for changes to this article
Save as PDF