• 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

    Hi Bob,

    This is a very common occurrence in our non-LIVE environments - we have an environment called MODEL which is refreshed on a nightly basis from that nights backup of LIVE and is an environment we use a lot for some of our (very resource) hungry reports.

    Whilst the solution you post works, are you able to tell me what causes this issue?  Curiously, it appears to affect particular users on a (reasonably) regular basis.

    Martin

Reply
  • $organization in reply to Former Member

    Hi Bob,

    This is a very common occurrence in our non-LIVE environments - we have an environment called MODEL which is refreshed on a nightly basis from that nights backup of LIVE and is an environment we use a lot for some of our (very resource) hungry reports.

    Whilst the solution you post works, are you able to tell me what causes this issue?  Curiously, it appears to affect particular users on a (reasonably) regular basis.

    Martin

Children
No Data