Forum OpenACS Q&A: Response to Payment Service Contract available
Posted by
jay he
on 06/08/02 05:30 AM
Bart.
I checked the log file and found the following error:
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Debug: PgBindCmd: query with bind var
iables substituted =
insert into payflowpro_result_log
(transaction_id, txn_attempted_type, txn_attempted_time, txn_returne
d_type, errmsg, auth_code, avs_code_zip, avs_code_addr, amount)
values
('V53A14524377', '''mauthonly''', sysdate, 'success', NULL, '445PNI'
, NULL, NULL, '5.000000')
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Notice: Querying '
insert into payflowpro_result_log
(transaction_id, txn_attempted_type, txn_attempted_time, txn_returne
d_type, errmsg, auth_code, avs_code_zip, avs_code_addr, amount)
values
('V53A14524377', '''mauthonly''', sysdate, 'success', NULL, '445PNI'
, NULL, NULL, '5.000000');'
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Error: Ns_PgExec: result status: 7 me
ssage: ERROR: Attribute 'sysdate' not found
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Error: dbinit: error(localhost::final
planning,ERROR: Attribute 'sysdate' not found
): '
insert into payflowpro_result_log
(transaction_id, txn_attempted_type, txn_attempted_time, txn_returne
d_type, errmsg, auth_code, avs_code_zip, avs_code_addr, amount)
values
('V53A14524377', '''mauthonly''', sysdate, 'success', NULL, '445PNI'
, NULL, NULL, '5.000000')
'
'
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Error: Error inserting into payflowpr
o_result_log for transaction_id V53A14524377: Database operation "dml" failed
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Notice: Querying 'abort transaction;'
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Notice: Ns_PgExec: Rolling back trans
action
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Notice: dbinit: sql(localhost::finalp
lanning): 'abort transaction'
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Error: Aborting transaction due to er
ror:
Database operation "dml" failed
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Debug: QD_LOGGER = calling namespace
=
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Debug: QD_LOGGER = proc_name is -ec_u
pdate_state_to_in_basket-
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Debug: QD_LOGGER = generated fullname
of dbqd.ecommerce.tcl.ecommerce-state-changes-procs.ec_update_state_to_in_baske
t.order_state_update
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Debug: QD_LOGGER = PRE-QD: the SQL is
update ec_orders
set order_state='in_basket', confirmed_date=null
where order_id=:order_id for dbqd.ecommerce.tcl.ecommerce-state-changes-
procs.ec_update_state_to_in_basket.order_state_update
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Debug: QD_LOGGER = query dbqd.ecommerce.tcl.ecommerce-state-changes-procs.ec_update_state_to_in_basket.order_state_up
date from /web/birdnotes/packages/ecommerce/tcl/ecommerce-state-changes-procs.xql
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Debug: QD_LOGGER = POST-QD: the SQL i
s
update ec_orders
set order_state='in_basket', confirmed_date=null
where order_id=:order_id
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Debug: PgBindCmd: sql =
update ec_orders
set order_state='in_basket', confirmed_date=null
where order_id=:order_id
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Debug: QD_LOGGER = PRE-QD: the SQL is
update ec_creditcards
set failed_p='t'
where creditcard_id=:creditcard_id for dbqd.ecommerce.tcl.ecommerce-stat
e-changes-procs.ec_update_state_to_in_basket.creditcard_update
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Debug: QD_LOGGER = query dbqd.ecommer
ce.tcl.ecommerce-state-changes-procs.ec_update_state_to_in_basket.creditcard_upd
ate from /web/birdnotes/packages/ecommerce/tcl/ecommerce-state-changes-procs
.xql
[07/Jun/2002:22:00:43][6183.7176][-conn4-] Debug: QD_LOGGER = POST-QD: the SQL is
update ec_creditcards
set failed_p='t'
where creditcard_id=:creditcard_id
Looks like the sysdate in Oracle PL/SQL causes the trouble in payflowpro_result_log. I will change that to now for postGreSQL and report my new result (The retry was successful, which meant the retry ignored updating of payflowpro_result_log table?).
Jay
