Problem Uploading File ... Not the Normal Problem
Sky13May 17 2012 — edited May 22 2012Hello,
I am upgrading my database from 11.1.0.6 to 11.2.0.3 and moving from SE to EE at the same time. All that seems to be going fine until I try to import a file into Apex 4.0.2
I will give a high level overview of my upgrade steps.
1. Created a new 11.2.0.3 Database using DBCA.
2. Removed Apex 3.2.1 using the apxremov.sql that comes with Apex 3.2.1.
3. Full import using datapump and excluding FLOWS_FILES, FLOWS_030000, APEX_040000, APEX_030200, APEX_030000 (Along with a bunch of others).
4. Install Apex 4.0.2
Apex works fine except when I try and import a file. I get the 404 error with "wwv_flow.accept was not found on this server".
I look at the Apache error log and see "mod_plsql: /pls/apexXXX/wwv_flow.accept HTTP-404 ORA-00942: table or view does not exist".
My DAD has the PlsqlDocumentTablename entry pointing to the wwv_flow_file_objects$ table. This table is in the FLOWS_FILES schema with a public synonym on it. and APEX_040000, APEX_PUBLIC_USER and ANONYMOUS all have INSERT, UPDATE and DELETE grants.
I have gone through my upgrade process a number of times thinking I would get a different result (And we all know what that means).
Any idea how to fix this?