You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jonas Colmsjö (Commented JIRA)" <ji...@apache.org> on 2011/11/12 15:56:51 UTC

[jira] [Commented] (OFBIZ-4381) ofbizsetup "INSERT CARRIER_SHIPMENT_METHOD" ERROR when new store is created

    [ 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