(97) This transaction cannot be accepted. - ColdFusion Code

cjervin — Fri, 07 Oct 2011 17:26:02 GMT

I keep getting this error: (97) This transaction cannot be accepted. I am using ColdFusion for my code.

I am using the Source Code downloaded from http://developer.authorize.net/downloads/samplecode/?searchid=1317927783498 under SIM - ColdFusion. Only mods is my Login ID and Transaction key and the Dumps to see the values and adding seconds to the time Explained below).

My server is EST and I add 18000 seconds to it to make it GMT time. In the code, I post the EST Time, the GMT Time I create by adding 18000 seconds, then the Seconds. The code gives all the values I used and dumps them on the screen. If you view the source, you will see that this value is what is passed in the form.

My code is working (no errors and you can see my error response on submit), you will just need to add your own Login ID and transaction key to test, IF you want to test. Also if you server is a different timezone than EST, the seconds added will need to be different.

If I take the value that my page creates, and put it in theAuthorize.net Test at http://developer.authorize.net/tools/responsecode97/ it works. This value can be taken from the 1st variable display, when you view source and take the value out of the field x_fp_timestamp (that passes the time stamp value) and after the form for the 2nd variable dump. Value never changes through out the entire process once the variable is set (Variable name is timestamp).

Below is my code, that you can view for problems, errors or whatever or you can use and test:

<CODE START> --------

<cfsetting enablecfoutputonly="true">
<cfoutput>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<HTML lang='en'>
<HEAD>
    <TITLE> Sample SIM Implementation </TITLE>
</HEAD>
<BODY>


</cfoutput>


<cfset loginID="MUST ENTER LOGIN ID">
<cfset transactionKey="MUST ENTER TRANSACTION KEY">
<cfset amount="19.99">
<cfset description="Sample Transaction">
<cfset label="Submit Payment"> 

<cfset testMode="true">

<cfset posturl="https://secure.authorize.net/gateway/transact.dll">


<cfset invoice=DateFormat(Now(),"yyyymmdd") & TimeFormat(Now(),"HHmmss")>


<cfset sequence=RandRange(1, 1000)>



<cfset dtNow = Now() />


<cfset dtGMT = DateAdd("s",GetTimeZoneInfo().UTCTotalOffset,dtNow) /> 
<cfset dtGMT = DateAdd("s",3600,dtGMT) /> 

<cfset timestamp=DateDiff("s", "January 1 1970 00:00", DateConvert('local2UTC', dtGMT)) >
<cfset timestamp = trim(timestamp)> 

<cfset timestamp2=DateDiff("s", "January 1 1970 00:00", DateConvert('local2UTC', Now())) >



<cf_hmac data="#loginID#^#sequence#^#timestamp#^#amount#^" key="#transactionKey#">
<cfset fingerprint=#digest#>

<cfoutput>


<strong>Amount:</strong> #amount# <br />
<strong>Description:</strong> #description# <br />
<strong>DateTime:</strong> #dtNow# - (COMES FROM HOSTED SERVER)<br />
<strong>GMT:</strong> #dtGMT# - (DATE MY CODE CREATES)<br />
<strong>timestamp:</strong> #timestamp# - (USED IN FORM BELOW - SAME VARIABLE / SAME VALUE)</br></br>

<strong><em>Backward Compatibility test:</em></strong><BR>
<strong>GMT Timestamp Seconds:</strong> <cfdump var="#timestamp#"> <BR>
<strong>EMT Timestamp Seconds:</strong> <cfdump var="#timestamp2#"><BR>
<cfset vDif = timestamp - timestamp2>
<strong>Difference:</strong> <cfdump var="#vDif#"> - <em>Amount to add to make it 5 hours ahead like Authorize.net needs.</em> <BR><BR>

<font color="##800000">**************************************** START FORM SECTION ****************************************************</font><BR>
Form to submit to https://secure.authorize.net/gateway/transact.dll - <BR><BR>

<FORM method='post' action='#posturl#' >

<INPUT type='hidden' name='x_login' value='#loginID#' />
    <INPUT type='hidden' name='x_amount' value='#amount#' />
    <INPUT type='hidden' name='x_description' value='#description#' />
    <INPUT type='hidden' name='x_invoice_num' value='#invoice#' />
    <INPUT type='hidden' name='x_fp_sequence' value='#sequence#' />
    <INPUT type='hidden' name='x_fp_timestamp' value='#timestamp#' />
    <INPUT type='hidden' name='x_fp_hash' value='#fingerprint#' />
    <INPUT type='hidden' name='x_test_request' value='#testMode#' />
    <INPUT type='hidden' name='x_show_form' value='PAYMENT_FORM' />
    <input type='submit' value='#label#' />
</FORM>

<BR>
If you view source you will see that the form field <em>x_fp_timestamp</em> will have the same value as the dump above and below!<BR>

<font color="##800000">**************************************** END FORM SECTION *******************************************************</font><BR>
<BR><BR>
<strong>Timestamp dump to make sure that the timestamp did not change:</strong><BR>
<cfdump var="#timestamp#"> <BR>

</BODY>
</HTML>

</cfoutput>

-------- <CODE END>

I have talked to tech support and they said to post on here, because they see no problem, but they are not developers. But they also said it can not be on their end. So there is a problem somewhere between.

Thanks in advance,

Re: (97) This transaction cannot be accepted. - ColdFusion Code

RaynorC1emen7 — Fri, 07 Oct 2011 18:46:39 GMT

Are you sure it is not 4 hour ahead since it is still daylight savings time(EDT).

Also, it would be easier to set it in your account and then you can just sent in your server current time.

Account - Settings - Business Settings - Time Zone

Re: (97) This transaction cannot be accepted. - ColdFusion Code

teddyc1 — Wed, 09 Nov 2011 17:33:16 GMT

Robert B at authorize.net chat says:

Robert B: Yes, our tech's agree the Time Zone setting will not effect that error you are getting.

So the info above from RaynorC1emen7 is incorrect.

Re: (97) This transaction cannot be accepted. - ColdFusion Code

TJPride — Wed, 09 Nov 2011 21:10:00 GMT

From http://developer.authorize.net/tools/responsereasoncode/

Response Reason Code: 97

Response Reason Text: This transaction cannot be accepted.

Other Suggestions: Applicable only to the SIM API. Fingerprints are only valid for a short period of time. This code indicates that the transaction fingerprint has expired.

The fingerprint is obviously the problem. If you're using the demo code and the only thing you're changing is the timestamp, my guess would be that the timestamp is being read as invalid for some reason and therefore the fingerprint is being rejected. In any case, it's a place to start.

topic Re: (97) This transaction cannot be accepted. - ColdFusion Code in Integration and Testing

(97) This transaction cannot be accepted. - ColdFusion Code

Re: (97) This transaction cannot be accepted. - ColdFusion Code

Re: (97) This transaction cannot be accepted. - ColdFusion Code

Re: (97) This transaction cannot be accepted. - ColdFusion Code