SAP Knowledge Base Article - Preview

2862429 - during boot up cycle sybsystemprocs device raising 840 error then activates - SAP ASE

Symptom

  • SAP ASE on HADR
  • DBACockpit -> ASE Error Log displays 'Insufficient resources' error/warning
  • ASE error raised during boot-up cycle:

00:0002:00000:00002:2019/11/10 19:59:21.76 server Error: 840, Severity: 17, State: 2
00:0002:00000:00002:2019/11/10 19:59:21.76 server Device 'sysprocsdev' (with physical name '/sybase/SID/data/sysprocs.dat', and virtual device number 1) has not been correctly activated at startup time. Please contact a user with System Administrator (SA) role.
00:0002:00000:00002:2019/11/10 19:59:21.78 server Error: 840, Severity: 17, State: 2
00:0002:00000:00002:2019/11/10 19:59:21.78 server Device 'sysprocsdev' (with physical name '/sybase/SID/data/sysprocs.dat', and virtual device number 1) has not been correctly activated at startup time. Please contact a user with System Administrator (SA) role.
00:0002:00000:00002:2019/11/10 19:59:21.89 kernel remote HADR server <SID>_<REPNAME> is STANDBY
00:0002:00000:00002:2019/11/10 19:59:21.89 server Error: 840, Severity: 17, State: 2
00:0002:00000:00002:2019/11/10 19:59:21.89 server Device 'sysprocsdev' (with physical name '/sybase/SID/data/sysprocs.dat', and virtual device number 1) has not been correctly activated at startup time. Please contact a user with System Administrator (SA) role.
00:0002:00000:00002:2019/11/10 19:59:21.90 server Error: 840, Severity: 17, State: 2
00:0002:00000:00002:2019/11/10 19:59:21.90 server Device 'sysprocsdev' (with physical name '/sybase/SID/data/sysprocs.dat', and virtual device number 1) has not been correctly activated at startup time. Please contact a user with System Administrator (SA) role.
00:0002:00000:00002:2019/11/10 19:59:21.93 kernel local server is now promoted to Primary.
00:0002:00000:00002:2019/11/10 19:59:21.93 kernel booting into HADR group PSL_group in Primary mode
00:0000:00000:00000:2019/11/10 19:59:21.93 kernel [139979408004864] Begin processing to generate RSA keypair.
00:0002:00000:00002:2019/11/10 19:59:22.01 server server name is 'SID'
00:0002:00000:00002:2019/11/10 19:59:22.01 server Activating disk 'sysprocsdev' of size 307200 KB.
00:0002:00000:00002:2019/11/10 19:59:22.02 kernel Initializing virtual device 1, '/sybase/<SID>/data/sysprocs.dat' with dsync 'off'.
00:0002:00000:00002:2019/11/10 19:59:22.02 kernel Virtual device 1 started using asynchronous (with DIRECTIO) i/o.
...
...
00:0002:00000:00002:2019/11/10 19:59:24.03 server Started estimating recovery log boundaries for database 'sybsystemprocs'.
00:0002:00000:00002:2019/11/10 19:59:24.03 server Database 'sybsystemprocs', checkpoint=(19046, 54), first=(19046, 54), last=(19046, 54).
00:0002:00000:00002:2019/11/10 19:59:24.03 server Completed estimating recovery log boundaries for database 'sybsystemprocs'.
00:0002:00000:00002:2019/11/10 19:59:24.03 server Started ANALYSIS pass for database 'sybsystemprocs'.
00:0002:00000:00002:2019/11/10 19:59:24.03 server Completed ANALYSIS pass for database 'sybsystemprocs'.
00:0002:00000:00002:2019/11/10 19:59:24.03 server Log contains all committed transactions until 2019/11/10 19:58:29.97 for database sybsystemprocs.
00:0002:00000:00002:2019/11/10 19:59:24.03 server Started REDO pass for database 'sybsystemprocs'. The total number of log records to process is 1.
00:0002:00000:00002:2019/11/10 19:59:24.04 server Completed REDO pass for database 'sybsystemprocs'.
00:0002:00000:00002:2019/11/10 19:59:24.11 server Timestamp for database 'sybsystemprocs' is (0x0000, 0x007645fb).
00:0002:00000:00002:2019/11/10 19:59:24.11 server Recovery of database 'sybsystemprocs' will undo incomplete nested top actions.
00:0002:00000:00002:2019/11/10 19:59:24.11 server Started recovery checkpoint for database 'sybsystemprocs'.
00:0002:00000:00002:2019/11/10 19:59:24.12 server Completed recovery checkpoint for database 'sybsystemprocs'.
00:0002:00000:00002:2019/11/10 19:59:24.13 server Started filling free space info for database 'sybsystemprocs'.
00:0002:00000:00002:2019/11/10 19:59:24.14 server Completed filling free space info for database 'sybsystemprocs'.
00:0002:00000:00002:2019/11/10 19:59:24.14 server Started cleaning up the default data cache for database 'sybsystemprocs'.
00:0002:00000:00002:2019/11/10 19:59:24.15 server Completed cleaning up the default data cache for database 'sybsystemprocs'.
00:0002:00000:00002:2019/11/10 19:59:24.15 server Checking external objects.
00:0002:00000:00002:2019/11/10 19:59:24.19 server The transaction log in the database 'sybsystemprocs' will use I/O size of 16 Kb.
00:0002:00000:00002:2019/11/10 19:59:24.20 server Database 'sybsystemprocs' is now online.


Read more...

Environment

SAP Adaptive Server Enterprise 16.0 SP03 PL06 or higher

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Insufficient resources, activated, startup time, sybsystemprocs, device, sysprocsdev, sybprocsdev , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , 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.