[OFBiz] Users - billing account as payment method

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
19 messages Options
Reply | Threaded
Open this post in threaded view
|

[OFBiz] Users - billing account as payment method

Hao Jiang-4
Hello there,

Has anyone done this?

I know the selection of payment methods when doing checkout are hard
coded at checkoutoptions.ftl, that's no problem to edit the file,
however, is there a service already available to deduct that amount from
billing account limits?

Also I found there is a calcBillingAccountBalance service available, but
I couldn't find where it's implemented.

Thanks

Hao


 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

[OFBiz] Users - Error in ecommerce

Jacques Le Roux
Administrator
Got this after an svn up and a run-install on a fresh Postgres DB.
Have no time to loke at it sorry. I'm not sure it's a general problem
either...

 Method public java.lang.String
org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String) throws
org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXExce
ption,javax.xml.parsers.ParserConfigurationException threw an exception when
invoked on org.ofbiz.widget.screen.ScreenRenderer@a5c9f1 The problematic
instruction: ---------- ==> ${screens.render(productsummaryScreen)} [on line
85, column 13 in categorydetail.ftl] ---------- Java backtrace for
programmers: ---------- freemarker.template.TemplateModelException: Method
public java.lang.String
org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String) throws
org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXExce
ption,javax.xml.parsers.ParserConfigurationException threw an exception when
invoked on org.ofbiz.widget.screen.ScreenRenderer@a5c9f1 at
freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:1
33) at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93) at
[...]

Jacques

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

RE: [OFBiz] Users - Error in ecommerce

firas-3
I think I get the same error but it's probably occurs much earlier from what
I can see (bellow).

/*___________________________________________________ LOG-EXCERPT */
...

247296[  ServiceDispatcher.java:381:DEBUG] [[Sync service failed...-
total:0.0,since last(Begin):0.0]] - 'ecommerce / calculateProductPrice'
247306[  ServiceDispatcher.java:384:ERROR]
---- exception report
----------------------------------------------------------
Service [calculateProductPrice] threw an unexpected exception/error
Exception: org.ofbiz.service.GenericServiceException
Message: Service target threw an unexpected exception (null)
---- stack trace
---------------------------------------------------------------
org.ofbiz.service.GenericServiceException: Service target threw an
unexpected exception (null)
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngin
e.java:113)
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)

...
/*__________________________________________________/ LOG-EXCERPT */


My platform rev.5787/PostgreSQL 8.0.3

Regards

</Firas>

---------------------------------------------------- Original Message
From: [hidden email] [mailto:[hidden email]]
On Behalf Of Jacques Le Roux
Sent: den 20 september 2005 21:25
To: OFBiz Users / Usage Discussion
Subject: [OFBiz] Users - Error in ecommerce

Got this after an svn up and a run-install on a fresh Postgres DB.
Have no time to loke at it sorry. I'm not sure it's a general problem
either...

 Method public java.lang.String
org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String) throws
org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXExce
ption,javax.xml.parsers.ParserConfigurationException threw an exception when
invoked on org.ofbiz.widget.screen.ScreenRenderer@a5c9f1 The problematic
instruction: ---------- ==> ${screens.render(productsummaryScreen)} [on line
85, column 13 in categorydetail.ftl] ---------- Java backtrace for
programmers: ---------- freemarker.template.TemplateModelException: Method
public java.lang.String
org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String) throws
org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXExce
ption,javax.xml.parsers.ParserConfigurationException threw an exception when
invoked on org.ofbiz.widget.screen.ScreenRenderer@a5c9f1 at
freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:1
33) at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93) at
[...]

Jacques

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - Error in ecommerce

Jacques Le Roux
Administrator
Seems to be a Windows related problem : it runs OK on Linux... (svn 5792)
Always KO on Windows...

Jacques

----- Original Message -----
From: "Firas A." <[hidden email]>
To: "'OFBiz Users / Usage Discussion'" <[hidden email]>
Sent: Tuesday, September 20, 2005 10:32 PM
Subject: RE: [OFBiz] Users - Error in ecommerce


> I think I get the same error but it's probably occurs much earlier from
what

> I can see (bellow).
>
> /*___________________________________________________ LOG-EXCERPT */
> ...
>
> 247296[  ServiceDispatcher.java:381:DEBUG] [[Sync service failed...-
> total:0.0,since last(Begin):0.0]] - 'ecommerce / calculateProductPrice'
> 247306[  ServiceDispatcher.java:384:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Service [calculateProductPrice] threw an unexpected exception/error
> Exception: org.ofbiz.service.GenericServiceException
> Message: Service target threw an unexpected exception (null)
> ---- stack trace
> ---------------------------------------------------------------
> org.ofbiz.service.GenericServiceException: Service target threw an
> unexpected exception (null)
>
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngin
> e.java:113)
>
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)
>
> ...
> /*__________________________________________________/ LOG-EXCERPT */
>
>
> My platform rev.5787/PostgreSQL 8.0.3
>
> Regards
>
> </Firas>
>
> ---------------------------------------------------- Original Message
> From: [hidden email] [mailto:[hidden email]]
> On Behalf Of Jacques Le Roux
> Sent: den 20 september 2005 21:25
> To: OFBiz Users / Usage Discussion
> Subject: [OFBiz] Users - Error in ecommerce
>
> Got this after an svn up and a run-install on a fresh Postgres DB.
> Have no time to loke at it sorry. I'm not sure it's a general problem
> either...
>
>  Method public java.lang.String
> org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String) throws
>
org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXExce
> ption,javax.xml.parsers.ParserConfigurationException threw an exception
when
> invoked on org.ofbiz.widget.screen.ScreenRenderer@a5c9f1 The problematic
> instruction: ---------- ==> ${screens.render(productsummaryScreen)} [on
line
> 85, column 13 in categorydetail.ftl] ---------- Java backtrace for
> programmers: ---------- freemarker.template.TemplateModelException: Method
> public java.lang.String
> org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String) throws
>
org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXExce
> ption,javax.xml.parsers.ParserConfigurationException threw an exception
when
> invoked on org.ofbiz.widget.screen.ScreenRenderer@a5c9f1 at
>
freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:1
> 33) at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
at
> [...]
>
> Jacques
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - billing account as payment method

Jacopo Cappellato
In reply to this post by Hao Jiang-4
Hao,

create a billing account and link yo it the customer with the role of
"Bill to Customer" (or something similar, I don't remember); then the
billing account will be available in the checkout options.

Jacopo

Hao Jiang wrote:

> Hello there,
>
> Has anyone done this?
>
> I know the selection of payment methods when doing checkout are hard
> coded at checkoutoptions.ftl, that's no problem to edit the file,
> however, is there a service already available to deduct that amount from
> billing account limits?
>
> Also I found there is a calcBillingAccountBalance service available, but
> I couldn't find where it's implemented.
>
> Thanks
>
> Hao
>
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

RE: [OFBiz] Users - Error in ecommerce

firas-3
In reply to this post by Jacques Le Roux

No, Jacques, it's not Windows (thank God). I managed to run the same
revision (5792) but used Derby instead of PostgreSQL.

Could it be the PostgreSQL seed data?

OFBiz veterans, anyone?

Thanks!

</Firas>

-----Original Message-----
From: [hidden email] [mailto:[hidden email]]
On Behalf Of Jacques Le Roux
Sent: den 20 september 2005 23:17
To: OFBiz Users / Usage Discussion
Subject: Re: [OFBiz] Users - Error in ecommerce

Seems to be a Windows related problem : it runs OK on Linux... (svn 5792)
Always KO on Windows...

Jacques

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - Error in ecommerce

Jacques Le Roux
Administrator
Firas,

OK, but I use also PostGres on Linux and it's ok (version 8.0 on Windows,
7.4 on Linux I suppose (std Ubuntu Hoary, it's a dual boot and I'm working
on a .NET project on Windows so I can't verify without loosing too much time
today))

I put all this on the jira issue I created for it :
http://jira.undersunconsulting.com/browse/OFBIZ-498

Jacques

PS : I must confess a bad habit of too much parenthesis ;o)

----- Original Message -----
From: "Firas A." <[hidden email]>
To: "'OFBiz Users / Usage Discussion'" <[hidden email]>
Sent: Wednesday, September 21, 2005 10:47 AM
Subject: RE: [OFBiz] Users - Error in ecommerce


>
> No, Jacques, it's not Windows (thank God). I managed to run the same
> revision (5792) but used Derby instead of PostgreSQL.
>
> Could it be the PostgreSQL seed data?
>
> OFBiz veterans, anyone?
>
> Thanks!
>
> </Firas>
>
> -----Original Message-----
> From: [hidden email] [mailto:[hidden email]]
> On Behalf Of Jacques Le Roux
> Sent: den 20 september 2005 23:17
> To: OFBiz Users / Usage Discussion
> Subject: Re: [OFBiz] Users - Error in ecommerce
>
> Seems to be a Windows related problem : it runs OK on Linux... (svn 5792)
> Always KO on Windows...
>
> Jacques
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - billing account as payment method

Hao Jiang-4
In reply to this post by Jacopo Cappellato
Thanks Jacopo.

I downloaded ofbiz a month before since then working on it, occasionally
I use svn update to the newest version (command line, not in eclipse).

Yesterday I downloaded a fresh copy of ofbiz from weekly build, running
without any modification, I found lots of problems I had before
disappeared, include the billing account issue I asked here.

It seems that the svn update can't update the existing system to those
new features, any suggestions how can I update the system but still keep
my works unchanged?

Thanks

Hao

On Wed, 2005-09-21 at 06:18 +0200, Jacopo Cappellato wrote:

> Hao,
>
> create a billing account and link yo it the customer with the role of
> "Bill to Customer" (or something similar, I don't remember); then the
> billing account will be available in the checkout options.
>
> Jacopo
>
> Hao Jiang wrote:
> > Hello there,
> >
> > Has anyone done this?
> >
> > I know the selection of payment methods when doing checkout are hard
> > coded at checkoutoptions.ftl, that's no problem to edit the file,
> > however, is there a service already available to deduct that amount from
> > billing account limits?
> >
> > Also I found there is a calcBillingAccountBalance service available, but
> > I couldn't find where it's implemented.
> >
> > Thanks
> >
> > Hao
> >
> >
> >  
> > _______________________________________________
> > 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
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - Error in ecommerce

David E. Jones
In reply to this post by firas-3

Chances are your seed data is out of date or your database metadata  
(table defs, etc) are out of date. For database metadata watch your  
startup log and it will tell you about various problems, including  
out of date primary keys now (if your JDBC driver supports it...  
evidently not working right now with MySQL).

-David


On Sep 21, 2005, at 2:47 AM, Firas A. wrote:

>
> No, Jacques, it's not Windows (thank God). I managed to run the same
> revision (5792) but used Derby instead of PostgreSQL.
>
> Could it be the PostgreSQL seed data?
>
> OFBiz veterans, anyone?
>
> Thanks!
>
> </Firas>
>
> -----Original Message-----
> From: [hidden email] [mailto:users-
> [hidden email]]
> On Behalf Of Jacques Le Roux
> Sent: den 20 september 2005 23:17
> To: OFBiz Users / Usage Discussion
> Subject: Re: [OFBiz] Users - Error in ecommerce
>
> Seems to be a Windows related problem : it runs OK on Linux... (svn  
> 5792)
> Always KO on Windows...
>
> Jacques
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - billing account as payment method

Si Chen-2
In reply to this post by Hao Jiang-4
Are you sure?  $ svn update always works for me.  What happens when you
try to do it?  Do you see a list of files that are changed?

The only other thing you need to do regularly is an
$ ant run-install-seed

It will recompile all the files and install the up to date seed data.

Hao Jiang wrote:

>Thanks Jacopo.
>
>I downloaded ofbiz a month before since then working on it, occasionally
>I use svn update to the newest version (command line, not in eclipse).
>
>Yesterday I downloaded a fresh copy of ofbiz from weekly build, running
>without any modification, I found lots of problems I had before
>disappeared, include the billing account issue I asked here.
>
>It seems that the svn update can't update the existing system to those
>new features, any suggestions how can I update the system but still keep
>my works unchanged?
>
>Thanks
>
>Hao
>
>On Wed, 2005-09-21 at 06:18 +0200, Jacopo Cappellato wrote:
>  
>
>>Hao,
>>
>>create a billing account and link yo it the customer with the role of
>>"Bill to Customer" (or something similar, I don't remember); then the
>>billing account will be available in the checkout options.
>>
>>Jacopo
>>
>>Hao Jiang wrote:
>>    
>>
>>>Hello there,
>>>
>>>Has anyone done this?
>>>
>>>I know the selection of payment methods when doing checkout are hard
>>>coded at checkoutoptions.ftl, that's no problem to edit the file,
>>>however, is there a service already available to deduct that amount from
>>>billing account limits?
>>>
>>>Also I found there is a calcBillingAccountBalance service available, but
>>>I couldn't find where it's implemented.
>>>
>>>Thanks
>>>
>>>Hao
>>>
>>>
>>>
>>>_______________________________________________
>>>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
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - Error in ecommerce

Jacques Le Roux
Administrator
In reply to this post by David E. Jones
David,

As I said before, I got this after an "svn up" and a "run-install" on a
*fresh* Postgres DB.
I just tried to do a new "svn up" (was already in 5801) and just after a
"run-install-seed" : always the same problem.

I tried with default entityengine.xml and it's running without any problem
(except 24 mn on Derby vs 4mn on Postgres ;o)
Did you notice (with default entityengine.xml):
     [java] 5203  (main) [            UtilXml.java:634:ERROR] XmlFileLoader:
File file:/D:/workspace/ofbiz/framework/entity/config/entityengine.xml
process e
ror. Line: 272. Error message: cvc-complex-type.2.3: Element 'datasource'
cannot have character [children], because the type's content type is
element-only.

So I created another *new* Postgres DB with a "run-install" and I got the
same problem (please see :
http://jira.undersunconsulting.com/browse/OFBIZ-498)

Seems to be related to Postgres, at least on XP with version 8.0.
Have somebody else tried on XP with PostGres 8.0 ?

Jacques

PS : I'm very tired today, perhaps I missed something, might somebody be
interested by Postgres 8.0 on XP ?

----- Original Message ----- From: "David E. Jones" <[hidden email]>

>
> Chances are your seed data is out of date or your database metadata
> (table defs, etc) are out of date. For database metadata watch your
> startup log and it will tell you about various problems, including
> out of date primary keys now (if your JDBC driver supports it...
> evidently not working right now with MySQL).
>
> -David
>
>
> On Sep 21, 2005, at 2:47 AM, Firas A. wrote:
>
> >
> > No, Jacques, it's not Windows (thank God). I managed to run the same
> > revision (5792) but used Derby instead of PostgreSQL.
> >
> > Could it be the PostgreSQL seed data?
> >
> > OFBiz veterans, anyone?
> >
> > Thanks!
> >
> > </Firas>
> >
> > -----Original Message-----
> > From: [hidden email] [mailto:users-
> > [hidden email]]
> > On Behalf Of Jacques Le Roux
> > Sent: den 20 september 2005 23:17
> > To: OFBiz Users / Usage Discussion
> > Subject: Re: [OFBiz] Users - Error in ecommerce
> >
> > Seems to be a Windows related problem : it runs OK on Linux... (svn
> > 5792)
> > Always KO on Windows...
> >
> > Jacques
> >
> >
> > _______________________________________________
> > 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
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - Error in ecommerce

David E. Jones

Okay, if you're getting that message then your local file is messed  
up somehow. Chances are it is an update merge conflict. You can see a  
list of all changed and conflicted files by doing an "svn st" or "svn  
status". It's probably a good idea to get a full list since you may  
have other conflicted files or files that are changed and causing  
problems (not based anything from this message, just a general  
recommendation when doing updates).

-David


On Sep 21, 2005, at 3:02 PM, Jacques Le Roux wrote:

> David,
>
> As I said before, I got this after an "svn up" and a "run-install"  
> on a
> *fresh* Postgres DB.
> I just tried to do a new "svn up" (was already in 5801) and just  
> after a
> "run-install-seed" : always the same problem.
>
> I tried with default entityengine.xml and it's running without any  
> problem
> (except 24 mn on Derby vs 4mn on Postgres ;o)
> Did you notice (with default entityengine.xml):
>      [java] 5203  (main) [            UtilXml.java:634:ERROR]  
> XmlFileLoader:
> File file:/D:/workspace/ofbiz/framework/entity/config/entityengine.xml
> process e
> ror. Line: 272. Error message: cvc-complex-type.2.3: Element  
> 'datasource'
> cannot have character [children], because the type's content type is
> element-only.
>
> So I created another *new* Postgres DB with a "run-install" and I  
> got the
> same problem (please see :
> http://jira.undersunconsulting.com/browse/OFBIZ-498)
>
> Seems to be related to Postgres, at least on XP with version 8.0.
> Have somebody else tried on XP with PostGres 8.0 ?
>
> Jacques
>
> PS : I'm very tired today, perhaps I missed something, might  
> somebody be
> interested by Postgres 8.0 on XP ?
>
> ----- Original Message ----- From: "David E. Jones"  
> <[hidden email]>
>
>
>>
>> Chances are your seed data is out of date or your database metadata
>> (table defs, etc) are out of date. For database metadata watch your
>> startup log and it will tell you about various problems, including
>> out of date primary keys now (if your JDBC driver supports it...
>> evidently not working right now with MySQL).
>>
>> -David
>>
>>
>> On Sep 21, 2005, at 2:47 AM, Firas A. wrote:
>>
>>
>>>
>>> No, Jacques, it's not Windows (thank God). I managed to run the same
>>> revision (5792) but used Derby instead of PostgreSQL.
>>>
>>> Could it be the PostgreSQL seed data?
>>>
>>> OFBiz veterans, anyone?
>>>
>>> Thanks!
>>>
>>> </Firas>
>>>
>>> -----Original Message-----
>>> From: [hidden email] [mailto:users-
>>> [hidden email]]
>>> On Behalf Of Jacques Le Roux
>>> Sent: den 20 september 2005 23:17
>>> To: OFBiz Users / Usage Discussion
>>> Subject: Re: [OFBiz] Users - Error in ecommerce
>>>
>>> Seems to be a Windows related problem : it runs OK on Linux... (svn
>>> 5792)
>>> Always KO on Windows...
>>>
>>> Jacques
>>>
>>>
>>> _______________________________________________
>>> 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

smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - Error in ecommerce

Jacques Le Roux
Administrator
David,
 
Thanks, yes I frequently use "svn st". Perhaps I did not explain myself correctly.
This message came only when I used a default configuration, ie after having "del" (Windows) entityengine.xml  and just after did an "svn up" of that only file. So it's when I used the file from the svn repository (using Derby) that I got this message
 
Here is the result of an "svn st" after I modified entityengine.xml  to use postgres

D:\workspace\ofbiz>svn st
?      ofbiz.ico
?      .externalToolBuilders
?      $jarplug.work
?      Patchs en attente
?      SQLProcessor.patch
?      startofbizdebug.bat
?      startofbizPos.bat
M      .project
?      applications\pos\screens\default\menu\posmain.xml.fr
?      applications\pos\config\XuiLabels.properties
?      applications\pos\config\Copy of custreceipt.txt
?      applications\pos\config\Copie de balance.txt
?      applications\pos\config\Copy of pos_fr.properties
?      applications\pos\config\Copy of storereceipt.txt
?      applications\pos\config\Copy of pos.properties
?      applications\pos\config\Copie de totals.txt
M      applications\pos\config\xpos.properties
?      applications\pos\lib\XuiCoreSwing.jar
?      applications\pos\src\org\ofbiz\pos\device\impl\Receipt.java.bak
M      applications\pos\src\org\ofbiz\pos\device\impl\Keyboard.java
?      base\config\both-containers.xml
M      base\config\pos-containers.xml
M      base\config\ofbiz-containers.xml
?      base\lib\commons\commons-digester.jar
?      base\lib\commons\commons-digester-1.7.jar.tmp
M      startofbiz.bat
?      framework\rules
M      framework\guiapp\src\org\ofbiz\guiapp\xui\XuiContainer.java
?      framework\images\webapp\images\logo.jpg
?      framework\images\webapp\images\fond.gif
M      framework\images\webapp\images\ecommain.css
?      framework\images\webapp\images\products\medium
?      framework\images\webapp\images\products\detail
?      framework\images\webapp\images\products\small\Axim30.jpg
?      framework\images\webapp\images\products\small\PCMoyen.jpg
?      framework\images\webapp\images\products\small\PCHaut.jpg
?      framework\images\webapp\images\products\small\PCBas.jpg
?      framework\images\webapp\images\products\small\PDA-GPS.jpg
?      framework\images\webapp\images\products\small\ImprBas.jpg
?      framework\images\webapp\images\products\large\PCBas.jpg
M      framework\shark\webapp\shark\includes\appbar.ftl
M      framework\shark\webapp\shark\templates\main.ftl
?      framework\entity\config\entityengine.xml.BAK
M      framework\entity\config\entityengine.xml

 
And here is the modification of entityengine.xml  :

D:\workspace\ofbiz>svn di  framework\entity\config\entityengine.xml
Index: framework/entity/config/entityengine.xml
===================================================================
--- framework/entity/config/entityengine.xml    (r+vision 5802)
+++ framework/entity/config/entityengine.xml    (copie de travail)
@@ -54,7 +54,7 @@
     -->
 
     <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="localderby"/>
+        <group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
         <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-ca
che-clear-enabled="false">

 
M      base\config\pos-containers.xml
M      base\config\ofbiz-containers.xml

are because I modified files (from Andy recommandation) to have simultaneaoulsy POS and HTML applications (but commented out for now)
 
So as you can see there is nothing wrong with my configuration. And this problems came suddently while I was not working on OFBiz for 2 weeks now (only updating and testing after)
 
To be sure I tested the same configuration (OFBiz on XP) with a PostGres DB (version 7.4.7) on another server (Linux - Ubuntu Hoary) and it works !
 
I mus admit that I am confused, and also that I have no more time for it today :(
 
Have a good day all and sorry for this long HTML format message (needed to be more readeable)...
 
Jacques
 
 
----- Original Message ----- From: "David E. Jones" <[hidden email]>
>Okay, if you're getting that message then your local file is messed 
>up somehow. Chances are it is an update merge conflict. You can see a 
>list of all changed and conflicted files by doing an "svn st" or "svn 
>status". It's probably a good idea to get a full list since you may 
>have other conflicted files or files that are changed and causing 
>problems (not based anything from this message, just a general 
>recommendation when doing updates).
 
-David
 

On Sep 21, 2005, at 3:02 PM, Jacques Le Roux wrote:
 
> David,

>
> As I said before, I got this after an "svn up" and a "run-install" 
> on a
> *fresh* Postgres DB.
> I just tried to do a new "svn up" (was already in 5801) and just 
> after a
> "run-install-seed" : always the same problem.
>
> I tried with default entityengine.xml and it's running without any 
> problem
> (except 24 mn on Derby vs 4mn on Postgres ;o)
> Did you notice (with default entityengine.xml):
>      [java] 5203  (main) [            UtilXml.java:634:ERROR] 
> XmlFileLoader:
> File file:/D:/workspace/ofbiz/framework/entity/config/entityengine.xml
> process e
> ror. Line: 272. Error message: cvc-complex-type.2.3: Element 
> 'datasource'
> cannot have character [children], because the type's content type is
> element-only.
>
> So I created another *new* Postgres DB with a "run-install" and I 
> got the
> same problem (please see :
>
http://jira.undersunconsulting.com/browse/OFBIZ-498)
>
> Seems to be related to Postgres, at least on XP with version 8.0.
> Have somebody else tried on XP with PostGres 8.0 ?
>
> Jacques
>
> PS : I'm very tired today, perhaps I missed something, might 
> somebody be
> interested by Postgres 8.0 on XP ?
>
> ----- Original Message ----- From: "David E. Jones" 
> <
[hidden email]>
>
>
>>
>> Chances are your seed data is out of date or your database metadata
>> (table defs, etc) are out of date. For database metadata watch your
>> startup log and it will tell you about various problems, including
>> out of date primary keys now (if your JDBC driver supports it...
>> evidently not working right now with MySQL).
>>
>> -David
>>
>>
>> On Sep 21, 2005, at 2:47 AM, Firas A. wrote:
>>
>>
>>>
>>> No, Jacques, it's not Windows (thank God). I managed to run the same
>>> revision (5792) but used Derby instead of PostgreSQL.
>>>
>>> Could it be the PostgreSQL seed data?
>>>
>>> OFBiz veterans, anyone?
>>>
>>> Thanks!
>>>
>>> </Firas>
>>>
>>> -----Original Message-----
>>> From:
[hidden email] [mailto:users-
>>>
[hidden email]]
>>> On Behalf Of Jacques Le Roux
>>> Sent: den 20 september 2005 23:17
>>> To: OFBiz Users / Usage Discussion
>>> Subject: Re: [OFBiz] Users - Error in ecommerce
>>>
>>> Seems to be a Windows related problem : it runs OK on Linux... (svn
>>> 5792)
>>> Always KO on Windows...
>>>
>>> Jacques
>>>
>>>
>>> _______________________________________________
>>> 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
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - Error in ecommerce

Jacques Le Roux
Administrator
In reply to this post by David E. Jones
David,

On a suggestion of Si I tried with the last stable Sequoia ERP.
It works with the same DB that does not work with OFBiz.
ASAP I will compare the 2 projects to understand.

Thanks for your help.

Jacques


----- Original Message ----- From: "David E. Jones" <[hidden email]>

Okay, if you're getting that message then your local file is messed  
up somehow. Chances are it is an update merge conflict. You can see a  
list of all changed and conflicted files by doing an "svn st" or "svn  
status". It's probably a good idea to get a full list since you may  
have other conflicted files or files that are changed and causing  
problems (not based anything from this message, just a general  
recommendation when doing updates).

-David


 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - Error in ecommerce

Si Chen-2
That is very strange indeed: Sequoia is OFBIZ SVN r 5660 with
progressive bug patches, so could something have changed since then to
make it not work?  I just checked my weekly blog and couldn't find any
changes to the entity engine since then.  Wonder what it could be?

Si

Jacques Le Roux wrote:

>David,
>
>On a suggestion of Si I tried with the last stable Sequoia ERP.
>It works with the same DB that does not work with OFBiz.
>ASAP I will compare the 2 projects to understand.
>
>Thanks for your help.
>
>Jacques
>
>
>----- Original Message ----- From: "David E. Jones" <[hidden email]>
>
>Okay, if you're getting that message then your local file is messed  
>up somehow. Chances are it is an update merge conflict. You can see a  
>list of all changed and conflicted files by doing an "svn st" or "svn  
>status". It's probably a good idea to get a full list since you may  
>have other conflicted files or files that are changed and causing  
>problems (not based anything from this message, just a general  
>recommendation when doing updates).
>
>-David
>
>
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
>
>  
>
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

RE: [OFBiz] Users - Error in ecommerce

firas-3
In reply to this post by David E. Jones
David,

My current environment that produces this error is:
        * rev.5792 checked out into an empty folder
        * PostgreSQL 8.0.3, and a newly created database
        * Java 1.4.2_09-b05 on WinXP
        * Issued ant run-install
As you can see the it's a very clean setup.

Also, I've noticed another (and for me strange) behavior. The list of
'Fetured products' is ordered differently depending on the database used.
Using Derby it begins with the 'Round Gizmo' and ends with 'Configurable
PC'. In PosgreSQL it begins with 'Configurable PC' and ends with 'Gift Card
Activation', after which the exception discussed is raised and displayed by
FreeMarker.

To keep this message readable, I'm attaching a log excerpt of the request
corresponding to the view-map "main".


</Firas>

-----Original Message-----
From: [hidden email] [mailto:[hidden email]]
On Behalf Of David E. Jones
Sent: den 21 september 2005 19:41
To: OFBiz Users / Usage Discussion
Subject: Re: [OFBiz] Users - Error in ecommerce

Chances are your seed data is out of date or your database metadata (table
defs, etc) are out of date. For database metadata watch your startup log and
it will tell you about various problems, including out of date primary keys
now (if your JDBC driver supports it...  
evidently not working right now with MySQL).

-David

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

ofbiz-postgre-main.log (32K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - Error in ecommerce

Jacques Le Roux
Administrator
It's ok for me now, thanks to Ashish and David :o)

Firas tried the last svn, please.

Jacques


----- Original Message -----
From: "Firas A." <[hidden email]>
To: "'OFBiz Users / Usage Discussion'" <[hidden email]>
Sent: Saturday, September 24, 2005 9:12 AM
Subject: RE: [OFBiz] Users - Error in ecommerce


> David,
>
> My current environment that produces this error is:
> * rev.5792 checked out into an empty folder
> * PostgreSQL 8.0.3, and a newly created database
> * Java 1.4.2_09-b05 on WinXP
> * Issued ant run-install
> As you can see the it's a very clean setup.
>
> Also, I've noticed another (and for me strange) behavior. The list of
> 'Fetured products' is ordered differently depending on the database used.
> Using Derby it begins with the 'Round Gizmo' and ends with 'Configurable
> PC'. In PosgreSQL it begins with 'Configurable PC' and ends with 'Gift
Card
> Activation', after which the exception discussed is raised and displayed
by

> FreeMarker.
>
> To keep this message readable, I'm attaching a log excerpt of the request
> corresponding to the view-map "main".
>
>
> </Firas>
>
> -----Original Message-----
> From: [hidden email] [mailto:[hidden email]]
> On Behalf Of David E. Jones
> Sent: den 21 september 2005 19:41
> To: OFBiz Users / Usage Discussion
> Subject: Re: [OFBiz] Users - Error in ecommerce
>
> Chances are your seed data is out of date or your database metadata (table
> defs, etc) are out of date. For database metadata watch your startup log
and
> it will tell you about various problems, including out of date primary
keys
> now (if your JDBC driver supports it...
> evidently not working right now with MySQL).
>
> -David
>


----------------------------------------------------------------------------
----


>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

RE: [OFBiz] Users - Error in ecommerce

firas-3
Jacques,

Thanks for the tip. Updating to the lates revision did solve the issue, but
I'd still like to know the cause of it.

</Firas>
 

-----Original Message-----
From: [hidden email] [mailto:[hidden email]]
On Behalf Of Jacques Le Roux
Sent: den 24 september 2005 10:05
To: OFBiz Users / Usage Discussion
Subject: Re: [OFBiz] Users - Error in ecommerce

It's ok for me now, thanks to Ashish and David :o)

Firas tried the last svn, please.

Jacques


----- Original Message -----
From: "Firas A." <[hidden email]>
To: "'OFBiz Users / Usage Discussion'" <[hidden email]>
Sent: Saturday, September 24, 2005 9:12 AM
Subject: RE: [OFBiz] Users - Error in ecommerce


> David,
>
> My current environment that produces this error is:
> * rev.5792 checked out into an empty folder
> * PostgreSQL 8.0.3, and a newly created database
> * Java 1.4.2_09-b05 on WinXP
> * Issued ant run-install
> As you can see the it's a very clean setup.
>
> Also, I've noticed another (and for me strange) behavior. The list of
> 'Fetured products' is ordered differently depending on the database used.
> Using Derby it begins with the 'Round Gizmo' and ends with 'Configurable
> PC'. In PosgreSQL it begins with 'Configurable PC' and ends with 'Gift
Card
> Activation', after which the exception discussed is raised and displayed
by

> FreeMarker.
>
> To keep this message readable, I'm attaching a log excerpt of the request
> corresponding to the view-map "main".
>
>
> </Firas>
>
> -----Original Message-----
> From: [hidden email] [mailto:[hidden email]]
> On Behalf Of David E. Jones
> Sent: den 21 september 2005 19:41
> To: OFBiz Users / Usage Discussion
> Subject: Re: [OFBiz] Users - Error in ecommerce
>
> Chances are your seed data is out of date or your database metadata (table
> defs, etc) are out of date. For database metadata watch your startup log
and
> it will tell you about various problems, including out of date primary
keys
> now (if your JDBC driver supports it...
> evidently not working right now with MySQL).
>
> -David
>


----------------------------------------------------------------------------
----


>
> _______________________________________________
> 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
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - Error in ecommerce

David E. Jones

Here is the issue in Jira for it: http://jira.undersunconsulting.com/ 
browse/OFBIZ-498

The title on it isn't very accurate since the problem really has  
nothing to do with windows, but scroll down to the comments near the  
bottom and look more closely at the exception reports to see the  
cause and solution and such.

-David


On Sep 24, 2005, at 10:00 AM, Firas A. wrote:

> Jacques,
>
> Thanks for the tip. Updating to the lates revision did solve the  
> issue, but
> I'd still like to know the cause of it.
>
> </Firas>
>
>
> -----Original Message-----
> From: [hidden email] [mailto:users-
> [hidden email]]
> On Behalf Of Jacques Le Roux
> Sent: den 24 september 2005 10:05
> To: OFBiz Users / Usage Discussion
> Subject: Re: [OFBiz] Users - Error in ecommerce
>
> It's ok for me now, thanks to Ashish and David :o)
>
> Firas tried the last svn, please.
>
> Jacques
>
>
> ----- Original Message -----
> From: "Firas A." <[hidden email]>
> To: "'OFBiz Users / Usage Discussion'" <[hidden email]>
> Sent: Saturday, September 24, 2005 9:12 AM
> Subject: RE: [OFBiz] Users - Error in ecommerce
>
>
>
>> David,
>>
>> My current environment that produces this error is:
>> * rev.5792 checked out into an empty folder
>> * PostgreSQL 8.0.3, and a newly created database
>> * Java 1.4.2_09-b05 on WinXP
>> * Issued ant run-install
>> As you can see the it's a very clean setup.
>>
>> Also, I've noticed another (and for me strange) behavior. The list of
>> 'Fetured products' is ordered differently depending on the  
>> database used.
>> Using Derby it begins with the 'Round Gizmo' and ends with  
>> 'Configurable
>> PC'. In PosgreSQL it begins with 'Configurable PC' and ends with  
>> 'Gift
>>
> Card
>
>> Activation', after which the exception discussed is raised and  
>> displayed
>>
> by
>
>> FreeMarker.
>>
>> To keep this message readable, I'm attaching a log excerpt of the  
>> request
>> corresponding to the view-map "main".
>>
>>
>> </Firas>
>>
>> -----Original Message-----
>> From: [hidden email] [mailto:users-
>> [hidden email]]
>> On Behalf Of David E. Jones
>> Sent: den 21 september 2005 19:41
>> To: OFBiz Users / Usage Discussion
>> Subject: Re: [OFBiz] Users - Error in ecommerce
>>
>> Chances are your seed data is out of date or your database  
>> metadata (table
>> defs, etc) are out of date. For database metadata watch your  
>> startup log
>>
> and
>
>> it will tell you about various problems, including out of date  
>> primary
>>
> keys
>
>> now (if your JDBC driver supports it...
>> evidently not working right now with MySQL).
>>
>> -David
>>
>>
>
>
> ----------------------------------------------------------------------
> ------
> ----
>
>
>
>>
>> _______________________________________________
>> 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