[OFBiz] Users - Problems with Search queries ...
Locked
[OFBiz] Users - Problems with Search queries ...
 
|
Hi List,
I'm using the party manager and the search facility to track down users of the system resident in specific postcode areas. I have selected the 'Postal' option button and then put 'N' and a range of wildcards into the PartyPostalCode box. The wildcards that I'm using atm are *, $ and & but they all return zero results. I've tried this on Sequoia, a fairly recent svn and version 3.0 and it doesn't seem to work in any case. Are there wildcards that I'm not aware of? Has anyone else had any issues with this? Server environment is Debian Sarge, Postgres 7.3 (or default db in a couple of cases) and the workstation is W2K SP4 and Firefox Beta 2. I'll try it with IE and Opera this afternoon but wanted to make sure the wildcards were appropriate. Thanks and best wishes Ian _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: [OFBiz] Users - Problems with Search queries ...
|
|
Ian,
I don't know about OFBiz, but an Oracle system I used to work on used % as it's wildcard. That's what I call a "wild" card!!! Kind Regards -- Andrew Sykes <[hidden email]> Sykes Development Ltd _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: [OFBiz] Users - Problems with Search queries ...
|
|
Right now we aren't translating wild cards in general queries (we do in the product search queries to support the "*" and "?" wild cards). So, the wild cards are the default SQL wild cars: "%" to match any string, "_" (underscore) to match a single character. -David On Oct 27, 2005, at 9:59 AM, Andrew Sykes wrote: > Ian, > > I don't know about OFBiz, but an Oracle system I used to work on > used % > as it's wildcard. > > That's what I call a "wild" card!!! > > Kind Regards > -- > Andrew Sykes <[hidden email]> > Sykes Development Ltd > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
smime.p7s (3K)
Re: [OFBiz] Users - Problems with Search queries ...
|
|
Thanks for that. I don't think that it is working in the case of the
party manager for postcodes. I'll investigate more widely and submit a bug report. Best wishes Ian On Thu, October 27, 2005 5:15 pm, David E. Jones wrote: > > Right now we aren't translating wild cards in general queries (we do > in the product search queries to support the "*" and "?" wild cards). So, > the wild cards are the default SQL wild cars: "%" to match any string, "_" > (underscore) to match a single character. > > > -David > > > > On Oct 27, 2005, at 9:59 AM, Andrew Sykes wrote: > > >> Ian, >> >> >> I don't know about OFBiz, but an Oracle system I used to work on >> used % as it's wildcard. >> >> That's what I call a "wild" card!!! >> >> >> Kind Regards >> -- >> Andrew Sykes <[hidden email]> >> Sykes Development Ltd >> >> >> >> _______________________________________________ >> Users mailing list >> [hidden email] >> http://lists.ofbiz.org/mailman/listinfo/users >> >> > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: [OFBiz] Users - Problems with Search queries ...
|
|
If it isn't doing that I wouldn't call it a bug... It may be that it is doing an equals instead of a LIKE on the postal code. That should be pretty easy to change. -David On Oct 27, 2005, at 6:20 PM, Ian Gilbert wrote: > Thanks for that. I don't think that it is working in the case of the > party manager for postcodes. I'll investigate more widely and > submit a > bug report. > > Best wishes > > Ian > > On Thu, October 27, 2005 5:15 pm, David E. Jones wrote: > >> >> > > >> Right now we aren't translating wild cards in general queries (we do >> in the product search queries to support the "*" and "?" wild >> cards). So, >> the wild cards are the default SQL wild cars: "%" to match any >> string, "_" >> (underscore) to match a single character. >> >> >> -David >> >> >> >> On Oct 27, 2005, at 9:59 AM, Andrew Sykes wrote: >> >> >> >>> Ian, >>> >>> >>> I don't know about OFBiz, but an Oracle system I used to work on >>> used % as it's wildcard. >>> >>> That's what I call a "wild" card!!! >>> >>> >>> Kind Regards >>> -- >>> Andrew Sykes <[hidden email]> >>> Sykes Development Ltd >>> >>> >>> >>> _______________________________________________ >>> Users mailing list >>> [hidden email] >>> http://lists.ofbiz.org/mailman/listinfo/users >>> >>> >>> >> >> >> _______________________________________________ >> Users mailing list >> [hidden email] >> http://lists.ofbiz.org/mailman/listinfo/users >> > > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
[OFBiz] Users - JOTM / RMI problem
|
|
With the latest Sequoia build, I'm occasionally getting the error
below... Does anyone know what this is about and why it would be intermittent? ------------------------------------------------------------------ [java] 19988 (main) [ Jotm.java:129:INFO ] CAROL initialization [java] 20126 (main) [ Current.java:171:INFO ] Jotm version = 2.0.9 [java] org.ofbiz.base.start.StartupException: Cannot init() jotm- container (Unable to bind UserTransaction/TransactionManager to JNDI (null)) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer (ContainerLoader.java:152) [java] at org.ofbiz.base.container.ContainerLoader.load (ContainerLoader.java:74) [java] at org.ofbiz.base.start.Start.initStartLoaders (Start.java:257) [java] at org.ofbiz.base.start.Start.init(Start.java:96) [java] at org.ofbiz.base.start.Start.main(Start.java:412) [java] org.ofbiz.base.container.ContainerException: Unable to bind UserTransaction/TransactionManager to JNDI (null) [java] at org.ofbiz.jotm.container.JotmContainer.startJotm (JotmContainer.java:102) [java] at org.ofbiz.jotm.container.JotmContainer.init (JotmContainer.java:61) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer (ContainerLoader.java:150) [java] at org.ofbiz.base.container.ContainerLoader.load (ContainerLoader.java:74) [java] at org.ofbiz.base.start.Start.initStartLoaders (Start.java:257) [java] at org.ofbiz.base.start.Start.init(Start.java:96) [java] at org.ofbiz.base.start.Start.main(Start.java:412) [java] javax.naming.CommunicationException [Root exception is java.rmi.NoSuchObjectException: no such object in table] [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:133) [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:138) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.objectweb.carol.jndi.spi.ContextWrapper.rebind (ContextWrapper.java:185) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.objectweb.carol.jndi.enc.java.javaURLContext.rebind (javaURLContext.java:264) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.ofbiz.jotm.container.JotmContainer.startJotm (JotmContainer.java:100) [java] at org.ofbiz.jotm.container.JotmContainer.init (JotmContainer.java:61) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer (ContainerLoader.java:150) [java] at org.ofbiz.base.container.ContainerLoader.load (ContainerLoader.java:74) [java] at org.ofbiz.base.start.Start.initStartLoaders (Start.java:257) [java] at org.ofbiz.base.start.Start.init(Start.java:96) [java] at org.ofbiz.base.start.Start.main(Start.java:412) [java] Caused by: java.rmi.NoSuchObjectException: no such object in table [java] at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer (StreamRemoteCall.java:247) [java] at sun.rmi.transport.StreamRemoteCall.executeCall (StreamRemoteCall.java:223) [java] at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:350) [java] at sun.rmi.registry.RegistryImpl_Stub.rebind(Unknown Source) [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:131) [java] ... 13 more [java] org.ofbiz.base.container.ContainerException: Unable to bind UserTransaction/TransactionManager to JNDI (null) [java] at org.ofbiz.jotm.container.JotmContainer.startJotm (JotmContainer.java:102) [java] at org.ofbiz.jotm.container.JotmContainer.init (JotmContainer.java:61) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer (ContainerLoader.java:150) [java] at org.ofbiz.base.container.ContainerLoader.load (ContainerLoader.java:74) [java] at org.ofbiz.base.start.Start.initStartLoaders (Start.java:257) [java] at org.ofbiz.base.start.Start.init(Start.java:96) [java] at org.ofbiz.base.start.Start.main(Start.java:412) [java] javax.naming.CommunicationException [Root exception is java.rmi.NoSuchObjectException: no such object in table] [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:133) [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:138) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.objectweb.carol.jndi.spi.ContextWrapper.rebind (ContextWrapper.java:185) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.objectweb.carol.jndi.enc.java.javaURLContext.rebind (javaURLContext.java:264) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.ofbiz.jotm.container.JotmContainer.startJotm (JotmContainer.java:100) [java] at org.ofbiz.jotm.container.JotmContainer.init (JotmContainer.java:61) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer (ContainerLoader.java:150) [java] at org.ofbiz.base.container.ContainerLoader.load (ContainerLoader.java:74) [java] at org.ofbiz.base.start.Start.initStartLoaders (Start.java:257) [java] at org.ofbiz.base.start.Start.init(Start.java:96) [java] at org.ofbiz.base.start.Start.main(Start.java:412) [java] Caused by: java.rmi.NoSuchObjectException: no such object in table [java] at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer (StreamRemoteCall.java:247) [java] at sun.rmi.transport.StreamRemoteCall.executeCall (StreamRemoteCall.java:223) [java] at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:350) [java] at sun.rmi.registry.RegistryImpl_Stub.rebind(Unknown Source) [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:131) [java] ... 13 more [java] javax.naming.CommunicationException [Root exception is java.rmi.NoSuchObjectException: no such object in table] [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:133) [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:138) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.objectweb.carol.jndi.spi.ContextWrapper.rebind (ContextWrapper.java:185) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.objectweb.carol.jndi.enc.java.javaURLContext.rebind (javaURLContext.java:264) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.ofbiz.jotm.container.JotmContainer.startJotm (JotmContainer.java:100) [java] at org.ofbiz.jotm.container.JotmContainer.init (JotmContainer.java:61) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer (ContainerLoader.java:150) [java] at org.ofbiz.base.container.ContainerLoader.load (ContainerLoader.java:74) [java] at org.ofbiz.base.start.Start.initStartLoaders (Start.java:257) [java] at org.ofbiz.base.start.Start.init(Start.java:96) [java] at org.ofbiz.base.start.Start.main(Start.java:412) [java] Caused by: java.rmi.NoSuchObjectException: no such object in table [java] at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer (StreamRemoteCall.java:247) [java] at sun.rmi.transport.StreamRemoteCall.executeCall (StreamRemoteCall.java:223) [java] at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:350) [java] at sun.rmi.registry.RegistryImpl_Stub.rebind(Unknown Source) [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:131) [java] ... 13 more [java] Java Result: 99 ------------------------------------------------------------------ Thanks for your time. -- Andrew Sykes <[hidden email]> Sykes Development Ltd _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
RE: [OFBiz] Users - JOTM / RMI problem
|
|
I've got similar error once or twice with OFBiz. As I recall it, the cause was my software firewall blocking outgoing requests of java executable. </Firas> -----Original Message----- From: [hidden email] [mailto:[hidden email]] On Behalf Of Andrew Sykes Sent: den 28 oktober 2005 12:16 To: OFBiz Users / Usage Discussion Subject: [OFBiz] Users - JOTM / RMI problem With the latest Sequoia build, I'm occasionally getting the error below... Does anyone know what this is about and why it would be intermittent? ------------------------------------------------------------------ [java] 19988 (main) [ Jotm.java:129:INFO ] CAROL initialization [java] 20126 (main) [ Current.java:171:INFO ] Jotm version = 2.0.9 [java] org.ofbiz.base.start.StartupException: Cannot init() jotm- container (Unable to bind UserTransaction/TransactionManager to JNDI (null)) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer (ContainerLoader.java:152) [java] at org.ofbiz.base.container.ContainerLoader.load (ContainerLoader.java:74) [java] at org.ofbiz.base.start.Start.initStartLoaders (Start.java:257) [java] at org.ofbiz.base.start.Start.init(Start.java:96) [java] at org.ofbiz.base.start.Start.main(Start.java:412) [java] org.ofbiz.base.container.ContainerException: Unable to bind UserTransaction/TransactionManager to JNDI (null) [java] at org.ofbiz.jotm.container.JotmContainer.startJotm (JotmContainer.java:102) [java] at org.ofbiz.jotm.container.JotmContainer.init (JotmContainer.java:61) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer (ContainerLoader.java:150) [java] at org.ofbiz.base.container.ContainerLoader.load (ContainerLoader.java:74) [java] at org.ofbiz.base.start.Start.initStartLoaders (Start.java:257) [java] at org.ofbiz.base.start.Start.init(Start.java:96) [java] at org.ofbiz.base.start.Start.main(Start.java:412) [java] javax.naming.CommunicationException [Root exception is java.rmi.NoSuchObjectException: no such object in table] [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:133) [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:138) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.objectweb.carol.jndi.spi.ContextWrapper.rebind (ContextWrapper.java:185) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.objectweb.carol.jndi.enc.java.javaURLContext.rebind (javaURLContext.java:264) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.ofbiz.jotm.container.JotmContainer.startJotm (JotmContainer.java:100) [java] at org.ofbiz.jotm.container.JotmContainer.init (JotmContainer.java:61) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer (ContainerLoader.java:150) [java] at org.ofbiz.base.container.ContainerLoader.load (ContainerLoader.java:74) [java] at org.ofbiz.base.start.Start.initStartLoaders (Start.java:257) [java] at org.ofbiz.base.start.Start.init(Start.java:96) [java] at org.ofbiz.base.start.Start.main(Start.java:412) [java] Caused by: java.rmi.NoSuchObjectException: no such object in table [java] at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer (StreamRemoteCall.java:247) [java] at sun.rmi.transport.StreamRemoteCall.executeCall (StreamRemoteCall.java:223) [java] at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:350) [java] at sun.rmi.registry.RegistryImpl_Stub.rebind(Unknown Source) [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:131) [java] ... 13 more [java] org.ofbiz.base.container.ContainerException: Unable to bind UserTransaction/TransactionManager to JNDI (null) [java] at org.ofbiz.jotm.container.JotmContainer.startJotm (JotmContainer.java:102) [java] at org.ofbiz.jotm.container.JotmContainer.init (JotmContainer.java:61) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer (ContainerLoader.java:150) [java] at org.ofbiz.base.container.ContainerLoader.load (ContainerLoader.java:74) [java] at org.ofbiz.base.start.Start.initStartLoaders (Start.java:257) [java] at org.ofbiz.base.start.Start.init(Start.java:96) [java] at org.ofbiz.base.start.Start.main(Start.java:412) [java] javax.naming.CommunicationException [Root exception is java.rmi.NoSuchObjectException: no such object in table] [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:133) [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:138) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.objectweb.carol.jndi.spi.ContextWrapper.rebind (ContextWrapper.java:185) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.objectweb.carol.jndi.enc.java.javaURLContext.rebind (javaURLContext.java:264) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.ofbiz.jotm.container.JotmContainer.startJotm (JotmContainer.java:100) [java] at org.ofbiz.jotm.container.JotmContainer.init (JotmContainer.java:61) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer (ContainerLoader.java:150) [java] at org.ofbiz.base.container.ContainerLoader.load (ContainerLoader.java:74) [java] at org.ofbiz.base.start.Start.initStartLoaders (Start.java:257) [java] at org.ofbiz.base.start.Start.init(Start.java:96) [java] at org.ofbiz.base.start.Start.main(Start.java:412) [java] Caused by: java.rmi.NoSuchObjectException: no such object in table [java] at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer (StreamRemoteCall.java:247) [java] at sun.rmi.transport.StreamRemoteCall.executeCall (StreamRemoteCall.java:223) [java] at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:350) [java] at sun.rmi.registry.RegistryImpl_Stub.rebind(Unknown Source) [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:131) [java] ... 13 more [java] javax.naming.CommunicationException [Root exception is java.rmi.NoSuchObjectException: no such object in table] [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:133) [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:138) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.objectweb.carol.jndi.spi.ContextWrapper.rebind (ContextWrapper.java:185) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.objectweb.carol.jndi.enc.java.javaURLContext.rebind (javaURLContext.java:264) [java] at javax.naming.InitialContext.rebind (InitialContext.java:363) [java] at org.ofbiz.jotm.container.JotmContainer.startJotm (JotmContainer.java:100) [java] at org.ofbiz.jotm.container.JotmContainer.init (JotmContainer.java:61) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer (ContainerLoader.java:150) [java] at org.ofbiz.base.container.ContainerLoader.load (ContainerLoader.java:74) [java] at org.ofbiz.base.start.Start.initStartLoaders (Start.java:257) [java] at org.ofbiz.base.start.Start.init(Start.java:96) [java] at org.ofbiz.base.start.Start.main(Start.java:412) [java] Caused by: java.rmi.NoSuchObjectException: no such object in table [java] at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer (StreamRemoteCall.java:247) [java] at sun.rmi.transport.StreamRemoteCall.executeCall (StreamRemoteCall.java:223) [java] at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:350) [java] at sun.rmi.registry.RegistryImpl_Stub.rebind(Unknown Source) [java] at com.sun.jndi.rmi.registry.RegistryContext.rebind (RegistryContext.java:131) [java] ... 13 more [java] Java Result: 99 ------------------------------------------------------------------ Thanks for your time. -- Andrew Sykes <[hidden email]> Sykes Development Ltd _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
RE: [OFBiz] Users - JOTM / RMI problem
|
|
Firas,
That's interesting, I don't have any firewall software running, but I do have a rather dodgy VPN connection (PPTP). Perhaps it's causing some issue. Kind Regards -- Andrew Sykes <[hidden email]> Sykes Development Ltd _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
I also see this problem more frequently on Windows boxes than Linux boxes.
Brett On 10/28/05, Andrew Sykes <[hidden email]> wrote: > Firas, > > That's interesting, I don't have any firewall software running, but I do > have a rather dodgy VPN connection (PPTP). > > Perhaps it's causing some issue. > > Kind Regards > -- > Andrew Sykes <[hidden email]> > Sykes Development Ltd > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: [OFBiz] Users - JOTM / RMI problem
|
|
Brett,
I've only seen this 2 or 3 times on linux (FC3), I don't use windows much. Perhaps its something to do with the way RMI is doing ip resolution. About a year ago I was working on a box whose /etc/hosts file got mangled. I got a very similar error. It took ages to figure out what was going on. Perhaps there's config pointing to "localhost" that might be better pointed directly to "127.0.0.1". Kind Regards -- Andrew Sykes <[hidden email]> Sykes Development Ltd _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
RE: [OFBiz] Users - JOTM / RMI problem
|
|
In reply to this post by Andrew Sykes
I see the same RMI error occasionally on my Win XP machine when starting
Ofbiz. Usually, rebooting fixes it. However, the last time it happened, I did a netstat -a and saw that my machine was connecting port 1099 to our company mail server. I disabled my network connection, then re-enabled the connection. After that, netstat -a showed the connection to the mail server choose another port. Then I successfully started Ofbiz. Best regards, Rob Riggins Integral Business Solutions Roseville, MN, US -----Original Message----- From: [hidden email] [mailto:[hidden email]] On Behalf Of Andrew Sykes Sent: Friday, October 28, 2005 8:31 AM To: OFBiz Users / Usage Discussion Subject: Re: [OFBiz] Users - JOTM / RMI problem Brett, I've only seen this 2 or 3 times on linux (FC3), I don't use windows much. Perhaps its something to do with the way RMI is doing ip resolution. About a year ago I was working on a box whose /etc/hosts file got mangled. I got a very similar error. It took ages to figure out what was going on. Perhaps there's config pointing to "localhost" that might be better pointed directly to "127.0.0.1". Kind Regards -- Andrew Sykes <[hidden email]> Sykes Development Ltd _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
If you really can't get it to work just comment out the rmi dispatcher
in base/config/ofbiz-container.xml Si Robert Riggins wrote: >I see the same RMI error occasionally on my Win XP machine when starting >Ofbiz. Usually, rebooting fixes it. However, the last time it happened, >I did a netstat -a and saw that my machine was connecting port 1099 to >our company mail server. > >I disabled my network connection, then re-enabled the connection. After >that, netstat -a showed the connection to the mail server choose another >port. Then I successfully started Ofbiz. > >Best regards, >Rob Riggins >Integral Business Solutions >Roseville, MN, US > >-----Original Message----- >From: [hidden email] >[mailto:[hidden email]] On Behalf Of Andrew Sykes >Sent: Friday, October 28, 2005 8:31 AM >To: OFBiz Users / Usage Discussion >Subject: Re: [OFBiz] Users - JOTM / RMI problem > >Brett, > >I've only seen this 2 or 3 times on linux (FC3), I don't use windows >much. > >Perhaps its something to do with the way RMI is doing ip resolution. > >About a year ago I was working on a box whose /etc/hosts file got >mangled. I got a very similar error. It took ages to figure out what was >going on. > >Perhaps there's config pointing to "localhost" that might be better >pointed directly to "127.0.0.1". > >Kind Regards >-- >Andrew Sykes <[hidden email]> Sykes Development Ltd > > >_______________________________________________ >Users mailing list >[hidden email] >http://lists.ofbiz.org/mailman/listinfo/users > >_______________________________________________ >Users mailing list >[hidden email] >http://lists.ofbiz.org/mailman/listinfo/users > > > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
I have commented out the RMI service dispatcher in the past as well.
Recently we have started to use this service so we are looking into what is causing the problem. We don't see the problem on our Linux machines but on our windows machines the RMI service does not load. I'll post to the group when we find a workaround. Brett On 10/28/05, Si Chen <[hidden email]> wrote: > If you really can't get it to work just comment out the rmi dispatcher > in base/config/ofbiz-container.xml > > Si > > Robert Riggins wrote: > > >I see the same RMI error occasionally on my Win XP machine when starting > >Ofbiz. Usually, rebooting fixes it. However, the last time it happened, > >I did a netstat -a and saw that my machine was connecting port 1099 to > >our company mail server. > > > >I disabled my network connection, then re-enabled the connection. After > >that, netstat -a showed the connection to the mail server choose another > >port. Then I successfully started Ofbiz. > > > >Best regards, > >Rob Riggins > >Integral Business Solutions > >Roseville, MN, US > > > >-----Original Message----- > >From: [hidden email] > >[mailto:[hidden email]] On Behalf Of Andrew Sykes > >Sent: Friday, October 28, 2005 8:31 AM > >To: OFBiz Users / Usage Discussion > >Subject: Re: [OFBiz] Users - JOTM / RMI problem > > > >Brett, > > > >I've only seen this 2 or 3 times on linux (FC3), I don't use windows > >much. > > > >Perhaps its something to do with the way RMI is doing ip resolution. > > > >About a year ago I was working on a box whose /etc/hosts file got > >mangled. I got a very similar error. It took ages to figure out what was > >going on. > > > >Perhaps there's config pointing to "localhost" that might be better > >pointed directly to "127.0.0.1". > > > >Kind Regards > >-- > >Andrew Sykes <[hidden email]> Sykes Development Ltd > > > > > >_______________________________________________ > >Users mailing list > >[hidden email] > >http://lists.ofbiz.org/mailman/listinfo/users > > > >_______________________________________________ > >Users mailing list > >[hidden email] > >http://lists.ofbiz.org/mailman/listinfo/users > > > > > > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
RE: [OFBiz] Users - JOTM / RMI problem
|
|
In reply to this post by Andrew Sykes
Something I forgot to mention in my post about ports was that I found
which port the RMI dispatcher was trying to connect through by searching an older Ofbiz log that included a successful startup. I searched the older log for the RMI loading step. That gave me the port number it wanted. Then I looked in my machine's netstat output for that port and what was using it. Rob -----Original Message----- From: [hidden email] [mailto:[hidden email]] On Behalf Of Brett Palmer Sent: Friday, October 28, 2005 12:47 PM To: OFBiz Users / Usage Discussion Subject: Re: [OFBiz] Users - JOTM / RMI problem I have commented out the RMI service dispatcher in the past as well. Recently we have started to use this service so we are looking into what is causing the problem. We don't see the problem on our Linux machines but on our windows machines the RMI service does not load. I'll post to the group when we find a workaround. Brett On 10/28/05, Si Chen <[hidden email]> wrote: > If you really can't get it to work just comment out the rmi dispatcher > in base/config/ofbiz-container.xml > > Si > > Robert Riggins wrote: > > >I see the same RMI error occasionally on my Win XP machine when > >starting Ofbiz. Usually, rebooting fixes it. However, the last time > >it happened, I did a netstat -a and saw that my machine was > >connecting port 1099 to our company mail server. > > > >I disabled my network connection, then re-enabled the connection. > >After that, netstat -a showed the connection to the mail server > >choose another port. Then I successfully started Ofbiz. > > > >Best regards, > >Rob Riggins > >Integral Business Solutions > >Roseville, MN, US > > > >-----Original Message----- > >From: [hidden email] > >[mailto:[hidden email]] On Behalf Of Andrew Sykes > >Sent: Friday, October 28, 2005 8:31 AM > >To: OFBiz Users / Usage Discussion > >Subject: Re: [OFBiz] Users - JOTM / RMI problem > > > >Brett, > > > >I've only seen this 2 or 3 times on linux (FC3), I don't use windows > >much. > > > >Perhaps its something to do with the way RMI is doing ip resolution. > > > >About a year ago I was working on a box whose /etc/hosts file got > >mangled. I got a very similar error. It took ages to figure out what > >was going on. > > > >Perhaps there's config pointing to "localhost" that might be better > >pointed directly to "127.0.0.1". > > > >Kind Regards > >-- > >Andrew Sykes <[hidden email]> Sykes Development Ltd > > > > > >_______________________________________________ > >Users mailing list > >[hidden email] > >http://lists.ofbiz.org/mailman/listinfo/users > > > >_______________________________________________ > >Users mailing list > >[hidden email] > >http://lists.ofbiz.org/mailman/listinfo/users > > > > > > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
RE: [OFBiz] Users - JOTM / RMI problem
|
|
Rob,
This is interesting, it seems from the various comments like there may be a number of reasons for this happening. A couple of the possible reasons, your mailserver situation and the firewall thing don't really apply to me. I guess the moral of the story is, be careful that port 1099 is available if you enable RMI. None of these really explain the intermittent nature of the problem though. Does anyone know if it's possible that the port is not being released reliably when OFBiz is stopped? I wouldn't keep going on about it, but I'm looking at deploying in an environment where the server will be up and down quite a bit. I'd rather not be getting complaints about an intermittent bug. Thanks to everyone for their comments on this today. -- Andrew Sykes <[hidden email]> Sykes Development Ltd _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
[OFBiz] Users - Helper name not found for entity OdbcPackageIn
Administrator
|
This mail is in HTML format cause of the log
below
It seems that I have a problem with entity
OdbcPackageIn (after one week without any problem). After this error OFBiz can't
be accessed.
I use PostGres so in entityengine.xml I
have
<delegator name="other"
entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localderby"/> <group-map group-name="org.ofbiz.odbc" datasource-name="localderbyodbc"/> </delegator> <delegator name="default-no-eca" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" entity-eca-enabled="false" distributed-cache-clear-enabled="false"> <group-map group-name="org.ofbiz" datasource-name="localderby"/> <group-map group-name="org.ofbiz.odbc" datasource-name="localderbyodbc"/> </delegator> <delegator name="test"
entity-model-reader="main" entity-group-reader="main"
entity-eca-reader="main">
<group-map group-name="org.ofbiz" datasource-name="localderby"/> </delegator> <delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false"> <group-map group-name="org.ofbiz" datasource-name="localpostgres"/> </delegator> Is that bad ? Is localderbyodbc needed
?
Thanks
Jacques
---- exception report
----------------------------------------------------------
Exception: org.ofbiz.entity.GenericEntityException Message: Helper name not found for entity OdbcPackageIn ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericEntityException: Helper name not found for entity OdbcPackageIn org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.java:434) org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1816) org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1775) org.ofbiz.shipment.shipment.ShipmentServices.updateShipmentsFromStaging(ShipmentServices.java:635) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:324) org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java: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.job.GenericServiceJob.exec(GenericServiceJob.java:80) org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) java.lang.Thread.run(Thread.java:534) -------------------------------------------------------------------------------- 866479547[ ServiceDispatcher.java:407:ERROR]
Service Error [updateShipmentFromStaging]: Helper name not found for entity
OdbcPackageIn
866479548[ TransactionUtil.java:288:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, status is STATUS_NO_TRANSACTION 866479550[ ServiceDispatcher.java:447:DEBUG] [[Sync service finished- total:0.014,since last(Begin):0.014]] - 'JobDispatcher / updateShipmentFromStaging' 866479552[ GenericServiceJob.java:127:ERROR] ---- exception report ---------------------------------------------------------- Async-Service failed. Exception: java.lang.Exception Message: Helper name not found for entity OdbcPackageIn ---- stack trace --------------------------------------------------------------- java.lang.Exception: Helper name not found for entity OdbcPackageIn org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:86) org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) java.lang.Thread.run(Thread.java:534) -------------------------------------------------------------------------------- 870318513[
GenericDAO.java:796:DEBUG] Ran query in 140 milli-seconds: SELECT JOB_ID,
JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID,
SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID,
RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME,
CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND
STATUS_ID = ?) ORDER BY RUN_TIME
ASC
877667123[ GenericDAO.java:796:DEBUG] Ran query in 420 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 877700592[ GenericDAO.java:796:DEBUG] Ran query in 303 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 877740946[ GenericDAO.java:796:DEBUG] Ran query in 4248 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 877829173[ GenericDAO.java:796:DEBUG] Ran query in 9494 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 877888623[ GenericDAO.java:796:DEBUG] Ran query in 1581 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 877928039[ GenericDAO.java:796:DEBUG] Ran query in 1408 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 878055949[ GenericDAO.java:796:DEBUG] Ran query in 276 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 878081360[ GenericDAO.java:796:DEBUG] Ran query in 409 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 878108239[ GenericDAO.java:796:DEBUG] Ran query in 183 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 878131421[ GenericDAO.java:796:DEBUG] Ran query in 342 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 878217439[ GenericDAO.java:796:DEBUG] Ran query in 134 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 878263877[ GenericDAO.java:796:DEBUG] Ran query in 237 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 878374106[ GenericDAO.java:796:DEBUG] Ran query in 349 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 878398110[ GenericDAO.java:796:DEBUG] Ran query in 226 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 878439110[ GenericDAO.java:796:DEBUG] Ran query in 3693 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 878507971[ GenericDAO.java:796:DEBUG] Ran query in 5175 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC 878641741[ GenericDAO.java:796:DEBUG] Ran query in 12676 milli-seconds: SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.JOB_SANDBOX WHERE (RUN_BY_INSTANCE_ID = ? AND STATUS_ID = ?) ORDER BY RUN_TIME ASC _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: [OFBiz] Users - Helper name not found for entity OdbcPackageIn
|
Administrator
|
May someone help on this subject ?
Do you think that the end of the job (and BTW
OFBiz) is related to the "Helper name not found for entity OdbcPackageIn"
problem ?
In the same log I had some other "Helper name not
found for entity OdbcPackageIn" messages before but without hanging OFBiz.
Perhaps it's another problem only related to the last line of the job. And why
there are so much (20 times) of the same 'GenericDAO.java:796' message just
before the end ?
It's a demo made with svn 5969 standard install
(ant run-install) on a fresh new Postres 7.4 database on Ubuntu Hoary (upgraded
from Warty).
It runned one week before
collapsing...
May a backup (rsync) interfere with OFBiz
?
Any idea ? Thanks.
Jacques
_______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |