• Replies 4 replies
  • Subscribers 338 subscribers
  • Views 24 views
  • Users 0 members are here
Related

Merge not possible: opera subscriber

Steven Hanks
$organization

Today I tried to merge two records, and received this admonition: "Merge not possible: Delete ID is an Opera Subscriber and Keep ID is not!"

I can't find anything in the records that would trigger this. We don't even have subscriptions.

Any ideas what's up with this?

  • $organization

    That's the example behaviour from LP_VALIDATE_CUST_MERGE, which reference constituency 5, which in that example is the subscriber constituency. So probably constituency 5 is something else for y'all, and that account has that constituency. If you comment out that part of the procedure, your merge should go through.

  • $organization

    This is because of some sample code in the local procedure LP_VALIDATE_CUST_MERGE which is called when two constituents are scheduled to be merged.  It can be commented out and this issue should be resolved.  It should be pretty easy to spot if you open the procedure in an ALTER format in a query window of SSMS.

     

    If you need assistance with this, please open a support ticket!

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Steven Hanks
    Sent: Wednesday, February 24, 2010 2:57 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Merge not possible: opera subscriber

     

    Today I tried to merge two records, and received this admonition: "Merge not possible: Delete ID is an Opera Subscriber and Keep ID is not!"

    I can't find anything in the records that would trigger this. We don't even have subscriptions.

    Any ideas what's up with this?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • Former Member
    Former Member $organization
    This messaging is coming from the localized procedure LP_VALIDATE_CUST_MERGE.  This localized procedure is called when customers are scheduled for merging in the Merge Constituents window.  Its purpose is to allow for custom code to be included that would disallow customers from being scheduled for merging if certain conditions are met.  I believe the default code in this localized procedure is causing the message you are seeing and is likely a result of constituency codes in place on your system that mean something different than in the default code in place in the localized procedure.
     
    Bob

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Steven Hanks
    Sent: Wednesday, February 24, 2010 2:57 PM
    To: Robert Bell
    Subject: [Tessitura Technical Forum] Merge not possible: opera subscriber

    Today I tried to merge two records, and received this admonition: "Merge not possible: Delete ID is an Opera Subscriber and Keep ID is not!"

    I can't find anything in the records that would trigger this. We don't even have subscriptions.

    Any ideas what's up with this?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • $organization in reply to Former Member

    Ryan, Bob and Amanda,

    Thanks for your advice. We've got it fixed now.