21
Attempts to read logical page `%ld`, virtpage `%ld` from virtual device `%d` for %S_PTNINFO failed due to read failure in prefetch. Please contact Sybase Technical Support.
A problem occurred when another process tried to read the indicated page asynchronously. Adaptive Server will retry this operation 10 times, then raise a 12334 error.
It may be possible that some other process is taking an excessive amount of time while accessing the indicated page. Check either the sysprocesses.cpu field. For example:
select top 20 spid,status,program_name,cpu
from master..sysprocesses
order by cpu desc
Or, if you have Monitoring and Diagnostic (MDA) tables installed, check the monProcessActivity.CPUTime field to check for jobs with high CPU usage. For example:
select top 20 a.SPID, a.CPUTime, b.Application, b.Command
from master..monProcessActivity a, master..monProcess b
where a.SPID = b.SPID
order by a.CPUTime desc
Examine any jobs with unexpectedly high cpu usage to see what they are doing. When any problems are corrected, re-run the affected query.
If error 12333 persists, it may be necessary to gather a configurable shared memory dump (CSMD). See “Obtaining a CSMD” in the Troubleshooting and Disaster Recovery guide section “Other Useful Tasks.”
Version 15.0 and later
