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
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.