SEO

Our ASE 15.0 Express on Linux (Debian stable) reports error 1025 to a
windows client application. I have turned on logging for this error
(sp_altermessage 1025,with_log,true) and get lines like

00:00000:00018:2006/02/24 14:19:06.72 server Abstract Plan (AP)
Warning : An error occured while applying the AP:

in the error log.


I have sampled the queries (using mda/monSysSQLText) issued by the
application, but I am not able to provoke the same error when
executing the queries manually. I have tried isql, sqsh on the ASE
server and SQL Advantage on a Windows client.

Error 1025 is not listed in the Trobleshooting and Error Message
Guide, but the document available on the web appears to be quite aged
(ISBN 39996-01-1250-01, last revised May 2002).

I have applied ebfs 12948 and 13247 to the ASE 15 Express.


Hints, solutions and relevant pointers are welcome.

--
Odd Skjaeveland odd.privat@hamso.no

It looks as though your server is enabled to use Abstract Plans. Is this your intention? Abstract Plans are used to override the query optimizer and force the use of a particular, previously generated optimization strategy. From the error you are getting, it appears that the query in question is being run under the abstract plan "associate" mode - which causes the AP to be used. You might want to examine why this mode is being used and consider turning it off.