Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    7

    Unanswered: Stored Procedure Error 7.23. UC6

    I'm getting the following error message occasionally when running stored procedures on Onlint 7.23.UC6 under HP-UX 11.00.

    SQL statement error number -211.
    Cannot read system catalog (sysprocauth).
    SYSTEM error number -107.
    ISAM error: record is locked.

    The procedure may run 1000 times perfectly before falling over with this error.

    Any ideas ?

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Stored Procedure Error 7.23. UC6

    Originally posted by richie_smith
    I'm getting the following error message occasionally when running stored procedures on Onlint 7.23.UC6 under HP-UX 11.00.

    SQL statement error number -211.
    Cannot read system catalog (sysprocauth).
    SYSTEM error number -107.
    ISAM error: record is locked.

    The procedure may run 1000 times perfectly before falling over with this error.

    Any ideas ?
    Hi,

    Can be a bug, but please add into SPL the sentences SET LOCK MODE TO WAIT or SET LOCK MODE TO 10.

    How often you run update statisics for procedure u all?

    Gustavo.

  3. #3
    Join Date
    Feb 2004
    Posts
    7
    Thanks - I'll give that a go.

    I run "Update Stats" every night.

  4. #4
    Join Date
    Mar 2004
    Posts
    2

    Re: Stored Procedure Error 7.23. UC6

    Originally posted by richie_smith
    I'm getting the following error message occasionally when running stored procedures on Onlint 7.23.UC6 under HP-UX 11.00.

    SQL statement error number -211.
    Cannot read system catalog (sysprocauth).
    SYSTEM error number -107.
    ISAM error: record is locked.

    The procedure may run 1000 times perfectly before falling over with this error.

    Any ideas ?

    Hi,

    I have the same problem with IDS 7.31.UD7
    Once or twice a day, the error occurs. Strange, because those stored procedures are executed about 200-300 times a day.
    I've been told it was a bug in the IDS version.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •