My Oracle Support Banner

ODI 12c OdiOSCommand Error ODI-30038 with Return Code 77 and "Unable to initialize NSS database" Calling CURL (Doc ID 2434821.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle Data Integrator (ODI) 12.2.1, executing OdiOSCommand to invoke the curl tool in an ODI task results in the following error loading the third-party NSS libraries:

com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30038: OS command returned 77. Error details are [* About to connect() to <HOST> port <SSL_PORT> (#0)
* Trying <IP_ADDRESS>... connected
* Connected to <HOST> (<IP_ADDRESS>) port <SSL_PORT> (#0)
* Initializing NSS with certpath: sql:/etc/pki/nssdb
* Unable to initialize NSS database
* Initializing NSS with certpath: none
* Unable to initialize NSS
* NSS error -5925
* Closing connection #0
* Problem with the SSL CA cert (path? access rights?)

The command in the ODI task is:

OdiOSCommand "-ERR_FILE=./error.log" "-CAPTURE_OUT_STREAM=ON_ERROR,10,50" "-CAPTURE_ERR_STREAM=ON_ERROR,10,50"
curl -vvv <HOST_URL>

When the curl command is executed manually outside of the Agent, it works with no problems:

* About to connect() to <HOST> port <SSL_PORT> (#0)
* Trying <IP_ADDRESS>... connected
* Connected to <HOST> (<IP_ADDRESS>) port <SSL_PORT> (#0)
* Initializing NSS with certpath: sql:/etc/pki/nssdb
* warning: ignoring value of ssl.verifyhost
* skipping SSL peer certificate verification
* SSL connection using TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
* Server certificate:
* [cert details here]
> GET / HTTP/1.1

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.