3 Replies Latest reply: May 27, 2013 1:28 PM by genache RSS

    Errors when trying to copy application to another database

    genache
      Hello all.

      I wanted to have another environment for testing modifications to my application, environment that has is on another machine. So on that machine I've installed a new database (exactly the same as on the original machine) and a new application express (exactly the same). Then i've exported the workspace, i've imported it to the new environment (on apex_admin mode). Next step was to get into my application's workspace and export it, Then I've imported my app to the new workspace just created. With SQL Developer i've exported all the tables and then I've created them in the new machine.

      All with no errors.
      Then I've tried to run my app. First thing i notice is that it doesn't ask for a user and password. That mean i didn't know how to import users?

      The errors i get are:

      Error processing authorization.
      ORA-06550: line 11, column 19: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 10, column 14: PL/SQL: SQL Statement ignored ORA-06550: line 14, column 18: PLS-00364: loop index variable 'C1' use is invalid ORA-06550: line 14, column 4: PL/SQL: Statement ignored ORA-06550: line 15, column 14: PLS-00364: loop index variable 'C1' use is invalid ORA-06550: line 15, column 4: PL/SQL: Statement ignored ORA-06550: line 23, column 19: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line
      Technical Info (only visible for developers)
      is_internal_error: true
      apex_error_code: APEX.AUTHORIZATION.UNHANDLED_ERROR
      ora_sqlcode: -6550
      ora_sqlerrm: ORA-06550: line 11, column 19: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 10, column 14: PL/SQL: SQL Statement ignored ORA-06550: line 14, column 18: PLS-00364: loop index variable 'C1' use is invalid ORA-06550: line 14, column 4: PL/SQL: Statement ignored ORA-06550: line 15, column 14: PLS-00364: loop index variable 'C1' use is invalid ORA-06550: line 15, column 4: PL/SQL: Statement ignored ORA-06550: line 23, column 19: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line
      component.type: APEX_APPLICATION_AUTHORIZATION
      component.id: 11672738986893340
      component.name: access control - view
      error_backtrace:
      ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926
      ORA-06512: at "SYS.WWV_DBMS_SQL", line 973
      ORA-06512: at "SYS.WWV_DBMS_SQL", line 999
      ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 773
      ORA-06512: at "APEX_040200.WWV_FLOW_AUTHORIZATION", line 80
      ORA-06512: at "APEX_040200.WWV_FLOW_AUTHORIZATION", line 160
      ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN", line 1922
      ORA-06512: at "APEX_040200.WWV_FLOW_AUTHORIZATION", line 411

      Please help me understand what i didn't do or what I do wrong.

      Thank you.

      Best regards,
      Gabriel