Error Importing Application

Brad Chriss

import_error.jpg

I have tried to import the same application into two different workspaces. I get the same error everytime (attached)...

Execution of the statement was unsuccessfull. ORA-02091: transaction rolled back

begin

wwv_flow_api.import_end(p_auto_install_sup_obj => nvl(wwv_flow_application_install.get_auto_install_sup_obj, false));

commit;

end;

The export I'm using have been exported using the original IDs and different IDs. the result is the same.

I have no idea where to look to resolve the error

AndyH

Have you checked your database alert log for any further clues?

Last time I saw an ORA-02091 it was related to inserts being made into a table with deferrable constraints - on commit the constraint was broken and the transaction rolled back. Anything like that in your supporting objects?