Skip to Content
0
Jan 13, 2020 at 04:34 PM

#ABAP_Trial Error: 823, Severity: 24, State: 1

147 Views

Hello,

I'm trying to set up the ABAP trial System with NetWeaver 7.52 in order to use the ABAP Code Check to evaluate our S/4HANA readiness. Unfortunately, we ran into rather obscure errors and were advised to use transaction SGEN to re-compile the ABAP package. This did help to a certain degree, because ACT stopped working at step 8 instead of step 6.

Unfortunately, we started getting Sybase database errors, starting with Error: 1105, Severity: 17, State: 4.

I was able to solve this error eventually, but run into Error: 823, Severity: 24, State: 1

kernel sddone: read error on virtual disk 7 block 5027608:
kernel sddone: Input/output error
server Error: 823, Severity: 24, State: 1
server I/O error detected during read for BUF=0x0x00000001970835f8, MASS=0x0x00000001970835f8, Buf#=0, page=0x0x0000000195a2c000, dbid=5, Mass vdevno=7, vpage=5027608, Buf lpage=628451, Mass stat=0x4000100, Buf stat=0x1, size=16384, cid=0 ('default data cache'), Pinned xdes=0x(nil), spid=0.

Disk 7 is Sybase device NPL_data_001. Database NPL has DBID 5.

I have tried executing dbcc sp_dboption(NPL, fix) to no avail:

1> use master
2> go
1> sp_dboption NPL, single, true
2> go
Database option 'single user' turned ON for database 'NPL'.
Running CHECKPOINT on database 'NPL' for option 'single user' to take effect.
(return status = 0)
1> checkpoint
2> go
1> use master
2> go
1> dbcc checkalloc(NPL, fix)
2> go
Checking NPL: Logical pagesize is 16384 bytes
***************************************************************
TABLE: sysobjects OBJID = 1
PARTITION ID=1 FIRST=1 ROOT=1 SORT=0
Data level: indid 0, partition 1. 566 Data pages allocated and 89 Extents allocated.
PARTITION ID=1 FIRST=137 ROOT=136 SORT=1
Indid : 2, partition : 1. 189 Index pages allocated and 24 Extents allocated.
PARTITION ID=1 FIRST=10 ROOT=9 SORT=0
Indid : 3, partition : 1. 93 Index pages allocated and 13 Extents allocated.
TOTAL # of extents = 126
***************************************************************
TABLE: sysindexes OBJID = 2
PARTITION ID=2 FIRST=16 ROOT=16 SORT=0
Data level: indid 0, partition 2. 1152 Data pages allocated and 182 Extents allocated.
PARTITION ID=2 FIRST=34 ROOT=33 SORT=0
Indid : 2, partition : 2. 169 Index pages allocated and 23 Extents allocated.
TOTAL # of extents = 205
***************************************************************
TABLE: syscolumns OBJID = 3
PARTITION ID=3 FIRST=40 ROOT=40 SORT=0
Data level: indid 0, partition 3. 1889 Data pages allocated and 342 Extents allocated.
PARTITION ID=3 FIRST=50 ROOT=49 SORT=0
Indid : 2, partition : 3. 1195 Index pages allocated and 158 Extents allocated.
TOTAL # of extents = 500
***************************************************************
TABLE: systypes OBJID = 4
PARTITION ID=4 FIRST=7608 ROOT=7608 SORT=1
Data level: indid 0, partition 4. 1 Data pages allocated and 2 Extents allocated.
PARTITION ID=4 FIRST=31441 ROOT=31440 SORT=0
Indid : 2, partition : 4. 2 Index pages allocated and 2 Extents allocated.
PARTITION ID=4 FIRST=7625 ROOT=7624 SORT=1
Indid : 3, partition : 4. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 6
***************************************************************
TABLE: sysprocedures OBJID = 5
PARTITION ID=5 FIRST=209 ROOT=209 SORT=0
Data level: indid 0, partition 5. 3191 Data pages allocated and 599 Extents allocated.
PARTITION ID=5 FIRST=225 ROOT=224 SORT=1
Indid : 2, partition : 5. 1081 Index pages allocated and 156 Extents allocated.
TOTAL # of extents = 755
***************************************************************
TABLE: syscomments OBJID = 6
PARTITION ID=6 FIRST=73 ROOT=73 SORT=0
Data level: indid 0, partition 6. 523 Data pages allocated and 109 Extents allocated.
PARTITION ID=6 FIRST=241 ROOT=240 SORT=1
Indid : 2, partition : 6. 224 Index pages allocated and 30 Extents allocated.
TOTAL # of extents = 139
***************************************************************
TABLE: syssegments OBJID = 7
PARTITION ID=7 FIRST=249 ROOT=249 SORT=0
Data level: indid 0, partition 7. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: syslogs OBJID = 8
PARTITION ID=8 FIRST=2706219 ROOT=3402345 SORT=0
Msg 2502, Level 16, State 1:
Server 'NPL', Line 1:
Table Corrupt: A page is linked in more than one chain; check this page: page number=2706219 allocation status=248
TOTAL # of extents = 0
***************************************************************
TABLE: sysprotects OBJID = 9
PARTITION ID=9 FIRST=258 ROOT=258 SORT=0
Data level: indid 0, partition 9. 1 Data pages allocated and 1 Extents allocated.
PARTITION ID=9 FIRST=273 ROOT=272 SORT=1
Indid : 2, partition : 9. 6 Index pages allocated and 6 Extents allocated.
TOTAL # of extents = 7
***************************************************************
TABLE: sysusers OBJID = 10
PARTITION ID=10 FIRST=281 ROOT=281 SORT=0
Data level: indid 0, partition 10. 1 Data pages allocated and 1 Extents allocated.
PARTITION ID=10 FIRST=313 ROOT=312 SORT=1
Indid : 2, partition : 10. 2 Index pages allocated and 2 Extents allocated.
PARTITION ID=10 FIRST=329 ROOT=328 SORT=1
Indid : 3, partition : 10. 2 Index pages allocated and 2 Extents allocated.
PARTITION ID=10 FIRST=297 ROOT=296 SORT=1
Indid : 4, partition : 10. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 7
***************************************************************
TABLE: sysalternates OBJID = 11
PARTITION ID=11 FIRST=337 ROOT=337 SORT=0
Data level: indid 0, partition 11. 1 Data pages allocated and 1 Extents allocated.
PARTITION ID=11 FIRST=353 ROOT=352 SORT=1
Indid : 2, partition : 11. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: sysdepends OBJID = 12
PARTITION ID=12 FIRST=361 ROOT=361 SORT=0
Data level: indid 0, partition 12. 31 Data pages allocated and 8 Extents allocated.
PARTITION ID=12 FIRST=377 ROOT=376 SORT=1
Indid : 2, partition : 12. 73 Index pages allocated and 10 Extents allocated.
TOTAL # of extents = 18
***************************************************************
TABLE: syskeys OBJID = 13
PARTITION ID=13 FIRST=385 ROOT=385 SORT=0
Data level: indid 0, partition 13. 1 Data pages allocated and 1 Extents allocated.
PARTITION ID=13 FIRST=401 ROOT=400 SORT=1
Indid : 2, partition : 13. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: sysusermessages OBJID = 15
PARTITION ID=15 FIRST=545 ROOT=537 SORT=1
Data level: indid 1, partition 15. 1 Data pages allocated and 1 Extents allocated.
Indid : 1, partition : 15. 1 Index pages allocated and 1 Extents allocated.
PARTITION ID=15 FIRST=529 ROOT=529 SORT=0
Indid : 2, partition : 15. 1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: sysreferences OBJID = 16
PARTITION ID=16 FIRST=169 ROOT=169 SORT=0
Data level: indid 0, partition 16. 1 Data pages allocated and 1 Extents allocated.
PARTITION ID=16 FIRST=465 ROOT=464 SORT=1
Indid : 2, partition : 16. 2 Index pages allocated and 2 Extents allocated.
PARTITION ID=16 FIRST=481 ROOT=480 SORT=1
Indid : 3, partition : 16. 2 Index pages allocated and 2 Extents allocated.
PARTITION ID=16 FIRST=449 ROOT=448 SORT=1
Indid : 4, partition : 16. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 7
***************************************************************
TABLE: sysconstraints OBJID = 17
PARTITION ID=17 FIRST=489 ROOT=489 SORT=0
Data level: indid 0, partition 17. 1 Data pages allocated and 1 Extents allocated.
PARTITION ID=17 FIRST=521 ROOT=520 SORT=1
Indid : 2, partition : 17. 2 Index pages allocated and 2 Extents allocated.
PARTITION ID=17 FIRST=505 ROOT=504 SORT=1
Indid : 3, partition : 17. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: systhresholds OBJID = 18
PARTITION ID=18 FIRST=553 ROOT=553 SORT=0
Data level: indid 0, partition 18. 1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: sysroles OBJID = 19
PARTITION ID=19 FIRST=561 ROOT=561 SORT=0
Data level: indid 0, partition 19. 1 Data pages allocated and 1 Extents allocated.
PARTITION ID=19 FIRST=577 ROOT=576 SORT=1
Indid : 2, partition : 19. 2 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: sysattributes OBJID = 21
PARTITION ID=21 FIRST=785 ROOT=785 SORT=0
Data level: indid 0, partition 21. 1 Data pages allocated and 1 Extents allocated.
PARTITION ID=21 FIRST=825 ROOT=824 SORT=1
Indid : 2, partition : 21. 2 Index pages allocated and 2 Extents allocated.
PARTITION ID=21 FIRST=809 ROOT=808 SORT=1
Indid : 3, partition : 21. 2 Index pages allocated and 2 Extents allocated.
PARTITION ID=21 FIRST=793 ROOT=793 SORT=0
TOTAL # of extents = 5
***************************************************************
TABLE: sysslices OBJID = 22
PARTITION ID=22 FIRST=601 ROOT=593 SORT=1
Data level: indid 1, partition 22. 1 Data pages allocated and 1 Extents allocated.
Indid : 1, partition : 22. 1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: systabstats OBJID = 23
PARTITION ID=23 FIRST=184 ROOT=184 SORT=1
Msg 9004, Level 16, State 1:
Server 'NPL', Line 1:
I/O error detected on disk buffer 0x0x19b1b39f0 for page request 628448, dbid 5.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.

I guess errors...

  • Msg 2502, Level 16, State 1:
    Server 'NPL', Line 1:
    Table Corrupt: A page is linked in more than one chain; check this page: page number=2706219 allocation status=248
  • Msg 9004, Level 16, State 1:
    Server 'NPL', Line 1:
    I/O error detected on disk buffer 0x0x19b1b39f0 for page request 628448, dbid 5.

...are follow-up errors?