Application Development Software

I've been having an issue installing the delivery instance. The verification part works but further down the install at about the 96% mark - it fails. Included below is the exception I get from the install logs.

Software Details:
DB: Oracle 11g R2
CS: WCS 11G r1
OS: Redhat 5.7


* The installer seems to create all the other tables, but fails at the below point. I've tried re-installing, clearing up the db etc, but it seems to fail at the same point each time.




[2012-06-12 23:38:41,818] [INFO ] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.xml] GatorInstall: CS Direct Advantage already installed (atm/advcols).
[2012-06-12 23:38:41,821] [INFO ] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.xml] GatorInstall: CS Direct Advantage Base already installed (assets).
[2012-06-12 23:38:41,821] [INFO ] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.xml] GatorInstall: CS Direct Advantage AdvCols already installed (assets).
[2012-06-12 23:38:41,822] [INFO ] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.xml] GatorInstall: ##SUCCESS##
[2012-06-12 23:38:41,949] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] SQLException executing query: SELECT id,description,connectionclassname FROM VMACCESSMETHOD
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4692)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4825)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1913)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at weblogic.jdbc.wrapper.Statement.execute(Statement.java:485)
at COM.FutureTense.Servlet.JDBCConn.ExecuteQuery_trans(JDBCConn.java:983)
at COM.FutureTense.Servlet.JDBCConn.ExecuteQuery(JDBCConn.java:611)
at COM.FutureTense.Common.ftDBTable.doSQL(ftDBTable.java:2189)
at COM.FutureTense.CatalogManager.CatalogEngine.runSQL(CatalogEngine.java:2730)
at COM.FutureTense.CatalogManager.CatalogEngine._queryAndCache(CatalogEngine.java:4939)
at COM.FutureTense.CatalogManager.CatalogEngine.access$800(CatalogEngine.java:43)
at COM.FutureTense.CatalogManager.CatalogEngine$8.execute(CatalogEngine.java:4920)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:180)
at COM.FutureTense.CatalogManager.CatalogEngine._queryAndCacheTrans(CatalogEngine.java:4926)
at COM.FutureTense.CatalogManager.CatalogEngine.processSQL(CatalogEngine.java:4879)
at COM.FutureTense.Common.CS.SQL(CS.java:1104)
at COM.FutureTense.Common.CS.SQL(CS.java:1052)
at com.openmarket.visitor.data.AbstractPersistentObject.executeSQL(AbstractPersistentObject.java:1453)
at com.openmarket.visitor.data.AbstractPersistentObject.getObjectList(AbstractPersistentObject.java:1119)
at com.openmarket.visitor.data.PersistentVisitorDataConnection.getObjectWithPreload(PersistentVisitorDataConnection.java:3088)
at com.openmarket.visitor.data.PersistentVisitorDataConnection.getAccessMethod(PersistentVisitorDataConnection.java:336)
at com.openmarket.visitor.data.PersistentVisitorDataConnection.createAccessMethod(PersistentVisitorDataConnection.java:310)
at com.openmarket.visitor.seed.VisitorDataManager.worker(VisitorDataManager.java:334)
at com.openmarket.basic.seed.BaseSeed.endTag(BaseSeed.java:263)
at COM.FutureTense.XML.Template.DynTag.execute(DynTag.java:218)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
at COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365)
at COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
at COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3186)
at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2447)
at COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1895)
at COM.FutureTense.XML.Template.CallElement.execute(CallTag.java:253)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
at COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
at COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
at COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
at COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
at COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365)
at COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
at COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3186)
at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2447)
at COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1895)
at COM.FutureTense.Common.CS.CallElement(CS.java:1599)
at COM.FutureTense.Apps.Install.command.ReadURL.exec(ReadURL.java:169)
at COM.FutureTense.Apps.Install.command.Command.execute(Command.java:130)
at COM.FutureTense.Apps.Install.server.InstallManager.invokeCommand(InstallManager.java:479)
at COM.FutureTense.Apps.Install.server.InstallManager.execute(InstallManager.java:104)
at COM.FutureTense.Apps.Install.server.InstallServer.evalPage(InstallServer.java:123)
at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:453)
at COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129)
at COM.FutureTense.Servlet.FTServlet.doGet(FTServlet.java:53)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:557)
at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
[2012-06-12 23:38:41,950] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Failed to execute query SELECT id,description,connectionclassname FROM VMACCESSMETHOD for query DUMMYLIST
[2012-06-12 23:38:41,957] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO VMACCESSMETHOD (ID,DESCRIPTION,CONNECTIONCLASSNAME) VALUES (?,?,?)
ID = tx
DESCRIPTION = Access method for the connection to CommerceEngine
CONNECTIONCLASSNAME = com.openmarket.cscommerce.txvisdata.CommerceEngineConnection
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3674)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans_logic(JDBCTable.java:1367)
at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans(JDBCTable.java:1337)
at COM.FutureTense.Servlet.JDBCTable.executeUpdate(JDBCTable.java:1211)
at COM.FutureTense.Servlet.JDBCTable.AddRow(JDBCTable.java:943)
at COM.FutureTense.Common.ftDBTable.insertRow(ftDBTable.java:1271)
at COM.FutureTense.CatalogManager.CatalogEngine.addToTable_trans(CatalogEngine.java:820)
at COM.FutureTense.CatalogManager.CatalogEngine.addToTable(CatalogEngine.java:705)
at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:752)
at COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3338)
at COM.FutureTense.Common.CS.CatalogManager(CS.java:1501)
at COM.FutureTense.Common.CS.CatalogManager(CS.java:1456)
at com.openmarket.visitor.data.AbstractPersistentObject.callCatalogManager(AbstractPersistentObject.java:156)
at com.openmarket.visitor.data.AbstractPersistentObject.executeWrite(AbstractPersistentObject.java:1343)
at com.openmarket.visitor.data.AbstractPersistentObject.writeObject(AbstractPersistentObject.java:856)
at com.openmarket.visitor.data.PersistentVisitorDataConnection.createAccessMethod(PersistentVisitorDataConnection.java:315)
at com.openmarket.visitor.seed.VisitorDataManager.worker(VisitorDataManager.java:334)
at com.openmarket.basic.seed.BaseSeed.endTag(BaseSeed.java:263)
at COM.FutureTense.XML.Template.DynTag.execute(DynTag.java:218)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
at COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365)
at COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
at COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3186)
at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2447)
at COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1895)
at COM.FutureTense.XML.Template.CallElement.execute(CallTag.java:253)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
at COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
at COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
at COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
at COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
at COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365)
at COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
at COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3186)
at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2447)
at COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1895)
at COM.FutureTense.Common.CS.CallElement(CS.java:1599)
at COM.FutureTense.Apps.Install.command.ReadURL.exec(ReadURL.java:169)
at COM.FutureTense.Apps.Install.command.Command.execute(Command.java:130)
at COM.FutureTense.Apps.Install.server.InstallManager.invokeCommand(InstallManager.java:479)
at COM.FutureTense.Apps.Install.server.InstallManager.execute(InstallManager.java:104)
at COM.FutureTense.Apps.Install.server.InstallServer.evalPage(InstallServer.java:123)
at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:453)
at COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129)
at COM.FutureTense.Servlet.FTServlet.doGet(FTServlet.java:53)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:557)
at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
[2012-06-12 23:38:41,961] [ERROR] [.kernel.Default (self-tuning)'] [com.fatwire.logging.cs] Exception in visitordata.createaccessmethod endTag() in tag com.openmarket.visitor.seed.VisitorDataManager in page 'OpenMarket/Xcelerate/Installation/GatorCallGatorInstall' in element 'OpenMarket/Xcelerate/Installation/GatorVad' errno: -105 errdetail: 0
java.lang.Exception: Could not create access method tx
at com.openmarket.visitor.seed.VisitorDataManager.worker(VisitorDataManager.java:335)
at com.openmarket.basic.seed.BaseSeed.endTag(BaseSeed.java:263)
at COM.FutureTense.XML.Template.DynTag.execute(DynTag.java:218)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:122)
at COM.FutureTense.XML.Template.Root.execute(BlockTag.java:367)
at COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
at COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3186)
at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2447)
at COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1895)
at COM.FutureTense.XML.Template.CallElement.execute(CallTag.java:253)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:122)
at COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
at COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:122)
at COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
at COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:122)
at COM.FutureTense.XML.Template.Root.execute(BlockTag.java:367)
at COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
at COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3186)
at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2447)
at COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1895)
at COM.FutureTense.Common.CS.CallElement(CS.java:1599)
at COM.FutureTense.Apps.Install.command.ReadURL.exec(ReadURL.java:170)
at COM.FutureTense.Apps.Install.command.Command.execute(Command.java:130)
at COM.FutureTense.Apps.Install.server.InstallManager.invokeCommand(InstallManager.java:479)
at COM.FutureTense.Apps.Install.server.InstallManager.execute(InstallManager.java:104)
at COM.FutureTense.Apps.Install.server.InstallServer.evalPage(InstallServer.java:123)
at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:453)
at COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129)
at COM.FutureTense.Servlet.FTServlet.doGet(FTServlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:557)
at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
[2012-06-12 23:38:41,962] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.install] READURLProblem in CallElement. Error number=-105
[2012-06-12 23:40:05,871] [INFO ] [.kernel.Default (self-tuning)'] [logging.cs.cache.page] FW_InvalidationMemory table not found. Creating.

Edited by: user11174975 on 14-Jun-2012 17:28