JB

Hi, guys. how are u?

 

I'm working with Aris Business Server Business Publisher 7.2, Oracle Database 11g.

I'm trying to Export Aris Architect but the following error it displays "The procedure was canceled".

I was looked at Business Publisher log file(stderr, stdout).

The log file said follow below:

IT_13ed04cbbc6_SEVERE  2013-05-23T16:31:29,862 BPError - com.idsscheer.aris.businesspublisher.application.dao.ADAOSystemFacade.computeStatistics
NO MESSAGE AVAILABLEcom.idsscheer.aris.businesspublisher.application.dao.ADAOException: ADAOException
        at com.idsscheer.aris.businesspublisher.application.dao.ADAOSystemFacade.computeStatistics(Unknown Source)
        at com.idsscheer.aris.businesspublisher.corba.idl.impl.ABPExportNew.finishExportStep1(Unknown Source)
        at com.idsscheer.aris.businesspublisher.corba.idl.impl.ABPDataTransferImpl.writeChunkTerminated(Unknown Source)
        at com.idsscheer.aris.businesspublisher.corba.idl.transfer.IBPDataTransferPOA._OB_op_writeChunkTerminated(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: com.idsscheer.aris.businesspublisher.application.dao.util.ADAOSystemException: Error on retrieving all table names beginning with table prefix E10_
        at com.idsscheer.aris.businesspublisher.application.dao.util.ADAOUtils.translateException(Unknown Source)
        at com.idsscheer.aris.businesspublisher.application.dao.util.ADAOUtils.translateException(Unknown Source)
        at com.idsscheer.aris.businesspublisher.application.dao.database.AOracleDatabaseDAO.getExportTableNames(Unknown Source)
        at com.idsscheer.aris.businesspublisher.application.dao.database.AOracleDatabaseDAO.computeStatistics(Unknown Source)
        ... 12 more
Caused by: org.springframework.jdbc.BadSqlGrammarException: Error on retrieving
all table names beginning with table prefix E10_; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

        at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        ... 16 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
        ... 14 more

IT_13ed04cbbcb_SEVERE  2013-05-23T16:31:29,867 BPError - .
ExportTest01: CreateExportException: IDL:transfer/CreateExportException:1.0 ADAOExcept
ion

IT_13ed04cbbcd_SEVERE  2013-05-23T16:31:29,869 BPError - .
ExportTest01: Rollback export triggered from external

IT_13ed04cbbde_SEVERE  2013-05-23T16:31:29,886 BPError - .
ExportTest01: CreateExportException: ADAOException

I upload above log file.

Can you help me? Please.
Tags: ARIS Business Publisher