SAP Knowledge Base Article - Preview

2882912 - Error: 7114, Severity: 22, State: 1 followed by Error: 605, Severity: 21, State: 1 - SAP ASE

Symptom

The ASE log started reporting errors:

Error: 7114, Severity: 22, State: 1
Page 0 is not a valid text page. 
************************************
SQL causing error : SELECT .....


LeSendRowR_sendColsToClient6MpnDpss_ii_i_
LeSendRow::sendRowToClient
LeEmitSndOp::_LeEoRouteResults
LeEmitSndOp::_LeOpNext
LeOperator::LeOpNext
LeRetnCode LeEmitSndOp::_LeOpNext
LeRetnCode LeOperator::LeOpNext
LePlanNext

le_execerr
exec_lava
get_txtpage
s_execute
sendimgblks

Error: 605, Severity: 21, State: 1
An attempt was made to fetch logical page '17537281' from cache 'default data cache'. Page belongs to database 'mydb' (22), object 'my_image' (1481769305), index 'ind_image' (255), partition 'my_image_1481769305' (1481769305) and not to database 'mydb' (22), object 'diff_obj' (949575390), index 'diff_obj' (0), partition 'diff_obj_949575390' (949575390).
00:0004:00000:00042:2020/01/15 08:29:48.03 server Starting diagnostics for read failure:
00:0004:00000:00042:2020/01/15 08:29:48.03 server Device Information:
Device number = 32
Phyname = /dev/mydev
00:0004:00000:00042:2020/01/15 08:29:48.03 server Buffer Information:
Buf addr = 0x10097d63a10, Mass addr = 0x10097d63a10
Buf pageno = 17537281, Mass pageno = 17537281, dbid = 22
00:0004:00000:00042:2020/01/15 08:29:48.03 server
Buf virtpg = 17537281, Mass virtpg = 3979009
Buf stat = 0x1, Mass stat = 0x4001008
etc...


Read more...

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.