Skip to Content
0
Former Member
May 10, 2010 at 09:44 AM

-24988: ERR_SQL - sql error - Content Server

195 Views

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.