Stored Procedure Error 7.23. UC6

richie_smith · #1 (**permalink**) 02-26-04, 09:33

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 ?

gurey · #2 (**permalink**) 02-26-04, 09:48

Quote:

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.

richie_smith · #3 (**permalink**) 02-26-04, 10:13

Thanks - I'll give that a go.

I run "Update Stats" every night.

krisvansnick · #4 (**permalink**) 03-03-04, 02:04

Quote:

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech