RE: Add Product Supplier broken - similar to Edit Facility bug
Based on my reading of the comments in arithmetic.properties, it only controls the display (rounding/format) of decimals, not the actual underlying database field. In most cases, the related database fields only have 3 (or less) decimal places, so you cannot store a value out to 5 decimal places, to round from. What controls the creation of the fields? Is there/can there be a properties file that lets you set the precision/scale of the decimal type fields? Examples: PRODUCT_PRICE.PRICE = decimal(18,3) QUOTE_ITEM.QUOTE_UNIT_PRICE = decimal(18,2) INVOICE_ITEM.AMOUNT = decimal(18,3) FIN_ACCOUNT_TRANS.AMOUNT = decimal(18,2) ACCTG_TRANS_ENTRY.AMOUNT = decimal(18,2) ORDER_ITEM.UNIT_PRICE = decimal(18,3) ORDER_ITEM.UNIT_AVERAGE_COST = decimal(18,2) REQUIREMENT_BUDGET_ALLOCATION.AMOUNT = decimal(18,2) SUPPLIER_PRODUCT.LAST_PRICE = decimal(18,3) SUPPLIER_PRODUCT.SHIPPING_PRICE = decimal(18,3) I can't easily identify what tables hold bill of materials and routings, but my guess is, I would see similar issues there. It is not every cost or price field though, which to me is a baffling inconsistency. For example, COST_COMPONENT.COST is decimal(18,6), which would be fine. Thanks, Tim -Original Message- From: Paul Foxworthy [mailto:p...@cohsoft.com.au] Sent: Wednesday, January 3, 2018 8:47 PM To: user@ofbiz.apache.org Subject: Re: Add Product Supplier broken - similar to Edit Facility bug Hi again, I've changed my mind about a Jira for the moment. I think this is not exactly the same thing as OFBIZ-6436. We could create a new issue in future, but I'd like to consider this some more. I see the general point that there's a need for more decimal places in prices. OFBiz has configuration options for decimal places in orders, invoices, indirect taxes, financial accounts and general ledger reports. (All of these are in https://github.com/apache/ofbiz/blob/trunk/applications/ accounting/config/arithmetic.properties <https://github.com/apache/ofbiz/blob/trunk/applications/accounting/config/arithmetic.properties#L24> ). Here are questions I'd like Tim and everyone to consider: - Is a rule for product price DPs a separate thing to rules for other amounts specified in arithmetic.properties? I think the answer is "yes". - Should OFBiz just accept a price to whatever level of precision a user wants to enter it, and not round it? - Product pricing and the number of DPs might vary significantly for different products. Is there any need to enforce some sort of consistency here? - If enforcement is needed, is a single configuration option for product pricing sufficient? - If enforcement is needed, should it be more fine-grained than one rule for all products? Should the number of DPs be an attribute of some entity, perhaps ProductCategory or SupplierProduct? Cheers Paul Foxworthy On 4 January 2018 at 11:57, Paul Foxworthy <p...@cohsoft.com.au> wrote: > Thanks, that makes sense. > > Maybe further discussion should move to https://issues.apache.org/ > jira/browse/OFBIZ-6436 . I will put a comment there with your link to > the NCES standard. > > Cheers > > Paul Foxworthy > > P.S. I buy my gasxxx petrol in litres and one place suffices :-). > > > On 3 January 2018 at 23:20, Boyden, Timothy > <tboy...@electroswitch.com> > wrote: > >> Same reason your gas prices are quoted to 3 digits at the pump. Those >> extra cents amount to millions of dollars after millions of gallons >> or hundreds of thousands of component sales. It is also necessary in >> order to capture actual cost of products when using only a few of the >> components in a part, or like I said, grams of a precious metal >> coating on electrical connectors. Measurements to convert from grams >> to a purchase UM of ounces will almost always be a 5 digit decimal >> value. And you can bet those precious metal vendors count their hundreds and >> thousandths of ounces. >> Also, for the purposes of statistical analysis, which is used to >> analyze production quality, the US national standard is (at least) 4 >> decimal >> places: https://nces.ed.gov/statprog/2002/std5_3.asp >> >> -Tim >> >> >> -Original Message- >> From: Paul Foxworthy [mailto:p...@cohsoft.com.au] >> Sent: Tuesday, January 2, 2018 7:43 PM >> To: user@ofbiz.apache.org >> Subject: Re: Add Product Supplier broken - similar to Edit Facility >> bug >> >> Hi Tim, >> >> Thanks for your feedback. >> >> I am curious what you would use the unit price for. Do you order your >> washers in quantities of thousands, and might the price vary if you >> ordered in quantities like 10,000 or 100,000? So acquisition price >> might depend on quantity ordered. If you are calculating cost price &
RE: Add Product Supplier broken - similar to Edit Facility bug
Same reason your gas prices are quoted to 3 digits at the pump. Those extra cents amount to millions of dollars after millions of gallons or hundreds of thousands of component sales. It is also necessary in order to capture actual cost of products when using only a few of the components in a part, or like I said, grams of a precious metal coating on electrical connectors. Measurements to convert from grams to a purchase UM of ounces will almost always be a 5 digit decimal value. And you can bet those precious metal vendors count their hundreds and thousandths of ounces. Also, for the purposes of statistical analysis, which is used to analyze production quality, the US national standard is (at least) 4 decimal places: https://nces.ed.gov/statprog/2002/std5_3.asp -Tim -Original Message- From: Paul Foxworthy [mailto:p...@cohsoft.com.au] Sent: Tuesday, January 2, 2018 7:43 PM To: user@ofbiz.apache.org Subject: Re: Add Product Supplier broken - similar to Edit Facility bug Hi Tim, Thanks for your feedback. I am curious what you would use the unit price for. Do you order your washers in quantities of thousands, and might the price vary if you ordered in quantities like 10,000 or 100,000? So acquisition price might depend on quantity ordered. If you are calculating cost price for a manufactured product, the prices for washers might be imprecise but that's unlikely to be most significant contributor to the cost price. What am I missing? Thanks Paul Foxworthy On 24 December 2017 at 22:42, Boyden, Timothy <tboy...@electroswitch.com> wrote: > The issue that I had was that the underlying field would not accept a > value of 0.00590. I had to enter the value as a lot of 1, to get > the price to 59.00, before it would accept the value. If I read the > first link correctly, that is referring to display format, and not > validation of the field input, or the size of fields. Looking at the > table spec, indeed the LAST_PRICE field of SUPPLIER_PRODUCT is only a > decimal field with 3 decimal place precision. It should be at least 5. > All price fields should be at least 5 decimal place precision. > > -Tim > > -Original Message- > From: Paul Foxworthy [mailto:p...@cohsoft.com.au] > Sent: Saturday, December 23, 2017 7:36 PM > To: user@ofbiz.apache.org > Subject: Re: Add Product Supplier broken - similar to Edit Facility > bug > > Hi Tim, > > Decimal places are configurable for many things in OFBiz - see > https://github.com/apache/ofbiz/blob/trunk/applications/ > accounting/config/arithmetic.properties#L24 > and below. > > I can see product pricing should be configurable too. In > https://issues.apache.org/jira/browse/OFBIZ-6436, Ingo Wolfmayer was > proposing adding a similar thing for prices. > > Cheers > > Paul Foxworthy > > > On 24 December 2017 at 08:02, Boyden, Timothy > <tboy...@electroswitch.com> > wrote: > > > Also, it looks like the Last Purchase Price field doesn't accept 5 > > digit decimal places. Major bad for a manufacturing system. A steel > > washer, priced per each, would be like $0.00590 USD. Similarly, > > precious metals, like silver for silver plating, would be ordered in > 5-digit decimal ounces. > > That needs to get fixed. > > > > Thanks, > > > > Tim > > > > > > -- > Coherent Software Australia Pty Ltd > PO Box 2773 > Cheltenham Vic 3192 > Australia > > Phone: +61 3 9585 6788 > Web: http://www.coherentsoftware.com.au/ > Email: i...@coherentsoftware.com.au > -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Australia Phone: +61 3 9585 6788 Web: http://www.coherentsoftware.com.au/ Email: i...@coherentsoftware.com.au
How to specify Windows file path for gradlew "ofbiz --load-data file=foo/bar/FileNameHere.xml"?
How do you specify a Windows file path for command line command `gradlew "ofbiz --load-data file=foo/bar/FileNameHere.xml"`? I put C:\SomePath\SomeFile.xml and the command errored with: Project 'ofbiz --load-data file=C' not found in root project 'ofbiz'. Thanks, Tim
RE: Data Load tips/tricks?
Thanks Taher and Nicolas. I'll check those out. -Tim -Original Message- From: Taher Alkhateeb [mailto:slidingfilame...@gmail.com] Sent: Wednesday, December 27, 2017 7:18 AM To: user@ofbiz.apache.org Subject: Re: Data Load tips/tricks? Hi Tim, My recommendation is to avoid using the web tools altogether, and instead using the CLI. The exact documentation for how to import from XML files is specified in the README.md. This has the benefit of not only reducing resource usage but also allows for automation instead of doing this stuff manually by hand On Wed, Dec 27, 2017 at 3:06 PM, Boyden, Timothy <tboy...@electroswitch.com> wrote: > I started writing scripts this week to export data from our current ERP to > the OFBiz XML data formats. I have loaded about 25,000 of our 150,000 > products through the Web Tools Import XML utility. Are there any tips to > improve load speed, such as temporarily disabling indexing or anything else > anyone has experience with? > > Thanks, > > Tim
Data Load tips/tricks?
I started writing scripts this week to export data from our current ERP to the OFBiz XML data formats. I have loaded about 25,000 of our 150,000 products through the Web Tools Import XML utility. Are there any tips to improve load speed, such as temporarily disabling indexing or anything else anyone has experience with? Thanks, Tim
RE: Cannot install apache-ofbiz-16.11.03 on windows 10
That should be how it works, but I have run into weird issues like Christian has, when I don't run them individually. I had the best luck following the directions listed in the Technical Documentation version of the "Quick & Easy" setup instructions (https://cwiki.apache.org/confluence/display/OFBIZ/Demo+and+Test+Setup+Guide#DemoandTestSetupGuide-Quick), which list the steps separately. -Tim -Original Message- From: Michael Brohl [mailto:michael.br...@ecomify.de] Sent: Sunday, December 24, 2017 8:37 AM To: user@ofbiz.apache.org Subject: Re: Cannot install apache-ofbiz-16.11.03 on windows 10 You also run the tasks all in one, Gradle executes all necessary dependend tasks by itself. No need to run them one-by-one. -- Michael Brohl Geschäftsführer Fon +49 521 448 157-91 Fax +49 521 448 157-99 Mobil +49 160 3664918 Company and Management Headquarters: ecomify GmbH, Gustav-Winkler-Straße 22, 33699 Bielefeld, Deutschland Fon: +49 521 448157-90, Fax: +49 521 448157-99, www.ecomify.de Court Registration: Amtsgericht Bielefeld HRB 41683 Chief Executive Officer: Martin Becker, Michael Brohl > Am 24.12.2017 um 14:26 schrieb Boyden, Timothy <tboy...@electroswitch.com>: > > Christian, > > The first step after unpacking the OFBiz zip file, is to run "gradlew" by > itself. That downloads all of the libraries and does an initial build of > OFBiz. > > Then you would run the "gradlew loadDefault" to load the data into default > Derby database. > > Then you would run "gradlew ofbiz" to run the application. > > -Tim > > -Original Message- > From: Christian Vetterli [mailto:purduealu...@gmx.ch] > Sent: Sunday, December 24, 2017 8:18 AM > To: user@ofbiz.apache.org > Subject: Aw: Re: Cannot install apache-ofbiz-16.11.03 on windows 10 > > Hi Michael, > Thank you for your suggestions. I have read the README.md before I started. I > followed the steps and did nothing else to it. It seems to be straight > forward. > First, get Java JDK. > So, I got Java and saved it to > C:\Program Files\Java\jdk1.8.0_151 > C:\Program Files\Java\jre1.8.0_151 > Second, get the latest OFBiz version. > I got from > https://www.apache.org/dyn/closer.lua/ofbiz/apache-ofbiz-16.11.03.zip the > very first link to download the latest version. > I saved it to > C:\apache-ofbiz-16.11.03 > Then I ran the following command line > gradlew cleanAll loadDefault > I have tried > gradlew loadDefault ofbiz previously with the same result. > And as Jacques suggested > -- stacktrace > > I know that I would not have to uninstall everything to make a new attempt. I > just wanted to make sure that there is nothing else which could mess with the > installation. > > That is all I did. No additional moving around, no programming – nothing. > I have no clue what I could have done wrong. > > I am grateful for your help. > Thanks a lot. > Christian > > > > Gesendet: Sonntag, 24. Dezember 2017 um 12:37 Uhr > Von: "Michael Brohl" <michael.br...@ecomify.de> > An: user@ofbiz.apache.org > Betreff: Re: Cannot install apache-ofbiz-16.11.03 on windows 10 Hi > Christian, > > there is no need to uninstall Java/OFbiz when there is just a missing > JAVA_HOME environment variable. Just point this variable to the correct Java > home directory. > > What does "echo %JAVA_HOME%" and "java -version" say on the command line? > > OFBIZ_HOME is not needed at all, the Gradle build detects everything on its > own. > > I recommend reading the README.md in the project's root folder. It describes > every step you need to run OFBiz. > > NoClassDefFoundError: It seems that you don't have the necessary dependencies > installed on your system. > > Please notice that the library dependencies are (intentionally) not delivered > together with the release. They should be automatically downloaded by the > Gradle build which can take some time for the initial build. You will need an > internet connection to do this. > > If your Gradle cache is messy, please consider removing the contents in the > .gradle folder in your user home directory and execute "gradlew cleanAll > loadDefault ofbiz" again. You should see a lot of additional libaries be > downloaded during the build which may take a while. > > Hope this helps, > > Regards, > > Michael Brohl > ecomify GmbH > www.ecomify.de[http://www.ecomify.de] > >> Am 23.12.17 um 21:25 schrieb Christian Vetterli: >> Thank you Jacques for your hint (deleting JRE, running --stacktrace). >> I uninstalled java JRE and left C:\Program Files\Java\jdk1.8.0_151 >> OFBiz is still at the same location
RE: Re: Cannot install apache-ofbiz-16.11.03 on windows 10
TaskAction.execute(AnnotationProcessingTaskFactory.java: > 210) > at > org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(Abstrac > tTask.java:585) > at > org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(Abstrac > tTask.java:568) > at > org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.exe > cuteAction(ExecuteActionsTaskExecuter.java:80) > at > org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.exe > cuteActions(ExecuteActionsTaskExecuter.java:61) > ... 60 more > > > BUILD FAILED > > Total time: 3 mins 49.412 secs > > C:\apache-ofbiz-16.11.03> > > > Any suggestions? > > Gesendet: Freitag, 22. Dezember 2017 um 20:26 Uhr > Von: "Jacques Le Roux" <jacques.le.r...@les7arts.com> > An: user@ofbiz.apache.org > Betreff: Re: Cannot install apache-ofbiz-16.11.03 on windows 10 Forgot > to say that we can see > > :compileJava > Note: Some input files use unchecked or unsafe operations. > Note: Recompile with -Xlint:unchecked for details. > > that's why I believe Gradle found the JDK. > > But then why Gradle can't find the Apache Commons ParseException class > :-\ > > which is part commons-cli-1.3.1-sources.jar and declared in build.gradle > (line 95): compile 'commons-cli:commons-cli:1.3.1' > > Please Christian follows Gradle advice: "Run with --stacktrace option to get > the stack trace." we may then help you more... > > Jacques > > > Le 22/12/2017 à 20:11, Jacques Le Roux a écrit : >> I see actually you don't need it OOTB. >> >> Most of the time simply it's simply a shortcut to name the directory >> where you have installed OFBiz >> >> In rare specific cases, mostly in few bash scripts, it's used as an >> environment variable. >> >> Also for Christian the problem can't be the definition of JAVA_HOME >> since he gets Gradle to run and got this message >> >> Process 'command 'C:\Program Files\Java\jdk1.8.0_151\bin\java.exe'' >> finished with non-zero exit value 1 >> >> Which proves Windows knows where the Java JDK is and Gradle uses it, right >> Christian? >> >> But maybe there is a confusion we can't see (I use Windows 7) >> >> I'd try to uninstall the JRE and have only the JDK installed to avoid >> any confusion >> >> HTH >> >> Jacques >> >> >> Le 22/12/2017 à 18:43, Boyden, Timothy a écrit : >>> List of docs that reference OFBIZ_HOME: >>> >>> https://cwiki.apache.org/confluence/dosearchsite.action?where=OFBIZ; >>> spaceSearch=true=OFBIZ_HOME[https://cwiki.apache.org/con >>> fluence/dosearchsite.action?where=OFBIZ=true >>> =OFBIZ_HOME] >>> >>> -Tim >>> >>> -Original Message- >>> From: Boyden, Timothy [mailto:tboy...@electroswitch.com] >>> Sent: Friday, December 22, 2017 12:42 PM >>> To: user@ofbiz.apache.org >>> Subject: RE: Cannot install apache-ofbiz-16.11.03 on windows 10 >>> >>> I guess it's not needed, but ran across some documents on ofbiz.apache.org >>> that recommend setting it. >>> >>> -Tim >>> >>> -Original Message- >>> From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] >>> Sent: Friday, December 22, 2017 12:04 PM >>> To: user@ofbiz.apache.org >>> Subject: Re: Cannot install apache-ofbiz-16.11.03 on windows 10 >>> >>> Hi Tim, >>> >>> Why do you define OFBIZ_HOME? >>> >>> Jacques >>> >>> >>> Le 22/12/2017 à 17:25, Boyden, Timothy a écrit : >>>> Hi Christian, >>>> >>>> Did you try setting environment variables for JAVA_HOME and OFBIZ_HOME? >>>> >>>> https://www.mkyong.com/java/how-to-set-java_home-on-windows-10/[htt >>>> ps://www.mkyong.com/java/how-to-set-java_home-on-windows-10/][https >>>> ://www.mkyong.com/java/how-to-set-java_home-on-windows-10/[https:// >>>> www.mkyong.com/java/how-to-set-java_home-on-windows-10/]] >>>> >>>> Follow the instructions in the above to set: >>>> >>>> JAVA_HOME = C:\Program Files\Java\jdk1.8.0_151 OFBIZ_HOME = >>>> C:\apache-ofbiz-16.11.03 >>>> >>>> Make sure the bin folder is in the root of C:\Program >>>> Files\Java\jdk1.8.0_151. >>>> >>>> Make sure the application, framework, etc... folders are in the root of >>>> C:\apache-ofbiz-16.11.03. >>>>
RE: Add Product Supplier broken - similar to Edit Facility bug
Seeing how the Product Supplier works now, was this how Facilities were supposed to work? If so, it looks like Facility should be added to the Add to Role selection, with Facility Group as the Parent Type Id (which also needs to be added to that selection). -Tim -Original Message- From: Paul Foxworthy [mailto:p...@cohsoft.com.au] Sent: Saturday, December 23, 2017 8:01 PM To: user@ofbiz.apache.org Subject: Re: Add Product Supplier broken - similar to Edit Facility bug Hi Tim, In my time with OFBiz, I have discovered that if something seems to be missing, it's probably slightly more complicated than I imagined, rather than being absent altogether. In Add Product Supplier, there is a pick list, but it's looking for parties that have a role of SUPPLIER - https://github.com/apache/ofbiz/blob/trunk/applications/product/widget/catalog/ProductForms.xml#L891 OTH_ea is the ID for a measure, an internal thing. "Other" is a measure category to separate measures for undimensional numbers from weight, time and so on. There is an abbreviation attribute of plain "ea", just as you want - https://github.com/apache/ofbiz/blob/trunk/framework/common/data/UnitData.xml#L322 The demo OFBiz application is intended to show off the capabilities of the OFBiz framework, and will almost certainly be customised for a serious use. If the ea is important for you, you can pretty up presentation of measures for your own work. There are numerous places in the demo where I would welcome enhancements like this. I still work with OFBiz because the underlying framework is well-designed and has very broad capabilities. As an OFBiz contributor, I am more interested in improving the framework and less the demo application, and I suspect I'm not alone in this. So the demo may be somewhat messy and incomplete. Cheers Paul Foxworthy On 24 December 2017 at 07:55, Boyden, Timothy <tboy...@electroswitch.com> wrote: > Having all kinds of fun with Release 16.11.03 today... > > I am following the Getting Started with Apache OFBiz Manufacturing and > MRP book, to add products and suppliers. > > Went to add a supplier for my product, and the Add Product Supplier > screen doesn't provide you with any way to specify or select an > existing Supplier ID. > > Had to use the Entity Data Maintenance tool to create a new > SupplierProduct record, and look up the ID keys for various fields from SQL. > > Just for the record, EA is an ISO standard. Why the keys don't use the > ISO abbreviations for the key ID, is baffling to me. Having to type > OTH_ea is stupid. > > I am guessing we're not using test driven development for this > project? A lot of broken functionality in this release. > > Thanks, > > Tim > -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Australia Phone: +61 3 9585 6788 Web: http://www.coherentsoftware.com.au/ Email: i...@coherentsoftware.com.au
RE: Entity ID key counter not reset after import from XML
No, I understood. When I added the new party (after the import) with a new Postal Address ContactMech, it incremented the sequence correctly. Only when I went to add a ContactMech for the TelecomNumber, did it give me the key conflict error. I had to hit the save key 41 times, as it incremented through all 41 keys, to get it to save. -Tim -Original Message- From: Michael Brohl [mailto:michael.br...@ecomify.de] Sent: Sunday, December 24, 2017 7:14 AM To: user@ofbiz.apache.org Subject: Re: Entity ID key counter not reset after import from XML Maybe I was not clear enough: If you import data from another system, containing the primary key, you won't get a new sequence value from the system you import to. It just imports with the pk in the data. The sequence value for the pk is therefore not increased. In case of TelecomNumber, the primary key is a contactMechId, which is the pk of the ContactMech entity. So you have to look at the sequence value item for ContactMech. Importing telecom numbers alone are not sufficient, the database model is a bit more sophisticated in this case. You have a ContactMech with a purpose TELECOM_NUMBER and a detail entity TelecomNumber. I recommend to have a closer look at the data model. It will make some things clearer. I also recommend the new data model book of 2017, see https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams. Regards, Michael Am 24.12.17 um 13:03 schrieb Boyden, Timothy: > No, this was a new telephone record, being added to a new party, not from the > import. The import was of 10 parties and 40 contact records. To add the new > phone number for the new party, I had to hit save 41 times, to get to an id > value that it would accept. That is certainly not acceptable, the system > should know what the next key available to use is. It doesn't look like the > TelecomNumber uses the SEQUENCE_VALUE_ITEM table to store its next key, so it > must be using some other method, that isn't working correctly. > > -Tim > > -Original Message- > From: Michael Brohl [mailto:michael.br...@ecomify.de] > Sent: Sunday, December 24, 2017 6:45 AM > To: user@ofbiz.apache.org > Subject: Re: Entity ID key counter not reset after import from XML > > Hi Tim, > > if you export the values and just import the generic values, no new > primary key values are generated. The data is imported just the way it is. > > Therefore the sequence value item for the table is not increased and if > you want to create a new item through the user interface, you'll receive > an already used primary key value. This is all logical and no failure in > the software. > > You have two options here: > > 1. set the sequence value item for the table one higher than your > highest value in the loaded data. This can be done using the entity > maintenance in webtools. > > 2. import your data without the primary key values. OFBiz will then > generate them from the SEQUENCE_VALUE_ITEM table. > > Hope this helps, > > Regards, > > Michael Brohl > ecomify GmbH > www.ecomify.de > > > Am 23.12.17 um 21:03 schrieb Boyden, Timothy: >> I found the SEQUENCE_VALUE_ITEM table, and the entry for ContactMech had the >> correct next key. It looks like for some reason, ContactMech or >> TelecomNumber is not using that to create the next sequence correctly. I >> guess for now, I'll just keep hitting save until I get to 10042. Hopefully >> it will save then and reset the counter its using. >> >> -Tim >> >> -Original Message- >> From: Boyden, Timothy [mailto:tboy...@electroswitch.com] >> Sent: Saturday, December 23, 2017 2:37 PM >> To: user@ofbiz.apache.org >> Subject: Entity ID key counter not reset after import from XML >> >> Using Release 16.11.03... >> >> Working on an instance of OFBiz on my home computer. Imported 40 >> TelecomNumber records from my work computer. Went to create a new >> TelecomNumber record, and get: >> >> >> The Following Errors Occurred: >> >> Exception thrown while creating the "newValue" GenericValue: >> org.apache.ofbiz.entity.GenericEntityException: Error while inserting: >> [GenericEntity:ContactMech][contactMechId,10031(java.lang.String)][contactMechTypeId,TELECOM_NUMBER(java.lang.String)][createdStamp,2017-12-23 >> 14:33:09.744(java.sql.Timestamp)][createdTxStamp,2017-12-23 >> 14:33:09.657(java.sql.Timestamp)][lastUpdatedStamp,2017-12-23 >> 14:33:09.744(java.sql.Timestamp)][lastUpdatedTxStamp,2017-12-23 >> 14:33:09.657(java.sql.Timestamp)] (SQL Exception while executing the >> following:INSERT INTO dbo.CONTACT_MECH (CONTACT_MECH_ID, >> CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATE
RE: Add Product Supplier broken - similar to Edit Facility bug
Michael, Thank you for your response, and I agree. I will start filing Jiras. My thought was to first see if anyone else experienced the same issues and knew of a solution, prior to doing so. In the case of Product Suppliers, that was the case. Hopefully the Jiras won't go into a black hole... Thanks, Tim -Original Message- From: Michael Brohl [mailto:michael.br...@ecomify.de] Sent: Sunday, December 24, 2017 6:16 AM To: user@ofbiz.apache.org Subject: Re: Add Product Supplier broken - similar to Edit Facility bug Hi Tim, thanks you for your valuable feedback. It's important to get feedback from users, especially new users who have a fresh view on the project. Paul already gave some hints about the details. Please file a Jira issue if you think there is something broken or needs an improvement. In this way you can become part of the "we" you are referring to and it helps to improve the software. Thanks for your contribution, Michael Am 23.12.17 um 21:55 schrieb Boyden, Timothy: > Having all kinds of fun with Release 16.11.03 today... > > I am following the Getting Started with Apache OFBiz Manufacturing and MRP > book, to add products and suppliers. > > Went to add a supplier for my product, and the Add Product Supplier screen > doesn't provide you with any way to specify or select an existing Supplier ID. > > Had to use the Entity Data Maintenance tool to create a new SupplierProduct > record, and look up the ID keys for various fields from SQL. > > Just for the record, EA is an ISO standard. Why the keys don't use the ISO > abbreviations for the key ID, is baffling to me. Having to type OTH_ea is > stupid. > > I am guessing we're not using test driven development for this project? A lot > of broken functionality in this release. > > Thanks, > > Tim >
RE: Entity ID key counter not reset after import from XML
No, this was a new telephone record, being added to a new party, not from the import. The import was of 10 parties and 40 contact records. To add the new phone number for the new party, I had to hit save 41 times, to get to an id value that it would accept. That is certainly not acceptable, the system should know what the next key available to use is. It doesn't look like the TelecomNumber uses the SEQUENCE_VALUE_ITEM table to store its next key, so it must be using some other method, that isn't working correctly. -Tim -Original Message- From: Michael Brohl [mailto:michael.br...@ecomify.de] Sent: Sunday, December 24, 2017 6:45 AM To: user@ofbiz.apache.org Subject: Re: Entity ID key counter not reset after import from XML Hi Tim, if you export the values and just import the generic values, no new primary key values are generated. The data is imported just the way it is. Therefore the sequence value item for the table is not increased and if you want to create a new item through the user interface, you'll receive an already used primary key value. This is all logical and no failure in the software. You have two options here: 1. set the sequence value item for the table one higher than your highest value in the loaded data. This can be done using the entity maintenance in webtools. 2. import your data without the primary key values. OFBiz will then generate them from the SEQUENCE_VALUE_ITEM table. Hope this helps, Regards, Michael Brohl ecomify GmbH www.ecomify.de Am 23.12.17 um 21:03 schrieb Boyden, Timothy: > I found the SEQUENCE_VALUE_ITEM table, and the entry for ContactMech had the > correct next key. It looks like for some reason, ContactMech or TelecomNumber > is not using that to create the next sequence correctly. I guess for now, > I'll just keep hitting save until I get to 10042. Hopefully it will save then > and reset the counter its using. > > -Tim > > -Original Message----- > From: Boyden, Timothy [mailto:tboy...@electroswitch.com] > Sent: Saturday, December 23, 2017 2:37 PM > To: user@ofbiz.apache.org > Subject: Entity ID key counter not reset after import from XML > > Using Release 16.11.03... > > Working on an instance of OFBiz on my home computer. Imported 40 > TelecomNumber records from my work computer. Went to create a new > TelecomNumber record, and get: > > > The Following Errors Occurred: > > Exception thrown while creating the "newValue" GenericValue: > org.apache.ofbiz.entity.GenericEntityException: Error while inserting: > [GenericEntity:ContactMech][contactMechId,10031(java.lang.String)][contactMechTypeId,TELECOM_NUMBER(java.lang.String)][createdStamp,2017-12-23 > 14:33:09.744(java.sql.Timestamp)][createdTxStamp,2017-12-23 > 14:33:09.657(java.sql.Timestamp)][lastUpdatedStamp,2017-12-23 > 14:33:09.744(java.sql.Timestamp)][lastUpdatedTxStamp,2017-12-23 > 14:33:09.657(java.sql.Timestamp)] (SQL Exception while executing the > following:INSERT INTO dbo.CONTACT_MECH (CONTACT_MECH_ID, > CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (Violation of > PRIMARY KEY constraint 'PK_CONTACT_MECH'. Cannot insert duplicate key in > object 'dbo.CONTACT_MECH'. The duplicate key value is (10031).)) (Error while > inserting: > [GenericEntity:ContactMech][contactMechId,10031(java.lang.String)][contactMechTypeId,TELECOM_NUMBER(java.lang.String)][createdStamp,2017-12-23 > 14:33:09.744(java.sql.Timestamp)][createdTxStamp,2017-12-23 > 14:33:09.657(java.sql.Timestamp)][lastUpdatedStamp,2017-12-23 > 14:33:09.744(java.sql.Timestamp)][lastUpdatedTxStamp,2017-12-23 > 14:33:09.657(java.sql.Timestamp)] (SQL Exception while executing the > following:INSERT INTO dbo.CONTACT_MECH (CONTACT_MECH_ID, > CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (Violation of > PRIMARY KEY constraint 'PK_CONTACT_MECH'. Cannot insert duplicate key in > object 'dbo.CONTACT_MECH'. The duplicate key value is (10031).))) The next > key value should have been reset to 10041 after the import, but it wasn't. > > Is there a quick way for me to reset the next key value? > > Thanks, > > Tim
RE: Add Product Supplier broken - similar to Edit Facility bug
I stand corrected on Product Suppliers. Thank you for the clarification. I get what you are saying about unit of measures, I don't agree, and think the ISO standard should be used when available, but at this point, with the above info, the point is moot. I understand where you are coming from, from the developer perspective. Especially in an open source project where people are choosing to work on the features they care about. I also understand that there is dual marketing involved here, one side is pushing "just a framework", and the other side is pushing a mature buisness application for your business. I don't think the second aspect of this can be "it's just a demo" program. Clearly its not, and a lot of thought went into the design and functionality to make it a viable application for a buisness. There are even books written on how to use it as such. So to casually brush off any perceived issues, as "well, it's just a demo application", does the project injustice, and doesn't speak well to its maturity. Especially after the recent ha-ha that was had comparing OFBiz to Odoo. If you want to project the project as a superior solution, in light of others, you definitely shouldn't treat it as "just a demo application". -Tim -Original Message- From: Paul Foxworthy [mailto:p...@cohsoft.com.au] Sent: Saturday, December 23, 2017 8:01 PM To: user@ofbiz.apache.org Subject: Re: Add Product Supplier broken - similar to Edit Facility bug Hi Tim, In my time with OFBiz, I have discovered that if something seems to be missing, it's probably slightly more complicated than I imagined, rather than being absent altogether. In Add Product Supplier, there is a pick list, but it's looking for parties that have a role of SUPPLIER - https://github.com/apache/ofbiz/blob/trunk/applications/product/widget/catalog/ProductForms.xml#L891 OTH_ea is the ID for a measure, an internal thing. "Other" is a measure category to separate measures for undimensional numbers from weight, time and so on. There is an abbreviation attribute of plain "ea", just as you want - https://github.com/apache/ofbiz/blob/trunk/framework/common/data/UnitData.xml#L322 The demo OFBiz application is intended to show off the capabilities of the OFBiz framework, and will almost certainly be customised for a serious use. If the ea is important for you, you can pretty up presentation of measures for your own work. There are numerous places in the demo where I would welcome enhancements like this. I still work with OFBiz because the underlying framework is well-designed and has very broad capabilities. As an OFBiz contributor, I am more interested in improving the framework and less the demo application, and I suspect I'm not alone in this. So the demo may be somewhat messy and incomplete. Cheers Paul Foxworthy On 24 December 2017 at 07:55, Boyden, Timothy <tboy...@electroswitch.com> wrote: > Having all kinds of fun with Release 16.11.03 today... > > I am following the Getting Started with Apache OFBiz Manufacturing and > MRP book, to add products and suppliers. > > Went to add a supplier for my product, and the Add Product Supplier > screen doesn't provide you with any way to specify or select an > existing Supplier ID. > > Had to use the Entity Data Maintenance tool to create a new > SupplierProduct record, and look up the ID keys for various fields from SQL. > > Just for the record, EA is an ISO standard. Why the keys don't use the > ISO abbreviations for the key ID, is baffling to me. Having to type > OTH_ea is stupid. > > I am guessing we're not using test driven development for this > project? A lot of broken functionality in this release. > > Thanks, > > Tim > -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Australia Phone: +61 3 9585 6788 Web: http://www.coherentsoftware.com.au/ Email: i...@coherentsoftware.com.au
RE: Add Product Supplier broken - similar to Edit Facility bug
The issue that I had was that the underlying field would not accept a value of 0.00590. I had to enter the value as a lot of 1, to get the price to 59.00, before it would accept the value. If I read the first link correctly, that is referring to display format, and not validation of the field input, or the size of fields. Looking at the table spec, indeed the LAST_PRICE field of SUPPLIER_PRODUCT is only a decimal field with 3 decimal place precision. It should be at least 5. All price fields should be at least 5 decimal place precision. -Tim -Original Message- From: Paul Foxworthy [mailto:p...@cohsoft.com.au] Sent: Saturday, December 23, 2017 7:36 PM To: user@ofbiz.apache.org Subject: Re: Add Product Supplier broken - similar to Edit Facility bug Hi Tim, Decimal places are configurable for many things in OFBiz - see https://github.com/apache/ofbiz/blob/trunk/applications/accounting/config/arithmetic.properties#L24 and below. I can see product pricing should be configurable too. In https://issues.apache.org/jira/browse/OFBIZ-6436, Ingo Wolfmayer was proposing adding a similar thing for prices. Cheers Paul Foxworthy On 24 December 2017 at 08:02, Boyden, Timothy <tboy...@electroswitch.com> wrote: > Also, it looks like the Last Purchase Price field doesn't accept 5 > digit decimal places. Major bad for a manufacturing system. A steel > washer, priced per each, would be like $0.00590 USD. Similarly, > precious metals, like silver for silver plating, would be ordered in 5-digit > decimal ounces. > That needs to get fixed. > > Thanks, > > Tim > -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Australia Phone: +61 3 9585 6788 Web: http://www.coherentsoftware.com.au/ Email: i...@coherentsoftware.com.au
RE: Add Product Supplier broken - similar to Edit Facility bug
Also, it looks like the Last Purchase Price field doesn't accept 5 digit decimal places. Major bad for a manufacturing system. A steel washer, priced per each, would be like $0.00590 USD. Similarly, precious metals, like silver for silver plating, would be ordered in 5-digit decimal ounces. That needs to get fixed. Thanks, Tim
Add Product Supplier broken - similar to Edit Facility bug
Having all kinds of fun with Release 16.11.03 today... I am following the Getting Started with Apache OFBiz Manufacturing and MRP book, to add products and suppliers. Went to add a supplier for my product, and the Add Product Supplier screen doesn't provide you with any way to specify or select an existing Supplier ID. Had to use the Entity Data Maintenance tool to create a new SupplierProduct record, and look up the ID keys for various fields from SQL. Just for the record, EA is an ISO standard. Why the keys don't use the ISO abbreviations for the key ID, is baffling to me. Having to type OTH_ea is stupid. I am guessing we're not using test driven development for this project? A lot of broken functionality in this release. Thanks, Tim
RE: Entity ID key counter not reset after import from XML
I found the SEQUENCE_VALUE_ITEM table, and the entry for ContactMech had the correct next key. It looks like for some reason, ContactMech or TelecomNumber is not using that to create the next sequence correctly. I guess for now, I'll just keep hitting save until I get to 10042. Hopefully it will save then and reset the counter its using. -Tim -Original Message- From: Boyden, Timothy [mailto:tboy...@electroswitch.com] Sent: Saturday, December 23, 2017 2:37 PM To: user@ofbiz.apache.org Subject: Entity ID key counter not reset after import from XML Using Release 16.11.03... Working on an instance of OFBiz on my home computer. Imported 40 TelecomNumber records from my work computer. Went to create a new TelecomNumber record, and get: The Following Errors Occurred: Exception thrown while creating the "newValue" GenericValue: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ContactMech][contactMechId,10031(java.lang.String)][contactMechTypeId,TELECOM_NUMBER(java.lang.String)][createdStamp,2017-12-23 14:33:09.744(java.sql.Timestamp)][createdTxStamp,2017-12-23 14:33:09.657(java.sql.Timestamp)][lastUpdatedStamp,2017-12-23 14:33:09.744(java.sql.Timestamp)][lastUpdatedTxStamp,2017-12-23 14:33:09.657(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO dbo.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (Violation of PRIMARY KEY constraint 'PK_CONTACT_MECH'. Cannot insert duplicate key in object 'dbo.CONTACT_MECH'. The duplicate key value is (10031).)) (Error while inserting: [GenericEntity:ContactMech][contactMechId,10031(java.lang.String)][contactMechTypeId,TELECOM_NUMBER(java.lang.String)][createdStamp,2017-12-23 14:33:09.744(java.sql.Timestamp)][createdTxStamp,2017-12-23 14:33:09.657(java.sql.Timestamp)][lastUpdatedStamp,2017-12-23 14:33:09.744(java.sql.Timestamp)][lastUpdatedTxStamp,2017-12-23 14:33:09.657(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO dbo.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (Violation of PRIMARY KEY constraint 'PK_CONTACT_MECH'. Cannot insert duplicate key in object 'dbo.CONTACT_MECH'. The duplicate key value is (10031).))) The next key value should have been reset to 10041 after the import, but it wasn't. Is there a quick way for me to reset the next key value? Thanks, Tim
Party export error
Using Release 16.11.03... When exporting Party records from my work PC this morning, I got the following error: ERROR rendering error page [/error/error.jsp], but here is the error text: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://webtools/widget/EntityScreens.xml#xmldsdump]: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://webtools/widget/CommonScreens.xml#CommonImportExportDecorator]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: [1] [xxx] Error when writing Party: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because it is not comparable.)org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because it is not comparable.) (SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because it is not comparable.)) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: [1] [xxx] Error when writing Party: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because it is not comparable.)org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because it is not comparable.) (SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because it is not comparable.))) (Error rendering screen [component://webtools/widget/CommonScreens.xml#CommonImportExportDecorator]: org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: [1] [xxx] Error when writing Party: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because it is not comparable.)org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE,
Entity ID key counter not reset after import from XML
Using Release 16.11.03... Working on an instance of OFBiz on my home computer. Imported 40 TelecomNumber records from my work computer. Went to create a new TelecomNumber record, and get: The Following Errors Occurred: Exception thrown while creating the "newValue" GenericValue: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ContactMech][contactMechId,10031(java.lang.String)][contactMechTypeId,TELECOM_NUMBER(java.lang.String)][createdStamp,2017-12-23 14:33:09.744(java.sql.Timestamp)][createdTxStamp,2017-12-23 14:33:09.657(java.sql.Timestamp)][lastUpdatedStamp,2017-12-23 14:33:09.744(java.sql.Timestamp)][lastUpdatedTxStamp,2017-12-23 14:33:09.657(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO dbo.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (Violation of PRIMARY KEY constraint 'PK_CONTACT_MECH'. Cannot insert duplicate key in object 'dbo.CONTACT_MECH'. The duplicate key value is (10031).)) (Error while inserting: [GenericEntity:ContactMech][contactMechId,10031(java.lang.String)][contactMechTypeId,TELECOM_NUMBER(java.lang.String)][createdStamp,2017-12-23 14:33:09.744(java.sql.Timestamp)][createdTxStamp,2017-12-23 14:33:09.657(java.sql.Timestamp)][lastUpdatedStamp,2017-12-23 14:33:09.744(java.sql.Timestamp)][lastUpdatedTxStamp,2017-12-23 14:33:09.657(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO dbo.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (Violation of PRIMARY KEY constraint 'PK_CONTACT_MECH'. Cannot insert duplicate key in object 'dbo.CONTACT_MECH'. The duplicate key value is (10031).))) The next key value should have been reset to 10041 after the import, but it wasn't. Is there a quick way for me to reset the next key value? Thanks, Tim
RE: Cannot install apache-ofbiz-16.11.03 on windows 10
List of docs that reference OFBIZ_HOME: https://cwiki.apache.org/confluence/dosearchsite.action?where=OFBIZ=true=OFBIZ_HOME -Tim -Original Message- From: Boyden, Timothy [mailto:tboy...@electroswitch.com] Sent: Friday, December 22, 2017 12:42 PM To: user@ofbiz.apache.org Subject: RE: Cannot install apache-ofbiz-16.11.03 on windows 10 I guess it's not needed, but ran across some documents on ofbiz.apache.org that recommend setting it. -Tim -Original Message- From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] Sent: Friday, December 22, 2017 12:04 PM To: user@ofbiz.apache.org Subject: Re: Cannot install apache-ofbiz-16.11.03 on windows 10 Hi Tim, Why do you define OFBIZ_HOME? Jacques Le 22/12/2017 à 17:25, Boyden, Timothy a écrit : > Hi Christian, > > Did you try setting environment variables for JAVA_HOME and OFBIZ_HOME? > > https://www.mkyong.com/java/how-to-set-java_home-on-windows-10/ > > Follow the instructions in the above to set: > > JAVA_HOME = C:\Program Files\Java\jdk1.8.0_151 OFBIZ_HOME = > C:\apache-ofbiz-16.11.03 > > Make sure the bin folder is in the root of C:\Program Files\Java\jdk1.8.0_151. > > Make sure the application, framework, etc... folders are in the root of > C:\apache-ofbiz-16.11.03. > > Then try recompiling. > > -Tim > > > -Original Message- > From: Christian Vetterli [mailto:purduealu...@gmx.ch] > Sent: Friday, December 22, 2017 8:59 AM > To: user@ofbiz.apache.org > Subject: Cannot install apache-ofbiz-16.11.03 on windows 10 > > Hello all, > I do not get OFBiz istalled on my Windows 10 computer. I have tried any > combination I could come up with. Different loading locations. All currently > available Java versions from Oracle. Nothing seem to work. I am not a > programmer. > > What I did for example is: > OFBiz to C:\apache-ofbiz-16.11.03 > Java to C:\Program Files\Java\jdk1.8.0_151 and C:\Program > Files\Java\jre1.8.0_151 > > I used the commands gradlew cleanAll loadDefault or gradlew loadDefault ofbiz > and I tried to change locations for OFBiz and Java. In addition, I tried the > latest version of Java. > All I am getting is: > > C:\apache-ofbiz-16.11.03>gradlew cleanAll loadDefault :clean :cleanAnt > :cleanCatalina :cleanData :cleanDownloads :cleanEclipseClasspath > UP-TO-DATE :cleanEclipseJdt UP-TO-DATE :cleanEclipseProject UP-TO-DATE > :cleanEclipse UP-TO-DATE :cleanFooterFiles :cleanGradle :cleanIndexes > :cleanLogs :cleanOutput :cleanTempfiles :cleanUploads :cleanXtra > :cleanAll :compileJava > Note: Some input files use unchecked or unsafe operations. > Note: Recompile with -Xlint:unchecked for details. > :processResources > :classes > :jar > :assemble > :compileTestJava > :processTestResources UP-TO-DATE > :testClasses > :test > :check > :build > :ofbiz --load-data > > Exception in thread "main" java.lang.NoClassDefFoundError: > org/apache/commons/cli/ParseException > at org.apache.ofbiz.base.start.Start.main(Start.java:60) > Caused by: java.lang.ClassNotFoundException: > org.apache.commons.cli.ParseException > at java.net.URLClassLoader.findClass(URLClassLoader.java:381) > at java.lang.ClassLoader.loadClass(ClassLoader.java:424) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335) > at java.lang.ClassLoader.loadClass(ClassLoader.java:357) > ... 1 more > :ofbiz --load-data FAILED > > FAILURE: Build failed with an exception. > > * What went wrong: > Execution failed for task ':ofbiz --load-data'. >> Process 'command 'C:\Program Files\Java\jdk1.8.0_151\bin\java.exe'' >> finished with non-zero exit value 1 > > * Try: > Run with --stacktrace option to get the stack trace. Run with --info or > --debug option to get more log output. > > BUILD FAILED > > Total time: 2 mins 54.909 secs > > C:\apache-ofbiz-16.11.03> > > It seems that there might be a problem with windows 10. > Does someone have a solution? > Thanks a lot. > Greetings from Switzerland, > Christian
RE: Cannot install apache-ofbiz-16.11.03 on windows 10
I guess it's not needed, but ran across some documents on ofbiz.apache.org that recommend setting it. -Tim -Original Message- From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] Sent: Friday, December 22, 2017 12:04 PM To: user@ofbiz.apache.org Subject: Re: Cannot install apache-ofbiz-16.11.03 on windows 10 Hi Tim, Why do you define OFBIZ_HOME? Jacques Le 22/12/2017 à 17:25, Boyden, Timothy a écrit : > Hi Christian, > > Did you try setting environment variables for JAVA_HOME and OFBIZ_HOME? > > https://www.mkyong.com/java/how-to-set-java_home-on-windows-10/ > > Follow the instructions in the above to set: > > JAVA_HOME = C:\Program Files\Java\jdk1.8.0_151 OFBIZ_HOME = > C:\apache-ofbiz-16.11.03 > > Make sure the bin folder is in the root of C:\Program Files\Java\jdk1.8.0_151. > > Make sure the application, framework, etc... folders are in the root of > C:\apache-ofbiz-16.11.03. > > Then try recompiling. > > -Tim > > > -Original Message- > From: Christian Vetterli [mailto:purduealu...@gmx.ch] > Sent: Friday, December 22, 2017 8:59 AM > To: user@ofbiz.apache.org > Subject: Cannot install apache-ofbiz-16.11.03 on windows 10 > > Hello all, > I do not get OFBiz istalled on my Windows 10 computer. I have tried any > combination I could come up with. Different loading locations. All currently > available Java versions from Oracle. Nothing seem to work. I am not a > programmer. > > What I did for example is: > OFBiz to C:\apache-ofbiz-16.11.03 > Java to C:\Program Files\Java\jdk1.8.0_151 and C:\Program > Files\Java\jre1.8.0_151 > > I used the commands gradlew cleanAll loadDefault or gradlew loadDefault ofbiz > and I tried to change locations for OFBiz and Java. In addition, I tried the > latest version of Java. > All I am getting is: > > C:\apache-ofbiz-16.11.03>gradlew cleanAll loadDefault :clean :cleanAnt > :cleanCatalina :cleanData :cleanDownloads :cleanEclipseClasspath > UP-TO-DATE :cleanEclipseJdt UP-TO-DATE :cleanEclipseProject UP-TO-DATE > :cleanEclipse UP-TO-DATE :cleanFooterFiles :cleanGradle :cleanIndexes > :cleanLogs :cleanOutput :cleanTempfiles :cleanUploads :cleanXtra > :cleanAll :compileJava > Note: Some input files use unchecked or unsafe operations. > Note: Recompile with -Xlint:unchecked for details. > :processResources > :classes > :jar > :assemble > :compileTestJava > :processTestResources UP-TO-DATE > :testClasses > :test > :check > :build > :ofbiz --load-data > > Exception in thread "main" java.lang.NoClassDefFoundError: > org/apache/commons/cli/ParseException > at org.apache.ofbiz.base.start.Start.main(Start.java:60) > Caused by: java.lang.ClassNotFoundException: > org.apache.commons.cli.ParseException > at java.net.URLClassLoader.findClass(URLClassLoader.java:381) > at java.lang.ClassLoader.loadClass(ClassLoader.java:424) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335) > at java.lang.ClassLoader.loadClass(ClassLoader.java:357) > ... 1 more > :ofbiz --load-data FAILED > > FAILURE: Build failed with an exception. > > * What went wrong: > Execution failed for task ':ofbiz --load-data'. >> Process 'command 'C:\Program Files\Java\jdk1.8.0_151\bin\java.exe'' >> finished with non-zero exit value 1 > > * Try: > Run with --stacktrace option to get the stack trace. Run with --info or > --debug option to get more log output. > > BUILD FAILED > > Total time: 2 mins 54.909 secs > > C:\apache-ofbiz-16.11.03> > > It seems that there might be a problem with windows 10. > Does someone have a solution? > Thanks a lot. > Greetings from Switzerland, > Christian
RE: Cannot install apache-ofbiz-16.11.03 on windows 10
That should be: JAVA_HOME = C:\Program Files\Java\jdk1.8.0_151 OFBIZ_HOME = C:\apache-ofbiz-16.11.03 The list engine mangled my email. -Tim -Original Message- From: Boyden, Timothy [mailto:tboy...@electroswitch.com] Sent: Friday, December 22, 2017 11:25 AM To: user@ofbiz.apache.org Subject: RE: Cannot install apache-ofbiz-16.11.03 on windows 10 Hi Christian, Did you try setting environment variables for JAVA_HOME and OFBIZ_HOME? https://www.mkyong.com/java/how-to-set-java_home-on-windows-10/ Follow the instructions in the above to set: JAVA_HOME = C:\Program Files\Java\jdk1.8.0_151 OFBIZ_HOME = C:\apache-ofbiz-16.11.03 Make sure the bin folder is in the root of C:\Program Files\Java\jdk1.8.0_151. Make sure the application, framework, etc... folders are in the root of C:\apache-ofbiz-16.11.03. Then try recompiling. -Tim -Original Message- From: Christian Vetterli [mailto:purduealu...@gmx.ch] Sent: Friday, December 22, 2017 8:59 AM To: user@ofbiz.apache.org Subject: Cannot install apache-ofbiz-16.11.03 on windows 10 Hello all, I do not get OFBiz istalled on my Windows 10 computer. I have tried any combination I could come up with. Different loading locations. All currently available Java versions from Oracle. Nothing seem to work. I am not a programmer. What I did for example is: OFBiz to C:\apache-ofbiz-16.11.03 Java to C:\Program Files\Java\jdk1.8.0_151 and C:\Program Files\Java\jre1.8.0_151 I used the commands gradlew cleanAll loadDefault or gradlew loadDefault ofbiz and I tried to change locations for OFBiz and Java. In addition, I tried the latest version of Java. All I am getting is: C:\apache-ofbiz-16.11.03>gradlew cleanAll loadDefault :clean :cleanAnt :cleanCatalina :cleanData :cleanDownloads :cleanEclipseClasspath UP-TO-DATE :cleanEclipseJdt UP-TO-DATE :cleanEclipseProject UP-TO-DATE :cleanEclipse UP-TO-DATE :cleanFooterFiles :cleanGradle :cleanIndexes :cleanLogs :cleanOutput :cleanTempfiles :cleanUploads :cleanXtra :cleanAll :compileJava Note: Some input files use unchecked or unsafe operations. Note: Recompile with -Xlint:unchecked for details. :processResources :classes :jar :assemble :compileTestJava :processTestResources UP-TO-DATE :testClasses :test :check :build :ofbiz --load-data Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/cli/ParseException at org.apache.ofbiz.base.start.Start.main(Start.java:60) Caused by: java.lang.ClassNotFoundException: org.apache.commons.cli.ParseException at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ... 1 more :ofbiz --load-data FAILED FAILURE: Build failed with an exception. * What went wrong: Execution failed for task ':ofbiz --load-data'. > Process 'command 'C:\Program Files\Java\jdk1.8.0_151\bin\java.exe'' > finished with non-zero exit value 1 * Try: Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. BUILD FAILED Total time: 2 mins 54.909 secs C:\apache-ofbiz-16.11.03> It seems that there might be a problem with windows 10. Does someone have a solution? Thanks a lot. Greetings from Switzerland, Christian
RE: Cannot install apache-ofbiz-16.11.03 on windows 10
Hi Christian, Did you try setting environment variables for JAVA_HOME and OFBIZ_HOME? https://www.mkyong.com/java/how-to-set-java_home-on-windows-10/ Follow the instructions in the above to set: JAVA_HOME = C:\Program Files\Java\jdk1.8.0_151 OFBIZ_HOME = C:\apache-ofbiz-16.11.03 Make sure the bin folder is in the root of C:\Program Files\Java\jdk1.8.0_151. Make sure the application, framework, etc... folders are in the root of C:\apache-ofbiz-16.11.03. Then try recompiling. -Tim -Original Message- From: Christian Vetterli [mailto:purduealu...@gmx.ch] Sent: Friday, December 22, 2017 8:59 AM To: user@ofbiz.apache.org Subject: Cannot install apache-ofbiz-16.11.03 on windows 10 Hello all, I do not get OFBiz istalled on my Windows 10 computer. I have tried any combination I could come up with. Different loading locations. All currently available Java versions from Oracle. Nothing seem to work. I am not a programmer. What I did for example is: OFBiz to C:\apache-ofbiz-16.11.03 Java to C:\Program Files\Java\jdk1.8.0_151 and C:\Program Files\Java\jre1.8.0_151 I used the commands gradlew cleanAll loadDefault or gradlew loadDefault ofbiz and I tried to change locations for OFBiz and Java. In addition, I tried the latest version of Java. All I am getting is: C:\apache-ofbiz-16.11.03>gradlew cleanAll loadDefault :clean :cleanAnt :cleanCatalina :cleanData :cleanDownloads :cleanEclipseClasspath UP-TO-DATE :cleanEclipseJdt UP-TO-DATE :cleanEclipseProject UP-TO-DATE :cleanEclipse UP-TO-DATE :cleanFooterFiles :cleanGradle :cleanIndexes :cleanLogs :cleanOutput :cleanTempfiles :cleanUploads :cleanXtra :cleanAll :compileJava Note: Some input files use unchecked or unsafe operations. Note: Recompile with -Xlint:unchecked for details. :processResources :classes :jar :assemble :compileTestJava :processTestResources UP-TO-DATE :testClasses :test :check :build :ofbiz --load-data Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/cli/ParseException at org.apache.ofbiz.base.start.Start.main(Start.java:60) Caused by: java.lang.ClassNotFoundException: org.apache.commons.cli.ParseException at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ... 1 more :ofbiz --load-data FAILED FAILURE: Build failed with an exception. * What went wrong: Execution failed for task ':ofbiz --load-data'. > Process 'command 'C:\Program Files\Java\jdk1.8.0_151\bin\java.exe'' > finished with non-zero exit value 1 * Try: Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. BUILD FAILED Total time: 2 mins 54.909 secs C:\apache-ofbiz-16.11.03> It seems that there might be a problem with windows 10. Does someone have a solution? Thanks a lot. Greetings from Switzerland, Christian
RE: Create Facility bug?
Maybe a short term solution would be to seed in a default facility, just like
there is the default _NA_ facility group. That would be a quicker fix I would
think, and suppress the issue until it can be fixed.
-Tim
-Original Message-
From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com]
Sent: Saturday, December 16, 2017 12:15 PM
To: user@ofbiz.apache.org
Subject: Re: Create Facility bug?
Yes this has been discussed (many times), here is the last take at it
http://markmail.org/message/tbn7mn753x27snn7
The right thing to do would be to revert or refactor r734037 but as I said in
OFBIZ-5321 not an easy task and not a priority
BTW the right link to use is facility/control/EditFacility
I think for now I'll complete my comment for the case when there is no facility
at all by giving a link to facility/control/EditFacility
Thanks
Jacques
Le 15/12/2017 à 19:22, Boyden, Timothy a écrit :
>
> Wondering if anyone is aware of a UI bug with creating new facilities?
>
> From a clean install of OFBiz.
>
> * Go to Facility tab
> * The main page that comes up is a Facility search form
> o When there have been no facilities added yet, the Facility ID box is
> empty, and, of course, no Facilities are found.
> o The button on this form points to creating a new Facility Group, and
> not a new Facility
> * Go to Facility Groups sub-tab
> * Click on default _/NA/_ group
> * Click on Facilities sub-tab
> o This form is similar to what you see the first time clicking on the
> main Facility tab
> o Same issue exists here - instead of a button to create a new
> Facility, the button instead prompts you to create a New Group
>
> The work-around for this, after studying the URL paths, is to navigate
> to: https://{OFBiz site URL}/facility/control/CreateFacility
>
> That gets you to the correct create facility form, where you can
> create your first facility. Once you created the first one, then you can get
> to a Create New Facility button, via the Facility Selection form on the
> Facilities sub-tab.
>
> Here is a screenshot of the offending UI:
>
> cid:image001.png@01D375A7.44C78130
>
> This is what is should look like:
>
> cid:image002.png@01D375A7.A427B410
>
> Thanks,
>
> Tim Boyden
>
RE: Ofbiz to postgresSql connection problem
Looks like there is already some working Docker images out on Docker Hub. None
so far suite my current needs (OFBiz with Docker MS SQL 2017 on Linux). I think
I may reach out to opensourceknight and see if he can extend his image to add
the volume /framework/entity/lib/jdbc, so that any JDBC driver, for any DBMS,
can be installed and configured.
I am currently running trunk from Git locally against a MS SQL 2017 on Linux
Docker image. Works pretty sweet. Now just need OFBiz in a Docker image to link
to the MS SQL instance, and it will be gangbusters.
-Tim
-Original Message-
From: Paul Mandeltort [mailto:p...@marcospec.com]
Sent: Friday, December 15, 2017 1:37 PM
To: user@ofbiz.apache.org
Subject: RE: Ofbiz to postgresSql connection problem
Going to second the option of Docker image - I’ve started playing with it but
ran out of time lately.
A proper docker architecture for ofbiz would be split up as a reference docker
compose file that launches:
- OFbiz Application/Tomcat container
- Database Container - my recommendation is to ditch Derby completely since
deploying postgres as a container is trivial now and the only reason we have
derby (as I understand it) is to simplify initial bring-up of the application.
This can be switched out for a demo-data image that’s already ready to go or
switched to a production image with almost no headaches.
- SOLR container
- Load/Balancer/Http proxy container
I’ve been toying with this but ran out of time with some other projects on
fire, but want to get back to it as I’m convinced it’ll reduce developer on
boarding effort by an order of magnitude and make it trivial to test and move
deployments between production and development machines.
—P
On Dec 15, 2017, 13:02 -0500, Boyden, Timothy <tboy...@electroswitch.com>,
wrote:
> No problem, hopefully that came across as constructive criticism (as it was
> meant), and not as a rant.
>
> Maybe one possibility is enlisting the help of the jpackage team
> (http://www.jpackage.org/). They have quite the library of Java applications
> that they have repackaged as yum, apt, and rpm installers.
>
> Another possibilty would be reaching out to existing talent in other Apache
> projects, that currently write installers for their projects.
>
> Even nicer would be a Docker image, as that is how most people get up to
> speed on a new application server these days, and would allow a quick path to
> creating a scalable/fault tolerant instance of OFBiz.
>
> Wish I could help out more in this area, but installer package creation is
> not my forte.
>
> Regards,
>
> Tim Boyden
>
>
> -Original Message-
> From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com]
> Sent: Friday, December 15, 2017 11:39 AM
> To: user@ofbiz.apache.org
> Subject: Re: Ofbiz to postgresSql connection problem
>
> Thanks Tim,
>
> Such feedback is valuable for us in order to tune and maintain our
> documentation.
>
> I completely agree, and most of us do, that having a plethoric documentation
> is not a good thing.
>
> I also see that's it's harder to maintain a well structured and up to date
> documentation than to add bricks here and there.
>
> We want to make an effort in this direction in 2018, I hope we will get
> something better.
>
> Help is appreciated, notably about installers, because active committers
> already have a lot to do with the rest.
>
> This said I totally agree and understand your point of view about
> installation. It could be indeed that we are missing attention because we
> neglect this aspect. Actually it's not hard to imagine, just a bit of empathy
> is enough...
>
> Jacques
>
>
> Le 15/12/2017 à 14:22, Boyden, Timothy a écrit :
> > I have to agree, the documentation for setting up OFBiz with an external
> > database is about as clear as mud. For one there are multiple Wiki
> > documents that describe different methods to accomplish the task, rather
> > than one officially accepted method. For example, I tried to follow the
> > Linux (CentOS) version of this Wiki page
> > (https://cwiki.apache.org/confluence/display/OFBIZ/Setup+OFBiz+version+16.11.02+with+PostgreSQL+on+Windows)
> > and the compile command did not properly download and load the driver.
> > However, I had success following the older approach of manually adding the
> > JDBC driver jar file to ${ofbiz install dir}/framework/entity/lib/jdbc as
> > described in this Wiki page (
> > https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup).
> > Of course, the jar file keeps getting wiped out if you run the cleanAll
> > command. That took a few install attempts to realize, as I foug
Create Facility bug?
Wondering if anyone is aware of a UI bug with creating new facilities?
>From a clean install of OFBiz...
* Go to Facility tab
* The main page that comes up is a Facility search form
* When there have been no facilities added yet, the Facility ID box is
empty, and, of course, no Facilities are found.
* The button on this form points to creating a new Facility Group, and
not a new Facility
* Go to Facility Groups sub-tab
* Click on default _NA_ group
* Click on Facilities sub-tab
* This form is similar to what you see the first time clicking on the
main Facility tab
* Same issue exists here - instead of a button to create a new Facility,
the button instead prompts you to create a New Group
The work-around for this, after studying the URL paths, is to navigate to:
https://{OFBiz site URL}/facility/control/CreateFacility
That gets you to the correct create facility form, where you can create your
first facility. Once you created the first one, then you can get to a Create
New Facility button, via the Facility Selection form on the Facilities sub-tab.
Here is a screenshot of the offending UI:
[cid:image001.png@01D375A7.44C78130]
This is what is should look like:
[cid:image002.png@01D375A7.A427B410]
Thanks,
Tim Boyden
RE: Ofbiz to postgresSql connection problem
No problem, hopefully that came across as constructive criticism (as it was
meant), and not as a rant.
Maybe one possibility is enlisting the help of the jpackage team
(http://www.jpackage.org/). They have quite the library of Java applications
that they have repackaged as yum, apt, and rpm installers.
Another possibilty would be reaching out to existing talent in other Apache
projects, that currently write installers for their projects.
Even nicer would be a Docker image, as that is how most people get up to speed
on a new application server these days, and would allow a quick path to
creating a scalable/fault tolerant instance of OFBiz.
Wish I could help out more in this area, but installer package creation is not
my forte.
Regards,
Tim Boyden
-Original Message-
From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com]
Sent: Friday, December 15, 2017 11:39 AM
To: user@ofbiz.apache.org
Subject: Re: Ofbiz to postgresSql connection problem
Thanks Tim,
Such feedback is valuable for us in order to tune and maintain our
documentation.
I completely agree, and most of us do, that having a plethoric documentation is
not a good thing.
I also see that's it's harder to maintain a well structured and up to date
documentation than to add bricks here and there.
We want to make an effort in this direction in 2018, I hope we will get
something better.
Help is appreciated, notably about installers, because active committers
already have a lot to do with the rest.
This said I totally agree and understand your point of view about installation.
It could be indeed that we are missing attention because we neglect this
aspect. Actually it's not hard to imagine, just a bit of empathy is enough...
Jacques
Le 15/12/2017 à 14:22, Boyden, Timothy a écrit :
> I have to agree, the documentation for setting up OFBiz with an external
> database is about as clear as mud. For one there are multiple Wiki documents
> that describe different methods to accomplish the task, rather than one
> officially accepted method. For example, I tried to follow the Linux (CentOS)
> version of this Wiki page
> (https://cwiki.apache.org/confluence/display/OFBIZ/Setup+OFBiz+version+16.11.02+with+PostgreSQL+on+Windows)
> and the compile command did not properly download and load the driver.
> However, I had success following the older approach of manually adding the
> JDBC driver jar file to ${ofbiz install dir}/framework/entity/lib/jdbc as
> described in this Wiki page (
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup).
> Of course, the jar file keeps getting wiped out if you run the cleanAll
> command. That took a few install attempts to realize, as I fought with DB
> permission issues.
>
> I think more attention in the startup documentation needs to address this
> issue, rather than a passing comment, that it can (and is even recommended)
> that the software be setup with an external DBMS.
>
> The worst thing you can have, when trying to appeal to ERP solution
> evaluators, is a software solution that is frustrating to install. A Demo
> site that doesn't work is the first red flag, but I give that a pass, as we
> really need to see the software with our own data, in order to fully evaluate
> it.
>
> That is why I am recommending that Yum, Apt, Windows, etc... installers be
> made available with appropriate install options for clean install and demo
> install. The software should be installable from software repositories, just
> like any other modern Linux or Windows application. I have been implementing
> ERP systems for over 10 years now, and if I didn't like a challenge, would
> have given up on OFBiz after the first failed install attempt, following the
> published startup instructions. The last thing an ERP system implementer
> needs on a go-live weekend, is issues installing the software in the live
> environment. They already have a huge task ahead of them, getting the
> business's data loaded in the system.
>
> Regards,
>
> Tim Boyden
>
>
>
> -Original Message-
> From: Rishi Solanki [mailto:rishisolan...@gmail.com]
> Sent: Friday, December 15, 2017 7:05 AM
> To: ofbizuser <user@ofbiz.apache.org>
> Subject: Re: Ofbiz to postgresSql connection problem
>
> Bashir,
>
> Are you able to connect postgres version mentioned with specific mentioned
> driver in pure java class please note that here I'm asking to not use
> OFBiz and connect.
> If so then we can look into it further.
>
> Also please share the OFBiz version and other driver version you are trying
> with.
>
> HTH!
>
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd.
> Dir
RE: Ofbiz to postgresSql connection problem
I have to agree, the documentation for setting up OFBiz with an external
database is about as clear as mud. For one there are multiple Wiki documents
that describe different methods to accomplish the task, rather than one
officially accepted method. For example, I tried to follow the Linux (CentOS)
version of this Wiki page
(https://cwiki.apache.org/confluence/display/OFBIZ/Setup+OFBiz+version+16.11.02+with+PostgreSQL+on+Windows)
and the compile command did not properly download and load the driver.
However, I had success following the older approach of manually adding the JDBC
driver jar file to ${ofbiz install dir}/framework/entity/lib/jdbc as described
in this Wiki page (
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup).
Of course, the jar file keeps getting wiped out if you run the cleanAll
command. That took a few install attempts to realize, as I fought with DB
permission issues.
I think more attention in the startup documentation needs to address this
issue, rather than a passing comment, that it can (and is even recommended)
that the software be setup with an external DBMS.
The worst thing you can have, when trying to appeal to ERP solution evaluators,
is a software solution that is frustrating to install. A Demo site that doesn't
work is the first red flag, but I give that a pass, as we really need to see
the software with our own data, in order to fully evaluate it.
That is why I am recommending that Yum, Apt, Windows, etc... installers be made
available with appropriate install options for clean install and demo install.
The software should be installable from software repositories, just like any
other modern Linux or Windows application. I have been implementing ERP systems
for over 10 years now, and if I didn't like a challenge, would have given up on
OFBiz after the first failed install attempt, following the published startup
instructions. The last thing an ERP system implementer needs on a go-live
weekend, is issues installing the software in the live environment. They
already have a huge task ahead of them, getting the business's data loaded in
the system.
Regards,
Tim Boyden
-Original Message-
From: Rishi Solanki [mailto:rishisolan...@gmail.com]
Sent: Friday, December 15, 2017 7:05 AM
To: ofbizuser
Subject: Re: Ofbiz to postgresSql connection problem
Bashir,
Are you able to connect postgres version mentioned with specific mentioned
driver in pure java class please note that here I'm asking to not use
OFBiz and connect.
If so then we can look into it further.
Also please share the OFBiz version and other driver version you are trying
with.
HTH!
Rishi Solanki
Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co
On Thu, Dec 14, 2017 at 5:42 AM, bashir.karim...@gmail.com <
bashir.karim...@gmail.com> wrote:
> Hi Im new to ofbiz and i have some problem in connecting ofbiz to
> postgresql version 10, i couldnt find the latest JDBC driver Version
> 42.1.4 in Jcenter, .
> i tried other driver from the Jcenter the connection was failed and
> couldn't connect to database.
> waiting for your help.
>
