Tejaswi

ORA-22288: file or LOB operation FILEOPEN failed

0 votes

Getting the below error while adding the attachment in esign in Oracle(Production instance)

ORA-22288: file or LOB operation FILEOPEN failed
Permission denied

While testing in non prod instances, no such error occurred.

Kindly assist as soon as possible.


Reply to: ORA-22288: file or LOB operation FILEOPEN failed

0 votes

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


Reply to: ORA-22288: file or LOB operation FILEOPEN failed

0 votes

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

Duo Liang OneSpan Evangelism and Partner Integrations Developer


Reply to: ORA-22288: file or LOB operation FILEOPEN failed

0 votes

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?


Reply to: ORA-22288: file or LOB operation FILEOPEN failed

0 votes

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 ?


Attachments

Reply to: ORA-22288: file or LOB operation FILEOPEN failed

0 votes

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

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


Reply to: ORA-22288: file or LOB operation FILEOPEN failed

0 votes

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


Reply to: ORA-22288: file or LOB operation FILEOPEN failed

0 votes

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

 

 

 

Duo Liang OneSpan Evangelism and Partner Integrations Developer


Reply to: ORA-22288: file or LOB operation FILEOPEN failed

0 votes

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

 


Attachments

Reply to: ORA-22288: file or LOB operation FILEOPEN failed

0 votes

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)

2-17-1

 

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:

2-17-2

Duo

Duo Liang OneSpan Evangelism and Partner Integrations Developer


Hello! Looks like you're enjoying the discussion, but haven't signed up for an account.

When you create an account, we remember exactly what you've read, so you always come right back where you left off