OS_PayPal ERROR: System.FormatException about os_paypal HOT 5 OPEN

I have not seen this error so I'm guessing with minimal info.

It sounds like there could be a problem with the item number in the NameValue collection created from the IPN request params getting processing by the web handler.

Hopefully you've got you're dev environment up and you're debugging. The best way to figure it out would be to put a couple of breakpoints near the failure and step through the function to see what is going wrong.

I would start in the web handler.

I would also put a break point at this line as well. Is the item number really a number? :

That would be a good starting point.

from os_paypal.

Thank you very much for your response.
I see this in production environment - I have no dev environment on the production server. So I have no chance to step through the code.
Can you tell me what this Item_number is? Is this the Product Code or which parameter in Product admin is this?
Paypal only shows me the order-number - no separate items when I am directed to paypal payment page ...
I managed to get IPN working now but if someone cancels payment on the paypal page, the order is "copied" - one with "payment not verified" status and one with "payment failed" status
Any idea what this may be caused by?
thanks a lot for your assistance
Gerald

from os_paypal.

OS sql uses upserts. It will either generate a new record type or update a record if an id is provided.

This looks like it may be happening with your order record. I think the web handler is losing it's id at some point in the code flow.

I am not sure why though.

Is is possible for you to duplicate your production environment to a dev environment so that you can better test?

from os_paypal.

Try checking the IPN url... if the paypal provider is in debug mode, there is a debug file in the portal folder of data sent to the bank, that may help understand.

from os_paypal.

Thank you all for taking the time to reply.
I will try your suggestions as soon as possible and will give feedback here afterwards
best regards
Gerald

from os_paypal.