dostats fails on indexkeyarray_out
We just moved to 9.40.UC8 from 9.40.UC5 and can no longer run dostats on any
database. It always bombs just as it starts to update the stored procedures
with this error:
Procedures:
indexkeyarray_out...Cannot Update statistics for procedure:
indexkeyarray_out. SQL=-674, ISAM=0.
I looked online and only found one other person seeing this error from a few
years ago -- no solution. The stored procedure *does* exist and running this
command works fine:
update statistics for procedure indexkeyarray_out;
Thanks for any help.
--
"Douglas Palmer" <dcp_news@nyed.uscourts.gov> wrote in message news:ebgg17$hlk$1@coronis.nyed.circ2.dcn... > Procedures: > indexkeyarray_out...Cannot Update statistics for procedure: > indexkeyarray_out. SQL=-674, ISAM=0. A walk home and some distance gave the obvious answer -- get the updated dostats from IIUG, make and install. All better now. Thank you, Art Kagel, for a great utility and for keeping it up. --
DCP wrote: > "Douglas Palmer" <dcp_news@nyed.uscourts.gov> wrote in message > news:ebgg17$hlk$1@coronis.nyed.circ2.dcn... > > >>Procedures: >> indexkeyarray_out...Cannot Update statistics for procedure: >>indexkeyarray_out. SQL=-674, ISAM=0. > > > A walk home and some distance gave the obvious answer -- get the updated > dostats from IIUG, make and install. > > All better now. Ahh, I was just going to post that I thought I'd fixed that recently. Good. > Thank you, Art Kagel, for a great utility and for keeping it up. > You're welcome. 8-)> Art S. Kagel