This discussion is archived
4 Replies Latest reply: Feb 10, 2013 9:03 AM by KamilJackiewicz RSS

Error running WCS 11.1.1.6.0 JSK

948133 Newbie
Currently Being Moderated
Hi all,

We don't manage to run the WCS jump start kit. The installation seems to work correctly, no error is thrown, but every time we launch the jump start kit we get the next error:

2013-01-15 11:03:07,653 ERROR [com.fatwire.logging.cs] - <Exception processing CatalogManager request> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnection
Factory (error in script file line: 13814 org.hsqldb.HsqlException: Violation of unique constraint SYS_PK_244: duplicate value(s) for column(s) ID)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.fatwire.cs.core.db.DataSourceBackedPool.acquire(DataSourceBackedPool.java:47)
at COM.FutureTense.Servlet.JDBCConn.Ping_trans(JDBCConn.java:291)
at COM.FutureTense.Servlet.JDBCConn.Ping(JDBCConn.java:274)
at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:1122)
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:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.fatwire.cs.core.logging.context.filter.ContextHeaderFilter.doFilterWork(ContextHeaderFilter.java:37)
at com.fatwire.cs.core.logging.context.filter.RunOncePerRequestFilter.doFilter(RunOncePerRequestFilter.java:54)
at com.fatwire.cs.core.logging.context.filter.HttpFilter.doFilter(HttpFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:557)
at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
          
Caused by: java.sql.SQLException: error in script file line: 13814 org.hsqldb.HsqlException: Violation of unique constraint SYS_PK_244: duplicate value(s) for column(s) ID
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 31 more

It's a new clean installation. We install the JSK following the readme.txt instructions.

¿Is this a known error? ¿Is there any incompatibility with any other app or OS version? We are running on windows XP.

thanks & regards

Jon MIkel

Edited by: 945130 on Jan 15, 2013 3:00 AM

Edited by: 945130 on Jan 15, 2013 3:01 AM

Edited by: 945130 on Jan 15, 2013 3:07 AM
  • 1. Re: Error running WCS 11.1.1.6.0 JSK
    528802 Newbie
    Currently Being Moderated
    I have the same problems. But now it has been fixed: when you install, pls leave all things as default, do not check the configuration after finished installation. That's would be OK. Goold luck.
  • 2. Re: Error running WCS 11.1.1.6.0 JSK
    KamilJackiewicz Newbie
    Currently Being Moderated
    Hi, the same errors appear in my console ... I have both instalations of WCS: jsk11gR1 and jsk11gR1BP1 and for both of them I am not able to run server with configuration of FirstSiteII and avisports...
    Maybe they are sharing the same tablaspace in memory database, so the rows are duplicated? can I flush in some way this HSQL database?
  • 3. Re: Error running WCS 11.1.1.6.0 JSK
    528802 Newbie
    Currently Being Moderated
    Hi, pls go to check the logs in Sites\11.1.1.6.1\logs. And look what exception occurred. If those data rows are duplicated, pls try to remove all things again, and install jsk step by step, make sure as default settings. When completed installation, then start the JSK bat, it will popup a configuration dialog, then you can select fistsiteII & avisports, after completed this, pls try again. good luck
  • 4. Re: Error running WCS 11.1.1.6.0 JSK
    KamilJackiewicz Newbie
    Currently Being Moderated
    Finally I found the reason.

    JSK loads the DB using a script which you can locate under<<jsk home>>\App_Server\apache-tomcat-6.0.32\default\data\hypersonic as "csDB.script". The standard port for JSK is 8080 and with this port everything is fine. But when I changed the port to e.g. 8380, installer replaced all instances of 8080 to 8380 in hypersonic DB script.

    To avoid this situation please do following steps:

    1. firstly you need to configure your JSK with default 8080 port.
    2. take a backup of <<jsk home>>\App_Server\apache-tomcat-6.0.32\default\data\hypersonic\csDB.script
    3. now you can change port to e.g. 8380 in configuration UI
    4. before starting the server, you need to modify archived script. I've found only one line with port settings, which needs to be adjusted:
    INSERT INTO SYSTEMSATELLITE VALUES(1351276284801,'Installer registered co-resident Satellite Engine','http','localhost',8080,'/cs/Satellite','/cs/FlushServer','/cs/Inventory','/cs/Pastrami','SatelliteServer','675286278df204915f228fd298c09388')
    5. replace the original file with the fixed one
    6. run app server

    Edited by: Kamil Jackiewicz on 2013-02-10 09:00

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points