You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Dirk Kissing (JIRA)" <ji...@apache.org> on 2007/05/02 01:12:15 UTC

[jira] Created: (OFBIZ-954) Bug with demo data and MySql

Bug with demo data and MySql
----------------------------

                 Key: OFBIZ-954
                 URL: https://issues.apache.org/jira/browse/OFBIZ-954
             Project: OFBiz (The Open for Business Project)
          Issue Type: Bug
    Affects Versions: SVN trunk
         Environment: Windows 2003, JDK1.6, MySql 5.037
            Reporter: Dirk Kissing
            Priority: Minor



The following error happens when i run install (with MySql). 
It runs very smoothful, until the last lines. With Derby it doesn't happen.
 
 
O ] The following errors occured in the data load: 
[java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:289:INF 
O ] [install.loadData]: Error loading XML Resource "file:/D:/OFBiz/applications/ 
accounting/data/PaymentsInvoices.xml"; Error was: A transaction error occurred r 
eading data 
[java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:289:INF 
O ] [install.loadData]: Error loading XML Resource "file:/D:/OFBiz/applications/ 
ecommerce/data/DemoProductCategoriesI18nData.xml"; Error was: A transaction erro 
r occurred reading data 
[java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:293:INF 
O ] =-=-=-=-=-=-= Finished the data load with 10139 rows changed. 
[java] 2007-05-01 10:01:48,031 (main) [ ContainerLoader.java:93 :INFO ] 
Shutting down containers 
 
BUILD SUCCESSFUL 
Total time: 11 minutes 2 seconds 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (OFBIZ-954) Bug with demo data and MySql

Posted by "Dirk Kissing (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OFBIZ-954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dirk Kissing updated OFBIZ-954:
-------------------------------

    Attachment: OFBIZ-954.patch

You're right, it's an UTF-8 error, caused by: "français".

I've attached a workaround (simple rename to "francais").

Needs further investigation.


> Bug with demo data and MySql
> ----------------------------
>
>                 Key: OFBIZ-954
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-954
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>    Affects Versions: SVN trunk
>         Environment: Windows 2003, JDK1.6, MySql 5.037
>            Reporter: Dirk Kissing
>            Priority: Minor
>         Attachments: OFBIZ-954.patch
>
>
> The following error happens when i run install (with MySql). 
> It runs very smoothful, until the last lines. With Derby it doesn't happen.
>  
>  
> O ] The following errors occured in the data load: 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:289:INF 
> O ] [install.loadData]: Error loading XML Resource "file:/D:/OFBiz/applications/ 
> accounting/data/PaymentsInvoices.xml"; Error was: A transaction error occurred r 
> eading data 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:289:INF 
> O ] [install.loadData]: Error loading XML Resource "file:/D:/OFBiz/applications/ 
> ecommerce/data/DemoProductCategoriesI18nData.xml"; Error was: A transaction erro 
> r occurred reading data 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:293:INF 
> O ] =-=-=-=-=-=-= Finished the data load with 10139 rows changed. 
> [java] 2007-05-01 10:01:48,031 (main) [ ContainerLoader.java:93 :INFO ] 
> Shutting down containers 
>  
> BUILD SUCCESSFUL 
> Total time: 11 minutes 2 seconds 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Assigned: (OFBIZ-954) Bug with demo data and MySql

Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OFBIZ-954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux reassigned OFBIZ-954:
-------------------------------------

    Assignee: Jacques Le Roux

> Bug with demo data and MySql
> ----------------------------
>
>                 Key: OFBIZ-954
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-954
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>    Affects Versions: SVN trunk
>         Environment: Windows 2003, JDK1.6, MySql 5.037
>            Reporter: Dirk Kissing
>         Assigned To: Jacques Le Roux
>            Priority: Minor
>         Attachments: OFBIZ-954.patch
>
>
> The following error happens when i run install (with MySql). 
> It runs very smoothful, until the last lines. With Derby it doesn't happen.
>  
>  
> O ] The following errors occured in the data load: 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:289:INF 
> O ] [install.loadData]: Error loading XML Resource "file:/D:/OFBiz/applications/ 
> accounting/data/PaymentsInvoices.xml"; Error was: A transaction error occurred r 
> eading data 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:289:INF 
> O ] [install.loadData]: Error loading XML Resource "file:/D:/OFBiz/applications/ 
> ecommerce/data/DemoProductCategoriesI18nData.xml"; Error was: A transaction erro 
> r occurred reading data 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:293:INF 
> O ] =-=-=-=-=-=-= Finished the data load with 10139 rows changed. 
> [java] 2007-05-01 10:01:48,031 (main) [ ContainerLoader.java:93 :INFO ] 
> Shutting down containers 
>  
> BUILD SUCCESSFUL 
> Total time: 11 minutes 2 seconds 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (OFBIZ-954) Bug with demo data and MySql

Posted by "Chris Howe (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OFBIZ-954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12493010 ] 

Chris Howe commented on OFBIZ-954:
----------------------------------

Because of the existence of the 18n data, I would suspect it may have something to do with character/collation issues.  Can you split up the demo data into smaller files and add the data through webtools to localize which entry is having the problem?

> Bug with demo data and MySql
> ----------------------------
>
>                 Key: OFBIZ-954
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-954
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>    Affects Versions: SVN trunk
>         Environment: Windows 2003, JDK1.6, MySql 5.037
>            Reporter: Dirk Kissing
>            Priority: Minor
>
> The following error happens when i run install (with MySql). 
> It runs very smoothful, until the last lines. With Derby it doesn't happen.
>  
>  
> O ] The following errors occured in the data load: 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:289:INF 
> O ] [install.loadData]: Error loading XML Resource "file:/D:/OFBiz/applications/ 
> accounting/data/PaymentsInvoices.xml"; Error was: A transaction error occurred r 
> eading data 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:289:INF 
> O ] [install.loadData]: Error loading XML Resource "file:/D:/OFBiz/applications/ 
> ecommerce/data/DemoProductCategoriesI18nData.xml"; Error was: A transaction erro 
> r occurred reading data 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:293:INF 
> O ] =-=-=-=-=-=-= Finished the data load with 10139 rows changed. 
> [java] 2007-05-01 10:01:48,031 (main) [ ContainerLoader.java:93 :INFO ] 
> Shutting down containers 
>  
> BUILD SUCCESSFUL 
> Total time: 11 minutes 2 seconds 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (OFBIZ-954) Bug with demo data and MySql

Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OFBIZ-954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux closed OFBIZ-954.
---------------------------------

    Resolution: Won't Fix

> Bug with demo data and MySql
> ----------------------------
>
>                 Key: OFBIZ-954
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-954
>             Project: OFBiz
>          Issue Type: Bug
>    Affects Versions: SVN trunk
>         Environment: Windows 2003, JDK1.6, MySql 5.037
>            Reporter: Dirk Kissing
>            Assignee: Jacques Le Roux
>            Priority: Minor
>         Attachments: OFBIZ-954.patch
>
>
> The following error happens when i run install (with MySql). 
> It runs very smoothful, until the last lines. With Derby it doesn't happen.
>  
>  
> O ] The following errors occured in the data load: 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:289:INF 
> O ] [install.loadData]: Error loading XML Resource "file:/D:/OFBiz/applications/ 
> accounting/data/PaymentsInvoices.xml"; Error was: A transaction error occurred r 
> eading data 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:289:INF 
> O ] [install.loadData]: Error loading XML Resource "file:/D:/OFBiz/applications/ 
> ecommerce/data/DemoProductCategoriesI18nData.xml"; Error was: A transaction erro 
> r occurred reading data 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:293:INF 
> O ] =-=-=-=-=-=-= Finished the data load with 10139 rows changed. 
> [java] 2007-05-01 10:01:48,031 (main) [ ContainerLoader.java:93 :INFO ] 
> Shutting down containers 
>  
> BUILD SUCCESSFUL 
> Total time: 11 minutes 2 seconds 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (OFBIZ-954) Bug with demo data and MySql

Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OFBIZ-954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12493049 ] 

Jacques Le Roux commented on OFBIZ-954:
---------------------------------------

Please don't commit this patch because this is working well in, at least, PostGres and Derby. So I will rather suspect a problem in MySql.

To check see https://demo.hotwaxmedia.com/catalog/control/main and set to french

Thanks

> Bug with demo data and MySql
> ----------------------------
>
>                 Key: OFBIZ-954
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-954
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>    Affects Versions: SVN trunk
>         Environment: Windows 2003, JDK1.6, MySql 5.037
>            Reporter: Dirk Kissing
>         Assigned To: Jacques Le Roux
>            Priority: Minor
>         Attachments: OFBIZ-954.patch
>
>
> The following error happens when i run install (with MySql). 
> It runs very smoothful, until the last lines. With Derby it doesn't happen.
>  
>  
> O ] The following errors occured in the data load: 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:289:INF 
> O ] [install.loadData]: Error loading XML Resource "file:/D:/OFBiz/applications/ 
> accounting/data/PaymentsInvoices.xml"; Error was: A transaction error occurred r 
> eading data 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:289:INF 
> O ] [install.loadData]: Error loading XML Resource "file:/D:/OFBiz/applications/ 
> ecommerce/data/DemoProductCategoriesI18nData.xml"; Error was: A transaction erro 
> r occurred reading data 
> [java] 2007-05-01 10:01:48,031 (main) [EntityDataLoadContainer.java:293:INF 
> O ] =-=-=-=-=-=-= Finished the data load with 10139 rows changed. 
> [java] 2007-05-01 10:01:48,031 (main) [ ContainerLoader.java:93 :INFO ] 
> Shutting down containers 
>  
> BUILD SUCCESSFUL 
> Total time: 11 minutes 2 seconds 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.