search cancel

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

book

Article ID: 144584

calendar_today

Updated On:

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

Environment

Test Data Manager
TDM 
Javelin

Cause

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

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.