3 Replies Latest reply: Oct 29, 2012 4:51 AM by Pravin Chikhale RSS

    Setting instance configuration. from Dev Studio

    SunilN
      Hi All,

      I am struggling with instance setting from developer studio, I have set host name and port from Tool>IAP Workbench Setting option.
      Please find the error detail.

      Setting instance configuration..
      Endeca parsing resource: Hibernate error: could not get or update next value
      IAP workbench Status: RUNNING

      Please share with your experience if any one faced this before.

      Thanks,
      Sunil N
        • 1. Re: Setting instance configuration. from Dev Studio
          Pravin Chikhale
          Hi Sunil,

          Check webstudio.log and cataline.out for more detailed error log.
          Also it would be helpful to rectify this issue if you post it on this thread.

          Thanks,
          Pravin.
          • 2. Re: Setting instance configuration. from Dev Studio
            SunilN
            Hi Pravin,

            I am getting this exception on webstudio.log file.

            java.sql.SQLException: An SQL data change is not permitted for a read-only connection, user or database.
                 at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
                 at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
                 at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
                 at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
                 at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
                 at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
                 at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
                 at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
                 at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
                 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
                 at org.hibernate.id.TableGenerator.doWorkInCurrentTransaction(TableGenerator.java:156)
                 at org.hibernate.engine.TransactionHelper$1Work.doWork(TransactionHelper.java:38)
                 ... 52 more
            Caused by: java.sql.SQLException: An SQL data change is not permitted for a read-only connection, user or database.
                 at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
                 at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
                 ... 64 more

            2012-10-25 08:17:26,569 WARN com.endeca.manager.web.SetAppConfigServlet:120 - Error parsing resource: Hibernate error: could not get or update next value
            com.endeca.manager.ConfigStoreException: Error parsing resource: Hibernate error: could not get or update next value
                 at com.endeca.manager.core.ConfigStore.validate(ConfigStore.java:143)
                 at com.endeca.manager.core.ConfigStore.setResources(ConfigStore.java:75)
                 at com.endeca.manager.web.SetAppConfigServlet.processRequest(SetAppConfigServlet.java:103)
                 at com.endeca.manager.web.ManagerServlet.doPost(ManagerServlet.java:117)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
                 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 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
                 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
                 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
                 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
                 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
                 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567)
                 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
                 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
                 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
                 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
                 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
                 at java.lang.Thread.run(Thread.java:619)

            Any idea on this.

            Thank,
            Sunil
            • 3. Re: Setting instance configuration. from Dev Studio
              Pravin Chikhale
              Check for the permission for the windows user for modifying configuration on workbench. It looks like this user has only read only permission.

              If Endeca setup is on linux machine try giving read-write permission to user.
              chmod +x <endeca_install_dir>/*
              HTH

              --Pravin