That version of SequoiaERP is based on a revision of OFBiz that is a
fair bit older. Is it an option to try a newer version of OFBiz?
Based on the limited information here you might be able to solve this
problem by increasing the JDBC connection pool size. In other words,
it may be running out of connections.
There were some problems a while back with the key sequencing, but I
don't know if those were in the S-ERP 0.8.3 release (my memory isn't
that good).
-David
On Aug 25, 2006, at 2:31 AM, Zaoui Bruno wrote:
Hi
I'm using SequoiaERP 0.83
-----Message d'origine-----
De : David E Jones [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 25 août 2006 10:29
À : [email protected]
Objet : [Spam][Spam]Re: Postgres : Lost connexion with my Postgres
Database while an EntitySync
Which version/revision of OFBiz are you using?
-David
On Aug 24, 2006, at 2:25 AM, Zaoui Bruno wrote:
Hello,
When I synchronize lot of data by EntitySync, the remote server
after a
while, lost his connexion to the database (see logs at the end of the
mail).
I've tried to increase the pool-maxsize of the entityengine.xml
file but
I keep my problem.
Could you please explain me what could happen?
Should I change the postgres configuration?
My config :
Postgres 8.0.1 under Linux Debian
I use
org.ofbiz.service.rmi.socket.zip.CompressionClientSocketFactory and
org.ofbiz.service.rmi.socket.zip.CompressionServerSocketFactory
entityengine.xml :
<inline-jdbc
jdbc-driver="org.postgresql.Driver"
jdbc-uri="jdbc:postgresql://xxx.xxx.xxx.xxx:5432/
TOTO"
jdbc-username="toto"
jdbc-password="toto"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="100"/>
1036559051[ ConnectionFactory.java:54 :ERROR] ******* ERROR: No
database connection found for helperName "localpostgres"
1036559052[ SequenceUtil.java:283:ERROR]
---- exception report
----------------------------------------------------------
General error in getting a sequenced ID
Exception: org.ofbiz.entity.GenericEntityException
Message: [SequenceUtil.SequenceBank.fillBank]: Unable to esablish a
connection with the database, connection was null...
---- stack trace
---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException:
[SequenceUtil.SequenceBank.fillBank]: Unable to esablish a connection
with the database, connection was null...
org.ofbiz.entity.util.SequenceUtil$SequenceBank.fillBank
(SequenceUtil.ja
va:187)
org.ofbiz.entity.util.SequenceUtil$SequenceBank.getNextSeqId
(SequenceUti
l.java:135)
org.ofbiz.entity.util.SequenceUtil.getNextSeqId(SequenceUtil.java:99)
org.ofbiz.entity.GenericDelegator.getNextSeqIdLong
(GenericDelegator.java
:2643)
org.ofbiz.entity.GenericDelegator.getNextSeqId
(GenericDelegator.java:257
9)
org.ofbiz.entity.GenericDelegator.getNextSeqId
(GenericDelegator.java:256
3)
org.ofbiz.entity.GenericDelegator.saveEntitySyncRemoveInfo
(GenericDelega
tor.java:687)
org.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:
841)
org.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:
808)
org.ofbiz.entityext.synchronization.EntitySyncServices.storeEntitySyn
c
Da
ta(EntitySyncServices.java:359)
sun.reflect.GeneratedMethodAccessor180.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessor
Impl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker
(StandardJavaE
ngine.java:101)
org.ofbiz.service.engine.StandardJavaEngine.runSync
(StandardJavaEngine.j
ava:63)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
339)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
213)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
110)
org.ofbiz.service.rmi.RemoteDispatcherImpl.runSync
(RemoteDispatcherImpl.
java:62)
sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessor
Impl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
sun.rmi.transport.Transport$1.run(Transport.java:148)
java.security.AccessController.doPrivileged(Native Method)
sun.rmi.transport.Transport.serviceCall(Transport.java:144)
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:
460)
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run
(TCPTransport.ja
va:701)
java.lang.Thread.run(Thread.java:534)
---------------------------------------------------------------------
-
--
--------
Thanks
Bruno
