Hi Jacques, I tried with a fresh DB again and got the same problem. Right now I am setting up a data model in ofbiz that would represent what we plan to do. Slow process, can do this only in my 'leisure time' I have no issue when entering the data manually so far.What I have experiences so far is that some of the error messages are very technical and not deciphable for end-users.
I will post/ask learnigs or problems I run into. Sales Channels (1) Sale from central DC to end-user (eCommerce) (2) Sale from central DC to wholesaler FINGDOOD transfers (3) Inventory transfer from central DC to retail shops for sale to end-user Title remains with 'Company'. Consignemt stock Shops are 'children' of central DC Production *All products produced by Sub-contractor * Sub-contracted supplier operates central DC * Title of inventory @ central DC remains with Company Sourcing / Replenishment Performed by 'Company'. Direct material drop-shipped to Sub-Contractor and stored there as consignment stock Thanks for your support. Wolfgang On Wed, Jun 6, 2018 at 11:07 AM, Jacques Le Roux < [email protected]> wrote: > Hi, > > Yes those are only warning and show that your DB differs from the data > loaded. You might try to begin with a fresh DB again if you have still > issues. Else you can live with it, though I'd no recommend that in > production. > > Jacques > > > > Le 05/06/2018 à 16:59, Wolfgang Paul Rauchholz a écrit : > >> When running the ./gradlew commant I redicrected the output into a .txt >> file to review. >> There is not a single error message I can find, but some messages I assume >> are Warnings, like e.g. >> >> 2018-06-04 14:57:47,991 |OFBiz-batch-1 |DatabaseUtil >> |W| Column [LAST_UPDATED_TX_STAMP] of table [SALES_ORDER_ITEM_FACT] of >> entity [SalesOrderItemFact] has a column size of [19] in the database, but >> is defined to have a column size of [3] in the entity definition. >> 2018-06-04 14:57:47,991 |OFBiz-batch-1 |DatabaseUtil >> |W| Column [CREATED_STAMP] of table [SALES_ORDER_ITEM_FACT] of entity >> [SalesOrderItemFact] has a column size of [19] in the database, but is >> defined to have a column size of [3] in the entity definition. >> 2018-06-04 14:57:47,991 |OFBiz-batch-1 |DatabaseUtil >> |W| Table named [ACCOMMODATION_CLASS] exists in the database but has no >> corresponding entity >> 2018-06-04 14:57:47,991 |OFBiz-batch-1 |DatabaseUtil >> |W| Table named [ACCOMMODATION_MAP] exists in the database but has no >> corresponding entity >> 2018-06-04 14:57:47,991 |OFBiz-batch-1 |DatabaseUtil >> |W| Table named [ACCOMMODATION_MAP_TYPE] exists in the database but has >> no corresponding entity >> 2018-06-04 14:57:47,991 |OFBiz-batch-1 |DatabaseUtil >> |W| Table named [ACCOMMODATION_SPOT] exists in the database but has no >> corresponding entity >> 2018-06-04 14:57:47,991 |OFBiz-batch-1 |DatabaseUtil >> |W| Table named [ACCTG_TRANS] exists in the database but has no >> corresponding entity >> >> >> >> >> 2018-06-04 14:57:48,179 |OFBiz-batch-2 |DatabaseUtil >> |W| Column [RESERVED_DATETIME] of table [ORDER_ITEM_SHIP_GRP_INV_RES] >> of >> entity [OrderItemShipGrpInvRes] has a column size of [19] in the database, >> but is defined to have a column size of [3] in the entity definition. >> 2018-06-04 14:57:48,179 |OFBiz-batch-2 |DatabaseUtil >> |W| Column [PROMISED_DATETIME] of table [ORDER_ITEM_SHIP_GRP_INV_RES] >> of >> entity [OrderItemShipGrpInvRes] has a column size of [19] in the database, >> but is defined to have a column size of [3] in the entity definition. >> 2018-06-04 14:57:48,179 |OFBiz-batch-2 |DatabaseUtil >> |W| Column [LAST_UPDATED_TX_STAMP] of table [ORDER_ITEM_TYPE] of entity >> [OrderItemType] has a column size of [19] in the database, but is defined >> to have a column size of [3] in the entity definition. >> 2018-06-04 14:57:48,179 |OFBiz-batch-2 |DatabaseUtil >> |W| Column [LAST_UPDATED_STAMP] of table [ORDER_ITEM_TYPE] of entity >> [OrderItemType] has a column size of [19] in the database, but is defined >> to have a column size of [3] in the entity definition. >> 2018-06-04 14:57:48,180 |OFBiz-batch-2 |DatabaseUtil >> |W| Column [CREATED_STAMP] of table [ORDER_ITEM_TYPE] of entity >> [OrderItemType] has a column size of [19] in the database, but is defined >> to have a column size of [3] in the entity definition. >> 2018-06-04 14:57:48,180 |OFBiz-batch-2 |DatabaseUtil >> |W| Column [CREATED_TX_STAMP] of table [ORDER_ITEM_TYPE] of entity >> [OrderItemType] has a column size of [19] in the database, but is defined >> to have a column size of [3] in the entity definition. >> >> On Tue, Jun 5, 2018 at 4:18 PM, Jacques Le Roux < >> [email protected]> wrote: >> >> To be frank, like you, I prefer to use a branch rather than a package >>> because it has the last fixes. >>> >>> So for me (only, not as an official PMC member) no, svn is stabler than a >>> package. >>> >>> This said I have still no ideas why you get issues ;) >>> >>> Jacques >>> >>> >>> >>> Le 05/06/2018 à 12:06, Wolfgang Paul Rauchholz a écrit : >>> >>> I run OfBiz on Centos 7 home server. Latest kernel version. >>>> >>>> Database Product Name is MySQL >>>> Database Product Version is 5.5.56-MariaDB >>>> Database Driver Name is MySQL Connector Java >>>> Database Driver Version is mysql-connector-java-5.1.25 ( Revision: >>>> ${bzr.revision-id} ) >>>> Database Driver JDBC Version is 4.0 >>>> >>>> Install sources. Is zip file a better (stabler0 version than svn? >>>> >>>> >>>> >>>> On Sun, Jun 3, 2018 at 2:39 PM, Jacques Le Roux < >>>> [email protected]> wrote: >>>> >>>> Le 01/06/2018 à 15:23, Wolfgang Paul Rauchholz a écrit : >>>> >>>>> Not sure what happend, but I really did not change anything. I do also >>>>> >>>>>> have >>>>>> problems with uploading XML files I had created before by exporting >>>>>> from >>>>>> ofbiz into the empye db. >>>>>> >>>>>> What might help here are small relevant log extracts >>>>>> >>>>> Did I do something wrong with setting up the installation? This is >>>>> what I >>>>> >>>>> did: >>>>>> (1) Install sources: >>>>>> svn co http://svn.apache.org/repos/asf/ofbiz/branches/release16.11 >>>>>> ofbiz >>>>>> >>>>>> That sounds good if you want to work from a not released branch >>>>>> instead >>>>>> >>>>> of >>>>> a package >>>>> >>>>> cd ofbiz >>>>> >>>>> svn co http://svn.apache.org/repos/asf/ofbiz/tools ofbiz-tools >>>>>> svn co http://svn.apache.org/repos/asf/ofbiz/site ofbiz-website >>>>>> >>>>>> You should not need those apart if you want to contribute to them >>>>>> >>>>> (2) runnning on mysql I made changes in gradle.build and >>>>> entityengine.xml >>>>> >>>>> accordingly. >>>>>> >>>>>> Sounds good >>>>>> >>>>> (3) create database ofbiz >>>>> >>>>> (4) ./gradlew build >>>>>> (5) ./gradlew "ofbiz --load-data readers=seed,seed-initial" >>>>>> loadAdminUserLogin -PuserLoginId=my_username >>>>>> >>>>>> You might even chain all of them, in one command but that's good >>>>>> >>>>> gradlew ran wi/o an error message. Initial data were (mostly I guess) >>>>> >>>>> loaded correctly. >>>>>> >>>>>> Sincerely I have no ideas, relevant traces (ie not repeating same >>>>>> things >>>>>> >>>>> ad nauseam) in logs should help >>>>> >>>>> BTW on which OS are you running? >>>>> >>>>> HTH >>>>> >>>>> Jacques >>>>> >>>>> >>>>> Wolfgang >>>>> >>>>>> On Thu, May 31, 2018 at 10:04 PM, Jacques Le Roux < >>>>>> [email protected]> wrote: >>>>>> >>>>>> You certainly changed something. It works in demos >>>>>> >>>>>> https://demo-trunk.ofbiz.apache.org/accounting/control/EditP >>>>>>> aymentGatewayConfig?paymentGatewayConfigId=CLEARCOMMERCE_CONFIG >>>>>>> >>>>>>> https://demo-stable.ofbiz.apache.org/accounting/control/Edit >>>>>>> PaymentGatewayConfig?paymentGatewayConfigId=CLEARCOMMERCE_CONFIG >>>>>>> >>>>>>> This said and unrelated I don't see Authorize Dot Net Config < >>>>>>> https://demo-stable.ofbiz.apache.org/accounting/control/Edi >>>>>>> tPaymentGatewayConfig?paymentGatewayConfigId=AUTHORIZE_NET_CONFIG> >>>>>>> in >>>>>>> trunk (exists in stable) >>>>>>> >>>>>>> https://demo-trunk.ofbiz.apache.org/accounting/control/FindP >>>>>>> aymentGatewayConfig >>>>>>> >>>>>>> Jacques >>>>>>> >>>>>>> >>>>>>> >>>>>>> Le 31/05/2018 à 18:25, [email protected] a écrit : >>>>>>> >>>>>>> I am in the Payment Gateway Config module. >>>>>>> >>>>>>> When hitting the link 'Authorize Dot Net Config' ofbiz shows the >>>>>>>> configuration of it. >>>>>>>> but when I hit "Clear Commerce Config" it throws out an error >>>>>>>> message >>>>>>>> >>>>>>>> Any idea whay this happens? I did not change anything, just wanted >>>>>>>> to >>>>>>>> look. >>>>>>>> >>>>>>>> Thanks, WOlfgang >>>>>>>> >>>>>>>> >>>>>>>> ERROR rendering error page [/error/error.jsp], but here is the error >>>>>>>> text: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error >>>>>>>> rendering screen [component://accounting/widget >>>>>>>> /PaymentGatewayConfigScreens.xml#EditPaymentGatewayConfig]: >>>>>>>> java.lang.IllegalArgumentException: Error doing entity query by >>>>>>>> condition: org.apache.ofbiz.base.util.GeneralException: Error >>>>>>>> finding >>>>>>>> entity value by primary key with entity-one: >>>>>>>> org.apache.ofbiz.entity.GenericEntityException: >>>>>>>> org.apache.shiro.crypto.CryptoException: Unable to execute >>>>>>>> 'doFinal' >>>>>>>> with cipher instance [javax.crypto.Cipher@53a1f3aa]. (Unable to >>>>>>>> execute >>>>>>>> 'doFinal' with cipher instance [javax.crypto.Cipher@53a1f3aa].) >>>>>>>> (org.apache.shiro.crypto.CryptoException: Unable to execute >>>>>>>> 'doFinal' >>>>>>>> with cipher instance [javax.crypto.Cipher@53a1f3aa]. (Unable to >>>>>>>> execute >>>>>>>> 'doFinal' with cipher instance [javax.crypto.Cipher@53a1f3aa].)) >>>>>>>> (Error >>>>>>>> doing entity query by condition: org.apache.ofbiz.base.util.Gen >>>>>>>> eralException: >>>>>>>> Error finding entity value by >>>>>>>> primary key with entity-one: org.apache.ofbiz.entity.Generi >>>>>>>> cEntityException: >>>>>>>> org.apache.shiro.crypto.CryptoException: Unable to execute >>>>>>>> 'doFinal' >>>>>>>> with cipher instance [javax.crypto.Cipher@53a1f3aa]. (Unable to >>>>>>>> execute >>>>>>>> 'doFinal' with cipher instance [javax.crypto.Cipher@53a1f3aa].) >>>>>>>> (org.apache.shiro.crypto.CryptoException: Unable to execute >>>>>>>> 'doFinal' >>>>>>>> with cipher instance [javax.crypto.Cipher@53a1f3aa]. (Unable to >>>>>>>> execute >>>>>>>> 'doFinal' with cipher instance [javax.crypto.Cipher@53a1f3aa].))) >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >> > -- Wolfgang Rauchholz
