Users - PO entry problem
Locked
 
|
I got opentaps 0.9.0 to work and have a problem entering a Purchase Order:
I pick an "Internal Organization" and a "Supplier", which should be enough to get on to the next step. However, I get an error "Error calling event: org.ofbiz.webapp.event.EventHandlerException: Problems processing event: java.lang.IllegalArgumentException: productStoreId cannot be null (productStoreId cannot be null)" There is a field "Product Store", but it is in the top section of the screen, which is related to Sales Orders, not Purchase Orders. And it is not NULL either... MARK _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
Which supplier and internal organization?
I just created this order: https://demo.opensourcestrategies.com:8445/ordermgr/control/orderview?orderId=WS10031 Can you try it on our server? Si Mark wrote: > I got opentaps 0.9.0 to work and have a problem entering a Purchase Order: > I pick an "Internal Organization" and a "Supplier", which should be > enough to get on to the next step. > However, I get an error "Error calling event: > org.ofbiz.webapp.event.EventHandlerException: Problems processing event: > java.lang.IllegalArgumentException: productStoreId cannot be null > (productStoreId cannot be null)" > > There is a field "Product Store", but it is in the top section of the > screen, which is related to Sales Orders, not Purchase Orders. And it is > not NULL either... > > MARK > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > > > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
I tried it on my fresh install. I only loaded the seed data, not the demo data. I am not exactly sure what kind of facilities/parties/stores to set up and what settings they need, but I got enough entities, facilities and one store to have all the dropdowns on that "Order Entry" page populated with at least one entry. And I picked one for each of them. Interestingly, I am able to create "Sales Orders", just "Purchase Orders" do not work. But the error messages seems to refer to a field of the Sales Order, not the Purchase Order. I have one party set up as "Internal Organization", a different one as "Supplier" and one Store in the "Catalog" section. Do I need more? Is there any documentation regarding the minimum required configuration of parties, facilities, etc? Or something else on how all those entities are related? Thanks, MARK Si Chen wrote: Which supplier and internal organization? I just created this order: https://demo.opensourcestrategies.com:8445/ordermgr/control/orderview?orderId=WS10031 Can you try it on our server? Si Mark wrote:I got opentaps 0.9.0 to work and have a problem entering a Purchase Order: I pick an "Internal Organization" and a "Supplier", which should be enough to get on to the next step. However, I get an error "Error calling event: org.ofbiz.webapp.event.EventHandlerException: Problems processing event: java.lang.IllegalArgumentException: productStoreId cannot be null (productStoreId cannot be null)" There is a field "Product Store", but it is in the top section of the screen, which is related to Sales Orders, not Purchase Orders. And it is not NULL either... MARK _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users_______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
Mark,
Yes, it is a data issue. If you have only installed the seed data, then you are looking at a fresh implementation from scratch. This is pretty complicated. You might want to go through the undersun doc site. Also we'll have some more documentation available soon. Your specific problem is a legacy gremlin in the purchasing code. We wrote it a long time ago by adopting the sales order code, so it still checks for a productStoreId which is configured in applications/order/webapp/ordermgr/WEB-INF/web.xml. If the productStoreId does not reference a real product store set up in catalog manager, purchase orders will not work, even though it doesn't do anything with the productStoreId. Sorry for the inconvenience--we should probably re-factor that in an idealized world. Si Mark wrote:
_______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
> Sorry for the inconvenience--we should probably re-factor that in an > idealized world. Idealized world ? That sounds great! If you find one reserve a spot for me! :-) _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
In reply to this post by Si Chen-2
I also tried to compare the various store/entity configurations of the demo setup and my fresh install, but I can just not figure out where the system gets the ProductStore from... Can you give me a hint? Thank you, MARK Si Chen wrote: Mark, _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
Mark, have you looked in applications/ecommerce/data/DemoProduct.xml then look for ProductStore. you'll see all the productstore entities there. you can copy that file somewhere else and carve it up then import it with java -jar ofbiz.jar -install -timeout=21600 -file=/full/path/to/new/DemoProduct.xml Hope that helps. Fred Mark wrote: > I am playing around with this, tried to change the source, but I don't know all > the relations that ShoppingCart has to other objects. > I also tried to compare the various store/entity configurations of the demo > setup and my fresh install, but I can just not figure out where the system gets > the ProductStore from... > Can you give me a hint? > > Thank you, > > MARK > > > Si Chen wrote: > >> Mark, >> >> Yes, it is a data issue. If you have only installed the seed data, then you >> are looking at a fresh implementation from scratch. This is pretty >> complicated. You might want to go through the undersun doc site. Also we'll >> have some more documentation available soon. >> >> Your specific problem is a legacy gremlin in the purchasing code. We wrote it >> a long time ago by adopting the sales order code, so it still checks for a >> productStoreId which is configured in >> applications/order/webapp/ordermgr/WEB-INF/web.xml. If the productStoreId >> does not reference a real product store set up in catalog manager, purchase >> orders will not work, even though it doesn't do anything with the >> productStoreId. Sorry for the inconvenience--we should probably re-factor >> that in an idealized world. >> >> Si >> >> Mark wrote: >> >>> It works on your server. Maybe a data issue? >>> I tried it on my fresh install. I only loaded the seed data, not the demo >>> data. I am not exactly sure what kind of facilities/parties/stores to set up >>> and what settings they need, but I got enough entities, facilities and one >>> store to have all the dropdowns on that "Order Entry" page populated with at >>> least one entry. >>> And I picked one for each of them. >>> >>> Interestingly, I am able to create "Sales Orders", just "Purchase Orders" do >>> not work. But the error messages seems to refer to a field of the Sales >>> Order, not the Purchase Order. >>> >>> I have one party set up as "Internal Organization", a different one as >>> "Supplier" and one Store in the "Catalog" section. Do I need more? Is there >>> any documentation regarding the minimum required configuration of parties, >>> facilities, etc? Or something else on how all those entities are related? >>> >>> Thanks, >>> >>> MARK >>> >>> >>> >>> >>> Si Chen wrote: >>> >>>>Which supplier and internal organization? >>>> >>>>I just created this order: >>>>https://demo.opensourcestrategies.com:8445/ordermgr/control/orderview?orderId=WS10031 >>>>Can you try it on our server? >>>> >>>>Si >>>> >>>>Mark wrote: >>>> >>>> >>>>>I got opentaps 0.9.0 to work and have a problem entering a Purchase Order: >>>>>I pick an "Internal Organization" and a "Supplier", which should be >>>>>enough to get on to the next step. >>>>>However, I get an error "Error calling event: >>>>>org.ofbiz.webapp.event.EventHandlerException: Problems processing event: >>>>>java.lang.IllegalArgumentException: productStoreId cannot be null >>>>>(productStoreId cannot be null)" >>>>> >>>>>There is a field "Product Store", but it is in the top section of the >>>>>screen, which is related to Sales Orders, not Purchase Orders. And it is >>>>>not NULL either... >>>>> >>>>>MARK >>>>> >>>>>_______________________________________________ >>>>>Users mailing list >>>>>[hidden email] >>>>>http://lists.ofbiz.org/mailman/listinfo/users >>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>>>_______________________________________________ >>>>Users mailing list >>>>[hidden email] >>>>http://lists.ofbiz.org/mailman/listinfo/users >>>> >>>> >>>> >>>> >>>> >>> >>>-------------------------------------------------------------------------------- >>> >>> >>>_______________________________________________ >>>Users mailing list >>>[hidden email] >>>http://lists.ofbiz.org/mailman/listinfo/users >>> >>-------------------------------------------------------------------------------- >> >> >>_______________________________________________ >>Users mailing list >>[hidden email] >>http://lists.ofbiz.org/mailman/listinfo/users >> > > > ------------------------------------------------------------------------ > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
Well, I kind of lost sight of the fact that PO entry does work using
the demo data setup - so rather than changing the code I am just trying
to create the proper entity relations for my data setup.
The setup I am using is running on a database that I initialized with the "seed" reader data, but without the "demo" reader data. I created some Products, Stores, Entities, Websites, Catalog etc, but the system can still not get the ProductStoreId it needs for a new PO. I don't know where that ID comes from, it must be some relation somewhere, but I haven't figured it out yet... Thanks, MARK Fred Forester wrote: Mark, have you looked in applications/ecommerce/data/DemoProduct.xml then look for ProductStore. you'll see all the productstore entities there. you can copy that file somewhere else and carve it up then import it with java -jar ofbiz.jar -install -timeout=21600 -file=/full/path/to/new/DemoProduct.xml Hope that helps. Fred Mark wrote: _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
On Monday 15 May 2006 05:18, Mark wrote:
>.... > I don't know where that ID comes from, it must be some relation > somewhere, but I haven't figured it out yet...<br> Please have a look in the file WEB-INF/web.xml, there is the productStoreId defined. hope this helps... -- Regards, Hans Bakker ANT Websystems Co.,Ltd (http://www.antwebsystems.com) If you want to verify that this message really originates from from the above person, download the public key from: http://www.antwebsystems.com/hbakkerAntwebsystems.asc _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
attachment0 (196 bytes) |
|
Sorry, the websiteId is defined here which should specify the productStoreId
On Monday 15 May 2006 05:27, Hans Bakker wrote: > On Monday 15 May 2006 05:18, Mark wrote: > >.... > > I don't know where that ID comes from, it must be some relation > > somewhere, but I haven't figured it out yet...<br> > > Please have a look in the file WEB-INF/web.xml, there is the productStoreId > defined. > > hope this helps... -- Regards, Hans Bakker ANT Websystems Co.,Ltd (http://www.antwebsystems.com) If you want to verify that this message really originates from from the above person, download the public key from: http://www.antwebsystems.com/hbakkerAntwebsystems.asc _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
In reply to this post by Mark-60
Can you copy and paste all the error messages from the screen and from the logs? it may help in searching the code to see those exactly as they appear Thanx Fred Mark wrote: > Well, I kind of lost sight of the fact that PO entry does work using the demo > data setup - so rather than changing the code I am just trying to create the > proper entity relations for my data setup. > The setup I am using is running on a database that I initialized with the "seed" > reader data, but without the "demo" reader data. > > I created some Products, Stores, Entities, Websites, Catalog etc, but the system > can still not get the ProductStoreId it needs for a new PO. I don't know where > that ID comes from, it must be some relation somewhere, but I haven't figured it > out yet... > > Thanks, > > MARK > > > Fred Forester wrote: > >>Mark, >> >>have you looked in applications/ecommerce/data/DemoProduct.xml then look >>for ProductStore. you'll see all the productstore entities there. >> >>you can copy that file somewhere else and carve it up then import it with >>java -jar ofbiz.jar -install -timeout=21600 >>-file=/full/path/to/new/DemoProduct.xml >> >> >> >>Hope that helps. >> >>Fred >> >> >>Mark wrote: >> >> >>>I am playing around with this, tried to change the source, but I don't know all >>>the relations that ShoppingCart has to other objects. >>>I also tried to compare the various store/entity configurations of the demo >>>setup and my fresh install, but I can just not figure out where the system gets >>>the ProductStore from... >>>Can you give me a hint? >>> >>>Thank you, >>> >>>MARK >>> >>> >>>Si Chen wrote: >>> >>> >>> >>>>Mark, >>>> >>>>Yes, it is a data issue. If you have only installed the seed data, then you >>>>are looking at a fresh implementation from scratch. This is pretty >>>>complicated. You might want to go through the undersun doc site. Also we'll >>>>have some more documentation available soon. >>>> >>>>Your specific problem is a legacy gremlin in the purchasing code. We wrote it >>>>a long time ago by adopting the sales order code, so it still checks for a >>>>productStoreId which is configured in >>>>applications/order/webapp/ordermgr/WEB-INF/web.xml. If the productStoreId >>>>does not reference a real product store set up in catalog manager, purchase >>>>orders will not work, even though it doesn't do anything with the >>>>productStoreId. Sorry for the inconvenience--we should probably re-factor >>>>that in an idealized world. >>>> >>>>Si >>>> >>>>Mark wrote: >>>> >>>> >>>> >>>>>It works on your server. Maybe a data issue? >>>>>I tried it on my fresh install. I only loaded the seed data, not the demo >>>>>data. I am not exactly sure what kind of facilities/parties/stores to set up >>>>>and what settings they need, but I got enough entities, facilities and one >>>>>store to have all the dropdowns on that "Order Entry" page populated with at >>>>>least one entry. >>>>>And I picked one for each of them. >>>>> >>>>>Interestingly, I am able to create "Sales Orders", just "Purchase Orders" do >>>>>not work. But the error messages seems to refer to a field of the Sales >>>>>Order, not the Purchase Order. >>>>> >>>>>I have one party set up as "Internal Organization", a different one as >>>>>"Supplier" and one Store in the "Catalog" section. Do I need more? Is there >>>>>any documentation regarding the minimum required configuration of parties, >>>>>facilities, etc? Or something else on how all those entities are related? >>>>> >>>>>Thanks, >>>>> >>>>>MARK >>>>> >>>>> >>>>> >>>>> >>>>>Si Chen wrote: >>>>> >>>>> >>>>> >>>>>>Which supplier and internal organization? >>>>>> >>>>>>I just created this order: >>>>>>https://demo.opensourcestrategies.com:8445/ordermgr/control/orderview?orderId=WS10031 >>>>>>Can you try it on our server? >>>>>> >>>>>>Si >>>>>> >>>>>>Mark wrote: >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>>I got opentaps 0.9.0 to work and have a problem entering a Purchase Order: >>>>>>>I pick an "Internal Organization" and a "Supplier", which should be >>>>>>>enough to get on to the next step. >>>>>>>However, I get an error "Error calling event: >>>>>>>org.ofbiz.webapp.event.EventHandlerException: Problems processing event: >>>>>>>java.lang.IllegalArgumentException: productStoreId cannot be null >>>>>>>(productStoreId cannot be null)" >>>>>>> >>>>>>>There is a field "Product Store", but it is in the top section of the >>>>>>>screen, which is related to Sales Orders, not Purchase Orders. And it is >>>>>>>not NULL either... >>>>>>> >>>>>>>MARK >>>>>>> >>>>>>>_______________________________________________ >>>>>>>Users mailing list >>>>>>>[hidden email] >>>>>>>http://lists.ofbiz.org/mailman/listinfo/users >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>_______________________________________________ >>>>>>Users mailing list >>>>>>[hidden email] >>>>>>http://lists.ofbiz.org/mailman/listinfo/users >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>-------------------------------------------------------------------------------- >>>>> >>>>> >>>>>_______________________________________________ >>>>>Users mailing list >>>>>[hidden email] >>>>>http://lists.ofbiz.org/mailman/listinfo/users >>>>> >>>>> >>>>> >>>>-------------------------------------------------------------------------------- >>>> >>>> >>>>_______________________________________________ >>>>Users mailing list >>>>[hidden email] >>>>http://lists.ofbiz.org/mailman/listinfo/users >>>> >>>> >>>> >>>------------------------------------------------------------------------ >>> >>> >>>_______________________________________________ >>>Users mailing list >>>[hidden email] >>>http://lists.ofbiz.org/mailman/listinfo/users >>> >>> >> >>_______________________________________________ >>Users mailing list >>[hidden email] >>http://lists.ofbiz.org/mailman/listinfo/users >> >> >> >> >> > > > ------------------------------------------------------------------------ > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
I think Hans might just have given me the tip I needed.
I'll check it out and let you know. Thanks, MARK Fred Forester wrote: > Can you copy and paste all the error messages from the screen and from > the logs? it may help in searching the code to see those exactly as they > appear > > Thanx > Fred > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
In reply to this post by Hans Bakker
OK, now I get to step through all the PO screens up to the last "Create
Order" step.
That causes this error: Did not complete the order, the following occurred:ERROR : Could not create order (write error :Exception while inserting the following entity: [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10011(java.lang.String)][createdStamp,2006-05-14 16:19:08.875(java.sql.Timestamp)][createdTxStamp,2006-05-14 16:19:08.718(java.sql.Timestamp)][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2006-05-14 16:19:08.875(java.sql.Timestamp)][lastUpdatedTxStamp,2006-05-14 16:19:08.718(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10022(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)] (while inserting: [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10011(java.lang.String)][createdStamp,2006-05-14 16:19:08.875(java.sql.Timestamp)][createdTxStamp,2006-05-14 16:19:08.718(java.sql.Timestamp)][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2006-05-14 16:19:08.875(java.sql.Timestamp)][lastUpdatedTxStamp,2006-05-14 16:19:08.718(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10022(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)] (SQL Exception while executing the following:INSERT INTO ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_METHOD_TYPE_ID, CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, CONTACT_MECH_ID, TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Cannot add or update a child row: a foreign key constraint fails (`ofbiz5/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` (`SHIPMENT)")))). What causes this one? How can I get rid of it? I don't really need shipment, since the Items are picked up at a local supplier (retail store)... Thanks, MARK Hans Bakker wrote: Sorry, the websiteId is defined here which should specify the productStoreId On Monday 15 May 2006 05:27, Hans Bakker wrote: _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
Its possible that you need to import "ecommerce/data/DemoShipping.xml" or set them up yourself. ofbiz may require this info for the order but you may be able to just ignore it. still a relative newbie myself so just taking a guess on this one. note that you may have to change the values of partyId="Company" and productStoreId="9000" to match what you used when you set it up manually Fred Mark wrote: > OK, now I get to step through all the PO screens up to the last "Create Order" step. > That causes this error: > > Did not complete the order, the following occurred:ERROR : Could not create > order (write error :Exception while inserting the following entity: > [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10011(java.lang.String)][createdStamp,2006-05-14 > 16:19:08.875(java.sql.Timestamp)][createdTxStamp,2006-05-14 > 16:19:08.718(java.sql.Timestamp)][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2006-05-14 > 16:19:08.875(java.sql.Timestamp)][lastUpdatedTxStamp,2006-05-14 > 16:19:08.718(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10022(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)] > (while inserting: > [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10011(java.lang.String)][createdStamp,2006-05-14 > 16:19:08.875(java.sql.Timestamp)][createdTxStamp,2006-05-14 > 16:19:08.718(java.sql.Timestamp)][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2006-05-14 > 16:19:08.875(java.sql.Timestamp)][lastUpdatedTxStamp,2006-05-14 > 16:19:08.718(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10022(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO ORDER_ITEM_SHIP_GROUP > (ORDER_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_METHOD_TYPE_ID, CARRIER_PARTY_ID, > CARRIER_ROLE_TYPE_ID, CONTACT_MECH_ID, TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, > SHIPPING_INSTRUCTIONS, MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, > SHIP_BY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, > CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > (Duplicate key or integrity constraint violation message from server: "Cannot > add or update a child row: a foreign key constraint fails > (`ofbiz5/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` (`SHIPMENT)")))). > > > What causes this one? How can I get rid of it? > I don't really need shipment, since the Items are picked up at a local supplier > (retail store)... > > Thanks, > > MARK > > > Hans Bakker wrote: > >>Sorry, the websiteId is defined here which should specify the productStoreId >> >>On Monday 15 May 2006 05:27, Hans Bakker wrote: >> >> >>>On Monday 15 May 2006 05:18, Mark wrote: >>> >>> >>>>.... >>>>I don't know where that ID comes from, it must be some relation >>>>somewhere, but I haven't figured it out yet...<br> >>>> >>>> >>>Please have a look in the file WEB-INF/web.xml, there is the productStoreId >>>defined. >>> >>>hope this helps... >>> >>> >> >> >> >>-------------------------------------------------------------------------------- >> >> >>_______________________________________________ >>Users mailing list >>[hidden email] >>http://lists.ofbiz.org/mailman/listinfo/users >> > > > ------------------------------------------------------------------------ > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
That file isn't really necessary, but a properly setup shipping method is. It looks like the shipping method used (from the error message the shipmentMethodTypeId is NO_SHIPPING) is not valid, and the carrier information is also missing. From the data model perspective the shipmentMethodTypeId must be null for no shipment method, hence the error. Actually, to work with every else it is best to create a no shipping shipment method that is explicitly defined with the _NA_ partyId and roleTypeId. -David Fred Forester wrote: > Its possible that you need to import "ecommerce/data/DemoShipping.xml" > or set them up yourself. ofbiz may require this info for the order but > you may be able to just ignore it. still a relative newbie myself so > just taking a guess on this one. > > note that you may have to change the values of partyId="Company" and > productStoreId="9000" to match what you used when you set it up manually > > > > Fred > > > > Mark wrote: >> OK, now I get to step through all the PO screens up to the last "Create Order" step. >> That causes this error: >> >> Did not complete the order, the following occurred:ERROR : Could not create >> order (write error :Exception while inserting the following entity: >> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10011(java.lang.String)][createdStamp,2006-05-14 >> 16:19:08.875(java.sql.Timestamp)][createdTxStamp,2006-05-14 >> 16:19:08.718(java.sql.Timestamp)][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2006-05-14 >> 16:19:08.875(java.sql.Timestamp)][lastUpdatedTxStamp,2006-05-14 >> 16:19:08.718(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10022(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)] >> (while inserting: >> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10011(java.lang.String)][createdStamp,2006-05-14 >> 16:19:08.875(java.sql.Timestamp)][createdTxStamp,2006-05-14 >> 16:19:08.718(java.sql.Timestamp)][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2006-05-14 >> 16:19:08.875(java.sql.Timestamp)][lastUpdatedTxStamp,2006-05-14 >> 16:19:08.718(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10022(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)] >> (SQL Exception while executing the following:INSERT INTO ORDER_ITEM_SHIP_GROUP >> (ORDER_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_METHOD_TYPE_ID, CARRIER_PARTY_ID, >> CARRIER_ROLE_TYPE_ID, CONTACT_MECH_ID, TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, >> SHIPPING_INSTRUCTIONS, MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, >> SHIP_BY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, >> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) >> (Duplicate key or integrity constraint violation message from server: "Cannot >> add or update a child row: a foreign key constraint fails >> (`ofbiz5/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` (`SHIPMENT)")))). >> >> >> What causes this one? How can I get rid of it? >> I don't really need shipment, since the Items are picked up at a local supplier >> (retail store)... >> >> Thanks, >> >> MARK >> >> >> Hans Bakker wrote: >> >>> Sorry, the websiteId is defined here which should specify the productStoreId >>> >>> On Monday 15 May 2006 05:27, Hans Bakker wrote: >>> >>> >>>> On Monday 15 May 2006 05:18, Mark wrote: >>>> >>>> >>>>> .... >>>>> I don't know where that ID comes from, it must be some relation >>>>> somewhere, but I haven't figured it out yet...<br> >>>>> >>>>> >>>> Please have a look in the file WEB-INF/web.xml, there is the productStoreId >>>> defined. >>>> >>>> hope this helps... >>>> >>>> >>> >>> >>> -------------------------------------------------------------------------------- >>> >>> >>> _______________________________________________ >>> Users mailing list >>> [hidden email] >>> http://lists.ofbiz.org/mailman/listinfo/users >>> >> >> ------------------------------------------------------------------------ >> >> >> _______________________________________________ >> Users mailing list >> [hidden email] >> http://lists.ofbiz.org/mailman/listinfo/users > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |