Error when Managing Temporary Contacts

[kraldrich]

Hello,
We have been managing temporary contacts in a C&P Event with no problems for the last month or so, but today when managing a contact I got the following error: Error:

Insert failed. First exception on row 0; first error: DUPLICATE_VALUE, duplicate value found: CnP_PaaS__VaultGUID__c duplicates value on record with id: a1R500000002ooZ: []
Can anyone help explain why this might be happening?
Thanks,
Kristen

[CnP.Support]

@Kristen,

Duplicate value means that this transaction is already in the system. Perhaps it was synced a second time or posted again by someone at your org by mistake.

If you search for the order number I am sure you will find 2 C&P Data posts for this transaction.

We can review your instance and find out the root cause - please grant us access and we will review and let you know.

[kraldrich]

Thank you for your response. I have searched for the Order Number and found only one that matches. I have granted you login access so that you may check it out. Thanks in advance for your assistance.
~Kristen

@Kristen,

Duplicate value means that this transaction is already in the system. Perhaps it was synced a second time or posted again by someone at your org by mistake.

If you search for the order number I am sure you will find 2 C&P Data posts for this transaction.

We can review your instance and find out the root cause - please grant us access and we will review and let you know.

[CnP.Support]

Good day!

One important point before answering your question. You are on a very old version of the app. If you want we can upgrade your instance and we highly recommend that you upgrade as staying a full version behind may be harder to upgrade later.

We searched the order #: 1410202328443873029

The following is the search result:

click to enlarge



Based on what we see:

- there is a Temp record and a settled transaction which are contradictory
- an error had occurred when creating the opportunities and that is why the Temp record is still in the listing

If it is OK we need to delete this transaction and post it again and fix it for you.

Let us know how you wish to proceed & please consider upgrading to the latest release 8.x

[kraldrich]

Thanks for the information and explanation (though I'm not sure I follow 100%). If you are able to delete the transaction and post it again without affecting anything on the customer's end, please proceed.

As for upgrading to the latest release, my only hesitation is any impact that might have on current functionality. Is there any way we can wait until our current event registrations for the Farm to School (F2S) Conference are done next week? And is there a way we can anticipate any potential changes or issues that might impact our system?


Thank you!

Kristen

Good day!

One important point before answering your question. You are on a very old version of the app. If you want we can upgrade your instance and we highly recommend that you upgrade as staying a full version behind may be harder to upgrade later.

We searched the order #: 1410202328443873029

The following is the search result:

click to enlarge
[ATTACH=CONFIG]1416[/ATTACH]


Based on what we see:

- there is a Temp record and a settled transaction which are contradictory
- an error had occurred when creating the opportunities and that is why the Temp record is still in the listing

If it is OK we need to delete this transaction and post it again and fix it for you.

Let us know how you wish to proceed & please consider upgrading to the latest release 8.x

[CnP.Support]

Good day!

We will go ahead and fix the transaction for you.

As for upgrade - I don't recommend you upgrade the instance if you have a live event. I agree that it is best to wait and upgrade once your event is over.

Once fixed we will post a reply to this thread letting you know of the fix. Let us know when your event is over and we will go ahead and upgrade you.

[kraldrich]

Thank you that sounds great!
~Kristen

Good day!

We will go ahead and fix the transaction for you.

As for upgrade - I don't recommend you upgrade the instance if you have a live event. I agree that it is best to wait and upgrade once your event is over.

Once fixed we will post a reply to this thread letting you know of the fix. Let us know when your event is over and we will go ahead and upgrade you.

[CnP.Support]

Hi Kristen,

One of developers wanted to work on your instance today but we no longer have access.

Please grant us access for a week and I will make sure we can resolve it.

[kraldrich]

I have granted login access for 1 week. Thank you!

Hi Kristen,

One of developers wanted to work on your instance today but we no longer have access.

Please grant us access for a week and I will make sure we can resolve it.

[CnP.Support]

Good day!

We fixed the issue with Order # 1410202328443873029

No other issues were found.

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

[kraldrich]

That is great, thanks for your help! Can you provide an explanation of the issue and how you fixed it? Is this something I can fix myself if it happens again in the future? Thank you.
~Kristen

Good day!

We fixed the issue with Order # 1410202328443873029

No other issues were found.

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

[CnP.Support]

Good day!

We can't trace the error in your instance since the debug mode is not turned on.

We simply removed the transaction and posted it again and it worked. Perhaps you had some code or validation in place that had blocked us from creating the opportunity. Since the debug mode is not enabled we can't figure out what might have gone wrong with your instance.

Let us know if this happens again and we can review similarities.