• Replies 6 replies
  • Subscribers 338 subscribers
  • Views 33 views
  • Users 0 members are here
Related

f_get_nextid

Randall Mitchell
$organization

We have this error comes up randomly in our TEST environment. Sometimes it comes up immediately when a user logs in. Other times the user will be kicked out and the error appears. How I do begin to isolate this?

********************************

The error is a System Error and reads: "A system error has occured. Please contact your adminstrator and provide the folowing information:

The error message is a System Error and reads:

 A System Error has occurred.

Please contact your system administrator and provide the following information:

 Windowmenu: f_get_nextid

Object: f_get_nextid

Objectevent: f_get_nextid

Line: 10

Error Code: 20

Error Text: Database command not successfully prepared at line 10 in function f_get_nextid of object f_get_nextid

Parents
  • Former Member
    Former Member $organization
    This error is usually solved by dropping and recreating the affected user's login in the test Security module.  If all user logins were not dropped on the test system before a live to test copy or restore and recreated after the copy/restore is complete, this may result for one or more users. 
     
    Bob

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Randall Mitchell
    Sent: Tuesday, June 08, 2010 6:26 PM
    To: Robert Bell
    Subject: [Tessitura Technical Forum] f_get_nextid

    We have this error comes up randomly in our TEST environment. Sometimes it comes up immediately when a user logs in. Other times the user will be kicked out and the error appears. How I do begin to isolate this?

    ********************************

    The error is a System Error and reads: "A system error has occured. Please contact your adminstrator and provide the folowing information:

    The error message is a System Error and reads:

     A System Error has occurred.

    Please contact your system administrator and provide the following information:

     Windowmenu: f_get_nextid

    Object: f_get_nextid

    Objectevent: f_get_nextid

    Line: 10

    Error Code: 20

    Error Text: Database command not successfully prepared at line 10 in function f_get_nextid of object f_get_nextid




    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

    thank you. I'll drop and recreate and see if that works!

  • $organization in reply to Randall Mitchell

    I noticed that by adding the SQL password at the bottom right of the Edit user screen in Security, you don't need to drop and recreate.

    At least in the particular case I was dealing with...

    Just thought I would drop in a note since this seems simpler.

    Cheers!

     

    Gabe.

Reply Children
No Data