You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ofbiz.apache.org by Mark Schneider <ms...@it-infrastrukturen.org> on 2012/12/07 19:39:13 UTC

ERROR 23503: INSERT on table 'ORDER_CONTACT_MECH' caused a violation of foreign key constraint 'ORDER_CMECH_CM' for key (10004)

Hello,

It looks like a bug in ecommerce (a try to execute a new order on OFBiz 
11.04.01).
# ---
ERROR 23503: INSERT on table 'ORDER_CONTACT_MECH' caused a violation of 
foreign key constraint 'ORDER_CMECH_CM' for key (10004)

More details are in the attached file.

regards, Mark

-- 
ms@it-infrastrukturen.org

http://rsync.it-infrastrukturen.org

Re: Re: Two .png files more / Re: ERROR 23503: INSERT on table 'ORDER_CONTACT_MECH' caused a violation of foreign key constraint 'ORDER_CMECH_CM' for key (10004)

Posted by Jacques Le Roux <ja...@les7arts.com>.

Did not get a chance yet, but I will defintively have a look

The log error is clear

2012-12-08 20:54:00,849 (http-0.0.0.0-8443-1) [ ServiceDispatcher.java:532:ERROR] Error in Service [createCreditCard]: 1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)
2012-12-08 20:54:00,859 (http-0.0.0.0-8443-1) [ CallService.java:333:ERROR] 
---- exception report ----------------------------------------------------------
Exception: java.lang.Exception
Message: Error:�1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)��calling service createCreditCard in createUpdateCreditCard
---- stack trace ---------------------------------------------------------------
java.lang.Exception: Error:�1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)��calling service createCreditCard in createUpdateCreditCard

So it should no be a big deal, only that this message is not correctly returned to the UI. You could maybe have a look and provide a patch?

Jacques
  ----- Original Message ----- 
  From: Mark Schneider 
  To: user@ofbiz.apache.org 
  Sent: Sunday, December 09, 2012 12:27 AM
  Subject: Fwd: Re: Two .png files more / Re: ERROR 23503: INSERT on table 'ORDER_CONTACT_MECH' caused a violation of foreign key constraint 'ORDER_CMECH_CM' for key (10004)



  png-files.zip

  It looks like attached -png files are excluded from the original email .. just now as .zip file


  Am 08.12.2012 23:55, schrieb Mark Schneider: 
    Two attachment files more (.png)

    Am 08.12.2012 22:33, schrieb Mark Schneider: 
      Thanks a lot for checking this issue Jacques.

      I have repeated the test (with fresh installation of OFBiz 11.04.01) with the non-working "one page checkout / MasterCard payment" and a working one with "normal checkout / offline payment" .. (see attached .png, and log files)

      It looks like a wrong credit card number leads to the following error message in UI (tested with one-page checkout):
      # ---
      ... (INSERT on table 'ORDER_CONTACT_MECH' caused a violation of foreign key constraint 'ORDER_CMECH_CM' for key (10005). ...

      I would rather expect an error message like "invalid credit cartd number" instead.

      The product was: Tiny Gizmo 

      Please let me know if you need more details.

      I have also noticed some other issues like "strange 3 characters" restriction to some phone number fields (in one page checkout).

      regards, Mark

-- 
ms@it-infrastrukturen.org

http://rsync.it-infrastrukturen.org

      # ---
      ironm@wheezy:~/apache-ofbiz-11.04.01/runtime/logs$ grep -i credit ofbiz.log
      2012-12-08 20:54:00,845 (http-0.0.0.0-8443-1) [     ServiceEcaRule.java:150:INFO ] Running Service ECA Service: buildCcExpireDate, triggered by rule on Service: createCreditCard
      2012-12-08 20:54:00,849 (http-0.0.0.0-8443-1) [  ServiceDispatcher.java:532:ERROR] Error in Service [createCreditCard]: 1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)
      Message: Error in Service [createCreditCard]: 1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)
      java.lang.Exception: Error in Service [createCreditCard]: 1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)
      Message: Error: 1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)  calling service createCreditCard in createUpdateCreditCard
      java.lang.Exception: Error: 1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)  calling service createCreditCard in createUpdateCreditCard
      2012-12-08 20:54:00,859 (http-0.0.0.0-8443-1) [  ServiceDispatcher.java:532:ERROR] Error in Service [createUpdateCreditCard]: 1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)
      Message: Error: 1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)  calling service createUpdateCreditCard in createUpdateBillingAddressAndPaymentMethod
      java.lang.Exception: Error: 1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)  calling service createUpdateCreditCard in createUpdateBillingAddressAndPaymentMethod
      2012-12-08 20:54:00,860 (http-0.0.0.0-8443-1) [  ServiceDispatcher.java:532:ERROR] Error in Service [createUpdateBillingAddressAndPaymentMethod]: 1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)
      2012-12-08 20:54:00,864 (http-0.0.0.0-8443-1) [  ServiceDispatcher.java:593:INFO ] Sync service [ecommerce/createUpdateBillingAddressAndPaymentMethod] finished in [80] milliseconds with response [{contactMechId=10003, billToPhoneContactMechId=10005, paymentMethodId=null, errorMessageList={1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)}, responseMessage=error}]
      2012-12-08 20:54:00,864 (http-0.0.0.0-8443-1) [     RequestHandler.java:435:ERROR] Request createUpdateBillingAndPayment caused an error with the following message: {1122334455667788 is not a valid MasterCard credit card number. (It appears to be a Unknown) credit card number)}


      Am 08.12.2012 14:35, schrieb Jacques Le Roux: 
The 1st error I found in the log is

2012-12-07 18:20:37,465 (http-0.0.0.0-8443-6) [        CallService.java:251:ERROR] 
---- exception report ----------------------------------------------------------
ERROR: Could not complete the create and update credit card [file:/home/ironm/apache-ofbiz-11.04.01/applications/order/script/org/ofbiz/order/order/OrderServices.xml#createUpdateCreditCard] process [problem invoking the [createCreditCard] service with the map named [creditCardContext] containing [{paymentMethodId=null, cardType=MasterCard, cardNumber=FR42300102011176, firstNameOnCard=Hugo, lastNameOnCard=Boss, contactMechId=10002, partyId=10000, expMonth=12, expYear=2017, userLogin=[GenericEntity:UserLogin][createdStamp,2012-12-07 18:13:50.75(java.sql.Timestamp)][createdTxStamp,2012-12-07 18:13:50.582(java.sql.Timestamp)][currentPassword,{SHA}74ce7fcefd5b3f91ffb54157247c9902e0e44c72(java.lang.String)][disabledDateTime,null()][enabled,null()][externalAuthId,null()][hasLoggedOut,null()]
 [isSystem
,null()][lastC
 urrencyUo
m,null()][lastLocale,null()][lastTimeZone,null()][lastUpdatedStamp,2012-12-07 18:13:50.75(java.sql.Timestamp)][lastUpdatedTxStamp,2012-12-07 18:13:50.582(java.sql.Timestamp)][partyId,10000(java.lang.String)][passwordHint,123(java.lang.String)][requirePasswordChange,null()][successiveFailedLogins,null()][userLdapDn,null()][userLoginId,hb@boss.fr(java.lang.String)], locale=en_US, timeZone=sun.util.calendar.ZoneInfo[id="Etc/UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null]}]: Service [createCreditCard] target threw an unexpected exception (For input string: "F")]

Then the one you found.

But to reproduce we need more: notably the products you bought the payment method, etc. Include as much as you can

Thanks

Jacques
  ----- Original Message ----- 
  From: Mark Schneider 
  To: user@ofbiz.apache.org 
  Sent: Saturday, December 08, 2012 1:27 PM
  Subject: Fwd: ERROR 23503: INSERT on table 'ORDER_CONTACT_MECH' caused a violation of foreign key constraint 'ORDER_CMECH_CM' for key (10004)


  Hello,

  In case "dev@ofbiz.apache.org" is not the appriopriate list for such message like below (as I didn't get any answers yet).

  I use wheezy (debian linux) with JDK7 u9 for testing of OFBiz 11.04.01 and just follow the "Apache OFBiz Development" book from Rupert Howell and Jonathon Wong.

  regards, Mark


  -------- Original-Nachricht -------- Betreff:  ERROR 23503: INSERT on table 'ORDER_CONTACT_MECH' caused a violation of foreign key constraint 'ORDER_CMECH_CM' for key (10004) 
        Datum:  Fri, 07 Dec 2012 19:39:13 +0100 
        Von:  Mark Schneider <ms...@it-infrastrukturen.org> 
        Antwort an:  dev@ofbiz.apache.org 
        An:  dev@ofbiz.apache.org 


Hello,

It looks like a bug in ecommerce (a try to execute a new order on OFBiz 
11.04.01).
# ---
ERROR 23503: INSERT on table 'ORDER_CONTACT_MECH' caused a violation of 
foreign key constraint 'ORDER_CMECH_CM' for key (10004)

More details are in the attached file.