TP_PAY_TRANS error

Hi Randall,

Good day.

There are three very similar stored procedures in impresario.

They are :

TP_PAY_TRANS_MISMATCH

TP_PAY_TRANS_MISMATCH_M

TP_PAY_TRANS_MISMATCH_R

==============================

ERROR_HANDLER_T:
SELECT @return_value = @not_matching
SELECT @error_string =
'Amount mismatch in T_Payment ( '+ convert(char,ISNULL(@payment_amt,0))
+ ' ) and T_transaction ( ' + convert(char,ISNULL(@transaction_amt,0)) + ' )'
RAISERROR(@error_string,16,2) WITH SETERROR
RETURN -999

ERROR_HANDLER_TM:
SELECT @return_value = @not_matching
PRINT 'TP_PAY_TRANS_MISMATCH'
SELECT @error_string =
'Amount mismatch in TM_Payment ( '+ convert(char,ISNULL(@payment_amt,0))
+ ' ) and TM_transaction ( ' + convert(char,ISNULL(@transaction_amt,0)) + ' )'
RAISERROR(@error_string,16,2) WITH SETERROR
RETURN  -999

 ======================================

Basically they compare records in T_transaction table with t_payment table.

When the payment is not the same as transaction then the error will pop up.

You can check user account, in transaction tab, compare the $486.00 payment( in payment screen )with $474.00 transaction (in transaction screen).

In database, the records are in t_payment table and t_transaction table.

Also you can run exec pord @orderNo  to check.

After all, I will suggest you to raise a helpdesk ticket. because most possibly you need to get the $12.00 record back to t_transaction table. 

You can nothing to prevent it from reoccuring.

So just have fun.

Ben

Thanks Ben - I appreciate the help. I'll open a help ticket now.

Randy