MaxDB Database Manager do not display State Info.

[JPReyes]

Hi,

After and update done ages ago MaxDB do not display any info on the State page on the DB Manager. Basically i can't see how much Data, log space or sessions are running (DB works fine though!) and I also get the following error when opening the DB in the DB Manager.

-24988 sql error [sql_execute SELECT DESCRIPTION, VALUE FROM SYSDBA.DBPARAMETERS WHERE DESCRIPTION = 'LOG_SEGMENT_SIZE' OR DESCRIPTION = 'MAXUSERTASKS'; 100,Row not found

The version of the DB is 7.4.03.32

version of DB Manager is 7.5.00.18 (I have tried with DB Manager version 7.4.3.30 and the above error do not happen but the info is not displayed either)

DB is running on Windows 2000 server, SP4.

Thanks in Advance!

Juan Reyes

[roland_mallmann · Accepted solution]

Hi,

it's probably due to a missing loading of the system tables. Please (re)load the system tables, either by using the Database Manager GUI or dbmcli:

- Database Manager v7.6: Configuration -> Upgrade System Tables

- dbmcli (from the commandline):

dbmcli -d <SID> -u <dbm-user>,<pwd> load_systab -u <dba-user>,<pwd> -ud DOMAIN

Regards,

Roland

[JPReyes · Accepted solution]

Hi Roland,

I tried to upgrade system tables but i'm getting -24988 sql error [load_systab ...], it seems to me like a kernel problem, im thinking in upgrade to 7.5.00.34

Will this solve the problem?

Regards

Juan Reyes

[roland_mallmann · Accepted solution]

No, I think it will not solve it.

Do you have some more error output? You could check the (/sapdb/data/wrk/<SID>/dbm.prt file

[JPReyes · Accepted solution]

This is the last part of the log...

2006-03-01 11:52:55 0x00000ae4 0 DBM command load_systab

2006-03-01 11:52:56 0x00000ae4 ERR -24904 DBM ERR_DOMPWRONG: wrong DOMAIN password

2006-03-01 11:53:02 0x00000ae4 0 DBM command param_startsession

2006-03-01 11:53:02 0x00000ae4 0 DBM command param_abortsession

2006-03-01 11:57:25 0x00000ae4 0 DBM command load_systab

2006-03-01 11:57:26 0x00000ae4 ERR -24909 DBM ERR_DBAUNKNOWN: SYSDBA unknown

2006-03-01 11:57:38 0x00000ae4 0 DBM command load_systab

2006-03-01 11:57:39 0x00000ae4 ERR -24988 DBM ERR_SQL: sql error

2006-03-01 11:57:43 0x00000ae4 0 DBM command param_startsession

2006-03-01 11:57:44 0x00000ae4 0 DBM command param_abortsession

2006-03-01 11:58:13 0x00000a9c 0 DBM command load_systab

2006-03-01 11:58:14 0x00000a9c ERR -24909 DBM ERR_DBAUNKNOWN: SYSDBA unknown

2006-03-01 11:58:32 0x00000a9c 0 DBM command load_systab

2006-03-01 11:58:33 0x00000a9c ERR -24988 DBM ERR_SQL: sql error

2006-03-01 12:34:01 0x00000a9c 0 DBM command load_systab

2006-03-01 12:34:02 0x00000a9c ERR -24909 DBM ERR_DBAUNKNOWN: SYSDBA unknown

2006-03-01 12:34:16 0x00000a9c 0 DBM command load_systab

2006-03-01 12:34:17 0x00000a9c ERR -24988 DBM ERR_SQL: sql error

[roland_mallmann · Accepted solution]

Hi,

can you please issue the following command from the commandline:

dbmcli -d <SID> -u <dbm-user>,<pwd> user_getall

Additionally, please try to open the following <b>binary</b> files and look for the 'superdba' string (I'm guessing that's what the user is called on your system):

/sapdb/data/config/<SID>.upc

/sapdb/data/wrk/<SID>/dbm.upc

Kind regards,

Roland

[JPReyes · Accepted solution]

Users:

dbm

dba

DOMAIN

CONTROL

superdba

/sapdb/data/wrk/<SID>/dbm.upc

Im opening above file with notepad and i can see superdba but the rest of the text is unreadable

Thanks

Juan

[roland_mallmann · Accepted solution]

So, you don't have a *.upc file in the path /sapdb/data/config?

- Edit 1 -

Erm... you seem to have a 'dba' AND a 'SUPERDBA' user... did you add one of those yourself (manually)?

- Edit 2 -

Can you please show me the output of:

1) xuser list

2) dbmcli -d <SID> -u control,<pwd> [followed by Enter]

a.) sql_connect superdba,<pwd>

b.) sql_connect dba,<pwd>

Message was edited by: Roland Mallmann

[JPReyes · Accepted solution]

<b>So, you don't have a *.upc file in the path /sapdb/data/config?</b>

I don't have a config folder

<b>Erm... you seem to have a 'dba' AND a 'SUPERDBA' user... did you add one of those yourself (manually)?</b>

I didn't but as i said before this update was done ages ago so maybe and old colleague did... Should i remove one?

Cheers!

Juan

[JPReyes · Accepted solution]

how do i get the xuser list?

a.) sql_connect superdba,<pwd>

Connect!

b.) sql_connect dba,<pwd>

Fails (i dont have the pwd)

[roland_mallmann · Accepted solution]

To display the xuser list, just issue 'xuser list' from the commandline.

If command a.) sql_connect superdba,<pwd> succeeded, then

please continue from there with:

sql_execute select * from users

Please let me know the output.

[JPReyes · Accepted solution]

C:\sapdb\programs\bin>xuser list

OS_ERROR 2: The system cannot find the file specified.

RTE_ERROR 1: Error during CreateProcess: c:\program files\sapdb\indep_prog\pgm\u

serx.exe

This is the return from the sql command.

dbmcli on SDB>sql_execute select * from users

ERR

-24988,ERR_SQL: sql error

-4004,Unknown table name:USERS

Message was edited by: Juan Reyes

[roland_mallmann · Accepted solution]

Could you try the following:

1. Rename the UPC-files

a.) c:\sapdb\data\wrk\<SID>\dbm.upc (for example to dbm.upc.orig)

b.) c:\sapdb\data\config\<SID>.upc (for example to <SID>.upc.orig) [apparantly not existing on your system)

2. Create new UPC files

Issue from the commandline:

dbmcli -s -d <SID> -u control,<pwd>

You should now find UPC file in the paths from step 1.

3. Load the System Tables

Start the Database Manager, goto the option 'Configuration' -> 'Upgrade System Tables'. You'll probably get the error 'wrong sysdba' again here.

After that, I got a popup where I could fill in the dba-user and password and the domain-user and password (normally 'domain').

I'm using Database Manager GUI version 7.6 (103224).

Message was edited by: Roland Mallmann