My Oracle Support Banner

Cannot Save ACS Destination Username and Password for FTP Protocol, ORA-00001: unique constraint ({Prefix}_OPSS.JPS_DN_PK) violated in ManagedServer01-diagnostic.log (Doc ID 2874671.1)

Last updated on JANUARY 24, 2024

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior

Username and Password fields values disappear after Saving the created ACS (Agile Contents Service) Destination using FTP protocol

Expected Behavior

Username and Password fields values for ACS Destination using FTP protocol can be saved


Error

Below error is seen in ManagedServer01-diagnostic.log under %Agile_Home%\agileDomain\servers\hostname-AgileServer\logs:
[2022-02-24T22:16:47.921+08:00] [ManagedServer01] [WARNING] [JPS-01033] [oracle.jps.credstore] [tid: [ACTIVE].ExecuteThread: '33' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: {username}] [ecid: xxxxxxxxxx,0] [APP: AgilePLM] [partition-name: DOMAIN] [tenant-name: GLOBAL] Cannot set credential. Reason oracle.security.jps.service.policystore.PolicyObjectAlreadyExistsException: Error : 1, Position : 0, Sql = INSERT INTO JPS_DN (ENTRYID, PARENTDN, RDN) VALUES (:1 , :2 , :3 ), OriginalSql = INSERT INTO JPS_DN (ENTRYID, PARENTDN, RDN) VALUES (?, ?, ?), Error Msg = ORA-00001: unique constraint ({Prefix}_OPSS.JPS_DN_PK) violated[[


Steps

The issue can be reproduced at will with the following steps:

  1. Login to Java Client as admin user, and go to Admin tab > Server setting > Agile Content Service > Destinations
  2. Create New
  3. Fill in Name and Description field
  4. For Protocol, select "FTP"
  5. Type the URL of the FTP site where the transfer order is sent
  6. Type the Username and Password of the FTP site
  7. Click Test, and confirm it shows "Test Successful."
  8. Click OK to save
  9. The saved Destination shows up in the screen. However, see Username and Password fields are blank
  10. Below error is seen in ManagedServer01-diagnostic.log under %Agile_Home%\agileDomain\servers\{hostname}-AgileServer\logs:
    ORA-00001: unique constraint ({prefix}_OPSS.JPS_DN_PK)

Changes

Imported Agile database schema and RCU schema

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.