AbleCommerce Shopping Cart Software

We have had an instance of AC Gold 7.0 running for quite some time. We recently expanded the store presence and migrated to a new environment. Ever since the migration, the system is not receiving IPN's from PayPal. We have checked the configuration of the PayPal gateway in AC and we have confirmed the set up in PayPal also. The only difference in the platforms is that the new one is load balanced. We have verified the configuration is correct on both instances of the servers.

When an order is placed the user goes to PayPal and enters the payment. Once complete, they are automatically sent back to our confirmation page (again, all configured in the PP admin correctly). When the user is passed back, it looks like it is hitting the AC /ProcessPayPal.ashx page which is defined in the AC gateway configuration. At that point the IPN should be received, but when you review the order in the admin tool it says "Pending IPN". The PayPal logs show they are successfully being sent by their system but there is a disconnect somewhere between getting the user back from PP with the IPN.

We are getting transaction ID information from PP and can manually process the IPN, so communications with PP are OK through other avenues.

Has anyone else seen this issue? I can provide more information as discussion progresses, but figured I would start with the basics.

Thanks!

What is the IPN URL? For live transactions, it must be SSL.

e.g.
https://www.mystore.com/ProcessPayPal.ashx

When you enable debugging for the gateway, do you see any error messages in the Paypal.log file in the \app_data\logs\ folder?

Thanks
Katie

Do both your sites have the same machineKey entry in the web.config?

jmestep wrote:Do both your sites have the same machineKey entry in the web.config?

YES

Katie wrote:What is the IPN URL? For live transactions, it must be SSL.

e.g.
https://www.mystore.com/ProcessPayPal.ashx

When you enable debugging for the gateway, do you see any error messages in the Paypal.log file in the \app_data\logs\ folder?

The IPN URL is not HTTPS as we control security through the IIS settings. This is the same way it was configured in the old platform and it worked without an issue. We have tried the IPN URL defined as HTTP and HTTPS in the paypal configuration.

When you enable debugging for the gateway, do you see any error messages in the Paypal.log file in the \app_data\logs\ folder?

Katie wrote:When you enable debugging for the gateway, do you see any error messages in the Paypal.log file in the \app_data\logs\ folder?

We do not even see a PayPal.log file although we have debug mode enabled.

We see this in the web config file.

<trace enabled="false" requestLimit="100" pageOutput="false" localOnly="true" mostRecent="true" />
<compilation debug="true" strict="false" explicit="false" targetFramework="4.0">

Do we need to change <trace enabled="TRUE"

It has been a long, long time since I have done this, but (affinity?)- is that set up? I'm not even sure it's necessary, just grasping at straws here.

Judy, are you talking about the Microsoft Web Services Enhancements (WSE) 3.0? This is required for older versions of AbleCommerce using Paypal.

jjarch86 -

What is the exact version of AbleCommerce you are using? Also, what is the version of the CommerceBuilder.Paypal.dll file?

The logging should be working if you have permissions set to write/edit access to the \app_data\logs folder, but I will test this myself when I hear back about the version you are using.

Thanks
Katie

AbleCommerce for ASP.NET
VERSION: 7.0.86.6169
Release Label: GoldR6



CommerceBuilder.PayPal: 7.86.5000.17240

Katie,

We found this in our continued research of addressing this issue. It sounds like the same behavior we are experiencing but I do not see any resolution because the bug tracking link at the bottom of the thread just takes me to bugzilla which I assume is only available to your team internally.
viewtopic.php?f=42&t=13484
As an FYI as you read the above thread...our Receipt page is using the method where we automatically invoke the 'Pay Now' button. We do not use Express Pay.

In addition, we see a table ‘PayPalLog’ in the backend and the ‘ProcessPayPal.ashx’ page logs all incoming calls to this table. In the old system, I see two entries (as soon as an order is placed thru PayPal) but in the new system we have only one. Here is a sample:

OLD system:

mc_gross=25.00&auth_exp=00:38:38 Dec 13, 2014 PST&protection_eligibility=Ineligible&payer_id=XXXXXXXXXX&tax=0.00&payment_date=00:38:38 Nov 13, 2014 PST&payment_status=Pending&charset=windows-1252&first_name=XXXXXXXX&transaction_entity=auth&notify_version=3.8&custom=429889&payer_status=verified&business=TIaccxxxx@harte-hanks.com&quantity=1&verify_sign=XXXXXXXXXXX&payer_email=XXXX&parent_txn_id=&txn_id=XXXXX&payment_type=instant&remaining_settle=10&payer_business_name=XXXXXXXX&auth_id=XXXXXX&last_name=XXXXXX&receiver_email=TIaccounting@harte-hanks.com&auth_amount=25.00&receiver_id=FRE5E4PLCFBRG&pending_reason=authorization&txn_type=web_accept&item_name=Order #: 402900&mc_currency=USD&item_number=&residence_country=XXXX&handling_amount=0.00&transaction_subject=429889&payment_gross=25.00&auth_status=Pending&shipping=0.00&ipn_track_id=XXXXXXX

mc_gross=25.00&auth_exp=00:38:38 Dec 13, 2014 PST&protection_eligibility=Ineligible&payer_id=XXXXXXXX&tax=0.00&payment_date=00:38:38 Nov 13, 2014 PST&payment_status=Pending&charset=windows-
1252&first_name=XXXXXXXXXX&transaction_entity=auth&notify_version=3.8&custom=429889&payer_status=verified&business=TIaccxxxx@harte-hanks.com&quantity=1&payer_email=XXXXXX&verify_sign=XXXXXXXXXXXXXX&parent_txn_id=&txn_id=XXXXXXX&payment_type=instant&payer_business_name=XXXXXXXX&remaining_settle=10&auth_id=XXXXXX&last_name=XXXXX&receiver_email=TIaccounting@harte-hanks.com&auth_amount=25.00&receiver_id=FRE5E4PLCFBRG&pending_reason=authorization&txn_type=web_accept&item_name=Order #: 402900&mc_currency=USD&item_number=&residence_country=XXXX&handling_amount=0.00&transaction_subject=429889&payment_gross=25.00&shipping=0.00&auth_status=Pending&auth=AN5I27ejPC69vzz4jwfmt8ACp9Fq59A2nHKHWZcwt1iEFxC1ct2f-oLFqK9oUvh9hk9FoFqvW1aBXzvVrK71P7Q&form_charset=UTF-8


New Systsem:

mc_gross=0.92&auth_exp=10:56:29 Jan 09, 2015 PST&protection_eligibility=Ineligible&payer_id=XXXXX&tax=0.00&payment_date=10:56:29 Dec 10, 2014 PST&payment_status=Pending&charset=windows-1252&first_name=XXXXX&transaction_entity=auth&notify_version=3.8&custom=463125&payer_status=verified&business=TIaccxxxx@harte-hanks.com&quantity=1&verify_sign=XXXXX&payer_email=XXXX&parent_txn_id=&txn_id=XXXXXX&payment_type=instant&remaining_settle=10&auth_id=XXXXXXX&last_name=XXXXX&receiver_email=TIaccounting@harte-hanks.com&auth_amount=0.92&receiver_id=FRE5E4PLCFBRG&pending_reason=authorization&txn_type=web_accept&item_name=Order #: 436151&mc_currency=USD&item_number=&residence_country=XXXX&handling_amount=0.00&transaction_subject=463125&payment_gross=0.92&auth_status=Pending&shipping=0.00&ipn_track_id=XXXXXX

Look at the second entry (old system). It has ‘auth=’ parameter at the end. So we are not receiving second entry in the new system. (Note: I did not want to send sensitive info via email so I put XXXXX in some places).

The send request looks identical from old to new. If you are basically using the same files as you had on the previous server, then it must be something different with the server environment.

Based on what you posted last, it doesn't look like Paypal is able to access the server at all. Whether it's due to the SSL or something else, I cannot say.

Katie wrote:The send request looks identical from old to new. If you are basically using the same files as you had on the previous server, then it must be something different with the server environment.

Based on what you posted last, it doesn't look like Paypal is able to access the server at all. Whether it's due to the SSL or something else, I cannot say.

Katie, those entries in the log are communications we log from PayPal. So the fact that there is one communication from them initially shows that they are able to communicate with us. In addition, all of our other interfaces with PP work properly.

The reason there are two communications is because the first post back from PP is to the "listener". The listener then posts the information back to PP for confirmation of the transaction and then PP send the final transaction message with the IPN and authorization information (this is from PP developer documentation). From my understanding the listener resides on that ProcessPayPal.ashx page within AC.

We have continued to debug the issue and I believe we have narrowed down the area where the issue is occurring. According to the PP documentation, an IPN POST is sent from PP to AC. AC then sends back two responses, a 200 message and a POST back to PP. We enabled a trace and see the POST from PP and the 200 message being sent, but then no other outbound traffic after that point. All of these communications are handled within the IPN Listener (ProcessPayPal.ashx).

Is there an updated DLL or something that exists in the ProcessPayPal.ashx page that needs to be updated?

We have had an instance of AC Gold 7.0 running for quite some time. We recently expanded the store presence and migrated to a new environment. Ever since the migration, the system is not receiving IPN's from PayPal. We have checked the configuration of the PayPal gateway in AC and we have confirmed the set up in PayPal also. The only difference in the platforms is that the new one is load balanced. We have verified the configuration is correct on both instances of the servers.

I really don't think this is a code issue. Paypal is being used by many customers, and if there were a problem in the code, we would hear about it.

Based on your original post above, you said that it was working until you moved to a different environment. I suggest that you install a stock version of AbleCommerce on the same server and see if it works (to eliminate any customizations and/or load balancing as the cause). The only thing that has changed is the server, so it must be the cause.