Error when trying to import CVS file to Oracle Database with Javelin

book

Article ID: 194949

calendar_today

Updated On:

Products

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

Issue/Introduction

When trying to import a CSV file to an oracle database using the same basic structure as the SQL example that is provided with Javelin the import fails with the following Error:

Error 1:
2020-07-09 08:04:47 - Variable Name = Username  Value = CA_UIM_902
2020-07-09 08:04:47 - Variable Name = ServiceName  Value = pdborcl
2020-07-09 08:04:47 - Variable Name = Port  Value = 1521
2020-07-09 08:04:47 - Variable Name = BatchSize  Value = 0
2020-07-09 08:04:47 - Variable Name = NotifyAfter  Value = 0
2020-07-09 08:04:47 - Variable Name = BulkCopyTimeout  Value = 600000
2020-07-09 08:04:47 - Variable Name = DestinationTableName  Value = TestCases
2020-07-09 08:04:47 - Variable Name = ColumnMappings  Value = 
2020-07-09 08:04:47 - Variable Name = AdditionalConnectionParameters  Value = <NULL>
2020-07-09 08:04:47 - Variable Name = Timeout  Value = 0
2020-07-09 08:04:47 - Error executing Idata reader push into Oracle : The type initializer for 'Oracle.DataAccess.Client.OracleBulkCopy' threw an exception.

 

Cause

Version and path issues.

Environment

Original version:
Windows 2016
Javelin (2.x) ( default installed with 4.9 TDM release)

 

 

Resolution

Update to Javelin 64-bit 8.4.x
ftp://tdmpuser:[email protected]/TDM/Javelin/Javelin-4.8.109.0.zip

Update to the latest GTODACDeployer 4.126.X
 ftp://tdmpuser:[email protected]/TDM/GTODACDeployer/GTODACDeployer-4.126.0.100.zip

add the odac64  directory to your environment path.

Attachments

1594644433883__PushCSVIntooracletable.zip get_app