• Replies 1 reply
  • Subscribers 338 subscribers
  • Views 18 views
  • Users 0 members are here
Related

Problem with Lists and associations

Levi Sauerbrei
$organization

We have started pulling lists using associated records (very exciting!) but one specific association seems to cause problems.  When we try to include associated records using this association we get the following error when trying to generate the list:

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_T_LIST_CONTENTS_T_CUSTOMER". The conflict occurred in database "impresario", table "dbo.T_CUSTOMER", column 'customer_no'.

The list still generates the count, but it does not include the associated records.  Other association types function as expected. 

Has anyone encountered this before?

  • $organization

    Levi, this may be an incorrect setup in TR_XREF_TYPE or a circular reference with a single constituent.  I suggest a support ticket.  We can help you find the issue!

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Tuesday, September 28, 2010 1:23 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Problem with Lists and associations

     

    We have started pulling lists using associated records (very exciting!) but one specific association seems to cause problems.  When we try to include associated records using this association we get the following error when trying to generate the list:

    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_T_LIST_CONTENTS_T_CUSTOMER". The conflict occurred in database "impresario", table "dbo.T_CUSTOMER", column 'customer_no'.

    The list still generates the count, but it does not include the associated records.  Other association types function as expected. 

    Has anyone encountered this before?




    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!