Getting an error when creating Purchase Order
Locked
 
|
Hi, I am getting an error when creating a Purchase Order. Can anyone tell me what I am doing wrong and how to fix it.
The Following Errors Occurred: Did not complete the order, the following occurred:ERROR : Could not create order (write error :Error while inserting: [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 11:49:09.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 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN KEY (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) REFERENCES `carrier_shipment_method` (`SHIPMEN)))). Purchase Order : Order Confirmation Create OrderReview OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad -------------------------------------------------------------------------------- Order Terms Term Type Term Value Term Days Description -------------------------------------------------------------------------------- Payment (net days) 30 -------------------------------------------------------------------------------- Splitting Preference Please wait until the entire order is ready before shipping. -------------------------------------------------------------------------------- Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 11:49:09.000 Shipping InformationDestination Supplier Shipment Method Item Quantity -------------------------------------------------------------------------------- To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San Francisco CA , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 -------------------------------------------------------------------------------- Grand Total $680.00 |
Re: Getting an error when creating Purchase Order
|
|
want version of ofbiz, please
also what steps did you do and where did the error happen in the steps? thanks ========================= BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> 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> rugstan sent the following on 4/3/2010 10:30 AM: > Hi, I am getting an error when creating a Purchase Order. Can anyone tell me > what I am doing wrong and how to fix it. > > The Following Errors Occurred: Did not complete the order, the following > occurred:ERROR : Could not create order (write error :Error while inserting: > [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 > 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 > 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 > 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 > 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 > 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 > 11:49:09.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 > 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > (Cannot add or update a child row: a foreign key constraint fails > (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN KEY > (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) > REFERENCES `carrier_shipment_method` (`SHIPMEN)))). > > Purchase Order : Order Confirmation Create OrderReview > OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad > -------------------------------------------------------------------------------- > Order Terms Term Type Term Value Term Days Description > -------------------------------------------------------------------------------- > Payment (net days) 30 > -------------------------------------------------------------------------------- > Splitting Preference Please wait until the entire order is ready before > shipping. > -------------------------------------------------------------------------------- > Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 > 11:49:09.000 Shipping InformationDestination Supplier Shipment Method Item > Quantity > -------------------------------------------------------------------------------- > To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San Francisco CA > , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 > -------------------------------------------------------------------------------- > Grand Total $680.00 |
|
|
I am using 9.04 and when I press the button to finalize the Purchase Order than I get this error and I cannot create a Purchase order. I tried everyhing but cannot figure out the mistake I am making and where I am making.
Thanks
Rishi
On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] <[hidden email]> wrote:
-- Rishi Khanna Director Rugstan Inc. Ph # 650-292-2493 |
Re: Getting an error when creating Purchase Order
|
|
In reply to this post by BJ Freeman
the error says that you did not select a carrier.
the default was put in _NA_ but is does not have a Role type Carrier assigned to it. ===================== BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> 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> rugstan sent the following on 4/3/2010 3:12 PM: > I am using 9.04 and when I press the button to finalize the Purchase Order > than I get this error and I cannot create a Purchase order. I tried > everyhing but cannot figure out the mistake I am making and where I am > making. > > Thanks > > Rishi > > On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] < > [hidden email]<ml-node%[hidden email]> >> wrote: > >> want version of ofbiz, please >> also what steps did you do and where did the error happen in the steps? >> thanks >> >> ========================= >> BJ Freeman >> http://bjfreeman.elance.com >> Strategic Power Office with Supplier Automation < >> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >> 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> >> >> >> >> rugstan sent the following on 4/3/2010 10:30 AM: >> >> > Hi, I am getting an error when creating a Purchase Order. Can anyone >> tell me >>> what I am doing wrong and how to fix it. >>> >>> The Following Errors Occurred: Did not complete the order, the following >>> occurred:ERROR : Could not create order (write error :Error while >> inserting: >> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 >> >>> 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 >>> >> 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 >> >>> 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 >>> >> 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 >> >>> 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 >>> >> 11:49:09.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 >>> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?) >>> (Cannot add or update a child row: a foreign key constraint fails >>> (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN >> KEY >>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) >>> REFERENCES `carrier_shipment_method` (`SHIPMEN)))). >>> >>> Purchase Order : Order Confirmation Create OrderReview >>> OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad >>> >> -------------------------------------------------------------------------------- >> >>> Order Terms Term Type Term Value Term Days Description >>> >> -------------------------------------------------------------------------------- >> >>> Payment (net days) 30 >>> >> -------------------------------------------------------------------------------- >> >>> Splitting Preference Please wait until the entire order is ready before >>> shipping. >>> >> -------------------------------------------------------------------------------- >> >>> Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 >>> 11:49:09.000 Shipping InformationDestination Supplier Shipment Method >> Item >>> Quantity >>> >> -------------------------------------------------------------------------------- >> >>> To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San Francisco >> CA >>> , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 >>> >> -------------------------------------------------------------------------------- >> >>> Grand Total $680.00 >> >> >> >> ------------------------------ >> View message @ >> http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html >> To unsubscribe from Getting an error when creating Purchase Order, click >> here< (link removed) =>. >> >> >> > > |
Re: Getting an error when creating Purchase Order
|
|
In reply to this post by BJ Freeman
if you selected
No shipping it is assigned _NA_ for PartyID the Party ID _NA_ does not have a role type Carrier assigned to it ========================= BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> 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> BJ Freeman sent the following on 4/3/2010 3:39 PM: > the error says that you did not select a carrier. > the default was put in _NA_ but is does not have a Role type Carrier > assigned to it. > > ===================== > BJ Freeman > http://bjfreeman.elance.com > Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> > 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> > > > rugstan sent the following on 4/3/2010 3:12 PM: >> I am using 9.04 and when I press the button to finalize the Purchase Order >> than I get this error and I cannot create a Purchase order. I tried >> everyhing but cannot figure out the mistake I am making and where I am >> making. >> >> Thanks >> >> Rishi >> >> On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] < >> [hidden email]<ml-node%[hidden email]> >>> wrote: >>> want version of ofbiz, please >>> also what steps did you do and where did the error happen in the steps? >>> thanks >>> >>> ========================= >>> BJ Freeman >>> http://bjfreeman.elance.com >>> Strategic Power Office with Supplier Automation < >>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>> 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> >>> >>> >>> >>> rugstan sent the following on 4/3/2010 10:30 AM: >>> >>> > Hi, I am getting an error when creating a Purchase Order. Can anyone >>> tell me >>>> what I am doing wrong and how to fix it. >>>> >>>> The Following Errors Occurred: Did not complete the order, the following >>>> occurred:ERROR : Could not create order (write error :Error while >>> inserting: >>> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 >>> >>>> 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 >>>> >>> 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 >>> >>>> 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 >>>> >>> 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 >>> >>>> 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 >>>> >>> 11:49:09.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 >>>> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >>> ?) >>>> (Cannot add or update a child row: a foreign key constraint fails >>>> (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN >>> KEY >>>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) >>>> REFERENCES `carrier_shipment_method` (`SHIPMEN)))). >>>> >>>> Purchase Order : Order Confirmation Create OrderReview >>>> OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad >>>> >>> -------------------------------------------------------------------------------- >>> >>>> Order Terms Term Type Term Value Term Days Description >>>> >>> -------------------------------------------------------------------------------- >>> >>>> Payment (net days) 30 >>>> >>> -------------------------------------------------------------------------------- >>> >>>> Splitting Preference Please wait until the entire order is ready before >>>> shipping. >>>> >>> -------------------------------------------------------------------------------- >>> >>>> Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 >>>> 11:49:09.000 Shipping InformationDestination Supplier Shipment Method >>> Item >>>> Quantity >>>> >>> -------------------------------------------------------------------------------- >>> >>>> To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San Francisco >>> CA >>>> , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 >>>> >>> -------------------------------------------------------------------------------- >>> >>>> Grand Total $680.00 >>> >>> >>> ------------------------------ >>> View message @ >>> http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html >>> To unsubscribe from Getting an error when creating Purchase Order, click >>> here< (link removed) =>. >>> >>> >>> >> > > > |
Re: Getting an error when creating Purchase Order
|
|
In reply to this post by BJ Freeman
a quick work around is to go into the party for _NA_ and give it a role
carrier. I am not sure this might cause another glitch down the road. but it will allow the PO to be generated. ========================= BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> 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> BJ Freeman sent the following on 4/3/2010 3:49 PM: > if you selected > No shipping > it is assigned _NA_ for PartyID > the Party ID _NA_ does not have a role type Carrier assigned to it > > > > ========================= > BJ Freeman > http://bjfreeman.elance.com > Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> > 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> > > > BJ Freeman sent the following on 4/3/2010 3:39 PM: >> the error says that you did not select a carrier. >> the default was put in _NA_ but is does not have a Role type Carrier >> assigned to it. >> >> ===================== >> BJ Freeman >> http://bjfreeman.elance.com >> Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> >> 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> >> >> >> rugstan sent the following on 4/3/2010 3:12 PM: >>> I am using 9.04 and when I press the button to finalize the Purchase Order >>> than I get this error and I cannot create a Purchase order. I tried >>> everyhing but cannot figure out the mistake I am making and where I am >>> making. >>> >>> Thanks >>> >>> Rishi >>> >>> On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] < >>> [hidden email]<ml-node%[hidden email]> >>>> wrote: >>>> want version of ofbiz, please >>>> also what steps did you do and where did the error happen in the steps? >>>> thanks >>>> >>>> ========================= >>>> BJ Freeman >>>> http://bjfreeman.elance.com >>>> Strategic Power Office with Supplier Automation < >>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>>> 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> >>>> >>>> >>>> >>>> rugstan sent the following on 4/3/2010 10:30 AM: >>>> >>>> > Hi, I am getting an error when creating a Purchase Order. Can anyone >>>> tell me >>>>> what I am doing wrong and how to fix it. >>>>> >>>>> The Following Errors Occurred: Did not complete the order, the following >>>>> occurred:ERROR : Could not create order (write error :Error while >>>> inserting: >>>> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 >>>> >>>>> 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 >>>>> >>>> 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 >>>> >>>>> 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 >>>>> >>>> 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 >>>> >>>>> 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 >>>>> >>>> 11:49:09.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 >>>>> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >>>> ?) >>>>> (Cannot add or update a child row: a foreign key constraint fails >>>>> (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN >>>> KEY >>>>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) >>>>> REFERENCES `carrier_shipment_method` (`SHIPMEN)))). >>>>> >>>>> Purchase Order : Order Confirmation Create OrderReview >>>>> OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad >>>>> >>>> -------------------------------------------------------------------------------- >>>> >>>>> Order Terms Term Type Term Value Term Days Description >>>>> >>>> -------------------------------------------------------------------------------- >>>> >>>>> Payment (net days) 30 >>>>> >>>> -------------------------------------------------------------------------------- >>>> >>>>> Splitting Preference Please wait until the entire order is ready before >>>>> shipping. >>>>> >>>> -------------------------------------------------------------------------------- >>>> >>>>> Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 >>>>> 11:49:09.000 Shipping InformationDestination Supplier Shipment Method >>>> Item >>>>> Quantity >>>>> >>>> -------------------------------------------------------------------------------- >>>> >>>>> To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San Francisco >>>> CA >>>>> , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 >>>>> >>>> -------------------------------------------------------------------------------- >>>> >>>>> Grand Total $680.00 >>>> >>>> ------------------------------ >>>> View message @ >>>> http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html >>>> To unsubscribe from Getting an error when creating Purchase Order, click >>>> here< (link removed) =>. >>>> >>>> >>>> >> >> > > > |
|
|
In reply to this post by BJ Freeman
HI,
Thanks for the help. But where I go and assign the role type carrier? Rishi On Sat, Apr 3, 2010 at 3:39 PM, BJ Freeman <[hidden email]> wrote: > the error says that you did not select a carrier. > the default was put in _NA_ but is does not have a Role type Carrier > assigned to it. > > ===================== > BJ Freeman > http://bjfreeman.elance.com > Strategic Power Office with Supplier Automation < > http://www.businessesnetwork.com/automation/viewforum.php?f=93> > 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 > > > > > rugstan sent the following on 4/3/2010 3:12 PM: > > I am using 9.04 and when I press the button to finalize the Purchase > Order > > than I get this error and I cannot create a Purchase order. I tried > > everyhing but cannot figure out the mistake I am making and where I am > > making. > > > > Thanks > > > > Rishi > > > > On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] < > > [hidden email]<ml-node%[hidden email]> > <ml-node%[hidden email]<ml-node%[hidden email]> > > > >> wrote: > > > >> want version of ofbiz, please > >> also what steps did you do and where did the error happen in the steps? > >> thanks > >> > >> ========================= > >> BJ Freeman > >> http://bjfreeman.elance.com > >> Strategic Power Office with Supplier Automation < > >> http://www.businessesnetwork.com/automation/viewforum.php?f=93> > >> 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 > > > >> > >> > >> > >> rugstan sent the following on 4/3/2010 10:30 AM: > >> > >> > Hi, I am getting an error when creating a Purchase Order. Can anyone > >> tell me > >>> what I am doing wrong and how to fix it. > >>> > >>> The Following Errors Occurred: Did not complete the order, the > following > >>> occurred:ERROR : Could not create order (write error :Error while > >> inserting: > >> > [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 > >> > >>> 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 > >>> > >> > 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 > >> > >>> 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 > >>> > >> > 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 > >> > >>> 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 > >>> > >> > 11:49:09.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 > >>> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, > >> ?) > >>> (Cannot add or update a child row: a foreign key constraint fails > >>> (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN > >> KEY > >>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) > >>> REFERENCES `carrier_shipment_method` (`SHIPMEN)))). > >>> > >>> Purchase Order : Order Confirmation Create OrderReview > >>> OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad > >>> > >> > -------------------------------------------------------------------------------- > >> > >>> Order Terms Term Type Term Value Term Days Description > >>> > >> > -------------------------------------------------------------------------------- > >> > >>> Payment (net days) 30 > >>> > >> > -------------------------------------------------------------------------------- > >> > >>> Splitting Preference Please wait until the entire order is ready before > >>> shipping. > >>> > >> > -------------------------------------------------------------------------------- > >> > >>> Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 > >>> 11:49:09.000 Shipping InformationDestination Supplier Shipment Method > >> Item > >>> Quantity > >>> > >> > -------------------------------------------------------------------------------- > >> > >>> To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San > Francisco > >> CA > >>> , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 > >>> > >> > -------------------------------------------------------------------------------- > >> > >>> Grand Total $680.00 > >> > >> > >> > >> ------------------------------ > >> View message @ > >> > http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html > >> To unsubscribe from Getting an error when creating Purchase Order, click > >> here< (link removed) =>. > >> > >> > >> > > > > > > > -- Rishi Khanna Director Rugstan Inc. Ph # 650-292-2493 |
Re: Getting an error when creating Purchase Order
|
|
In reply to this post by BJ Freeman
click on the party tab
in the partyID put _NA_ then click on lookup then click on _NA_ click on Role(s) see if there is a RoletypeID of carrier if not then under add role select carrier click on Add ======================= BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> 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> Rishi Khanna sent the following on 4/3/2010 4:14 PM: > HI, > > Thanks for the help. > > But where I go and assign the role type carrier? > > Rishi > > On Sat, Apr 3, 2010 at 3:39 PM, BJ Freeman <[hidden email]> wrote: > >> the error says that you did not select a carrier. >> the default was put in _NA_ but is does not have a Role type Carrier >> assigned to it. >> >> ===================== >> BJ Freeman >> http://bjfreeman.elance.com >> Strategic Power Office with Supplier Automation < >> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >> 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 >> >> rugstan sent the following on 4/3/2010 3:12 PM: >>> I am using 9.04 and when I press the button to finalize the Purchase >> Order >>> than I get this error and I cannot create a Purchase order. I tried >>> everyhing but cannot figure out the mistake I am making and where I am >>> making. >>> >>> Thanks >>> >>> Rishi >>> >>> On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] < >>> [hidden email]<ml-node%[hidden email]> >> <ml-node%[hidden email]<ml-node%[hidden email]> >>>> wrote: >> >> want version of ofbiz, please >>>> also what steps did you do and where did the error happen in the steps? >>>> thanks >>>> >>>> ========================= >>>> BJ Freeman >>>> http://bjfreeman.elance.com >>>> Strategic Power Office with Supplier Automation < >>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>>> 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 >>>> >>>> >>>> rugstan sent the following on 4/3/2010 10:30 AM: >>>> >>>> > Hi, I am getting an error when creating a Purchase Order. Can anyone >>>> tell me >>>>> what I am doing wrong and how to fix it. >>>>> >>>>> The Following Errors Occurred: Did not complete the order, the >> following >>>>> occurred:ERROR : Could not create order (write error :Error while >>>> inserting: >>>> >> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 >>>>> 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 >>>>> >> 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 >>>>> 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 >>>>> >> 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 >>>>> 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 >>>>> >> 11:49:09.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 >>>>> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, >>>> ?) >>>>> (Cannot add or update a child row: a foreign key constraint fails >>>>> (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN >>>> KEY >>>>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) >>>>> REFERENCES `carrier_shipment_method` (`SHIPMEN)))). >>>>> >>>>> Purchase Order : Order Confirmation Create OrderReview >>>>> OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad >>>>> >> -------------------------------------------------------------------------------- >>>>> Order Terms Term Type Term Value Term Days Description >>>>> >> -------------------------------------------------------------------------------- >>>>> Payment (net days) 30 >>>>> >> -------------------------------------------------------------------------------- >>>>> Splitting Preference Please wait until the entire order is ready before >>>>> shipping. >>>>> >> -------------------------------------------------------------------------------- >>>>> Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 >>>>> 11:49:09.000 Shipping InformationDestination Supplier Shipment Method >>>> Item >>>>> Quantity >>>>> >> -------------------------------------------------------------------------------- >>>>> To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San >> Francisco >>>> CA >>>>> , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 >>>>> >> -------------------------------------------------------------------------------- >>>>> Grand Total $680.00 >>>> >>>> >>>> ------------------------------ >>>> View message @ >>>> >> http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html >>>> To unsubscribe from Getting an error when creating Purchase Order, click >>>> here< (link removed) =>. >>>> >>>> >>>> >>> >> >> > > |
|
|
In reply to this post by rugstan
I had no party with NA
Veru confused On Sat, Apr 3, 2010 at 4:14 PM, Rishi Khanna <[hidden email]> wrote: > HI, > > Thanks for the help. > > But where I go and assign the role type carrier? > > Rishi > > On Sat, Apr 3, 2010 at 3:39 PM, BJ Freeman <[hidden email]> wrote: > >> the error says that you did not select a carrier. >> the default was put in _NA_ but is does not have a Role type Carrier >> assigned to it. >> >> ===================== >> BJ Freeman >> http://bjfreeman.elance.com >> Strategic Power Office with Supplier Automation < >> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >> 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 >> > >> >> >> rugstan sent the following on 4/3/2010 3:12 PM: >> > I am using 9.04 and when I press the button to finalize the Purchase >> Order >> > than I get this error and I cannot create a Purchase order. I tried >> > everyhing but cannot figure out the mistake I am making and where I am >> > making. >> > >> > Thanks >> > >> > Rishi >> > >> > On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] < >> > [hidden email]<ml-node%[hidden email]> >> <ml-node%[hidden email]<ml-node%[hidden email]> >> > >> >> wrote: >> > >> >> want version of ofbiz, please >> >> also what steps did you do and where did the error happen in the steps? >> >> thanks >> >> >> >> ========================= >> >> BJ Freeman >> >> http://bjfreeman.elance.com >> >> Strategic Power Office with Supplier Automation < >> >> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >> >> 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 >> > >> >> >> >> >> >> >> >> rugstan sent the following on 4/3/2010 10:30 AM: >> >> >> >> > Hi, I am getting an error when creating a Purchase Order. Can anyone >> >> tell me >> >>> what I am doing wrong and how to fix it. >> >>> >> >>> The Following Errors Occurred: Did not complete the order, the >> following >> >>> occurred:ERROR : Could not create order (write error :Error while >> >> inserting: >> >> >> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 >> >> >> >>> 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 >> >>> >> >> >> 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 >> >> >> >>> 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 >> >>> >> >> >> 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 >> >> >> >>> 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 >> >>> >> >> >> 11:49:09.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 >> >>> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, >> >> ?) >> >>> (Cannot add or update a child row: a foreign key constraint fails >> >>> (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN >> >> KEY >> >>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, >> `CARRIER_ROLE_TYPE_ID`) >> >>> REFERENCES `carrier_shipment_method` (`SHIPMEN)))). >> >>> >> >>> Purchase Order : Order Confirmation Create OrderReview >> >>> OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad >> >>> >> >> >> -------------------------------------------------------------------------------- >> >> >> >>> Order Terms Term Type Term Value Term Days Description >> >>> >> >> >> -------------------------------------------------------------------------------- >> >> >> >>> Payment (net days) 30 >> >>> >> >> >> -------------------------------------------------------------------------------- >> >> >> >>> Splitting Preference Please wait until the entire order is ready >> before >> >>> shipping. >> >>> >> >> >> -------------------------------------------------------------------------------- >> >> >> >>> Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 >> >>> 11:49:09.000 Shipping InformationDestination Supplier Shipment Method >> >> Item >> >>> Quantity >> >>> >> >> >> -------------------------------------------------------------------------------- >> >> >> >>> To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San >> Francisco >> >> CA >> >>> , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 >> >>> >> >> >> -------------------------------------------------------------------------------- >> >> >> >>> Grand Total $680.00 >> >> >> >> >> >> >> >> ------------------------------ >> >> View message @ >> >> >> http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html >> >> To unsubscribe from Getting an error when creating Purchase Order, >> click >> >> here< (link removed) =>. >> >> >> >> >> >> >> > >> > >> >> >> > > > -- > Rishi Khanna > Director > Rugstan Inc. > Ph # 650-292-2493 > -- Rishi Khanna Director Rugstan Inc. Ph # 650-292-2493 |
Re: Getting an error when creating Purchase Order
|
|
In reply to this post by rugstan
I suggest you down load a separate 9.04 and install the demo data, and
run in local host mode. try your PO to see if it works. if so then compare the demo data with the data in your installation to see what you don't have. I would suggest using the Demo server but they don't have one for 9.04 right now. ========================= BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> 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> Rishi Khanna sent the following on 4/3/2010 5:04 PM: > I had no party with NA > > Veru confused > > On Sat, Apr 3, 2010 at 4:14 PM, Rishi Khanna <[hidden email]> wrote: > >> HI, >> >> Thanks for the help. >> >> But where I go and assign the role type carrier? >> >> Rishi >> >> On Sat, Apr 3, 2010 at 3:39 PM, BJ Freeman <[hidden email]> wrote: >> >>> the error says that you did not select a carrier. >>> the default was put in _NA_ but is does not have a Role type Carrier >>> assigned to it. >>> >>> ===================== >>> BJ Freeman >>> http://bjfreeman.elance.com >>> Strategic Power Office with Supplier Automation < >>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>> 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 >>> >>> rugstan sent the following on 4/3/2010 3:12 PM: >>>> I am using 9.04 and when I press the button to finalize the Purchase >>> Order >>>> than I get this error and I cannot create a Purchase order. I tried >>>> everyhing but cannot figure out the mistake I am making and where I am >>>> making. >>>> >>>> Thanks >>>> >>>> Rishi >>>> >>>> On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] < >>>> [hidden email]<ml-node%[hidden email]> >>> <ml-node%[hidden email]<ml-node%[hidden email]> >>>>> wrote: >>> >> want version of ofbiz, please >>>>> also what steps did you do and where did the error happen in the steps? >>>>> thanks >>>>> >>>>> ========================= >>>>> BJ Freeman >>>>> http://bjfreeman.elance.com >>>>> Strategic Power Office with Supplier Automation < >>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>>>> 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 >>>>> >>>>> >>>>> rugstan sent the following on 4/3/2010 10:30 AM: >>>>> >>>>> > Hi, I am getting an error when creating a Purchase Order. Can anyone >>>>> tell me >>>>>> what I am doing wrong and how to fix it. >>>>>> >>>>>> The Following Errors Occurred: Did not complete the order, the >>> following >>>>>> occurred:ERROR : Could not create order (write error :Error while >>>>> inserting: >>>>> >>> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 >>>>>> 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 >>>>>> >>> 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 >>>>>> 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 >>>>>> >>> 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 >>>>>> 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 >>>>>> >>> 11:49:09.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 >>>>>> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >>> ?, >>>>> ?) >>>>>> (Cannot add or update a child row: a foreign key constraint fails >>>>>> (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN >>>>> KEY >>>>>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, >>> `CARRIER_ROLE_TYPE_ID`) >>>>>> REFERENCES `carrier_shipment_method` (`SHIPMEN)))). >>>>>> >>>>>> Purchase Order : Order Confirmation Create OrderReview >>>>>> OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad >>>>>> >>> -------------------------------------------------------------------------------- >>>>>> Order Terms Term Type Term Value Term Days Description >>>>>> >>> -------------------------------------------------------------------------------- >>>>>> Payment (net days) 30 >>>>>> >>> -------------------------------------------------------------------------------- >>>>>> Splitting Preference Please wait until the entire order is ready >>> before >>>>>> shipping. >>>>>> >>> -------------------------------------------------------------------------------- >>>>>> Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 >>>>>> 11:49:09.000 Shipping InformationDestination Supplier Shipment Method >>>>> Item >>>>>> Quantity >>>>>> >>> -------------------------------------------------------------------------------- >>>>>> To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San >>> Francisco >>>>> CA >>>>>> , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 >>>>>> >>> -------------------------------------------------------------------------------- >>>>>> Grand Total $680.00 >>>>> >>>>> >>>>> ------------------------------ >>>>> View message @ >>>>> >>> http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html >>>>> To unsubscribe from Getting an error when creating Purchase Order, >>> click >>>>> here< (link removed) =>. >>>>> >>>>> >>>>> >>>> >>> >>> >> >> -- >> Rishi Khanna >> Director >> Rugstan Inc. >> Ph # 650-292-2493 >> > > > |
|
|
In reply to this post by BJ Freeman
Hi Sir,
I do not have any party with _NA_ and I even checked the database there is no such party. Please advise what to do now? Thanks RIshi On Sat, Apr 3, 2010 at 5:04 PM, BJ Freeman <[hidden email]> wrote: > click on the party tab > in the partyID put _NA_ > then click on lookup > then click on _NA_ > click on Role(s) > see if there is a RoletypeID of carrier > if not then > under add role > select carrier > click on Add > > ======================= > > BJ Freeman > http://bjfreeman.elance.com > Strategic Power Office with Supplier Automation < > http://www.businessesnetwork.com/automation/viewforum.php?f=93> > 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 > > > > > Rishi Khanna sent the following on 4/3/2010 4:14 PM: > > HI, > > > > Thanks for the help. > > > > But where I go and assign the role type carrier? > > > > Rishi > > > > On Sat, Apr 3, 2010 at 3:39 PM, BJ Freeman <[hidden email]> wrote: > > > >> the error says that you did not select a carrier. > >> the default was put in _NA_ but is does not have a Role type Carrier > >> assigned to it. > >> > >> ===================== > >> BJ Freeman > >> http://bjfreeman.elance.com > >> Strategic Power Office with Supplier Automation < > >> http://www.businessesnetwork.com/automation/viewforum.php?f=93> > >> 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 > >> > >> rugstan sent the following on 4/3/2010 3:12 PM: > >>> I am using 9.04 and when I press the button to finalize the Purchase > >> Order > >>> than I get this error and I cannot create a Purchase order. I tried > >>> everyhing but cannot figure out the mistake I am making and where I am > >>> making. > >>> > >>> Thanks > >>> > >>> Rishi > >>> > >>> On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] < > >>> [hidden email]<ml-node%[hidden email]> > <ml-node%[hidden email]<ml-node%[hidden email]> > > > >> <ml-node%[hidden email]<ml-node%[hidden email]> > <ml-node%[hidden email]<ml-node%[hidden email]> > > > >>>> wrote: > >> >> want version of ofbiz, please > >>>> also what steps did you do and where did the error happen in the > steps? > >>>> thanks > >>>> > >>>> ========================= > >>>> BJ Freeman > >>>> http://bjfreeman.elance.com > >>>> Strategic Power Office with Supplier Automation < > >>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> > >>>> 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 > >>>> > >>>> > >>>> rugstan sent the following on 4/3/2010 10:30 AM: > >>>> > >>>> > Hi, I am getting an error when creating a Purchase Order. Can > anyone > >>>> tell me > >>>>> what I am doing wrong and how to fix it. > >>>>> > >>>>> The Following Errors Occurred: Did not complete the order, the > >> following > >>>>> occurred:ERROR : Could not create order (write error :Error while > >>>> inserting: > >>>> > >> > [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 > >>>>> 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 > >>>>> > >> > 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 > >>>>> 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 > >>>>> > >> > 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 > >>>>> 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 > >>>>> > >> > 11:49:09.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 > >>>>> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, > >> ?, > >>>> ?) > >>>>> (Cannot add or update a child row: a foreign key constraint fails > >>>>> (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` > FOREIGN > >>>> KEY > >>>>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, > `CARRIER_ROLE_TYPE_ID`) > >>>>> REFERENCES `carrier_shipment_method` (`SHIPMEN)))). > >>>>> > >>>>> Purchase Order : Order Confirmation Create OrderReview > >>>>> OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad > >>>>> > >> > -------------------------------------------------------------------------------- > >>>>> Order Terms Term Type Term Value Term Days Description > >>>>> > >> > -------------------------------------------------------------------------------- > >>>>> Payment (net days) 30 > >>>>> > >> > -------------------------------------------------------------------------------- > >>>>> Splitting Preference Please wait until the entire order is ready > before > >>>>> shipping. > >>>>> > >> > -------------------------------------------------------------------------------- > >>>>> Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 > >>>>> 11:49:09.000 Shipping InformationDestination Supplier Shipment Method > >>>> Item > >>>>> Quantity > >>>>> > >> > -------------------------------------------------------------------------------- > >>>>> To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San > >> Francisco > >>>> CA > >>>>> , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 > >>>>> > >> > -------------------------------------------------------------------------------- > >>>>> Grand Total $680.00 > >>>> > >>>> > >>>> ------------------------------ > >>>> View message @ > >>>> > >> > http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html > >>>> To unsubscribe from Getting an error when creating Purchase Order, > click > >>>> here< (link removed) =>. > >>>> > >>>> > >>>> > >>> > >> > >> > > > > > > > -- Rishi Khanna Director Rugstan Inc. Ph # 650-292-2493 |
Re: Getting an error when creating Purchase Order
|
|
In reply to this post by BJ Freeman
from your error
> [carrierPartyId,_NA_ there is a party there ========================= BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> 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> Rishi Khanna sent the following on 4/3/2010 5:28 PM: > Hi Sir, > > I do not have any party with _NA_ and I even checked the database there is > no such party. > > Please advise what to do now? > > Thanks > > RIshi > > On Sat, Apr 3, 2010 at 5:04 PM, BJ Freeman <[hidden email]> wrote: > >> click on the party tab >> in the partyID put _NA_ >> then click on lookup >> then click on _NA_ >> click on Role(s) >> see if there is a RoletypeID of carrier >> if not then >> under add role >> select carrier >> click on Add >> >> ======================= >> >> BJ Freeman >> http://bjfreeman.elance.com >> Strategic Power Office with Supplier Automation < >> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >> 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 >> >> Rishi Khanna sent the following on 4/3/2010 4:14 PM: >>> HI, >>> >>> Thanks for the help. >>> >>> But where I go and assign the role type carrier? >>> >>> Rishi >>> >>> On Sat, Apr 3, 2010 at 3:39 PM, BJ Freeman <[hidden email]> wrote: >>> >>>> the error says that you did not select a carrier. >>>> the default was put in _NA_ but is does not have a Role type Carrier >>>> assigned to it. >>>> >>>> ===================== >>>> BJ Freeman >>>> http://bjfreeman.elance.com >>>> Strategic Power Office with Supplier Automation < >>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>>> 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 >>>> rugstan sent the following on 4/3/2010 3:12 PM: >>>>> I am using 9.04 and when I press the button to finalize the Purchase >>>> Order >>>>> than I get this error and I cannot create a Purchase order. I tried >>>>> everyhing but cannot figure out the mistake I am making and where I am >>>>> making. >>>>> >>>>> Thanks >>>>> >>>>> Rishi >>>>> >>>>> On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] < >>>>> [hidden email]<ml-node%[hidden email]> >> <ml-node%[hidden email]<ml-node%[hidden email]> >>>> <ml-node%[hidden email]<ml-node%[hidden email]> >> <ml-node%[hidden email]<ml-node%[hidden email]> >> >>>> wrote: >>>> >> want version of ofbiz, please >>>>>> also what steps did you do and where did the error happen in the >> steps? >>>>>> thanks >>>>>> >>>>>> ========================= >>>>>> BJ Freeman >>>>>> http://bjfreeman.elance.com >>>>>> Strategic Power Office with Supplier Automation < >>>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>>>>> 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 >>>>>> >>>>>> rugstan sent the following on 4/3/2010 10:30 AM: >>>>>> >>>>>> > Hi, I am getting an error when creating a Purchase Order. Can >> anyone >>>>>> tell me >>>>>>> what I am doing wrong and how to fix it. >>>>>>> >>>>>>> The Following Errors Occurred: Did not complete the order, the >>>> following >>>>>>> occurred:ERROR : Could not create order (write error :Error while >>>>>> inserting: >>>>>> >> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 >>>>>>> 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 >>>>>>> >> 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 >>>>>>> 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 >>>>>>> >> 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 >>>>>>> 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 >>>>>>> >> 11:49:09.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 >>>>>>> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, >>>> ?, >>>>>> ?) >>>>>>> (Cannot add or update a child row: a foreign key constraint fails >>>>>>> (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` >> FOREIGN >>>>>> KEY >>>>>>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, >> `CARRIER_ROLE_TYPE_ID`) >>>>>>> REFERENCES `carrier_shipment_method` (`SHIPMEN)))). >>>>>>> >>>>>>> Purchase Order : Order Confirmation Create OrderReview >>>>>>> OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad >>>>>>> >> -------------------------------------------------------------------------------- >>>>>>> Order Terms Term Type Term Value Term Days Description >>>>>>> >> -------------------------------------------------------------------------------- >>>>>>> Payment (net days) 30 >>>>>>> >> -------------------------------------------------------------------------------- >>>>>>> Splitting Preference Please wait until the entire order is ready >> before >>>>>>> shipping. >>>>>>> >> -------------------------------------------------------------------------------- >>>>>>> Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 >>>>>>> 11:49:09.000 Shipping InformationDestination Supplier Shipment Method >>>>>> Item >>>>>>> Quantity >>>>>>> >> -------------------------------------------------------------------------------- >>>>>>> To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San >>>> Francisco >>>>>> CA >>>>>>> , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 >>>>>>> >> -------------------------------------------------------------------------------- >>>>>>> Grand Total $680.00 >>>>>> >>>>>> ------------------------------ >>>>>> View message @ >>>>>> >> http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html >>>>>> To unsubscribe from Getting an error when creating Purchase Order, >> click >>>>>> here< (link removed) =>. >>>>>> >>>>>> >>>>>> >>>> >>> >> >> > > |
Re: Getting an error when creating Purchase Order
Administrator
|
In reply to this post by BJ Freeman
There is one demo for R9.04, it's even accessible from the OFBiz home page
Jacques From: "BJ Freeman" <[hidden email]> >I suggest you down load a separate 9.04 and install the demo data, and > run in local host mode. > try your PO to see if it works. > if so then compare the demo data with the data in your installation to > see what you don't have. > > I would suggest using the Demo server but they don't have one for 9.04 > right now. > > ========================= > BJ Freeman > http://bjfreeman.elance.com > Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> > 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> > > > Rishi Khanna sent the following on 4/3/2010 5:04 PM: >> I had no party with NA >> >> Veru confused >> >> On Sat, Apr 3, 2010 at 4:14 PM, Rishi Khanna <[hidden email]> wrote: >> >>> HI, >>> >>> Thanks for the help. >>> >>> But where I go and assign the role type carrier? >>> >>> Rishi >>> >>> On Sat, Apr 3, 2010 at 3:39 PM, BJ Freeman <[hidden email]> wrote: >>> >>>> the error says that you did not select a carrier. >>>> the default was put in _NA_ but is does not have a Role type Carrier >>>> assigned to it. >>>> >>>> ===================== >>>> BJ Freeman >>>> http://bjfreeman.elance.com >>>> Strategic Power Office with Supplier Automation < >>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>>> 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 >>>> >>>> rugstan sent the following on 4/3/2010 3:12 PM: >>>>> I am using 9.04 and when I press the button to finalize the Purchase >>>> Order >>>>> than I get this error and I cannot create a Purchase order. I tried >>>>> everyhing but cannot figure out the mistake I am making and where I am >>>>> making. >>>>> >>>>> Thanks >>>>> >>>>> Rishi >>>>> >>>>> On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] < >>>>> [hidden email]<ml-node%[hidden email]> >>>> <ml-node%[hidden email]<ml-node%[hidden email]> >>>>>> wrote: >>>> >> want version of ofbiz, please >>>>>> also what steps did you do and where did the error happen in the steps? >>>>>> thanks >>>>>> >>>>>> ========================= >>>>>> BJ Freeman >>>>>> http://bjfreeman.elance.com >>>>>> Strategic Power Office with Supplier Automation < >>>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>>>>> 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 >>>>>> >>>>>> >>>>>> rugstan sent the following on 4/3/2010 10:30 AM: >>>>>> >>>>>> > Hi, I am getting an error when creating a Purchase Order. Can anyone >>>>>> tell me >>>>>>> what I am doing wrong and how to fix it. >>>>>>> >>>>>>> The Following Errors Occurred: Did not complete the order, the >>>> following >>>>>>> occurred:ERROR : Could not create order (write error :Error while >>>>>> inserting: >>>>>> >>>> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 >>>>>>> 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 >>>>>>> >>>> 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 >>>>>>> 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 >>>>>>> >>>> 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 >>>>>>> 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 >>>>>>> >>>> 11:49:09.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 >>>>>>> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >>>> ?, >>>>>> ?) >>>>>>> (Cannot add or update a child row: a foreign key constraint fails >>>>>>> (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN >>>>>> KEY >>>>>>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, >>>> `CARRIER_ROLE_TYPE_ID`) >>>>>>> REFERENCES `carrier_shipment_method` (`SHIPMEN)))). >>>>>>> >>>>>>> Purchase Order : Order Confirmation Create OrderReview >>>>>>> OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad >>>>>>> >>>> -------------------------------------------------------------------------------- >>>>>>> Order Terms Term Type Term Value Term Days Description >>>>>>> >>>> -------------------------------------------------------------------------------- >>>>>>> Payment (net days) 30 >>>>>>> >>>> -------------------------------------------------------------------------------- >>>>>>> Splitting Preference Please wait until the entire order is ready >>>> before >>>>>>> shipping. >>>>>>> >>>> -------------------------------------------------------------------------------- >>>>>>> Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 >>>>>>> 11:49:09.000 Shipping InformationDestination Supplier Shipment Method >>>>>> Item >>>>>>> Quantity >>>>>>> >>>> -------------------------------------------------------------------------------- >>>>>>> To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San >>>> Francisco >>>>>> CA >>>>>>> , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 >>>>>>> >>>> -------------------------------------------------------------------------------- >>>>>>> Grand Total $680.00 >>>>>> >>>>>> >>>>>> ------------------------------ >>>>>> View message @ >>>>>> >>>> http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html >>>>>> To unsubscribe from Getting an error when creating Purchase Order, >>>> click >>>>>> here< (link removed) =>. >>>>>> >>>>>> >>>>>> >>>>> >>>> >>>> >>> >>> -- >>> Rishi Khanna >>> Director >>> Rugstan Inc. >>> Ph # 650-292-2493 >>> >> >> >> > > |
Re: Getting an error when creating Purchase Order
|
|
In reply to this post by BJ Freeman
thanks
========================= BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> 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> Jacques Le Roux sent the following on 4/4/2010 1:24 AM: > There is one demo for R9.04, it's even accessible from the OFBiz home page > > Jacques > > From: "BJ Freeman" <[hidden email]> >> I suggest you down load a separate 9.04 and install the demo data, and >> run in local host mode. >> try your PO to see if it works. >> if so then compare the demo data with the data in your installation to >> see what you don't have. >> >> I would suggest using the Demo server but they don't have one for 9.04 >> right now. >> >> ========================= >> BJ Freeman >> http://bjfreeman.elance.com >> Strategic Power Office with Supplier Automation >> <http://www.businessesnetwork.com/automation/viewforum.php?f=93> >> 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> >> >> >> >> Rishi Khanna sent the following on 4/3/2010 5:04 PM: >>> I had no party with NA >>> >>> Veru confused >>> >>> On Sat, Apr 3, 2010 at 4:14 PM, Rishi Khanna <[hidden email]> wrote: >>> >>>> HI, >>>> >>>> Thanks for the help. >>>> >>>> But where I go and assign the role type carrier? >>>> >>>> Rishi >>>> >>>> On Sat, Apr 3, 2010 at 3:39 PM, BJ Freeman <[hidden email]> >>>> wrote: >>>> >>>>> the error says that you did not select a carrier. >>>>> the default was put in _NA_ but is does not have a Role type Carrier >>>>> assigned to it. >>>>> >>>>> ===================== >>>>> BJ Freeman >>>>> http://bjfreeman.elance.com >>>>> Strategic Power Office with Supplier Automation < >>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>>>> 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 >>>>> >>>>> >>>>> rugstan sent the following on 4/3/2010 3:12 PM: >>>>>> I am using 9.04 and when I press the button to finalize the Purchase >>>>> Order >>>>>> than I get this error and I cannot create a Purchase order. I tried >>>>>> everyhing but cannot figure out the mistake I am making and where >>>>>> I am >>>>>> making. >>>>>> >>>>>> Thanks >>>>>> >>>>>> Rishi >>>>>> >>>>>> On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] < >>>>>> [hidden email]<ml-node%[hidden email]> >>>>>> >>>>> <ml-node%[hidden email]<ml-node%[hidden email]> >>>>> >>>>>>> wrote: >>>>> >> want version of ofbiz, please >>>>>>> also what steps did you do and where did the error happen in the >>>>>>> steps? >>>>>>> thanks >>>>>>> >>>>>>> ========================= >>>>>>> BJ Freeman >>>>>>> http://bjfreeman.elance.com >>>>>>> Strategic Power Office with Supplier Automation < >>>>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>>>>>> 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 >>>>> >>>>>>> >>>>>>> >>>>>>> rugstan sent the following on 4/3/2010 10:30 AM: >>>>>>> >>>>>>> > Hi, I am getting an error when creating a Purchase Order. Can >>>>>>> anyone >>>>>>> tell me >>>>>>>> what I am doing wrong and how to fix it. >>>>>>>> >>>>>>>> The Following Errors Occurred: Did not complete the order, the >>>>> following >>>>>>>> occurred:ERROR : Could not create order (write error :Error while >>>>>>> inserting: >>>>>>> >>>>> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 >>>>> >>>>>>>> 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 >>>>>>>> >>>>> 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 >>>>> >>>>>>>> 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 >>>>>>>> >>>>> 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 >>>>> >>>>>>>> 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 >>>>>>>> >>>>> 11:49:09.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 >>>>>>>> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >>>>>>>> ?, ?, >>>>> ?, >>>>>>> ?) >>>>>>>> (Cannot add or update a child row: a foreign key constraint fails >>>>>>>> (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` >>>>>>>> FOREIGN >>>>>>> KEY >>>>>>>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, >>>>> `CARRIER_ROLE_TYPE_ID`) >>>>>>>> REFERENCES `carrier_shipment_method` (`SHIPMEN)))). >>>>>>>> >>>>>>>> Purchase Order : Order Confirmation Create OrderReview >>>>>>>> OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad >>>>>>>> >>>>> -------------------------------------------------------------------------------- >>>>> >>>>>>>> Order Terms Term Type Term Value Term Days Description >>>>>>>> >>>>> -------------------------------------------------------------------------------- >>>>> >>>>>>>> Payment (net days) 30 >>>>>>>> >>>>> -------------------------------------------------------------------------------- >>>>> >>>>>>>> Splitting Preference Please wait until the entire order is ready >>>>> before >>>>>>>> shipping. >>>>>>>> >>>>> -------------------------------------------------------------------------------- >>>>> >>>>>>>> Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 >>>>>>>> 11:49:09.000 Shipping InformationDestination Supplier Shipment >>>>>>>> Method >>>>>>> Item >>>>>>>> Quantity >>>>>>>> >>>>> -------------------------------------------------------------------------------- >>>>> >>>>>>>> To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San >>>>> Francisco >>>>>>> CA >>>>>>>> , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 >>>>>>>> >>>>> -------------------------------------------------------------------------------- >>>>> >>>>>>>> Grand Total $680.00 >>>>>>> >>>>>>> >>>>>>> ------------------------------ >>>>>>> View message @ >>>>>>> >>>>> http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html >>>>> >>>>>>> To unsubscribe from Getting an error when creating Purchase Order, >>>>> click >>>>>>> here< (link removed) =>. >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>>> >>>> >>>> -- >>>> Rishi Khanna >>>> Director >>>> Rugstan Inc. >>>> Ph # 650-292-2493 >>>> >>> >>> >>> >> >> > > > |
|
|
In reply to this post by Jacques Le Roux
that do not have the purchase order in there under order entry.
On Sun, Apr 4, 2010 at 1:24 AM, Jacques Le Roux < [hidden email]> wrote: > There is one demo for R9.04, it's even accessible from the OFBiz home page > > Jacques > > From: "BJ Freeman" <[hidden email]> > > I suggest you down load a separate 9.04 and install the demo data, and >> run in local host mode. >> try your PO to see if it works. >> if so then compare the demo data with the data in your installation to >> see what you don't have. >> >> I would suggest using the Demo server but they don't have one for 9.04 >> right now. >> >> ========================= >> BJ Freeman >> http://bjfreeman.elance.com >> Strategic Power Office with Supplier Automation < >> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >> 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 >> > >> >> >> Rishi Khanna sent the following on 4/3/2010 5:04 PM: >> >>> I had no party with NA >>> >>> Veru confused >>> >>> On Sat, Apr 3, 2010 at 4:14 PM, Rishi Khanna <[hidden email]> wrote: >>> >>> HI, >>>> >>>> Thanks for the help. >>>> >>>> But where I go and assign the role type carrier? >>>> >>>> Rishi >>>> >>>> On Sat, Apr 3, 2010 at 3:39 PM, BJ Freeman <[hidden email]> >>>> wrote: >>>> >>>> the error says that you did not select a carrier. >>>>> the default was put in _NA_ but is does not have a Role type Carrier >>>>> assigned to it. >>>>> >>>>> ===================== >>>>> BJ Freeman >>>>> http://bjfreeman.elance.com >>>>> Strategic Power Office with Supplier Automation < >>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>>>> 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 >>>>> >>>>> rugstan sent the following on 4/3/2010 3:12 PM: >>>>> >>>>>> I am using 9.04 and when I press the button to finalize the Purchase >>>>>> >>>>> Order >>>>> >>>>>> than I get this error and I cannot create a Purchase order. I tried >>>>>> everyhing but cannot figure out the mistake I am making and where I am >>>>>> making. >>>>>> >>>>>> Thanks >>>>>> >>>>>> Rishi >>>>>> >>>>>> On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] < >>>>>> [hidden email]<ml-node%[hidden email]> >>>>>> <ml-node%[hidden email]<ml-node%[hidden email]> >>>>>> > >>>>>> >>>>> <ml-node%[hidden email]<ml-node%[hidden email]> >>>>> <ml-node%[hidden email]<ml-node%[hidden email]> >>>>> > >>>>> >>>>>> wrote: >>>>>>> >>>>>> >> want version of ofbiz, please >>>>> >>>>>> also what steps did you do and where did the error happen in the >>>>>>> steps? >>>>>>> thanks >>>>>>> >>>>>>> ========================= >>>>>>> BJ Freeman >>>>>>> http://bjfreeman.elance.com >>>>>>> Strategic Power Office with Supplier Automation < >>>>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>>>>>> 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 >>>>> >>>>>> >>>>>>> >>>>>>> rugstan sent the following on 4/3/2010 10:30 AM: >>>>>>> >>>>>>> > Hi, I am getting an error when creating a Purchase Order. Can >>>>>>> anyone >>>>>>> tell me >>>>>>> >>>>>>>> what I am doing wrong and how to fix it. >>>>>>>> >>>>>>>> The Following Errors Occurred: Did not complete the order, the >>>>>>>> >>>>>>> following >>>>> >>>>>> occurred:ERROR : Could not create order (write error :Error while >>>>>>>> >>>>>>> inserting: >>>>>>> >>>>>>> >>>>> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 >>>>> >>>>>> 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 >>>>>>>> >>>>>>>> >>>>> 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 >>>>> >>>>>> 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 >>>>>>>> >>>>>>>> >>>>> 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 >>>>> >>>>>> 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 >>>>>>>> >>>>>>>> >>>>> 11:49:09.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 >>>>>>>> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >>>>>>>> ?, >>>>>>>> >>>>>>> ?, >>>>> >>>>>> ?) >>>>>>> >>>>>>>> (Cannot add or update a child row: a foreign key constraint fails >>>>>>>> (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` >>>>>>>> FOREIGN >>>>>>>> >>>>>>> KEY >>>>>>> >>>>>>>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, >>>>>>>> >>>>>>> `CARRIER_ROLE_TYPE_ID`) >>>>> >>>>>> REFERENCES `carrier_shipment_method` (`SHIPMEN)))). >>>>>>>> >>>>>>>> Purchase Order : Order Confirmation Create OrderReview >>>>>>>> OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad >>>>>>>> >>>>>>>> >>>>> -------------------------------------------------------------------------------- >>>>> >>>>>> Order Terms Term Type Term Value Term Days Description >>>>>>>> >>>>>>>> >>>>> -------------------------------------------------------------------------------- >>>>> >>>>>> Payment (net days) 30 >>>>>>>> >>>>>>>> >>>>> -------------------------------------------------------------------------------- >>>>> >>>>>> Splitting Preference Please wait until the entire order is ready >>>>>>>> >>>>>>> before >>>>> >>>>>> shipping. >>>>>>>> >>>>>>>> >>>>> -------------------------------------------------------------------------------- >>>>> >>>>>> Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 >>>>>>>> 11:49:09.000 Shipping InformationDestination Supplier Shipment >>>>>>>> Method >>>>>>>> >>>>>>> Item >>>>>>> >>>>>>>> Quantity >>>>>>>> >>>>>>>> >>>>> -------------------------------------------------------------------------------- >>>>> >>>>>> To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San >>>>>>>> >>>>>>> Francisco >>>>> >>>>>> CA >>>>>>> >>>>>>>> , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 >>>>>>>> >>>>>>>> >>>>> -------------------------------------------------------------------------------- >>>>> >>>>>> Grand Total $680.00 >>>>>>>> >>>>>>> >>>>>>> >>>>>>> ------------------------------ >>>>>>> View message @ >>>>>>> >>>>>>> >>>>> http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html >>>>> >>>>>> To unsubscribe from Getting an error when creating Purchase Order, >>>>>>> >>>>>> click >>>>> >>>>>> here< (link removed) =>. >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>>> >>>> -- >>>> Rishi Khanna >>>> Director >>>> Rugstan Inc. >>>> Ph # 650-292-2493 >>>> >>>> >>> >>> >>> >> >> > > -- Rishi Khanna Director Rugstan Inc. Ph # 650-292-2493 |
Re: Getting an error when creating Purchase Order
|
|
In reply to this post by Jacques Le Roux
I run 9.04 for on one of my websites.
if you look at the order entry page you will see purchase order under sales order ========================= BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93> 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> Rishi Khanna sent the following on 4/4/2010 2:30 PM: > that do not have the purchase order in there under order entry. > > On Sun, Apr 4, 2010 at 1:24 AM, Jacques Le Roux < > [hidden email]> wrote: > >> There is one demo for R9.04, it's even accessible from the OFBiz home page >> >> Jacques >> >> From: "BJ Freeman" <[hidden email]> >> >> I suggest you down load a separate 9.04 and install the demo data, and >>> run in local host mode. >>> try your PO to see if it works. >>> if so then compare the demo data with the data in your installation to >>> see what you don't have. >>> >>> I would suggest using the Demo server but they don't have one for 9.04 >>> right now. >>> >>> ========================= >>> BJ Freeman >>> http://bjfreeman.elance.com >>> Strategic Power Office with Supplier Automation < >>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>> 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 >>> >>> Rishi Khanna sent the following on 4/3/2010 5:04 PM: >>> >>>> I had no party with NA >>>> >>>> Veru confused >>>> >>>> On Sat, Apr 3, 2010 at 4:14 PM, Rishi Khanna <[hidden email]> wrote: >>>> >>>> HI, >>>>> Thanks for the help. >>>>> >>>>> But where I go and assign the role type carrier? >>>>> >>>>> Rishi >>>>> >>>>> On Sat, Apr 3, 2010 at 3:39 PM, BJ Freeman <[hidden email]> >>>>> wrote: >>>>> >>>>> the error says that you did not select a carrier. >>>>>> the default was put in _NA_ but is does not have a Role type Carrier >>>>>> assigned to it. >>>>>> >>>>>> ===================== >>>>>> BJ Freeman >>>>>> http://bjfreeman.elance.com >>>>>> Strategic Power Office with Supplier Automation < >>>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>>>>> 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 >>>>>> >>>>>> rugstan sent the following on 4/3/2010 3:12 PM: >>>>>> >>>>>>> I am using 9.04 and when I press the button to finalize the Purchase >>>>>>> >>>>>> Order >>>>>> >>>>>>> than I get this error and I cannot create a Purchase order. I tried >>>>>>> everyhing but cannot figure out the mistake I am making and where I am >>>>>>> making. >>>>>>> >>>>>>> Thanks >>>>>>> >>>>>>> Rishi >>>>>>> >>>>>>> On Sat, Apr 3, 2010 at 12:58 PM, BJ Freeman [via OFBiz] < >>>>>>> [hidden email]<ml-node%[hidden email]> >>>>>>> <ml-node%[hidden email]<ml-node%[hidden email]> >>>>>> <ml-node%[hidden email]<ml-node%[hidden email]> >>>>>> <ml-node%[hidden email]<ml-node%[hidden email]> >>>>>>> wrote: >>>>>>> >> want version of ofbiz, please >>>>>>> also what steps did you do and where did the error happen in the >>>>>>>> steps? >>>>>>>> thanks >>>>>>>> >>>>>>>> ========================= >>>>>>>> BJ Freeman >>>>>>>> http://bjfreeman.elance.com >>>>>>>> Strategic Power Office with Supplier Automation < >>>>>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=93> >>>>>>>> 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 >>>>>> >>>>>>>> rugstan sent the following on 4/3/2010 10:30 AM: >>>>>>>> >>>>>>>> > Hi, I am getting an error when creating a Purchase Order. Can >>>>>>>> anyone >>>>>>>> tell me >>>>>>>> >>>>>>>>> what I am doing wrong and how to fix it. >>>>>>>>> >>>>>>>>> The Following Errors Occurred: Did not complete the order, the >>>>>>>>> >>>>>>>> following >>>>>>> occurred:ERROR : Could not create order (write error :Error while >>>>>>>> inserting: >>>>>>>> >>>>>>>> >>>>>> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 >>>>>> >>>>>>> 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 >>>>>>>>> >>>>>> 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 >>>>>> >>>>>>> 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 >>>>>>>>> >>>>>> 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 >>>>>> >>>>>>> 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 >>>>>>>>> >>>>>> 11:49:09.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 >>>>>>>>> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >>>>>>>>> ?, >>>>>>>>> >>>>>>>> ?, >>>>>>> ?) >>>>>>>>> (Cannot add or update a child row: a foreign key constraint fails >>>>>>>>> (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` >>>>>>>>> FOREIGN >>>>>>>>> >>>>>>>> KEY >>>>>>>> >>>>>>>>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, >>>>>>>>> >>>>>>>> `CARRIER_ROLE_TYPE_ID`) >>>>>>> REFERENCES `carrier_shipment_method` (`SHIPMEN)))). >>>>>>>>> Purchase Order : Order Confirmation Create OrderReview >>>>>>>>> OrderPartiesOptionsShippingOrder TermsOrder Items Order Name pad >>>>>>>>> >>>>>>>>> >>>>>> -------------------------------------------------------------------------------- >>>>>> >>>>>>> Order Terms Term Type Term Value Term Days Description >>>>>>>>> >>>>>> -------------------------------------------------------------------------------- >>>>>> >>>>>>> Payment (net days) 30 >>>>>>>>> >>>>>> -------------------------------------------------------------------------------- >>>>>> >>>>>>> Splitting Preference Please wait until the entire order is ready >>>>>>>> before >>>>>>> shipping. >>>>>>>>> >>>>>> -------------------------------------------------------------------------------- >>>>>> >>>>>>> Ship After Date 2010-03-29 11:49:02.000 Ship Before Date 2010-03-31 >>>>>>>>> 11:49:09.000 Shipping InformationDestination Supplier Shipment >>>>>>>>> Method >>>>>>>>> >>>>>>>> Item >>>>>>>> >>>>>>>>> Quantity >>>>>>>>> >>>>>>>>> >>>>>> -------------------------------------------------------------------------------- >>>>>> >>>>>>> To: ABC Decorative Rugs Attn: Farhan Qazi 1 Henry Adams St. San >>>>>>>> Francisco >>>>>>> CA >>>>>>>>> , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2 >>>>>>>>> >>>>>>>>> >>>>>> -------------------------------------------------------------------------------- >>>>>> >>>>>>> Grand Total $680.00 >>>>>>>> >>>>>>>> ------------------------------ >>>>>>>> View message @ >>>>>>>> >>>>>>>> >>>>>> http://n4.nabble.com/Getting-an-error-when-creating-Purchase-Order-tp1750301p1750438.html >>>>>> >>>>>>> To unsubscribe from Getting an error when creating Purchase Order, >>>>>>> click >>>>>>> here< (link removed) =>. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>> >>>>> -- >>>>> Rishi Khanna >>>>> Director >>>>> Rugstan Inc. >>>>> Ph # 650-292-2493 >>>>> >>>>> >>>> >>>> >>> >> > > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |