Re: svn commit: r504996 - in /ofbiz/trunk/applications: ecommerce/data/ product/ product/config/ product/entitydef/ product/servicedef/ product/src/org/ofbiz/shipment
Locked
Re: svn commit: r504996 - in /ofbiz/trunk/applications: ecommerce/data/ product/ product/config/ product/entitydef/ product/servicedef/ product/src/org/ofbiz/shipment
 
Administrator
|
Si,
I found a problem while loading demoshipping data : 'FEDEXENVELOPE' seems too long or something Jacques ----- Original Message ----- From: <[hidden email]> To: <[hidden email]> 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: |
Re: svn commit: r504996 - in /ofbiz/trunk/applications: ecommerce/data/ product/ product/config/ product/entitydef/ product/servicedef/ product/src/org/ofbiz/shipment
|
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: <[hidden email]> > To: <[hidden email]> > 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 > |
smime.p7s (3K)
Re: svn commit: r504996 - in /ofbiz/trunk/applications: ecommerce/data/ product/ product/config/ product/entitydef/ product/servicedef/ product/src/org/ofbiz/shipment
|
Administrator
|
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: <[hidden email]> > > To: <[hidden email]> > > 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 > > > > |
Re: svn commit: r504996 - in /ofbiz/trunk/applications: ecommerce/data/ product/ product/config/ product/entitydef/ product/servicedef/ product/src/org/ofbiz/shipment
|
|
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: <[hidden email]> >>> To: <[hidden email]> >>> 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 >>> >>> >> > > Si |
Re: svn commit: r504996 - in /ofbiz/trunk/applications: ecommerce/data/ product/ product/config/ product/entitydef/ product/servicedef/ product/src/org/ofbiz/shipment
|
Administrator
|
Si,
I cant see any changes (commits) for DemoShipping.xm since this commit. So logically the problem remains. Jacques ----- Original Message ----- From: "Si Chen" <[hidden email]> To: <[hidden email]> 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 > > > > 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: <[hidden email]> > >>> To: <[hidden email]> > >>> 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 > |
Re: svn commit: r504996 - in /ofbiz/trunk/applications: ecommerce/data/ product/ product/config/ product/entitydef/ product/servicedef/ product/src/org/ofbiz/shipment
|
|
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" <[hidden email]> > To: <[hidden email]> > 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: <[hidden email]> >>>>> To: <[hidden email]> >>>>> 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 >> >> > > |
Re: svn commit: r504996 - in /ofbiz/trunk/applications: ecommerce/data/ product/ product/config/ product/entitydef/ product/servicedef/ product/src/org/ofbiz/shipment
|
Administrator
|
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" <[hidden email]> > > To: <[hidden email]> > > 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/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: > >>> 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 > >>> 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: <[hidden email]> > >>>>> To: <[hidden email]> > >>>>> 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 > >> > >> > > > > > |
Re: svn commit: r504996 - in /ofbiz/trunk/applications: ecommerce/data/ product/ product/config/ product/entitydef/ product/servicedef/ product/src/org/ofbiz/shipment
|
Administrator
|
Was a breeze with pgAdminIII. Now it's another story for Derby. I installed Eclipse Derby's plugins (nice but no UI), connected to
the DB with ij without problem but did not succed in changing field type. I found this http://best-practice-software-engineering.blogspot.com/2006/09/tech-derbys-next-round.html#comment-8980636160782036513 I can't believe it :(. So in such cases the easier is to drop the DB and recreate it, that's it ? Of course this is not a production environment. Thanks Jacques > 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" <[hidden email]> > > > To: <[hidden email]> > > > 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 > 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 > > >>> > > > 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: <[hidden email]> > > >>>>> To: <[hidden email]> > > >>>>> 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 > > >> > > >> > > > > > > > > |
Re: svn commit: r504996 - in /ofbiz/trunk/applications: ecommerce/data/ product/ product/config/ product/entitydef/ product/servicedef/ product/src/org/ofbiz/shipment
|
|
Seems to me you could do the following:
1. Export the table to xml 2. Drop the table 3. Start OFBiz - table recreated with new structure 4. Import xml data from #1 Jacques Le Roux wrote: > Was a breeze with pgAdminIII. Now it's another story for Derby. I installed Eclipse Derby's plugins (nice but no UI), connected to > the DB with ij without problem but did not succed in changing field type. > > I found this http://best-practice-software-engineering.blogspot.com/2006/09/tech-derbys-next-round.html#comment-8980636160782036513 > > I can't believe it :(. So in such cases the easier is to drop the DB and recreate it, that's it ? Of course this is not a production > environment. > > Thanks > > Jacques > > > >>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" <[hidden email]> >>>>To: <[hidden email]> >>>>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: <[hidden email]> >>>>>>>>To: <[hidden email]> >>>>>>>>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 >>>>> >>>>> >>>> >>>> > > |
Re: svn commit: r504996 - in /ofbiz/trunk/applications: ecommerce/data/ product/ product/config/ product/entitydef/ product/servicedef/ product/src/org/ofbiz/shipment
|
Administrator
|
Thanks Adrian,
This seems the best way in a production environment I guess. This is the kind of good ideas we may put in a cookbook in the Wiki. I just created one http://docs.ofbiz.org/pages/createpage.action?spaceKey=OFBIZ&fromPageId=146 Actually this page is intended to be the root of cookbooks. Because I know that the OpenSource Strategy team wants to open its cookbooks to community. This could be the place to begin... Thus the community may extend this cookbooks. BTW I will drop and recreate not clever but easier in my case, less manipulations ;o) Jacques > Seems to me you could do the following: > > 1. Export the table to xml > 2. Drop the table > 3. Start OFBiz - table recreated with new structure > 4. Import xml data from #1 > > > Jacques Le Roux wrote: > > > Was a breeze with pgAdminIII. Now it's another story for Derby. I installed Eclipse Derby's plugins (nice but no UI), connected > > the DB with ij without problem but did not succed in changing field type. > > > > I found this http://best-practice-software-engineering.blogspot.com/2006/09/tech-derbys-next-round.html#comment-8980636160782036513 > > > > I can't believe it :(. So in such cases the easier is to drop the DB and recreate it, that's it ? Of course this is not a production > > environment. > > > > Thanks > > > > Jacques > > > > > > > >>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" <[hidden email]> > >>>>To: <[hidden email]> > >>>>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 > >> > >>>>>> > > > > > >>>>>>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: <[hidden email]> > >>>>>>>>To: <[hidden email]> > >>>>>>>>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 > >>>>> > >>>>> > >>>> > >>>> > > > > |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |