Javelin error while performing Bulk copy - Oracle ( GT subset)

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Imported "Subset bulk copy XML" created using GT Subset into Javelin. 

When I run the flow, receiving error :  ORA-12537: Network Session: End of file.

Javelin error log : 

Running flow...

2019-11-27 01:32:45 - Run flow: H:\User\Javelin\EMPLOYEE_INTERACTION_EVENT.vwf

2019-11-27 01:32:45 - Running Test Case: Flowchart

2019-11-27 01:32:45 - Executing Step: LogActivity

2019-11-27 01:32:45 - With Params:

2019-11-27 01:32:45 - Variable Name = MessageToLog                    Value = <NULL>

2019-11-27 01:32:45 - Variable Name = Timeout                                Value = 0

2019-11-27 01:32:45 -

2019-11-27 01:32:45 - Running Test Case: Bulk Copy

2019-11-27 01:32:45 - Executing Step: Read data from KPD_REPOS.EMPLOYEE_INTERACTION_EVENT

2019-11-27 01:32:45 - With Params:

2019-11-27 01:32:45 - Variable Name = Provider                                Value = Oracle

2019-11-27 01:32:45 - Variable Name = Port                         Value = 50001

2019-11-27 01:32:45 - Variable Name = Server                    Value = xxx.xxx.xxx.xxx

2019-11-27 01:32:45 - Variable Name = Database                               Value = DBNAME

2019-11-27 01:32:45 - Variable Name = Schema                  Value = KPD_REPOS

2019-11-27 01:32:45 - Variable Name = Username                             Value = USername

2019-11-27 01:32:45 - Variable Name = ServiceName                      Value = Srvc.oracle.db

2019-11-27 01:32:45 - Variable Name = OleDbConnectionString                 Value = <NULL>

2019-11-27 01:32:45 - Variable Name = OdbcConnectionString                   Value = <NULL>

2019-11-27 01:32:45 - Variable Name = CommandTimeout                           Value = 600

2019-11-27 01:32:45 - Variable Name = Query                     Value = select EDELIVERY_SIGNUP_DATE,UPDATED_BY,UPDATED_TS,CREATED_BY,CREATED_TS,ENTITY_SYSTEM_KEY,EMAIL_CAPTURE_PROMPT_DATE,ALERT_MESSAGE_VIEW_DATE,CONVERTED_ING_ACCESS_IND,ONLINE_EVLTN_LAYER_READ_DATE,EXCEL_TRANSACTION_DOWNLOAD_IND,TRANSACTION_DOWNLOAD_IND,EMAIL_PRFRNC_FORCED_SETUP_IND,PARTY_ID,SSO_CLIENT_ID,CONSENT_ONLINE_ADVISOR_OM,CONSENT_ONLINE_ADVISOR_TXN from KPD_REPOS.EMPLOYEE_INTERACTION_EVENT L0  where SSO_CLIENT_ID = 'INGWIN'

2019-11-27 01:32:45 - Variable Name = AdditionalConnectionParameters                             Value = <NULL>

2019-11-27 01:32:45 - Variable Name = Timeout                                Value = 0

2019-11-27 01:32:46 - Connecting to database...

2019-11-27 01:32:46 - Error executing Read data from KPD_REPOS.EMPLOYEE_INTERACTION_EVENT: ORA-12537: Network Session: End of file

2019-11-27 01:32:46 - Running Test Case: Bulk Copy

2019-11-27 01:32:46 - Test Case: Bulk Copy Execution Complete

2019-11-27 01:32:46 - Running Test Case: Flowchart

2019-11-27 01:32:46 - Test Case: Flowchart Execution Complete

Execution complete with error:ORA-12537: Network Session: End of file

Cause

This issue is caused due to the old OracleManaged dll which doesn't support Oracle encryption. 

Environment

Release : 4.7

Component : CA Test Data Manager

Resolution

Please follow below steps to update the dll and required dependencies in Javelin installation folder:

- Rename Oracle.ManagedDataAccess.dll to Oracle.ManagedDataAccess.dll.old and move to any backup location.

- Copy the latest version of Oracle.ManagedDataAccess.dll (version 4.122.19.1) uploaded to support case into Javelin directory.

- Modify Javelin.exe.config and JavelinExecutor.exe.config to change the Version mentioned in the following line:


Now restart Javelin and test again. Issue should be resolved.