Hi all,
We have this data load utility in an Apex app which loads data from a csv file into a table with 4 fields and it stopped working in Aug 2020 after 3 years with the error "ORA-01403: no data found". We haven't made any changes to the app since last year and so far couldn't find the reason and resolution for it.
Instead of selecting an Upload file, Copying & Pasting still works and provides a reliable albeit cumbersome work-around solution.
Creating a new data load from scratch produces the exact same error so it seems something is amiss within the software installation itself.
Creating a new data load from scratch to another table still produces the same error.
Setting the "Skipping validation" to Yes in the Data Load definition makes no difference.
Access to the target table is open and works perfectly fine with the Copying & Pasting method so it's not the table's access problem.
There seems to be something wrong with the way the Wizard tries to parse the file. We tested using files that were successfully loaded in the past but now no longer work. We created new, simplified files with all column names, all data fields verified and limited to just 5 rows but still run into the same error.
Error during rendering of region "Data / Table Mapping".Contact your application administrator.
Technical Info (only visible for developers)
is_internal_error: true
apex_error_code: APEX.REGION.UNHANDLED_ERROR
ora_sqlcode: 100 ORA-01403: no data found
The only recent change was that the DBA said he may have moved some paths on the database recently but couldn't be more specific.
Help. We are running out of ideas. Any suggestions will be greatly appreciated.
Thank you.
Daniel
Oracle Apex 18.2.0.00.12