Hi Guys,
When trying to create a new instance using the DBMGUI Wizzard, I am getting the following error: -24988: ERR_SQL - sql error
Attached an extract of knldiag:
============================================ begin of write cycle ==================
2010-05-08 18:10:18 0x1440 19633 CONNECT Connect req. (T5, Node:'', PID:376)
2010-05-08 18:10:18 0x1440 19615 DEVIO Attaching devspace 'SYS_001'
2010-05-08 18:10:18 0x140C ERR 18159 DEVIO Could not open devspace 'SYS_001', rc = 2
2010-05-08 18:10:18 0x1440 ERR 53013 I/O could not open devspace
2010-05-08 18:10:18 0x1440 ERR 53017 I/O SYSDEV DEVNO: 1
2010-05-08 18:10:18 0x1440 ERR 53016 I/O SYS_001
2010-05-08 18:10:18 0x1440 19651 CONNECT Connection released, T5
2010-05-08 18:10:25 0x1440 19633 CONNECT Connect req. (T5, Node:'', PID:376)
2010-05-08 18:10:25 0x318 19625 IO Async I/O thread started, 'D:\sapdb\N02\backup
2010-05-08 18:10:25 0x318 ERR 18611 SECURITY Access denied
2010-05-08 18:10:25 0x1440 52011 SAVE tape: surprising blockcount
2010-05-08 18:10:25 0x1440 19651 CONNECT Connection released, T5
2010-05-08 18:10:26 0x1440 19633 CONNECT Connect req. (T5, Node:'', PID:376)
2010-05-08 18:10:27 0xBF8 19625 IO Async I/O thread started, 'D:\sapdb\N02\backup
2010-05-08 18:10:27 0xBF8 ERR 18611 SECURITY Access denied
2010-05-08 18:10:27 0x1440 ERR 52012 RESTORE error occured, basis_err 3700
2010-05-08 18:10:35 0x1440 19651 CONNECT Connection released, T5
2010-05-08 18:10:39 0x8EC 19611 DBSTATE SERVERDB is being stopped
2010-05-08 18:10:39 0x12C8 19617 DEVIO Single I/O attach, 'knltrace', UKT:1
2010-05-08 18:10:39 0x8EC 19684 TASKING Tracewriter termination timeout: 1200 sec
2010-05-08 18:10:39 0x12C8 19619 TASKING Releasing tracewriter
2010-05-08 18:10:39 0x8EC 19600 VERSION 'Kernel 7.3.0 Build 035-000-090-294'
2010-05-08 18:10:39 0x8EC 19654 DBSTATE SERVERDB 'N02' has stopped
-
current write position -
and also an extract of knldiag.err:
2010-05-08 17:21:20 --- Starting ---
2010-05-08 17:28:18 0x16D4 ERR 18159 DEVIO Could not open devspace 'SYS_001', rc = 2
2010-05-08 17:28:18 0x1578 ERR 53013 I/O could not open devspace
2010-05-08 17:28:18 0x1578 ERR 53017 I/O SYSDEV DEVNO: 1
2010-05-08 17:28:18 0x1578 ERR 53016 I/O SYS_001
2010-05-08 17:28:27 0xBA0 ERR 18611 SECURITY Access denied
2010-05-08 17:28:32 0x1440 ERR 18611 SECURITY Access denied
2010-05-08 17:28:32 0x1578 ERR 52012 RESTORE error occured, basis_err 3700
2010-05-08 18:09:52 --- Starting ---
2010-05-08 18:10:18 0x140C ERR 18159 DEVIO Could not open devspace 'SYS_001', rc = 2
2010-05-08 18:10:18 0x1440 ERR 53013 I/O could not open devspace
2010-05-08 18:10:18 0x1440 ERR 53017 I/O SYSDEV DEVNO: 1
2010-05-08 18:10:18 0x1440 ERR 53016 I/O SYS_001
2010-05-08 18:10:25 0x318 ERR 18611 SECURITY Access denied
2010-05-08 18:10:27 0xBF8 ERR 18611 SECURITY Access denied
2010-05-08 18:10:27 0x1440 ERR 52012 RESTORE error occured, basis_err 3700
And lastly, the dbm.prt file:
0x00000318 ERR -24988 DBM -902,Message not available
2010-05-08 17:28:27 0x00000318 0 DBM command backup_label
2010-05-08 17:28:27 0x00000318 ERR -24988 DBM ERR_SQL: sql error
0x00000318 ERR -24988 DBM -903,Message not available,access denied [5]
2010-05-08 17:28:32 0x00000318 0 DBM command backup_restore "N02FULL" DATA
2010-05-08 17:28:32 0x00000318 ERR -24988 DBM ERR_SQL: sql error
0x00000318 ERR -24988 DBM -903,Message not available,access denied [5]
2010-05-08 17:28:38 0x00000318 0 DBM command backup_save_cancel
2010-05-08 17:28:38 0x00000318 ERR -24988 DBM ERR_SQL: sql error
0x00000318 ERR -24988 DBM -7078,Message not available
2010-05-08 18:10:18 0x00000178 0 DBM command backup_history_open
2010-05-08 18:10:18 0x00000178 ERR -24982 DBM ERR_NOHISTORY: backup history file not found
2010-05-08 18:10:18 0x00000178 0 DBM command backup_restart_info
2010-05-08 18:10:18 0x00000178 ERR -24988 DBM ERR_SQL: sql error
0x00000178 ERR -24988 DBM -902,Message not available
2010-05-08 18:10:25 0x00000178 0 DBM command backup_label
2010-05-08 18:10:25 0x00000178 ERR -24988 DBM ERR_SQL: sql error
0x00000178 ERR -24988 DBM -903,Message not available,access denied [5]
2010-05-08 18:10:26 0x00000178 0 DBM command backup_restore "N02FULL" DATA
2010-05-08 18:10:27 0x00000178 ERR -24988 DBM ERR_SQL: sql error
0x00000178 ERR -24988 DBM -903,Message not available,access denied [5]
2010-05-08 18:10:34 0x00000178 0 DBM command backup_save_cancel
2010-05-08 18:10:35 0x00000178 ERR -24988 DBM ERR_SQL: sql error
0x00000178 ERR -24988 DBM -7078,Message not available
2010-05-08 18:10:39 0x00001224 0 DBM command db_offline
I have search for possible solutions for a few days now, and nothing yet. Please advise what I need to look at, and what could possibly be the issue.
Many thanks.
Freddie.