ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created
---------------------------------------------------------------------------- Key: OFBIZ-4381 URL: https://issues.apache.org/jira/browse/OFBIZ-4381 Project: OFBiz Issue Type: Bug Components: commonext/setup Affects Versions: Release 10.04 Reporter: Marcelo Giubergia Priority: Minor I installed ofbiz from scratch according with recommended method >ant clean-all >ant run-install-extseed >ant create-admin-setup >./startofbiz.sh Then, when I create an store by https://localhost:8443/ofbizsetup/control/createProductStore Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][partyId,sds(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 public.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 (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla «carrier_shipment_method» viola la llave foránea «carr_shmeth_type»<br/> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in importTempDataFile -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira |
[ https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13093205#comment-13093205 ] Marcelo Giubergia commented on OFBIZ-4381: ------------------------------------------ the ${ofbiz-dir}/applications/commonext/ofbiz-component.xml doesn't contains <entity-resource type="data" reader-name="seed" loader="main" location="data/ShippingData.xml"/> > ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created > ---------------------------------------------------------------------------- > > Key: OFBIZ-4381 > URL: https://issues.apache.org/jira/browse/OFBIZ-4381 > Project: OFBiz > Issue Type: Bug > Components: commonext/setup > Affects Versions: Release 10.04 > Reporter: Marcelo Giubergia > Priority: Minor > > I installed ofbiz from scratch according with recommended method > >ant clean-all > >ant run-install-extseed > >ant create-admin-setup > >./startofbiz.sh > Then, when I create an store by https://localhost:8443/ofbizsetup/control/createProductStore > Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][partyId,sds(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 public.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 (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla «carrier_shipment_method» viola la llave foránea «carr_shmeth_type»<br/> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in importTempDataFile -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marcelo Giubergia updated OFBIZ-4381: ------------------------------------- Attachment: OFBIZ-4381.patch This patch add ShippingData in seed reader /applications/commonext/ofbiz-component.xml > ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created > ---------------------------------------------------------------------------- > > Key: OFBIZ-4381 > URL: https://issues.apache.org/jira/browse/OFBIZ-4381 > Project: OFBiz > Issue Type: Bug > Components: commonext/setup > Affects Versions: Release 10.04 > Reporter: Marcelo Giubergia > Priority: Minor > Attachments: OFBIZ-4381.patch > > > I installed ofbiz from scratch according with recommended method > >ant clean-all > >ant run-install-extseed > >ant create-admin-setup > >./startofbiz.sh > Then, when I create an store by https://localhost:8443/ofbizsetup/control/createProductStore > Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][partyId,sds(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 public.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 (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla «carrier_shipment_method» viola la llave foránea «carr_shmeth_type»<br/> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in importTempDataFile -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marcelo Giubergia updated OFBIZ-4381: ------------------------------------- Attachment: OFBIZ-4381.patch sorry, this is the correct patch > ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created > ---------------------------------------------------------------------------- > > Key: OFBIZ-4381 > URL: https://issues.apache.org/jira/browse/OFBIZ-4381 > Project: OFBiz > Issue Type: Bug > Components: commonext/setup > Affects Versions: Release 10.04 > Reporter: Marcelo Giubergia > Priority: Minor > Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch > > > I installed ofbiz from scratch according with recommended method > >ant clean-all > >ant run-install-extseed > >ant create-admin-setup > >./startofbiz.sh > Then, when I create an store by https://localhost:8443/ofbizsetup/control/createProductStore > Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][partyId,sds(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 public.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 (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla «carrier_shipment_method» viola la llave foránea «carr_shmeth_type»<br/> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in importTempDataFile -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13094280#comment-13094280 ] Jacques Le Roux commented on OFBIZ-4381: ---------------------------------------- Hi Marcello, There is any create-admin-setup target in both R10.04 and trunk, so I wonder... > ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created > ---------------------------------------------------------------------------- > > Key: OFBIZ-4381 > URL: https://issues.apache.org/jira/browse/OFBIZ-4381 > Project: OFBiz > Issue Type: Bug > Components: commonext/setup > Affects Versions: Release 10.04 > Reporter: Marcelo Giubergia > Priority: Minor > Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch > > > I installed ofbiz from scratch according with recommended method > >ant clean-all > >ant run-install-extseed > >ant create-admin-setup > >./startofbiz.sh > Then, when I create an store by https://localhost:8443/ofbizsetup/control/createProductStore > Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][partyId,sds(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 public.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 (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla «carrier_shipment_method» viola la llave foránea «carr_shmeth_type»<br/> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in importTempDataFile -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13094429#comment-13094429 ] Marcelo Giubergia commented on OFBIZ-4381: ------------------------------------------ Hi Jacques, create-admin-setup target doesn't exist. Sorry about my mistake, I meant create-admin-user-login Regards > ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created > ---------------------------------------------------------------------------- > > Key: OFBIZ-4381 > URL: https://issues.apache.org/jira/browse/OFBIZ-4381 > Project: OFBiz > Issue Type: Bug > Components: commonext/setup > Affects Versions: Release 10.04 > Reporter: Marcelo Giubergia > Priority: Minor > Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch > > > I installed ofbiz from scratch according with recommended method > >ant clean-all > >ant run-install-extseed > >ant create-admin-setup > >./startofbiz.sh > Then, when I create an store by https://localhost:8443/ofbizsetup/control/createProductStore > Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][partyId,sds(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 public.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 (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla «carrier_shipment_method» viola la llave foránea «carr_shmeth_type»<br/> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in importTempDataFile -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux closed OFBIZ-4381. ---------------------------------- Resolution: Fixed Assignee: Jacques Le Roux Thanks Marcelo, Your patch is in trunk r1167510 R11.04 r1167513 R10.04 r1167514 > ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created > ---------------------------------------------------------------------------- > > Key: OFBIZ-4381 > URL: https://issues.apache.org/jira/browse/OFBIZ-4381 > Project: OFBiz > Issue Type: Bug > Components: commonext/setup > Affects Versions: Release 10.04 > Reporter: Marcelo Giubergia > Assignee: Jacques Le Roux > Priority: Minor > Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch > > > I installed ofbiz from scratch according with recommended method > >ant clean-all > >ant run-install-extseed > >ant create-admin-setup > >./startofbiz.sh > Then, when I create an store by https://localhost:8443/ofbizsetup/control/createProductStore > Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][partyId,sds(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 public.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 (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla «carrier_shipment_method» viola la llave foránea «carr_shmeth_type»<br/> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in importTempDataFile -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13149088#comment-13149088 ] Jonas Colmsjö commented on OFBIZ-4381: -------------------------------------- I just installed the latest version of ofbiz (10.04) on OSX Lion and have the same error. Applying the patch made no difference though. I'm a beginner at ofbiz. What more do I need to do? /BR Jonas > ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created > ---------------------------------------------------------------------------- > > Key: OFBIZ-4381 > URL: https://issues.apache.org/jira/browse/OFBIZ-4381 > Project: OFBiz > Issue Type: Bug > Components: commonext/setup > Affects Versions: Release 10.04 > Reporter: Marcelo Giubergia > Assignee: Jacques Le Roux > Priority: Minor > Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch > > > I installed ofbiz from scratch according with recommended method > >ant clean-all > >ant run-install-extseed > >ant create-admin-setup > >./startofbiz.sh > Then, when I create an store by https://localhost:8443/ofbizsetup/control/createProductStore > Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][partyId,sds(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 public.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 (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla «carrier_shipment_method» viola la llave foránea «carr_shmeth_type»<br/> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in importTempDataFile -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13149118#comment-13149118 ] Jacques Le Roux commented on OFBIZ-4381: ---------------------------------------- It may depend from where you downloaded the file, which revision are you using? > ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created > ---------------------------------------------------------------------------- > > Key: OFBIZ-4381 > URL: https://issues.apache.org/jira/browse/OFBIZ-4381 > Project: OFBiz > Issue Type: Bug > Components: commonext/setup > Affects Versions: Release 10.04 > Reporter: Marcelo Giubergia > Assignee: Jacques Le Roux > Priority: Minor > Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch > > > I installed ofbiz from scratch according with recommended method > >ant clean-all > >ant run-install-extseed > >ant create-admin-setup > >./startofbiz.sh > Then, when I create an store by https://localhost:8443/ofbizsetup/control/createProductStore > Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][partyId,sds(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 public.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 (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla «carrier_shipment_method» viola la llave foránea «carr_shmeth_type»<br/> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in importTempDataFile -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13200929#comment-13200929 ] Jacques Le Roux commented on OFBIZ-4381: ---------------------------------------- This has been reverted, see OFBIZ-4675 > ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created > ---------------------------------------------------------------------------- > > Key: OFBIZ-4381 > URL: https://issues.apache.org/jira/browse/OFBIZ-4381 > Project: OFBiz > Issue Type: Bug > Components: commonext/setup > Affects Versions: Release 10.04 > Reporter: Marcelo Giubergia > Assignee: Jacques Le Roux > Priority: Minor > Attachments: OFBIZ-4381.patch, OFBIZ-4381.patch > > > I installed ofbiz from scratch according with recommended method > >ant clean-all > >ant run-install-extseed > >ant create-admin-setup > >./startofbiz.sh > Then, when I create an store by https://localhost:8443/ofbizsetup/control/createProductStore > Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][createdTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][lastUpdatedStamp,2011-08-29 11:16:33.247(java.sql.Timestamp)][lastUpdatedTxStamp,2011-08-29 11:16:32.951(java.sql.Timestamp)][partyId,sds(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 public.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 (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: inserción o actualización en la tabla «carrier_shipment_method» viola la llave foránea «carr_shmeth_type»<br/> Detail: La llave (shipment_method_type_id)=(LOCAL_DELIVERY) no está presente en la tabla «shipment_method_type».)) calling service parseEntityXmlFile in importTempDataFile -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
Free forum by Nabble | Edit this page |