OFBiz › OFBiz - Dev

[jira] Created: (OFBIZ-3935) setup component error

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

8 messages Options

Nicolas Malin (Jira)

[jira] Created: (OFBIZ-3935) setup component error

setup component error
---------------------

Key: OFBIZ-3935
URL: https://issues.apache.org/jira/browse/OFBIZ-3935
Project: OFBiz
Issue Type: Bug
Components: commonext/setup
Affects Versions: Release Branch 10.04
Reporter: chris snow

I'm guessing this is the same problem as: http://www.mail-archive.com/user@.../msg29741.html

Steps to reproduce:

"git clone 10.04"
./ant run-install-extseed
./ant create-admin-user-login
./ant run

The Following Errors Occurred:

Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][createdTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][lastUpdatedStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][lastUpdatedTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][partyId,xxx(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CARRIER_SHIPMENT_METHOD' caused a violation of foreign key constraint 'CARR_SHMETH_TYPE' for key (LOCAL_DELIVERY). The statement has been rolled back.)) calling service parseEntityXmlFile in importTempDataFile

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

Nicolas Malin (Jira)

[jira] Commented: (OFBIZ-3935) setup component error

[ https://issues.apache.org/jira/browse/OFBIZ-3935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12908494#action_12908494 ]

BJ Freeman commented on OFBIZ-3935:
-----------------------------------

I assume you were doing
Go to http://localhost:8080/ofbizsetup

can you show the steps you were on when this happened

> setup component error
> ---------------------
>
> Key: OFBIZ-3935
> URL: https://issues.apache.org/jira/browse/OFBIZ-3935
> Project: OFBiz
> Issue Type: Bug
> Components: commonext/setup
> Affects Versions: Release Branch 10.04
> Reporter: chris snow
>
> I'm guessing this is the same problem as: http://www.mail-archive.com/user@.../msg29741.html
> Steps to reproduce:
> "git clone 10.04"
> ./ant run-install-extseed
> ./ant create-admin-user-login
> ./ant run
> The Following Errors Occurred:
> Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][createdTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][lastUpdatedStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][lastUpdatedTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][partyId,xxx(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CARRIER_SHIPMENT_METHOD' caused a violation of foreign key constraint 'CARR_SHMETH_TYPE' for key (LOCAL_DELIVERY). The statement has been rolled back.)) calling service parseEntityXmlFile in importTempDataFile

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

Nicolas Malin (Jira)

[jira] Commented: (OFBIZ-3935) setup component error

In reply to this post by Nicolas Malin (Jira)

[ https://issues.apache.org/jira/browse/OFBIZ-3935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12908520#action_12908520 ]

chris snow commented on OFBIZ-3935:
-----------------------------------

I followed the steps as outlined in:

http://demo-trunk.ofbiz.apache.org/cmssite/cms/APACHE_OFBIZ_HTML#N20094

1. Open a new terminal.
2. Go to your ofbiz directory.
3. Clean out all built classes with : ./ant clean-all
4. Load the seed data with : ant run-install-extseed
5. Create the admin user with : ./ant create-admin-user-login , then enter a user login id that will be created for you (the initial temporary password is "ofbiz")
6. Start ofbiz with : ./startofbiz.sh
7. Connect to the OFBiz Setup application with your browser at https://localhost:8443/ofbizsetup.

Create New Organization screen:
Organization name: xxx
Address 1: xxx
City: xxx
Zip/Postal Code: xxx xxx
Country: GBR: United Kingdom
Work Phone Number
Country Code: 111
Area Code: 111
Phone Number 111111
E-Mail Adderss: [hidden email]
> Save

> select Facility menu
New Facility Screen:
Name: xxx
> Save

> select Product Store menu
Edit Product Store Screen:
Store Name: xxx
> Update

ERROR as above

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

Nicolas Malin (Jira)

[jira] Updated: (OFBIZ-3935) setup component error

In reply to this post by Nicolas Malin (Jira)

[ https://issues.apache.org/jira/browse/OFBIZ-3935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

chris snow updated OFBIZ-3935:
------------------------------

Affects Version/s: SVN trunk

Trunk is throwing an error too, but at the Create Customer screen - see screenshot.

> setup component error
> ---------------------
>
> Key: OFBIZ-3935
> URL: https://issues.apache.org/jira/browse/OFBIZ-3935
> Project: OFBiz
> Issue Type: Bug
> Components: commonext/setup
> Affects Versions: Release Branch 10.04, SVN trunk
> Reporter: chris snow
>
> I'm guessing this is the same problem as: http://www.mail-archive.com/user@.../msg29741.html
> Steps to reproduce:
> "git clone 10.04"
> ./ant run-install-extseed
> ./ant create-admin-user-login
> ./ant run
> The Following Errors Occurred:
> Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][createdTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][lastUpdatedStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][lastUpdatedTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][partyId,xxx(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CARRIER_SHIPMENT_METHOD' caused a violation of foreign key constraint 'CARR_SHMETH_TYPE' for key (LOCAL_DELIVERY). The statement has been rolled back.)) calling service parseEntityXmlFile in importTempDataFile

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

Nicolas Malin (Jira)

[jira] Updated: (OFBIZ-3935) setup component error

In reply to this post by Nicolas Malin (Jira)

> setup component error
> ---------------------
>
> Key: OFBIZ-3935
> URL: https://issues.apache.org/jira/browse/OFBIZ-3935
> Project: OFBiz
> Issue Type: Bug
> Components: commonext/setup
> Affects Versions: Release Branch 10.04, SVN trunk
> Reporter: chris snow
> Attachments: Screenshot.png
>
>
> I'm guessing this is the same problem as: http://www.mail-archive.com/user@.../msg29741.html
> Steps to reproduce:
> "git clone 10.04"
> ./ant run-install-extseed
> ./ant create-admin-user-login
> ./ant run
> The Following Errors Occurred:
> Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][createdTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][lastUpdatedStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][lastUpdatedTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][partyId,xxx(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CARRIER_SHIPMENT_METHOD' caused a violation of foreign key constraint 'CARR_SHMETH_TYPE' for key (LOCAL_DELIVERY). The statement has been rolled back.)) calling service parseEntityXmlFile in importTempDataFile

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

Nicolas Malin (Jira)

[jira] Commented: (OFBIZ-3935) setup component error

In reply to this post by Nicolas Malin (Jira)

[ https://issues.apache.org/jira/browse/OFBIZ-3935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12908564#action_12908564 ]

BJ Freeman commented on OFBIZ-3935:
-----------------------------------

yes see
https://issues.apache.org/jira/browse/OFBIZ-3908

> setup component error
> ---------------------
>
> Key: OFBIZ-3935
> URL: https://issues.apache.org/jira/browse/OFBIZ-3935
> Project: OFBiz
> Issue Type: Bug
> Components: commonext/setup
> Affects Versions: Release Branch 10.04, SVN trunk
> Reporter: chris snow
> Attachments: Screenshot.png
>
>
> I'm guessing this is the same problem as: http://www.mail-archive.com/user@.../msg29741.html
> Steps to reproduce:
> "git clone 10.04"
> ./ant run-install-extseed
> ./ant create-admin-user-login
> ./ant run
> The Following Errors Occurred:
> Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][createdTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][lastUpdatedStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][lastUpdatedTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][partyId,xxx(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CARRIER_SHIPMENT_METHOD' caused a violation of foreign key constraint 'CARR_SHMETH_TYPE' for key (LOCAL_DELIVERY). The statement has been rolled back.)) calling service parseEntityXmlFile in importTempDataFile

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

Nicolas Malin (Jira)

[jira] Updated: (OFBIZ-3935) setup component error

In reply to this post by Nicolas Malin (Jira)

[ https://issues.apache.org/jira/browse/OFBIZ-3935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

chris snow updated OFBIZ-3935:
------------------------------

Attachment: HELP_SETUP.patch

Provide a warning for users following the setup instructions to let them know that the setup component is broken!

> setup component error
> ---------------------
>
> Key: OFBIZ-3935
> URL: https://issues.apache.org/jira/browse/OFBIZ-3935
> Project: OFBiz
> Issue Type: Bug
> Components: commonext/setup
> Affects Versions: Release Branch 10.04, SVN trunk
> Reporter: chris snow
> Attachments: HELP_SETUP.patch, Screenshot.png
>
>
> I'm guessing this is the same problem as: http://www.mail-archive.com/user@.../msg29741.html
> Steps to reproduce:
> "git clone 10.04"
> ./ant run-install-extseed
> ./ant create-admin-user-login
> ./ant run
> The Following Errors Occurred:
> Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][createdTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][lastUpdatedStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][lastUpdatedTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][partyId,xxx(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CARRIER_SHIPMENT_METHOD' caused a violation of foreign key constraint 'CARR_SHMETH_TYPE' for key (LOCAL_DELIVERY). The statement has been rolled back.)) calling service parseEntityXmlFile in importTempDataFile

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

Nicolas Malin (Jira)

[jira] Closed: (OFBIZ-3935) setup component error

In reply to this post by Nicolas Malin (Jira)

[ https://issues.apache.org/jira/browse/OFBIZ-3935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux closed OFBIZ-3935.
----------------------------------

Assignee: Jacques Le Roux
Fix Version/s: Release Branch 10.04
SVN trunk
Resolution: Fixed

Thanks Chris,

Your patch is in trunk at r998412, R10.04 at r998413

Please in future provide true svn patch, even if modifying (svn-?)git patches by hand it's not hard at all.

> setup component error
> ---------------------
>
> Key: OFBIZ-3935
> URL: https://issues.apache.org/jira/browse/OFBIZ-3935
> Project: OFBiz
> Issue Type: Bug
> Components: commonext/setup
> Affects Versions: Release Branch 10.04, SVN trunk
> Reporter: chris snow
> Assignee: Jacques Le Roux
> Fix For: Release Branch 10.04, SVN trunk
>
> Attachments: HELP_SETUP.patch, Screenshot.png
>
>
> I'm guessing this is the same problem as: http://www.mail-archive.com/user@.../msg29741.html
> Steps to reproduce:
> "git clone 10.04"
> ./ant run-install-extseed
> ./ant create-admin-user-login
> ./ant run
> The Following Errors Occurred:
> Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][createdTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][lastUpdatedStamp,2010-09-12 16:30:13.938(java.sql.Timestamp)][lastUpdatedTxStamp,2010-09-12 16:30:13.699(java.sql.Timestamp)][partyId,xxx(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'CARRIER_SHIPMENT_METHOD' caused a violation of foreign key constraint 'CARR_SHMETH_TYPE' for key (LOCAL_DELIVERY). The statement has been rolled back.)) calling service parseEntityXmlFile in importTempDataFile

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