I am on Apex version 19.2 on database 19c. In one of the apex form I have a button. When The button clicked it generate a and excel report. Now When I click , the report is not displayed. it says MS excel cannot open this file because the file format or extension is not valid. Meaning the actual excel file is not generated .
in my download folder I open this file in note pad and I see this
Error in BASE REPORT 0:ORA-0000: normal, successful completion
FAILED
ERROR#:255
INFO:ORA-27369: job of type EXECUTABLE failed with exit code: 255 execve: No such file or directory STANDARD_ERROR="execve: No such file or directory"
The report suppose to be generated in a Linux folder and through a redirect URL in open the excel report
I noticed that a corresponding job with failed status . I see the same error in the additional_information column of the job. in dba_scheduler_job_run_details
ORA-27369: job of type EXECUTABLE failed with exit code: 255 execve: No such file or directorySTANDARD_ERROR="execve: No such file or directory"
I couldnt figure out the reason for this . Can someone please help.
George