Skip to Content
avatar image
Former Member

MaxDB 7.6.5.09 upgrade / install hangs at inst_reg.

Good day

I have successfully installed MaxDB 7.6.3.15 on Windows Server 2003 SP2.

When I try and upgrade or install 7.6.05 Build 009-123-191-997 it hangs when trying to register the instance and dbmsrv consumes almost 50% of the CPU

continuously.

I have tried istalling as the domain admin and as the local administrator.

Here is the log from the wrk dir:

2008-10-02 12:06:09 0x00000404 INF        216 DBMSrv   DBM Server client connection (established at 2008-10-02 12:06:09): PID 968 on computer sunflower.pha.co.za
2008-10-02 12:06:09 0x00000404 INF        283 DBMSrv   Command 'inst_reg -k "C:\Program Files\sdb\7605" ' is being executed.

If I check the registry the following key exists

HKEY_LOCAL_MACHINE\SOFTWARE\SAP\SAP DBTech\Installations\C:/Program Files/sdb/7605

If I install all packages except the Database Kernel it succeeds.

If I then try and install the Database Kernel I get the following error:

2008-10-02 12:35:54 0x00000c3c INF        283 DBMSrv   Command 'inst_reg -k "C:\Program Files\sdb\7605" ' is being executed.
2008-10-02 12:35:58 0x00000c3c ERR     -24913 DBMSrv   ERR_SERVICEDB: Cannot register service database instance for .M760509
                    0x00000c3c ERR     -24832 DBMSrv   ERR_SHMNOTAVAILABLE: Shared memory not available
                    0x00000c3c ERR     -24686 DBMSrv   ERR_SHMNOCLEANUP: Could not cleanup the DBM server Shared Memory
                    0x00000c3c ERR     -24827 DBMSrv   ERR_SHMALLOCFAILED: ID C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\.M760509.dbm.shm, requested size 81
2008-10-02 12:35:58 0x00000c3c ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'inst_reg' has ended and failed with return code -24913.
                    0x00000c3c ERR     -24913 DBMSrv   ERR_SERVICEDB: Cannot register service database instance for C:\Program Files\sdb\7605
2008-10-02 12:35:58 0x00000c3c INF        226 DBMSrv   DBM Server client disconnected: PID 2912 on computer sunflower.pha.co.za

I have successfully upgraded / installed 7.6.5.09 on other PCs with the same version of Windows.

Regards

Bradley Patchett

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

41 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 28, 2008 at 07:13 AM

    Hello Marc-Philip

    Sunflower and MaxDB are still not friends 😔

    I tried to create a database instance with the DBMGUI create instance wizard. Below are the results.

    -


    Start DBMGUI 7.6.00.37 (148140).

    Use the Create Intsance Wizard to created a database.

    Select Desktop PC / Laptop and accept all the default values.

    Fails with an auto extend error.

    Here is the relevant output from dbmsrv_SUNFLOWER.prt:

    2008-10-28 08:48:53 0x00000ddc INF        216 DBMSrv   DBM Server client connection (established at 2008-10-28 08:48:53): PID 584 on computer sunflower.pha.co.za
    2008-10-28 08:48:53 0x00000ddc INF        283 DBMSrv   Command 'db_create -a ...' is being executed.
    2008-10-28 08:48:54 0x00000ddc INF        419 DBMSrv   Command 'db_create' has ended with return code 0.
    2008-10-28 08:48:54 0x00000ddc INF        226 DBMSrv   DBM Server client disconnected: PID 584 on computer sunflower.pha.co.za
    2008-10-28 08:48:54 0x00000624 INF          4 DBMSrvLo This DBM Server does not switch its log file to file dbm.prt in the run directory.
                        0x00000624 INF         21 DBMSrv   Parameter RUNDIRECTORY not found
    2008-10-28 08:48:54 0x00000624 INF        216 DBMSrv   DBM Server client connection (established at 2008-10-28 08:48:54): PID 584 on computer sunflower.pha.co.za
    2008-10-28 08:48:54 0x00000624 INF        283 DBMSrv   Command 'auto_extend show' is being executed.
    2008-10-28 08:48:54 0x00000624 INF        419 DBMSrv   Command 'auto_extend' has ended with return code 0.
    2008-10-28 08:48:54 0x00000624 INF        283 DBMSrv   Command 'auto_update_statistics show' is being executed.
    2008-10-28 08:48:54 0x00000624 INF        419 DBMSrv   Command 'auto_update_statistics' has ended with return code 0.
    2008-10-28 08:48:55 0x00000624 INF        283 DBMSrv   Command 'param_put SESSION_TIMEOUT "0"' is being executed.
    2008-10-28 08:48:55 0x00000624 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
    2008-10-28 08:48:55 0x00000624 INF        283 DBMSrv   Command 'param_directput _UNICODE "YES"' is being executed.
    2008-10-28 08:48:55 0x00000624 INF        419 DBMSrv   Command 'param_directput' has ended with return code 0.
    2008-10-28 08:48:55 0x00000624 INF        283 DBMSrv   Command 'param_put CACHE_SIZE "2500"' is being executed.
    2008-10-28 08:48:55 0x00000624 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
    2008-10-28 08:48:55 0x00000624 INF        283 DBMSrv   Command 'param_put _SERVERDB_FOR_SAP "NO"' is being executed.
    2008-10-28 08:48:55 0x00000624 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
    2008-10-28 08:48:55 0x00000624 INF        283 DBMSrv   Command 'param_put MAXDATAVOLUMES "64"' is being executed.
    2008-10-28 08:48:55 0x00000624 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
    2008-10-28 08:48:55 0x00000624 INF        283 DBMSrv   Command 'param_put XP_MAXPAGER "3"' is being executed.
    2008-10-28 08:48:55 0x00000624 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
    2008-10-28 08:48:55 0x00000624 INF        283 DBMSrv   Command 'param_put MAXUSERTASKS "10"' is being executed.
    2008-10-28 08:48:55 0x00000624 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
    2008-10-28 08:48:55 0x00000624 INF        283 DBMSrv   Command 'param_checkall EXTENDED' is being executed.
    2008-10-28 08:48:55 0x00000624 INF        419 DBMSrv   Command 'param_checkall' has ended with return code 0.
    2008-10-28 08:48:55 0x00000624 INF        283 DBMSrv   Command 'param_commitsession NOCLOSE' is being executed.
    2008-10-28 08:49:01 0x00000624 INF        419 DBMSrv   Command 'param_commitsession' has ended with return code 0.
    2008-10-28 08:49:01 0x00000624 INF        283 DBMSrv   Command 'param_addvolume 1 DATA "C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB1\data\DISKD0001" F 32768' is being executed.
    2008-10-28 08:49:01 0x00000624 INF        419 DBMSrv   Command 'param_addvolume' has ended with return code 0.
    2008-10-28 08:49:01 0x00000624 INF        283 DBMSrv   Command 'param_addvolume 1 LOG "C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB1\log\DISKL001" F 6400' is being executed.
    2008-10-28 08:49:02 0x00000624 INF        419 DBMSrv   Command 'param_addvolume' has ended with return code 0.
    2008-10-28 08:49:02 0x00000624 INF        283 DBMSrv   Command 'db_admin -f' is being executed.
    2008-10-28 08:49:08 0x00000624 INF        419 DBMSrv   Command 'db_admin' has ended with return code 0.
    2008-10-28 08:49:08 0x00000624 INF        283 DBMSrv   Command 'auto_extend show' is being executed.
    2008-10-28 08:49:08 0x00000624 INF        419 DBMSrv   Command 'auto_extend' has ended with return code 0.
    2008-10-28 08:49:08 0x00000624 INF        283 DBMSrv   Command 'auto_update_statistics show' is being executed.
    2008-10-28 08:49:08 0x00000624 INF        419 DBMSrv   Command 'auto_update_statistics' has ended with return code 0.
    2008-10-28 08:49:08 0x00000624 INF        283 DBMSrv   Command 'auto_extend on 90' is being executed.
    2008-10-28 08:49:09 0x00000624 ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'auto_extend' has ended and failed with return code -24805.
                        0x00000624 ERR     -24805 DBMSrv   ERR_NOAUTOEXTEND: auto extend feature not activated
                        0x00000624 ERR     -24964 DBMSrv   ERR_EXECUTE: Error in program execution
                        0x00000624 ERR     -24853 DBMSrv   ERR_NOSERVERPROCESSRUNNING: Could not start server process (used command: "dbm_execute_serverprocess 2 start -internal "C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\MAXDB1\dbmsilevt.cfg" -l "C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\MAXDB1\dbmevtdisp.prt" -d MAXDB1 -u DBM,*")
                        0x00000624 ERR     -24778 DBMSrv   -4,unknown host name
    2008-10-28 08:52:47 0x00000624 INF        226 DBMSrv   DBM Server client disconnected: PID 584 on computer sunflower.pha.co.za
    

    -


    Try and create a custom instance with the create instance wizard.

    Accept all defaults except auto extend data areas.

    Fails, here is the dbmsrv_SUNFLOWER.prt output:

    2008-10-28 08:56:43 0x00000bd0 INF        216 DBMSrv   DBM Server client connection (established at 2008-10-28 08:56:43): PID 904 on computer sunflower.pha.co.za
    2008-10-28 08:56:43 0x00000bd0 INF        283 DBMSrv   Command 'db_create -a ...' is being executed.
    2008-10-28 08:56:43 0x00000bd0 INF        419 DBMSrv   Command 'db_create' has ended with return code 0.
    2008-10-28 08:56:43 0x00000bd0 INF        226 DBMSrv   DBM Server client disconnected: PID 904 on computer sunflower.pha.co.za
    2008-10-28 08:56:43 0x00000674 INF          4 DBMSrvLo This DBM Server does not switch its log file to file dbm.prt in the run directory.
                        0x00000674 INF         21 DBMSrv   Parameter RUNDIRECTORY not found
    2008-10-28 08:56:43 0x00000674 INF        216 DBMSrv   DBM Server client connection (established at 2008-10-28 08:56:43): PID 904 on computer sunflower.pha.co.za
    2008-10-28 08:56:43 0x00000674 INF        283 DBMSrv   Command 'auto_extend show' is being executed.
    2008-10-28 08:56:43 0x00000674 INF        419 DBMSrv   Command 'auto_extend' has ended with return code 0.
    2008-10-28 08:56:43 0x00000674 INF        283 DBMSrv   Command 'auto_update_statistics show' is being executed.
    2008-10-28 08:56:44 0x00000674 INF        419 DBMSrv   Command 'auto_update_statistics' has ended with return code 0.
    2008-10-28 08:56:44 0x00000674 INF        283 DBMSrv   Command 'param_directput _UNICODE "YES"' is being executed.
    2008-10-28 08:56:44 0x00000674 INF        419 DBMSrv   Command 'param_directput' has ended with return code 0.
    2008-10-28 08:56:44 0x00000674 INF        283 DBMSrv   Command 'param_put CACHE_SIZE "2500"' is being executed.
    2008-10-28 08:56:44 0x00000674 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
    2008-10-28 08:56:44 0x00000674 INF        283 DBMSrv   Command 'param_put MAXDATAVOLUMES "64"' is being executed.
    2008-10-28 08:56:44 0x00000674 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
    2008-10-28 08:56:44 0x00000674 INF        283 DBMSrv   Command 'param_put MAXUSERTASKS "20"' is being executed.
    2008-10-28 08:56:44 0x00000674 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
    2008-10-28 08:56:44 0x00000674 INF        283 DBMSrv   Command 'param_checkall EXTENDED' is being executed.
    2008-10-28 08:56:44 0x00000674 INF        419 DBMSrv   Command 'param_checkall' has ended with return code 0.
    2008-10-28 08:56:44 0x00000674 INF        283 DBMSrv   Command 'param_commitsession NOCLOSE' is being executed.
    2008-10-28 08:56:49 0x00000674 INF        419 DBMSrv   Command 'param_commitsession' has ended with return code 0.
    2008-10-28 08:56:54 0x00000674 INF        283 DBMSrv   Command 'param_addvolume 1 DATA "C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB2\data\DISKD0001" F 131072' is being executed.
    2008-10-28 08:56:54 0x00000674 INF        419 DBMSrv   Command 'param_addvolume' has ended with return code 0.
    2008-10-28 08:56:54 0x00000674 INF        283 DBMSrv   Command 'param_addvolume 1 LOG "C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB2\log\DISKL001" F 6400' is being executed.
    2008-10-28 08:56:55 0x00000674 INF        419 DBMSrv   Command 'param_addvolume' has ended with return code 0.
    2008-10-28 08:57:05 0x00000674 INF        421 DBMSrv   Command 'backup_media_getall' was executed since 2008-10-28 08:57:05.
    2008-10-28 08:57:05 0x00000674 ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'backup_media_getall' has ended and failed with return code -24986.
                        0x00000674 ERR     -24986 DBMSrv   ERR_NOMEDIA: media file not found
    2008-10-28 08:57:05 0x00000674 INF        283 DBMSrv   Command 'backup_media_put "INITIALBACKUP" "C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB2\backup\DATA1" FILE DATA 0 0 NO NO "" NONE' is being executed.
    2008-10-28 08:57:06 0x00000674 INF        419 DBMSrv   Command 'backup_media_put' has ended with return code 0.
    2008-10-28 08:57:06 0x00000674 INF        283 DBMSrv   Command 'backup_media_put "LOGBACKUP" "C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB2\backup\LOG" FILE LOG 0 0 NO NO "" NONE' is being executed.
    2008-10-28 08:57:06 0x00000674 INF        419 DBMSrv   Command 'backup_media_put' has ended with return code 0.
    2008-10-28 08:57:13 0x00000674 INF        283 DBMSrv   Command 'db_admin -f' is being executed.
    2008-10-28 08:57:16 0x00000674 INF        419 DBMSrv   Command 'db_admin' has ended with return code 0.
    2008-10-28 08:57:16 0x00000674 INF        283 DBMSrv   Command 'auto_extend show' is being executed.
    2008-10-28 08:57:16 0x00000674 INF        419 DBMSrv   Command 'auto_extend' has ended with return code 0.
    2008-10-28 08:57:17 0x00000674 INF        283 DBMSrv   Command 'auto_update_statistics show' is being executed.
    2008-10-28 08:57:17 0x00000674 INF        419 DBMSrv   Command 'auto_update_statistics' has ended with return code 0.
    2008-10-28 08:57:17 0x00000674 INF        283 DBMSrv   Command 'db_activate ...' is being executed.
    2008-10-28 08:57:39 0x00000674 INF        419 DBMSrv   Command 'db_activate' has ended with return code 0.
    2008-10-28 08:57:39 0x00000674 INF        283 DBMSrv   Command 'load_systab ...' is being executed.
    2008-10-28 08:57:39 0x00000674 ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'load_systab' has ended and failed with return code -24967.
                        0x00000674 ERR     -24967 DBMSrv   ERR_SYSTEM: system call error
                        0x00000674 ERR     -24778 DBMSrv   2,ENOENT : no such file or directory
                        0x00000674 ERR     -24778 DBMSrv   0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab.py" -R "C:\Program Files\sdb\7605" -d MAXDB2 -u DBADMIN,dbadmin  en ENG" 1>\s1jk..DBM 2>&1
    2008-10-28 08:57:55 0x00000674 INF        226 DBMSrv   DBM Server client disconnected: PID 904 on computer sunflower.pha.co.za
    

    Regards

    Bradley

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Bradley,

      please not that you must not use the dbmsrv.exe that I sent you for other purposes than testing.

      Concerning the installation problem: This is fixed now, your new problems are not related to it. You can monitor the fixing of the installation problem [here|http://maxdb.sap.com/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1159033].

      Concerning the auto_extend problem (your 1st try):

      It seems as if the host name "localhost" is not defined on sunflower. Please check file C:\WINDOWS\system32\drivers\etc\hosts (or equivalent). It must contain this line:

      127.0.0.1       localhost
      

      Please try

      dbmcli -d MAXDB1 -u <user>,<pass> -n localhost
      

      both before and after modifying the hosts file.

      Concerning the load_systab problem (your 2nd try):

      The environment variables TMP resp. TEMP don't seem to be set for the user account that runs the dbmsrv.exe. Please set them and make them point to a directory, where this user accour may read/write/execute.

      If these proposals don't help, please open a new thread as this one is about a hanging installation...

      Regards,

      Marc-Philip

      Edited by: Marc-Philip Werner on Oct 28, 2008 11:58 AM

  • Oct 17, 2008 at 07:43 AM

    Hi Bradley,

    the db_drop problem seems to be related to install problem (i.e., probably something with permissions).

    Just a thought: Do you have some kind of disk encryption software installed? AFAIK, this used to cause similar problems in the past, but we found a workaround which we believed that it worked.

    Regards,

    Ivan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2008 at 02:15 PM

    Hello

    I am unable to install the Database Kernel. It hangs at inst_reg as usual. When I run sdbinst to install the DB Kernel it also installs dbmsrv.exe overwriting any copy I put in place.

    Here is the wrk dir after a failed sdbinst:

    #dir
     Volume in drive C is System
     Volume Serial Number is D819-1472
    
     Directory of C:\Documents and Settings\All Users\Application Data\sdb\data\wrk
    
    2008/10/23  03:37 PM    <DIR>          .
    2008/10/23  03:37 PM    <DIR>          ..
    2008/10/20  03:11 PM             2,544 .M760509.dbm.shi
    2008/10/20  11:56 AM                 0 dbmsrv_SUNFLOWER.err
    2008/10/23  03:32 PM             4,509 dbmsrv_SUNFLOWER.prt
    

    If I copy the new dbmsrv and run (I ran it the first time without escaping the quotes).

    dbmcli inst_reg -k \"C:\Program Files\sdb\7605\"
    

    here is the oupt from dbmsrv_SUNFLOWER.prt

    2008-10-23 15:32:05 0x00000c14 INF        283 DBMSrv   Command 'inst_reg -k "C:\Program Files\sdb\7605" ' is being executed.
    2008-10-23 15:32:09 0x00000c14 ERR     -24913 DBMSrv   ERR_SERVICEDB: Cannot register service database instance for .M760509
                        0x00000c14 ERR     -24832 DBMSrv   ERR_SHMNOTAVAILABLE: Shared memory not available
                        0x00000c14 ERR     -24686 DBMSrv   ERR_SHMNOCLEANUP: Could not cleanup the DBM server Shared Memory
                        0x00000c14 ERR     -24827 DBMSrv   ERR_SHMALLOCFAILED: ID C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\.M760509.dbm.shm, requested size 81
    2008-10-23 15:32:09 0x00000c14 ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'inst_reg' has ended and failed with return code -24913.
                        0x00000c14 ERR     -24913 DBMSrv   ERR_SERVICEDB: Cannot register service database instance for C:\Program Files\sdb\7605
    2008-10-23 15:32:09 0x00000c14 INF        226 DBMSrv   DBM Server client disconnected: PID 3836 on computer sunflower.pha.co.za
    2008-10-23 15:40:39 0x000006dc INF        216 DBMSrv   DBM Server client connection (established at 2008-10-23 15:40:39): PID 1744 on computer sunflower.pha.co.za
    2008-10-23 15:40:39 0x000006dc INF        283 DBMSrv   Command 'inst_reg -k C:\Program Files\sdb\7605 ' is being executed.
    2008-10-23 15:40:39 0x000006dc ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'inst_reg' has ended and failed with return code -24996.
                        0x000006dc ERR     -24996 DBMSrv   ERR_PARAM: wrong parameters
    2008-10-23 15:40:39 0x000006dc INF        226 DBMSrv   DBM Server client disconnected: PID 1744 on computer sunflower.pha.co.za
    2008-10-23 15:41:48 0x00000834 INF        216 DBMSrv   DBM Server client connection (established at 2008-10-23 15:41:48): PID 1460 on computer sunflower.pha.co.za
    2008-10-23 15:41:48 0x00000834 INF        283 DBMSrv   Command 'inst_reg -k "C:\Program Files\sdb\7605" ' is being executed.
    2008-10-23 15:41:53 0x00000834 ERR     -24748 DBMSrv   ERR_FILEOPEN: Error opening file C:\Documents and Settings\All Users\Application Data\sdb\data\config\.M760511.cfg
                        0x00000834 ERR     -24994 DBMSrv   ERR_RTE: Runtime environment error
                        0x00000834 ERR     -24778 DBMSrv   1,wrong file or device name
                        0x00000834 ERR     -24748 DBMSrv   ERR_FILEOPEN: Error opening file C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\.M760511\dbm.cfg
                        0x00000834 ERR     -24994 DBMSrv   ERR_RTE: Runtime environment error
                        0x00000834 ERR     -24778 DBMSrv   1,wrong file or device name
                        0x00000834 ERR     -24748 DBMSrv   ERR_FILEOPEN: Error opening file C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\.M760511\dbm.cfg
                        0x00000834 ERR     -24994 DBMSrv   ERR_RTE: Runtime environment error
                        0x00000834 ERR     -24778 DBMSrv   1,wrong file or device name
    2008-10-23 15:41:54 0x00000834 INF        419 DBMSrv   Command 'inst_reg' has ended with return code 0.
    2008-10-23 15:41:54 0x00000834 INF        226 DBMSrv   DBM Server client disconnected: PID 1460 on computer sunflower.pha.co.za
    

    and here is the wrk dir:

    #dir
     Volume in drive C is System
     Volume Serial Number is D819-1472
    
     Directory of C:\Documents and Settings\All Users\Application Data\sdb\data\wrk
    
    2008/10/23  03:41 PM    <DIR>          .
    2008/10/23  03:41 PM    <DIR>          ..
    2008/10/20  03:11 PM             2,544 .M760509.dbm.shi
    2008/10/23  03:41 PM    <DIR>          .M760511
    2008/10/23  03:41 PM             2,544 .M760511.dbm.shi
    2008/10/23  03:41 PM               258 .M760511.dbm.shm
    2008/10/20  11:56 AM                 0 dbmsrv_SUNFLOWER.err
    2008/10/23  03:41 PM             6,715 dbmsrv_SUNFLOWER.prt
    

    Regards

    Bradley

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Bradley,

      please check if the user that you install as may create a file in

      C:\Documents and Settings\All Users\Application Data\sdb\data\wrk

      Just try to create one e.g. with the Windows Explorer. Does it work?

      Regards,

      Marc-Philip

      Edited by: Marc-Philip Werner on Oct 23, 2008 6:18 PM

  • avatar image
    Former Member
    Oct 06, 2008 at 06:16 PM

    Hello Bradley,

    As you saw that "Could not cleanup the DBM server Shared Memory" for service

    database instance reported, when installation tried to register the Database Kernel

    Installation.

    • Do you have on the server

    C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\.M760509.dbm.shm ?

    • Was the database kernel software of the instance '7605' installed before?

    • Please update with the output of the following commands:

    dbmcli -d .M760509 -u service,service dbm_shm_info

    dbmcli inst_enum

    dbmcli db_enum

    xinstinfo 7605

    dbmcli db_enum -s

    sdbregview -l

    sdbverify

    • You wrote:

    "I have successfully installed MaxDB 7.6.3.15 on Windows Server 2003 SP2.

    When I try and upgrade or install 7.6.05 Build 009-123-191-997 "

    What is exactly your project?

    Do you need to upgrade the database instance of the version 7.6.3.15 to the version 7.6.05 Build 009?

    Or do you need to install the second database instance of the version 7.6.05 Build 009?

    What MAXDB tool/installation guide did you use for the MAXDB "upgrade or install"?

    • Please review the MAXDB documentation at the library:

    http://maxdb.sap.com/doc/7_6/default.htm -> Installation -> Installation Manual

    < Installing/Upgrading on Microsoft Windows -> Installing/Upgrading on Microsoft Windows -> Directories >

    &&

    http://maxdb.sap.com/doc/7_6/default.htm -> Glossary -> Shared Memory

    Thank you and best regards, Natalia Khlopina

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 07, 2008 at 08:33 AM

    Hello

    When I run SDBINST it runs as far as

    . . .
    extracting: -rw-r--r--       388096 2008-08-15 20:11:57 symbols/systemrc.pdb
    extracting: -rw-r--r--       846848 2008-08-15 22:11:43 symbols/TableDefC.pdb
    extracting: -rw-r--r--       887808 2008-08-15 22:01:47 symbols/tracesort.pdb
    checking unpacked archive... ok
    

    I then have to kill the dbmsrv process as it hangs and consumes about 50% of the CPU.

    error occured while executing "C:\Program Files\sdb\programs\pgm\dbmcli.exe" -R
    "C:\Program Files\sdb\7605" inst_reg -k \"C:\Program Files\sdb\7605\"
    "C:\Program Files\sdb\programs\pgm\dbmcli.exe" -R "C:\Program Files\sdb\7605" in
    st_reg -k \"C:\Program Files\sdb\7605\": DBM-Api error ( -4'Connection broken')
    installation exited abnormally  at Tu, Oct 07, 2008 at 08:54:37
    

    If I run SDBSETUP it hangs at the end of the Database Kernel progress bar.

    After that I have no .M760509.dbm.shm. Contents of wrk directory are:

     Directory of C:\Documents and Settings\All Users\Application Data\sdb\data\wrk
    
    2008/10/07  08:56 AM    <DIR>          .
    2008/10/07  08:56 AM    <DIR>          ..
    2008/10/07  08:32 AM             2,544 .M760509.dbm.shi
    2008/10/07  08:32 AM                 0 dbmsrv_SUNFLOWER.err
    2008/10/07  08:32 AM               514 dbmsrv_SUNFLOWER.prt
    2008/10/07  08:56 AM            62,828 MaxDBSoftware_install-07.10.2008-08.56.log
    

    No database kernel instance of 7605 has been successsfully installed on this server. I originally had 7.5.00.38 installed. Successfully upgraded to 7.6.3.15. Not successfull with 7.6.05.09 upgraded.

    I have tried to uninstall with

    dbmcli int_unreg <dbroot>

    and

    sdbuninst -all

    and used the SDBSETUP Remove MaxDB components.

    I have also manually deleted the C:\Documents and Settings\All Users\Application Data\sdb and C:\Program Files\sdb directories and deleted the HKEY_LOCAL_MACHINE\SOFTWARE\SAP and HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SAP DBTech* registry keys.

    After uninstalling / deleting all installed software I can reinstall 7.5.008 and upgrade to 7.6.3.15. But I cannot upgrade to 7.6.05.09.

    If I again uninstall / delete all software I can install 7.6.3.15, but I cannot upgrade to 7.6.05.09.

    If I uninstall / delete all software and just try and install 7.6.05.09 it also fails.

    In all cases the upgrade / install hangs at the same place, inst_reg.

    Here is the output from the commands:

    C:\Program Files\sdb\programs\pgm
    #dbmcli -d .M760509 -u service,service dbm_shm_info
    Error! Connection failed to node (local) for database .M760509:
    -24700,ERR_DBMSRV_NOSTART: Could not start DBM server.
    -24832,ERR_SHMNOTAVAILABLE: Shared memory not available
    -24686,ERR_SHMNOCLEANUP: Could not cleanup the DBM server Shared Memory
    -24827,ERR_SHMALLOCFAILED: ID C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\.M760509.dbm.shm, requested size 81
    
    C:\Program Files\sdb\programs\pgm
    #dbmcli inst_enum
    OK
    7.6.05.09    C:\Program Files\sdb\7605
    
    C:\Program Files\sdb\programs\pgm
    #dbmcli db_enum
    OK
    
    C:\Program Files\sdb\programs\bin
    #xinstinfo 7605
    IndepData           : C:\Documents and Settings\All Users\Application Data\sdb\data
    IndepPrograms       : C:\Program Files\sdb\programs
    Installationpath of serverdb <7605> not found!
    
    #dbmcli db_enum -s
    OK
    .M760509        C:\Program Files\sdb\7605               7.6.05.09       fast 
    offline
    .M760509        C:\Program Files\sdb\7605               7.6.05.09       quick
    offline
    .M760509        C:\Program Files\sdb\7605               7.6.05.09       slow
    offline
    .M760509        C:\Program Files\sdb\7605               7.6.05.09       test
    offline
    
    C:\Program Files\sdb\programs\bin
    #sdbregview -l
    DB Analyzer         c:/program files/sdb/programs    7.6.05.09    32 bit    valid
    Server Utilities    c:/program files/sdb/programs    7.6.05.09    32 bit    valid
    Database Kernel     c:/program files/sdb/7605        7.6.05.09    32 bit    invalid
    Base                c:/program files/sdb/programs    7.6.05.09    32 bit    valid
    SQLDBC              c:/program files/sdb/programs    7.6.05.09    32 bit    valid
    JDBC                c:/program files/sdb/programs    7.6.05.06              valid
    
    
    C:\Program Files\sdb\programs\bin
    #sdbverify
    
    
    DB Analyzer 7.6.05.09 32 bit in c:/program files/sdb/programs
    -------------------------------------------------------------
    
    check files... ok
    
    check dependencies... ok
    
    package data is consistent
    
    
    Server Utilities 7.6.05.09 32 bit in c:/program files/sdb/programs
    ------------------------------------------------------------------
    
    check files... ok
    
    check dependencies... ok
    
    package data is consistent
    
    
    Database Kernel in c:/program files/sdb/7605 is invalid
    
    
    Base 7.6.05.09 32 bit in c:/program files/sdb/programs
    ------------------------------------------------------
    
    check files... ok
    
    check dependencies... ok
    
    check rte registration of package... ok
    
    package data is consistent
    
    
    SQLDBC 7.6.05.09 32 bit in c:/program files/sdb/programs
    --------------------------------------------------------
    
    check files... ok
    
    check dependencies... ok
    
    package data is consistent
    
    
    JDBC 7.6.05.06 in c:/program files/sdb/programs
    -----------------------------------------------
    
    check files... ok
    
    check dependencies... ok
    
    package data is consistent
    
    
    VERIFICATION SUMMARY:
    *********************
    
    INVALID PACKAGES:                   1
    VALID PACKAGES:                     5
    INCONSISTENT PACKAGES:              0
    
    TOTAL FILES:                        103
    MISSED FILES:                       0
    MODIFIED FILES:                     0
    FILES WITH MODIFIED PERMISSIONS:    0
    

    My project is to install one instance of 7.6.05.09. The server is used for DR. After installing the software I will recover a full backup of the production server and thereafter recover the log files. The production server has 7.6.05.09 installed.

    The tools I used for the upgrade / install:

    Initially I executed maxdb-all-win-32bit.exe (which I had renamed to maxdb-all-win-32bit-7_6_05_09.exe) when I tried to upgrade the 7.6.3.15 DB instance. SInce then I have unpacked the files and used SDBSETUP and SDBINST when trying to install the software. Ihave also used SDBSETUP and SDBUPD when trying to upgrade from a 7.6.3.15 instance.

    Regards

    Bradley

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Bradley,

      -> Are you SAP customer?

      -> You run a lot of activities, which are NOT recommended.

          • "I have also manually deleted the C:\Documents and Settings\All Users\Application Data\sdb and

          C:\Program Files\sdb directories and deleted the HKEY_LOCAL_MACHINE\SOFTWARE\SAP

          and HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SAP DBTech* registry keys."

          Please don't delete the database software and registry manually next time.

          If you have problems to uninstall the database software using the SDBUNINST or SDBSETUP

          Database tools, please report the problem

              • "I have tried to uninstall with

              dbmcli int_unreg <dbroot> u2026 "

              Do you mean 'inst_unreg'. It's using for deleting the Registration of a Version of the Database Software.

              And it should NOT run before 'sdbuninst -all', if you would like to uninstall the database software on the server.

              -> You still have the service DBM server Shared Memory file .M760509.dbm.shi.

              Could you rename the file "C:\Documents and Settings\All Users\Application Data\sdb\data\wrk

              \.M760509.dbm.shi" & run the Database Kernel package software install:

              SDBINST -package "Database Kernel"

              < Please run first 'SDBINST -l' to be sure that you will run the installation of the "Database Kernel"

              version 7.6.05.09. >

              Update with your results.

              Thank you and best regards, Natalia Khlopina

          • avatar image
            Former Member
            Oct 08, 2008 at 04:20 PM

            Hi Bradley,

            maybe it's a good idea to try starting from a clear setting. Please do the following:

            1.

            Stop all DBM Server processes on the machine (dbmsrv.exe in Windows Task Manager).

            2.

            Remove all files *.dbm.shi and *.dbm.shm from <indep_data>/wrk folder (should be C:\Documents and Settings\All Users\Application Data\sdb\data\wrk on your machine).

            3.

            Retry dbmcli -d .M760509 -u service,service dbm_shm_info.

            4.

            If this still does not work, please provide files <indep_data>/wrk/dbmsrv_SUNFLOWER.err, <indep_data>/wrk/dbmsrv_SUNFLOWER.prt and <indep_data>/wrk/.M760509/dbm.prt.

            Regards,

            Marc-Philip

            Add comment
            10|10000 characters needed characters exceeded

          • avatar image
            Former Member
            Oct 09, 2008 at 10:49 AM

            Hi Bradley,

            please perform my steps 1 through 4 again in the very situation that you have right now.

            please provide file <indep_data>/wrk/appldiag.

            Regards,

            Marc-Philip

            Add comment
            10|10000 characters needed characters exceeded

          • avatar image
            Former Member
            Oct 10, 2008 at 03:44 PM

            Hi Bradley,

            could you please check the folders that the environment variables TMP, TEMP and USERPROFILE point to for files named "*.dbm.sh?"? If there are any, please check, if they are marked read-only.

            Regards,

            Marc-Philip

            Add comment
            10|10000 characters needed characters exceeded

          • avatar image
            Former Member
            Oct 15, 2008 at 11:18 AM

            Bradley,

            I must admit that I'm quite astonished...

            Just to make sure: In your original posting you stated that you have successfully 7.6.3.15. Could you please try that again for me? You can install it without removing the 7.6.5.09 installation.

            Another idea: Is there some virus protection active on your machine? Could you please check it's logs? Anything interesting there?

            Regards,

            Marc-Philip

            Add comment
            10|10000 characters needed characters exceeded

          • avatar image
            Former Member
            Oct 15, 2008 at 01:59 PM

            Bradley,

            okay, so there must be something on Sunflower and Holly that makes them different from the other machines... Is the OS version the same on Sunflower, Holly and the machines that you could install successfully on? Is the virus protection identical on Sunflower, Holly and the others?

            Regards,

            Marc-Philip

            Add comment
            10|10000 characters needed characters exceeded