1 Reply Latest reply: Feb 27, 2012 12:51 AM by 920105 RSS

    Export Failure from Publisher Export Wizard in BPA 11gR1

    806900
      Hi Gurus,

      I had a problem with export from BPA.

      Procedures to reproduce the problem:

      1. Start BPA (as shown in snapshots)
      2. Select Administration in Modules panel
      3. In Navigation window, select Oracle BPA Suite Network->Publish->Publisher Server->devbppub
      4.Click New icon to start Publisher Export Wizard
      5.Add James in Name field and select ASIC Development (logged in) in Database field, click Next button
      6.In "2.Select version and reference" windows, click next
      7.In "3. Select representation options" windows, add Profile1 in Profiles field and select No template in Templates field, then click Next botton
      8. In"4. Select languanges and filter" windows, select "Use alternative language of the database" and select No filter in Evaluation filter, then click Next button
      9. In"5.Select method filter" window, select all Method filters, then click Next button
      10. In "6. Select object information" windows, tick Output object information, then click Next button
      11. In"7. Select layout" window, select default in Layout field, then click Next button
      12. In"8. Summary" , click Finish
      13. display "Creating export...."
      14. display "The procedure was canceled", click OK button. then display "Unable to create export", click Ok, then system was back to snapshot 1 as attached.

      Log information:

      <19/10/2010 12:18:54 PM EST> <Warning> <HTTP> <BEA-101162> <User defined listener com.idsscheer.aris.businesspublisher.application.web.listener.AHttpSessionListener failed: java.lang.NullPointerException.
      java.lang.NullPointerException
      at com.idsscheer.aris.businesspublisher.application.web.listener.AHttpSessionListener.sessionDestroyed(AHttpSessionListener.java:110)
      at weblogic.servlet.internal.EventsManager.notifySessionLifetimeEvent(EventsManager.java:276)
      at weblogic.servlet.internal.session.SessionData.remove(SessionData.java:1779)
      at weblogic.servlet.internal.session.MemorySessionContext.invalidateSession(MemorySessionContext.java:69)
      at weblogic.servlet.internal.session.SessionData.invalidate(SessionData.java:1591)
      Truncated. see log file for complete stacktrace
      >
      <19/10/2010 12:18:54 PM EST> <Notice> <LoggingService> <BEA-320400> <The log file E:\opt\app\wls\user_projects\domains\bpapub_domain\servers\AdminServer\logs\AdminServer.log will be rotated. Reopen the log file if tailing has stopped. This can happen on some platforms like Windows.>
      <19/10/2010 12:18:54 PM EST> <Notice> <LoggingService> <BEA-320401> <The log file has been rotated to E:\opt\app\wls\user_projects\domains\bpapub_domain\servers\AdminServer\logs\AdminServer.log08801. Log messages will continue to be logged in E:\opt\app\wls\user_projects\domains\bpapub_domain\servers\AdminServer\logs\AdminServer.log.>
      IT_12bc211e91c_INFO 2010-10-19T12:19:35,196 Output - Get export information of server: DEVBPREPOSIT.a1.asic.gov.au
      IT_12bc2126978_INFO 2010-10-19T12:20:08,56 Output - Get export information of export: Test
      <19/10/2010 12:21:38 PM EST> <Notice> <LoggingService> <BEA-320400> <The log file E:\opt\app\wls\user_projects\domains\bpapub_domain\servers\AdminServer\logs\AdminServer.log will be rotated. Reopen the log file if tailing has stopped. This can happen on some platforms like Windows.>
      <19/10/2010 12:21:38 PM EST> <Notice> <LoggingService> <BEA-320401> <The log file has been rotated to E:\opt\app\wls\user_projects\domains\bpapub_domain\servers\AdminServer\logs\AdminServer.log09647. Log messages will continue to be logged in E:\opt\app\wls\user_projects\domains\bpapub_domain\servers\AdminServer\logs\AdminServer.log.>
      IT_12bc213cc16_SEVERE 2010-10-19T12:21:38,838 Error - com.idsscheer.aris.businesspublisher.application.dao.ADAOSystemFacade.computeStatistics
      Version 7.1.0.403493
      com.idsscheer.aris.businesspublisher.application.dao.ADAOException: ADAOException
      at com.idsscheer.aris.businesspublisher.application.dao.ADAOSystemFacade.computeStatistics(ADAOSystemFacade.java:182)
      at com.idsscheer.aris.businesspublisher.corba.idl.impl.ABPExportNew.finishExport(ABPExportNew.java:212)
      at com.idsscheer.aris.businesspublisher.corba.idl.impl.ABPDataTransferImpl.writeChunkTerminated(ABPDataTransferImpl.java:292)
      at com.idsscheer.aris.businesspublisher.corba.idl.transfer.IBPDataTransferPOA._OB_op_writeChunkTerminated(IBPDataTransferPOA.java:220)
      at com.idsscheer.aris.businesspublisher.corba.idl.transfer.IBPDataTransferPOA._invoke(IBPDataTransferPOA.java:127)
      at com.ooc.OBPortableServer.ServantDispatcher.dispatch(Unknown Source)
      at com.ooc.OBPortableServer.POA_impl._OB_dispatch(Unknown Source)
      at com.ooc.OB.DispatchRequest_impl.invoke(Unknown Source)
      at com.ooc.OB.DispatchSameThread_impl.dispatch(Unknown Source)
      at com.ooc.OB.Upcall.invoke(Unknown Source)
      at com.ooc.OB.GIOPConnectionThreaded.execReceive(Unknown Source)
      at com.ooc.OB.GIOPConnectionThreaded$ReceiverThread.run(Unknown Source)
      Caused by: com.idsscheer.aris.businesspublisher.application.dao.util.ADAOSystemException: Error on computing statistics
      at com.idsscheer.aris.businesspublisher.application.dao.database.AOracleDatabaseDAO.computeStatistics(AOracleDatabaseDAO.java:354)
      at com.idsscheer.aris.businesspublisher.application.dao.ADAOSystemFacade.computeStatistics(ADAOSystemFacade.java:180)
      ... 11 more
      Caused by: java.sql.SQLException: ORA-25153: Temporary Tablespace is Empty
      ORA-06512: at "SYS.DBMS_STATS", line 18408
      ORA-06512: at "SYS.DBMS_STATS", line 18429
      ORA-06512: at line 1

      at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
      at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
      at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
      at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)

      Any adivce will be welcome!

      Thanks in adrance

      James
        • 1. Re: Export Failure from Publisher Export Wizard in BPA 11gR1
          920105
          Hello, I am also facing the same problem. I am getting the different error as below. However, I can publish as a HTML Export


          error---------------------------------------------------------------
          IT_135bd0d3c58_SEVERE 2012-02-27T15:24:15,704 BPError - .
          QuickStart: CreateExportException: IDL:transfer/CreateExportException:1.0 cannot process records: cannot write CLOB data into character output string.

          IT_135bd0d3c58_SEVERE 2012-02-27T15:24:15,704 BPError - .
          QuickStart: CreateExportException: IDL:transfer/CreateExportException:1.0 cannot process records: cannot write CLOB data into character output string.

          IT_135bd0d3c58_SEVERE 2012-02-27T15:24:15,704 BPError - .
          QuickStart: Rollback export triggered from external

          IT_135bd0d7d35_INFO 2012-02-27T15:24:32,309 Output - Remove method from cache for export: QuickStart - dd838074-ac29-11d4-85b8-00005a4053ff
          IT_135bd0dc58f_INFO 2012-02-27T15:24:50,831 Output - Get export informations of database: OBPA Release 11 Quick Start
          IT_135bd0deacb_INFO 2012-02-27T15:25:00,363 Output - Get export informations of database: OBPA Release 11 Quick Start
          IT_135bd0e46c5_INFO 2012-02-27T15:25:23,909 Output - Get export information of export: quickStart
          IT_135bd0e46d5_INFO 2012-02-27T15:25:23,925 Output - Get export information of server: Somashekhar.cochlear.com
          IT_135bd0fa345_SEVERE 2012-02-27T15:26:53,125 BPError - com.idsscheer.aris.businesspublisher.application.dao.attr.AOLiteDbAttrDAO.writeClobValue
          NO MESSAGE AVAILABLEcom.idsscheer.aris.businesspublisher.application.dao.util.ADAOSystemException: cannot write CLOB data into character output string.
               at com.idsscheer.aris.businesspublisher.application.dao.attr.AOLiteDbAttrDAO.writeClobValue(Unknown Source)
               at com.idsscheer.aris.businesspublisher.application.dao.attr.AOLiteDbAttrDAO.insertTextAttr(Unknown Source)
               at com.idsscheer.aris.businesspublisher.application.dao.AOLiteBatchSimInserter.addTextAttr(Unknown Source)
               at com.idsscheer.aris.businesspublisher.application.dao.AOLiteBatchSimInserter.add(Unknown Source)
               at com.idsscheer.aris.businesspublisher.application.dao.util.ATableWriter.addToBatch(Unknown Source)
               at com.idsscheer.aris.businesspublisher.application.dao.util.AAttrTableWriter.addToBatch(Unknown Source)
               at com.idsscheer.aris.businesspublisher.application.dao.util.ATableWriter.write(Unknown Source)
               at com.idsscheer.aris.businesspublisher.corba.idl.impl.ARecordInsertWriterBase.writeRecord(Unknown Source)
               at com.idsscheer.aris.businesspublisher.corba.idl.impl.ABPExportNew.processRecords(Unknown Source)
               at com.idsscheer.aris.businesspublisher.corba.idl.impl.ABPDataTransferImpl.writeRecordsOfSameTableTypeNum(Unknown Source)
               at com.idsscheer.aris.businesspublisher.corba.idl.impl.ABPDataTransferImpl.writeChunk(Unknown Source)
               at com.idsscheer.aris.businesspublisher.corba.idl.transfer.IBPDataTransferPOA._OB_op_writeChunk(Unknown Source)
               at com.idsscheer.aris.businesspublisher.corba.idl.transfer.IBPDataTransferPOA._invoke(Unknown Source)
               at com.ooc.OBPortableServer.ServantDispatcher.dispatch(Unknown Source)
               at com.ooc.OBPortableServer.POA_impl._OB_dispatch(Unknown Source)
               at com.ooc.OB.DispatchRequest_impl.invoke(Unknown Source)
               at com.ooc.OB.DispatchSameThread_impl.dispatch(Unknown Source)
               at com.ooc.OB.Upcall.invoke(Unknown Source)
               at com.ooc.OB.GIOPConnectionThreaded.execReceive(Unknown Source)
               at com.ooc.OB.GIOPConnectionThreaded$ReceiverThread.run(Unknown Source)
          Caused by: java.lang.IllegalArgumentException: object is not an instance of declaring class
               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
               at java.lang.reflect.Method.invoke(Method.java:597)
               ... 20 more
          -----------------------------------------------------------------------------------------------------