Error:"ORA-12638: Credential Retrieval Failed" and Keystore Warnings When Attempting to Run an ETL

(Doc ID 2407171.1)

Last updated on JUNE 15, 2018

Applies to:

Primavera Data Warehouse - Version 17.12.0.0 and later
Information in this document applies to any platform.

Symptoms

When running either the initial SETUP.BAT (.SH) or a STARETL.BAT (.SH), keystore warnings may occur and/or credential retrieval error occurs.

Error

Java steps may show this warning:

WARNING: Keystore E:\PrimaveraDataWarehouse\star\etl_homes\staretl1\p6keystore.jks was not found. If keys are needed from that keystore, you may encounter additional errors which prevent proper operation.

SQL steps may show:

16:58:33.187 [main] INFO ETL.Message - === Step 7, Part 1 ====================================================
16:58:33.187 [main] INFO ETL.Message - === Create sequences (create_sequences.sql)
16:58:33.718 [Thread-1] INFO ETL.Message - ERROR:
16:58:33.718 [Thread-1] INFO ETL.Message - ORA-12638: Credential retrieval failed

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms