• Replies 2 replies
  • Subscribers 336 subscribers
  • Views 67 views
  • Users 0 members are here
Related

Database Error

Marty Jones
$organization

Anybody seen this error before?

Database Error

Error #0: Procedure has not been executed or has no results.

 

What I am doing is setting up new servers for both Tessitura and TranScend and just got done setting up TranScend and the Tessitura CC Server as a service and was testing a Credit card purchase through an order. I do not get any errors when I do a cash purchase. The transaction does make into TranScend and I do get an Auth No.

The Tessitura database is a copy of our Live database and TranScend is a copy of our Test TranScend using the procedures from the Intrix document to move a database.

I have check the settings in T_Default and do not appear to be any issues.

 

Thanks for the help.

  • Former Member
    Former Member $organization

    This is likely caused by a lack of synchronization between the database encryption keys in Impresario and the server master key on your new database server. Review the "Moving a Database" document for specific steps to take to sync your keys:

    http://www.tessituranetwork.com/network/Learning/Documentation/System%20Administration/Moving%20a%20Database.aspx

    Hope this helps!

  • $organization in reply to Former Member

    Steven,

     

    Thanks, that was it. Isn't documentation a wonderful thing?

     

     

    Thanks again.

     

    Marty Jones

    Database Administrator

     

    Omaha Performing Arts
    1200 Douglas Street

    Omaha, Nebraska 68102

    P 402.661.8469  |  F 402.345.0222    

    Marty.Jones@omahaperformingarts.org

    www.omahaperformingarts.org

    For tickets, call Ticket Omaha at 402.345.0606

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Steven Bras
    Sent: Tuesday, April 13, 2010 12:42 PM
    To: Martin A. Jones
    Subject: Re: [Tessitura Technical Forum] Database Error

     

    This is likely caused by a lack of synchronization between the database encryption keys in Impresario and the server master key on your new database server. Review the "Moving a Database" document for specific steps to take to sync your keys:

    http://www.tessituranetwork.com/network/Learning/Documentation/System%20Administration/Moving%20a%20Database.aspx

    Hope this helps!

    From: Marty Jones <bounce-martyjones7649@tessituranetwork.com>
    Sent: 4/13/2010 11:38:43 AM

    Anybody seen this error before?

    Database Error

    Error #0: Procedure has not been executed or has no results.

     

    What I am doing is setting up new servers for both Tessitura and TranScend and just got done setting up TranScend and the Tessitura CC Server as a service and was testing a Credit card purchase through an order. I do not get any errors when I do a cash purchase. The transaction does make into TranScend and I do get an Auth No.

    The Tessitura database is a copy of our Live database and TranScend is a copy of our Test TranScend using the procedures from the Intrix document to move a database.

    I have check the settings in T_Default and do not appear to be any issues.

     

    Thanks for the help.




    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!