Javelin Issue Connecting to Oracle

[Jon Herrin]

I have a simple Javelin task that consists of a DataReaderActivity that connects to an Oracle database and runs a query to populate a variable that is used by a SqlBulkCopyActivity to populate a table in a SQL Server database. This task works just fine on everyone's computer EXCEPT MINE. When I run this task, I get the following message in the log when the task is connecting to Oracle:

2019-03-29 07:29:23 - Connecting to database...
2019-03-29 07:29:23 - Error executing DataReaderActivity: The type initializer for 'OracleInternal.Common.ProviderConfig' threw an exception.
2019-03-29 07:29:23 - Running Test Case: Flowchart
2019-03-29 07:29:23 - Test Case: Flowchart Execution Complete
Execution complete with error:The type initializer for 'OracleInternal.Common.ProviderConfig' threw an exception.

Has anyone seen this error? And if so, how did you correct the issue?

 

Just to be clear, I can perform other DataReaderActivity tasks, for example, connecting to and reading from a SQL Server database. This issue appears to be specific to connecting to Oracle.

[Jon Herrin]

Interesting follow up. Deleting or changing the permissions of the file

C:\Oracle\product\<version>\<client>\network\admin\sqlnet.ora

Fixed this issue for me.

But this raises a ew question: What is Javelin doing with this file?