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.I have the same problem:-( I suspect this is an error on my part as I'm still learning! Here is my setup...
1) Linux RH ES 6
2) Oracle 11g with JDBC_6 driver
3) ARIS 7.2.4.784319 (same on 7.2.5)
Business Server & Publisher start and stop, accessing thru WEB is all good too. No indication of a problem in any logs.
After you attempt Publish, it will fail with above error showing in catalina.out.
Any database will cause this so I've got something fundamentally wrong!!!
If you stop Business Publisher, it will not come up again - fails during clean up of failed exports. I have to wipe out the Business Publisher database to bring it up again.
I think this is key: "Caused by: com.idsscheer.aris.businesspublisher.application.dao.util.ADAOSystemException: Error on retrieving all table names beginning with table prefix E1_"
Please help...
Mo