Yes ! Thanks Chris, did not figured that out.
Jacques > Jacques, since the field type of > CarrierShipmentBoxType.packagingTypeCode was changed from very-short to > id in r504996, you may need to alter the SQL type of that column in your > database, if it hasn't happened automatically. > > Chris > > > Jacques Le Roux wrote: > > Si, > > > > I cant see any changes (commits) for DemoShipping.xm since this commit. So > > logically the problem remains. > > > > Jacques > > > > ----- Original Message ----- > > From: "Si Chen" <[EMAIL PROTECTED]> > > To: <dev@ofbiz.apache.org> > > Sent: Friday, February 09, 2007 6:26 PM > > Subject: Re: svn commit: r504996 [1/2] - in /ofbiz/trunk/applications: > > ecommerce/data/ product/ product/config/ product/entitydef/ > > product/servicedef/ product/src/org/ofbiz/shipment/thirdparty/fedex/ > > product/templates/ product/templates/shipment/ > > product/webapp/fac > > > > > > > >> Jacques Le Roux wrote: > >> > >>> I did not want to send it because some parts are in french, here we go : > >>> > >>> [java] 2007-02-09 10:33:11,593 (main) [ > >>> GenericDelegator.java:577:ERROR] > >>> [java] ---- exception report > >>> ---------------------------------------------------------- > >>> [java] Failure in create operation for entity > >>> [CarrierShipmentBoxType]: org.ofbiz.entity.GenericEntityException: Exception > >>> while inserting the following entity: > >>> [GenericEntity:CarrierShipmentBoxType][cre > >>> atedStamp,2007-02-09 > >>> 10:33:11.546(java.sql.Timestamp)][createdTxStamp,2007-02-09 > >>> 10:33:11.109(java.sql.Timestamp)][lastUpdatedStamp,2007-02-09 > >>> 10:33:11.546(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-09 1 > >>> > >>> > > 0:33:11.109(java.sql.Timestamp)][packagingTypeCode,FEDEXENVELOPE(java.lang.String)][partyId,FEDEX(java.lang.String)][shipmentBoxType > > > >>> Id,FXENV(java.lang.String)] (while inserting: > >>> [GenericEntity:CarrierShipment > >>> BoxType][createdStamp,2007-02-09 > >>> 10:33:11.546(java.sql.Timestamp)][createdTxStamp,2007-02-09 > >>> 10:33:11.109(java.sql.Timestamp)][lastUpdatedStamp,2007-02-09 > >>> 10:33:11.546(java.sql.Timestamp)][lastUpdatedTxStamp, > >>> 2007-02-09 > >>> > >>> > > 10:33:11.109(java.sql.Timestamp)][packagingTypeCode,FEDEXENVELOPE(java.lang.String)][partyId,FEDEX(java.lang.String)][shipmentBoxTyp > > > >>> eId,FXENV(java.lang.String)] (SQL Exception while executing the f > >>> ollowing:INSERT INTO OFBIZ.CARRIER_SHIPMENT_BOX_TYPE > >>> (SHIPMENT_BOX_TYPE_ID, PARTY_ID, PACKAGING_TYPE_CODE, OVERSIZE_CODE, > >>> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, > >>> CREATED_TX_STAMP) VALUES (?, > >>> ?, ?, ?, ?, ?, ?, ?) ($$$Une erreur de troncature a t dtecte lors de la > >>> tentative de rduction de VARCHAR 'FEDEXENVELOPE' une > >>> longueur de 10.))). Rolling back transaction. > >>> [java] Exception: org.ofbiz.entity.GenericEntityException > >>> [java] Message: Exception while inserting the following entity: > >>> > > [GenericEntity:CarrierShipmentBoxType][createdStamp,2007-02-09 > > > >>> 10:33:11.546(java.sql.Timestamp)][createdTxStamp,2007-02-09 > >>> 10:33:11.109(jav > >>> a.sql.Timestamp)][lastUpdatedStamp,2007-02-09 > >>> 10:33:11.546(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-09 > >>> 10:33:11.109(java.sql.Timestamp)][packagingTypeCode,FEDEXENVELOPE(java.lang.String)][partyId,FEDEX > >>> (java.lang.String)][shipmentBoxTypeId,FXENV(java.lang.String)] (while > >>> inserting: > >>> [GenericEntity:CarrierShipmentBoxType][createdStamp,2007-02-09 > >>> 10:33:11.546(java.sql.Timestamp)][createdTxStamp,2007-02-09 10:3 > >>> 3:11.109(java.sql.Timestamp)][lastUpdatedStamp,2007-02-09 > >>> 10:33:11.546(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-09 > >>> 10:33:11.109(java.sql.Timestamp)][packagingTypeCode,FEDEXENVELOPE(java.lang.String)][p > >>> artyId,FEDEX(java.lang.String)][shipmentBoxTypeId,FXENV(java.lang.String)] > >>> (SQL Exception while executing the following:INSERT > >>> > > INTO > > > >>> OFBIZ.CARRIER_SHIPMENT_BOX_TYPE (SHIPMENT_BOX_TYPE_ID, PARTY_ID, > >>> PACKAGING_T > >>> YPE_CODE, OVERSIZE_CODE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > >>> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, > >>> > > ?, ?) > > > >>> ($$$Une erreur de troncature a t dtecte lors de la tentative de rducti > >>> on de VARCHAR 'FEDEXENVELOPE' une longueur de 10.))) > >>> [java] ---- stack trace > >>> --------------------------------------------------------------- > >>> > >>> Did you try to load data ? > >>> > >>> Jacques > >>> > >>> > >>> > >>> > >>>> What is the actual error you're getting? > >>>> > >>>> -David > >>>> > >>>> > >>>> On Feb 9, 2007, at 8:19 AM, Jacques Le Roux wrote: > >>>> > >>>> > >>>> > >>>>> Si, > >>>>> > >>>>> I found a problem while loading demoshipping data : > >>>>> 'FEDEXENVELOPE' seems too long or something > >>>>> > >>>>> Jacques > >>>>> > >>>>> ----- Original Message ----- > >>>>> From: <[EMAIL PROTECTED]> > >>>>> To: <commits@ofbiz.apache.org> > >>>>> Sent: Thursday, February 08, 2007 7:41 PM > >>>>> Subject: svn commit: r504996 [1/2] - in /ofbiz/trunk/applications: > >>>>> ecommerce/data/ product/ product/config/ product/entitydef/ > >>>>> product/servicedef/ product/src/org/ofbiz/shipment/thirdparty/ > >>>>> fedex/ product/templates/ product/templates/shipment/ > >>>>> product/webapp/fac... > >>>>> > >>>>> > >>>>> > >>>>> > >>>>>> Author: sichen > >>>>>> Date: Thu Feb 8 10:41:20 2007 > >>>>>> New Revision: 504996 > >>>>>> > >>>>>> URL: http://svn.apache.org/viewvc?view=rev&rev=504996 > >>>>>> Log: > >>>>>> Support for FedEx subscription and ship requests via FedEx Ship > >>>>>> Manager Direct API > >>>>>> > >>>>>> Added: > >>>>>> ofbiz/trunk/applications/product/servicedef/ > >>>>>> services_shipment_fedex.xml (with props) > >>>>>> ofbiz/trunk/applications/product/src/org/ofbiz/shipment/ > >>>>>> thirdparty/fedex/ > >>>>>> ofbiz/trunk/applications/product/src/org/ofbiz/shipment/ > >>>>>> thirdparty/fedex/FedexServices.java (with props) > >>>>>> ofbiz/trunk/applications/product/templates/ > >>>>>> ofbiz/trunk/applications/product/templates/shipment/ > >>>>>> ofbiz/trunk/applications/product/templates/shipment/ > >>>>>> FedexShipRequestTemplate.xml (with props) > >>>>>> ofbiz/trunk/applications/product/templates/shipment/ > >>>>>> FedexSubscriptionRequestTemplate.xml (with props) > >>>>>> Modified: > >>>>>> ofbiz/trunk/applications/ecommerce/data/DemoShipping.xml > >>>>>> ofbiz/trunk/applications/product/config/ > >>>>>> ProductUiLabels.properties > >>>>>> ofbiz/trunk/applications/product/config/shipment.properties > >>>>>> ofbiz/trunk/applications/product/entitydef/ > >>>>>> entitymodel_shipment.xml > >>>>>> ofbiz/trunk/applications/product/ofbiz-component.xml > >>>>>> ofbiz/trunk/applications/product/webapp/facility/WEB-INF/ > >>>>>> controller.xml > >>>>>> ofbiz/trunk/applications/product/webapp/facility/shipment/ > >>>>>> EditShipmentPackages.ftl > >>>>>> ofbiz/trunk/applications/product/webapp/facility/shipment/ > >>>>>> EditShipmentRouteSegments.ftl > >>>>>> > >>>>>> Modified: ofbiz/trunk/applications/ecommerce/data/DemoShipping.xml > >>>>>> URL: > >>>>>> > >>>>>> > >>>>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/ecommerce/ > >>>>> data/DemoShipping.xml?view=diff&rev=504996&r1=504995&r2=504996 > >>>>> > >>>>> > >>>>> > >>> > >> Can you try it now? It's been changed to "id" which is a longer field now. > >> > >> Si > >> > >> > > > > >
