SAP Knowledge Base Article - Preview

2502516 - Error 605, 692 on isolation level 0 scan on table undergoing SELECT INTO - SAP ASE

Symptom

  • When running SELECT INTO a new table
  • A concurrent SELECT at isolation level 0 on that new table reports Error 605:

Msg 605, Level 21, State 1:
Server 'ASE', Line 1:
An attempt was made to fetch logical page '61649' from cache 'default data cache'. Page belongs to database 'repro_605' (4), object '<Unknown>' (0), index '<Unknown>' (0), partition '<Unknown>' (1776006327) and not to database 'repro_605' (4), object 'l_tab_2' (1920006840), index 'l_tab_2' (0), partition 'l_tab_2_1936006897' (1936006897).

  • Also Error 692, rather than Error 605, may be reported:

Msg 692, Level 20, State 1:
Server 'SP02_PL05', Line 1:
Uninitialized logical page '67796' was read while accessing database 'repro_605' (4), object 'l_tab_2' (1104003933), index 'l_tab_2' (0), partition 'l_tab_2_1136004047' (1136004047). Please contact SAP Technical Support.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR809498, CR#809498, 809498, spurious, ignore , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.