Sushant Singh Rajput: Boycott Karan Johar, YRF films
Hey, I just signed the petition "Sushant Singh Rajput: Boycott Karan Johar, YRF films" and wanted to see if you could help by adding your name. Our goal is to reach 75,000 signatures and we need more support. You can read more and sign the petition here: http://chng.it/XbKYPYm7SP Thanks! Rohit
Re: Multiple services run immediately
Thanks Rishi for adding up details. Just wanted to share, In Sync mode, a single thread is responsible for executing a complete task(means it child services and ECA rules). So if we have we have multiple ECA associated over a single service in sync mode then ECA will be run running in the order in which they get stacked during server startup. In addition, other ECA's needs to hold up until the current gets finished successfully. So in case, if there is any error during ECA execution at that point framework immediately stops subsequent ECA's to get trigger except for rules having run-on-failure/run-on-error is set to true. Unlike in Async mode, multiple independent threads are involved which allow executions of multiple ECA simultaneously over a common service. Thanks & Regards Rohit Koushal On Tue, Apr 28, 2020 at 2:36 AM Rishi Solanki wrote: > Ingo, > What exactly you want to achieve, you want to run two independent services > on ECA trigger and should run independently without waiting for each other > then it would be possible. Add two ECA rules and use Sync in action. > > And if you want two services run one by one on success or so then that also > possible. Add one ECA rule and two action with sync in sequence you want to > execute. The exact requirement would help to answer better. > > > Best Regards, > -- > Rishi Solanki > *CTO, Mindpath Technology* > Intelligent Solutions > cell: +91-98932-87847 > http://www.mindpathtech.com > LinkedIn <https://www.linkedin.com/in/rishi-solanki-62271b7/> > > > On Sun, Apr 26, 2020 at 6:21 PM Ankush Upadhyay < > ankush.upadh...@hotwaxsystems.com> wrote: > > > Hello Ingo, > > > > Answer for question > > @Pawan: "Have you tried with mode="sync" instead of mode="async"? It > should > > run both services simultaneously." Do you mean that in my example (one > eca > > - two sync action services) the second service would be started without > > waiting for the first to return the result? > > > > No, with sync mode, all actions of particular service eca would execute > one > > by one, If you want to go dipper to know how it works, you can review > > ServiceEcaRule.java and ServiceEcaAction. > > > > > > Kind Regards, > > Ankush Upadhyay > > Senior Technical Consultant > > > > *HotWax Systems* > > *Enterprise open source experts* > > cell: +91-8109201285 > > office: 0731-409-3684 > > http://www.hotwaxsystems.com > > > > > > On Sun, Apr 26, 2020 at 1:27 PM Ingo Wolfmayr > > wrote: > > > > > Hello Suraj, hello Pawan, Hello Nameet > > > > > > thanks for the fast responses. > > > > > > I have read the blog article aready + adjusting the service settings is > > > one of those things I try to improve before launching a new ofbiz > > > installation in production. So I guess I can check this of :) Adding an > > > additional server would be my last resort, but always taken into > account. > > > > > > When it comes to async an sync services with the example below - I just > > > want to make sure I am not folling a wrong idea: > > > > > > 1) async services would run independenly, but depend on the interval > > > services are polled. Default 30 seconds. So I will have to change this > > to 5 > > > seconds in order to have thoses services started "right away". > > > > persist="true"/> > > > > > > > > > > 2) sync services - the second service would wait for the first service > + > > > it is possible to use the result of service one. > > > > > > > > > > > > @Pawan: "Have you tried with mode="sync" instead of mode="async"? It > > > should run both services simultaneously." Do you mean that in my > example > > > (one eca - two sync action services) the second service would be > started > > > without waiting for the first to return the result? > > > > > > With case 1 - would it make a difference if I create a single eca > service > > > definition for each service to be called? Would they be called > > > independently? > > > > > > Thanks a lot. > > > Ingo > > > > > > > > > > > > -Ursprüngliche Nachricht- > > > Von: Suraj Khurana > > > Gesendet: Samstag, 25. April 2020 08:05 > > > An: ofbizuser > > > Betreff: Re: Multiple services run immediately > > > > > > Hello Ingo, > > > > >
Re: Multiple services run immediately
Hey Ingo, >> With case 1 - would it make a difference if I create a single eca service definition for each service to be called? Would they be called independently? It won't make any difference until we are utilizing async mode and same eca configuration. Additionally, they do call independently because when we are calling any service in async mode, it implies that system treats it as an independent thread and they are allowed to execute when system permits. If you would like to go in more details check ServiceDispatcher and ServiceEcaRule Kind Regards *Rohit Koushal* On Sun, Apr 26, 2020 at 6:21 PM Ankush Upadhyay < ankush.upadh...@hotwaxsystems.com> wrote: > Hello Ingo, > > Answer for question > @Pawan: "Have you tried with mode="sync" instead of mode="async"? It should > run both services simultaneously." Do you mean that in my example (one eca > - two sync action services) the second service would be started without > waiting for the first to return the result? > > No, with sync mode, all actions of particular service eca would execute one > by one, If you want to go dipper to know how it works, you can review > ServiceEcaRule.java and ServiceEcaAction. > > > Kind Regards, > Ankush Upadhyay > Senior Technical Consultant > > *HotWax Systems* > *Enterprise open source experts* > cell: +91-8109201285 > office: 0731-409-3684 > http://www.hotwaxsystems.com > > > On Sun, Apr 26, 2020 at 1:27 PM Ingo Wolfmayr > wrote: > > > Hello Suraj, hello Pawan, Hello Nameet > > > > thanks for the fast responses. > > > > I have read the blog article aready + adjusting the service settings is > > one of those things I try to improve before launching a new ofbiz > > installation in production. So I guess I can check this of :) Adding an > > additional server would be my last resort, but always taken into account. > > > > When it comes to async an sync services with the example below - I just > > want to make sure I am not folling a wrong idea: > > > > 1) async services would run independenly, but depend on the interval > > services are polled. Default 30 seconds. So I will have to change this > to 5 > > seconds in order to have thoses services started "right away". > > persist="true"/> > > > > > > 2) sync services - the second service would wait for the first service + > > it is possible to use the result of service one. > > > > > > > > @Pawan: "Have you tried with mode="sync" instead of mode="async"? It > > should run both services simultaneously." Do you mean that in my example > > (one eca - two sync action services) the second service would be started > > without waiting for the first to return the result? > > > > With case 1 - would it make a difference if I create a single eca service > > definition for each service to be called? Would they be called > > independently? > > > > Thanks a lot. > > Ingo > > > > > > > > -Ursprüngliche Nachricht- > > Von: Suraj Khurana > > Gesendet: Samstag, 25. April 2020 08:05 > > An: ofbizuser > > Betreff: Re: Multiple services run immediately > > > > Hello Ingo, > > > > Hope you are doing good. > > > > I am not sure about the environment you are currently trying to achieve > > this. IMO, there are two ways: > > > > - For improving performance, we can set up multiple OFBiz servers in > > parallel. Yes, we can set up two OFBiz servers, one calling sync service > > and another dedicated for async services only. > > Here [1] is a reference blog for more details. > > > > - You can increase jobs count in service engine [2], so that your OFBiz > > server will be picking more jobs to complete at a time, be careful > various > > factors are responsible with this approach, like CPU core, deployed OFBiz > > memory allocation, maximum DB threads enabled etc. > > > > [1] > > > > > https://www.hotwaxsystems.com/ofbiz/ofbiz-tutorials/apache-ofbiz-performance/ > > [2] framework/service/config/serviceengine.xml > > > > HTH. > > -- > > Best Regards, > > Suraj Khurana > > Senior Techincal Consultant > > > > > > On Fri, Apr 24, 2020 at 11:01 PM Ingo Wolfmayr > > wrote: > > > > > Hi everybody, > > > > > > I want to run two or more services immediately after another service > > > has finished. > > > > > > For example printing creating/printing the invoice and starting the > > >
Re: Easiest way to load entity data in XML from cmdline
Addition to the above reply, if you have multiple files then put them in a directory and run below command `gradlew "ofbiz --load-data dir=[path]"` On Mon, Feb 11, 2019 at 3:44 AM Blurbiness Info wrote: > Dear Rajesh, > > You could use: > > gradlew "ofbiz --load-data file=foo/bar/FileNameHere.xml" > > For any doubth about ofbiz command line options, the most useful > documentation source is the ofbiz/readme.md file. > > Best regards, > > Francisco > > > El dom., 10 feb. 2019 a las 21:00, Rajesh Mallah ( >) > escribió: > > > Dear List , > > > > While importing data from external systems, i am creating XML files > > having content like below. > > > > DemoData.xml > > > > > > .. > > entity data here ... > > .. > > > > > > What is the simple command that can be executed on shell to load > > the data from such files into OFBiz. > > > > > > > > > > regds > > mallah. > > > > > -- > > > *Blurbiness* > Producción multimedia para su negocio > *www.blurbiness.com* <http://www.blurbiness.com> > Thanks and Regards Rohit Koushal Sr. Enterprise Software Engineer Hotwax Systems www.hotwaxsystems.com
REQUEST TO BEACOME A CONTRIBUTOR
Hello, Please register me as an OFBiz Contributor. My account details are as follows: Full Name: Rohit Hukkeri Username: rohit.hukkeri I have signed the ICLA: https://people.apache.org/unlistedclas.html <https://www.google.com/url?q=https://people.apache.org/unlistedclas.html&sa=D&source=hangouts&ust=154044762261&usg=AFQjCNFbaWPiWg7zjSC8h36AeUR1gMhiKQ>
Re: REQUEST TO BECOME A CONTRIBUOR
Hello, It's my pleasure to be a part of the OFBiz community. Thanks and Regards *Rohit Hukkeri* | Enterprise Software Engineer HotWax Systems Pvt. Ltd On Wed, Oct 24, 2018 at 3:26 PM Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > You are now an OFBiz contributor, please update > https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Contributors > > Thanks > > > Le 24/10/2018 à 11:34, Rohit Hukkeri a écrit : > > Hello, > > > > I have updated the username on the Confluence site. > > > > Thanks and Regards > > Rohit Hukkeri > > > > > > > > On Wed, Oct 24, 2018 at 2:38 PM Jacques Le Roux < > > jacques.le.r...@les7arts.com> wrote: > > > >> Le 24/10/2018 à 10:28, Jacques Le Roux a écrit : > >>> Hi Rohit , > >>> > >>> I'll handle it very soon > >>> > >>> Jacques > >> I can't find "rohit.hukkeri" as a Confluence user > >> > >>> Le 24/10/2018 à 08:12, Rohit Hukkeri a écrit : > >>>> Hello, > >>>> > >>>> Please register me as an OFBiz Contributor. > >>>> > >>>> My account details are as follows: > >>>> Full Name: Rohit Hukkeri > >>>> Username: rohit.hukkeri > >>>> > >>>> I have signed the ICLA: > >>>> https://people.apache.org/unlistedclas.html > >>>> < > >> > https://www.google.com/url?q=https://people.apache.org/unlistedclas.html&sa=D&source=hangouts&ust=154044762261&usg=AFQjCNFbaWPiWg7zjSC8h36AeUR1gMhiKQ > > > >> > >>>> > >>> > >> > >
Re: REQUEST TO BECOME A CONTRIBUOR
Hello, I have updated the username on the Confluence site. Thanks and Regards Rohit Hukkeri On Wed, Oct 24, 2018 at 2:38 PM Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Le 24/10/2018 à 10:28, Jacques Le Roux a écrit : > > Hi Rohit , > > > > I'll handle it very soon > > > > Jacques > I can't find "rohit.hukkeri" as a Confluence user > > > > > Le 24/10/2018 à 08:12, Rohit Hukkeri a écrit : > >> Hello, > >> > >> Please register me as an OFBiz Contributor. > >> > >> My account details are as follows: > >> Full Name: Rohit Hukkeri > >> Username: rohit.hukkeri > >> > >> I have signed the ICLA: > >> https://people.apache.org/unlistedclas.html > >> < > https://www.google.com/url?q=https://people.apache.org/unlistedclas.html&sa=D&source=hangouts&ust=154044762261&usg=AFQjCNFbaWPiWg7zjSC8h36AeUR1gMhiKQ> > > >> > >> > > > > > >
REQUEST TO BECOME A CONTRIBUOR
Hello, Please register me as an OFBiz Contributor. My account details are as follows: Full Name: Rohit Hukkeri Username: rohit.hukkeri I have signed the ICLA: https://people.apache.org/unlistedclas.html <https://www.google.com/url?q=https://people.apache.org/unlistedclas.html&sa=D&source=hangouts&ust=154044762261&usg=AFQjCNFbaWPiWg7zjSC8h36AeUR1gMhiKQ>
Re: EntitySQLProcessor Transaction time-out
Hi Rajesh, Thanks for your reply. I tried count(*) beforehand it returned a time-out roll back. Rohit Rai www.hotwaxsystems.com On Mon, Jun 11, 2018 at 5:13 PM, Rajesh Mallah wrote: > Hi Rohit , > > for huge-sized resultset you should ideally use paging. > > Also try to see how long does the query takes to execute. > > you may use count(*) in place of the selected columns > to estimate it. > > regds > mallah. > > On Mon, Jun 11, 2018 at 4:39 PM, Rohit Rai > wrote: > > > Hi folks, > > > > I encountered a transaction time-out while performing a MySQL query from > > EntitySQLProcessor perhaps due to the huge size of the result set. > > > > > > Is it possible to increase the time-out or is there any other way to deal > > with this? Please advice. > > > > > > Earlier, when I faced the same issue while performing a delete query I > > dealt with it by limiting the rows. But, this time I need to perform a > > select query. > > > > > > Rohit Rai > > www.hotwaxsystems.com > > >
EntitySQLProcessor Transaction time-out
Hi folks, I encountered a transaction time-out while performing a MySQL query from EntitySQLProcessor perhaps due to the huge size of the result set. Is it possible to increase the time-out or is there any other way to deal with this? Please advice. Earlier, when I faced the same issue while performing a delete query I dealt with it by limiting the rows. But, this time I need to perform a select query. Rohit Rai www.hotwaxsystems.com
Re: Request to Become a Contributor.
Thank you :) Rohit Rai www.hotwaxsystems.com On Sat, Jul 22, 2017 at 12:25 PM, Ashish Vijaywargiya < ashish.vijaywarg...@hotwaxsystems.com> wrote: > Done, Thanks Rohit. Please check - > https://cwiki.apache.org/confluence/x/AIRMAg > > Kind Regards > Ashish Vijaywargiya > HotWax Systems - est. 1997 <http://www.hotwaxsystems.com/> > > > On Sat, Jul 22, 2017 at 9:52 AM, Rohit Rai > wrote: > > > Hello, > > > > Please register me as an OFBiz Contributor. > > > > My account details are as follows: > > Full Name: Rohit Rai > > User Name: rohit.rai > > Email: rohit@hotwaxsystems.com > > > > I have signed the ICLA: > > https://people.apache.org/unlistedclas.html > > > > Best Regards, > > Rohit Rai > > www.hotwaxsystems.com > > >
Request to Become a Contributor.
Hello, Please register me as an OFBiz Contributor. My account details are as follows: Full Name: Rohit Rai User Name: rohit.rai Email: rohit@hotwaxsystems.com I have signed the ICLA: https://people.apache.org/unlistedclas.html Best Regards, Rohit Rai www.hotwaxsystems.com
Re: To become contributor
Thanks Ashish. :) On Thu, Jun 2, 2016 at 12:03 PM, Ashish Vijaywargiya < ashish.vijaywarg...@hotwaxsystems.com> wrote: > Done. Thanks Rohit. Here you go - > https://cwiki.apache.org/confluence/x/AIRMAg > > -- > Kind Regards > Ashish Vijaywargiya > HotWax Systems - est. 1997 > https://www.linkedin.com/in/ashishvijaywargiya1 > > > On Thu, Jun 2, 2016 at 11:55 AM, Rohit Koushal < > rohit.kous...@hotwaxsystems.com> wrote: > >> Hello, >> >> I have filled the ICLA form and now I am sharing my confluence details - >> Full Name : Rohit Koushal >> User Name : rohit.koushal >> Email : rohit.kous...@hotwaxsystems.com >> >> >> Thanks and Regards >> Rohit Koushal >> > > -- Thanks and Regards Rohit Koushal Sr. Enterprise Software Engineer Hotwax Systems www.hotwaxsystems.com
To become contributor
Hello, I have filled the ICLA form and now I am sharing my confluence details - Full Name : Rohit Koushal User Name : rohit.koushal Email : rohit.kous...@hotwaxsystems.com Thanks and Regards Rohit Koushal
Re: Rupees Symbol in OFBiz
Hello Deepak, Thanks for your suggestion now its working as expected. On Mon, Jul 1, 2013 at 6:46 PM, Deepak Dixit wrote: > Hi Rohit, > > > You need to upgrade the icu4j jar to at least 4.6 or higher version. As > indian rupee sign support added on icu4_6.jar ( > http://site.icu-project.org/download/46). > > > Thanks & Regards > -- > Deepak Dixit > HotWax Media Pvt. Ltd. > www.hotwaxmedia.com > Contact :- +91-98267-54548 > Skype :- deepakdixit > > On Jul 1, 2013, at 6:37 PM, Deepak Dixit wrote: > > > Hi Rohit, > > > > Which release branch are you using? > > > > Thanks & Regards > > -- > > Deepak Dixit > > HotWax Media Pvt. Ltd. > > www.hotwaxmedia.com > > Contact :- +91-98267-54548 > > Skype :- deepakdixit > > > > On Jul 1, 2013, at 6:31 PM, Rohit Jain wrote: > > > >> Hello All, > >> > >> I am working on Indian e-commerce site that developed on OFBiz, I need > to > >> display Rupees symbol (Indian currency) in place of "Rs". > >> please suggest me changes or area where I need to look for achieve this. > >> > >> -- > >> > >> Thanks & Regards > >> -- > >> Rohit Jain > >> ERP & Ecommerce Software Developer > > > > -- Thanks & Regards -- Rohit Jain ERP & Ecommerce Software Developer rohit_indor...@yahoo.co.in Mob. : 8109181465
Rupees Symbol in OFBiz
Hello All, I am working on Indian e-commerce site that developed on OFBiz, I need to display Rupees symbol (Indian currency) in place of "Rs". please suggest me changes or area where I need to look for achieve this. -- Thanks & Regards -- Rohit Jain ERP & Ecommerce Software Developer
Re: Promotion Query
Hi Dev, Thanks for replay. 10 categories are just for explaining my case it could be more then 20-50 or 100 and all these categories are at same level that could have some sub-level categories. so I just want to know can we set such condition by that we can exclude 1 or more categories. As you mention include/exclude are for subcategories so I think we need to add "Browse Root" category with promotion and then need to exclude some categories from them. I will try this but is it right to add Browse Root category with a promotion? On Fri, Nov 2, 2012 at 4:39 PM, Deb Panda wrote: > Rohit, > > 1 - Why not include relevant 9 categories only rather that going for 10 > and excuding one? > 2 - Include / exclude are for subcategories while you are configuring > categories. > 3 - If these are sub categories of main category, suggest to explicitly > give relevant categories to be included and include its subsets. > 4 - Always exclude will be if parent category is included and this > category is to be excluded. > > > Hope the above helps... > > Dev Panda > > -Rohit Jain wrote: - > To: user@ofbiz.apache.org > From: Rohit Jain > Date: 11/02/2012 02:55PM > Subject: Promotion Query > > > Hello All, > > we are using OFBiz 10.04 > In catalog-> promo tabs > Query:- If we have 10 categories, and want to create a Promotion that can > be apply for all 9 categories but excluding 1. > for this, is it required to mention all those 9 categories in category > include section for promo Condition? > Or there is any other way to achieve it? > I have tried to use exclude category option but its not full fill our > requirement. > As if a order that include 1 product from that 1 excluded category with > other category products than promotion not applying > > Please provide your thoughts, it will help us > > -- > > Thanks & Regards > -- > Rohit Jain > ERP & Ecommerce Software Developer > rohit_indor...@yahoo.co.in > Mob. : 8109181465 > =-=-= > Notice: The information contained in this e-mail > message and/or attachments to it may contain > confidential or privileged information. If you are > not the intended recipient, any dissemination, use, > review, distribution, printing or copying of the > information contained in this e-mail message > and/or attachments to it are strictly prohibited. If > you have received this communication in error, > please notify us by reply e-mail or telephone and > immediately and permanently delete the message > and any attachments. Thank you > > > -- Thanks & Regards -- Rohit Jain ERP & Ecommerce Software Developer rohit_indor...@yahoo.co.in Mob. : 8109181465
GenericValue object - Calling OFBiz Web Service
Hi All, I have a basic question about the org.ofbiz.entity.GenericValue complex java object. I am implementing a RESTFul API layer as a component in the OFBiz. Here, I am exposing REST API to the external world and in turn I am trying to access the standard OFBiz web service in the layer code using Delegator and LocalDispatcher available in the web servlet context. My question here is when I want to call OFBiz service like "aimCCAuth" in org.ofbiz.accounting.thirdparty.authorizedotnet.AIMPaymentServices, if we observe the IN Parameter list, there are 2 parameters (credit card and orderPaymentPreference) mandatory with org.ofbiz.entity.GenericValue type. I dont know how to create this object since I am on the client side but within the OFBiz package as a component under /hot-deploy folder. Any light and help on this topic is greatly appreciated. I am stuck at this point. Thanks & Regards, Rohit
GenericValue object - OFBiz Web services
Hi All, I have a basic question about the org.ofbiz.entity.GenericValue complex java object. I am implementing a RESTFul API layer as a component in the OFBiz. Here, I am exposing REST API to the external world and in turn I am trying to access the standard OFBiz web service in the layer code using Delegator and LocalDispatcher available in the web servlet context. My question here is when I want to call OFBiz service like "aimCCAuth" in org.ofbiz.accounting.thirdparty.authorizedotnet.AIMPaymentServices, if we observe the IN Parameter list, there are 2 parameters (credit card and orderPaymentPreference) mandatory with org.ofbiz.entity.GenericValue type. I dont know how to create this object since I am on the client side but within the OFBiz package as a component under /hot-deploy folder. Any light and help on this topic is greatly appreciated. I am stuck at this point. Thanks & Regards, Rohit
Re: Unable to display images in ajax product jump form.
Hi Bilgin, i tried that but i did not work. I think the issue is more with jQuery and its configuration. for eg...i am adding the image tags in jQuery as : item.label = ""; where, item.value is the image path returned from ofbiz. Escaping "<" and ">" is jQuery has not helped either. I am quite confused as the "" tags which are added in the jQuery in the selectall.js file are working quite well. thanks, Rohit - saanjhi.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/Unable-to-display-images-in-ajax-product-jump-form-tp4236275p4239005.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Unable to display images in ajax product jump form.
Hi, I am trying to display product images in the product jump form in the keyword search box of the catalog application. Currently, it displays only the product name, brand name and the product Id. I was trying to display the product image as well. While I could get the image from the database and construct the image URL, the html returned by the jQuery escapes the image tags and displays the URL instead of displaying the image. For eg. after getting the image filepath i added the below code in the jQurey to append the image tag to form the image URL, item.label = ""; The code in the browser instead of showing the image, shows the URL as: http://ofbiz.apache.org/images/ofbiz_logo.gif And when i check the code in google chrome developer tools, the html generated is displayed as below: <img src="http://ofbiz.apache.org/images/ofbiz_logo.gif">; The tags "<" and ">" are being replaced by &alt; and > which causes the image URL to be displayed instead of the image itself. If i replace the &alt; and > tags in the debugger with "<" and ">" respectively, the image gets in the ajax request properly. I will really appreciate if someone can help me prevent the tags "<" and ">" being replaced. Thanks, Rohit - saanjhi.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/Unable-to-display-images-in-ajax-product-jump-form-tp4236275p4236275.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Import addresses with special characters.
hi, we are trying to import addresses from a tab-delimited file. The addresses in the file are in local languages such as German or Japanese, which contain special characters. Though ofbiz supports multiple languages, i am not sure how to import them into the database. I will appreciate if anyone can help. Thanks, Rohit - saanjhi.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/Import-addresses-with-special-characters-tp4107252p4107252.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Product Price Rule page load error.
hi, there is a problem in the product price rules page. the default value in the conditions table under the "input" drop-down list is "product", which causes the "value" drop-down list to list all the products currently in the catalog. A store may have thousands of products which in this case will all be listed under the 'value' list. This cause the page to time-out or hang, and i suppose is not the best option and it should be replaces with a search box besides it, as we have in 'search products' tab. Thanks Rohit - saanjhi.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/Product-Price-Rule-page-load-error-tp3629705p3629705.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: svn commit: r1076507 deletes the images folder.
Hi Hans, Firstly, even if re-sizing can be done using the new system...how do you suggest the issues of bulk upload can be tackled, without maintaining 2 separate directory structures for images? Secondly, the JIRA issue may be open for 10 days...that does not mean, its necessarily approved of. I am no expert of the code...but i do not find if any of the other more experienced committers and contributors have made any comment of this functionality. i am not sure if any opinion was sought either. For eg. when the code was migrated to jQuery their was a conscious effort from the contributors to solicit feedback and opinion. Thirdly, the fact that i have been following the mailing list directly is what made me identify this issue and still believe their is no reason you should replace the existing structure...when your code could have been made optional for those who wanted to use it rather than being forced to use it. Please do not mis-construe that i am suggesting on the quality of code, all that i am saying is that it could have been made optional without removing the existing functionality. and as Eric mentioned "Rule #1 for a committer is the same as for a doctor: first do no harm. Nothing should be committed that breaks existing functionality without replacing it either before or in the same commit. Whatever you are working with someone developed it and chances are someone is using it, and possibly MANY people." thanks Rohit - saanjhi.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/Re-svn-commit-r1076507-deletes-the-images-folder-tp3343463p3351328.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: svn commit: r1076507 deletes the images folder.
hi, i am also not sure of a few other practical issues. for eg. bulk uploading of new products and images. currently i assume most use the the xml file to import products data and then upload product images into 1 directory after re-sizing. though it appears that the existing image file system can be maintained, but does it make sense to have 2 different image file system, it can obviously be an issue when doing back-up maintenance etc. The new image management contribution, does not seem complete as its not working fully on the demo server, when i checked last 03/09/11. Also there are many store which run ofbiz on the trunk. though the trunk may not be ideal for it, i still believe that the current structure should not have been removed so fast as many using ofbiz risk accidently deleting all their images. And instead of replacing the current directory structure a new directly may have used until the code matured and acquired more acceptance. Should it not be researched more, before it replaces the current structure. thanks Rohit - saanjhi.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/Re-svn-commit-r1076507-deletes-the-images-folder-tp3343463p3347403.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: svn commit: r1076507 deletes the images folder.
hi, i see that in this commit the images folders are being deleted. I assume that anyone running ofbiz on its trunk would lose all the product images if they updated their code as the folder will be deleted. please correct me if I am wrong. and if this is the case, i am really surprised how such a major change can be included without further discussions. the current commit also shows that a new folder is created for every product, thus if a store had say 100K products, there will be 100K additional folders created. I am not sure if this is at all expected or desirable and before getting such major changes incorporated in the trunk, it has not been discussed at all. please post your feedback. thanks Rohit - saanjhi.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/Re-svn-commit-r1076507-deletes-the-images-folder-tp3343463p3343463.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: svn commit: r1076507 deletes the images folder.
hi, i see that in this commit the images folders are being deleted. I assume that anyone running ofbiz on its trunk would lose all the product images if they updated their code as the folder will be deleted. please correct me if I am wrong. and if this is the case, i am really surprised how such a major change can be included without further discussions. the current commit also shows that a new folder is created for every product, thus if a store had say 100K products, there will be 100K additional folders created. I am not sure if this is at all expected or desirable and before getting such major changes incorporated in the trunk, it has not been discussed at all. please post your feedback. thanks Rohit - saanjhi.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/Re-svn-commit-r1076507-deletes-the-images-folder-tp3343462p3343462.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: svn commit: r1076507 deletes the images folder.
hi, i see that in this commit the images folders are being deleted. I assume that anyone running ofbiz on its trunk would lose all the product images if they updated their code as the folder will be deleted. please correct me if I am wrong. and if this is the case, i am really surprised how such a major change can be included without further discussions. the current commit also shows that a new folder is created for every product, thus if a store had say 100K products, there will be 100K additional folders created. I am not sure if this is at all expected or desirable and before getting such major changes incorporated in the trunk, it has not been discussed at all. please post your feedback. thanks Rohit - saanjhi.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/Re-svn-commit-r1076507-deletes-the-images-folder-tp3343461p3343461.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Customer Registration module in OFBiz without address details.
hi, yes, its possible to register a customer without the address details. we use the service 'createPersonAndUserLogin' to do this. you can probably use the same service, using some default password required to be changed at first log-on. the only parameters that you necessarily need is the first name, last name, userloginId and the password to run this service. the rest of the data can be added as and when necessary. hope it helps. rohit - http://www.saanjhi.com saanjhi.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/Customer-Registration-module-in-OFBiz-without-address-details-tp3165933p3166818.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Unable to acquire a new connection from the pool
hi, i generally saw such error caused due to some services not terminating properly. For eg. in such cases i would shut down ofbiz and check the 'JobSandbox' table to see if any process is still in the running state. If yes, i assume it means that the job did not terminate and is causing the problem. i will try to delete that records and then re-start ofbiz. if may not be the right way, but it worked for us. thanks Rohit http://www.saanjhi.com www.saanjhi.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/Unable-to-acquire-a-new-connection-from-the-pool-tp1012609p3051282.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: removing whitespace from String.
hi Jacques, Yes, i found the same code as you mentioned and it did work. thanks so much. rohit -- View this message in context: http://ofbiz.135035.n4.nabble.com/removing-whitespace-from-String-tp2537234p2539014.html Sent from the OFBiz - User mailing list archive at Nabble.com.
removing whitespace from String.
hi i am trying to remove whitespace from string, but have been unable to do so in cases where there are 3 consecutive whitespaces. for eg. String X = X.replaceAll(" ", "-"); replaces only a maximum of 2 consecutive whitespace and not 3. i tried running the relaceAll, once again on the already modified string, but it did not help. any ideas will be helpful. Thanks Rohit -- View this message in context: http://ofbiz.135035.n4.nabble.com/removing-whitespace-from-String-tp2537234p2537234.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: help with groovy file
i did, now it shows the below error: (SQL Exception while setting value on field [orderId] of entity OrderHeader: (An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'Types.JAVA_OBJECT'.)) (Error running Groovy script at location [component://snjPurchasing/webapp/snjPurchasing/WEB-INF/actions/ViewRequirement.groovy] (SQL Exception while setting value on field [orderId] of entity OrderHeader: (An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'Types.JAVA_OBJECT'.))) -- View this message in context: http://ofbiz.135035.n4.nabble.com/help-with-groovy-file-tp2300959p2300980.html Sent from the OFBiz - User mailing list archive at Nabble.com.
help with groovy file
hi, I want to view the order page using the requirementId passed to the order view page. The code should search the orderID associate with the requirement ID in the entity OrderRequirementCommitment, and then display the order. In the OrderView.groovy file i thus the following code, but its not working: requirementId = parameters.requirementId; orderRequirement = null; requirement = null; requirement = delegator.findByPrimaryKey("Requirement", [requirementId : requirementId]); orderRequirement = requirement.getRelated("OrderRequirementCommitment"); orderId = orderRequirement("orderId"); context.orderId = orderId; I guess the problem is that the relationship is not one-to-one and i am getting the below error, any help will be appreciated. ERROR rendering error page [/error/error.jsp], but here is the error text: org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://snjPurchasing/widget/snjPurchasingScreens.xml#ViewRequirement]: groovy.lang.MissingMethodException: No signature of method: javolution.util.FastMap.call() is applicable for argument types: (java.lang.String) values: [orderId] Possible solutions: tail(), wait(), any(), wait(long), any(groovy.lang.Closure), each(groovy.lang.Closure) (No signature of method: javolution.util.FastMap.call() is applicable for argument types: (java.lang.String) values: [orderId] Possible solutions: tail(), wait(), any(), wait(long), any(groovy.lang.Closure), each(groovy.lang.Closure)) -- View this message in context: http://ofbiz.135035.n4.nabble.com/help-with-groovy-file-tp2300959p2300959.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Product Search Error when using Postgres database.
does the error log, provide any help or point to any potential problem. I spent the whole day today to resolve this but no success yet. I also updated postgres to 8.4 and the jdbc driver and did the ant run-install. to freshly populate the database but no help. I guess its more of an environment issue, than with the code. I am using jdk 1.6-17, postgres 8.4 and postgres8.4-jdbc4, on FC-8. If u get any pointers, from the log please do let me know. Thanks, Rohit -- View this message in context: http://ofbiz.135035.n4.nabble.com/Product-Search-Error-when-using-Postgres-database-tp2253277p2253573.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Product Search Error when using Postgres database.
it was showing for the keyword 'giz'. u mentioned that you are using postgres 8.4, do we necessarily have to use 8.4. I am getting the error when using 8.2. Does the SQL generated as shown in the error seem correct to you. Thanks, Rohit -- View this message in context: http://ofbiz.135035.n4.nabble.com/Product-Search-Error-when-using-Postgres-database-tp2253277p2253341.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Product Search Error when using Postgres database.
Hi, I am using the latest SVN with postgres database 8.2.11. When searching for products for certain keyword, its throwing the below error. Did anyone notice such error? Its best to try some random keywords to reproduce the error. Any help will be appreciated. Thanks, Rohit 010-06-13 04:05:37,506 (TP-Processor7) [ SequenceUtil.java:337:INFO ] Got bank of sequenced IDs for [ProductSearchResult]; curSeqId=10010, maxSeqId=10020, bankSize=10 2010-06-13 04:05:37,508 (TP-Processor7) [ GenericDelegator.java:900:ERROR] exception report -- Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-13 04:05:37.507(java.sql.Timestamp)][createdTxStamp,2010-06-13 04:05:37.377(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-13 04:05:37.507(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-13 04:05:37.377(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10010(java.lang.String)][searchDate,2010-06-13 04:05:37.412(java.sql.Timestamp)][secondsTotal,0.011(java.lang.Double)][visitId,10015(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction. Exception: org.ofbiz.entity.GenericEntityException Message: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-06-13 04:05:37.507(java.sql.Timestamp)][createdTxStamp,2010-06-13 04:05:37.377(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-13 04:05:37.507(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-13 04:05:37.377(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10010(java.lang.String)][searchDate,2010-06-13 04:05:37.412(java.sql.Timestamp)][secondsTotal,0.011(java.lang.Double)][visitId,10015(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)) cause - Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block) cause - Exception: org.postgresql.util.PSQLException Message: ERROR: current transaction is aborted, commands ignored until end of transaction block stack trace --- org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:195) org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305) org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744) org.ofbiz.entity.GenericValue.create(GenericValue.java:125
Re: error in google product export.
just checking is someone encountered similar problems. I couldn't find how to change the quotes in the form, but couldn't do it, any help will be appreciated. Thanks Rohit rohit wrote: > > Hi, > > I think there is an error in googlebase product export. > > if we export a single item, the code works OK, but when we try to export > multiple item to google base the code fails. > > The probable error is with the way the multiple product ids are passed to > the java code for processing. > > till sometime, the part of the FTL holding the multiple porductids were in > '[]' or second brackets, with a recent path they have been changed to '{}' > or third bracket. I am not sure if this causes the failure for the java > code to accept multiple items, but its the only change I noticed in Google > base recently. > > I am using the latest SVN on a linux machine. > > Any feedback is welcome. > > Thanks, > > Rohit > > -- View this message in context: http://n4.nabble.com/error-in-google-product-export-tp1594536p1693554.html Sent from the OFBiz - User mailing list archive at Nabble.com.
error in google product export.
Hi, I think there is an error in googlebase product export. if we export a single item, the code works OK, but when we try to export multiple item to google base the code fails. The probable error is with the way the multiple product ids are passed to the java code for processing. till sometime, the part of the FTL holding the multiple porductids were in '[]' or second brackets, with a recent path they have been changed to '{}' or third bracket. I am not sure if this causes the failure for the java code to accept multiple items, but its the only change I noticed in Google base recently. I am using the latest SVN on a linux machine. Any feedback is welcome. Thanks, Rohit -- View this message in context: http://n4.nabble.com/error-in-google-product-export-tp1594536p1594536.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: ofbiz build fails
yes, it tried building on another machine with jdk 1.6.0_17 and it build fine. But it does not build with jdk 1.6.0_11. which jdk version did u test with? Rohit -- View this message in context: http://n4.nabble.com/ofbiz-build-fails-tp1469028p1469116.html Sent from the OFBiz - User mailing list archive at Nabble.com.
ofbiz build fails
hi, i tried to build the latest svn, but it failed with the following message. i am doing a fresh build with no changes whatsoever on a linux machine with jdk 1.6.11 Anybody else experience such issue. Rohit prepare: [mkdir] Created dir: /mnt/server-disk/ofbizsvn/ofbiz/applications/product/build/classes [mkdir] Created dir: /mnt/server-disk/ofbizsvn/ofbiz/applications/product/build/lib classes: [javac16] Compiling 54 source files to /mnt/server-disk/ofbizsvn/ofbiz/applications/product/build/classes [javac16] /mnt/server-disk/ofbizsvn/ofbiz/applications/product/src/org/ofbiz/product/product/ProductSearchSession.java:1230: cannot find symbol [javac16] symbol : method add(java.util.Map) [javac16] location: interface java.util.List> [javac16] featureCountList.add(UtilMisc.toMap("productFeatureId", (String) searchResult.get("pfacProductFeatureId"), "productFeatureTypeId", (String) searchResult.get("pfcProductFeatureTypeId"), "description", (String) searchResult.get("pfcDescription"), "featureCount", Long.toString((Long) searchResult.get("featureCount"; [javac16] ^ [javac16] Note: /mnt/server-disk/ofbizsvn/ofbiz/applications/product/src/org/ofbiz/product/product/ProductSearch.java uses unchecked or unsafe operations. [javac16] Note: Recompile with -Xlint:unchecked for details. [javac16] 1 error -- View this message in context: http://n4.nabble.com/ofbiz-build-fails-tp1469028p1469028.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Paypal Payment via PayFlow Pro
hi, what is "YOUR API SIGNATURE". i intend to test on live server, and have the api username and password setup, but could not find anything that said 'API SIGNATURE'. Do you mean the certificate file with it? Rohit -- View this message in context: http://n4.nabble.com/Paypal-Payment-via-PayFlow-Pro-tp1288675p1457554.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Paypal Payment via PayFlow Pro
yes, i too intend to use the NVP API. Rohit -- View this message in context: http://n4.nabble.com/Paypal-Payment-via-PayFlow-Pro-tp1288675p1457539.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Paypal Payment via PayFlow Pro
Hi Scott, Is there any documentation on how to set it up. On the demo server, we are directed back to ofbiz site after clicking the paypal express checkout button. Am not sure how to do the set-up and try it out. Thank, rohit -- View this message in context: http://n4.nabble.com/Paypal-Payment-via-PayFlow-Pro-tp1288675p1457532.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Paypal Express set up help...
hi, Is there any documentation on how to setup and use paypal express checkout? Any information will be appreciated. Thanks Rohit -- View this message in context: http://n4.nabble.com/Paypal-Express-set-up-help-tp1457426p1457426.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: doubt in popup position setting by using popup.js
Hello All, Please lets me know if my question not clear and if there more detail required. Still I am facing same problem when working with popup .js. I can't set specific position of popup. Thanks & Regards -- Rohit Jain On Tue, Jan 12, 2010 at 11:38 AM, Rohit Jain wrote: > Hello All, > > I am trying to use popup.js for rederning popup. > but popup are rendered on its default position, I want to changed its > position > please suggest me how can I set custom position of popup by using popup.js > for rendering popup I am using following code > > new Popup('popupBox','popupLink', {modal: true, position: '', trigger: > 'click'}) > > I tried to understand popup.js code but unable to get following Regular > Expression that used in condition > > if (mo = > this.options.position.match(/^\s*([^\s,]+)\s*,\s*([^\s,]+)\s*$/)) { > > it used in get_popup_position() function of popup class. > > Thanks in Advance > > Thanks & Regards > -- > Rohit Jain >
Re: svn commit: r897605 - in /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: datasource/GenericDAO.java util/EntityListIterator.java
Hi David, I was checking if you got the chance to check my last post. Thanks, Rohit "Yes, i am using a different database, PostgreSQL 8.2.11 on fedora FC 8. I am not a database expert, but issue seems to be with some 'nested queries' that ofbiz was making after this commit. I noticed in logs that select query for the keywords that caused the error was different from that of the keywords which did not cause any problem. I am unsure but should i open a Jira issue for it, i assume that ofbiz is made to support multiple database software. Rohit " David E Jones-4 wrote: > > > This is probably true. I apologize that I haven't been able to look into > your report more... > > Which database are you using Rohit? > > -David > > > On Jan 14, 2010, at 9:10 PM, Scott Gray wrote: > >> My guess is that the commit introduced a problem for some databases but >> not for others, so it works on the demo instance (Derby) but not on your >> instance which I assume is running a different database server. >> >> Regards >> Scott >> >> On 14/01/2010, at 8:00 PM, rohit wrote: >> >>> >>> I did not recreate the database. but i briefly checked it was working on >>> ofbiz demo server, which i assume is started up afresh everyday >>> including the database. >>> I faced the problem in the following situations: >>> if multiple keywords are used and the keywords were already in the >>> database in productkeyword table and other tables, ofbiz throws the >>> error. the unique thing i noticed that the error did not occur for sets >>> of keywords used for the first time and not already existing in the >>> database. >>> I hope it helps, but i am sure there is some issue with this commit. >>> Rohit >>> >>> >>> --- On Fri, 1/15/10, Scott Gray-2 [via OFBiz] >>> wrote: >>> >>> From: Scott Gray-2 [via OFBiz] >>> >>> Subject: Re: svn commit: r897605 - in >>> /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: >>> datasource/GenericDAO.java util/EntityListIterator.java >>> To: "rohit" >>> Date: Friday, January 15, 2010, 5:21 AM >>> >>> >>> >>> Hi Rohit, >>> >>> >>> Are you sure that it works if the database is recreated? I can't see >>> >>> anything in the commit that would cause or require the database >>> >>> structure to change. >>> >>> >>> Regards >>> >>> Scott >>> >>> >>> HotWax Media >>> >>> http://www.hotwaxmedia.com >>> >>> On 13/01/2010, at 3:44 PM, rohit wrote: >>> >>> >>>> >>> >>>> Hi, >>> >>>> >>> >>>> I don't think this commit is compatible with older database created by >>> >>>> ofbiz. >>> >>>> >>> >>>> For eg. if you update the code without recreating the ofbiz database >>> >>>> you get >>> >>>> error as in >>> >>>> >>> >>>> http://n4.nabble.com/Error-in-product-search-result-when-using-multiple-keywords-td1012687.html#a1012687 >>>> >>> >>>> I had to reverse this commit to remove the error. >>> >>>> >>> >>>> I guess there might be a better way to do this than to drop and >>> >>>> recreate the >>> >>>> tables for this commit to work. >>> >>>> >>> >>>> Rohit >>> >>>> -- >>> >>>> View this message in context: >>>> http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1013432.html >>>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >>> >>> smime.p7s (3K) Download Attachment >>> >>> >>> >>> >>> >>> View message @ >>> http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1014358.html >>> >>> >>> To unsubscribe from RE: svn commit: r897605 - in >>> /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: >>> datasource/GenericDAO.java util/EntityListIterator.java, click here. >>> >>> >>> >>> >>> -- >>> View this message in context: >>> http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1014471.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >> > > > -- View this message in context: http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1016339.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Unable to acquire a new connection from the pool
I don't know, but i my case it sure did. For eg. i noticed that every running process not properly terminated held 2 pool connections with my postgres database, one in either 'commit' or 'update' mode and the other in 'in transaction' status. Say, 3 services in running status, blocked 6 pool connections. After restarting ofbiz, the pool connections would be released, but when ofbiz tried to run the same service again, it probably tries to complete the older tasks not properly closed. this further caused the database pool error. I am not aware in detail of how the pool connections are used by ofbiz. But after removing the services not properly closed from the jobsandox database, i witnessed significant change in performance in ofbiz. Rohit Scott Gray-2 wrote: > > On 13/01/2010, at 12:05 AM, Jacques Le Roux wrote: > >> From: "rohit" >>> Hi, >>> >>> Please also check the jobsandbox database for any service not >>> properly >>> terminated, for eg. they are still in the running status. >>> >>> i had a lot of problem with us service not ending properly. even >>> with the >>> latest code running i have to manually delete some running process >>> on the >>> database. Each running process seems to block 1 - 2 pool connection >>> and >>> hence the error. currently for eg. the sendorderconfirmation email >>> gets >>> stuck as a running process for a long time. >> >> A Jira issue is pending for that >> https://issues.apache.org/jira/browse/OFBIZ-2974 > > I don't think that issue would be relevant to this discussion, a job > left in the running status after an improper shutdown won't have any > effect on database connections. > > Regards > Scott > >> >> Jacques >> >>> Hope it help. >>> >>> Rohit >>> >>> >>> Juan Pablo wrote: >>>> >>>> Hi Community. >>>> >>>> Today I had a lot of error messages when I execute some >>>> operations: Update >>>> Product, Facility Receipt, etc. >>>> >>>> This is one of the error messages: >>>> >>>> -- >>>> >>>> Error en la llamada el evento: >>>> org.ofbiz.webapp.event.EventHandlerException: >>>> Service invocation error (Could not commit transaction for service >>>> [updateProduct] call: Roll back error, could not commit >>>> transaction, was >>>> rolled back instead because of: Failure in findByCondition >>>> operation for >>>> entity [ProductDimension]: >>>> org.ofbiz.entity.GenericDataSourceException: >>>> Unable to esablish a connection with the database. (Unable to >>>> acquire a >>>> new >>>> connection from the pool). Rolling back >>>> transaction.org.ofbiz.entity.GenericDataSourceException: Unable to >>>> esablish >>>> a connection with the database. (Unable to acquire a new >>>> connection from >>>> the >>>> pool) (Unable to esablish a connection with the database. (Unable to >>>> acquire >>>> a new connection from the pool))) >>>> >>>> -- >>>> I understand that the main erro is "Unable to acquire a new >>>> connection >>>> from >>>> the pool" but I don´t understand how I can resolve. >>>> >>>> I use a local installation with a unique user! >>>> >>>> Thaks. >>>> >>>> -- >>>> Juan Pablo >>>> >>>> >>> >>> -- >>> View this message in context: >>> http://n4.nabble.com/Unable-to-acquire-a-new-connection-from-the-pool-tp1012609p1012691.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >> >> > > > > -- View this message in context: http://n4.nabble.com/Unable-to-acquire-a-new-connection-from-the-pool-tp1012609p1014491.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: svn commit: r897605 - in /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: datasource/GenericDAO.java util/EntityListIterator.java
Yes, i am using a different database, PostgreSQL 8.2.11 on fedora FC 8. I am not a database expert, but issue seems to be with some 'nested queries' that ofbiz was making after this commit. I noticed in logs that select query for the keywords that caused the error was different from that of the keywords which did not cause any problem. I am unsure but should i open a Jira issue for it, i assume that ofbiz is made to support multiple database software. Rohit David E Jones-4 wrote: > > > This is probably true. I apologize that I haven't been able to look into > your report more... > > Which database are you using Rohit? > > -David > > > On Jan 14, 2010, at 9:10 PM, Scott Gray wrote: > >> My guess is that the commit introduced a problem for some databases but >> not for others, so it works on the demo instance (Derby) but not on your >> instance which I assume is running a different database server. >> >> Regards >> Scott >> >> On 14/01/2010, at 8:00 PM, rohit wrote: >> >>> >>> I did not recreate the database. but i briefly checked it was working on >>> ofbiz demo server, which i assume is started up afresh everyday >>> including the database. >>> I faced the problem in the following situations: >>> if multiple keywords are used and the keywords were already in the >>> database in productkeyword table and other tables, ofbiz throws the >>> error. the unique thing i noticed that the error did not occur for sets >>> of keywords used for the first time and not already existing in the >>> database. >>> I hope it helps, but i am sure there is some issue with this commit. >>> Rohit >>> >>> >>> --- On Fri, 1/15/10, Scott Gray-2 [via OFBiz] >>> wrote: >>> >>> From: Scott Gray-2 [via OFBiz] >>> >>> Subject: Re: svn commit: r897605 - in >>> /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: >>> datasource/GenericDAO.java util/EntityListIterator.java >>> To: "rohit" >>> Date: Friday, January 15, 2010, 5:21 AM >>> >>> >>> >>> Hi Rohit, >>> >>> >>> Are you sure that it works if the database is recreated? I can't see >>> >>> anything in the commit that would cause or require the database >>> >>> structure to change. >>> >>> >>> Regards >>> >>> Scott >>> >>> >>> HotWax Media >>> >>> http://www.hotwaxmedia.com >>> >>> On 13/01/2010, at 3:44 PM, rohit wrote: >>> >>> >>>> >>> >>>> Hi, >>> >>>> >>> >>>> I don't think this commit is compatible with older database created by >>> >>>> ofbiz. >>> >>>> >>> >>>> For eg. if you update the code without recreating the ofbiz database >>> >>>> you get >>> >>>> error as in >>> >>>> >>> >>>> http://n4.nabble.com/Error-in-product-search-result-when-using-multiple-keywords-td1012687.html#a1012687 >>>> >>> >>>> I had to reverse this commit to remove the error. >>> >>>> >>> >>>> I guess there might be a better way to do this than to drop and >>> >>>> recreate the >>> >>>> tables for this commit to work. >>> >>>> >>> >>>> Rohit >>> >>>> -- >>> >>>> View this message in context: >>>> http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1013432.html >>>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >>> >>> smime.p7s (3K) Download Attachment >>> >>> >>> >>> >>> >>> View message @ >>> http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1014358.html >>> >>> >>> To unsubscribe from RE: svn commit: r897605 - in >>> /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: >>> datasource/GenericDAO.java util/EntityListIterator.java, click here. >>> >>> >>> >>> >>> -- >>> View this message in context: >>> http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1014471.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >> > > > -- View this message in context: http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1014484.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: svn commit: r897605 - in /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: datasource/GenericDAO.java util/EntityListIterator.java
I did not recreate the database. but i briefly checked it was working on ofbiz demo server, which i assume is started up afresh everyday including the database. I faced the problem in the following situations: if multiple keywords are used and the keywords were already in the database in productkeyword table and other tables, ofbiz throws the error. the unique thing i noticed that the error did not occur for sets of keywords used for the first time and not already existing in the database. I hope it helps, but i am sure there is some issue with this commit. Rohit --- On Fri, 1/15/10, Scott Gray-2 [via OFBiz] wrote: From: Scott Gray-2 [via OFBiz] Subject: Re: svn commit: r897605 - in /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: datasource/GenericDAO.java util/EntityListIterator.java To: "rohit" Date: Friday, January 15, 2010, 5:21 AM Hi Rohit, Are you sure that it works if the database is recreated? I can't see anything in the commit that would cause or require the database structure to change. Regards Scott HotWax Media http://www.hotwaxmedia.com On 13/01/2010, at 3:44 PM, rohit wrote: > > Hi, > > I don't think this commit is compatible with older database created by > ofbiz. > > For eg. if you update the code without recreating the ofbiz database > you get > error as in > > http://n4.nabble.com/Error-in-product-search-result-when-using-multiple-keywords-td1012687.html#a1012687 > > I had to reverse this commit to remove the error. > > I guess there might be a better way to do this than to drop and > recreate the > tables for this commit to work. > > Rohit > -- > View this message in context: > http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1013432.html > Sent from the OFBiz - User mailing list archive at Nabble.com. smime.p7s (3K) Download Attachment View message @ http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1014358.html To unsubscribe from RE: svn commit: r897605 - in /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: datasource/GenericDAO.java util/EntityListIterator.java, click here. -- View this message in context: http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1014471.html Sent from the OFBiz - User mailing list archive at Nabble.com.
RE: svn commit: r897605 - in /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: datasource/GenericDAO.java util/EntityListIterator.java
Hi, I don't think this commit is compatible with older database created by ofbiz. For eg. if you update the code without recreating the ofbiz database you get error as in http://n4.nabble.com/Error-in-product-search-result-when-using-multiple-keywords-td1012687.html#a1012687 I had to reverse this commit to remove the error. I guess there might be a better way to do this than to drop and recreate the tables for this commit to work. Rohit -- View this message in context: http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1013432.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Unable to acquire a new connection from the pool
Hi, Please also check the jobsandbox database for any service not properly terminated, for eg. they are still in the running status. i had a lot of problem with us service not ending properly. even with the latest code running i have to manually delete some running process on the database. Each running process seems to block 1 - 2 pool connection and hence the error. currently for eg. the sendorderconfirmation email gets stuck as a running process for a long time. Hope it help. Rohit Juan Pablo wrote: > > Hi Community. > > Today I had a lot of error messages when I execute some operations: Update > Product, Facility Receipt, etc. > > This is one of the error messages: > > -- > > Error en la llamada el evento: > org.ofbiz.webapp.event.EventHandlerException: > Service invocation error (Could not commit transaction for service > [updateProduct] call: Roll back error, could not commit transaction, was > rolled back instead because of: Failure in findByCondition operation for > entity [ProductDimension]: org.ofbiz.entity.GenericDataSourceException: > Unable to esablish a connection with the database. (Unable to acquire a > new > connection from the pool). Rolling back > transaction.org.ofbiz.entity.GenericDataSourceException: Unable to > esablish > a connection with the database. (Unable to acquire a new connection from > the > pool) (Unable to esablish a connection with the database. (Unable to > acquire > a new connection from the pool))) > > -- > I understand that the main erro is "Unable to acquire a new connection > from > the pool" but I don´t understand how I can resolve. > > I use a local installation with a unique user! > > Thaks. > > -- > Juan Pablo > > -- View this message in context: http://n4.nabble.com/Unable-to-acquire-a-new-connection-from-the-pool-tp1012609p1012691.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Error in product search result when using multiple keywords.
Hi, i am running the latest version of ofbiz with postgres. The product search in ecommerce works fine when using a single keyword, however when two or more keywords are entered i am getting the below error. Is it a bug, should i open a jira issue for it. Please advise, Thanks, Rohit 2010-01-12 21:12:21,982 (TP-Processor20) [ ControlServlet.java:321:INFO ] [[[keywordsearch] Request Done- total:0.269,since last([keywordsearch] R...):0.269]] 2010-01-12 21:12:22,694 (TP-Processor20) [ ContextFilter.java:260:WARN ] [Filtered request]: /favicon.ico (/control/main) 2010-01-12 21:12:23,012 (TP-Processor2) [ ControlServlet.java:140:INFO ] [[[main] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2010-01-12 21:12:23,014 (TP-Processor2) [ RequestHandler.java:733:INFO ] Rendering View [main], sessionId=B3B4DC9539461C47F565AA8E223DCF60.jvm1 2010-01-12 21:12:23,160 (TP-Processor2) [ ProductStoreWorker.java:481:INFO ] getSurvey for product null 2010-01-12 21:12:23,886 (TP-Processor2) [ ControlServlet.java:321:INFO ] [[[main] Request Done- total:0.874,since last([main] Request Be...):0.874]] 2010-01-12 21:12:24,902 (TP-Processor9) [ ControlServlet.java:140:INFO ] [[[keywordsearch] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2010-01-12 21:12:24,907 (TP-Processor9) [ JkInputStream.java:196:INFO ] Receiving: getting request body chunk 96 96 2010-01-12 21:12:24,911 (TP-Processor9) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [abnormal], got set: [] 2010-01-12 21:12:24,912 (TP-Processor9) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [psychology], got set: [] 2010-01-12 21:12:24,912 (TP-Processor9) [ RequestHandler.java:629:INFO ] Ran Event [java:org.ofbiz.product.product.ProductSearchSession#checkDoKeywordOverride] from [request], result is [success] 2010-01-12 21:12:24,912 (TP-Processor9) [ RequestHandler.java:733:INFO ] Rendering View [keywordsearch], sessionId=B3B4DC9539461C47F565AA8E223DCF60.jvm1 2010-01-12 21:12:24,927 (TP-Processor9) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [abnormal], got set: [] 2010-01-12 21:12:24,927 (TP-Processor9) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [psychology], got set: [] 2010-01-12 21:12:24,928 (TP-Processor9) [ ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet=[] keywordFixedOrSetAndList=[[%abnormal%, %psycholog%]] 2010-01-12 21:12:25,129 (TP-Processor9) [ GenericDAO.java:766:INFO ] Ran query in 199 milli-seconds: SELECT DISTINCT SUM(PK1.RELEVANCY_WEIGHT), PROD.PRODUCT_ID FROM (public.PRODUCT PROD LEFT OUTER JOIN public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PROD.IS_VARIANT <> ? AND (PK1.KEYWORD LIKE ? OR PK1.KEYWORD LIKE ?)) GROUP BY PROD.PRODUCT_ID ORDER BY SUM(PK1.RELEVANCY_WEIGHT) DESC 2010-01-12 21:12:25,133 (TP-Processor9) [ ProductSearch.java:762:ERROR] exception report -- Error getting results from the product search query Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:SELECT COUNT(1) FROM (SELECT COUNT(DISTINCT SUM(PK1.RELEVANCY_WEIGHT)) FROM (public.PRODUCT PROD LEFT OUTER JOIN public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PROD.IS_VARIANT <> ? AND (PK1.KEYWORD LIKE ? OR PK1.KEYWORD LIKE ?)) GROUP BY PROD.PRODUCT_ID) TEMP_NAME (ERROR: aggregate function calls may not be nested) cause - Exception: org.postgresql.util.PSQLException Message: ERROR: aggregate function calls may not be nested stack trace --- org.postgresql.util.PSQLException: ERROR: aggregate function calls may not be nested org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:386) org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericD
doubt in popup position setting by using popup.js
Hello All, I am trying to use popup.js for rederning popup. but popup are rendered on its default position, I want to changed its position please suggest me how can I set custom position of popup by using popup.js for rendering popup I am using following code new Popup('popupBox','popupLink', {modal: true, position: '', trigger: 'click'}) I tried to understand popup.js code but unable to get following Regular Expression that used in condition if (mo = this.options.position.match(/^\s*([^\s,]+)\s*,\s*([^\s,]+)\s*$/)) { it used in get_popup_position() function of popup class. Thanks in Advance Thanks & Regards -- Rohit Jain
Re: Error in purgeOldJobs service.
Hi Scott, Thanks so much for the help. The ServiceSemaphore table had indeed and old entry which was stopping the purgeoldjobs entry to start. I deleted the entry and then the puroldjobs service started normally. There is one more query though, the runtime data table is getting bloated, i think there should be some service to clean it which is probably not running. Can you give me some info on it or direct to right resources. Thanks Rohit Scott Gray-2 wrote: > > Hi Rohit, > > The purgeOldJobs service can only be run one at a time so the error > below just indicates that the queued service execution timed out while > waiting for the existing execution to complete. I can think of two > possible causes for this: > 1. Your JobSandbox table has for some reason grown to be > exceptionally large and the service is struggling to clear the old > records before the next scheduled service execution. Assuming the > service is actually making progress then you should be fine to just > keep it running. > 2. The ServiceSemaphore table which controls the semaphore flags has > a stale record for the purgeOldJobs service and is locking the service > even though it isn't being executed. I may be wrong but I think the > ServiceSemaphore table isn't properly cleared when OFBiz is restarted > meaning that any semaphore locks in place when OFBiz is stopped get > left behind and prevent those services from running after the > restart. Removing any ServiceSemaphore records for services that > aren't currently running should resolve the problem. > > Regards > Scott > > HotWax Media > http://www.hotwaxmedia.com > > On 30/12/2009, at 9:25 PM, rohit wrote: > >> >> Hi I upgraded to the latest SVN, and am getting the following error >> when >> running the purgeOldJobs service. I tried to look for more details >> in my log >> file but could find more than that mentioned below: >> >> Request scheduleService caused an error with the following message: >> Service dispatcher threw an exceptionService [purgeOldJobs] with >> wait >> semaphore exceeded wait timeout, waited [307.608], wait started at >> 2009-12-30 02:47:04.374 >> >> >> The problem probably is with my database, as the service is working >> fine on >> a new build with seed data, but not when old data in imported in the >> currenct SVN. i am using postgres as the database. >> >> any help will be sincerely appreciated. >> >> Thanks >> -- >> View this message in context: >> http://n4.nabble.com/Error-in-purgeOldJobs-service-tp990793p990793.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. > > > > -- View this message in context: http://n4.nabble.com/Error-in-purgeOldJobs-service-tp990793p997628.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Error in purgeOldJobs service.
Hi I upgraded to the latest SVN, and am getting the following error when running the purgeOldJobs service. I tried to look for more details in my log file but could find more than that mentioned below: Request scheduleService caused an error with the following message: Service dispatcher threw an exceptionService [purgeOldJobs] with wait semaphore exceeded wait timeout, waited [307.608], wait started at 2009-12-30 02:47:04.374 The problem probably is with my database, as the service is working fine on a new build with seed data, but not when old data in imported in the currenct SVN. i am using postgres as the database. any help will be sincerely appreciated. Thanks -- View this message in context: http://n4.nabble.com/Error-in-purgeOldJobs-service-tp990793p990793.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: baseSecureUrl is returning a IP address instead of domain.
I am not sure i understand your mail correctly, can you please clarify. rohit --- On Fri, 12/25/09, BJ Freeman [via OFBiz] wrote: From: BJ Freeman [via OFBiz] Subject: Re: baseSecureUrl is returning a IP address instead of domain. To: "rohit" Date: Friday, December 25, 2009, 1:23 AM I think Rohit is use ver 4. he can implement the changes hans made. Jacques Le Roux sent the following on 12/24/2009 3:56 AM: > Thanks Rohit, > > Hopefully BJ, will have a look when he will get a chance > But I wonder now if it's not related to > https://issues.apache.org/jira/browse/OFBIZ-2657 and then no longer an > issue > > Jacques > > From: "rohit" <[hidden email]> >> >> Hi, >> >> The general.properties file in framework/common/config has the following: >> >> >> # -- The default domainname used in the notification emails links >> # as 'baseUrl' and 'baseSecureUrl' are set in the url.properties file. >> but there is no entry for them in the url.properties file. >> >> This could be perhaps the place where the problem lies. >> >> Thanks, >> >> Rohit >> >> >> Jacques Le Roux wrote: >>> >>> Hi BJ, >>> >>> Did you work it out ? >>> >>> Jacques >>> >>> From: "BJ Freeman" <[hidden email]> >>>> baseSecureUrl is used in a template for Subscription Verify Email in >>>> specialpurpose\ecommerce\widget\EmailContactListScreens.xml >>>> >>> value="${baseSecureUrl}/ecommerce/control/"/> >>>> >>>> so the email URL shows an IP instead of the domain name. >>>> still digging through code to find if this is changable. >>>> any help appreciated. >>>> >>>> >>>> >>>> -- >>>> BJ Freeman >>>> http://www.businessesnetwork.com/automation >>>> http://bjfreeman.elance.com >>>> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >>>> >>>> Systems Integrator. >>>> >>> >>> >>> >> >> -- >> View this message in context: >> http://n4.nabble.com/baseSecureUrl-is-returning-a-IP-address-instead-of-domain-tp160778p976064.html >> >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> > > View message @ http://n4.nabble.com/baseSecureUrl-is-returning-a-IP-address-instead-of-domain-tp160778p978588.html To unsubscribe from Re: baseSecureUrl is returning a IP address instead of domain., click here. -- View this message in context: http://n4.nabble.com/baseSecureUrl-is-returning-a-IP-address-instead-of-domain-tp160778p978663.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: baseSecureUrl is returning a IP address instead of domain.
Hi, The general.properties file in framework/common/config has the following: # -- The default domainname used in the notification emails links # as 'baseUrl' and 'baseSecureUrl' are set in the url.properties file. but there is no entry for them in the url.properties file. This could be perhaps the place where the problem lies. Thanks, Rohit Jacques Le Roux wrote: > > Hi BJ, > > Did you work it out ? > > Jacques > > From: "BJ Freeman" >> baseSecureUrl is used in a template for Subscription Verify Email in >> specialpurpose\ecommerce\widget\EmailContactListScreens.xml >>> value="${baseSecureUrl}/ecommerce/control/"/> >> >> so the email URL shows an IP instead of the domain name. >> still digging through code to find if this is changable. >> any help appreciated. >> >> >> >> -- >> BJ Freeman >> http://www.businessesnetwork.com/automation >> http://bjfreeman.elance.com >> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >> Systems Integrator. >> > > > -- View this message in context: http://n4.nabble.com/baseSecureUrl-is-returning-a-IP-address-instead-of-domain-tp160778p976064.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Error in product attributes page.
Hi, There seems to be an error in the product attribute page. The 'Add Product Attribute' has a drop down list for attribute name. if the product does not already have a existing product, its not possible to add a new attribute, since the attribute field is a required field but which is blank. If others find the same problem I will open a Jira issue for it. The error can be seen in the latest SVN. Thanks Rohit -- View this message in context: http://n4.nabble.com/Error-in-product-attributes-page-tp887930p887930.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: How to do Ofbiz Database Maintenance.
Hi Jacques, I am currently using the svn 884373. I had updated a few days hoping something may work but it did not. Prior to it i was using the SVN of something around 79000, when i had the same problem. Rohit Jacques Le Roux wrote: > > Which Release.revision are you using ? > > Jacques > > From: "rohit" >> Hi, >> >> I am using Postgres database with my ofbiz installation on linux. >> Recently i >> started getting database problems with ofbiz. >> >> Firstly, i see that more than a few database connections are made by >> ofbiz. >> Earlier, there were 3 - 4 running processes showing the database >> connection, >> but now i have more than 20 connections from ofbiz to the postsgres >> database. Most of the connections are in idle state, but they occupy a >> lot >> of memory and have terribly slowed ofbiz. >> >> Secondly, the database size is increasing much faster than the actual >> data. >> For eg. when i export the data as SQL file, the file size is 800 MB, >> however the database folder, folder that contains the files for the >> database, is more than 25 GB. >> >> I am quiet at a loss regarding the problem. Is there a problem with ofbiz >> or >> is it the problem with the database. >> >> I will appreciate if someone, can throw some more light on it. >> >> Thanks >> >> Rohit >> >> >> -- >> View this message in context: >> http://n4.nabble.com/How-to-do-Ofbiz-Database-Maintenance-tp788517p788517.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> > > > -- View this message in context: http://n4.nabble.com/How-to-do-Ofbiz-Database-Maintenance-tp788517p788750.html Sent from the OFBiz - User mailing list archive at Nabble.com.
How to do Ofbiz Database Maintenance.
Hi, I am using Postgres database with my ofbiz installation on linux. Recently i started getting database problems with ofbiz. Firstly, i see that more than a few database connections are made by ofbiz. Earlier, there were 3 - 4 running processes showing the database connection, but now i have more than 20 connections from ofbiz to the postsgres database. Most of the connections are in idle state, but they occupy a lot of memory and have terribly slowed ofbiz. Secondly, the database size is increasing much faster than the actual data. For eg. when i export the data as SQL file, the file size is 800 MB, however the database folder, folder that contains the files for the database, is more than 25 GB. I am quiet at a loss regarding the problem. Is there a problem with ofbiz or is it the problem with the database. I will appreciate if someone, can throw some more light on it. Thanks Rohit -- View this message in context: http://n4.nabble.com/How-to-do-Ofbiz-Database-Maintenance-tp788517p788517.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Getting error in Data load
Hello All, My local ofbiz at revision no 814471 I have tried to load data by using command "ant clean-all;ant run-install", and getting following error in loading Data file. [java] 2009-09-14 10:03:57,265 (main) [ EntitySaxReader.java:257:INFO ] Transaction Timeout set to 2 hours (7200 seconds) [java] 2009-09-14 10:03:57,366 (main) [ GenericDelegator.java:843:ERROR] [java] exception report -- [java] Failure in create operation for entity [DataResource]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:DataResource][createdStamp,2009-09-14 10:03:57.337(java.sql.Timestamp)][createdTxStamp,2009-09-14 10:03:57.264(java.sql.Timestamp)][dataResourceId,HELP_PARTY(java.lang.String)][dataResourceName,Party Overview(java.lang.String)][dataResourceTypeId,OFBIZ_FILE(java.lang.String)][dataTemplateTypeId,NONE(java.lang.String)][isPublic,Y(java.lang.String)][lastUpdatedStamp,2009-09-14 10:03:57.337(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-14 10:03:57.264(java.sql.Timestamp)][localeString,en(java.lang.String)][mimeTypeId,text/xml(java.lang.String)][objectInfo,applications/party/data/helpdata/HELP_PARTY.xml(java.lang.String)][statusId,CTNT_IN_PROGRESS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.DATA_RESOURCE (DATA_RESOURCE_ID, DATA_RESOURCE_TYPE_ID, DATA_TEMPLATE_TYPE_ID, DATA_CATEGORY_ID, DATA_SOURCE_ID, STATUS_ID, DATA_RESOURCE_NAME, LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, OBJECT_INFO, SURVEY_ID, SURVEY_RESPONSE_ID, RELATED_DETAIL_ID, IS_PUBLIC, 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) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'DATA_RESOURCE' caused a violation of foreign key constraint 'DTRSRC_STATUS' for key (CTNT_IN_PROGRESS). The statement has been rolled back.)). Rolling back transaction. [java] Exception: org.ofbiz.entity.GenericEntityException [java] Message: Error while inserting: [GenericEntity:DataResource][createdStamp,2009-09-14 10:03:57.337(java.sql.Timestamp)][createdTxStamp,2009-09-14 10:03:57.264(java.sql.Timestamp)][dataResourceId,HELP_PARTY(java.lang.String)][dataResourceName,Party Overview(java.lang.String)][dataResourceTypeId,OFBIZ_FILE(java.lang.String)][dataTemplateTypeId,NONE(java.lang.String)][isPublic,Y(java.lang.String)][lastUpdatedStamp,2009-09-14 10:03:57.337(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-14 10:03:57.264(java.sql.Timestamp)][localeString,en(java.lang.String)][mimeTypeId,text/xml(java.lang.String)][objectInfo,applications/party/data/helpdata/HELP_PARTY.xml(java.lang.String)][statusId,CTNT_IN_PROGRESS(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.DATA_RESOURCE (DATA_RESOURCE_ID, DATA_RESOURCE_TYPE_ID, DATA_TEMPLATE_TYPE_ID, DATA_CATEGORY_ID, DATA_SOURCE_ID, STATUS_ID, DATA_RESOURCE_NAME, LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, OBJECT_INFO, SURVEY_ID, SURVEY_RESPONSE_ID, RELATED_DETAIL_ID, IS_PUBLIC, 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) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'DATA_RESOURCE' caused a violation of foreign key constraint 'DTRSRC_STATUS' for key (CTNT_IN_PROGRESS). The statement has been rolled back.)) Is there any one who facing same problem. Thanks and regards Rohit Jain
Re: Chase Paymentech
they may be supporting, but i checked for cybersource and authorize.net only. Cybersource in not supported by chase, hence we signed up with authorize.net, it works pretty well. rohit --- On Mon, 7/6/09, Vince Clark wrote: From: Vince Clark Subject: Re: Chase Paymentech To: user@ofbiz.apache.org Cc: "Drew Mattke" Date: Monday, July 6, 2009, 10:19 PM Ah, I understand. So they are the merchant acct. part of the process, not the payment gateway. Any idea if they support other gw's besides Authorize.net? Vince Clark vcl...@globalera.com (303) 493-6723 - Original Message ----- From: "Rohit Sureka" To: user@ofbiz.apache.org Sent: Monday, July 6, 2009 10:42:09 AM GMT -07:00 US/Canada Mountain Subject: Re: Chase Paymentech hi, chase paymentech provides a internate merchant account and its not a gateway. Chase supports authorize.net, ofbiz supports authorize.net, thus when u sign up with chase ask them you would like to have the authorize.net gateway. they also have the orbital gateway, but ofbiz does not support that. Rohit --- On Mon, 7/6/09, Vince Clark wrote: From: Vince Clark Subject: Chase Paymentech To: "user" Date: Monday, July 6, 2009, 10:07 PM Has anyone integrated with this payment processor? Any info would be appreciated. Vince Clark vcl...@globalera.com (303) 493-6723
Re: Chase Paymentech
hi, chase paymentech provides a internate merchant account and its not a gateway. Chase supports authorize.net, ofbiz supports authorize.net, thus when u sign up with chase ask them you would like to have the authorize.net gateway. they also have the orbital gateway, but ofbiz does not support that. Rohit --- On Mon, 7/6/09, Vince Clark wrote: From: Vince Clark Subject: Chase Paymentech To: "user" Date: Monday, July 6, 2009, 10:07 PM Has anyone integrated with this payment processor? Any info would be appreciated. Vince Clark vcl...@globalera.com (303) 493-6723
Re: ofbiz and Ebay
i tested it on the live server itself. This is not recommended, but i found no alternatives at all. ebay's sandbox website did not help me all. For. eg. i wanted to create listing on sandbox.ebay.com using thier interface, but the site kept me logging out whenver i clicled the submit listing button. I hope you have a better experience. But I guess apart from the call which submits listing to ebay, you can safely test on live server, if you have access to, there is nothing to loose, ebay won't suspend your account :-) for technical errors on your server. Rohit --- On Wed, 7/1/09, Harry van Oosten wrote: From: Harry van Oosten Subject: Re: ofbiz and Ebay To: user@ofbiz.apache.org Date: Wednesday, July 1, 2009, 1:11 PM Rohit, thanks for you reply. If I switched to the production server don't I need a real sellers account? I don't hava a real store on ebay. This is just a test for a customer so i can't use there account.. and I can't create fake orders on ebay prodcution can I? And I also need to get the export to eBay to work otherwise they still have to put stuff manually on Ebay and change the stock in ofbiz. This tests are to see if Ofbiz is right for the job. In the futher they also want to be notified on a sale from Ebay for example. How did you test your integration? Kind regards, Harry On Wed, Jul 1, 2009 at 6:45 AM, Rohit Sureka wrote: > Hi Harry, > > I use the ebay application to import orders from ebay and it does work pretty > OK. Firstly, my experience with ebay sandbox, has been bad, i personally > don't think its reliable at all and behaves randomly to API requests. For > e.g. if you had order on ebay sandbox nothing would be imported, and when you > changed to live server, the api worked fine. > > The existing ebay code requires some updates, for eg. the ebay code assumes > order ID would be returned but they are not in the getorders request, which > has a time range defined to it. > > I would suggest you try the code on live server. Its not the recommended way, > but i could it working like on live server only. Secondly, i don;t think the > export items to ebay, is a complete feature set, I tried it once, but did not > work for me. You may however import orders from ebay items, which have been > created using the ebay interface. > > Rohit > > > --- On Tue, 6/30/09, Harry van Oosten wrote: > > From: Harry van Oosten > Subject: ofbiz and Ebay > To: user@ofbiz.apache.org > Date: Tuesday, June 30, 2009, 11:32 PM > > Hi all, > > I'm new to Ofbiz and i'm trying to export products to ebay. > > I got keys from Ebay and filled the in the ebayExport.properties. But > when i export some product it seems nothing happens.. I'm nog getting > any output from the export and the console log says the following: > > 2009-06-30 16:09:11,044 (http-0.0.0.0-8443-2) [ > ControlServlet.java:130:INFO ] [[[ProductsExportToEbay] Request Begun, > encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] > 2009-06-30 16:09:11,054 (http-0.0.0.0-8443-2) [ > RequestHandler.java:697:INFO ] Rendering View [ProductsExportToEbay], > sessionId=A08D55B0B02A256468B4530B4B26F488.jvm1 > 2009-06-30 16:09:12,686 (http-0.0.0.0-8443-2) [ > ServiceDispatcher.java:584:INFO ] Sync service > [ebay/getEbayCategories] finished in [1535] milliseconds > 2009-06-30 16:09:12,763 (http-0.0.0.0-8443-2) [ > ScreenFactory.java:129:INFO ] Got 22 screens in 0.053s from: > file:/C:/Tools/Dev/Apache%20ofbiz/ofbiz-release9.04/framework/common/widget/CommonScreens.xml > 2009-06-30 16:09:13,134 (http-0.0.0.0-8443-2) [ > UtilProperties.java:870:INFO ] ResourceBundle CommonEntityLabels (en) > created in 0.199s with 1399 properties > 2009-06-30 16:09:13,186 (http-0.0.0.0-8443-2) [ > ControlServlet.java:299:INFO ] [[[ProductsExportToEbay] Request Done- > total:2.141,since last([ProductsExportTo...):2.141]] > > It seams the request begun and ended.. > > But i can't find the product in the sandbox from ebay. > > > Someone did this before? > > The thing i want to do is: > > - export product(s) to Ebay. > - Do a sell on ebay. > - import the order into ofbiz. > > I can't find anything regarding this except a wiki with says what to > set in the property file. > > Can somebody help me along the way.. Maybe there's something wrong > with my ebay developers account? > > Kind regards, > > Harry >
Re: ofbiz and Ebay
Hi Harry, I use the ebay application to import orders from ebay and it does work pretty OK. Firstly, my experience with ebay sandbox, has been bad, i personally don't think its reliable at all and behaves randomly to API requests. For e.g. if you had order on ebay sandbox nothing would be imported, and when you changed to live server, the api worked fine. The existing ebay code requires some updates, for eg. the ebay code assumes order ID would be returned but they are not in the getorders request, which has a time range defined to it. I would suggest you try the code on live server. Its not the recommended way, but i could it working like on live server only. Secondly, i don;t think the export items to ebay, is a complete feature set, I tried it once, but did not work for me. You may however import orders from ebay items, which have been created using the ebay interface. Rohit --- On Tue, 6/30/09, Harry van Oosten wrote: From: Harry van Oosten Subject: ofbiz and Ebay To: user@ofbiz.apache.org Date: Tuesday, June 30, 2009, 11:32 PM Hi all, I'm new to Ofbiz and i'm trying to export products to ebay. I got keys from Ebay and filled the in the ebayExport.properties. But when i export some product it seems nothing happens.. I'm nog getting any output from the export and the console log says the following: 2009-06-30 16:09:11,044 (http-0.0.0.0-8443-2) [ ControlServlet.java:130:INFO ] [[[ProductsExportToEbay] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2009-06-30 16:09:11,054 (http-0.0.0.0-8443-2) [ RequestHandler.java:697:INFO ] Rendering View [ProductsExportToEbay], sessionId=A08D55B0B02A256468B4530B4B26F488.jvm1 2009-06-30 16:09:12,686 (http-0.0.0.0-8443-2) [ ServiceDispatcher.java:584:INFO ] Sync service [ebay/getEbayCategories] finished in [1535] milliseconds 2009-06-30 16:09:12,763 (http-0.0.0.0-8443-2) [ ScreenFactory.java:129:INFO ] Got 22 screens in 0.053s from: file:/C:/Tools/Dev/Apache%20ofbiz/ofbiz-release9.04/framework/common/widget/CommonScreens.xml 2009-06-30 16:09:13,134 (http-0.0.0.0-8443-2) [ UtilProperties.java:870:INFO ] ResourceBundle CommonEntityLabels (en) created in 0.199s with 1399 properties 2009-06-30 16:09:13,186 (http-0.0.0.0-8443-2) [ ControlServlet.java:299:INFO ] [[[ProductsExportToEbay] Request Done- total:2.141,since last([ProductsExportTo...):2.141]] It seams the request begun and ended.. But i can't find the product in the sandbox from ebay. Someone did this before? The thing i want to do is: - export product(s) to Ebay. - Do a sell on ebay. - import the order into ofbiz. I can't find anything regarding this except a wiki with says what to set in the property file. Can somebody help me along the way.. Maybe there's something wrong with my ebay developers account? Kind regards, Harry
Re: Authorize.net certificate error - SOLVED
Yes, it did work for me as well. As regards the property file, the password field is not required. Its a security issue and it should be removed. Authorize.net's transaction key and login will serve the purpse for authentication. rohit --- On Tue, 6/30/09, Kumaraswamy nandipati wrote: From: Kumaraswamy nandipati Subject: Re: Authorize.net certificate error - SOLVED To: user@ofbiz.apache.org Date: Tuesday, June 30, 2009, 4:03 PM Hi rohit., When I make implementation for my ofbiz store earlier,(For live mode) 1.P )I added secure.authorize.net certificate into /usr/lib/jvm/java-6-sun/jre/lib/security/cacerts using the following command add certificate: sudo keytool -import -alias AUTHORIZE_NET -keystore cacerts -trustcacerts -file secure.autorize.net.cer (I made certificate dump from https://secure.authorize.net) 2.P) in payment.properties, make sure that *payment.authorizedotnet.url*=payment.authorizedotnet.url= https://secure.authorize.net/gateway/transact.dll *payment.authorizedotnet.version*=3.1 *payment.authorizedotnet.trankey*=your transactionkey from authorize.net( secure.authorize.net) *payment.authorizedotnet.password*=your transactionkey from authorize.net( secure.authorize.net) *payment.authorizedotnet.login*=valid merchant id (secure.authorize.net). 3.P) make sure that product store level capture, authorize service call changes are done. Thats it. It worked for me. On Fri, Jun 19, 2009 at 5:35 PM, Raj Saini wrote: > Hi Rohit, > > Although, I never worked Authorize.net specific certificates, however, I > resolved similar problem by importing the certificates in the JDK ca > certificate store. This may be a problem related to missing Intermediate > certificate of the certificate chains. Also make sure the you are using the > same JDK, where you imported your certificates. > > If nothing works, I would debug the communication between client and server > using some network sniffer (or a some kind of http proxy which can show you > the http headers). > > Thanks, > > Raj > > > rohit2006 wrote: > >> Hi, >> >> I am getting the same problems. The logs reads as: >> >> 2009-06-19 04:35:30,143 (TP-Processor20) [ >> AIMPaymentServices.java:326:INFO >> ] Could not complete Authorize.Net transaction: >> org.ofbiz.base.util.HttpClientException: IO Error processing request >> (java.security.cert.CertificateException: No trusted certificate found) >> I have imported the SSL into both ofbizssl.jks and ofbiztrust.jks ( i >> don't >> it is required anymore) but with no success. >> >> I also imported the certificate into JDK keystore, at >> /usr/java/jdk1.6.0_11/jre/lib/security, but this do not help either. >> >> I am at a complete loss as, what the problem my be. If anyone can help >> identify the issue i will appreciate it. >> >> Thanks, >> >> Rohit >> >> >> Ritesh Trivedi wrote: >> >> >>> Added >>> >>> >>> http://docs.ofbiz.org/display/OFBIZ/How+to+configure+authorize.net+certificates >>> >>> >>> BJ Freeman wrote: >>> >>> >>>> better yet >>>> >>>> http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo >>>> >>>> >>>> Ritesh Trivedi sent the following on 7/25/2008 10:22 AM: >>>> >>>> >>>>> Thanks Raj and BJ for responses. >>>>> >>>>> After couple of hours of debugging, I was able to get pass the issue. >>>>> >>>>> For the completion of the thread - I had to import authorize.net >>>>> certificates into the default JDK keystore - even though in tomcat the >>>>> setting was to use ofbiz keystore for https - not sure why. >>>>> >>>>> Also keep in mind that authorize.net has different set of certificates >>>>> for >>>>> test and production site. if you are hitting >>>>> https://test.authorize.net >>>>> vs. >>>>> https://secure.authorize.net. For those who dont know how to get >>>>> authorize.net certificates, just go to the URLs and export the >>>>> certificates >>>>> to file and import then into the keystore. So you dont need your >>>>> website >>>>> certificates signed by CA but you need authorize.net (or the url you >>>>> are >>>>> connecting to - as trusted site) certificates added. >>>>> >>>>> >>>>> Raj Saini wrote: >>>>> >>>>> >>>>>> I don't know about Authorize.net b
Re: Callback URL is not accepting response string in Google Checkout
Hi Ashish, I have uploaded a merchant calculation file for doing the shipping cost. The file, handles XML string from google and responds with the shipping costs. I have the basic structure ready, ie., send the cart to google, calculate shipping cost, receive order notification, log the order in ofbiz, charge the customers card, cancel, refund and archieve order. What really needs to be done with my code is, cleanup, make it to confirm to ofbiz standards and do some coding to make sure that the accounting part is properly logged and reported in ofbiz. I will be happy to share the code with you, if you think you can work on it and give it back to the ofbiz community. Rohit --- On Tue, 5/26/09, Ashish Vijaywargiya wrote: From: Ashish Vijaywargiya Subject: Re: Callback URL is not accepting response string in Google Checkout To: user@ofbiz.apache.org Date: Tuesday, May 26, 2009, 12:33 PM Hello Rohit, Thanks for your reply. Its good to know that you have done Google Checkout Integration. Please see my comments inline: Rohit Sureka wrote: > Hi Aashish, > I have done a google checkout integration with ofbiz. i guess you are >sandbox for coding and testing. if you are using the sandbox, you do not need >the ssl on your server. using sandbox you can make calls to https as well as >http, just make the changes in google checkout setting on google. > Yes I was testing things on Sandbox. I agree from you that on sandbox you can make calls to https as well as https. The only problem that we are facing is: We are unable to process parameters coming from google in the CallBack URL. Although we are getting control on the request specified in the callback URL but unable to parse XML string associated with Callback URL. We are in the process to figure out this issue will update on this when we will be done from this. Rohit, were you able to get XML string on the call back URL on the http port ? > Can you tell me what degree of integration you are trying to achive. i mean > are you looking at just passing the cart to google, or you are looking for > complete order/payment processing and tracking. > Please see my comments on the OFBIZ-2521. > i have partially achieved the order and payment processing however a lot of >work needs to be done. > https://issues.apache.org/jira/browse/OFBIZ-2521 Please let us know the outstanding things that you have planned to implement. May be we can collaborate to get some good results. > If you plan to put your work on ofbiz for everyone's use, then i can share >my code with you. > I will put all the code in OFBiz. The reason is that I always consider that the code written by me may have some big issues and that can be addressed by sharing code with the community. If you like you can share your code at https://issues.apache.org/jira/browse/OFBIZ-2521 > For the SSL part, i am using apache proxy pass, the SSL is configured in >apache and google make call to a https URL, which is forwarded by apache to >ofbiz. > Thanks for the info. > Rohit >
Re: Callback URL is not accepting response string in Google Checkout
Hi Aashish, I have done a google checkout integration with ofbiz. i guess you are sandbox for coding and testing. if you are using the sandbox, you do not need the ssl on your server. using sandbox you can make calls to https as well as http, just make the changes in google checkout setting on google. Can you tell me what degree of integration you are trying to achive. i mean are you looking at just passing the cart to google, or you are looking for complete order/payment processing and tracking. i have partially achieved the order and payment processing however a lot of work needs to be done. If you plan to put your work on ofbiz for everyone's use, then i can share my code with you. For the SSL part, i am using apache proxy pass, the SSL is configured in apache and google make call to a https URL, which is forwarded by apache to ofbiz. Rohit --- On Tue, 5/26/09, Ashish Vijaywargiya wrote: From: Ashish Vijaywargiya Subject: Re: Callback URL is not accepting response string in Google Checkout To: user@ofbiz.apache.org Date: Tuesday, May 26, 2009, 1:01 AM Hello Marco, Thanks for your reply. I haven't played with certificate thing so here are some questions from my side before diving into it. Do you know some handy & easy document to install SSL certificate easily on my server ? Thoughts on authorize.net ? http://docs.ofbiz.org/display/OFBIZ/How+to+configure+authorize.net+certificates I will start searching on this early in the morning tomorrow but some pointer to install certificate will be of great help. Is it ok to use thawte ssl certificate for in trial period(will purchase later on if everything work for us on production instance) ? Any preference ? Anyone tried to install OpenSSL in tomcat instance of OFBiz server ? -- Ashish mrisal...@libero.it wrote: Hi Ashish, I never tested the trick from Andreas Sterbenz's blog but I have tested GC notifications in the past and it was necessary an https URL for notification with a trusted and visible certificate into OFBiz. If you try to click on the question mark "Specify a URL for Google to notify you of new orders and changes in order state. You must provide the URL of a server running 128-bit SSLv3 or TLS. [?]" (http://checkout.google.com/support/sell/bin/answer.py?answer=57519&hl=en) into Setting --> Integration you can get more informations about it. Are you able to do a Google Checkout from OFBiz? Are you redirect correctly to their site ? Can you try to use an https URL and configure your request processGoogleCheckoutResponse into Ecommerce controller.xml in this way : Thanks Marco Hello Marco, Thanks for your comments. Please see my comments inline: mrisal...@libero.it wrote: Hi Ashish, if you want to use Google Checkout API callback is necessary to install a trused certificate and then URL must be in https and not http (API callback URL on Setting --> Integration). Yes I agree from you but if my call back URL is http specific then should I also need to install the trusted certificate ? FYI I have installed the certificate by the steps shown in the document: http://docs.ofbiz.org/display/OFBIZ/Google+Checkout+Integration Isn't the certificate downloaded from sandbox.google.com trusted certificate ? Anyway if you see that Google Checkout does not reach your OFBiz URL you can check the logs under Tools --> Integration Console. Yes I have seen Integration Console too. But that is not generating any message, if I provide the URL something like specified in my last email. I can share you few bug details: We encountered an error trying to access your server at http://xxx.xxx.xxx.xxx:8080/ecommerce123/control/ <https://sandbox.google.com/checkout/sell/settings?userToken=1243251863134+j66kJeIclVm65f5ASdSKBIWPtqY%3D§ion=IntegrationConsole&returnURL=https%3A%2F%2Fsandbox.google.com%2Fcheckout%2Fsell%2Fsettings%3FuserToken%3D1243251863134%2Bj66kJeIclVm65f5ASdSKBIWPtqY%253D%26section%3DIntegrationConsole&serialNumber=959222106323078-6-1>processGoogleCheckoutResponse123 -- the error we got is Send failed with code: 400. Response body was: <https://sandbox.google.com/checkout/sell/settings?userToken=1243251863134+j66kJeIclVm65f5ASdSKBIWPtqY%3D§ion=IntegrationConsole&returnURL=https%3A%2F%2Fsandbox.google.com%2Fcheckout%2Fsell%2Fsettings%3FuserToken%3D1243251863134%2Bj66kJeIclVm65f5ASdSKBIWPtqY%253D%26section%3DIntegrationConsole&serialNumber=959222106323078-6-1> This message comes when I provide wrong server details. See "ecommerce123/control/processGoogleCheckoutResponse123 But when I provide right server details like the URL shown below then it don't generate any message on Integration Console. http://xxx.xxx.xxx.xxx:8080/ecommerce/control/processGoogleCheckoutResponse -- Ashish Hoping it can helps you. Thanks Marco
Re: order shipped email
i am sure if there is any particular email sent with order shipped status. you might want to check the 'Order completed' email. this email is sent when inventory is allocated in order processing and the when the order status is changed to completed from created/approved. rohit - Original Message From: Hansen Wang <[EMAIL PROTECTED]> To: user@ofbiz.apache.org; Jacques Le Roux <[EMAIL PROTECTED]> Sent: Monday, March 17, 2008 5:59:33 PM Subject: Re: order shipped email I have been to these places. But could not find an "order shipped" email type. I have searched the java and xml files but could not locate any information about this. Does ofbiz send out an "order shipped" email once a package is shipped? Regards, Hansen On 3/17/08, Jacques Le Roux <[EMAIL PROTECTED]> wrote: > > It's set there > https://demo.hotwaxmedia.com/catalog/control/EditProductStoreEmails?productStoreId=9000 > > Jacques > > From: "Hansen Wang" <[EMAIL PROTECTED]> > > Hi, > > > > I have been going through the admin webapps looking for places where a > > shipping notification email is sent. But I was not able to find that. Is > > such function supported out of box from the admin webapps? > > > > Thanks, > > Hansen > > > Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
Re: Unable to create a user account.
thanks for the mail Vikas. I was able to get it sorted out myself. I had changed the permission for the user 'system', which is the default user when ofbiz tries to create a new party. once i updated it, it was working fine as normal. Rohit - Original Message From: Vikas Mayur <[EMAIL PROTECTED]> To: user@ofbiz.apache.org Sent: Friday, March 14, 2008 4:18:11 AM Subject: Re: Unable to create a user account. On Thu, Mar 13, 2008 at 11:14 PM, rohit2006 <[EMAIL PROTECTED]> wrote: > > Hi, > > i need some help with security/permissions in ofbiz. I had edited few of > security settings in ofbiz due to which i am no longer able to create new > user accounts using 'ecommerce' application. > > When i try to create a new account using 'ecommerce' application, i am > getting the following error: > " > Party with specified party ID exists and you do not have permission to > create a user login with this party ID. calling service createUserLogin in > createPersonAndUserLogin calling service createPersonAndUserLogin in > createCustomer > " I encountered a similar problem while working on a custom applications that creates a customer, but I am not sure about it, but it works by clearing the browser cache. > > Currently i cannot do ant run-install, because i want to retain customer > data and run-install may replace the entire database with new data. > Thats not true. You only loose your data if you explicitly drop your database or run ant clean-all in case of derby. Vikas > i will sincerely appriate if someone can suggest ways to tackle this > issue. > > Thanks, > > Rohit > -- > View this message in context: > http://www.nabble.com/Unable-to-create-a-user-account.-tp16033327p16033327.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > > Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
Re: FedEx and Thermal Labels
hi Scott, i have good new for you, i was able to get it configured and working albiet with one minor glitch. The process is very simplem i did it as follows: 1)remove the ZEBRA 2844 driver from the machine, it should not be used if u want to send raw data to the printer. 2)add a new printer on the machine, it should be the Generic/text printer with the generic/text driver available in windows by default. Be sure sure that you get the port right (i am using the USB 2 port) 3)open a new notpad file and hit the 'enter' button, then type U and hit the 'enter' button again. 4)now go to file and click on page setup and then put '0' for all margins, ie. top, bottom, left and right. It will not work if you have anything more than that in it. 5)now print the file through the generic printer. 6)you should see something print from the LP 2844 printer, if it does then your printer has been setup properly. 7)you need to modify the FedEx FDSshiprequest templete in ofbiz, use 'ELTRON' as image type instead of 'ZEBRA'. i really funny that a fortune 500 co has nerd programmer in it, thats what the a guy told me and seems to be true. The LP2844 printer supports data in EPL format, whereas if we request the data as 'ZEBRA' which seems logical from fedex doc., returns the data in 'ZPL' format which the ZEBRA LP2844 does not support and hence does nothing. 8) now process a shipment through ofbiz, and click on the view label link, where you will see some printer commands. 9)paste this code into a notpad (be sure you have hit the 'enter' button both at the begging and at the end of the code, this is called feed data and is required) and print it like in step 5, and you should have the label with you. What i have not been able to do as yet is send the data, directly from the browser to the printer, if someone can help on that it will be really great. Let me know if it works for you. Rohit - Original Message From: Scott. <[EMAIL PROTECTED]> To: user@ofbiz.apache.org Sent: Friday, January 4, 2008 1:41:35 PM Subject: Re: FedEx and Thermal Labels No luck as yet. We've got communication with FedEx test servers and we are able to get a png but not for the thermal. We will probably dedicate someone to it in the next month and I'll be happy to share if we get a progress. rohit2006 wrote: > > Hi Scott, > > Did you have any luck on below issue, if yes then please so share it. > > I am having similar issue, and the fedex support team says if probably > requires some coding to save the commands in a file which is then sent to > the thermal printer. > > Rohit > > > Scott. wrote: >> >> I've posted this message once before but didn't receive any replies so I >> thought I would give it another go. >> >> Is anyone using OFBiz to ship via FedEx. If so, are you using the thermal >> labels on an LP2844? I'd really appreciate some input on this if >> possible. We need to set it up on our LAN to allow users to print FedEx >> labels directly to the shipping department. We have this currently >> working on a php product where we actually make use of a UPS Active X >> control but we are hoping that this is built into OFBiz somehow. >> >> Thanks in advance. >> > > -- View this message in context: http://www.nabble.com/FedEx-and-Thermal-Labels-tp13162327p14622476.html Sent from the OFBiz - User mailing list archive at Nabble.com. Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
Re: http://www.1800flowers.com/
Hi, Do you have any idea, if we can do something like this in ofbiz. Rohit - Original Message From: Jonathon -- Improov <[EMAIL PROTECTED]> To: user@ofbiz.apache.org Sent: Sunday, December 23, 2007 5:48:17 PM Subject: Re: http://www.1800flowers.com/ Yes, that is possible. Jonathon Brendan Vogt wrote: > I think they put restrictions on the site as to what country may or may not > access it. All sites work from my PC, except this one. > > > > -Original Message- > From: guo weizhan [mailto:[EMAIL PROTECTED] > Sent: Sunday, December 23, 2007 8:34 AM > To: user@ofbiz.apache.org > Subject: Re: http://www.1800flowers.com/ > > The site can't be accessed from China :) > > 2007/12/23, Ashish Vijaywargiya <[EMAIL PROTECTED]>: >> Brendan, >> >> We will not reach towards our target if you will forget about this :-) >> It looks like firewall problem that you may need to figure out. >> >> >> On Dec 22, 2007 11:41 PM, Brendan Vogt <[EMAIL PROTECTED]> wrote: >> >>> Nope, I'm just going to forget about it. >>> >>> >>> >>> -Original Message- >>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >>> Sent: Saturday, December 22, 2007 7:58 PM >>> To: user@ofbiz.apache.org >>> Subject: RE: http://www.1800flowers.com/ >>> >>> Try >>> >>> http://ww12.1800flowers.com/ >>> >>> >>> -Original Message- >>> From: Brendan Vogt [mailto:[EMAIL PROTECTED] >>> Sent: Saturday, December 22, 2007 4:57 AM >>> To: user@ofbiz.apache.org; 'Jacques Le Roux' >>> Subject: RE: http://www.1800flowers.com/ >>> >>> >>> That's weird!!! I'm not the only one in SA that can't access it. >>> >>> >>> -Original Message- >>> From: Jacques Le Roux [mailto:[EMAIL PROTECTED] >>> Sent: Saturday, December 22, 2007 2:53 PM >>> To: user@ofbiz.apache.org >>> Subject: Re: http://www.1800flowers.com/ >>> >>> No access problem at all >>> >>> Jacques >>> >>> From: "Brendan Vogt" <[EMAIL PROTECTED]> >>>> Hi, >>>> >>>> >>>> >>>> I'm from South Africa and the following site been around for some >> time, >>> but >>>> I can't access it at all. It's on the OFBiz users list. Maybe they >>> block >>>> South African access? >>>> >>>> >>>> >>>> http://www.1800flowers.com/ >>>> >>>> >>>> >>>> Can any one else not access this site? >>>> >>>> >>>> >>>> Brendan >>>> >>>> >>> >>> No virus found in this incoming message. >>> Checked by AVG Free Edition. >>> Version: 7.5.516 / Virus Database: 269.17.6/1193 - Release Date: >>> 12/22/2007 >>> 2:02 PM >>> >>> No virus found in this outgoing message. >>> Checked by AVG Free Edition. >>> Version: 7.5.516 / Virus Database: 269.17.6/1193 - Release Date: >>> 12/22/2007 >>> 2:02 PM >>> >>> >> >> -- >> Thanks & Regards >> Ashish Vijaywargiya >> +919893479711 >> > > Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs
Re: what is [storeIncomingEmail.messageWrapper]?
Thanks for the email and i am sorry if i did not put my question properly. My real problem is configuring the service to sort emails. I have put the MCA rules in place but i am not able to configure the "sortincomingemail' service. I understand that "sortincomingemail" has to be run at regular interval to process the email sorting. Rohit BJ Freeman <[EMAIL PROTECTED]> wrote: My previous response was aimed at sorting the communication events after they have been already loaded. to answer your question, Yes ofbiz will try to match any email to and from with those in the parties. if it can not find one of the parties, usually the from, it puts the address in comments, an marks it unknown email address. The MCA is used to filter the emails. Like: link tracking number to order--> value="[EMAIL PROTECTED]"/> in the above I am rerouting the Quantum emails to a process I wrote to input the shipping tracking number into an order. If this is what you were meaning by sort then this is the mechanism to to this. you can find /framework/common/servicedef/smca_test.xml rohit2006 sent the following on 4/19/2007 10:03 PM: > i am trying to configure email sorting in ofbiz. I have followed the > documentation by Si Chen, to test it. I am assuming that if email sorting is > correctly configured, emails will be recorded as communication event for the > related parties. For eg. after a email is received ofbiz, will try to match > the "to" address, with the email associated to a party, and if a match is > found, a communication event will be logged for the party. > > I hope that i got this right? > > I have followed the instruction as mentioned in documentation, and > everything loads fine, but when i schedule the service storeincomingemail, i > am prompted to enter the service parameter(messageWrapper > (org.ofbiz.service.mail.MimeMessageWrapper), which i have no clue about. i > guess this is to do something 'MimeMessageWrapper'. > > The documentation by Si Chen mentions this: > > 5. MCA services need to implement the mail processing interface, as in: > > It uses a MimeMessageWrapper: > MimeMessageWrapper wrapper = (MimeMessageWrapper) > context.get("messageWrapper"); > MimeMessage message = wrapper.getMessage(); > with methods like message.getAllRecipients(), message.getFrom(), > message.getSubject(), getAllRecipients(), getSentDate(), getReceivedDate(), > etc. > > Currently (20060607) there is a service called âstoreIncomingEmailâ which > could be used to do inbound mail sorting. This has not been fully tested > yet. > > > I am not sure what to insert in the service parameters. > > Do we need to create a view for email sorting, cause i think the mails will > be visible, under the communication tab, in party manager? > > Rohit > > > > BJ Freeman wrote: >> If I understand you, you can create a view with the sorting you want. >> >> rohit2006 sent the following on 4/19/2007 4:33 AM: >>> Hi, >>> >>> I am trying configure email sorting in ofbiz and store emails as >>> communication events. I believe i have to schedule the service >>> storeIncomingEmail as a service. I tried to do that and was prompted fill >>> the fields: >>> >>> Step 2: Service Parameters >>> messageWrapper (org.ofbiz.service.mail.MimeMessageWrapper). >>> >>> I am not sure what to enter into this field, can someone please help me >>> configure this. I am getting the following error in log when the service >>> is >>> run >>> >>> 2007-04-19 05:22:31,302 (default-invoker-Thread-2) [ >>> JobInvoker.java:211:INFO ] Invoker: default-invoker-Thread-2 received job >>> -- >>> 1176985293330 from poller - [EMAIL PROTECTED] >>> 2007-04-19 05:22:31,320 (default-invoker-Thread-2) >>> [PersistedServiceJob.java:136:INFO ] >>> [EMAIL PROTECTED] -- Next runtime: >>> -1 >>> [Error] :2:12: cvc-elt.1: Cannot find the declaration of element >>> 'ofbiz-ser'. >>> 2007-04-19 05:22:31,331 (default-invoker-Thread-2) [ >>> UtilXml.java:243:DEBUG] XML Read 0.0040s: Internal Content >>> 2007-04-19 05:22:31,332 (default-invoker-Thread-2) [ >>> ServiceDispatcher.java:322:ERROR] >>> exception report >>> -- >>> Incoming context (in runSync : storeIncomingEmail) does not match >>> expected >>> requirements >>> Exception: org.ofbiz.service.ServiceValidationExceptio