Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 466 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
APEX 18.2 Data Load Wizard w date format - no data found

Anyone working with the APEX 18.2 Data Load Wizard?
Working with a vanilla data load wizard - no transformations, no rules, straight upload against a table -
whenever I enter a date format for a field - i.e. DD/DD/YYYY for a BIRTH_DATE filed, I get "no data found" when I click Next on the Column Mapping page.
When I remove the date format, all works fine.
When I enter the data format in double quotes, I get to the next page, then get a literal date format error upon data load.
Has anyone gotten past this?
What Is the data load wizard expecting for a Date format? It used to be no quotes, just the format.
For our application we need the date format - our different users send us data in different date formats.
Yeah, we could preprocess the file but … this is an APEX feature that is supposed to work, and has worked in the past.
Does anyone have any insights here?
Thank you,
Karen
Best Answer
-
For those who may be wondering ..
I was able to track down the "no data found" error on Next moving from the column mapping page to the summary page, when:
- There are 3 Unique columns defined in the Data Load Definition
- The 3rd unique column either not in the upload data set OR selected as Do Not Load
AND in the Data Load Definition, the Skip Verification setting is No.
I am able to work around this issue by setting Skip Validations in the Data Load Definition to Yes.
Carsten identified that this is likely a bug, that will possibly be addressed in a future version. Many thanks for the help!
In the meantime, if someone encounters this issue, try one of these workarounds:
- Upload to a stage table w/o the unique keys, than use a custom process to move data to the real tables, or,
- Set Skip Validations to Yes.
I realize the latter may not be OK is you are relying on the DL Wiz to for validations and transforms ... in our case we are not, we do those elsewhere, so Skip Validations does the trick.
I hope this helps someone,
Karen
Answers
-
maybe instead of using DD/DD/YYYY as date Format, use DD/MM/YYYY.
it might work.
regards,
Franck
-
I wish, the DD/DD/YYYY was a typo - I had entered MM/DD/YYYY. And I even tried the other way. Just in case, which would have invalidated many rows. No matter. Interesting that entering "MM/DD/YYYY" got me past the no data found to the next page, BUT then I get the literal error.
-
This is a definite change in how the data load wizard worked in APEX 5.1.
The same data load wizard, when an app is upgraded, no longer works, giving the no data found error.
The specific example I am asking about is a new data load wizard created on the same table, bare bones, to see what APEX is expecting … but I have yet to figure that out. Any help or advice is appreciated.
-
More information:
After much testing, with different files, copy/paste and upload file, I get the "no data found" message on most every data set, whether I have a date column and enter a date format or not. The exact error message is:
Exception in "Prepare Uploaded Data":
Error Stack: ORA-01403: no data found
ORA-06512: at "APEX_180200.WWV_FLOW_DATA_UPLOAD", line 2777
ORA-06512: at "APEX_180200.WWV_FLOW_DATA_UPLOAD", line 394
ORA-06512: at "APEX_180200.WWV_FLOW_DATA_UPLOAD", line 2645
ORA-06512: at "APEX_180200.WWV_FLOW_PROCESS_NATIVE", line 1126
ORA-06512: at "APEX_180200.WWV_FLOW_PROCESS_NATIVE", line 1232
ORA-06512: at "APEX_180200.WWV_FLOW_PLUGIN", line 2451
Backtrace: ORA-06512: at "APEX_180200.WWV_FLOW_DATA_UPLOAD", line 2777
ORA-06512: at "APEX_180200.WWV_FLOW_DATA_UPLOAD", line 394
ORA-06512: at "APEX_180200.WWV_FLOW_DATA_UPLOAD", line 2645
ORA-06512: at "APEX_180200.WWV_FLOW_PROCESS_NATIVE", line 1126
ORA-06512: at "APEX_180200.WWV_FLOW_PROCESS_NATIVE", line 1232
ORA-06512: at "APEX_180200.WWV_FLOW_PLUGIN", line 2451
ORA-06512: at "APEX_180200.WWV_FLOW_PROCESS", line 201
Via debug I can see that the PARSE_COL_HEAD, LOAD_COL_HEAD, LOAD_CONTENT, NOT_LOAD_CONTENT collections have all been populated. Actually there are several rounds of loading NOT_LOAD_CONTENT, the last ending with a row count:
-
Based on the debug messages, my guess is that something is causing No rows to get loaded in the LOAD_CONTENT collection and all ros to be loaded in the NOT_LOAD_CONTENT collection, From that, I can guess that the no data found message is caused by the query agains the empty LOAD_CONTENT collection.
But why, when I am loading all valid rows, at least by pre-18.2 standards, are all these rows ending up in the NOT_LOADED_CONTENT collection?
APEX team, please help me understand what has changed behind the scenes, so I can adjust and get my applications working again.
Thank you!
-
Carsten Czarski-Oracle Consulting Member of technical Staff Munich, GermanyMember Posts: 1,345 Employee
Hi Karen,
would be happy to have a look into this ... from the error stack this seems to be related to the Primary Key Columns, but I would need to check in more detail:
Is it possible to create a test case ...? I would need ...
-) the table definition
-) details of the data load definition
-) sample data
You might also send this to me privately. The Oracle email scheme is {firstname}.{lastname}@oracle.com. As an alternative, could you set Debug mode to 9 (turn on Debug, then replace the "YES" in the URL with "LEVEL9") and send the debug output to me ...?
Best regards
-Carsten
-
Thank you Carsten - in progress. Will update with details soon and send privately.
-
For those who may be wondering ..
I was able to track down the "no data found" error on Next moving from the column mapping page to the summary page, when:
- There are 3 Unique columns defined in the Data Load Definition
- The 3rd unique column either not in the upload data set OR selected as Do Not Load
AND in the Data Load Definition, the Skip Verification setting is No.
I am able to work around this issue by setting Skip Validations in the Data Load Definition to Yes.
Carsten identified that this is likely a bug, that will possibly be addressed in a future version. Many thanks for the help!
In the meantime, if someone encounters this issue, try one of these workarounds:
- Upload to a stage table w/o the unique keys, than use a custom process to move data to the real tables, or,
- Set Skip Validations to Yes.
I realize the latter may not be OK is you are relying on the DL Wiz to for validations and transforms ... in our case we are not, we do those elsewhere, so Skip Validations does the trick.
I hope this helps someone,
Karen
-
Thanks for the suggested - I had the same (or very similar) problem - skipped validation and now things work again. No dates in my data though.