ORA-22288: file or LOB operation FILEOPEN failed

I gave permission rights(read write) to the file,which is uploaded in esign, and when I again ran the integration program it gave the error:

Response> Status Code: 302
Response> Reason Phrase: Found
Response> HTTP Version: HTTP/1.1
Response> Server: nginx
Response> Date: Tue, 11 Feb 2020 11:21:16 GMT
Response> Content-Length: 0
Response> Connection: close
Response> X-Powered-By: Undertow
Response> Location: https://apps.e-signlive.com/error?error=eyJjb2RlIjo0MDQsIm1lc3NhZ2VLZXkiOiJlcnJvci5ub3RGb3VuZC51c2VyTm90Rm91bmQiLCJ0ZWNobmljYWwiOiJDb3VsZCBub3QgZmluZCB1c2VyIHdpdGggdWlkICd0RFppSUpBMkJsMDInIiwibWVzc2FnZSI6IlRoZSBzcGVjaWZpZWQgdXNlciBjYW5ub3QgYmUgZm91bmQuIiwibmFtZSI6IlJlc291cmNlIE5vdCBGb3VuZCJ9
Response> Strict-Transport-Security: max-age=31536000; includeSubdomains;
Response> Allow: GET, POST, HEAD, PUT, PATCH, DELETE
Response> P3P: CP="IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT"
ORA-29266: end-of-body reached

Hi Tejaswi,

If you base64 decode the error message, and it tells you the fail reason:
{"code":404,"messageKey":"error.notFound.userNotFound","technical":"Could not find user with uid 'tDZiIJA2Bl02'","message":"The specified user cannot be found.","name":"Resource Not Found"}

From where it looks like that your API Key holder was not in the apps.e-signlive.com (US1 production) environment. Could you double check with the credentials?

Duo

Hi Duo,

The API key in the program is correct.

Can you please confirm if the below prod url is correct?

https://apps.e-signlive.com/api/packages (currently using this url in my code)

Or should it be https://apps.esignlive.com/api/packages?

Hi Tejaswi,

Do you know your login credentials? If so, you can try to login with your username and password through the UI portal:
https://apps.e-signlive.com/login vs https://apps.esignlive.com/login

Duo

Hi Duo,

I do not have the credentails for UI portal. But I asked client to do the above step and they are unable to access this site https://apps.e-signlive.com/login.
It says this site cannot be reached. They are able to login through https://apps.esignlive.com/login

I downloaded the security certificate from this site(https://apps.esignlive.com/login) and created the wallet. But the error occurred as follows:

ORA-29273: HTTP request failed

ORA-06512: at "SYS.UTL_HTTP", line 1130

ORA-29024: Certificate validation failure

PFA certificate(esignlive.com) for which wallet is created.

Also, attached is security certficate(globalsignrootca) which I was using earlier and the error - status code:302 occurred as mentioned above.

Can you please provide the security certificate link for site https://apps.e-signlive.com/login ?

Can you please provide the security certificate link for site https://apps.esignlive.com/login?  

and not site https://apps.e-signlive.com/login

Is this the correct url for integration code : https://apps.esignlive.com/api/packages ?

Hi Tejaswi,

After checking our support specialist, I can't find the user with uid of "tDZiIJA2Bl02" in US instances. Instead, I found one account at the Australia instance: https://apps.esignlive.com.au

Just out of caution, could you confirm with the client that they have provided you with the API Key in correct environment before we look into this connection issue?

PS: below is the step to check the API Key within UI portal:

(1)in dashboard, expand the "Admin" tab on top

(2)choose "Integration" option

(3)in Integration page, you will find the API Key, which be can unmasked by clicking the eye icon.

Duo

Hi Duo,

I have triple checked the API key and its correct.

Can you please please please confirm if the attached certificate is correct for this site - https://apps.esignlive.com.au/login?

Also in the integration code i am adding the url as - https://apps.esignlive.com.au/api/packages

Hi Tejaswi,

Glad you figured out the API Key and the environment.

If I download the Intermediate CA "GlobalSign Domain Validation CA  - SHA256 - G2" (I believe it's the same CA granted certificate to both AU prod and US2 prod)

And send request to the AU production's API URL "https://apps.esignlive.com.au/api/packages", I can successfully create a package. Below screenshot shows you the try connection:

Duo