SAP DB 7.3.0.35 ERR 53007 ILLEGAL DATA DEV

[Former Member]

Hello to everyone,

While trying to start DB I got message:

<b>-24988 sql error [db_worm -f] -8888, connection broken</b>

I have this log in KNLDIAG:

2007-11-08 14:16:15 0xFAC ERR 53007 CONFIG ILLEGAL DATA DEV SIZES

2007-11-08 14:16:15 0xFAC ERR 53007 CONFIG RestartRec: Max Data Pno: 889983

2007-11-08 14:16:15 0xFAC ERR 53007 CONFIG Config: Max Data Pno: 942335

I'm just beginner in SAPDB and I can not find any resolution for that error.

Hope sb can help.

Thanks in advance !!!

[markus_doehr2 · Accepted solution]

What did you prior to the startup? did you copy datafiles over?

--

Markus

[Former Member · Accepted solution]

Before startup, new volume was added to DB. (DB was almost out off free space)

[markus_doehr2 · Accepted solution]

did you add a new volume or did you increase the size of a current one? Check in knldiag which volume makes the problem.

--

Markus

[Former Member · Accepted solution]

Increasing of existing DB was made.

There is more info from knldiag - but no info about problems:

2007-11-08 15:07:24 0x990 19633 CONNECT Connect req. (T5, Node:'', PID:3576)

2007-11-08 15:07:24 0x990 19651 CONNECT Connection released, T5

2007-11-08 15:07:24 0x990 19633 CONNECT Connect req. (T5, Node:'', PID:3576)

2007-11-08 15:07:24 0x990 19615 DEVIO Attaching devspace 'C:\sapdb\SDB\dbsys\SYS'

2007-11-08 15:07:24 0xC8 19613 DBSTATE I/O thread for 'C:\sapdb\SDB\dbsys\SYS' started

2007-11-08 15:07:24 0x990 19617 DEVIO Single I/O attach, 'C:\sapdb\SDB\dbsys\SYS', UKT:3

2007-11-08 15:07:24 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0001'

2007-11-08 15:07:24 0xF18 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0001' started

2007-11-08 15:07:24 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0002'

2007-11-08 15:07:24 0xC3C 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0002' started

2007-11-08 15:07:24 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0003'

2007-11-08 15:07:24 0x304 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0003' started

2007-11-08 15:07:24 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0004'

2007-11-08 15:07:24 0xF28 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0004' started

2007-11-08 15:07:24 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0005'

2007-11-08 15:07:24 0xBDC 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0005' started

2007-11-08 15:07:25 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0006'

2007-11-08 15:07:25 0xCEC 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0006' started

2007-11-08 15:07:25 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0007'

2007-11-08 15:07:25 0x6F4 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0007' started

2007-11-08 15:07:25 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0008'

2007-11-08 15:07:25 0x5A8 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0008' started

2007-11-08 15:07:25 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0009'

2007-11-08 15:07:25 0xF60 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0009' started

2007-11-08 15:07:25 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0010'

2007-11-08 15:07:25 0xF78 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0010' started

2007-11-08 15:07:25 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0011'

2007-11-08 15:07:25 0x6D4 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0011' started

2007-11-08 15:07:25 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0012'

2007-11-08 15:07:26 0x108 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0012' started

2007-11-08 15:07:26 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0013'

2007-11-08 15:07:26 0xEDC 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0013' started

2007-11-08 15:07:26 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0014'

2007-11-08 15:07:26 0xEB8 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0014' started

2007-11-08 15:07:26 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0015'

2007-11-08 15:07:26 0xB70 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0015' started

2007-11-08 15:07:26 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0016'

2007-11-08 15:07:26 0x944 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0016' started

2007-11-08 15:07:26 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0017'

2007-11-08 15:07:26 0xBA0 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0017' started

2007-11-08 15:07:26 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\sapdata\DISKD0018'

2007-11-08 15:07:26 0xD7C 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\sapdata\DISKD0018' started

2007-11-08 15:07:27 0x990 19615 DEVIO Attaching devspace 'D:\sapdb\SDB\saplog\DISKL001'

2007-11-08 15:07:27 0x81C 19613 DBSTATE I/O thread for 'D:\sapdb\SDB\saplog\DISKL001' started

2007-11-08 15:07:27 0x990 ERR 53007 CONFIG ILLEGAL DATA DEV SIZES

2007-11-08 15:07:27 0x990 ERR 53007 CONFIG RestartRec: Max Data Pno: 889983

2007-11-08 15:07:27 0x990 ERR 53007 CONFIG Config: Max Data Pno: 942335

2007-11-08 15:07:27 0x990 ERR 18196 DBCRASH vabort:Emergency Shutdown, vbd15.c: 5156

I thing that there should be 942335 in RestartRec: Max Data Pno: 889983 because there is 18 devspace 52352 pages each one....but I dont know have to set up this parameter.

[Melanie · Accepted solution]

Hello Michal.

could you please explain how exactly you were adding the new data volume? Which command(s) did you use?

The error looks as if you just changed the configuration file but did not actually add a new data volume.

Melanie

[Former Member · Accepted solution]

Hi Melanie,

It was done with SAP DB GUI just by (configuration->volumes->new volumen). It always goes ok - but this time no.....

[Melanie · Accepted solution]

Hi Michal,

I just saw, that you already opened a customer message concerning this issue. So further analysis will be done using this message.

Best regards,

Melanie

[Former Member]

Case was resolved by SAP with ingerence into DB.

[Former Member]

Hi

Am facing the same issue my test system. Could u jus let me know the resolution.

Extracted from knldiag.err:-

2011-05-10 18:51:18 --- Starting ---

2011-05-10 18:51:25 0xCC4 ERR 18177 DEVIO No devspace on compressed file 'c:/sapdb/data/O3LOGS0001'

2011-05-10 18:51:25 0xE14 ERR 53013 I/O no devspaces on compressed file

2011-05-10 18:51:25 0xE14 ERR 53017 I/O LOGDEV DEVNO: 1

2011-05-10 18:51:25 0xE14 ERR 53016 I/O c:/sapdb/data/O3LOGS0001

2011-05-10 18:53:20 --- Starting ---

2011-05-10 18:53:32 0xD90 ERR 53007 CONFIG ILLEGAL DATA DEV SIZES

2011-05-10 18:53:32 0xD90 ERR 53007 CONFIG RestartRec: Max Data Pno: 1048559

2011-05-10 18:53:32 0xD90 ERR 53007 CONFIG Config: Max Data Pno: 131069

2011-05-10 18:53:32 0xD90 ERR 18196 DBCRASH vabort:Emergency Shutdown, vbd15.c: 5106

2011-05-10 18:53:32 0xD90 ERR 19999 BTRACE module file name |.text start |.text end

2011-05-10 18:53:32 0xD90 ERR 19999 BTRACE kernel.exe | 0x00400000 | 0x00845000

2011-05-10 18:53:32 0xD90 ERR 19999 BTRACE DBGHELP.dll | 0x59a60000 | 0x59b01000

[thorsten_zielke]

Hi sathya20075,

I do not think you are facing the same issue.

Please note that MaxDB does not support Windows file compression for its volumes and I guess thhe Data/Log Volumes are currently compressed by Windows.

Thorsten