• Replies 4 replies
  • Subscribers 337 subscribers
  • Views 88 views
  • Users 0 members are here
Related

Move Transactions problem

Former Member
Former Member $organization

Wondering if anyone else has run into this in the past.  We are trying to move an individuals transactions to the household using the standard tool.  But we are getting the following error:

"Msg 50000, Level 16, State 1, Procedure AP_MOVE_TRANSACTIONS_TO_HOUSEHOLD, Line 415

Transactions cannot be moved: Error in T_ACCOUNT_DATA_TI on line 27: Error #50000 Cannot store null as protected data. "

I initially thought this was related to credit cards as that's the one place I could think of with encrypted data.  However, after removing all credit cards from the account, I am still getting the error. 

It looks like the error message is coming from the INSERT trigger on T_ACCOUNT_DATA making a check to ensure that the encrypted copy of the cc number is present. But the credit card record (when it existed) definitely wasn't null, and now the cards are gone.  So I'm not sure where the issue lies.  

Any takers?

- Levi

Parents
  • $organization

    Levi,

    If you open a support ticket, we can help you with this.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Thursday, September 19, 2013 4:56 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Move Transactions problem

     

    Wondering if anyone else has run into this in the past.  We are trying to move an individuals transactions to the household using the standard tool.  But we are getting the following error:

    "Msg 50000, Level 16, State 1, Procedure AP_MOVE_TRANSACTIONS_TO_HOUSEHOLD, Line 415

    Transactions cannot be moved: Error in T_ACCOUNT_DATA_TI on line 27: Error #50000 Cannot store null as protected data. "

    I initially thought this was related to credit cards as that's the one place I could think of with encrypted data.  However, after removing all credit cards from the account, I am still getting the error. 

    It looks like the error message is coming from the INSERT trigger on T_ACCOUNT_DATA making a check to ensure that the encrypted copy of the cc number is present. But the credit card record (when it existed) definitely wasn't null, and now the cards are gone.  So I'm not sure where the issue lies.  

    Any takers?

    - Levi




    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!

Reply
  • $organization

    Levi,

    If you open a support ticket, we can help you with this.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Thursday, September 19, 2013 4:56 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Move Transactions problem

     

    Wondering if anyone else has run into this in the past.  We are trying to move an individuals transactions to the household using the standard tool.  But we are getting the following error:

    "Msg 50000, Level 16, State 1, Procedure AP_MOVE_TRANSACTIONS_TO_HOUSEHOLD, Line 415

    Transactions cannot be moved: Error in T_ACCOUNT_DATA_TI on line 27: Error #50000 Cannot store null as protected data. "

    I initially thought this was related to credit cards as that's the one place I could think of with encrypted data.  However, after removing all credit cards from the account, I am still getting the error. 

    It looks like the error message is coming from the INSERT trigger on T_ACCOUNT_DATA making a check to ensure that the encrypted copy of the cc number is present. But the credit card record (when it existed) definitely wasn't null, and now the cards are gone.  So I'm not sure where the issue lies.  

    Any takers?

    - Levi




    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!

Children