ORA-22288: file or LOB operation FILEOPEN failed
Tuesday, February 11, 2020 at 01:34amGetting 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
Tuesday, February 11, 2020 at 05:30amI 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
Tuesday, February 11, 2020 at 09:20amHi 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
Tuesday, February 11, 2020 at 11:21pmHi 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
Wednesday, February 12, 2020 at 06:49amHi 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
Duo Liang OneSpan Evangelism and Partner Integrations Developer
Reply to: ORA-22288: file or LOB operation FILEOPEN failed
Thursday, February 13, 2020 at 05:06amHi 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 ?
Reply to: ORA-22288: file or LOB operation FILEOPEN failed
Thursday, February 13, 2020 at 05:09amCan 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
Thursday, February 13, 2020 at 05:15amIs this the correct url for integration code : https://apps.esignlive.com/api/packages ?
Reply to: ORA-22288: file or LOB operation FILEOPEN failed
Thursday, February 13, 2020 at 10:30amHi 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
Monday, February 17, 2020 at 06:06amHi 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
Reply to: ORA-22288: file or LOB operation FILEOPEN failed
Monday, February 17, 2020 at 12:27pmHi 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
Duo Liang OneSpan Evangelism and Partner Integrations Developer