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 --------
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 -- [hidden email] http://rsync.it-infrastrukturen.org ps. ofbiz11.04.01-error-violation-of-foreign-key.png ofbiz.log-error.gz (108K) Download Attachment |
Administrator
|
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()][lastCurrencyUom,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,[hidden email](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: [hidden email] 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 "[hidden email]" 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 <[hidden email]> Antwort an: [hidden email] An: [hidden email] 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 -- [hidden email] http://rsync.it-infrastrukturen.org ps. ofbiz11.04.01-error-violation-of-foreign-key.png |
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 -- [hidden email] http://rsync.it-infrastrukturen.org # --- [hidden email] 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,[hidden email](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: [hidden email] 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 [hidden email] 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 [hidden email] Antwort an: [hidden email] An: [hidden email] 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. -- [hidden email] http://rsync.it-infrastrukturen.org |
Two attachment files more (.png)
Am 08.12.2012 22:33, schrieb Mark Schneider: Thanks a lot for checking this issue Jacques. |
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 >> -- >> [hidden email] >> >> 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,[hidden email](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:[hidden email] >>> 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"[hidden email]" 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<[hidden email]> >>> Antwort an:[hidden email] >>> An:[hidden email] >>> >>> >>> 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. |
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) png-files.zip (249K) Download Attachment |
Hi Mark,
Please open a jira issue http://issues.apache.org/jira with your files and logs Nicolas Le 09/12/2012 00:27, Mark Schneider a écrit : > > 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 >>> -- >>> [hidden email] >>> >>> 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,[hidden email](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:[hidden email] >>>> 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"[hidden email]" 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<[hidden email]> >>>> Antwort an:[hidden email] >>>> An:[hidden email] >>>> >>>> >>>> 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. |
Administrator
|
In reply to this post by Mark Schneider
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: [hidden email] 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 -- [hidden email] 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,[hidden email](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: [hidden email] 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 "[hidden email]" 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 <[hidden email]> Antwort an: [hidden email] An: [hidden email] 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. |
Free forum by Nabble | Edit this page |