Re: Discussion: OFBiz deployment on AWS for production environment
Hello team, Before going for the next session on this series, Please watch the video of Session-1 of this series. https://www.youtube.com/playlist?list=PLobIkeUbRXqcGDzd5sqrhDa5KaAWjEwNJ After sharing all(2) existing videos of this series, we will start discussion on next topic and will share link to join here as well. On Tue, Oct 6, 2020 at 5:43 PM Alphonse Tiu wrote: > Likewise! Please keep me posted on the time of the call and I'd like to > join the call if my schedule permits. > > Thank you in advance. > -Al Tiu > > > On Tue, Oct 6, 2020 at 6:51 AM Rishi Solanki > wrote: > > > This is a great initiative Arun. I would like to join the session, if > time > > permits. > > > > Thanks! > > > > Best Regards, > > -- > > Rishi Solanki > > *CTO, Mindpath Technology* > > Intelligent Solutions > > cell: +91-98932-87847 > > LinkedIn <https://www.linkedin.com/in/rishi-solanki-62271b7/> > > > > > > On Tue, Oct 6, 2020 at 4:51 PM Arun Patidar > > wrote: > > > > > Hello team, > > > > > > We have started discussion about OFBiz deployment on AWS platform for > > > production environment. Idea is to share and discuss the optimal way to > > > deploy OFBiz on AWS platform to achieve high availability and > scalability > > > in the production environment. > > > > > > We are preparing a video series on this and will share on OFBiz youtube > > > channel. > > > > > > Anyone from the community can join this session and share your thoughts > > on > > > this. I will share the meeting URL with the timing of our next session > > > here shortly. > > > > > > > > > Regards > > > --- > > > Arun Patidar > > > > > > > > -- > A. Tiu > 312.970.9808 >
Re: Discussion: OFBiz deployment on AWS for production environment
Here is list of topics that we will cover in upcoming sessions: 1. Docker image deployment 2. Auto Scaling configuration 3. Load Balancer configuration 4. Database management on RDS 5. SOLR setup and configuration 6. Images management on S3 bucket 7. Log management and Monitoring of infra On Tue, Oct 6, 2020 at 4:50 PM Arun Patidar wrote: > Hello team, > > We have started discussion about OFBiz deployment on AWS platform for > production environment. Idea is to share and discuss the optimal way to > deploy OFBiz on AWS platform to achieve high availability and scalability > in the production environment. > > We are preparing a video series on this and will share on OFBiz youtube > channel. > > Anyone from the community can join this session and share your thoughts on > this. I will share the meeting URL with the timing of our next session > here shortly. > > > Regards > --- > Arun Patidar > > > >
Discussion: OFBiz deployment on AWS for production environment
Hello team, We have started discussion about OFBiz deployment on AWS platform for production environment. Idea is to share and discuss the optimal way to deploy OFBiz on AWS platform to achieve high availability and scalability in the production environment. We are preparing a video series on this and will share on OFBiz youtube channel. Anyone from the community can join this session and share your thoughts on this. I will share the meeting URL with the timing of our next session here shortly. Regards --- Arun Patidar
Re: Should the providers listed on Apache OFBiz confluence have landing page for OFBiz on their website
+1 Kind Regards, Arun Patidar DIRECTOR OF INFORMATION SYSTEMS mobile: +91 9827353082 landline: 0731-409-3684 email: arun.pati...@hotwax.co *www.hotwax.co <http://www.hotwax.co/>* <https://www.linkedin.com/company/hotwaxcommerce/> <https://www.facebook.com/HotWaxCommerce/> <https://twitter.com/hotwaxcommerce> On Thu, May 7, 2020 at 2:49 AM Rishi Solanki wrote: > Thanks for raising this, +1 for the idea and discussion on this, few points > needs to be consider; > > - Few providers listed here does not have website, what to suggest them? > - How to encourage providers for the this? > - Finally, is it fine to identify and ask such providers on OFBiz > confluence? > > Suggestion is, for quick start we can add Recommendation on page that > website should have information about Apache OFBiz. But no enforcement at > this point, as number of service providers listed and community activity > also required for project adoption IMO. > > Again big +1 for discussion on the topic, and based on discussion we can > finalize how to best handle this. > > > Best Regards, > -- > Rishi Solanki > *CTO, Mindpath Technology* > Intelligent Solutions > cell: +91-98932-87847 > LinkedIn <https://www.linkedin.com/in/rishi-solanki-62271b7/> > > > On Thu, May 7, 2020 at 12:30 AM Jacques Le Roux < > jacques.le.r...@les7arts.com> wrote: > > > Hi Anil, > > > > That sounds legit to me > > > > Jacques > > > > Le 06/05/2020 à 18:56, Anil Patel a écrit : > > > We have many service providers listed on Apache OFBiz confluence page. > > This > > > is a good thing. > > > > > > > > > https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Service+Providers > > > > > > I found that few providers don't even mention Apache OFBiz anywhere on > > > their website. Their marketing does not acknowledge or talk about > > services > > > on Apache OFBiz. > > > > > > I think it is fair for the Apache OFBiz community to require at least > one > > > landing page on providers' websites describing their services related > to > > > Apache OFBiz. > > > > > > I would love to know comments on this idea/concern. > > > > > > Thanks and Regards > > > Anil Patel > > > COO > > > HotWax Systems > > > http://www.hotwaxsystems.com > > > Cell: + 1 509 398 3120 > > > > >
Re: myportal config.
Looks like portalPageId is empty value in screen component://common/widget/PortalPageScreens.xml#showPortalPage. Please verify. Kind Regards, *Arun Patidar* On Thu, Mar 14, 2019 at 1:35 PM Wolfgang Paul Rauchholz < wp.rauchh...@gmail.com> wrote: > Good day Arun. Here we go > > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > screen [component://common/widget/PortalPageScreens.xml#showPortalPage]: > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > screen [component://myportal/widget/CommonScreens.xml#main-decorator]: > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > screen > [component://commonext/widget/CommonScreens.xml#ApplicationDecorator]: > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: > java.lang.RuntimeException: Could not find PortalPage with portalPageId [] > (Could not find PortalPage with portalPageId [] ) (Error rendering screen > [component://common/widget/CommonScreens.xml#GlobalDecorator]: > java.lang.RuntimeException: Could not find PortalPage with portalPageId [] > (Could not find PortalPage with portalPageId [] )) (Error rendering screen > [component://commonext/widget/CommonScreens.xml#ApplicationDecorator]: > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: > java.lang.RuntimeException: Could not find PortalPage with portalPageId [] > (Could not find PortalPage with portalPageId [] ) (Error rendering screen > [component://common/widget/CommonScreens.xml#GlobalDecorator]: > java.lang.RuntimeException: Could not find PortalPage with portalPageId [] > (Could not find PortalPage with portalPageId [] ))) (Error rendering screen > [component://myportal/widget/CommonScreens.xml#main-decorator]: > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > screen > [component://commonext/widget/CommonScreens.xml#ApplicationDecorator]: > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: > java.lang.RuntimeException: Could not find PortalPage with portalPageId [] > (Could not find PortalPage with portalPageId [] ) (Error rendering screen > [component://common/widget/CommonScreens.xml#GlobalDecorator]: > java.lang.RuntimeException: Could not find PortalPage with portalPageId [] > (Could not find PortalPage with portalPageId [] )) (Error rendering screen > [component://commonext/widget/CommonScreens.xml#ApplicationDecorator]: > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: > java.lang.RuntimeException: Could not find PortalPage with portalPageId [] > (Could not find PortalPage with portalPageId [] ) (Error rendering screen > [component://common/widget/CommonScreens.xml#GlobalDecorator]: > java.lang.RuntimeException: Could not find PortalPage with portalPageId [] > (Could not find PortalPage with portalPageId [] > > Wolfgang > > On Thu, Mar 14, 2019 at 6:27 AM Arun Patidar < > arun.pati...@hotwaxsystems.com> > wrote: > > > Hi WOlfgang, > > > > Please share your error message in detail here. > > > > Kind Regards, > > *Arun Patidar* | Manager, Enterprise Development > > HotWax Systems <http://www.hotwaxsystems.com/> > > Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, > > Indore, M.P. 452010 > > Linkedin: *Arun Patidar* <https://www.linkedin.com/in/arunpatidar> > > > > > > > > On Thu, Mar 7, 2019 at 11:11 PM wp.rauchh...@gmail.com < > > wp.rauchh...@gmail.com> wrote: > > > > > I'd appreciate a hint form the community in what I am doing wrong with > > the > > > myportal setup. I get a long error message when accessing: > > > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > > > screen [component://common. > > > > > > That is what I did: > > > I added a new security group MYPORTAL_EMPLOYEE (as in demo). > > > In permissions I added amongst others: MYPORTALBASE_ADMIN ALL MyPortal > > > base operations and > > > I created then a new Portal Page ID added as 'Owner User Login ID' my > > own > > > login, set the Security Group Id to MYPORTAL_EMPLOYEE and added > > portlets. > > > > > > But still not working, what am I missing? > > > What I notices is that - in contrast to the demo version - when I go to > > > Preferences part in MyPortal, I only can create a new Portal Page, the > > the > > > ones created do not show up there. > > > > > > Thanks, WOlfgang > > > > > > > > -- > > Wolfgang Rauchholz >
Re: myportal config.
Hi WOlfgang, Please share your error message in detail here. Kind Regards, *Arun Patidar* | Manager, Enterprise Development HotWax Systems <http://www.hotwaxsystems.com/> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, Indore, M.P. 452010 Linkedin: *Arun Patidar* <https://www.linkedin.com/in/arunpatidar> On Thu, Mar 7, 2019 at 11:11 PM wp.rauchh...@gmail.com < wp.rauchh...@gmail.com> wrote: > I'd appreciate a hint form the community in what I am doing wrong with the > myportal setup. I get a long error message when accessing: > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > screen [component://common. > > That is what I did: > I added a new security group MYPORTAL_EMPLOYEE (as in demo). > In permissions I added amongst others: MYPORTALBASE_ADMIN ALL MyPortal > base operations and > I created then a new Portal Page ID added as 'Owner User Login ID' my own > login, set the Security Group Id to MYPORTAL_EMPLOYEE and added portlets. > > But still not working, what am I missing? > What I notices is that - in contrast to the demo version - when I go to > Preferences part in MyPortal, I only can create a new Portal Page, the the > ones created do not show up there. > > Thanks, WOlfgang >
Re: Ofbiz accounting / ecomseo vs ecommerce
Hello Wolfgang, In trunk, there is support to enable/disable accounting transactions. Please refer 'enableAccounting' field of 'PartyAcctgPreference' entity. Kind Regards, *Arun Patidar* | Manager, Enterprise Development HotWax Systems <http://www.hotwaxsystems.com/> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, Indore, M.P. 452010 Linkedin: *Arun Patidar* <https://www.linkedin.com/in/arunpatidar> On Tue, Mar 5, 2019 at 10:55 PM wp.rauchholz wrote: > Is there a possibility to 'switch off' the financial modules of Ofbiz. The > bookkeeping is outsourced and the the provider runs their own system. > > > What exactly is the difference between ecomseo and ecommerce in Orbiz?? > Is there somewhere a bit more in-depth explanation then here? > > https://cwiki.apache.org/confluence/display/OFBIZ/Search+Engine+Optimisation%2C+SEO+in+ecommerce > > > > Thanks, Wolfgang > > > > -- > Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html >
Re: Product Configuration or Marketing Package
Hello James, You can use 'quickCompleteProductionRun' service for completing production directly. Kind Regards, *Arun Patidar* | Manager, Enterprise Development HotWax Systems <http://www.hotwaxsystems.com/> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, Indore, M.P. 452010 Linkedin: *Arun Patidar* <https://www.linkedin.com/in/arunpatidar> On Mon, Feb 25, 2019 at 7:27 PM wrote: > Thank you Arun. That makes perfect sense. Where do you configure auto > complete for production runs? > > Original Message > Subject: Re: Product Configuration or Marketing Package > From: Arun Patidar > Date: Mon, February 25, 2019 6:46 am > To: ofbizuser > Cc: arunpati...@apache.org > > Hello james, > > Your requirements fits with configurable products. IMO, you can auto > complete Production Run to skip additional steps before fulfilment. > > > > Kind Regards, > *Arun Patidar* | Manager, Enterprise Development > HotWax Systems <http://www.hotwaxsystems.com/> > Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, > Indore, M.P. 452010 > Linkedin: *Arun Patidar* <https://www.linkedin.com/in/arunpatidar> > > > > On Mon, Feb 25, 2019 at 6:08 PM wrote: > > > > > Anyone have any ideas or experienced this requirement before? > > Original Message > > Subject: Product Configuration or Marketing Package > > From: > > Date: Fri, February 22, 2019 2:13 am > > To: user@ofbiz.apache.org > > > > Good Day. I have a situation where I am selling a bundle Marketing > > Package of 12 different products. Normally this would simply be handled > > with marketing package except we want the user to be able to mix or > > match the products in the marketing package. So they can order 12 all > > of the same item, or the can order 2 each of 6 items, or they can order > > all 12 in the marketing package etc. > > > > What is the best way to handle this? Product Configuration? (If we use > > this it adds a production order step and might complicate the > > fulfillment process). Marketing package would be the best if it was > > configurable. Thoughts? > > > > Thanks, > > > > James > > >
Re: Product Configuration or Marketing Package
Hello james, Your requirements fits with configurable products. IMO, you can auto complete Production Run to skip additional steps before fulfilment. Kind Regards, *Arun Patidar* | Manager, Enterprise Development HotWax Systems <http://www.hotwaxsystems.com/> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center, Indore, M.P. 452010 Linkedin: *Arun Patidar* <https://www.linkedin.com/in/arunpatidar> On Mon, Feb 25, 2019 at 6:08 PM wrote: > > Anyone have any ideas or experienced this requirement before? > Original Message > Subject: Product Configuration or Marketing Package > From: > Date: Fri, February 22, 2019 2:13 am > To: user@ofbiz.apache.org > > Good Day. I have a situation where I am selling a bundle Marketing > Package of 12 different products. Normally this would simply be handled > with marketing package except we want the user to be able to mix or > match the products in the marketing package. So they can order 12 all > of the same item, or the can order 2 each of 6 items, or they can order > all 12 in the marketing package etc. > > What is the best way to handle this? Product Configuration? (If we use > this it adds a production order step and might complicate the > fulfillment process). Marketing package would be the best if it was > configurable. Thoughts? > > Thanks, > > James >
Re: E-commerce
Hello Shrilesh, You will need two accounts on Paypal, one as merchant account and another one as buyer account. Thanks & Regards --- Arun Patidar Director of Information SystemsHotWax Commerce <http://www.hotwax.co> On Sat, Jan 19, 2019 at 3:39 PM Shrilesh Korgaonkar < shrilesh.korgaon...@udyogmandir.in> wrote: > Hi, > I am trying to configure the PayPal dev account with ofbiz. To that effect > could someone please give me some idea about below please..It is the Api > environment property that I am confused about. > Is it supposed to be any random string that helps identify which > environment the PayPal call is made from.. i.e. my own test environment or > something that I need find from PayPal side? > > Accounting -> Payment Gateway Config -> PayPal Config -> > > Any pointers or links would be highly appreciated. > Regards > Shrilesh >
Re: Promotion on payment methods
Thanks Rishi for your inputs. Calling doPromotion from billing/checkout page will be an additional call in order process. Before calling doPromotion we will need to collect and set details about selected payment option to cart. WDYT? Thanks & Regards --- Arun Patidar Director of Information SystemsHotWax Commerce <http://www.hotwax.co> On Wed, Dec 12, 2018 at 7:27 PM Rishi Solanki wrote: > Hi Arun, > +1 for the requirement and good idea to have this. > > I could think of two ways to achieve this. > 1) Add support for this in the same fashion its done for shipping method. > Like shipping is free on selecting some shipping method. Consider the other > value in the condition rules. > 2) Map the promo codes with payment method. > > Not sure about the ideas shared are good but it should work perfectly. > > -- > Rishi Solanki > Sr Manager, Enterprise Software Development > HotWax Systems Pvt. Ltd. > Direct: +91-9893287847 > http://www.hotwaxsystems.com > www.hotwax.co > > > On Wed, Dec 12, 2018 at 7:05 PM Arun Patidar < > arun.pati...@hotwaxsystems.com> wrote: > >> Hello team, >> >> Wanted to apply promotion on selected payment method during checkout. Now >> a >> days, it is very common use case to give additional discounts on specific >> bank's Credit card, UPI or wallet etc. Payment options selection comes on >> checkout page. So, is it good to use Promotion engine for the same? >> >> >> Thanks & Regards >> --- >> Arun Patidar >> Director of Information SystemsHotWax Commerce <http://www.hotwax.co> >> >
Promotion on payment methods
Hello team, Wanted to apply promotion on selected payment method during checkout. Now a days, it is very common use case to give additional discounts on specific bank's Credit card, UPI or wallet etc. Payment options selection comes on checkout page. So, is it good to use Promotion engine for the same? Thanks & Regards --- Arun Patidar Director of Information SystemsHotWax Commerce <http://www.hotwax.co>
Re: OFBiz OutOfMemory and stucked JobPoller issue
Managing of Visits and serverHit data in separate DB is very easy and will be faster to delete old records without affecting the main DB. A dedicated server only for processing jobs performs well as per my experience. Apart from this, root cause should be identified and fixed as Taher mentioned. Kind Regards, Arun Patidar Director of Information Systems *HotWax CommerceReal OmniChannel. Real Results.* m: +91 9827353082 On Fri, Sep 21, 2018 at 4:07 PM Giulio Speri - MpStyle Srl < giulio.sp...@mpstyle.it> wrote: > Hi everyone, > > first of all, I'd like to thank you very much, for the quick response and > the suggestions you gave me. > We are absolutely convinced to investigate deeper into this issue and find > the root cause, because we strongly believe in the OFBiz framework and for > us it's becoming a core part of our business. > > To answer to @Arun: > regarding the large tables sizes: at the moment we're using the Visit table > (along with other tables) for Business Intelligence purposes, so what we > did and what we will do, in accordance with the customer, is to keep those > tables smaller, keeping record for the last XX days only and deleting > everything is older than that number of days (with a scheduled weekly > service, for example); this should keep the dimensions of those tables, > acceptable and at the same time give good data for BI analysis. > > Regarding the split service configuration, instead, we have our > installation setup in a very similar mode; we have front1 (ofbiz1 instance) > where the JobPoller is enabled and a second front where it is disabled > (ofbiz2 instance). Web requests, are however, served by both instances. > Indeed the problems we're having, are limited to front1 only (but we did > not test if, enabling the JobPoller on the front2, we obtain the same > behaviour). > > @Taher We gladly accept your help proposal, so should I proceed with the > creation of a Jira task? > > > Thank you very much, > > Giulio > > Il giorno ven 21 set 2018 alle ore 11:16 Ingo Wolfmayr < > ingo.wolfm...@wolfix.at> ha scritto: > > > The root cause on my side was using a groovy service that was called > > thousends of times with the caching of groovy scripts disabled. If you > to a > > heap cache analyzis check the count of groovy instances. It was fixed by > > change the caching of groovy scripts. Maybe that saves you some time. > > > > > > > > Gesendet von meinem Windows 10-Gerät. > > > > > > > > Von: Taher Alkhateeb<mailto:slidingfilame...@gmail.com> > > Gesendet: Freitag, 21. September 2018 11:01 > > An: OFBiz user mailing list<mailto:user@ofbiz.apache.org> > > Betreff: Re: OFBiz OutOfMemory and stucked JobPoller issue > > > > > > > > I think it would be much better if we can find a root-cause fix instead > of > > altering settings. I would be interested in helping out digging out > > whatever is causing the memory leak if Guilio is interested in opening a > > JIRA for this and investigating further. > > > > On Fri, Sep 21, 2018, 11:48 AM Ingo Wolfmayr > > wrote: > > > > > Hallo Guilio, > > > > > > I had a similar issue some time ago. My fix was to enable caching for > > > groovy scripts etc. > > > > > > framework/base/config/cache.properties. > > > > > > There is a part that starts says: # Development Mode - comment these > out > > > to better cache groovy scripts, etc > > > > > > After checking the heat cache analysis I found that for every groovy > > > script call a new instance of that class was created. Caching fixed it > > > completely. Maybe it will work for you too. You will then have to clear > > the > > > cache in ofbiz if you change something in your groovy scripts. > > > > > > Best regards > > > Ingo > > > > > > > > > -Ursprüngliche Nachricht- > > > Von: Giulio Speri - MpStyle Srl > > > Gesendet: Donnerstag, 20. September 2018 18:43 > > > An: user@ofbiz.apache.org > > > Betreff: OFBiz OutOfMemory and stucked JobPoller issue > > > > > > Hello everyone, > > > > > > hope you're doing good. > > > I am writing, because I am struggling with a quite strange problem, > over > > > an ofbiz installation, for one of our customers. > > > This installation is composed by two instances of OFBiz (v13.07.03), > > > served via an Apache Tomcat webserver, along with a load balancer. > > > The database server is MariaDB. > > > > > > We had
Re: OFBiz OutOfMemory and stucked JobPoller issue
Hello Giulio, For large size of Visit and ServerHit data issue, you can opt any one from below options: 1) Use separate DB for group="org.apache.ofbiz.stats" entities and make regular cleanup of this DB 2) If you are not using ServerHits and Visits data for analytical purpose then simply disable visits. Kind Regards, Arun Patidar Director of Information Systems *HotWax CommerceReal OmniChannel. Real Results.* m: +91 9827353082 On Thu, Sep 20, 2018 at 10:13 PM Giulio Speri - MpStyle Srl < giulio.sp...@mpstyle.it> wrote: > Hello everyone, > > hope you're doing good. > I am writing, because I am struggling with a quite strange problem, over an > ofbiz installation, for one of our customers. > This installation is composed by two instances of OFBiz (v13.07.03), served > via an Apache Tomcat webserver, along with a load balancer. > The database server is MariaDB. > > We had the first problems, about 3 weeks ago, when suddenly, the front1 > (ofbiz instance 1), stopped serving web requests; front2, instead, was > still working correctly. > > Obviously we checked the log files, and we saw that async services were > failing; the failure was accompanied by this error line: > > *Thread "AsyncAppender-async" java.lang.OutOfMemoryError: GC overhead limit > exceeded* > > We analyzed the situation with our system specialists, and they told us > that the application was highly stressing machine resources (cpu always at > or near 100%, RAM usage rapidly increasing), until the jvm run out of > memory. > This "resource-high-consumption situation", occurred only when ofbiz1 > instance was started with the JobPoller enabled; if the JobPoller was not > enabled, ofbiz run with low resource usage. > > We then focused on the db, to check first of all the dimensions; the result > was disconcerting; 45GB, mainly divided on four tables: SERVER_HIT (about > 18 GB), VISIT (about 15 GB), ENTITY_SYNC_REMOVE (about 8 GB), VISITOR > (about 2 GB). > All the other tables had a size in the order of few MB each. > > The first thing we did, was to clear all those tables, reducing > considerably the db size. > After the cleaning, we tried to start ofbiz1 again, with the JobPoller > component enabled; this caused a lot of old scheduled/queued jobs, to > execute. > Except than for the start-up time, the resource usage of the machine, > stabilized around normal to low values (cpu 1-10%). > Ofbiz seemed to work (web request was served), but we noticed taht the > JobPoller did not schedule or run jobs, anymore. > The number of job in "Pending" state in the JobSandbox entity was small > (about 20); no Queued, no Failed, no jobs in other states. > In addition to this, unfortunately, after few hours, jvm run out of memory > again. > > Our jvm has an heap maximum size of 20GB ( we have 32GB on the machine), > so it's not so small, I think. > The next step we're going to do is set-up locally the application over the > same production db to see what happens. > > Now that I explained the situation, I am going to ask if, in your > opinion/experience: > > Could the JobPoller component be the root (and only) cause of the > OutOfMemory of the jvm? > > Could this issue be related to this > https://issues.apache.org/jira/browse/OFBIZ-5710? > > Dumping and analyzing the heap of the jvm could help in some way to > understand what or who fills the memory or is this operation a waste of > time? > > Is there something that we did not considered or missed during the whole > process of problem analysis? > > > I really thank you all for your attention and your help; any suggestion or > advice would really be greatly appreciated. > > Kind regards, > Giulio > > > > > > > -- > Giulio Speri > > > *Mp Styl**e Srl* > via Antonio Meucci, 37 > 41019 Limidi di Soliera (MO) > T 059/684916 > M 334/3779851 > > www.mpstyle.it >
Re: OFBiz OutOfMemory and stucked JobPoller issue
Hello Giulio, You can split your OFBiz instance into two instances[1], one for processing synchronous web requests and another for processing only jobs(async server). In this way, you may narrow down your analyses. [1]: https://www.hotwaxsystems.com/ofbiz/ofbiz-tutorials/apache-ofbiz-performance/ Kind Regards, Arun Patidar Director of Information Systems *HotWax CommerceReal OmniChannel. Real Results.* m: +91 9827353082 w: www.hotwax.co <https://www.linkedin.com/company/hotwaxcommerce/> <https://www.facebook.com/HotWaxCommerce/> <https://twitter.com/hotwaxcommerce> On Thu, Sep 20, 2018 at 10:39 PM Taher Alkhateeb wrote: > This smells like a memory leak. The problem is how to pin down the exact > cause. Maybe something in network setting, or the job poller or something > else. > > Perhaps the first thing to try to do to narrow it down is to run a profiler > against the JVM to see where the leak is happening. If you can narrow down > the class / method then it would be much easier to handle. > > On Thu, Sep 20, 2018, 7:43 PM Giulio Speri - MpStyle Srl < > giulio.sp...@mpstyle.it> wrote: > > > Hello everyone, > > > > hope you're doing good. > > I am writing, because I am struggling with a quite strange problem, over > an > > ofbiz installation, for one of our customers. > > This installation is composed by two instances of OFBiz (v13.07.03), > served > > via an Apache Tomcat webserver, along with a load balancer. > > The database server is MariaDB. > > > > We had the first problems, about 3 weeks ago, when suddenly, the front1 > > (ofbiz instance 1), stopped serving web requests; front2, instead, was > > still working correctly. > > > > Obviously we checked the log files, and we saw that async services were > > failing; the failure was accompanied by this error line: > > > > *Thread "AsyncAppender-async" java.lang.OutOfMemoryError: GC overhead > limit > > exceeded* > > > > We analyzed the situation with our system specialists, and they told us > > that the application was highly stressing machine resources (cpu always > at > > or near 100%, RAM usage rapidly increasing), until the jvm run out of > > memory. > > This "resource-high-consumption situation", occurred only when ofbiz1 > > instance was started with the JobPoller enabled; if the JobPoller was not > > enabled, ofbiz run with low resource usage. > > > > We then focused on the db, to check first of all the dimensions; the > result > > was disconcerting; 45GB, mainly divided on four tables: SERVER_HIT (about > > 18 GB), VISIT (about 15 GB), ENTITY_SYNC_REMOVE (about 8 GB), VISITOR > > (about 2 GB). > > All the other tables had a size in the order of few MB each. > > > > The first thing we did, was to clear all those tables, reducing > > considerably the db size. > > After the cleaning, we tried to start ofbiz1 again, with the JobPoller > > component enabled; this caused a lot of old scheduled/queued jobs, to > > execute. > > Except than for the start-up time, the resource usage of the machine, > > stabilized around normal to low values (cpu 1-10%). > > Ofbiz seemed to work (web request was served), but we noticed taht the > > JobPoller did not schedule or run jobs, anymore. > > The number of job in "Pending" state in the JobSandbox entity was small > > (about 20); no Queued, no Failed, no jobs in other states. > > In addition to this, unfortunately, after few hours, jvm run out of > memory > > again. > > > > Our jvm has an heap maximum size of 20GB ( we have 32GB on the machine), > > so it's not so small, I think. > > The next step we're going to do is set-up locally the application over > the > > same production db to see what happens. > > > > Now that I explained the situation, I am going to ask if, in your > > opinion/experience: > > > > Could the JobPoller component be the root (and only) cause of the > > OutOfMemory of the jvm? > > > > Could this issue be related to this > > https://issues.apache.org/jira/browse/OFBIZ-5710? > > > > Dumping and analyzing the heap of the jvm could help in some way to > > understand what or who fills the memory or is this operation a waste of > > time? > > > > Is there something that we did not considered or missed during the whole > > process of problem analysis? > > > > > > I really thank you all for your attention and your help; any suggestion > or > > advice would really be greatly appreciated. > > > > Kind regards, > > Giulio > > > > > > > > > > > > > > -- > > Giulio Speri > > > > > > *Mp Styl**e Srl* > > via Antonio Meucci, 37 > > 41019 Limidi di Soliera (MO) > > T 059/684916 > > M 334/3779851 > > > > www.mpstyle.it > > >
Re: Ecommerce
Did you prepare and load VisualTheme data? Also, please check the name and path mention in this code block: Kind Regards, Arun Patidar Director of Information Systems *HotWax CommerceReal OmniChannel. Real Results.* m: +91 9827353082 w: www.hotwax.co <https://www.linkedin.com/company/hotwaxcommerce/> <https://www.facebook.com/HotWaxCommerce/> <https://twitter.com/hotwaxcommerce> On Wed, Sep 19, 2018 at 4:28 PM Shrilesh Korgaonkar < shrilesh.korgaon...@udyogmandir.in> wrote: > Theme.xml > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > xsi:noNamespaceSchemaLocation=" > http://ofbiz.apache.org/dtds/widget-theme.xsd";> > > > > > > > > value="/application-name/images/blog.css"/> > value="/application-name/css/custom.css"/> > value="/contentimages/css/contentForum.css"/> > > > > > value="component://application-name/template/includes/Header.ftl"/> > value="component://application-name/template/includes/Footer.ftl"/> > > > > On Wed, Sep 19, 2018 at 11:52 AM, Arun Patidar > wrote: > > > Hello Shrilesh, > > > > Did you use the component location for plugin file > > like: component://myplugin/template/Header.ftl > > > > You can also share your example code so that someone can catch the > missing > > things in it. > > > > > > Kind Regards, > > > > Arun Patidar > > Director of Information Systems > > > > *HotWax CommerceReal OmniChannel. Real Results.* > > m: +91 9827353082 > > w: www.hotwax.co > > > > <https://www.linkedin.com/company/hotwaxcommerce/> > > <https://www.facebook.com/HotWaxCommerce/> > > <https://twitter.com/hotwaxcommerce> > > > > > > > > On Wed, Sep 19, 2018 at 2:46 PM Shrilesh Korgaonkar < > > shrilesh.korgaon...@udyogmandir.in> wrote: > > > > > Yup I read that also created but still it's unable to load with my > plugin > > > Path of Theme.xml file:: plugins/application-name/widget/Theme.xml > > > > > > > > > > > > On Wed 19 Sep, 2018, 2:12 PM Arun Patidar, > > wrote: > > > > > > > Did you read and follow file [1] shared by Nicolas in another email > > > thread > > > > of you? > > > > > > > > > > > > > > > https://svn.apache.org/repos/asf/ofbiz/ofbiz-framework/ > > trunk/themes/README.md > > > > > > > > > > > > Kind Regards, > > > > > > > > Arun Patidar > > > > Director of Information Systems > > > > > > > > *HotWax CommerceReal OmniChannel. Real Results.* > > > > m: +91 9827353082 > > > > w: www.hotwax.co > > > > > > > > <https://www.linkedin.com/company/hotwaxcommerce/> > > > > <https://www.facebook.com/HotWaxCommerce/> > > > > <https://twitter.com/hotwaxcommerce> > > > > > > > > > > > > > > > > On Tue, Sep 18, 2018 at 9:55 PM Shrilesh Korgaonkar < > > > > shrilesh.korgaon...@udyogmandir.in> wrote: > > > > > > > > > Yup I tried hard coding it > > > > > But I need help in theme.xml file it not loading with my plugin > > > > > If I can load it I will able to edit without disturbing decorator > > > screen > > > > > > > > > > > > > > > On Tue 18 Sep, 2018, 7:06 PM Arun Patidar, > > > > > wrote: > > > > > > > > > > > Hello Shrilesh, > > > > > > > > > > > > Check the decorator screens locations in view-map path screens. > You > > > > will > > > > > > need to create/use your custom decorator. > > > > > > > > > > > > > > > > > > > > > > > > Kind Regards, > > > > > > > > > > > > Arun Patidar > > > > > > Director of Information Systems > > > > > > > > > > > > *HotWax CommerceReal OmniChannel. Real Results.* > > > > > > m: +91 9827353082 > > > > > > w: www.hotwax.co > > > > > > > > > > > > <https://www.linkedin.com/company/hotwaxcommerce/> > > > > > > <https://www.facebook.com/HotWaxCommerce/> > > > > > > <https://twitter.com/hotwaxcommerce> > > > > > > > > > > > > > > > > > > > > > > > > On Tue, Sep 18, 2018 at 5:31 AM Shrilesh Korgaonkar < > > > > > > shrilesh.korgaon...@udyogmandir.in> wrote: > > > > > > > > > > > > > I'm facing some problem > > > > > > > can anybody help me if possible > > > > > > > i have created a plugin and extended the ecommerce plugin > > > > > > > i successful created templates and view-map in controller.xml > > > > > > > but when i saw the source of html page > > > > > > > i notice that the page is using my templets as well as the > > existing > > > > > > > templets of the ecommerce > > > > > > > after creating Theme.xml and fixing header and footer in the > html > > > > page > > > > > > > source is still showing me the same thing it's header and > footer > > > are > > > > > > still > > > > > > > coming from ecommerce > > > > > > > > > > > > > > In simple words > > > > > > > how can i use my own created templete rather than using the > > > templete > > > > of > > > > > > > existing ecommerce application > > > > > > > in my own application > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Re: Ecommerce
Hello Shrilesh, Did you use the component location for plugin file like: component://myplugin/template/Header.ftl You can also share your example code so that someone can catch the missing things in it. Kind Regards, Arun Patidar Director of Information Systems *HotWax CommerceReal OmniChannel. Real Results.* m: +91 9827353082 w: www.hotwax.co <https://www.linkedin.com/company/hotwaxcommerce/> <https://www.facebook.com/HotWaxCommerce/> <https://twitter.com/hotwaxcommerce> On Wed, Sep 19, 2018 at 2:46 PM Shrilesh Korgaonkar < shrilesh.korgaon...@udyogmandir.in> wrote: > Yup I read that also created but still it's unable to load with my plugin > Path of Theme.xml file:: plugins/application-name/widget/Theme.xml > > > > On Wed 19 Sep, 2018, 2:12 PM Arun Patidar, wrote: > > > Did you read and follow file [1] shared by Nicolas in another email > thread > > of you? > > > > > > > https://svn.apache.org/repos/asf/ofbiz/ofbiz-framework/trunk/themes/README.md > > > > > > Kind Regards, > > > > Arun Patidar > > Director of Information Systems > > > > *HotWax CommerceReal OmniChannel. Real Results.* > > m: +91 9827353082 > > w: www.hotwax.co > > > > <https://www.linkedin.com/company/hotwaxcommerce/> > > <https://www.facebook.com/HotWaxCommerce/> > > <https://twitter.com/hotwaxcommerce> > > > > > > > > On Tue, Sep 18, 2018 at 9:55 PM Shrilesh Korgaonkar < > > shrilesh.korgaon...@udyogmandir.in> wrote: > > > > > Yup I tried hard coding it > > > But I need help in theme.xml file it not loading with my plugin > > > If I can load it I will able to edit without disturbing decorator > screen > > > > > > > > > On Tue 18 Sep, 2018, 7:06 PM Arun Patidar, > > wrote: > > > > > > > Hello Shrilesh, > > > > > > > > Check the decorator screens locations in view-map path screens. You > > will > > > > need to create/use your custom decorator. > > > > > > > > > > > > > > > > Kind Regards, > > > > > > > > Arun Patidar > > > > Director of Information Systems > > > > > > > > *HotWax CommerceReal OmniChannel. Real Results.* > > > > m: +91 9827353082 > > > > w: www.hotwax.co > > > > > > > > <https://www.linkedin.com/company/hotwaxcommerce/> > > > > <https://www.facebook.com/HotWaxCommerce/> > > > > <https://twitter.com/hotwaxcommerce> > > > > > > > > > > > > > > > > On Tue, Sep 18, 2018 at 5:31 AM Shrilesh Korgaonkar < > > > > shrilesh.korgaon...@udyogmandir.in> wrote: > > > > > > > > > I'm facing some problem > > > > > can anybody help me if possible > > > > > i have created a plugin and extended the ecommerce plugin > > > > > i successful created templates and view-map in controller.xml > > > > > but when i saw the source of html page > > > > > i notice that the page is using my templets as well as the existing > > > > > templets of the ecommerce > > > > > after creating Theme.xml and fixing header and footer in the html > > page > > > > > source is still showing me the same thing it's header and footer > are > > > > still > > > > > coming from ecommerce > > > > > > > > > > In simple words > > > > > how can i use my own created templete rather than using the > templete > > of > > > > > existing ecommerce application > > > > > in my own application > > > > > > > > > > > > > > >
Re: Ecommerce
Did you read and follow file [1] shared by Nicolas in another email thread of you? https://svn.apache.org/repos/asf/ofbiz/ofbiz-framework/trunk/themes/README.md Kind Regards, Arun Patidar Director of Information Systems *HotWax CommerceReal OmniChannel. Real Results.* m: +91 9827353082 w: www.hotwax.co <https://www.linkedin.com/company/hotwaxcommerce/> <https://www.facebook.com/HotWaxCommerce/> <https://twitter.com/hotwaxcommerce> On Tue, Sep 18, 2018 at 9:55 PM Shrilesh Korgaonkar < shrilesh.korgaon...@udyogmandir.in> wrote: > Yup I tried hard coding it > But I need help in theme.xml file it not loading with my plugin > If I can load it I will able to edit without disturbing decorator screen > > > On Tue 18 Sep, 2018, 7:06 PM Arun Patidar, wrote: > > > Hello Shrilesh, > > > > Check the decorator screens locations in view-map path screens. You will > > need to create/use your custom decorator. > > > > > > > > Kind Regards, > > > > Arun Patidar > > Director of Information Systems > > > > *HotWax CommerceReal OmniChannel. Real Results.* > > m: +91 9827353082 > > w: www.hotwax.co > > > > <https://www.linkedin.com/company/hotwaxcommerce/> > > <https://www.facebook.com/HotWaxCommerce/> > > <https://twitter.com/hotwaxcommerce> > > > > > > > > On Tue, Sep 18, 2018 at 5:31 AM Shrilesh Korgaonkar < > > shrilesh.korgaon...@udyogmandir.in> wrote: > > > > > I'm facing some problem > > > can anybody help me if possible > > > i have created a plugin and extended the ecommerce plugin > > > i successful created templates and view-map in controller.xml > > > but when i saw the source of html page > > > i notice that the page is using my templets as well as the existing > > > templets of the ecommerce > > > after creating Theme.xml and fixing header and footer in the html page > > > source is still showing me the same thing it's header and footer are > > still > > > coming from ecommerce > > > > > > In simple words > > > how can i use my own created templete rather than using the templete of > > > existing ecommerce application > > > in my own application > > > > > >
Re: Ecommerce
Hello Shrilesh, Check the decorator screens locations in view-map path screens. You will need to create/use your custom decorator. Kind Regards, Arun Patidar Director of Information Systems *HotWax CommerceReal OmniChannel. Real Results.* m: +91 9827353082 w: www.hotwax.co <https://www.linkedin.com/company/hotwaxcommerce/> <https://www.facebook.com/HotWaxCommerce/> <https://twitter.com/hotwaxcommerce> On Tue, Sep 18, 2018 at 5:31 AM Shrilesh Korgaonkar < shrilesh.korgaon...@udyogmandir.in> wrote: > I'm facing some problem > can anybody help me if possible > i have created a plugin and extended the ecommerce plugin > i successful created templates and view-map in controller.xml > but when i saw the source of html page > i notice that the page is using my templets as well as the existing > templets of the ecommerce > after creating Theme.xml and fixing header and footer in the html page > source is still showing me the same thing it's header and footer are still > coming from ecommerce > > In simple words > how can i use my own created templete rather than using the templete of > existing ecommerce application > in my own application >
Re: eCommerce Use Case
Price rule support available OOTB, you will only need to customize your rendering logic. Kind Regards, Arun Patidar Director of Information Systems *HotWax CommerceReal OmniChannel. Real Results.* m: +91 9827353082 w: www.hotwax.co <https://www.linkedin.com/company/hotwaxcommerce/> <https://www.facebook.com/HotWaxCommerce/> <https://twitter.com/hotwaxcommerce> On Wed, Sep 12, 2018 at 6:42 PM wrote: > I like recommendation #2. Can it be done OOTB? > > > Original Message > Subject: Re: eCommerce Use Case > From: Arun Patidar > Date: Wed, September 12, 2018 4:46 am > To: user@ofbiz.apache.org > Cc: arunpati...@apache.org > > Hi James, > > I can think about two way that can restrict/allow products specific to > the > logged-in user > > 1) You can use Agreement data model to specify party specific products. > This may need some customization for rendering products. > 2) You can create a price rule for user classifications and can render > products accordingly. Here, you can set a default price to zero for all > products of the special category. By using price rule, you can set the > price as per wholesale customer. During rendering, you will only show > products having price more than zero. WDYT? > > > Kind Regards, > > Arun Patidar > Director of Information Systems > > *HotWax CommerceReal OmniChannel. Real Results.* > m: +91 9827353082 > w: www.hotwax.co > > <https://www.linkedin.com/company/hotwaxcommerce/> > <https://www.facebook.com/HotWaxCommerce/> > <https://twitter.com/hotwaxcommerce> > > > > On Mon, Sep 10, 2018 at 10:21 PM wrote: > > > Yes. I have the price rules configured however there are some > > categories of product that I only want my wholesale customers to see. > > Is there a way to configure it so when a wholesale customer logs in they > > see an extra category? > > > > Original Message > > Subject: Re: eCommerce Use Case > > From: Rishi Solanki > > Date: Mon, September 10, 2018 9:09 am > > To: ofbizuser > > > > James, > > Please check the price rules screen for details - > > > > > https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductPriceRules?productPriceRuleId=9000 > > Here you can select the Input as Party Classification and assign > > condition > > and price for the whole sale parties. > > > > HTH! > > > > -- > > Rishi Solanki > > Sr Manager, Enterprise Software Development > > HotWax Systems Pvt. Ltd. > > Direct: +91-9893287847 > > http://www.hotwaxsystems.com > > www.hotwax.co > > > > > > On Sun, Sep 9, 2018 at 10:05 PM wrote: > > > > > Awesome. Thanks! > > > > > > How do you actually assign the party classification to the category so > > > that only that group sees it? > > > > > > Original Message > > > Subject: Re: eCommerce Use Case > > > From: Giulio Speri - MpStyle Srl > > > Date: Fri, September 07, 2018 1:31 pm > > > To: user@ofbiz.apache.org > > > > > > Hi James, > > > > > > In our ecommerce implementation we faced a similar situation. > > > We had some customers that should see a certain discount only on some > > > products and only after login. > > > We used "meta" categories, along with Party Classification Groups and > > > Price > > > rules. > > > > > > "meta" category is simply a catalog category that should contain the > > > products that only a certain group of customer (party classification > > > group) > > > will see after login. > > > > > > Once you've created the product category and the party classification > > > group, you can set up a Price Rule, with "product category" and "party > > > classification" as activating conditions and a discount action type, > > > based > > > on your needs, as price rule action. > > > > > > Hope it helps, > > > > > > Giulio > > > > > > > > > > > > > > > Il 07/Set/2018 17:53, ha scritto: > > > > > > > > > I was wondering with how roles worked in Ofbiz if the following is > > > possible: > > > > > > I want to have whole customers and retail customer shop on the same > > > website. Obviously wholesale customers would see their pricing when > > > they log in but there is also a few more products that I want only > > > wholesale customers to see when they log in. Is it possible to have > > > products or categories that some customer hgroups can see and others > can > > > not? > > > > > > Thanks, > > > > > > James > > > > > >
Re: Invoice Ready to Post After Shipment
Hi James, You can use ProductStore.autoApproveInvoice field for this use case. Kind Regards, Arun Patidar Director of Information Systems *HotWax CommerceReal OmniChannel. Real Results.* m: +91 9827353082 w: www.hotwax.co <https://www.linkedin.com/company/hotwaxcommerce/> <https://www.facebook.com/HotWaxCommerce/> <https://twitter.com/hotwaxcommerce> On Wed, Sep 12, 2018 at 12:14 PM wrote: > I have another use case when it comes to shipping especially when using > non integrated LTL over the standard integrated DHL, Fedex, USPS, > Stamps.com. After packing the product and getting the dimensions the > customer will typically call their freight broker and get the details of > the shipment along with their costs so they know what to charge the > customer for shipping. The problem I have run into is when you pack an > order it automatically creates an invoice in Ready to Post status > instead of In-Porcess Status. At this point you can't go into the > invoice and add additional freight charges. Is there a setting to only > create invoices in "In Process Status or is there a way to add to > invoices in Ready to Post status? > > thanks, > > James >
Re: eCommerce Use Case
Hi James, I can think about two way that can restrict/allow products specific to the logged-in user 1) You can use Agreement data model to specify party specific products. This may need some customization for rendering products. 2) You can create a price rule for user classifications and can render products accordingly. Here, you can set a default price to zero for all products of the special category. By using price rule, you can set the price as per wholesale customer. During rendering, you will only show products having price more than zero. WDYT? Kind Regards, Arun Patidar Director of Information Systems *HotWax CommerceReal OmniChannel. Real Results.* m: +91 9827353082 w: www.hotwax.co <https://www.linkedin.com/company/hotwaxcommerce/> <https://www.facebook.com/HotWaxCommerce/> <https://twitter.com/hotwaxcommerce> On Mon, Sep 10, 2018 at 10:21 PM wrote: > Yes. I have the price rules configured however there are some > categories of product that I only want my wholesale customers to see. > Is there a way to configure it so when a wholesale customer logs in they > see an extra category? > > Original Message > Subject: Re: eCommerce Use Case > From: Rishi Solanki > Date: Mon, September 10, 2018 9:09 am > To: ofbizuser > > James, > Please check the price rules screen for details - > > https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductPriceRules?productPriceRuleId=9000 > Here you can select the Input as Party Classification and assign > condition > and price for the whole sale parties. > > HTH! > > -- > Rishi Solanki > Sr Manager, Enterprise Software Development > HotWax Systems Pvt. Ltd. > Direct: +91-9893287847 > http://www.hotwaxsystems.com > www.hotwax.co > > > On Sun, Sep 9, 2018 at 10:05 PM wrote: > > > Awesome. Thanks! > > > > How do you actually assign the party classification to the category so > > that only that group sees it? > > > > Original Message > > Subject: Re: eCommerce Use Case > > From: Giulio Speri - MpStyle Srl > > Date: Fri, September 07, 2018 1:31 pm > > To: user@ofbiz.apache.org > > > > Hi James, > > > > In our ecommerce implementation we faced a similar situation. > > We had some customers that should see a certain discount only on some > > products and only after login. > > We used "meta" categories, along with Party Classification Groups and > > Price > > rules. > > > > "meta" category is simply a catalog category that should contain the > > products that only a certain group of customer (party classification > > group) > > will see after login. > > > > Once you've created the product category and the party classification > > group, you can set up a Price Rule, with "product category" and "party > > classification" as activating conditions and a discount action type, > > based > > on your needs, as price rule action. > > > > Hope it helps, > > > > Giulio > > > > > > > > > > Il 07/Set/2018 17:53, ha scritto: > > > > > > I was wondering with how roles worked in Ofbiz if the following is > > possible: > > > > I want to have whole customers and retail customer shop on the same > > website. Obviously wholesale customers would see their pricing when > > they log in but there is also a few more products that I want only > > wholesale customers to see when they log in. Is it possible to have > > products or categories that some customer hgroups can see and others can > > not? > > > > Thanks, > > > > James > > >
Re: Proposal: sending the specialpurpose/oagis component to Attic
Hello Brajesh, EDI support is not available in OFBiz till now. You will need to implement services for parsing EDI files and creating new EDI files for different processes. You can refer 'Smooks[1]' for EDI parsing. [1]: http://www.smooks.org/guide Kind Regards, Arun Patidar Director of Information Systems *HotWax CommerceReal OmniChannel. Real Results.* m: +91 9827353082 w: www.hotwax.co <https://www.linkedin.com/company/hotwaxcommerce/> <https://www.facebook.com/HotWaxCommerce/> <https://twitter.com/hotwaxcommerce> On Sat, Sep 8, 2018 at 10:11 PM Brajesh Patel wrote: > Hi All, > > I am working on a project where I need to implement EDI thing. > > Found this old thread, is there any component or services that having EDI > implementation in latest release? > > > > On Thu, Oct 6, 2016 at 4:33 AM Mike wrote: > > > > "Thank you for the feedback Mike. I do agree that providing some EDI > > functionality out of the box is very important for an ERP system. OFBiz > > already has a few mechanisms for data exchange that can be leveraged to > > implement specific or custom integrations." > > > > I remember looking in the oagis code and didn't really see anywhere how > it > > was connected to the code. Still, you mention that ofbiz has "some EDI > > functionality"? Can you clarify this? > > > > If HotWax integrated ofbiz with EDI, how did you do it? In real life, a > PO > > is created, and transmitted to/from a supplier via EDI. > > > > A while ago I was looking at BOTS ( > > http://bots.sourceforge.net/en/index.shtml) and it looked like a better > > solution. > > > > On Wed, Oct 5, 2016 at 7:14 AM, Jacopo Cappellato < > > jacopo.cappell...@hotwaxsystems.com> wrote: > > > > > The component has been removed in rev. 1763454 > > > > > > Thanks, > > > > > > Jacopo > > > > > > On Wed, Oct 5, 2016 at 11:16 AM, Jacopo Cappellato < > > > jacopo.cappell...@hotwaxsystems.com> wrote: > > > > > > > On Wed, Sep 28, 2016 at 11:22 PM, Mike wrote: > > > > > > > >> Great. So everyone seems to agree to dump oagis. Obviously someone > > > took > > > >> the time to create this component. My understanding it is used for > > > >> automating B2B communication for purchase orders, inventory, etc. > If > > > you > > > >> want ofbiz to play with the big boys, you need this TYPE of > Electronic > > > >> Data > > > >> Interchange (EDI) functionality. > > > >> > > > >> So: If you want to dump oagis, please propose alternatives to make > > > ofbiz > > > >> integrate with EDI. All ERPs have this. > > > >> > > > >> > > > > Thank you for the feedback Mike. > > > > I do agree that providing some EDI functionality out of the box is > very > > > > important for an ERP system. OFBiz already has a few mechanisms for > > data > > > > exchange that can be leveraged to implement specific or custom > > > > integrations. The concept of an universal data interchange standard > is > > > > great, but, as far as I know, OAGIS has never reached the critical > mass > > > to > > > > make it a viable solution for all integration needs. By experience I > > have > > > > noticed that such standards tend to gain more tractions when they > > address > > > > specific industries (e.g. parts interchange formats for the auto > parts > > > > aftermarket industry etc...). > > > > Most importantly, when it was adopted by OFBiz, the OAGIS license > > allowed > > > > us to include its xsd files; but after that, they have been > relicensed > > > > under an incompatible license: as a consequence this component is > stuck > > > to > > > > an years old and unmaintained version making even more difficult to > be > > > used > > > > to integrate with an external system. > > > > > > > > Kind regards, > > > > > > > > Jacopo > > > > > > > > > > > > > > > > > > > > -- > Thanks > Brajesh Patel > skype: brajesh.patel11 > Cell :- +91 8750709907 >
Re: Customer Agreements
Hello James, I am assuming that you want to set-up a commission agreement on total profit of sales order instead of Order sub-total. If yes, then you may need to customize the existing code. First of all, you will need a method to which calculates profit on order and then pass this profit amount to Calculate Commission service. On Tue, Jul 17, 2018 at 4:12 AM wrote: > It seems as if you only can create an agreement on the total sales > order. Is there a way to actually create the commissions agreement on > the profit of the sales order? > -- Best regards, Arun Patidar Director of Information SystemsHotWax Commerce <http://www.hotwax.co/>
Re: Mail List
Hi James, Everything looks OK with OFBiz mailing lists and I received your another email on this mailing list. On Sat, Jul 14, 2018 at 12:24 AM wrote: > Is there something wrong with our mail list? I haven't seen the volume > of emails that typically come through. I hope I am not talking to > myself :) > > > Thanks, > > > James > -- Best regards, Arun Patidar Director of Information SystemsHotWax Commerce <http://www.hotwax.co/>
Re: Payment Gateways
Hi James, You can find list of supported payment gateways in OFBiz at location /applications/accounting/src/main/java/org/apache/ofbiz/accounting/thirdparty/ BTW, your email content seems regarding shipping gateway :) On Fri, Jul 13, 2018 at 1:48 AM wrote: > Which payment gateways are still supported with Ofbiz? > > Thanks, > > James > > Original Message > Subject: USPS Integration > From: > Date: Fri, May 25, 2018 5:59 am > To: user@ofbiz.apache.org > > Does Ofbiz integrate into USPS? We have it working with UPS and Frdex > but can’t find the code for USPS > -- Best regards, Arun Patidar Director of Information SystemsHotWax Commerce <http://www.hotwax.co/>
Re: Question about product costing
Hi, In the code, value of 'taskCost' depends on fields 'estimatedTaskTime', 'usageCost.amount', 'setupTime' and 'setupCost.amount'. You can add log messages in 'getTaskCost' service to see the values of all these variables on the console. On Sun, Jun 17, 2018 at 2:59 PM wp.rauchh...@gmail.com < wp.rauchh...@gmail.com> wrote: > I setup a fingood that is produced. > > It consists of > (1) a single level Manufacturing BOM with 6 componens. All these > components have a PO cost setup and I ran 'Auto-Calculate Costs' for them, > meaning thet all have an 'Estimated Standard Materials Cost' > > (2) Routing > a) Manufacturing Manager > Cost > 2 Cost Component Cal Entrie: > > b) Manufacturing Manager > Routing Task > 1 Routing Tasks that include 2 Cost Components (COST COMPONENT TYPE ID ') > 'defined under a) > > c) Manufacturing Manager > Routing > 1 Routing that includes Routing Taks defined undere b) > > When I run now 'Auto-Calculate Costs' for the manufacturing product, I get > an error message. > > The Following Errors Occurred: > ERROR: Could not complete the Calculates the product's cost > [file:/usr/local/ofbiz_sam/applications/product/minilang/product/cost/CostServices.xml#calculateProductCosts] > process [problem invoking the [getTaskCost] service with the map named > [callSvcMap] containing [{workEffortId=1, > userLogin=[GenericEntity:UserLogin][createdStamp,2018-06-08 > 11:09:05.0(java.sql.Timestamp)][createdTxStamp,2018-06-08 > 11:09:05.0(java.sql.Timestamp)][currentPassword,$SHA$4g$nHI14NDsYqeu7vLMX5iFXS2Ni0U(java.lang.String)][disabledBy,null()][disabledDateTime,null()][enabled,Y(java.lang.String)][externalAuthId,null()][hasLoggedOut,N(java.lang.String)][isSystem,null()][lastCurrencyUom,null()][lastLocale,en_US(java.lang.String)][lastTimeZone,null()][lastUpdatedStamp,2018-06-17 > 11:00:09.0(java.sql.Timestamp)][lastUpdatedTxStamp,2018-06-17 > 11:00:09.0(java.sql.Timestamp)][partyId,wp.rauchholz(java.lang.String)][passwordHint,null()][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,null()][userLdapDn,null()][userLoginId,wp.rauchholz(java.lang.String)], > currencyUomId=BRL, routingId=10001, productId=1, locale=en_US}]: > Outgoing result (in runSync : getTaskCost) does not match expected > requirements (The following required parameter is missing: [OUT] > [getTaskCost.taskCost])] > > > I was looking in source code for [OUT] [getTaskCost.taskCost], but can't > find the root cause of the problem. > I'd appreciate if somebody could point me to the solution. > > Thanks you, Wolfgang > > > > -- Best regards, Arun Patidar Director of Information SystemsHotWax Commerce <http://www.hotwax.co/>
Re: No email from last 15 days
It's not true, On Sat, Jun 23, 2018 at 8:58 AM Brajesh Patel wrote: > -- > Thanks > Brajesh Patel > skype: brajesh.patel11 > Cell :- +91 8750709907 > -- Best regards, Arun Patidar Director of Information SystemsHotWax Commerce <http://www.hotwax.co/>
Re: discussion:provide official docker image of Apache OFBiz?
+1 On Thu, May 17, 2018 at 11:33 AM, deepak nigam wrote: > +1. > > Please let me know if I can be of any help in this effort. > > On Thu, May 17, 2018 at 8:59 AM, innate Genius > wrote: > > > +1 > > > > > On 17-May-2018, at 8:26 AM, Hans Bakker > > wrote: > > > > > > Good morning, > > > > > > Shouldn't we provide a official docker image in hub.docker.com as most > > open source projects do? > > > > > > This could ease the installation of ofbiz, even with including the > > dependencies which is possible with gradle >3.5 > > > > > > To already prepare, I reserved the ofbiz username . > > > > > > more info at: https://issues.apache.org/jira/browse/OFBIZ-10407 > > > > > > opinions? > > > > > > > > > -- > > > > > > Regards, > > > > > > Hans Bakker > > > CEO, http://antwebsystems.com > > > > > -- Best regards, Arun Patidar Director of Information SystemsHotWax Commerce <http://www.hotwax.co/>
Re: About OFBiz Email Passwords Sending
Hi Jacques, Here, there are issues 1) SystemProperty data issue with empty fields: Regarding this issue, you shared all history. Here, my opinion is to use "null-field" to specify an empty value in SytemProperty, like we do in XML forms and services. This will avoid confusion to use SystemProperty data with empty value. 2) XML data import overrides data value with empty fields Due to current changes, there is the ability to override existing data by empty value if we set the field as empty("") in XML file. So concern was to remove this override by removing empty values from XML data files if any. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development www.hotwaxsystems.comwww.hotwax.co On Mon, Mar 19, 2018 at 3:41 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Hi Arun, > > This value were added by me with http://svn.apache.org/viewvc?v > iew=revision&revision=1748560 > > < https://issues.apache.org/jira/browse/OFBIZ-7112 > > OFBiz reads properties from either a properties file or the > entity:SystemProperty. > The way it worked previously is that OFBiz reads from the > entity:SystemProperty first and if there is no value associated with the > target propertyname, it would then locate the value from the relevant > properties file. > In other words, if there is a database entry for a property, the database > entry should override the associated properties file. > The issue is that if a database entry exist but the value is empty, it > would look for a value from the properties file. > It should not do so. If a database entry exists for the propertyname of > interest, the value should be taken from the database even if it holds an > empty value. > > "isExistInDb" is first defined in Map > getSystemPropertyValue(String, String, Delegator). This method is call by > many other methods. "isExistInDb" is used to indicate whether the method > is returning an empty value for the property that 'exists' in the database > rather than as a result of an absent database entry for the property. > > The other methods... > boolean propertyValueEqualsIgnoreCase(String, String, String, Delegator) > String getPropertyValue(String, String, String, Delegator) > String getPropertyValue(String, String, Delegator) > String getMessage(String, String, Locale, Delegator) > uses the above method and needs to decide whether to use the empty value > returned (ie. empty value from an existing property entry in database) or > decide if it needs to read from the property file (ie. property entry does > not exist in database) > > jleroux: this also add systemPropertyValue data in > CommonSystemPropertyData.xml > >> >>> > We know this is a controversial matter for a long time, I agree we could > in the meantime decide to remove the empty values from DB. They are all in > general but > systemResourceId="sfa" systemPropertyId="save.outgoing.directory" > > I maintain that we need to eventually decide about my proposition at > https://markmail.org/message/opldepaevls3y3ob > > Jacques > > > > -- > > > Le 16/03/2018 à 09:42, Arun Patidar a écrit : > >> Hello Jacques, >> >> There are still some occurrences in the code for systemPropertyValue="". >> This empty field should be removed to prevent data overridden. Added an >> example data in the ticket OFBIZ-10282 >> >> >> >> >> >> >
Re: About OFBiz Email Passwords Sending
Hello Jacques, There are still some occurrences in the code for systemPropertyValue="". This empty field should be removed to prevent data overridden. Added an example data in the ticket OFBIZ-10282 -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development www.hotwaxsystems.comwww.hotwax.co On Fri, Mar 16, 2018 at 12:49 AM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Sorry missed to say that it's on the dev ML > > Jacques > > > > Le 15/03/2018 à 18:28, Jacques Le Roux a écrit : > >> Hi Suraj, >> >> Before diving in this action, could you please check the thread >> "Deprecate properties in favour of SystemProperties" >> >> Notably https://markmail.org/message/opldepaevls3y3ob >> >> Thanks >> >> Jacques >> >> >> Le 15/03/2018 à 12:53, Suraj Khurana a écrit : >> >>> Hi Michael, Schumann, >>> >>> As per some recent code changes, there are many empty fields in data >>> files >>> which removes the data when some reader is again loaded into the system. >>> Lets say I configured some email settings and mistakenly if ext reader is >>> loaded again, that data will be corrupted and user is unaware of that. >>> >>> This ticket is created for changes regarding the same: >>> https://issues.apache.org/jira/browse/OFBIZ-10282 >>> >>> HTH. >>> >>> -- >>> Thanks and Regards, >>> *Suraj Khurana* | Sr. Enterprise Software Engineer >>> HotWax Commerce by HotWax Systems >>> Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010 >>> >>> >>> >>> >>> >>> On Thu, Mar 15, 2018 at 4:14 PM, Michael Brohl >> > >>> wrote: >>> >>> Hi Schumann, >>>> >>>> please have a look at the SystemProperty table. Currently the demo data >>>> loads some configuration for email so the changes in general.properties >>>> are >>>> partly overwritten in the configuration logic. Either change the >>>> database >>>> entries or remove them to use general.properties settings. >>>> >>>> Best regards, >>>> >>>> Michael Brohl >>>> ecomify GmbH >>>> www.ecomify.de >>>> >>>> >>>> Am 15.03.18 um 10:20 schrieb Schumann Ye: >>>> >>>> Dear Gurus, >>>> >>>>> When I try to activate OFBiz Passwords Forget (Email Passwords >>>>> function) >>>>> in the Login webpage, I have got the following Error message: >>>>> >>>>> The Following Errors Occurred: >>>>> Error occurred: unable to email password. Please try again later or >>>>> contact customer service. (error was: [CON] Connection error when >>>>> sending >>>>> message to ***@hotmail.com from @ >>>>> outlook.com >>>>> cc bcc subject New Password Sent (my own user login id)). >>>>> >>>>> What I have done in customizing the OFBiz Email Passwords is as >>>>> follows: >>>>> >>>>> 1. Update the fields (which are not null) From_Address, CC_Address >>>>> and BCC_Address from tables ofbiz.product_store_email_setting and >>>>> ofbiz.email_template_setting to sending email address >>>>> **@ >>>>> outlook.com >>>>> >>>>> 2. Modify the file general.properties as follows: >>>>> # -- general default 'fromEmailAddress' can be overridden in: >>>>> EmailTemplateSetting >>>>> defaultFromEmailAddress=**@outlook.com >>>>> >>>>> # -- mail notifications enabled (Y|N) >>>>> mail.notifications.enabled=Y >>>>> >>>>> # -- redirect all mail notifications to this address for testing >>>>> #mail.notifications.redirectTo= >>>>> >>>>> # -- the default mail server to use >>>>> mail.smtp.relay.host=smtp.office365.com >>>>> >>>>> # -- SMTP Auth settings >>>>> mail.smtp.auth.user=**(my outlook mail name with >>>>> the @outlook.com) >>>>> mail.smtp.auth.password=***(my outlook mailbox >>>>> passwords) >>>>> >
Re: Invoice in status approved - cancel
Hello Ingo, Your point makes sense. I am not able to think about any scenario in which current status change flow is valid. This seems a bug and you can raise a ticket in Jira for same. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development www.hotwaxsystems.comwww.hotwax.co On Tue, Jan 30, 2018 at 1:35 PM, Ingo Wolfmayr wrote: > Hi everyone, > > when I create an invoice and set it to status "INVOICE_APPROVED" it is not > possible to cancel the invoice as the status change is not available. If I > change the status to "INVOICE_READY" it is again possible to cancel the > invoice. I would like to know the reason why the invoice cannot be > cancelled in status "INVOICE_APPROVED" but can be done later. > > 1. Create invoice (sales invoice) > 2. Set status to "INVOICE_APPROVED": available status changes: > INVOICE_SEND, INVOICE_READY > 3. Set status to "INVOICE_READY": available status changes: INVOICE_PAID, > INVOICE_CANCELLED, INVOICE_PAIDOFF > > Thanks for any information. > Best regards > Ingo > > >
Re: Java 8 Testing
Hello Skip, You can refer Jira ticket OFBIZ-6458< https://issues.apache.org/jira/browse/OFBIZ-6458> for upgrading OFBiz to Java 8. Changes committed to trunk at r1709262 by Taher. As you are on release 12 so you may need some additional changes. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd. www.hotwaxsystems.com On Sat, Dec 9, 2017 at 6:14 AM, Skip wrote: > I installed Java 8 and tried running Ofbiz version 12 with it and it failed > miserably. I got client handshake errors using Chrome and Firefox. Never > got to testing the UPS handshake. > > > I have three servers running on Windows 7 and I need this UPS connection to > work. > > > > > > Here is the UPS notification email: > > Important Update: Implementing TLS Security Protocol > > UPS is committed to ensuring the most current security requirements are > being used with our customers when shipment data is transmitted. To help > ensure your shipping data remains encrypted, the security communication > protocol for interactions with web-based applications must be upgraded to > TLS 1.1 or 1.2. > > UPS will be making changes beginning September 1, 2017 through December 31, > 2017 to support enhancing our security. During this time, you may see > intermittent failures for transactions using TLS1.0 or earlier. > > Effective 12/31/2017, UPS will only accept TLS 1.1 and 1.2 security > protocols. It is highly recommended that the most current version, TLS 1.2, > be implemented. After that date, any communication requests submitted to > UPS > using older protocols (TLS 1.0 or earlier) will fail. > > > > Anyone have any ideas? > > > > > > >
Re: multitenancy
Hello Fred, Good to know that your tenant setup is up and running. Yes, you may need some customization to achieve your business use case. As an additional note, for accessing specific tenant data from the master, you will need to pass tenantId as a request parameter. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd. www.hotwaxsystems.com On Fri, Dec 22, 2017 at 4:37 AM, Fred Wang wrote: > I reinstalled master and tenant t1. it works now. I used following > gradle command to create tenant: > gradlew createTenant -PtenantId=t1 -PtenantName="great first tenant" > -PdomainName=t1.ness.com -PtenantReaders=seed,seed-initial,ext,demo > -PdbPlatform=P -PdbIp=127.0.0.1 -PdbUser=ofbiz -PdbPassword=ofbiz > > made sure the hosts file was correct and then updated the master and > t1's web site with the specific domain name, like master.ness.com and > t1.ness.com. Now https://mast.ness.com:8443/ecommerce goes to master > web store https://t1.ness.com:8443/ecommerce goes to t1's web store. > > Our business model requires master web store can display and place > order for any tenant's product, and payments have to go to master > first, then transferred to tenants after fee. Looks like it the OOTB > multi-tenancy won't help much, we may have to develop our own > multi-tenancy. > > On 21 December 2017 at 00:19, Arun Patidar > wrote: > > Hello Fred, > > > > Did you use TenantDomainName entity for specifying the domain name of > your > > tenant? This will work for both front-end and back-end. > > > > You will need to make an entry in hosts file to redirect 'abc.com' > tenant > > on your local server(127.0.0.1) as similar to 'localhost' > > > > > > > > > > -- > > Thanks & Regards > > --- > > Arun Patidar > > Manager, Enterprise Software Development > > > > www.hotwax.co <http://www.hotwaxsystems.com/>www.hotwaxsystems.com > > > > > > On Thu, Dec 21, 2017 at 1:27 PM, Fred Wang > wrote: > > > >> "Along with host entry on the local instance" > >> I guess you mean to add the sub-domain to tenant's front site? Because > it > >> only runs on HTTPS 8443 OOTB, should I add HTTPS entry and HTTPS port? > >> > >> I am dreaming someone can build a multi-tenant docker image to demo this > >> feature. > >> > >> > >> On Dec 20, 2017 8:23 PM, "Arun Patidar" > > >> wrote: > >> > >> Hello Fred, > >> > >> You can use 'TenantDomainName' entity for setting domain name for each > >> tenant. Along with host entry on the local instance. System is capable > to > >> identify tenant on the basis of domain/sub-domain. > >> > >> ''BILL_FROM_VENDOR' party id in the demo instance is 'Company'. > >> > >> > >> On Thu, Dec 21, 2017 at 6:37 AM, Fred Wang > >> wrote: > >> > >> > thanks Arun for the warm reply. I am new to Ofbiz, Please forgive me > for > >> > asking naive questions. Please see my comments inline. > >> > > >> > On 19 December 2017 at 22:09, Arun Patidar > >> com > >> > > > >> > wrote: > >> > > >> > > Hello Fred, > >> > > > >> > > Please see my comments inline: > >> > > > >> > > On Wed, Dec 20, 2017 at 6:03 AM, Wang, Fred LDB:EX < > >> fred.w...@bcldb.com> > >> > > wrote: > >> > > > >> > > Hi All, > >> > > > > >> > > > Our company has chosen Ofbiz as our ecommerce/erp platform. We are > >> > having > >> > > > difficulties to understand and configure the multi-tenancy. > >> > > > > >> > > > Our plan is as below, it's kind of like Amazon/eBay model. > >> > > > > >> > > > 1. Each tenant will have their own front store, say tenant A will > >> > have a > >> > > > front store a.example.com; document says it's supported out of > box, > >> > but > >> > > I > >> > > > cannot find any doc that describes how to setup. > >> > > > > >> > > > >> > > > >> > > Refer below links regarding multi-tenant setup: > >> > > https://cwiki.apache.org/confluence/x/Rwzi > >> > > https://cwiki
Re: multitenancy
Hello Fred, Did you use TenantDomainName entity for specifying the domain name of your tenant? This will work for both front-end and back-end. You will need to make an entry in hosts file to redirect 'abc.com' tenant on your local server(127.0.0.1) as similar to 'localhost' -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development www.hotwax.co <http://www.hotwaxsystems.com/>www.hotwaxsystems.com On Thu, Dec 21, 2017 at 1:27 PM, Fred Wang wrote: > "Along with host entry on the local instance" > I guess you mean to add the sub-domain to tenant's front site? Because it > only runs on HTTPS 8443 OOTB, should I add HTTPS entry and HTTPS port? > > I am dreaming someone can build a multi-tenant docker image to demo this > feature. > > > On Dec 20, 2017 8:23 PM, "Arun Patidar" > wrote: > > Hello Fred, > > You can use 'TenantDomainName' entity for setting domain name for each > tenant. Along with host entry on the local instance. System is capable to > identify tenant on the basis of domain/sub-domain. > > ''BILL_FROM_VENDOR' party id in the demo instance is 'Company'. > > > On Thu, Dec 21, 2017 at 6:37 AM, Fred Wang > wrote: > > > thanks Arun for the warm reply. I am new to Ofbiz, Please forgive me for > > asking naive questions. Please see my comments inline. > > > > On 19 December 2017 at 22:09, Arun Patidar com > > > > > wrote: > > > > > Hello Fred, > > > > > > Please see my comments inline: > > > > > > On Wed, Dec 20, 2017 at 6:03 AM, Wang, Fred LDB:EX < > fred.w...@bcldb.com> > > > wrote: > > > > > > Hi All, > > > > > > > > Our company has chosen Ofbiz as our ecommerce/erp platform. We are > > having > > > > difficulties to understand and configure the multi-tenancy. > > > > > > > > Our plan is as below, it's kind of like Amazon/eBay model. > > > > > > > > 1. Each tenant will have their own front store, say tenant A will > > have a > > > > front store a.example.com; document says it's supported out of box, > > but > > > I > > > > cannot find any doc that describes how to setup. > > > > > > > > > > > > > Refer below links regarding multi-tenant setup: > > > https://cwiki.apache.org/confluence/x/Rwzi > > > https://cwiki.apache.org/confluence/x/9oT0Ag > > > > > > Fred: Before this email, I have followed the docs and get tenant t1 > > > running on back end before this email. The master front store is > working, > > > but I still cannot get t1 front store running. I have only one > instance > > > running. I tried to manipulate the Https Host and Https Port in t1's > > > webstore. Say, master has master.ness.com:8443 and t1 has > > > t1.ness.com8443. I also edited the hosts file accordingly. The dns > names > > > are working, however t1.ness.com is always pointing to the master > site. > > > not sure where went wrong. > > > > > > > > > > > 2. The master front store is the overall front store, say > example.com > > , > > > > which can display products from any tenants. Users have to go through > > > > master store to get to tenant stores. They will be redirected to > master > > > > store if they go to tenant store directly. This may not be out of > box, > > > can > > > > someone shed a light how big the change is? > > > > > > > > > > This looks multi stores scenario instead of multi tenant. You can > achive > > it > > > by creating multiple stores in single DB and check the products of any > > > store. If Company parties are different for each store then you can go > > for > > > Multi store-multi company scenario. > > > > > > In multi tenant, system can connect with single tenant at a time. So > > multi > > > tenancy does not fit in this use case. > > > > > > Fred: that's what I thought. Our business requires multi tenant > instead > > > of multi stores in single DB. Looks like we have to customize here. > > > > > > > > 3. Tenant stores can be embedded in overall store. One can image the > > > > upper part of the home page shows the promotions from some tenant > > stores, > > > > the lower part shows the entry point of specific tenant stores. I > think > > > if >
Re: multitenancy
Hello Fred, You can use 'TenantDomainName' entity for setting domain name for each tenant. Along with host entry on the local instance. System is capable to identify tenant on the basis of domain/sub-domain. ''BILL_FROM_VENDOR' party id in the demo instance is 'Company'. On Thu, Dec 21, 2017 at 6:37 AM, Fred Wang wrote: > thanks Arun for the warm reply. I am new to Ofbiz, Please forgive me for > asking naive questions. Please see my comments inline. > > On 19 December 2017 at 22:09, Arun Patidar > > wrote: > > > Hello Fred, > > > > Please see my comments inline: > > > > On Wed, Dec 20, 2017 at 6:03 AM, Wang, Fred LDB:EX > > wrote: > > > > Hi All, > > > > > > Our company has chosen Ofbiz as our ecommerce/erp platform. We are > having > > > difficulties to understand and configure the multi-tenancy. > > > > > > Our plan is as below, it's kind of like Amazon/eBay model. > > > > > > 1. Each tenant will have their own front store, say tenant A will > have a > > > front store a.example.com; document says it's supported out of box, > but > > I > > > cannot find any doc that describes how to setup. > > > > > > > > > Refer below links regarding multi-tenant setup: > > https://cwiki.apache.org/confluence/x/Rwzi > > https://cwiki.apache.org/confluence/x/9oT0Ag > > > > Fred: Before this email, I have followed the docs and get tenant t1 > > running on back end before this email. The master front store is working, > > but I still cannot get t1 front store running. I have only one instance > > running. I tried to manipulate the Https Host and Https Port in t1's > > webstore. Say, master has master.ness.com:8443 and t1 has > > t1.ness.com8443. I also edited the hosts file accordingly. The dns names > > are working, however t1.ness.com is always pointing to the master site. > > not sure where went wrong. > > > > > > > > 2. The master front store is the overall front store, say example.com > , > > > which can display products from any tenants. Users have to go through > > > master store to get to tenant stores. They will be redirected to master > > > store if they go to tenant store directly. This may not be out of box, > > can > > > someone shed a light how big the change is? > > > > > > > This looks multi stores scenario instead of multi tenant. You can achive > it > > by creating multiple stores in single DB and check the products of any > > store. If Company parties are different for each store then you can go > for > > Multi store-multi company scenario. > > > > In multi tenant, system can connect with single tenant at a time. So > multi > > tenancy does not fit in this use case. > > > > Fred: that's what I thought. Our business requires multi tenant instead > > of multi stores in single DB. Looks like we have to customize here. > > > > > > 3. Tenant stores can be embedded in overall store. One can image the > > > upper part of the home page shows the promotions from some tenant > stores, > > > the lower part shows the entry point of specific tenant stores. I think > > if > > > 2 can be done, this one will be relatively simple. > > > > > > > Same as #2 > > > > > > > > > > 4. Sales order can include products from different tenant. Here comes > > > order split and aggregation, I don't think it's out of box. > > > > > > > Same as #2 > > > > > > > > > > 5. The sales orders are fulfilled by tenants, but the money has to be > > > received by master first, then transferred to tenant after fee. Again, > I > > do > > > think it's out of box. > > > > > > > You can set master party as a 'BILL_FROM_VENDOR' party on Order and set > > other party in any different role to calculate transfer amount after fee. > > You can refer Commission Run feature of OOTB for calculating transfer > > amount. > > > > Fred: is this for multi store in single DB or multi tenant? what is the > > actual party id in demo store? > > > > > > As many have reported, the documentation is short, outdated and > > > duplicated. It's pretty hard to follow documents to do the setup and > > > development. > > > > > > It's greatly appreciated if anyone can recommend some training courses, > > > video or consulting service. > > > > > > > > > Please let me know if you have any concern. > > > > > > > > -- > > Thanks & Regards > > --- > > Arun Patidar > > Manager, Enterprise Software Development > > > > www.hotwaxsystems.comwww.hotwax.co > > > > > > > > > > > > > > > > Fred Wang > > > > > >
Re: multitenancy
Hello Fred, Please see my comments inline: On Wed, Dec 20, 2017 at 6:03 AM, Wang, Fred LDB:EX wrote: Hi All, > > Our company has chosen Ofbiz as our ecommerce/erp platform. We are having > difficulties to understand and configure the multi-tenancy. > > Our plan is as below, it's kind of like Amazon/eBay model. > > 1. Each tenant will have their own front store, say tenant A will have a > front store a.example.com; document says it's supported out of box, but I > cannot find any doc that describes how to setup. > Refer below links regarding multi-tenant setup: https://cwiki.apache.org/confluence/x/Rwzi https://cwiki.apache.org/confluence/x/9oT0Ag > > 2. The master front store is the overall front store, say example.com, > which can display products from any tenants. Users have to go through > master store to get to tenant stores. They will be redirected to master > store if they go to tenant store directly. This may not be out of box, can > someone shed a light how big the change is? > This looks multi stores scenario instead of multi tenant. You can achive it by creating multiple stores in single DB and check the products of any store. If Company parties are different for each store then you can go for Multi store-multi company scenario. In multi tenant, system can connect with single tenant at a time. So multi tenancy does not fit in this use case. > > 3. Tenant stores can be embedded in overall store. One can image the > upper part of the home page shows the promotions from some tenant stores, > the lower part shows the entry point of specific tenant stores. I think if > 2 can be done, this one will be relatively simple. > Same as #2 > > 4. Sales order can include products from different tenant. Here comes > order split and aggregation, I don't think it's out of box. > Same as #2 > > 5. The sales orders are fulfilled by tenants, but the money has to be > received by master first, then transferred to tenant after fee. Again, I do > think it's out of box. > You can set master party as a 'BILL_FROM_VENDOR' party on Order and set other party in any different role to calculate transfer amount after fee. You can refer Commission Run feature of OOTB for calculating transfer amount. > > As many have reported, the documentation is short, outdated and > duplicated. It's pretty hard to follow documents to do the setup and > development. > > It's greatly appreciated if anyone can recommend some training courses, > video or consulting service. > Please let me know if you have any concern. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development www.hotwaxsystems.comwww.hotwax.co > > Fred Wang >
Re: multitenancy
Refer below links to enable multi tenant feature in OOTB https://cwiki.apache.org/confluence/x/Rwzi https://cwiki.apache.org/confluence/x/9oT0Ag -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd. www.hotwaxsystems.com On Wed, Dec 20, 2017 at 6:03 AM, Wang, Fred LDB:EX wrote: > Hi All, > > Our company has chosen Ofbiz as our ecommerce/erp platform. We are having > difficulties to understand and configure the multi-tenancy. > > Our plan is as below, it's kind of like Amazon/eBay model. > > 1. Each tenant will have their own front store, say tenant A will have a > front store a.example.com; document says it's supported out of box, but I > cannot find any doc that describes how to setup. > > 2. The master front store is the overall front store, say example.com, > which can display products from any tenants. Users have to go through > master store to get to tenant stores. They will be redirected to master > store if they go to tenant store directly. This may not be out of box, can > someone shed a light how big the change is? > > 3. Tenant stores can be embedded in overall store. One can image the > upper part of the home page shows the promotions from some tenant stores, > the lower part shows the entry point of specific tenant stores. I think if > 2 can be done, this one will be relatively simple. > > 4. Sales order can include products from different tenant. Here comes > order split and aggregation, I don't think it's out of box. > > 5. The sales orders are fulfilled by tenants, but the money has to be > received by master first, then transferred to tenant after fee. Again, I do > think it's out of box. > > As many have reported, the documentation is short, outdated and > duplicated. It's pretty hard to follow documents to do the setup and > development. > > It's greatly appreciated if anyone can recommend some training courses, > video or consulting service. > > Fred Wang >
Re: [ANNOUNCE] The Big Book for Apache OFBiz Data Model 2017 Released
Awesome work team. Thanks Aditya, Sonal, Pranay, Deepak and all who involved. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd. www.hotwaxsystems.com On Thu, Oct 5, 2017 at 8:30 PM, Paul Mandeltort wrote: > Incredible! Thank you so much to everyone who pulled this together! > > > On Oct 5, 2017, 5:33 AM -0500, Aditya Sharma com>, wrote: > > Hello All, > > > > It gives me immense pleasure informing you all that we have updated *The > Big > > Book of Apache OFBiz Data Model* according to the latest trunk version. > > > > The key features: > > * Colored content with titles according to the internal color pattern. > > * Addition of a separate page for integration specific entities. > > * Removal of technical process diagrams, making it specific for entities. > > * Addition of 77 new entities. > > * Removal of 8 entities. > > * Addition of around 200+ new fields in entities (Though major portion > > includes the addition of description or attrDescription fields in > > *Attribute or *TypeAttr entities). > > * Removal of 24 fields. > > > > Thanks to Sonal Patwari for all the effort she put in this whole task. > > Thanks to Pranay Pandey and Deepak Dixit for the guidance provided. > > > > I have uploaded the files on Data Model Diagrams page. Here is the link > > <https://cwiki.apache.org/confluence/x/8ILK>. > > > > Cheers! > > > > *Aditya Sharma* | Enterprise Software Engineer > > HotWax Systems <http://www.hotwaxsystems.com/ > > <https://www.linkedin.com/in/aditya-sharma-78291810a/ >
Re: Tenant Login Issue in OFBiz 16.11
Hello Taher, Yes, it is possible to run domain/sub-domain on localhost by making changes in the file */etc/hosts* of Ubuntu environment. It requires putting the domain name in front of local IP 127.0.0.1. Also, there is a domain_name field in Tenant entity that can be used for specifying a domain name for each tenant. IMO, in real time environment of multi-tenant, there should be a unique domain/sub-domain for each tenant. So we are safe to close Jira ticket. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd. www.hotwaxsystems.com On Tue, Oct 3, 2017 at 6:10 PM, Taher Alkhateeb wrote: > Hi Arun, > > So does that work for developers on localhost? Is it an acceptable > compromise to ignore and close the JIRA? > > On Oct 3, 2017 3:36 PM, "Arun Patidar" > wrote: > > > Hi Taher, > > > > Thanks for fixing the issue. The issue of multi-tenant logins in the same > > browser can be achieved by using sub-domain in URL for each tenant. In > this > > way, there will be a separate session and cookie management. > > > > -- > > Thanks & Regards > > --- > > Arun Patidar > > Manager, Enterprise Software Development > > > > HotWax Systems Pvt Ltd. > > > > www.hotwaxsystems.com > > > > > > On Fri, Sep 29, 2017 at 9:45 PM, Jacques Le Roux < > > jacques.le.r...@les7arts.com> wrote: > > > > > Le 29/09/2017 à 17:49, Taher Alkhateeb a écrit : > > > > > >> Very happy to note that I finally cracked the puzzle on this bug. It's > > >> a simple case of readers=tenant that was missing in the build script. > > >> This bug was always there since the introduction of gradle. So I will > > >> fix it and backport to branch 16. You can check [1] for more. > > >> > > >> However, given that this bug was discovered so late gives me an > > >> indication that very few people are interested in the multi-tenancy > > >> feature in OFBiz. > > >> > > > That's a good news anyway, thanks Taher > > > > > > Jacques > > > > > > > > > > > >> [1] https://issues.apache.org/jira/browse/OFBIZ-9278 > > >> > > >> On Mon, Jul 17, 2017 at 2:59 PM, vivek.mi > wrote: > > >> > > >>> I did try. I created two tenants with: > > >>> > > >>> 1. *./gradlew createTenant -PtenantId=mytenant -PtenantName="My Name" > > >>> -PdomainName=com.example -PtenantReaders=seed,seed-initial,ext > > >>> -PdbPlatform=M -PdbIp=127.0.0.1 -PdbUser=mydbuser > > -PdbPassword=mydbpass* > > >>> > > >>> Tenant1: CAD > > >>> Tenant 2: DDS > > >>> > > >>> 2. Used ./gradlew ofbiz > > >>> 3. Login with CAD-admin (first tenant), login successful > > >>> 4. Login with DDS-admin (second tenant), following error: > > >>> > > >>> Can't access entity of entityGroup = org.apache.ofbiz.tenant using > > tenant > > >>> delegator default#DDS, use base delegator instead > > >>> 2017-07-17 17:44:41,665 |OFBiz-batch-9|GenericDelegator > > >>> |I| Delegator "default#DDS" NOT initializing helper for entity group > > >>> "org.apache.ofbiz.tenant" because the group is not associated to this > > >>> delegator. > > >>> 2017-07-17 17:44:41,666 |OFBiz-batch-8|GenericDelegator > > >>> |I| Delegator "default#DDS" initializing helper "localpostgres" for > > >>> entity > > >>> group "org.apache.ofbiz". > > >>> 2017-07-17 17:44:41,666 |OFBiz-batch-7|GenericDelegator > > >>> |I| Delegator "default#DDS" initializing helper "localpostolap" for > > >>> entity > > >>> group "org.apache.ofbiz.olap". > > >>> 2017-07-17 17:44:41,666 |OFBiz-batch-8|GenericDelegator > > >>> |I| Doing database check as requested in entityengine.xml with > > >>> addMissing=true > > >>> 2017-07-17 17:44:41,666 |OFBiz-batch-7|GenericDelegator > > >>> |I| Doing database check as requested in entityengine.xml with > > >>> addMissing=true > > >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|DatabaseUtil > > >>> |I| Database Product Name is PostgreSQL > > >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|Dat
Re: Tenant Login Issue in OFBiz 16.11
Hi Taher, Thanks for fixing the issue. The issue of multi-tenant logins in the same browser can be achieved by using sub-domain in URL for each tenant. In this way, there will be a separate session and cookie management. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd. www.hotwaxsystems.com On Fri, Sep 29, 2017 at 9:45 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Le 29/09/2017 à 17:49, Taher Alkhateeb a écrit : > >> Very happy to note that I finally cracked the puzzle on this bug. It's >> a simple case of readers=tenant that was missing in the build script. >> This bug was always there since the introduction of gradle. So I will >> fix it and backport to branch 16. You can check [1] for more. >> >> However, given that this bug was discovered so late gives me an >> indication that very few people are interested in the multi-tenancy >> feature in OFBiz. >> > That's a good news anyway, thanks Taher > > Jacques > > > >> [1] https://issues.apache.org/jira/browse/OFBIZ-9278 >> >> On Mon, Jul 17, 2017 at 2:59 PM, vivek.mi wrote: >> >>> I did try. I created two tenants with: >>> >>> 1. *./gradlew createTenant -PtenantId=mytenant -PtenantName="My Name" >>> -PdomainName=com.example -PtenantReaders=seed,seed-initial,ext >>> -PdbPlatform=M -PdbIp=127.0.0.1 -PdbUser=mydbuser -PdbPassword=mydbpass* >>> >>> Tenant1: CAD >>> Tenant 2: DDS >>> >>> 2. Used ./gradlew ofbiz >>> 3. Login with CAD-admin (first tenant), login successful >>> 4. Login with DDS-admin (second tenant), following error: >>> >>> Can't access entity of entityGroup = org.apache.ofbiz.tenant using tenant >>> delegator default#DDS, use base delegator instead >>> 2017-07-17 17:44:41,665 |OFBiz-batch-9|GenericDelegator >>> |I| Delegator "default#DDS" NOT initializing helper for entity group >>> "org.apache.ofbiz.tenant" because the group is not associated to this >>> delegator. >>> 2017-07-17 17:44:41,666 |OFBiz-batch-8|GenericDelegator >>> |I| Delegator "default#DDS" initializing helper "localpostgres" for >>> entity >>> group "org.apache.ofbiz". >>> 2017-07-17 17:44:41,666 |OFBiz-batch-7|GenericDelegator >>> |I| Delegator "default#DDS" initializing helper "localpostolap" for >>> entity >>> group "org.apache.ofbiz.olap". >>> 2017-07-17 17:44:41,666 |OFBiz-batch-8|GenericDelegator >>> |I| Doing database check as requested in entityengine.xml with >>> addMissing=true >>> 2017-07-17 17:44:41,666 |OFBiz-batch-7|GenericDelegator >>> |I| Doing database check as requested in entityengine.xml with >>> addMissing=true >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|DatabaseUtil >>> |I| Database Product Name is PostgreSQL >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|DatabaseUtil >>> |I| Database Product Version is 9.3.17 >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|DatabaseUtil >>> |I| Database Driver Name is PostgreSQL Native Driver >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|DatabaseUtil >>> |I| Database Driver Version is PostgreSQL 9.4 JDBC4.1 (build 1201) >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|DatabaseUtil >>> |I| Database Driver JDBC Version is 4.0 >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|DatabaseUtil >>> |I| Database Setting/Support Information (those with a * should be true): >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|DatabaseUtil >>> |I| - supports transactions [true]* >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|DatabaseUtil >>> |I| - isolation None[false] >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|DatabaseUtil >>> |I| - isolation ReadCommitted [true] >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|DatabaseUtil >>> |I| - isolation ReadUncommitted [true] >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|DatabaseUtil >>> |I| - isolation RepeatableRead [true] >>> 2017-07-17 17:44:41,669 |OFBiz-batch-7|DatabaseUtil >>> |I| - isolation Serializable[true] >>> 2017-07-17 17:44:41,670 |OFBiz-batch-7|DatabaseUtil >>> |I| - forward only type [true] >>> 2017-07-17 17:44:41,670 |OFBiz-batch-7|DatabaseUtil >>> |I| - scroll sensitive type [false] >>> 2017-07-17 17:44
Re: Payment Type Vendor Credit Error
Hello James, I am able to apply Vendor Payment on Purchase Invoice. Followed steps on demo-trunk[1] instance as below: 1) Created a Vendor Payment for a supplier of amount $1500 2) Created a Purchase Invoice with an item of cost $1500 3) Approved Invoice Result: Existing Vendor Payment auto applied on the invoice. [1] https://demo-trunk-ofbiz.apache.org/accounting/control/main -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd. www.hotwaxsystems.com On Fri, Sep 22, 2017 at 7:04 PM, wrote: > Anyone have any idea how a payment type of vendor credit is suppose to > be applied to a Vendor Invoice? > > > Original Message > Subject: Payment Type Vendor Credit Error > From: > Date: Thu, September 21, 2017 6:44 am > To: user@ofbiz.apache.org > > When trying to make a vendor credit I get the following error > > The Following Errors Occurred: > Error calling event: org.ofbiz.webapp.event.EventHandlerException: > Service invocation error (Could not commit transaction for service > [setPaymentStatus] call: Roll back error, could not commit transaction, > was rolled back instead because of: Error in Service [postPaymentToGl]: > Offsetting GL account for payment type VENDOR_CREDIT_RCPT of > organization Company has not been configured.) > > On Vendor Credit it does not give you the ability to apply the credit to > a vendor invoice which would be the offsetting transaction. The GL > account would be determined by the vendor. Am I missing something or am > I not using Vendor Credit payment type correctly? > > > Thanks, > > James >
Re: Why createAcctgTransAndEntries cannot read the organizationPartyId
Hello Sach, Organization party should be PartyGroup instead of person. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd. www.hotwaxsystems.com On Fri, Sep 22, 2017 at 11:07 PM, Sach Shah wrote: > Hi All, > > I am testing the createAcctgTransAndEntries service using the web interface > (at > https://localhost:8443/webtools/control/setSyncServiceParameters? > SERVICE_NAME=createAcctgTransAndEntries&POOL_NAME=pool&_RUN_SYNC_=Y > ). > > I have tried many different formats for the acctgTransEntries field, but > the logs state that OfBiz is ignoring my entries because the > organizationPartyId is not an internal organization. When I dug deeper, it > seemed like the service could not read the organizationPartyId from what I > was passing it (read as null / blank). Obviously, the PartyRole check > failed at that point and the entry was discarded. > > Please note that, in the examples below, I created a Person (using > createPerson) and then made them an internal organization (using > cseCreatePartyRole). > > Here are some variations I tried, all without success: > {"debitCreditFlag":"D","organizationPartyId":"10182"," > amount":"200.00","glAccountId":"10663","partyId":"10182"} > ("debitCreditFlag":"C","organizationPartyId":"Company" > ,"amount":"1500.00","glAccountId":"10664") > {("debitCreditFlag":"D","organizationPartyId":"10212"," > amount":"150.00","glAccountId":"10690","partyId":"10212")} > [debitCreditFlag : D; organizationPartyId : 10212; amount : 150.00; > glAccountId : 10690; partyId : 10212] > [[debitCreditFlag : D; organizationPartyId : 10212; amount : 150.00; > glAccountId : 10690; partyId : 10212]] > [{"debitCreditFlag":"D","organizationPartyId":"10182"," > amount":"200.00","glAccountId":"10663","partyId":"10182"}] > > Any help that people can provide is greatly appreciated. If this is the > wrong service to use to create an accounting transaction from another > server, please provide some guidance on how best to do it. Please note > that I did try to use createAcctgTrans and then subsequent calls to > createAcctgTransEntry, but OfBiz kept generating duplicate transaction > entry sequence IDs, so I moved to createAcctgTransAndEntries. > > Thank you, > Sachin. >
Re: setting up TAX in ofbiz [ SOLVED ]
Hi Rajesh, Both ways are alternative to each other and not auto linked. You may need to use either file system configuration or SystemProperty data configuration. Usually, data configuration is essential with multi tenancy environment. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd. www.hotwaxsystems.com On Thu, Aug 31, 2017 at 8:07 PM, Rajesh Mallah wrote: > Dear Arun , > > Thanks for clarifying that . > > (1) I observed that when I changed the file system configuration > settings the restarted the server the value in SystemProperty > remained the same. I am not sure if this is the expected behaviour. > > In My setup I use a remote postgresql server . > > I verified (1) just now. > > regds > mallah. > > > > > > > On Thu, Aug 31, 2017 at 7:46 PM, Arun Patidar < > arun.pati...@hotwaxsystems.com> wrote: > > > Hi Rajesh, > > > > SystemProperty entity is used to override file system configuration > > settings. This also gives flexibility of changing values on runtime > without > > restart. System, first checks in the database and then go to file system > if > > value not found. > > > > > > -- > > Thanks & Regards > > --- > > Arun Patidar > > Manager, Enterprise Software Development > > > > HotWax Systems Pvt Ltd. > > > > www.hotwaxsystems.com > > > > > > On Thu, Aug 31, 2017 at 6:41 PM, Rajesh Mallah > > wrote: > > > > > Hi List , > > > > > > At last I managed to get my setup pick up the prices specified in > > non-USD > > > currency (i.e INR in my case) . > > > > > > From what I could understand , the system attempts to get the the > > > value of "currency of handling" from multiple sources as currency > > attribute > > > itself can be specified at multiple places. > > > > > > [ Source of above info: > > > ./applications/product/src/main/java/org/apache/ofbiz/ > > > product/price/PriceServices.java > > > Lines: 80-567, Func: calculateProductPrice ] > > > > > > If for whatever reasons (or set of reasons) the currency could not > > > be determined > > > > > > (1) it attempts to get the value of property > 'currency.uom.id.default' > > in > > > general resource/category , > > > (1.1) if that also cannot be got it uses the hard coded default > > USD [ > > > PriceServices.java:148 ] > > > > > > 142 String currencyDefaultUomId = (String) > > > context.get("currencyUomId"); > > > 143 String currencyUomIdTo = (String) > > > context.get("currencyUomIdTo"); > > > 144 if (UtilValidate.isEmpty(currencyDefaultUomId)) { > > > 145 if (productStore != null && > > > UtilValidate.isNotEmpty(productStore.getString(" > defaultCurrencyUomId"))) > > { > > > 146 currencyDefaultUomId = > > > productStore.getString("defaultCurrencyUomId"); > > > 147 } else { > > > 148 currencyDefaultUomId = > > > EntityUtilProperties.getPropertyValue("general", > > > "currency.uom.id.default", > > > "USD", delegator); > > > 149 } > > > 150 } > > > > > > > > > The reason why it took so long to track it down is that > > > the system property 'currency.uom.id.default' itself can be specified > > > in 2 places: > > > > > > (1) ./framework/common/config/general.properties > > > (2) ./framework/common/data/CommonSystemPropertyData.xml > > > > > > and the entity table (RDBMS) is : SYSTEM_PROPERTY > > > which seems to be loaded from (2) only and not (1) > > > ( at least for the property currency.uom.id.default ) > > > > > > I had been making changes to (1) and expecting the system to > > > use it. However the system uses the table SYSTEM_PROPERTY > > > that seems to be getting loaded only from (2). > > > > > > > > > Although i have marked this thread as solved , I am yet to analyze > > > why at all the flow control reached to the stage of last resort for > > > determining the handling currency from system property > > > currency.uom.id.default > > > > > > It should have been determined much earlier through information > provided > > > end user using W
Re: setting up TAX in ofbiz [ SOLVED ]
Hi Rajesh, SystemProperty entity is used to override file system configuration settings. This also gives flexibility of changing values on runtime without restart. System, first checks in the database and then go to file system if value not found. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd. www.hotwaxsystems.com On Thu, Aug 31, 2017 at 6:41 PM, Rajesh Mallah wrote: > Hi List , > > At last I managed to get my setup pick up the prices specified in non-USD > currency (i.e INR in my case) . > > From what I could understand , the system attempts to get the the > value of "currency of handling" from multiple sources as currency attribute > itself can be specified at multiple places. > > [ Source of above info: > ./applications/product/src/main/java/org/apache/ofbiz/ > product/price/PriceServices.java > Lines: 80-567, Func: calculateProductPrice ] > > If for whatever reasons (or set of reasons) the currency could not > be determined > > (1) it attempts to get the value of property 'currency.uom.id.default' in > general resource/category , > (1.1) if that also cannot be got it uses the hard coded default USD [ > PriceServices.java:148 ] > > 142 String currencyDefaultUomId = (String) > context.get("currencyUomId"); > 143 String currencyUomIdTo = (String) > context.get("currencyUomIdTo"); > 144 if (UtilValidate.isEmpty(currencyDefaultUomId)) { > 145 if (productStore != null && > UtilValidate.isNotEmpty(productStore.getString("defaultCurrencyUomId"))) { > 146 currencyDefaultUomId = > productStore.getString("defaultCurrencyUomId"); > 147 } else { > 148 currencyDefaultUomId = > EntityUtilProperties.getPropertyValue("general", > "currency.uom.id.default", > "USD", delegator); > 149 } > 150 } > > > The reason why it took so long to track it down is that > the system property 'currency.uom.id.default' itself can be specified > in 2 places: > > (1) ./framework/common/config/general.properties > (2) ./framework/common/data/CommonSystemPropertyData.xml > > and the entity table (RDBMS) is : SYSTEM_PROPERTY > which seems to be loaded from (2) only and not (1) > ( at least for the property currency.uom.id.default ) > > I had been making changes to (1) and expecting the system to > use it. However the system uses the table SYSTEM_PROPERTY > that seems to be getting loaded only from (2). > > > Although i have marked this thread as solved , I am yet to analyze > why at all the flow control reached to the stage of last resort for > determining the handling currency from system property > currency.uom.id.default > > It should have been determined much earlier through information provided > end user using WEB-UI controls. > > > I would update this thread at a later time when i am able to investigate > that. > > regds > mallah. > > > > On Thu, Aug 31, 2017 at 11:39 AM, Rajesh Mallah > wrote: > > > > > > > I wonder why a query on a table should be run looking for > > rows where the primary key of table is null. > > > > the sole filter on the below query on ProductStore is: > > WHERE ((PRODUCT_STORE_ID IS NULL)) > > > > Note: this query is just run *before* looking in the ProductPrice > > table. > > > > more context here: https://pastebin.com/raw/sSh1sNWb > > > > BTW: what is the way of altering logging config in OfBiz > >to include Filenames and Line number? > > > > regds > > mallah. > > > > > > > > > > 2017-08-31 10:45:18,180 |http-nio-8080-exec-5 > > |GenericDAO|T| Ran query in 3 milli-seconds: > > EntityName: ProductStore Sql: SELECT PRODUCT_STORE_ID, > > PRIMARY_STORE_GROUP_ID, STORE_NAME, COMPANY_NAME, TITLE, SUBTITLE, > > PAY_TO_PARTY_ID, DAYS_TO_CANCEL_NON_PAY, MANUAL_AUTH_IS_CAPTURE, > > PRORATE_SHIPPING, PRORATE_TAXES, VIEW_CART_ON_ADD, AUTO_SAVE_CART, > > AUTO_APPROVE_REVIEWS, IS_DEMO_STORE, IS_IMMEDIATELY_FULFILLED, > > INVENTORY_FACILITY_ID, ONE_INVENTORY_FACILITY, CHECK_INVENTORY, > > RESERVE_INVENTORY, RESERVE_ORDER_ENUM_ID, REQUIRE_INVENTORY, > > BALANCE_RES_ON_ORDER_CREATION, REQUIREMENT_METHOD_ENUM_ID, > > ORDER_NUMBER_PREFIX, DEFAULT_LOCALE_STRING, DEFAULT_CURRENCY_UOM_ID, > > DEFAULT_TIME_ZONE_STRING, DEFAULT_SALES_CHANNEL_ENUM_ID, ALLOW_PASSWORD, > > DEFAULT_PASSWORD, EXPLODE_ORDER_ITEMS, CHECK_GC_BALANCE, > > RETRY_FAILED_AUTHS, HEADER_A
Re: setting up TAX in ofbiz
Hello Rajesh, ProductStore and PartyAcctgPreference entities also have fields to store currency UOM. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd. www.hotwaxsystems.com On Thu, Aug 31, 2017 at 9:17 AM, Rajesh Mallah wrote: > looks like too many messages has already been > exchanged in past at various point in time. > > http://ofbiz.markmail.org/search/?q=changing+default+ > currency#query:changing%20default%20currency > > it will be beneficial to new users if it is given attention . > > regds > mallah. > > > On Thu, Aug 31, 2017 at 8:01 AM, Rajesh Mallah > wrote: > > > > > > > > > @Deepak , @Rishi / List , > > > > Additional SQL tracing reveals that the ProductPricing > > entities are being queried with CURRENCY_UOM_ID=USD > > and hence the USD pricing is being picked up. I am not sure > > why USD currency is being picked. I have changed in almost > > all places including properties file. > > > > -- ./framework/common/config/general.properties > > > > # -- unique instance id (20 char max) > > unique.instanceId=ofbiz1 > > # -- the default currency to use for prices, etc > > currency.uom.id.default=INR > > # These values override the _NA_ DEFAULT values in user preferences for > > the GLOBAL_PREFERENCES userPrefGroupTypeId > > # -- the default organizationPartyId for used in dropdowns and reports > > > > > > 2017-08-31 07:52:15,412 |http-nio-8080-exec-9 |GenericDAO > > |T| Ran query in 1 milli-seconds: EntityName: ProductPrice > > Sql: SELECT PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, PRODUCT_PRICE_PURPOSE_ID, > > CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, THRU_DATE, PRICE, > > TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX, > PRICE_WITH_TAX, > > TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, > TAX_IN_PRICE, > > CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, > > LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM ofbiz.PRODUCT_PRICE WHERE > > ((PRODUCT_ID = ? AND (PRODUCT_PRICE_PURPOSE_ID = ? OR > PRODUCT_PRICE_PURPOSE_ID IS NULL) > > AND CURRENCY_UOM_ID = ? AND PRODUCT_STORE_GROUP_ID = ?)) > > ORDER BY FROM_DATE DESC > > > > where clause:[PRODUCT_ID=1, PRODUCT_PRICE_PURPOSE_ID=PURCHASE, > > CURRENCY_UOM_ID=USD,PRODUCT_STORE_GROUP_ID=_NA_] > > > > Full Log: > > https://pastebin.com/raw/smdQX84B > > > > > > Looking forward to further comments and > > guidance. > > > > regds > > mallah. > > >
Re: Estimated Delivery Per Item on Sales Orders
Hello James, There is no automation exist to calculate estimated delivery date of item. This is on item level as item delivery depends on supplier, its lead time, current inventory stock and qty required. There are multiple criteria that affects delivery of item. Some of them are: - Origin and Destination address - Available inventory of item - Quantity required - Date of PO placed (if back-ordered) - Lead time of supplier for item (if PO raised) - Partial shipment allowed or not -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd.www.hotwaxsystems.com On Fri, Aug 25, 2017 at 5:20 PM, wrote: > Thanks is there anywhere that automatically calculates these dates based > on ship to location? Also is this at the order level or can it be at > the line item level? > > Original Message > Subject: Re: Estimated Delivery Per Item on Sales Orders > From: Arun Patidar > Date: Thu, August 24, 2017 10:12 pm > To: user@ofbiz.apache.org > Cc: arunpati...@apache.org > > Hello James, > > You can use OrderItem.estimatedDeliveryDate and > OrderITem.estimatedShipDate > fields for both SO and PO. > > -- > Thanks & Regards > --- > Arun Patidar > Manager, Enterprise Software Development > > > HotWax Systems Pvt Ltd.www.hotwaxsystems.com > > > On Fri, Aug 25, 2017 at 4:28 AM, wrote: > > > Is there anywhere in Ofbiz where we would use to estimate the delivery > > date on a sales order per item based on ship to location? What about on > > a purchase order per item per supplier? > > > > Thanks, > > > > James > > >
Re: Estimated Delivery Per Item on Sales Orders
Hello James, You can use OrderItem.estimatedDeliveryDate and OrderITem.estimatedShipDate fields for both SO and PO. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd.www.hotwaxsystems.com On Fri, Aug 25, 2017 at 4:28 AM, wrote: > Is there anywhere in Ofbiz where we would use to estimate the delivery > date on a sales order per item based on ship to location? What about on > a purchase order per item per supplier? > > Thanks, > > James >
Re: [PROPOSAL]Request to enhance entity:SystemProperty.
Hello Wai, We can use permission checks on screen and service level instead of adding a new field ' 'access'' in entity. We have 'PartyAcctgPreference' entity for storing party specific settings. We can think to add few general fields in it. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd.www.hotwaxsystems.com On Wed, Aug 9, 2017 at 9:25 PM, Wai wrote: > Anybody have a comment on this? > > > > -- > View this message in context: http://ofbiz.135035.n4.nabble. > com/PROPOSAL-Request-to-enhance-entity-SystemProperty- > tp4709232p4709390.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
Re: Expense Management in OFBiz
Hi Tejas, Managing company expenses separately using voucher is a good idea. Looks like you are going to use existing Invoice data model for creating voucher. -- Thanks & Regards --- Arun Patidar On Thu, Jul 27, 2017 at 6:29 PM, Tejas Khanna < tejas.kha...@hotwaxsystems.com> wrote: > Dear All, > We would like to propose the idea of introducing support for Expense > Management within any kind of business. Many a time a variety of expense > type(consumable) item & services like stationery, office supplies, computer > accessories, monthly services etc. are supplied to multiple locations of > the company by different vendors. But they don't necessarily follow the > same procure to pay process as that of regular saleable merchandise > supplied by other vendors. > > A typical business case could be that a vendor of stationary items or a > vendor responsible for delivering hardware maintenance services sends > consolidated invoice to Corporate office against multiple > shipments/delivery of such items/services at different company locations > without necessarily having a systemic Purchase Order in place. but still, > it all requires to be tracked and reconciled against receipts at each > location and properly vouched for accounting purposes to release the timely > payment to vendors. > > In order to support the AP processing, such kind of invoices need to be > vouched with respect to each vendor and payment needs to be processed by > accounting for such multiple vouchers within any given accounting period > for the corresponding vendor. > > We are planning to implement this voucher based invoice processing feature > in Ofbiz soon and would welcome any kind of early inputs/feedback/past > experiences. > > Thanks > Tejas Khanna > HotWax Systems >
Re: OFBiz Vimeo Channel
Thanks for the update Deepak. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd.www.hotwaxsystems.com On Thu, Apr 20, 2017 at 1:07 PM, Deepak Dixit wrote: > Hi, > > We are pleased to announce that we have setup ApacheOFBiz channel on vimeo > <https://vimeo.com> as well. > > Here is the link for OFBiz Vimeo Channel > https://vimeo.com/channels/apacheofbiz > > Thanks & Regards > -- > Deepak Dixit >
Re: Multi-Tenancy
Hi James, Refer below documents links related to multi tenancy support in OFBiz. https://cwiki.apache.org/confluence/x/Rwzi https://cwiki.apache.org/confluence/x/9oT0Ag -- Thanks & Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Mediawww.hotwaxsystems.com On Fri, Jan 27, 2017 at 7:42 PM, wrote: > Thanks Pierre - Can you provide the configuration or shed some light as > to how you accomplished Multi-Tenancy? > > Original Message > Subject: Re: Multi-Tenancy > From: Pierre Smits > Date: Fri, January 27, 2017 6:51 am > To: user@ofbiz.apache.org > > Dear James, > > I am. And yes, I have such. > > Best regards, > > Pierre Smits > > ORRTIZ.COM <http://www.orrtiz.com> > OFBiz based solutions & services > > OFBiz Extensions Marketplace > http://oem.ofbizci.net/oci-2/ > > On Fri, Jan 27, 2017 at 2:44 PM, wrote: > > > I know there seems to be some confusion as to multi-company and > > multi-tenant, but is there anyone out there utilizing Ofbiz in a > > multi-tenant environment. By multi-tenant environment I mean multiple > > companies with no relationship to each other running different databases > > utilizing the same infrastructure. Is there anyone out there running in > > this format? Is there a standard configuration in Ofbiz for this? > > > > Thanks in advance! > > > > James > > >
Re: Limiting the number of components for new tenant
Hi Nikhil, This is not supported currently. Below is the initial implementation thought to achieve your requirement: - Prepare manual data of TenantComponent as per your need. - You can override components info of ComponentConfig.webappInfos by using TenantComponent entity details whenever system switch to Tenant delegator. Refer ContextFilter.java Let me know if you have any concern. -- Thanks & Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Mediawww.hotwaxsystems.com On Mon, Jan 16, 2017 at 12:41 PM, Nikhil Bonte wrote: > Hello everyone, > > > When I am creating a new tenant and loading seed, seed-initial data, all > the available component functionalities are available for the new tenant. I > want to load only a few components (such as for example accounting, party, > product and order) for the new tenant. I noticed that there are a few > tables such as Component and TenantComponent in the tenant database. > > I have tried the gradlew loadTenant task and specified the specific > components, however, when I login into the new tenant, I am able to see all > the components. Also the table TenantComponent is empty. Can someone guide > me on how to restrict the components for a new tenant? > > > -- > Thanks & Regards, > Nikhil Bonte. > vnnogile Solutions Private Limited > >
Re: Error changing USD to INR when receiving order
What do you mean by "And for suppliers I cant edit filed to INR". You can create two SupplierProduct records with same supplier for a product with both USD and INR currencies. Select specific supplier while creating PO or receiving. -- Thanks & Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Mediawww.hotwaxsystems.com On Mon, Dec 5, 2016 at 3:24 PM, shwetacf wrote: > Hi, > > I am new to ofbiz. I am facing problem when adding product with India > rupees. And for suppliers I cant edit filed to INR. So please help me on > this, how to change price to INR. I am also attaching the picture of the > error. > > Thanks > Shweta > > > > -- > View this message in context: http://ofbiz.135035.n4.nabble. > com/Error-changing-USD-to-INR-when-receiving-order-tp4700025.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
Re: New ASF Members from the OFBiz Community!
Congratulations Sharan and Jacques!! Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems www.hotwaxsystems.com On Wednesday 30 March 2016 01:44 PM, Sharan-F wrote: Hi All Some great news. Two people from our Community (Jacques Le Roux and myself) have become Apache Software Foundation members. Membership is by invitation only so it's a real honour to be invited. For those who are not familiar with what an ASF member is – I've copied the current definition from the ASF site below. “An ASF member is a person who was nominated by current members and elected due to merit for the evolution and progress of the foundation. Members care for the ASF itself. This is usually demonstrated through the roots of project-related and cross-project activities. Legally, a member is a "shareholder" of the foundation, one of the owners. They have the right to elect the board, to stand as a candidate for the board election and to propose a committer for membership. They also have the right to propose a new project for incubation. The members coordinate their activities through their mailing list and through their annual meeting. “ So my congratulations goes out to Jacques (Felicitations!) :-) Thanks Sharan -- View this message in context: http://ofbiz.135035.n4.nabble.com/New-ASF-Members-from-the-OFBiz-Community-tp4678581.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Adrian Crum
Very sad news. My sincere condolences for him. Thanks & Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Systems www.hotwaxsystems.com On Tuesday 05 January 2016 01:34 PM, Pierre Smits wrote: Hi all, With sadness in my heart I inform you that on January 1st Adrian Crum passed away peacefully. Adrian was hospitalised in December of last year due to suffering from a double pneumonia. He died while being kept sedated. I wish his loved ones, relatives and friends strength in these difficult times. Best regards, Pierre Smits
Re: Multi-Tenant with MySQL or Postgress - Working?
Hi Fernando, In your attached log file, there is an error as : /org.ofbiz.base.config.GenericConfigException: File Resource not found: E:/DEV/ofbiz.14.12/framework/entity/fieldtype/fieldtypepostnew.xml/ Use postgres settings instead of postnew in entityengine since postnew does not support in 14.12 release. It should be 'fieldtypepostgres.xml' file location in entityengine. I just created a new tenant using Mysql on OFBiz trunk and it worked fine for me. Thanks & Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Media www.hotwaxsystems.com On Sunday 24 May 2015 12:05 PM, FGomez wrote: Hi all Not able to make multitenant working on postgres (nor on mysql). There are several errors and The script 'create-tenant' hangs at the following line: [java] 2015-05-23 23:05:55,222 |main |ContainerLoader |I| Starting container dataload-container [java] 2015-05-23 23:05:55,254 |delegator-startup-1 |DelegatorFactoryImpl |I| Creating new delegator [default#Tenant1] (delegator-startup-1) I have followed these guidances (now that a script is available to create Tenants). https://cwiki.apache.org/confluence/display/OFBIZ/Extension+in+Multitenancy+support ENV os=windows 12 R2 ofbiz release from svn co ofbiz.14.02 Thanks for your feedback. Regards, Fernando Le 2015-05-21 11:20, FGomez a écrit : Jacques, Pierre and Arum Thanks for the technical answer. I agreed with the advantages of a DB per Tenant and the scalability of the HW infrastructure underneath . Hence the maintenance and support issues. I test with v14.12 and advise. Regards, Fernando Le 2015-05-21 03:09, Jacques Le Roux a écrit : More accurately multi-tenancy has been introduced in trunk in February 2010 and has been continuously improved since. It works with all the DBMSs you can fiund in the EntityEngine.xml file. The number of tenants depends on the material resources, not the code. It's not a solution to scale above thousands tough (you need a DB by tenant...) This limitation comes with the obvious advantages of having separated DBs. You can find details about these advantages on the Net, notably when it comes to backups things and guarantee access separation... Jacques Le 21/05/2015 07:59, Pierre Smits a écrit : Hi Fernando. Multi-tenancy has been around since prior r12.x. And is working with both PostgreSQL and MySQL. Best regards, Pierre Smits *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Thu, May 21, 2015 at 4:34 AM, FGomez wrote: Hi All, I wanted to know if anyone has Multi-tenant running in production (or dev) with more then 3 tenants/clients with PostgreSql or mySql DBs? With v13.07 or v14.12 ( I believe the domain on the script is only available with the 'ant create-tenant' on v14.12 only). Thanks you for the feedback. Regards, Fernando
Re: Multi-Tenant with MySQL or Postgress - Working?
Hi Fernando, Multi-tenant functionality supports all DBs like Postgres, Mysql and Derby. Also 'domain-name' with create-tenant target introduced in v14.12. Thanks & Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Media www.hotwaxsystems.com On Thursday 21 May 2015 08:04 AM, FGomez wrote: Hi All, I wanted to know if anyone has Multi-tenant running in production (or dev) with more then 3 tenants/clients with PostgreSql or mySql DBs? With v13.07 or v14.12 ( I believe the domain on the script is only available with the 'ant create-tenant' on v14.12 only). Thanks you for the feedback. Regards, Fernando
Re: AW: Multiple root apps (tenant)
Hi Ingo, I verified the functionality on OFBiz 13.07 and Trunk version using same virtual-host value for 'ecommerce' and 'images' components. It seems to working for me. If you still face issue then please share more details to regenerate issue at our end. Thanks & Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Media www.hotwaxsystems.com On Saturday 24 January 2015 01:07 AM, Ingo Wolfmayr wrote: Hi Pierre, thanks for the answer. I will check. Can you confirm that it should work that way? I could not find any doc about it and had to figure it out myself. Thanks, Ingo -Ursprüngliche Nachricht- Von: Pierre Smits [mailto:pierre.sm...@gmail.com] Gesendet: Mittwoch, 21. Jänner 2015 15:55 An: user@ofbiz.apache.org Betreff: Re: Multiple root apps (tenant) Ingo, There were some recent changes committed regarding multi-tenancy functionality. You might consider doing a quick test against branch 14.12 to narrow it down. Best regards, Pierre Smits *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Tue, Jan 20, 2015 at 8:32 AM, Ingo Wolfmayr wrote: Hi everybody, I would like to run multiple websites on a single instance using the tenant functionality. In Ofbiz release 13.07 it was working by using virtual hosts: Root mount for virtual host: As I want to reuse code/resources from other webapps I did the following: for example framework/images This was necessary to make the images webapp available for all the webapps that already used it: This was necessary to make the images webapp available for the virtual host: I tried to migrate to the actual trunk but failed as the virtual host logic seems to work different. As far as I understood (in 13.07), other webapps where only available for a virtualhost if they had a matching virtual host entry as well. Can someone please help me by telling me how this is done correct. Best regards, Ingo
Re: Unable to connect tenant component with tenant database
Hi Anchit, Thanks for testing it. We assume that front store application for a tenant will run using specific domain name, alternatively you will need to pass tenantId as parameter in each anonymous request and also need to add/pass tenantId on login screen. There is code to get tenantId from request just to support above alternate way with front store application. Thanks & Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Media www.hotwaxsystems.com On Wednesday 28 January 2015 07:31 PM, Anchit Jindal wrote: Hi Arun Thanks for the reply i have tested this patch and by using this i found that it returns null for tenant id for the following code if(UtilValidate.isEmpty(tenantId)) { tenantId = (String) httpRequest.getAttribute("tenantId"); } if(UtilValidate.isEmpty(tenantId)) { tenantId = (String) httpRequest.getParameter("tenantId"); } so if tenantDomainName is null it is not able to get tenantId and delegator for tenant is not set. I also find that in this patch tenantId has not been set in requestAtteribute or request parameters before getting it so i want to know is it complete patch? i check in the latest ofbiz tenantId is set is request Attribute after getting it from TenantDomainName entity if it is not null. Also for domain name field i found there is no need for tenant domain name to access backend application because we use same backend application for tenant except it has different user login details and tenantid for login. i have tested it many times domain name is used to create delegator for tenant component and to get tenant id. Have you test it with the latest ofbiz or i miss some thing? Thanks Anchit Jindal On Wed, Jan 28, 2015 at 7:04 PM, Pierre Smits [via OFBiz] < ml-node+s135035n4662355...@n4.nabble.com> wrote: As it has now become a review of a committed change, I will report my findings in dev@ Regards, Pierre Smits *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Wed, Jan 28, 2015 at 2:25 PM, Pierre Smits <[hidden email] <http:///user/SendEmail.jtp?type=node&node=4662355&i=0>> wrote: Jacques, I had not had the change yet, but I will test recent changes and the patch provided in 5896 shortly. Best regards, Pierre Smits *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Wed, Jan 28, 2015 at 1:59 PM, Jacques Le Roux < [hidden email] <http:///user/SendEmail.jtp?type=node&node=4662355&i=1>> wrote: Le 28/01/2015 12:21, Pierre Smits a écrit : This seems to be related to https://issues.apache.org/ jira/browse/OFBIZ-5447 Pierre, is this resolved on your side? Ashish, what about https://issues.apache.org/jira/browse/OFBIZ-5986 ? Thanks Jacques Regards, Pierre Smits *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Wed, Jan 28, 2015 at 7:37 AM, Arun Patidar < [hidden email] <http:///user/SendEmail.jtp?type=node&node=4662355&i=2>> wrote: Hello Anchit, Domain name field is optional to make back-end application accessible by passing tenantId from login screen. I think patch attached on OFBIZ-5986 <https://issues.apache.org/ jira/browse/OFBIZ-5986> should work for you. Its not committed yet so you can try it by applying that patch from task. In this patch there is a support for identifying tenantId from domain name, request parameter or request attribute. Thanks & Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Media www.hotwaxsystems.com On Wednesday 28 January 2015 10:12 AM, Anchit Jindal wrote: Hi Pierre Thanks for the reply issue resolved by reading the link you provide. I have domain name issue. After reading this post i create its proper data for domain and it works fine. I have a question i check while creating new tenant, domain name is optional field and to create delegator for tenant it check for the domainName in TenantDomainName entity in ContextFilter.java if found the valid domainName delegator is created for tenant and if not found it gives tenant not found error. So now my question is why domin name field is optional during creating tenant because tenant site does not work if domain name is not configured properly. i thing it should be mandatory. what you think? On Wed, Jan 28, 2015 at 4:06 AM, Pierre Smits [via OFBiz] < [hidden email] <http:///user/SendEmail.jtp?type=node&node=4662355&i=3>> wrote: This is the change I am referring to: http://ofbiz.markmail.org/messag
Re: Unable to connect tenant component with tenant database
Hello Anchit, Domain name field is optional to make back-end application accessible by passing tenantId from login screen. I think patch attached on OFBIZ-5986 <https://issues.apache.org/jira/browse/OFBIZ-5986> should work for you. Its not committed yet so you can try it by applying that patch from task. In this patch there is a support for identifying tenantId from domain name, request parameter or request attribute. Thanks & Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Media www.hotwaxsystems.com On Wednesday 28 January 2015 10:12 AM, Anchit Jindal wrote: Hi Pierre Thanks for the reply issue resolved by reading the link you provide. I have domain name issue. After reading this post i create its proper data for domain and it works fine. I have a question i check while creating new tenant, domain name is optional field and to create delegator for tenant it check for the domainName in TenantDomainName entity in ContextFilter.java if found the valid domainName delegator is created for tenant and if not found it gives tenant not found error. So now my question is why domin name field is optional during creating tenant because tenant site does not work if domain name is not configured properly. i thing it should be mandatory. what you think? On Wed, Jan 28, 2015 at 4:06 AM, Pierre Smits [via OFBiz] < ml-node+s135035n4662338...@n4.nabble.com> wrote: This is the change I am referring to: http://ofbiz.markmail.org/message/5raxnkzm5rp7gsjr?q=r1643510+list:org%2Eapache%2Eofbiz%2Ecommits+order:date-backward Best regards, Pierre Smits *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Tue, Jan 27, 2015 at 10:36 PM, Pierre Smits <[hidden email] <http:///user/SendEmail.jtp?type=node&node=4662338&i=0>> wrote: Hi Anchit, This is the second posting regarding multi-tenancy within one week. See http://ofbiz.markmail.org/message/22bmphzfhkprhrcm?q=multi+root If you feel there is something serious wrong with multi-tenancy, as we had some changes recently, please create a JIRA issue. Best regards, Pierre Smits *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Tue, Jan 27, 2015 at 12:09 PM, Anchit Jindal <[hidden email] <http:///user/SendEmail.jtp?type=node&node=4662338&i=1>> wrote: Hi All I am trying to create tenant by using *'create-tenant-on-PostgreSQL'* command. I have created database for tenant and this command create tables and load seed data in tables and also create admin user for tenant and i am also able to connect to the backend of this tenant. But the main issue is my tenant component is not connected to tenant databases for this i do following changes in my tenant component's web.xml entityDelegatorName default#tenantId The Name of the Entity Delegator to use, defined in entityengine.xml can any one tell me what i need to do to make it work currently i am using the latest ofbiz from trunk. Thanks. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-component-with-tenant-database-tp4662327.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- If you reply to this email, your message will be added to the discussion below: http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-component-with-tenant-database-tp4662327p4662338.html To unsubscribe from Unable to connect tenant component with tenant database, click here <http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4662327&code=YW5jaGl0amluZGFsOTFAZ21haWwuY29tfDQ2NjIzMjd8LTEzODUxNzYwNDI=> . NAML <http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> -- View this message in context: http://ofbiz.135035.n4.nabble.com/Unable-to-connect-tenant-component-with-tenant-database-tp4662327p4662339.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Congratulations!
Many Congratulations Gavin, Mridul and Pranay ! Thanks & Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Media www.hotwaxmedia.com On Monday 12 January 2015 02:04 PM, Jacopo Cappellato wrote: Thank you for starting this thread Pierre. Please also welcome Gavin Mabie (gavinmabie) that was invited as committer with Pranay and Mridul. They are all officially OFBiz committers now; we were waiting to send the congratulation email just because we are waiting for the response of a fourth person but it's good to move on and I will let you all know as soon as we have some news. Regards, Jacopo On Jan 12, 2015, at 8:00 AM, Pierre Smits wrote: Hi All, Please join me in welcoming and congratulating Pranay Panday and Mridul Pathak of HotWax Media as the newest committers of this project. According to the blog of HotWax Media ( http://www.hotwaxmedia.com/apache-ofbiz-blog/happy-2015-team-hotwax/) it was a milestone in 2014 for the organisation to having them invited and accepted as committers by this project. Regards, Pierre Smits *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com
Re: Getting error when updating or committing the code from Subclipse
Thanks Jacopo and Ashish for fixing this issue and providing steps. It helps, I was facing same issue at my end. Thanks & Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Media www.hotwaxmedia.com On Tuesday 09 December 2014 11:32 AM, Ashish Vijaywargiya wrote: Thanks Jacopo for your help! I think this was tricky fix so sharing the steps for everyone's easy reference. 1) Changed the Default JDK version from 1.6 to 1.7. 2) Inside eclipse, I went to SVN Repository Exploring perspective. 3) Relocated repository URL from https://svn.apache.org/repos/asf to http://svn.apache.org/repos/asf (https -> http) 4) Then took code update, it worked fine for me. 5) Again went to SVN Repository Exploring perspective and changed the URL from http://svn.apache.org/repos/asf to https://svn.apache.org/repos/asf. (http -> https) Again I took code update, it worked fine for me. I think in step #5 it took the right IP address from apache svn and cached it for future reference. Kind Regards Ashish Vijaywargiya HotWax Media - est. 1997 On Sat, Dec 6, 2014 at 3:50 PM, Jacopo Cappellato < jacopo.cappell...@hotwaxmedia.com> wrote: I think it is due to the recent server crash. This is a response from Infra to another committer experiencing the same issue: "Firstly the SSL cert has changed, and this might be the cause. Also, ensure eclipse is not caching the wrong IP address. If the IP address starts with 140, it should be 140.211.11.105." I hope it helps, Jacopo On Dec 6, 2014, at 9:57 AM, Ashish Vijaywargiya < vijaywargiya.ash...@gmail.com> wrote: Hello, I am getting following error when updating code from svn update. Everything was working with me before 1 week or so but today when I took update I am getting this error. commit -m "Applied patch from jira issue - OFBIZ-5898" (10 paths specified) svn: E175002: java.lang.RuntimeException: Could not generate DH keypair svn: E175002: OPTIONS request failed on '/repos/asf/ofbiz/trunk' svn: E175002: java.lang.RuntimeException: Could not generate DH keypair svn: E175002: OPTIONS request failed on '/repos/asf/ofbiz/trunk' java.lang.RuntimeException: Could not generate DH keypair Could not generate DH keypair Prime size must be multiple of 64, and can only range from 512 to 1024 (inclusive) Anyone of you faced similar kind of problem? Environment: Ubuntu 12.04 Java Version: 1.7 Svn Version: 1.8.10 Subclipse Version: 1.10.5 -- Kind Regards, Ashish Vijaywargiya
Re: Multi-tenant ecommerce
Hi Tore, This can be of your help: https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support Thanks & Regards --- Arun Patidar On 09/18/2013 11:04 AM, Tore Van Grembergen wrote: Hi, Does ofbiz support multi-tenant ecommerce ? There is a comment on this from Pierre Smits in 2011 (http://ofbiz.135035.n4.nabble.com/Multi-tenant-ecommerce-td3888115.html) (I think that BJ Freeman confirmed this in its last comment) If I understand their thinking, it should be done by deploying the ecommerce app several times into the hotdeploy directory and setting the configuration parameters in that code. (configure tenantid in web.xml ?) is this still the way to go ? If yes, is there some information available on how this is done the best way ? Kind regards Tore smime.p7s Description: S/MIME Cryptographic Signature
Re: Error while deleting a Promo
Hello Mario, This is a secure url issue and it will be easy to fix. You can see https://issues.apache.org/jira/browse/OFBIZ-2468 for more detail and also see commits no. 790512, 790516, 774999. Thanks & Regards --- Arun Patidar MarioF wrote: Hi all, I can delete this promos making the following: In the url.properties file, change the service.http.parameters.require.encrypted=Y to service.http.parameters.require.encrypted=N. Then you can delete all the promos. When you delete all the promos I change again this propertie to Y. Thanks all, Mario. MarioF wrote: Hi all, I receive an error when I try to delete some promos. I made the following: Catalog Manager Appl. -> Stores -> My Store -> Promos -> Select some Promo (for example 9020) -> Stores -> Delete When I press the delete button, I receive the following error: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Found URL parameter [productStoreId] passed to secure (https) request-map with uri [promo_deleteProductStorePromoAppl] with an event that calls service [deleteProductStorePromoAppl]; this is not allowed for security reasons! The data should be encrypted by making it part of the request body (a form field) instead of the request URL. Moreover it would be kind if you could create a Jira sub-task of https://issues.apache.org/jira/browse/OFBIZ-2330 (check before if a sub-task for this error does not exist). If you are not sure how to create a Jira issue please have a look before at http://docs.ofbiz.org/x/r. Thank you in advance for your help. I don't know where this error can come from. Any idea? Thnaks in advance, Mario.
Re: Need help with groovy and ftl
Hello Rohit, findByAnd return list of Generic Values. So you must iterate the list, even though it have only one record. After that you fetch the orderId Thanks -- AP rohit2006 wrote: Hi, I am doing a query in orderview.groovy as follows, where i am getting a retreiving a order from a table amazonfps: amazonOrder = delegator.findByAnd("Amazonfps", [orderId : orderId]); context.amazonOrders = amazonOrder.orderId; Now, when i use the context amazonOrders, in the orderview.ftl, the orderID retreived in enclosed in square brackets eg. [CO10652], which i am unable to get rid off. I cannot use the data in this format and have to remove the square brackets. I am not sure what and where the issue is. Any help will be appreciated. Thanks Rohit
delegator.finlist method doesn't work in ftl
Hello all, When I try to access this request https://localhost:8443/projectmgr/control/EditProjectSkills, getting error. IMO this is because we can not use delegator.findList method in ftl. This has been used like this: <#assign skillTypes = delegator.findList("SkillType", null, null, null, null, false)> If I use it like <#assign skillTypes = delegator.findList("SkillType", NULL, NULL, NULL, NULL, false)> then it works fine. Do we need to change something at framework level. Here is the log: Method public java.util.List org.ofbiz.entity.GenericDelegator.findList(java.lang.String,org.ofbiz.entity.condition.EntityCondition,java.util.Set,java.util.List,org.ofbiz.entity.util.EntityFindOptions,boolean) throws org.ofbiz.entity.GenericEntityException threw an exception when invoked on org.ofbiz.entity.genericdelega...@10b51f4 The problematic instruction: -- ==> assignment: skillTypes=delegator.findList("SkillType", null, null, null, null, false) [on line 36, column 13 in component://projectmgr/webapp/projectmgr/project/editProjectskills.ftl] -- Java backtrace for programmers: -- freemarker.template.TemplateModelException: Method public java.util.List org.ofbiz.entity.GenericDelegator.findList(java.lang.String,org.ofbiz.entity.condition.EntityCondition,java.util.Set,java.util.List,org.ofbiz.entity.util.EntityFindOptions,boolean) throws org.ofbiz.entity.GenericEntityException threw an exception when invoked on org.ofbiz.entity.genericdelega...@10b51f4 at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:130) at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.Assignment.accept(Assignment.java:90) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.Environment.process(Environment.java:189) at Please correct me if I am wrong. Thanks & Regards -- Arun Patidar
Re: Error during selecting orders for picking
yes this request is \using request-redirect. I traced this and found a solution for this in RequestHandler.java .If you allow then i can create a issue and upload a patch. -Arun Jacques Le Roux wrote: Is this request using a request-redirect ? I found already 2 others cases where request-redirect seems to no longer appends a question mark before URL parameters Jacques From: "David E Jones" On Feb 9, 2009, at 11:08 PM, Arun Patidar wrote: Hello All, I am facing a problem during selecting orders for picking. I am working on latest revision 742839. Same problem also on demo site. I performed following steps:- 1:- created a sales order 2:- find list of orders by find orders tab in ordermgr 3:- select a sales order from list 4:- select pick orders option from drop down and then clicked on Run Action button. It gives an error:- org.ofbiz.webapp.control.RequestHandlerException: Unknown request [findordershideFields=Y]; this request does not exist or cannot be called directly. It looks like the URL is missing a question mark (?). Are you a developer? If so, the best way to resolve the issue you've raised is to look into the file (FTL or some widget def) and see where this link is defined and what's up with it. I'm sure a patch to fix the issue will make it into the project quickly and resolve your issue. :) -David
Error during selecting orders for picking
Hello All, I am facing a problem during selecting orders for picking. I am working on latest revision 742839. Same problem also on demo site. I performed following steps:- 1:- created a sales order 2:- find list of orders by find orders tab in ordermgr 3:- select a sales order from list 4:- select pick orders option from drop down and then clicked on Run Action button. It gives an error:- org.ofbiz.webapp.control.RequestHandlerException: Unknown request [findordershideFields=Y]; this request does not exist or cannot be called directly. Thanks & Regards --- Arun Patidar
Re: Error in Shipment Estimates
Hello You can use ProductStoreShipmentMeth entity,where shipmentMethodTypeId will be EXPRESS and you can also use includeGeoId field in this entity which will restrict to England and wales.If this does not helps you then please give some more detail about your implementation. Thanks and Regards Arun Patidar - Original Message - From: "nachi19" To: user@ofbiz.apache.org Sent: Sunday, February 1, 2009 10:04:40 PM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi Subject: Error in Shipment Estimates Hi, I have an issue in shipment estimate... the scenario is i have two shipment methods EXPRESS and STANDARD . and i have provided the this both shipment services for England and wales... but i dont want to provide EXPRESS service for other countries... i have created the estimates for other countries other than england and wales but at the user side at the time of checkout if the user selects the shipping address other than the England and wales ... and when he press the next button .. the error page is displaying this is the log which i have got and i don't want to define the express method for those countries... 2009-02-02 05:01:56,637 (TP-Processor8) [ ServiceDispatcher.java:411:ERROR] Service Error [calcShipmentCostEstimate]: No shipping estimate found for carrier [Company] and shipment method type [EXPRESS] 2009-02-02 05:01:56,639 (TP-Processor8) [ ShippingEvents.java:210:ERROR] No shipping estimate found for carrier [Company] and shipment method type [EXPRESS] 2009-02-02 05:01:56,639 (TP-Processor8) [ GenericDelegator.java:1701:ERROR] Failure in findByCondition operation for entity [ProductStoreShipmentMeth]: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service Error [calcShipmentCostEstimate]: No shipping estimate found for carrier [Company] and shipment method type [EXPRESS]. Rolling back transaction. org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service Error [calcShipmentCostEstimate]: No shipping estimate found for carrier [Company] and shipment method type [EXPRESS] -- View this message in context: http://www.nabble.com/Error-in-Shipment-Estimates-tp21777178p21777178.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Error in onePageCheckout process ,shipping options are empty
Hello all I am getting problem during onePageCheckout process. After clicking on Continue to 3 button ,shipping methods are empty in shipping options. This is due to the value of type attribute ="BigDecimal" in getShipOptions event in CustomerEvents.xml of ecommerce Changes are in following lines.(revision no.727783 ) (line no. 1062) (line no. 1064) Errors is :--- [ Could not convert field value for the field: [shippingDesc] to the [BigDecimal] type for the value [CEVA Basic Curbside - $229.1]: org.ofbiz.base.util.GeneralException: Could not convert CEVABasicCurbside-$229.1 to BigDecimal: (Unparseable number: "CEVABasicCurbside-$229.1") Exception: org.ofbiz.base.util.GeneralException Message: Could not convert CEVABasicCurbside-$229.1 to BigDecimal: (Unparseable number: "CEVABasicCurbside-$229.1") ] If we Remove the type ="BigDecimal" attribute from above lines then it will work properly. Regards -- Arun Patidar