This discussion is archived
3 Replies Latest reply: Oct 29, 2012 2:51 AM by PravinChikhale RSS

Setting instance configuration. from Dev Studio

SunilN Newbie
Currently Being Moderated
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
    PravinChikhale Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    PravinChikhale Explorer
    Currently Being Moderated
    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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               

Legend

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