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].)))
