3 Replies Latest reply: Jul 5, 2012 1:29 AM by em200281 RSS

    APEXExport - unexpected error for 2 Workspaces when trying to export

    556459
      Hi all,

      Have been using APEXExport for a couple of years to back up our Apps from numerous workspaces to subversion and it works great. Hoever, recently added two new workspaces and getting a really strange error:
      java oracle.apex.APEXExport -db <servername>:1521:<RAC instance>-user <schema_user> -password <password>-workspaceid <workspace ID>
      Exporting Application 100:'TESTING'
      Exception in thread "main" java.sql.SQLException: ORA-20987: APEX - Application 100 not found logged in as database user <schema_user>. - Contact your application administrator.
      ORA-06512: at "APEX_040100.WWV_FLOW_ERROR", line 752
      ORA-06512: at "APEX_040100.WWV_FLOW_ERROR", line 1064
      ORA-06512: at "APEX_040100.WWV_FLOW_UTILITIES", line 8902
      ORA-06512: at line 1

      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
      at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:242)
      at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:554)
      at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1478)
      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:888)
      at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2076)
      at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1986)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2697)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:457)
      at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:531)
      at oracle.apex.APEXExport.ExportFile(APEXExport.java:165)
      at oracle.apex.APEXExport.ExportFiles(APEXExport.java:125)
      at oracle.apex.APEXExport.main(APEXExport.java:314)

      The strange thing is that APPLICATION 100 that its objecting to does not exist in that workspace at all! All the other exports work fine.

      Anyone got any bright ideas? We are on APEX 4.1, Oracle 11.0.1.0.7.

      All help gratefully received!

      Thanks,

      Jeremy