Create Order Error
Locked
 
|
Hi all,
I'm getting this error after I tried to create an order. If I correctly interpret this error then I have to create a carrier with an "_NA_" name. Is this correct or not? For me this makes no sense? There already exist several carriers and carrier shipment methods. If you can say me please, how it's can be solved best? Error: The Following Errors Occurred: Auftrag nicht vervollständigt, folgender Fehler trat auf:ERROR : Could not create order (write error :Error while inserting: [GenericEntity:OrderItemShipGroup][*carrierPartyId,_NA_*(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10021(java.lang.String)][createdStamp,2010-06-02 10:01:43.54(java.sql.Timestamp)][createdTxStamp,2010-06-02 10:01:43.385(java.sql.Timestamp)][estimatedDeliveryDate,2010-06-09 09:52:39.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-06-02 10:01:43.54(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-02 10:01:43.385(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,123334(java.lang.String)][shipAfterDate,2010-06-04 09:52:44.0(java.sql.Timestamp)][shipByDate,2010-06-15 09:52:49.0(java.sql.Timestamp)][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,null()][supplierPartyId,null()][vendorPartyId,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID, CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID, TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE, ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key constraint 'ORDER_ITSG_CSHM' for key (*NO_SHIPPING,_NA_,CARRIER*). The statement has been rolled back.))). Many Thanks and Best Regards Rudolf |
|
|
I agree, it seems someone got gung-ho with using _NA_, which was meant
to be used to satisfy views-entities when not all records are avialalible. I re factored mine (in code also)to user noshipping as an ID. ========================= BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52> Specialtymarket.com <http://www.specialtymarket.com/> Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro> R. S. sent the following on 6/2/2010 1:26 AM: > Hi all, > I'm getting this error after I tried to create an order. If I correctly > interpret this error then I have to create a carrier with an "_NA_" > name. Is this correct or not? For me this makes no sense? There already > exist several carriers and carrier shipment methods. If you can say me > please, how it's can be solved best? > > Error: > The Following Errors Occurred: > Auftrag nicht vervollständigt, folgender Fehler trat auf:ERROR : Could > not create order (write error :Error while inserting: > [GenericEntity:OrderItemShipGroup][*carrierPartyId,_NA_*(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10021(java.lang.String)][createdStamp,2010-06-02 > 10:01:43.54(java.sql.Timestamp)][createdTxStamp,2010-06-02 > 10:01:43.385(java.sql.Timestamp)][estimatedDeliveryDate,2010-06-09 > 09:52:39.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-06-02 > 10:01:43.54(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-02 > 10:01:43.385(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,123334(java.lang.String)][shipAfterDate,2010-06-04 > 09:52:44.0(java.sql.Timestamp)][shipByDate,2010-06-15 > 09:52:49.0(java.sql.Timestamp)][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,null()][supplierPartyId,null()][vendorPartyId,null()] > (SQL Exception while executing the following:INSERT INTO > OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID, > SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID, > CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID, > TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, > MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, > ESTIMATED_SHIP_DATE, ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on > table 'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key > constraint 'ORDER_ITSG_CSHM' for key (*NO_SHIPPING,_NA_,CARRIER*). The > statement has been rolled back.))). > > > Many Thanks and Best Regards > Rudolf > |
|
|
Thank you BJ.
but I can not find where I can choose a carrier or why it don't take a one of the existing carriers for this order? BJ Freeman schrieb: > I agree, it seems someone got gung-ho with using _NA_, which was meant > to be used to satisfy views-entities when not all records are avialalible. > > I re factored mine (in code also)to user noshipping as an ID. > > ========================= > BJ Freeman > http://bjfreeman.elance.com > Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52> > Specialtymarket.com <http://www.specialtymarket.com/> > > Systems Integrator-- Glad to Assist > > Chat Y! messenger: bjfr33man > <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro> > > > R. S. sent the following on 6/2/2010 1:26 AM: > >> Hi all, >> I'm getting this error after I tried to create an order. If I correctly >> interpret this error then I have to create a carrier with an "_NA_" >> name. Is this correct or not? For me this makes no sense? There already >> exist several carriers and carrier shipment methods. If you can say me >> please, how it's can be solved best? >> >> Error: >> The Following Errors Occurred: >> Auftrag nicht vervollständigt, folgender Fehler trat auf:ERROR : Could >> not create order (write error :Error while inserting: >> [GenericEntity:OrderItemShipGroup][*carrierPartyId,_NA_*(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10021(java.lang.String)][createdStamp,2010-06-02 >> 10:01:43.54(java.sql.Timestamp)][createdTxStamp,2010-06-02 >> 10:01:43.385(java.sql.Timestamp)][estimatedDeliveryDate,2010-06-09 >> 09:52:39.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-06-02 >> 10:01:43.54(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-02 >> 10:01:43.385(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,123334(java.lang.String)][shipAfterDate,2010-06-04 >> 09:52:44.0(java.sql.Timestamp)][shipByDate,2010-06-15 >> 09:52:49.0(java.sql.Timestamp)][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,null()][supplierPartyId,null()][vendorPartyId,null()] >> (SQL Exception while executing the following:INSERT INTO >> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID, >> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID, >> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID, >> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, >> MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, >> ESTIMATED_SHIP_DATE, ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, >> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on >> table 'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key >> constraint 'ORDER_ITSG_CSHM' for key (*NO_SHIPPING,_NA_,CARRIER*). The >> statement has been rolled back.))). >> >> >> Many Thanks and Best Regards >> Rudolf >> >> > > |
|
|
I can't believe it. Is this a bug or something like that? After I have
added the person "_NA_", shippingMethodType "NO_SHIPPING" and then brought it together in CarrierShipmentMethod. I could create an order. BUT where are my shipment information in the orderview? How or where I must enter a carrier, so that he becomes visible by the orders. Thank You R. S. schrieb: > Thank you BJ. > but I can not find where I can choose a carrier or why it don't take a > one of the existing carriers for this order? > > > BJ Freeman schrieb: >> I agree, it seems someone got gung-ho with using _NA_, which was meant >> to be used to satisfy views-entities when not all records are >> avialalible. >> >> I re factored mine (in code also)to user noshipping as an ID. >> >> ========================= >> BJ Freeman >> http://bjfreeman.elance.com >> Strategic Power Office with Supplier Automation >> <http://www.businessesnetwork.com/automation/viewforum.php?f=52> >> Specialtymarket.com <http://www.specialtymarket.com/> >> >> Systems Integrator-- Glad to Assist >> >> Chat Y! messenger: bjfr33man >> <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro> >> >> >> >> R. S. sent the following on 6/2/2010 1:26 AM: >> >>> Hi all, >>> I'm getting this error after I tried to create an order. If I correctly >>> interpret this error then I have to create a carrier with an "_NA_" >>> name. Is this correct or not? For me this makes no sense? There already >>> exist several carriers and carrier shipment methods. If you can say me >>> please, how it's can be solved best? >>> >>> Error: >>> The Following Errors Occurred: >>> Auftrag nicht vervollständigt, folgender Fehler trat auf:ERROR : Could >>> not create order (write error :Error while inserting: >>> [GenericEntity:OrderItemShipGroup][*carrierPartyId,_NA_*(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10021(java.lang.String)][createdStamp,2010-06-02 >>> >>> 10:01:43.54(java.sql.Timestamp)][createdTxStamp,2010-06-02 >>> 10:01:43.385(java.sql.Timestamp)][estimatedDeliveryDate,2010-06-09 >>> 09:52:39.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-06-02 >>> >>> 10:01:43.54(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-02 >>> 10:01:43.385(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,123334(java.lang.String)][shipAfterDate,2010-06-04 >>> >>> 09:52:44.0(java.sql.Timestamp)][shipByDate,2010-06-15 >>> 09:52:49.0(java.sql.Timestamp)][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,null()][supplierPartyId,null()][vendorPartyId,null()] >>> >>> (SQL Exception while executing the following:INSERT INTO >>> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID, >>> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID, >>> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID, >>> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, >>> MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, >>> ESTIMATED_SHIP_DATE, ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, >>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, >>> ?, ?, >>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on >>> table 'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key >>> constraint 'ORDER_ITSG_CSHM' for key (*NO_SHIPPING,_NA_,CARRIER*). The >>> statement has been rolled back.))). >>> >>> >>> Many Thanks and Best Regards >>> Rudolf >>> >>> >> >> |
|
|
try changing the visual theme I find that tomhawk sometimes does not
show all the page. ========================= BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52> Specialtymarket.com <http://www.specialtymarket.com/> Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro> R. S. sent the following on 6/2/2010 4:12 AM: > I can't believe it. Is this a bug or something like that? After I have > added the person "_NA_", shippingMethodType "NO_SHIPPING" and then > brought it together in CarrierShipmentMethod. I could create an order. > > BUT where are my shipment information in the orderview? How or where I > must enter a carrier, so that he becomes visible by the orders. > > Thank You > > R. S. schrieb: >> Thank you BJ. >> but I can not find where I can choose a carrier or why it don't take a >> one of the existing carriers for this order? >> >> >> BJ Freeman schrieb: >>> I agree, it seems someone got gung-ho with using _NA_, which was meant >>> to be used to satisfy views-entities when not all records are >>> avialalible. >>> >>> I re factored mine (in code also)to user noshipping as an ID. >>> >>> ========================= >>> BJ Freeman >>> http://bjfreeman.elance.com >>> Strategic Power Office with Supplier Automation >>> <http://www.businessesnetwork.com/automation/viewforum.php?f=52> >>> Specialtymarket.com <http://www.specialtymarket.com/> >>> >>> Systems Integrator-- Glad to Assist >>> >>> Chat Y! messenger: bjfr33man >>> <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro> >>> >>> >>> >>> R. S. sent the following on 6/2/2010 1:26 AM: >>> >>>> Hi all, >>>> I'm getting this error after I tried to create an order. If I correctly >>>> interpret this error then I have to create a carrier with an "_NA_" >>>> name. Is this correct or not? For me this makes no sense? There already >>>> exist several carriers and carrier shipment methods. If you can say me >>>> please, how it's can be solved best? >>>> >>>> Error: >>>> The Following Errors Occurred: >>>> Auftrag nicht vervollständigt, folgender Fehler trat auf:ERROR : Could >>>> not create order (write error :Error while inserting: >>>> [GenericEntity:OrderItemShipGroup][*carrierPartyId,_NA_*(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10021(java.lang.String)][createdStamp,2010-06-02 >>>> >>>> 10:01:43.54(java.sql.Timestamp)][createdTxStamp,2010-06-02 >>>> 10:01:43.385(java.sql.Timestamp)][estimatedDeliveryDate,2010-06-09 >>>> 09:52:39.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-06-02 >>>> >>>> 10:01:43.54(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-02 >>>> 10:01:43.385(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,123334(java.lang.String)][shipAfterDate,2010-06-04 >>>> >>>> 09:52:44.0(java.sql.Timestamp)][shipByDate,2010-06-15 >>>> 09:52:49.0(java.sql.Timestamp)][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,null()][supplierPartyId,null()][vendorPartyId,null()] >>>> >>>> (SQL Exception while executing the following:INSERT INTO >>>> OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID, >>>> SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID, >>>> CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID, >>>> TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, >>>> MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, >>>> ESTIMATED_SHIP_DATE, ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, >>>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, >>>> ?, ?, >>>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on >>>> table 'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key >>>> constraint 'ORDER_ITSG_CSHM' for key (*NO_SHIPPING,_NA_,CARRIER*). The >>>> statement has been rolled back.))). >>>> >>>> >>>> Many Thanks and Best Regards >>>> Rudolf >>>> >>>> >>> >>> > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |