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.
by AbdulMateen Moghal
Posted on Thu, 02/13/2014 - 11:44

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

0
by Marcus Campos
Posted on Tue, 09/29/2015 - 13:30

Hi,

Did you fix this?

 

Regards,

Marcus Campos

0

Featured achievement

Genius
You like to help others solve their problems by answering questions.
Recent Unlocks
  • KF
  • KH
  • RG
  • Profile picture for user Vee_ARIS
  • Profile picture for user smarty
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock