Payment Gateway Config Error
Locked
 
|
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.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].))) |
Re: Payment Gateway Config Error
Administrator
|
You certainly changed something. It works in demos
https://demo-trunk.ofbiz.apache.org/accounting/control/EditPaymentGatewayConfig?paymentGatewayConfigId=CLEARCOMMERCE_CONFIG https://demo-stable.ofbiz.apache.org/accounting/control/EditPaymentGatewayConfig?paymentGatewayConfigId=CLEARCOMMERCE_CONFIG This said and unrelated I don't see Authorize Dot Net Config <https://demo-stable.ofbiz.apache.org/accounting/control/EditPaymentGatewayConfig?paymentGatewayConfigId=AUTHORIZE_NET_CONFIG> in trunk (exists in stable) https://demo-trunk.ofbiz.apache.org/accounting/control/FindPaymentGatewayConfig Jacques Le 31/05/2018 à 18:25, [hidden email] 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.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].))) > > > |
Re: Payment Gateway Config Error
|
|
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. 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 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 (2) runnning on mysql I made changes in gradle.build and entityengine.xml accordingly. (3) create database ofbiz (4) ./gradlew build (5) ./gradlew "ofbiz --load-data readers=seed,seed-initial" loadAdminUserLogin -PuserLoginId=my_username gradlew ran wi/o an error message. Initial data were (mostly I guess) loaded correctly. Wolfgang On Thu, May 31, 2018 at 10:04 PM, Jacques Le Roux < [hidden email]> 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, [hidden email] 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.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].))) >> >> >> >> > -- Wolfgang Rauchholz |
Re: Payment Gateway Config Error
|
Administrator
|
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 < > [hidden email]> 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, [hidden email] 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.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].))) >>> >>> >>> >>> > |
Re: Payment Gateway Config Error
|
|
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 < [hidden email]> 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 < >> [hidden email]> 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, [hidden email] 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 |
Re: Payment Gateway Config Error
|
Administrator
|
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 < > [hidden email]> 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 < >>> [hidden email]> 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, [hidden email] 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].))) >>>>> >>>>> >>>>> >>>>> >>>>> > |
Re: Payment Gateway Config Error
|
|
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 < [hidden email]> 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 < >> [hidden email]> 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 < >>>> [hidden email]> 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, [hidden email] 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 |
Re: Payment Gateway Config Error
|
Administrator
|
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 < > [hidden email]> 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 < >>> [hidden email]> 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 < >>>>> [hidden email]> 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, [hidden email] 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].))) >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> > |
Re: Payment Gateway Config Error
|
|
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 < [hidden email]> 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 < >> [hidden email]> 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 < >>>> [hidden email]> 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 < >>>>>> [hidden email]> 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, [hidden email] 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 |
Re: Payment Gateway Config Error
|
|
Not sure it makes sense what I am saying here, but at the end I was able to
upload the file. I opened the XML file and copied it into 'XML Import to DataSource(s)' > 'Import Text' There was a spaceline after each record (see also underneath) . After deleteing the space line, it uploaded fine. With the space line it would not. <GlAccount createdTxStamp="2018-05-16 22:24:56.734" createdStamp="2018-05-16 22:24:59.626" lastUpdatedTxStamp="2018-05-16 22:24:56.734" lastUpdatedStamp="2018-05-16 22:24:59.626" accountName="ACCOUNTING FEES" accountCode="642000" glResourceTypeId="MONEY" glAccountClassId="SGA_EXPENSE" glAccountId="642000" parentGlAccountId="640000"/> <GlAccount createdTxStamp="2018-05-16 22:24:56.734" createdStamp="2018-05-16 22:24:59.627" lastUpdatedTxStamp="2018-05-16 22:24:56.734" lastUpdatedStamp="2018-05-16 22:24:59.627" accountName="INVENTORY VERIFICATION" accountCode="643000" glResourceTypeId="MONEY" glAccountClassId="SGA_EXPENSE" glAccountId="643000" parentGlAccountId="640000"/> <GlAccount createdTxStamp="2018-05-16 22:24:56.734" createdStamp="2018-05-16 22:24:59.628" lastUpdatedTxStamp="2018-05-16 22:24:56.734" lastUpdatedStamp="2018-05-16 22:24:59.628" accountName="OTHER CONSULTING FEES" accountCode="649000" glResourceTypeId="MONEY" glAccountClassId="SGA_EXPENSE" glAccountId="649000" parentGlAccountId="640000"/> On Wed, Jun 6, 2018 at 11:37 AM, Wolfgang Paul Rauchholz < [hidden email]> wrote: > 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 < > [hidden email]> 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 < >>> [hidden email]> 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 < >>>>> [hidden email]> 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 < >>>>>>> [hidden email]> 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, [hidden email] 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 > > > > -- Wolfgang Rauchholz |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |