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.