MINIWAS Error: Database BSP NOT started

[Former Member]

Please i need help . when initializing the data base this is the error:

C:\MiniWAS>dbmcli -U c db_warm

ERR

-24988,ERR_SQL: sql error

-902,Message not available

Error: Database BSP NOT started !

Thanks

when star SAP MBS this message:

C:\MiniWAS>REM =====================================================

C:\MiniWAS>REM Set the Environment for the DB Connect

C:\MiniWAS>REM =====================================================

C:\MiniWAS>set DBMS_TYPE=ada

C:\MiniWAS>set PATH=C:\sapdb\programs\bin;C:\sapdb\programs\pgm;C:\WINDOWS\syste

m32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\ASRAPI2\BIN;C:\sapdb\programs\bin;C:\

sapdb\programs\sap;C:\sapdb\programs\pgm

C:\MiniWAS>REM =====================================================

C:\MiniWAS>REM Start the Database (SAP-DB)

C:\MiniWAS>REM =====================================================

C:\MiniWAS>cmd /c strdbsBSP.cmd

Iniciando base de datos

C:\MiniWAS>set DBNAME=BSP

C:\MiniWAS>x_server

18641 ERROR: XSERVER is already running!

C:\MiniWAS>dbmcli -U c db_warm

ERR

-24988,ERR_SQL: sql error

-902,Message not available

Error: Database BSP NOT started !

C:\MiniWAS>REM =====================================================

C:\MiniWAS>REM Start SAP System

C:\MiniWAS>REM =====================================================

C:\MiniWAS>rem del pxastat

C:\MiniWAS>start /B msg_server.exe pf=BSP_D00.pfl

C:\MiniWAS>disp+work.exe break pf=BSP_D00.pfl

dp Ctrl-C enabled

rslgwr1(21): Searching for overlap point in pre-existing SysLog file...

maximum pfclock time: 4294sec (1)

gw Ctrl-C enabled

dp Ctrl-C enabled

dp Ctrl-C enabled

dp Ctrl-C enabled

maximum pfclock time: 4294sec (1)

maximum pfclock time: 4294sec (1)

maximum pfclock time: 4294sec (1)

maximum pfclock time: 4294sec (1)

adjust_clock: delta 518

adjust_clock: delta 504

adjust_clock: delta 1500

***

• work process W1 died => tskh_init: db_connect

***

• work process W2 died => tskh_init: db_connect

***

• work process W0 died => tskh_init: db_connect

• WARNING => pfclock may be badly adjusted (518)

IcmHandleArgs: Illegal option break

• ICM up and operational (pid: 1508) ***

***

• DISPATCHER EMERGENCY SHUTDOWN => DpEnvCheck: no more work processes

Shutdown ICM server ....

• ICM shutdown completed (pid: 1508) ***

[Former Member]

With the DB Manager can you start the database manually?

Have you done a search in the OSS for those error messages?

[Former Member]

Did you change any of the names of the DB users?

[Former Member]

nop, i tyr but db not starting...

[Former Member]

the db is offline, not starting....

[Former Member]

What are the logs in the DB showing?

[Former Member]

yes,

2020-10-13 23:05:49 0x00000778 ERR -24988 DBM ERR_SQL: sql error

0x00000778 ERR -24988 DBM -902,Message not available

[Former Member]

The only mention I can find for that error number is about invalid user names.

How did you upgrade the system and DB?

[roland_mallmann]

Hi,

there must be some more information in the file named 'knldiag' or 'knldiag.err' file. Can you please copy and paste some information from either of those files into this thread?

Additionally, please mention your exact MaxDB/SAP DB Version (incl. Build).

I also noticed you've set the date of your system to the year 2020???

Regards,

Roland