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 <
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] 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.
>>>>>>>
>>>>>>> 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
>
>
>
>
--
Wolfgang Rauchholz
