Hello,

Has anyone else had a problem where sp_addmessage starts failing with:
"Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped
during query optimization.".

I'm running ASE 12.5.2 developers edition on Linux. I had to do some sort
order and language conversions on the databases that I ported over from
11.9.2, but apart from that I don't think I've done anything out of the
ordinary to bring this about.

My workaround has been to create my own copy of sp_addmessage in my
database, being careful to make sure that "allow updates" is on when I
compile it so it can update the sysusermessages system table.

But does anyone know a good way to fix the original problem? I've tried
deleting and updating statistics on all the system tables and it didn't
work. Recompiling sp_addmessage in sybsystemprocs didn't work. My hunting
around on the web has come up with a blank. What I did find was a mention
that 12.5.3 has a change request related to the error message I am getting
(339590), but it mentions identity columns and aggregation as part of the
problem so it doesn't really sound like the same thing.

Anyone out there got any better ideas?

Thanks,
Simon.