Error Using CIM: Duplicate Transaction Submitted

[abajrushi]

Hello,

I'm trying to set up Authorize.net using the Customer Information Manager (CIM) feature. We have an extension installed in the Magento store we are working on. When we set up the clients credentials, the information is being passed to Authorize.net and successfully processed. When the transaction is returned to Magento, however, the approval code returned is a "0", so Magento thinks the transaction failed and attempts to resubmit it. While the first transaction is being processed successfully by Authorize, orders are not being created in the system for the transactions.

The Customer Service rep I spoke with a few minutes ago instructed me to post the information being sent back to Magento in the hopes that someone can assist with this issue. Please see below for the two separate responses from Authorize.net to Magento.

2012-08-30T17:46:30+00:00 INFO (6): array (

  'Status' =>

  array (

    'transno' => 0,

    'approval' => 0,

    'CustomerProfileID' => '43347547',

    'PaymentProfileID' => '40819206',

    'statusCode' => 'Ok',

    'code' => 'I00001',

    'statusDescription' => 'Successful.',

  ),

)

2012-08-30T17:46:32+00:00 INFO (6): array (

  'Status' =>

  array (

    'transno' => 0,

    'approval' => '0',

    'CustomerProfileID' => '43347547',

    'PaymentProfileID' => '40819206',

    'statusCode' => 'Error',

    'code' => 'E00027',

    'statusDescription' => 'A duplicate transaction has been submitted.',

  ),

)

The Rep also suggested I post the Gateway ID for reference: 302908

As a side note, we tested this same integration using a different customers credentials who is also using CIM and were able to successfully process the transactions and get the correct code returned from Authorize to create an order in Magento. It seems that the issue might be within the customers account, but we're not sure what it might be.

Thanks for the help!

-Agbi Bajrushi

Redstage Networks

[RaynorC1emen7]

Can you give us the directResponse. Example from the xml documentation.

<?xml version="1.0" encoding="utf-8"?>
<createCustomerProfileTransactionResponse xmlns="AnetApi/xml/v1/schema/AnetApiSchema.xsd">
<messages>
<resultCode>Ok</resultCode>
<message>
<code>I00001</code>
<text>Successful.</text>
</message>
</messages>
<directResponse>1,1,1,This transaction has been
approved.,000000,Y,2000000001,INV000001,description of
transaction,10.95,CC,auth_capture,custId123,John,Doe,,123 Main
St.,Bellevue,WA,98004,USA,000-000-0000,,mark@example.com,John,Doe,,123
Main St.,Bellevue,WA,98004,USA,1.00,0.00,2.00,FALSE,PONUM000001,
D18EB6B211FE0BBF556B271FDA6F92EE,M,2,,,,,,,,,,,,,,,,,,,,,,,,,,,,
</directResponse>
</createCustomerProfileTransactionResponse>

[abajrushi]

Does this work?

<?xml version="1.0" encoding="utf-8"?><createCustomerProfileTransactionResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="AnetApi/xml/v1/schema/AnetApiSchema.xsd"><messages><resultCode>Ok</resultCode><message><code>I00001</code><text>Successful.</text></message></messages><directResponse>1:1:1:This transaction has been approved.:08930G:Y:4610291078:100000037::1.00:CC:auth_capture:1:xxxez:xxxx:80 River St:Hoboken:New Jersey:07030:US:5555555555::xxx::::::::::::::5480B7F841C4EBC6182A9B3A9DB3CF51:::::::::::::XXXX7358:Visa::::::::::::::::</directResponse></createCustomerProfileTransactionResponse>

Duplicate error:

<?xml version="1.0" encoding="utf-8"?><createCustomerProfileTransactionResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="AnetApi/xml/v1/schema/AnetApiSchema.xsd"><messages><resultCode>Error</resultCode><message><code>E00027</code><text>A duplicate transaction has been submitted.</text></message></messages><directResponse>3:1:11:A duplicate transaction has been submitted.::P:0:100000037::1.00:CC:auth_capture:1:x:xxxx:x:x:07030:US:5555555555::xxx.com::::::::::::::207BCBBF78E85CF174C87AE286B472D2:::::::::::::XXXX7358:Visa::::::::::::::::</directResponse></createCustomerProfileTransactionResponse>

[abajrushi]

note: the Smiley face that is displaying in the last post shoudl be ': P'

[RaynorC1emen7]

The data look correct from authorize.net, so the problem is Magento not reading it correctly. Did it set to use the ":" as the delimited char(x_delim_char)?  What about the encapsulating character(x_encap_char)?

[abajrushi]

We didn't build the extension, so we've been trying to avoid diving into the code.

The thing is, we are able to put different credentials in and process transactions without this issue. I don't think it's a problem with the code since only the credentials are changing when I do that.

Do you know: Is the ECheck service required for Authorize CIM to work properly? The only difference that we could tell between the two accounts is that ECheck is enabled on the working account and not the other one.

[RaynorC1emen7]

No, you don't echeck, but do check the delimited char(x_delim_char) and the encapsulating character(x_encap_char) settings. 

The problem is probably because Magento is expecting something else for a delimited char (like ",").

If it not a settings in Magento, then set it in the merchant account.

[abajrushi]

I confirmed with the client that ":" is the delimiting character in their admin.

We tested the credentials using the Native Authorize.net Integration (the one that comes with Magento) and were able to successfully process orders.

Any other ideas? I'm working with the extension developer, but since other credentials work in CIM, I can't imagine something is wrong with the extension.

[RaynorC1emen7]

We tested the credentials using the Native Authorize.net Integration (the one that comes with Magento) and were able to successfully process orders.

Ok. can you post the directResponse from that?