I am trying to create a page where csv files can be uploaded using the wizard in Apex 4.1.0.00.32
However after completing the wizard and pressing the finish button, the following message shows up:
Error Error creating page .
ORA-01403: no data found
All I can do then is press an OK button which takes me back to the summary screen before submitting.
I've already tried the wizard using other tables, empty and ones with data in it, but with the same result.
The strange thing is that I have used the wizard with success, but now it won't work anymore in this application.
The other strange thing is that the wizard is still working for other application within the same workspace, even on the same table...
Anyone has got any ideas to fix this (making a new application from scratch is my last resort considering the amount of work I've already put into this one)
We too are having the exact same problems as you have described. We are apex version 4.1.0.00.32.
We have a main application with all our web design and security and when i copy this application and try to create a Data Loading page, just accepting all the default values then at the end of the wizard I also get the Error
Error Error creating page.
ORA-04103 no data found
And like yourself if i create an application from scratch and use the same table it works fine.
I am trying to understand what is happening but I could not reproduce the same issue. From your post, you are having multiple application in the same workspace and you are able to create the data uploading without having any problem. Do you mean this happens only to one particular application ? Did you import that app ? I would appreciate if you can outline steps to reproduce the same error.
To answer your questions:
- i did not copy the application
- other applications in the same workspace do not have this problem.
- i created one page with the upload wizard in this particular application but the second time the wizard produced the error described above.
The URL that is shown on the error page ends with "wwv_flow.accept"
Does that help?
I have tried to reproduce the error in other applications by creating dataload forms with a variety of options, but (unfortunately) the error won't show up in these applications..
Maybe the error is logged somewhere with more detail but I don't know where to look. If you could help me with that, I might be able to provide further detail.
I have the exact same problem. In my existing 4.1 application I also get the no data found exception when I press the finish button of the data loading wizard. The problem only occurs in one specific application.
My application was imported from a 4.0 application. What I have found out so far:
If I make a new application in my workspace the data loading wizard works fine.
If I make a new application in my 4.0 environment, export it and then import it in my 4.1 workspace the data loading wizard also works fine.
The problem seems to occur regardless of what data I do or don't supply in the various steps of the wizard.
Is there any way to see from where the no data found exception originates (apex logging)?
Hi Martijn and Merijn,
If you are able to import other applications from previous versions and being able to create data upload function without any problem. Now I have two more questions and we should be able to find out what is going on in your applications. a. both of the applications that are failing, were they imported from either 3.2 or 4.0 ? if yes, can you check the name of the application default template ?
Alright, I got the wizard working again. This is how:
By doing some searching on google I found that the errorlogs of Apache are logged in the folder: apache\apache\logs\
I found that there were some error logs in there that created new lines each time I used the wizard:
[Fri Jan 27 17:45:41 2012] [error] [client 172.18.40.211] [ecid: 1327682741:10.10.10.128:2380:2616:373,0] File does not exist: d:/oracle/product/10.2.0/ohs_1/apache/images/css/apex_builder_4_0.css
[Fri Jan 27 17:45:44 2012] [error] [client 172.18.40.211] [ecid: 1327682744:10.10.10.128:2380:2536:480,0] File does not exist: d:/oracle/product/10.2.0/ohs_1/apache/images/css/apex_builder_4_0.css
So I figured maybe if I copy the existing apex_builder_4_1.css in the folder and rename it to apex_builder_4_0.css it would work.
After doing that the error messages stopped in the error log, but still the wizard failed.
After that I changed the theme of the application and the wizard started working again!
Don't no what will happen when I change the theme back to the one I was using, maybe I will try that later.
For now I am happy!
Thanks Patrick for putting time into it
(btw my application was not imported, but I did play around with the themes a fair bit)
Edited by: Merijn8106997 on 27-jan-2012 9:27
I a glad that you are able to get your app running now. Yes, renaming your themes as well would have created the same issue as the Data Upload was basically depending to existing names (4.1). However this will be changed in the coming release. I have filed the bug 13635954.
My application uses custom made templates, so that explains why I encountered this problem. After switching to an Oracle theme the wizard worked just fine for me as well.
A word of warning though: when I changed the theme back to my custom theme after using the wizard, the default templates for pages and regions were set to a different template. Before starting this workaround it's probably a good idea to make a copy of the application.