Re: Payment Gateway Config Error

2018-06-06 Thread Wolfgang Paul Rauchholz
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.









On Wed, Jun 6, 2018 at 11:37 AM, Wolfgang Paul Rauchholz <
wp.rauchh...@gmail.com> 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 <
> jacques.le.r...@les7arts.com> 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] 

Re: Payment Gateway Config Error

2018-06-06 Thread Wolfgang Paul Rauchholz
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 <
jacques.le.r...@les7arts.com> 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 <
>> jacques.le.r...@les7arts.com> 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 

Re: Payment Gateway Config Error

2018-06-06 Thread Jacques Le Roux

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 <
jacques.le.r...@les7arts.com> 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 <
jacques.le.r...@les7arts.com> 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 

Re: Payment Gateway Config Error

2018-06-05 Thread Wolfgang Paul Rauchholz
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 <
jacques.le.r...@les7arts.com> 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 <
>> jacques.le.r...@les7arts.com> 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.


Re: Payment Gateway Config Error

2018-06-05 Thread Jacques Le Roux

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 <
jacques.le.r...@les7arts.com> 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 <
jacques.le.r...@les7arts.com> 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, wp.rauchh...@gmail.com 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

2018-06-05 Thread Wolfgang Paul Rauchholz
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 <
jacques.le.r...@les7arts.com> 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 <
>> jacques.le.r...@les7arts.com> 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, wp.rauchh...@gmail.com 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

2018-06-03 Thread Jacques Le Roux



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 <
jacques.le.r...@les7arts.com> 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, wp.rauchh...@gmail.com 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

2018-06-01 Thread Wolfgang Paul Rauchholz
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 <
jacques.le.r...@les7arts.com> 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, wp.rauchh...@gmail.com 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

2018-05-31 Thread Jacques Le Roux

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 
 in trunk (exists in stable)


https://demo-trunk.ofbiz.apache.org/accounting/control/FindPaymentGatewayConfig

Jacques


Le 31/05/2018 à 18:25, wp.rauchh...@gmail.com 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].)))