[
https://issues.apache.org/jira/browse/OFBIZ-5064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Le Roux closed OFBIZ-5064.
----------------------------------
Resolution: Invalid
Thanks Divesh,
Makes perfect sense to me. PaymentGatewayResponse.resultDeclined is an
indicator which is indeed a sole character (supposed to be "Y" or "N")
I close as invalid
> Failure in create operation for entity PaymentGatewayResponse
> -------------------------------------------------------------
>
> Key: OFBIZ-5064
> URL: https://issues.apache.org/jira/browse/OFBIZ-5064
> Project: OFBiz
> Issue Type: Bug
> Components: accounting
> Environment: Linux
> Reporter: Nilesh S Patil
>
> An error appear in the log and gradually add records in JOBSANDBOX entity:
> 2012-08-08 19:26:33,917 (default#36-invoker-Thread-22) [
> GenericDelegator.java:866:ERROR] Failure in create operation for entity
> [PaymentGatewayResponse]: org.ofbiz.entity.GenericEntityException: Error
> while inserting:
> [GenericEntity:PaymentGatewayResponse][altReference,[null-field](java.lang.String)][amount,3.00(java.math.BigDecimal)][createdStamp,2012-08-08
> 19:26:33.915(java.sql.Timestamp)][createdTxStamp,2012-08-08
> 19:26:33.915(java.sql.Timestamp)][currencyUomId,USD][gatewayAvsResult,[null-field](java.lang.String)][gatewayCode,57355P(java.lang.String)][gatewayCvResult,[null-field](java.lang.String)][gatewayFlag,1(java.lang.String)][gatewayMessage,This
> transaction has been
> approved.(java.lang.String)][gatewayScoreResult,[null-field](java.lang.String)][lastUpdatedStamp,2012-08-08
> 19:26:33.915(java.sql.Timestamp)][lastUpdatedTxStamp,2012-08-08
> 19:26:33.915(java.sql.Timestamp)][orderPaymentPreferenceId,10021(java.lang.String)][paymentGatewayResponseId,10013(java.lang.String)][paymentMethodId,10220(java.lang.String)][paymentMethodTypeId,CREDIT_CARD(java.lang.String)][paymentServiceTypeEnumId,PRDS_PAY_CAPTURE(java.lang.String)][referenceNum,4547539856(java.lang.String)][resultBadCardNumber,[null-field](java.lang.String)][resultBadExpire,[null-field](java.lang.String)][resultDeclined,[null-field](java.lang.String)][resultNsf,[null-field](java.lang.String)][subReference,[null-field](java.lang.String)][transCodeEnumId,PGT_CAPTURE(java.lang.String)][transactionDate,2012-08-01
> 22:12:33.145(java.sql.Timestamp)] (SQL Exception while executing the
> following:INSERT INTO PAYMENT_GATEWAY_RESPONSE (PAYMENT_GATEWAY_RESPONSE_ID,
> PAYMENT_SERVICE_TYPE_ENUM_ID, ORDER_PAYMENT_PREFERENCE_ID,
> PAYMENT_METHOD_TYPE_ID, PAYMENT_METHOD_ID, TRANS_CODE_ENUM_ID, AMOUNT,
> CURRENCY_UOM_ID, REFERENCE_NUM, ALT_REFERENCE, SUB_REFERENCE, GATEWAY_CODE,
> GATEWAY_FLAG, GATEWAY_AVS_RESULT, GATEWAY_CV_RESULT, GATEWAY_SCORE_RESULT,
> GATEWAY_MESSAGE, TRANSACTION_DATE, RESULT_DECLINED, RESULT_NSF,
> RESULT_BAD_EXPIRE, RESULT_BAD_CARD_NUMBER, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data
> truncation: Data too long for column 'RESULT_DECLINED' at row 1)). Rolling
> back transaction.
> 2012-08-08 19:26:33,918 (default#36-invoker-Thread-22)
> [PaymentGatewayServices.java:2969:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Error while inserting:
> [GenericEntity:PaymentGatewayResponse][altReference,[null-field](java.lang.String)][amount,3.00(java.math.BigDecimal)][createdStamp,2012-08-08
> 19:26:33.915(java.sql.Timestamp)][createdTxStamp,2012-08-08
> 19:26:33.915(java.sql.Timestamp)][currencyUomId,USD][gatewayAvsResult,[null-field](java.lang.String)][gatewayCode,57355P(java.lang.String)][gatewayCvResult,[null-field](java.lang.String)][gatewayFlag,1(java.lang.String)][gatewayMessage,This
> transaction has been
> approved.(java.lang.String)][gatewayScoreResult,[null-field](java.lang.String)][lastUpdatedStamp,2012-08-08
> 19:26:33.915(java.sql.Timestamp)][lastUpdatedTxStamp,2012-08-08
> 19:26:33.915(java.sql.Timestamp)][orderPaymentPreferenceId,10021(java.lang.String)][paymentGatewayResponseId,10013(java.lang.String)][paymentMethodId,10220(java.lang.String)][paymentMethodTypeId,CREDIT_CARD(java.lang.String)][paymentServiceTypeEnumId,PRDS_PAY_CAPTURE(java.lang.String)][referenceNum,4547539856(java.lang.String)][resultBadCardNumber,[null-field](java.lang.String)][resultBadExpire,[null-field](java.lang.String)][resultDeclined,[null-field](java.lang.String)][resultNsf,[null-field](java.lang.String)][subReference,[null-field](java.lang.String)][transCodeEnumId,PGT_CAPTURE(java.lang.String)][transactionDate,2012-08-01
> 22:12:33.145(java.sql.Timestamp)] (SQL Exception while executing the
> following:INSERT INTO PAYMENT_GATEWAY_RESPONSE (PAYMENT_GATEWAY_RESPONSE_ID,
> PAYMENT_SERVICE_TYPE_ENUM_ID, ORDER_PAYMENT_PREFERENCE_ID,
> PAYMENT_METHOD_TYPE_ID, PAYMENT_METHOD_ID, TRANS_CODE_ENUM_ID, AMOUNT,
> CURRENCY_UOM_ID, REFERENCE_NUM, ALT_REFERENCE, SUB_REFERENCE, GATEWAY_CODE,
> GATEWAY_FLAG, GATEWAY_AVS_RESULT, GATEWAY_CV_RESULT, GATEWAY_SCORE_RESULT,
> GATEWAY_MESSAGE, TRANSACTION_DATE, RESULT_DECLINED, RESULT_NSF,
> RESULT_BAD_EXPIRE, RESULT_BAD_CARD_NUMBER, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data
> truncation: Data too long for column 'RESULT_DECLINED' at row 1))
> ---- cause
> ---------------------------------------------------------------------
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
