Error when trying to process temporary contact created during registration

[franharrington]

Hello,

We recently tried to process a temporary contact that was created when someone registered for our event. At first we got an error saying that it had already be processed, when we want into the record via the "temporary contacts" tab outside of the event module we got this error:

List has no rows for assignment to SObject 



An unexpected error has occurred. Your solution provider has been notified. (CnP_PaaS)

Can you advise us how to correctly process this contact and prevent this from happening in the future?

thanks!

[franharrington]

Hello, we just noticed a second instance of this same error. Can we please have someone from support take a look at our account to see why this is happening?

[CnP.Support]

Good day!

We have tried to login to your account but do not have access.

Please grant us login access so we can review the issue. Your instance is also behind so if you want we can upgrade it while reviewing the issue. Please see below:

[franharrington]

Hello, our id is: 00Do0000000bhRv

I just granted you access.

I didn't want to upgrade while our registration is open as I was concerned about this affecting our event. Would this not be the case?

[CnP.Support]

Good day!

We prefer not to upgrade when an active registration is taking place.

We can upgrade you very early in the morning if that helps. For example we can have it updated by 6 a.m. ET tomorrow.

Let us know how you wish to proceed. We can do whatever works for you.

[franharrington]

Is the upgrade necessary to fix the issue we are having with the temporary contacts?

If it is not, we would likely wait until our conference is over so that we don't risk breaking anything else.

[CnP.Support.AM]

Good day!

Would you please share the order number of temp contact which you are referring to?

Looking forward to hearing back from you.

Thanks,

[franharrington]

The first one is:

Order Number: 1606152358092654425
Authorization Code: 777238
Transaction Number: 899293115

[CnP.Support.AM]

Good day!

We reviewed and fixed the issue. The issue is, above order number didn't posted to your Salesforce instance. We simply pushed the data and you can see the temp contact.

Once the Event completed please post the request for upgrade in the "Salesforce Upgrade Assistance" channel so that we can upgrade it for you.

Let us know if we can be of any further assistance.

Thanks,

[franharrington]

That worked for that one.

There is one more that is still stuck:

Order Number: 1606152353021014309
Authorization Code: 015795
Transaction Number: 899292658

Is there a way for us to push the data on our own should this happen again?

thanks!

[CnP.Support.AM]

Good day!

We have pushed the above order number. Yes, you can push the data to Salesforce by yourself, it is very simple and easy steps which you will find in the below link:

http://help.clickandpledge.com/customer/en/portal/articles/2084081-donor-management-for-salesforce-re-post-transaction-to-salesforce

Let us know if we can be of any more help.

Thanks,

[franharrington]

Hello,

We noticed that this error is continuing. Pushing the transaction does not seem to be fixing it.

It seems that for all temporary contacts that were created as a result of a declined credit card are returning this error when we try to process them:

List has no rows for assignment to SObject



An unexpected error has occurred. Your solution provider has been notified. (CnP_PaaS_EVT)

An example of one such transaction is order number: 1604051741149611028

And there is another error which seems to have started after the most recent release of Salesforce.

If we try to process any of the temporary contacts which were created as a result of a declined payment after 6/4 the contact will appear to process, but then will return to the list of unprocessed temporary contacts in approximately 24 hours.

[CnP.Support]

Good day franharrington

One of our developers is looking into this. We will update this post by Monday, July 11.

[franharrington]

Thank you.

[CnP.Support.AM]

Good day @franharrington,

We reviewed and found that the order number which you are referring to (1604051741149611028 ) has been deleted from Event which is causing the above error. Manually deleting registrant and attendee will create orphaned records in the system.

Registration may be deleted by going to the registration record and cancelling the registration. Click on the name of the person in the "Name" column and delete the registration. This way it will remove complete footprint of the record:




However, for those orphan temp contacts, you will need to delete it through Maintenance under C&P Settings. It will remove complete footprint from the instance.

Please check and let us know if we can be of any further assistance.

Thanks,