Not Able To Encrypt Password In Connection Details. (Doc ID 2128242.1)

Last updated on MAY 25, 2016

Applies to:

Oracle Endeca Information Discovery Integrator - Version 3.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 3.0.0 version, Integrator ETL/Designer

Not able to encrypt password in connection details. After creating a custom dashboard. Need to to encrypt the password for database while creating the Graph.

ERROR
-----------------------

2016-04-07 17:29:07,592 ERROR 495106 [LOAD_CONFIGURATION_495103] Can't decrypt password on DBConnection (id=JDBC1). Please set the password as engine parameter -pass.
2016-04-07 17:29:07,936 ERROR 495106 [WatchDog] Graph execution finished with error
2016-04-07 17:29:07,937 ERROR 495106 [WatchDog] Node DB_INPUT_TABLE2 finished with status: ERROR caused by: Can't connect to DB.
2016-04-07 17:29:07,937 ERROR 495106 [WatchDog] Node DB_INPUT_TABLE2 error details:
org.jetel.exception.JetelRuntimeException: Can't connect to DB.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go into Clover ETL
2. Create a database connection
3. Enter connection information (uname, password)
4. Click on Encrypt password
5. Save changes

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, customer is unable to run the graph

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