1 Reply Latest reply on Mar 18, 2005 2:42 PM by clebert.suconic

    configuring the benchmarking tool

    malinims

      Hello all,
      i have a doubt with configuring the benchmarking driver script
      I am using Jboss 4.0.1 and specj2002.
      When i run the script with a Ir (txrate)rate of 20 and runMfg,runOrderEntry all 2,I get the follwoing error at Jboss console&script fails

      jboss log--
      18:40:17,984 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534)
      18:40:17,988 INFO [STDOUT] javax.ejb.EJBException: null; CausedByException is:
      null; CausedByException is:
      Failed to create instances: Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections"); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections")); CausedByException is:
      Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections"); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections")); CausedByException is:
      Failed to create instances: Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections"); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections")); CausedByException is:
      Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections"); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections")); CausedByException is:
      null; CausedByException is:
      Failed to create instances: Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections"); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections")); CausedByException is:
      Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections"); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections")); CausedByException is:
      Failed to create instances: Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections"); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections")); CausedByException is:
      Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections"); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections"))
      18:40:18,006 INFO [STDOUT] at org.spec.jappserver.mfg.workorderent.ejb.WorkOrderCmp20EJB.process(WorkOrderCmp20EJB.java:551)
      ------------------------------------------------------------
      Sameway if i try with some lower vaues of txrate(10 or less than 10),i get all specj reporst generated.BUt the jboss show the following error logs.Still The report files look fine.It shows few order related processes failed.But report files are fine.
      jboss log--

      18:45:18,966 ERROR [LogInterceptor] TransactionRolledbackLocalException in method: public abstract org.spec.jappserver.util.helper.SequenceBlock org.spec.jappserver.util.sequenceent.ejb.SequenceEntLocal.nextSequenceBlock(), causedBy:
      org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=kaveri.kovaiteam.com/256, BranchQual=, localId=256] status=STATUS_NO_TRANSACTION; - nested throwable: (javax.ejb.EJBException: Expected one updated row but got: 0)
      at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:344)
      at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:454)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:367)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:146)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:123)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
      ..
      ..
      at java.lang.Thread.run(Thread.java:534)
      Caused by: javax.ejb.EJBException: Expected one updated row but got: 0
      at org.jboss.ejb.plugins.cmp.jdbc2.schema.EntityTable$1.executeUpdate(EntityTable.java:1692)
      at org.jboss.ejb.plugins.cmp.jdbc2.schema.EntityTable.update(EntityTable.java:702)
      at org.jboss.ejb.plugins.cmp.jdbc2.schema.EntityTable.access$1800(EntityTable.java:58)
      at org.jboss.ejb.plugins.cmp.jdbc2.schema.EntityTable$View.flushUpdated(EntityTable.java:1158)
      at org.jboss.ejb.plugins.cmp.jdbc2.schema.Schema.flush(Schema.java:184)
      at org.jboss.ejb.plugins.cmp.jdbc2.schema.Schema$SchemaSynchronization.beforeCompletion(Schema.java:240)
      at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1383)
      at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1075)
      at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:296)
      ... 109 more


      So what does it mean.Does it mean my server can allow only Ir rates less than 10.What does it actually imply with the performace.What is the cause of second case.eventho i get reports i get errors&some tests failed.Does it need any configuration change?/


      Thanks
      ms