Profile picture for user amoghal

Hello,

I’m suffering from an installation problem where I am unable to successfully publish. I’ve installed multiple times, on different machines, different releases but same problem so I know I’m doing something wrong:-( Business Server and Business Publisher both start and stop cleanly as I checked all the logs. When I publish to HTML it works fine. Publishing to server fails near the end with “The procedure was cancelled.” Here is my setup:

  • OS: Linux RH 2.6
  • Business Server: 7.2.4.759374 (and I’ve tried later 7.2.4 and 7.2.5)
  • Tomcat: 6.0.29, 6.0.37 or 6.0.39
  • Database: Oracle 11g

Right at the point of failure I see this in webapps/businesspublisher/log/core/issues/bpError-7.1.0.759374_0.log:

-----------------------------------------------------------------------------------------------------------------------

IT_14462a862f2_SEVERE  2014-02-24T09:50:06,450 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 E1_

        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 E1_; 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:96)

        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

        ... 14 more

 

 

IT_14462a862f3_SEVERE  2014-02-24T09:50:06,451 .

my test: CreateExportException: IDL:transfer/CreateExportException:1.0 ADAOException

-----------------------------------------------------------------------------------------------------------------------

All I’ve done is, install, import some database or try a new one with minimal objects and publish. Any help would be very much appreciated.

Thx Mo

by AbdulMateen Moghal Author
Posted on Mon, 03/03/2014 - 12:16

Anyone please....

Thx Mo

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • Profile picture for user frankweise
  • Profile picture for user Henrik Buckler
  • Profile picture for user UffeK
  • SS
  • MZ
  • 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