Suggest more robust error handling for failed salesforce record insertion

[sum3]

When a transaction is processed through the click & pledge system, several objects are created in salesforce. some are click & pledge custom objects, along with a standard salesforce opportunity record.

Insertion of these records can fail for a number of reasons, such as a validation rule, missing required field, or perhaps storage space full error.

I'd like to suggest that when an error is encountered, the error log is captured, and emailed to the "Contact Email Address" set up with the click and pledge account info.

Further, I'd request that click & pledge systems retry insertion of any failed objects at some regular interval like 4 hours or 1 day or something. Then, once the source of the error has been resolved, the missing objects will get created in salesforce.

Thanks for your consideration.

[CnP.Support]

Good suggestion.

Actually if you email support they can run the failed transaction for you and it will post. If you have any transactions that have failed let us know and we can post it again. Making it automated is a good idea.

Errors: We have an update coming up next Tuesday and I try to see if we can fit this feature in. It should be easy to add. Currently our developers receive an email for any error generated in the system and our support receives notifications of any error in SF which results in a failed post. We just need to simply make it prettier and send it to the account administrator.

Next update will be Wednesday June 22, 2011 and will have a few key features and hopefully the error reporting.

[sum3]

i emailed support twice on this, but they didn't re-run the failed transaction. i've got another failed transaction today (due to an apex error on my part), what's the best way to proceed?

[sum3]

and what's the latest on error reporting?

[CnP.Support]

Good day.

The error reporting was included in 3.11 release.

Please see below:

• http://forums.clickandpledge.com/con...rce-Error-Logs

In case of errors the error message appears with the C&P Data. Every transaction is recorded as the XML and the error appears below the XML data. Please see the article listed above.

[CnP.Support]

Good day!

What is the organization ID so we can review the support post. All support incidents are handled as they arrive so I need to review the case.

Please let me know what your account # is so I can review it.

[sum3]

oh, we were still on 3.10, i upgraded to 3.11, thanks!

org id is 00D70000000Ilsw

the recent transaction with the failed opportunity insertion is order number 1171353443535420

https://cnp.na5.visual.force.com/apex/transactiondetail?Id=a0v70000001YcTiAAK

an older transaction with failed opportunity insertion is order number 116213457815420

https://cnp.na5.visual.force.com/apex/transactiondetail?Id=a0v7000000081BwAAI

[CnP.Support]

I just reprocessed the 2 transactions you listed for Organization ID: 18382

In the next release, due out in August, we will have the re-process option for each transaction posted in the C&P Data section. This will help with the problems one may have during the development.

Please check and see if those transactions were posted successfully.

[sum3]

No, the opportunity records don't seem to be there. Salesforce is showing no new opportunities since Jul 13. Let me know what else I can do to help.

Great idea on the re-process option.