Bug 20056

Summary:	Some sort of Oracle / web database error
Product:	Red Hat Web Site	Reporter:	Jeffrey Cohen <nobody+jcohen>
Component:	Store	Assignee:	Tom Lancaster <tlancast>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Paul Lindner <plindner>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	current	CC:	skothari
Target Milestone:	---
Target Release:	---
Hardware:	i386
OS:	Linux
URL:	http://www.redhat.com/apps/internalstore/verify.html?
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2000-10-31 19:15:15 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Jeffrey Cohen 2000-10-30 19:50:26 UTC

Entering an order in 'internal' web store generated  the following:

http://www.redhat.com/apps/internalstore/verify.html?ship_method%3Amethod_cb=FXEC&store_cart%3Aadd_item_cb=&amp;store_cart%3Akeep_10569=1&amp;store_cart%3Aqty_10569=1&amp;store_cart%3Ainternal_shipping=8.95&amp;order_cancel%3Aurl=%2Fapps%2Finternalstore&amp;order_suhttp://www.redhat.com/apps/internalstore/verify.html?ship_method%3Amethod_cb=FXEC&store_cart%3Aadd_item_cb=&amp;store_cart%3Akeep_10569=1&amp;store_cart%3Aqty_10569=1&amp;store_cart%3Ainternal_shipping=8.95&amp;order_cancel%3Aurl=%2Fapps%2Finternalstore&amp;order_submit%3Aend_page=%2Fapps%2Finternalstore%2Fthankyou.html&amp;order_submit%3Asubmit_cb=Submit+Order&amp;asp_charset=iso-8859-1


A database error occured: DBD::Oracle::db do failed: ORA-00001: unique
constraint
(WEB.WEB_USER_ORDER_ID_PK) violated (DBD ERROR: OCIStmtExecute) at
/var/www/lib/WebUser/Order.pm line 507. 
Failed to submit order 'I2195781': 

Please choose a shipping method below.


     Shipping Method 
                                      Description 
    
     FedEx Economy 2 Day 
                         Delivery to most areas in US within 2 business
                         days if ordered prior to 12:00 noon, EST. 




Add Items:

Add Discount:


Item
                                    Unit
                                   Price
                                         Unit
                                          Wt
                                               Unit
                                               Qty
                                                     Total
                                                      Wt.
                                                                Total
                                                                Price


Red Hat Linux 6.2 documentation
CD
                                    9.95
                                         0.12

                                                     0.12
                                                                9.95 


                                           Order Subtotal 
                                                                $9.95
                                        Order Weight (lbs) 
                                                                0.125 
                                    Shipping and Handling 
                                                            $ 
                                               Order Tax 
                                                                $0.86 
                                                    Total 
                                                               $19.76 

     Check here if you entered shipping charges in the field above and want
that
value to replace calculated shipping charges 
                                                                      




Billing Information
Eric Rice

3713 231 St. E.

Spanaway, WA 98387-6962
US 
Phone: 253-846-5030
                                 Shipping Information
                                 Eric Rice

                                 3713 231 St. E.

                                 Spanaway, WA 98387-6962
                                 US 

                                 Payment Information
                                 VS   4426248679636434
                                 Expires: 08/2003

Comment 1 Jeffrey Cohen 2000-10-31 19:15:12 UTC

Here is another

http://www.redhat.com/apps/internalstore/verify.html?ship_method%3Amethod_cb=FXEC&store_cart%3Aadd_item_cb=&store_cart%3Akeep_RH11000=1&store_cart%3Aqty_RH11000=6&store_cart%3Ainternal_shipping=0.00&order_cancel%3Aurl=%2Fapps%2Finternalstore&order_submit%3Aend_page=%2Fapps%2Finternalstore%2Fthankyou.html&order_submit%3Asubmit_cb=Submit+Order&asp_charset=iso-8859-1

Confirm Order Information


A database error occured: DBD::Oracle::db do failed: ORA-00001: unique
constraint (WEB.WEB_USER_ORDER_ID_PK) violated (DBD ERROR: OCIStmtExecute) at
/var/www/lib/WebUser/Order.pm line 507. 
Failed to submit order 'I2196031': 

Please choose a shipping method below.


      Shipping Method 
                                       Description 
   
     FedEx Economy 2 Day 
                         Delivery to most areas in US within 2 business days if
                         ordered prior to 12:00 noon, EST. 




Add Items:

Add Discount:


Item
                                    Unit
                                   Price
                                          Unit
                                           Wt
                                               Unit
                                               Qty
                                                     Total
                                                      Wt.
                                                                Total
                                                                Price


Red Hat Linux 6.2/Intel Standard
                                   29.95
                                          2.00

                                                     12.00
                                                                179.7 


                                             Order Subtotal 
                                                               $179.70
                                           Order Weight (lbs) 
                                                                  12 
                                        Shipping and Handling 
                                                            $ 
                                                Order Tax 
                                                               $13.03 
                                                    Total 
                                                              $214.68 

    Check here if you entered shipping charges in the field above and want that
value to
replace calculated shipping charges 
                                                                     




Billing Information
Jas Pannu

2480 Kruse Dr

San Jose, CA 95131
US 
Phone: 555-555-5555
                                 Shipping Information
                                 Jas Pannu
                                 BSDI
                                 2480 Kruse Dr

                                 San Jose, CA 95131
             US 

                                 Payment Information
                                 VS   5490960004327822
                                 Expires: 12/2002

Comment 2 Tom Lancaster 2001-04-09 22:55:45 UTC

Sequence error. Must be fixed by now...