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
