cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

MaxDb 7.6.05.09 load_systab fails in DBMGUI when creating a db instance

Go to solution
Former Member

on ‎10-29-2008 1:40 PM

0 Kudos

Hello

I have loaded MaxDB 7.6.05.09 and DBMGUI 7.6.00.37 (148140) on Windows Server 2003 SP2.

When I try a created a database instance with the DBMGUI I get the following error:


2008-10-29 09:21:54 0x00000d5c ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'load_systab' has ended and failed with return code -24967.
                    0x00000d5c ERR     -24967 DBMSrv   ERR_SYSTEM: system call error
                    0x00000d5c ERR     -24778 DBMSrv   2,ENOENT : no such file or directory
                    0x00000d5c 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 P01 -u DBA,*  en ENG" 1>\s3as..DBM 2>&1

However I can load_systab from the command line:


#dbmcli -d P01 -u dbm,* -n localhost load_systab
OK
0,OK: everything works fine
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*"
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

I have made sure that the %TMP% and %TEMP% variables point to directories that have read / write / execute permissions as suggested in .


C:\Documents and Settings\admin
#echo %TMP%
C:\DOCUME~1\admin\LOCALS~1\Temp\1

C:\Documents and Settings\admin
#echo %TEMP%
C:\DOCUME~1\admin\LOCALS~1\Temp\1

C:\Documents and Settings\admin
#echo echo testing 1 2 3 > %TMP%\test.bat

C:\Documents and Settings\admin
#%TMP%\test

C:\Documents and Settings\admin
#echo testing 1 2 3
testing 1 2 3

C:\Documents and Settings\admin
#type %TMP%\test.bat
echo testing 1 2 3

C:\Documents and Settings\admin
#del %TMP%\test.bat

C:\Documents and Settings\admin
#

Any further suggestions would be appreciated.

Regards

Bradley

Edited by: Bradley Patchett on Oct 29, 2008 2:43 PM

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎11-10-2008 1:00 PM
0 Kudos

Hello

I went into Terminal Services / Server Settings and uninstalled Application Server and Terminal Server.

Reboot.

load_systab now executes successfully.


C:\Documents and Settings\Administrator
#dbmcli -d MAXDB5 -u dbm,* load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000001
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\
Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Program Fil
es\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server\90\Too
ls\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\WINDOWS
TEMP=C:\WINDOWS\TEMP
TMP=C:\WINDOWS\TEMP
USERPROFILE=C:\Documents and Settings\Administrator
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\WINDOWS
***** end environment dump
OK
0,OK: everything works fine
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d MAXDB5 -u DBADMIN,*"
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

This also fixes the problem as I can create a database instance using the DBMGUI and accepting all the defaults which include auto_extend.

This may also relate to as SUNFLOWER and HOLLY were the two servers that gave problems both had Terminal Server installed.

Thank-you all for the time and effort spent in solving these problems.

Regards

Bradley

Show replies
Show replies
Former Member
‎11-10-2008 4:53 PM
0 Kudos

> 

> I went into Terminal Services / Server Settings and uninstalled Application Server and Terminal Server.
>

Hi Bradley,

Terminal Server... that's the kind of information that I had hoped you would give us when I asked if there's anything special about the Windows installation on SUNFLOWER...

Anyway, we found the problem. If you're interested, you can monitor the progress in fixing the issue [here|http://maxdb.sap.com/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1159683].

Thank you too for working with us so well (except that little detail :-).

Regards,

Marc-Philip

Answers (19)

Answers (19)

Former Member
‎11-10-2008 9:50 AM
0 Kudos

Hello

I asked Google about SHGetFolderPath and SystemRoot and came across the following:

From [http://www.microsoft.com/msj/1099/terminal/terminal.aspx]

Since many applications already share files in %systemroot%, Terminal Services gets around this problem by virtualizing the windows directory. The system creates a new windows directory in the user's %USERPROFILE% directory that is defined as %homedrive%\%homepath%. The %homepath% is defined differently on Windows NT 4.0 and Windows 2000. On Windows NT 4.0 it is defined as %systemroot%\profiles\%username%, while on Windows 2000 it is defined as "document and settings\%username%". Definitely stay away from hardcoding these paths and stick with the Windows directory returned by GetWindowsDirectory. On Windows 2000, you should use SHGetFolderPath with CSIDL_WINDOWS to obtain the Windows Directory. For the developers who insist on getting the real Windows directory, a new API called GetSystemWindowsDirectory has been created. This will return you the real Windows directory. 
In addition, the actual Windows directory is available by switching the system from execute mode to install mode by using the change.exe utility included with the system. The command to change the system to install mode is "change user /install". These modes were introduced to allow legacy applications to properly install in a Terminal Services environment. Not only does it preserve registry settings, but it also forces GetWindowsDirectory to return the true Windows directory since you may have files that are shared by all users, such as DLLs.

I don't know much about Windows system calls and how this relates to Windows 2003 but I tried (logged on as SUNFLOWER\Administrator):


C:\Documents and Settings\Administrator
#change user /install
User session is ready to install applications.

and then


C:\Documents and Settings\Administrator
#dbmcli -d MAXDB5 -u dbm,* load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000001
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\
Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Program Fil
es\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server\90\Too
ls\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\WINDOWS
TEMP=C:\WINDOWS\TEMP
TMP=C:\WINDOWS\TEMP
USERPROFILE=C:\Documents and Settings\Administrator
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\WINDOWS
***** end environment dump
OK
0,OK: everything works fine
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d MAXDB5 -u DBADMIN,*"
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

Regards

Bradley

Show replies
Show replies
Former Member
‎11-07-2008 5:08 PM
0 Kudos

Hello Bradley,

I'm very sorry, but I don't know how this issue can be solved.

The used code looks like this:

char buffer[MAX_PATH];

SHGetFolderPath( 0, CSIDL_WINDOWS, 0, SHGFP_TYPE_DEFAULT, buffer );

According to MSDN this should return 'Systemroot' in the buffer. For some reason it returns something else.

I don't know how this call get the path. I used a registry and file tracing tool to figure out whats going on inside the function, but I could not see any registry or file access. Initially the system root is set by the ntloader. You can check you boot configuration using the tool bootcfg on the command line. The 'Path' of you current partition should point to the current system root. Anyway, I think the boot configuration must be ok because the system would not boot with a broken boot configuration.

Of cause we are interested in the root cause of this issue. This code is used since May 2007 and you are the first one who reported it. But perhaps other will have the same problem...

May by you should contact Microsoft with this issue.

I'm very sorry about this.

Have a nice weekend,

Christoph

Show replies
Show replies
Former Member
‎11-07-2008 1:53 PM
0 Kudos

Hello

Here are the values returned by reg.exe for the registry keys. (Logged on as SUNFLOWER\Administrator).

 
C:\Documents and Settings\Administrator
#reg QUERY "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explore
r\User Shell Folders" /s

ERROR: More data is available.

There are keys under the User Shell Folders folder but reg.exe displays the above error message.


C:\Documents and Settings\Administrator
#reg QUERY "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explore
r\Shell Folders"

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Shell Fold
ers
    Common AppData    REG_SZ    C:\Documents and Settings\All Users\Application
Data
    Common Programs    REG_SZ    C:\Documents and Settings\All Users\Start Menu\
Programs
    Common Documents    REG_SZ    C:\Documents and Settings\All Users\Documents
    Common Desktop    REG_SZ    C:\Documents and Settings\All Users\Desktop
    Common Start Menu    REG_SZ    C:\Documents and Settings\All Users\Start Men
u
    CommonPictures    REG_SZ
    CommonMusic    REG_SZ    C:\Documents and Settings\All Users\Documents\My Mu
sic
    CommonVideo    REG_SZ
    Common Administrative Tools    REG_SZ    C:\Documents and Settings\All Users
\Start Menu\Programs\Administrative Tools
    Common Startup    REG_SZ    C:\Documents and Settings\All Users\Start Menu\P
rograms\Startup
    Common Templates    REG_SZ    C:\Documents and Settings\All Users\Templates
    Common Favorites    REG_SZ    C:\Documents and Settings\All Users\Favorites




C:\Documents and Settings\Administrator
#reg QUERY "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explore
r\User Shell Folders" /s
C:\Documents and Settings\Administrator
#reg QUERY "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer
\User Shell Folders" /s

ERROR: More data is available.

There are keys under the User Shell Folders folder but reg.exe displays the above error message. I am downloading a hotfix for reg.exe from Microsoft and will try again with the new reg.exe.


C:\Documents and Settings\Administrator
#reg QUERY "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer
\Shell Folders" /s

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folde
rs
    AppData    REG_SZ    C:\Documents and Settings\Administrator\Application Dat
a
    Cookies    REG_SZ    C:\Documents and Settings\Administrator\Cookies
    Desktop    REG_SZ    C:\Documents and Settings\Administrator\Desktop
    Favorites    REG_SZ    C:\Documents and Settings\Administrator\Favorites
    NetHood    REG_SZ    C:\Documents and Settings\Administrator\NetHood
    Personal    REG_SZ    C:\Documents and Settings\Administrator\My Documents
    PrintHood    REG_SZ    C:\Documents and Settings\Administrator\PrintHood
    Recent    REG_SZ    C:\Documents and Settings\Administrator\Recent
    SendTo    REG_SZ    C:\Documents and Settings\Administrator\SendTo
    Start Menu    REG_SZ    C:\Documents and Settings\Administrator\Start Menu
    Templates    REG_SZ    C:\Documents and Settings\Administrator\Templates
    Programs    REG_SZ    C:\Documents and Settings\Administrator\Start Menu\Pro
grams
    Startup    REG_SZ    C:\Documents and Settings\Administrator\Start Menu\Prog
rams\Startup
    Local Settings    REG_SZ    C:\Documents and Settings\Administrator\Local Se
ttings
    Local AppData    REG_SZ    C:\Documents and Settings\Administrator\Local Set
tings\Application Data
    Cache    REG_SZ    C:\Documents and Settings\Administrator\Local Settings\Te
mporary Internet Files
    History    REG_SZ    C:\Documents and Settings\Administrator\Local Settings\
History
    My Pictures    REG_SZ
    Fonts    REG_SZ    C:\WINDOWS\Fonts
    My Music    REG_SZ
    My Video    REG_SZ
    CD Burning    REG_SZ    C:\Documents and Settings\Administrator\Local Settin
gs\Application Data\Microsoft\CD Burning
    Administrative Tools    REG_SZ    C:\Documents and Settings\Administrator\St
art Menu\Programs\Administrative Tools

The SystemRoot variable does not appear in the Control Panel\ System \ Advanced \ Environment Variables panel but I can echo it from a cmd prompt.


C:\Documents and Settings\Administrator
#echo %SYSTEMROOT%
C:\WINDOWS

The only SystemRoot Key I can find in the registry is:


C:\Documents and Settings\Administrator
#reg QUERY "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion" /v
SystemRoot

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion
    SystemRoot    REG_SZ    C:\WINDOWS

Regards

Bradley

Show replies
Show replies
Former Member
‎11-07-2008 11:13 AM
0 Kudos

Hello Bradley,

I want to answer this time for Marc-Philip.

For some reason the Windows function SHGetFolderPath( ) returns a strange value on your system. This function finds it's values usually in

HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folder

or

HKLM\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders

or

HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folder

or

HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folder

Anyway, there is (usually) no value for the Systemroot.

As far as I know the Systemroot is found in

HKLM\Software\Microsoft\Windows\CurrentVersion\Systemroot

or

HKLM\Software\Microsoft\WindowsNT\CurrentVersion\Systemroot

Could you please check these registry value?

Regards,

Christoph Bautz

Show replies
Show replies
Former Member
‎11-07-2008 7:36 AM
0 Kudos

Hello

I checked 3 other servers that have MaxDB 7.6.05.09 running and all their SYSTEMROOT variables have a value of C:\Windows.

SUNFLOWER is a plain Windows install. I was mistaken about the domain controller, it is not a domain controller nor is it part of a cluster. The only difference I can think of is that it has a tape drive and BackupExec installed. None of the other servers running MaxDB have a tape drive. I uninstalled BackupExec during the original problem and it made no difference with that problem or this one.

Here is the same output wih the new test dbmsrv.exe as requested in the 2:02 PM post (3:02 PM here in Durban, South Africa (GMT + 2)).

-

Copy and install new test dbmsrv.exe.


#dir "c:\Program Files\sdb\7605\pgm\dbmsrv.exe"
 Volume in drive C is System
 Volume Serial Number is D819-1472

 Directory of c:\Program Files\sdb\7605\pgm

2008/11/06  05:06 PM         2,985,984 dbmsrv.exe
               1 File(s)      2,985,984 bytes
               0 Dir(s)  46,713,477,120 bytes free

-

As SWEIDAN\admin

dbmcli -d MAXDB5 -u dbm,* load_systab


C:\Documents and Settings\admin
#dbmcli -d MAXDB5 -u dbm,* load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000000
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\admin\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\admin\WINDOWS\system32;C:\Documents and Setting
s\admin\WINDOWS;C:\Documents and Settings\admin\WINDOWS\System32\Wbem;C:\Program
 Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Prog
ram Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server
\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\admin\WINDOWS
TEMP=C:\Documents and Settings\admin\WINDOWS\TEMP
TMP=C:\Documents and Settings\admin\WINDOWS\TEMP
USERPROFILE=C:\Documents and Settings\admin
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\admin\WINDOWS
***** end environment dump
ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d MAXDB5 -u DBADMIN,DBADMIN  en ENG" 1>C:
\DOCUME~1\admin\WINDOWS\TEMP\s4fc..DBM 2>&1

dbmcli -d MAXDB5 -u DBADMIN,dbadmin load_systab


C:\Documents and Settings\admin
#dbmcli -d MAXDB5 -u DBADMIN,dbadmin load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000001
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\admin\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\admin\WINDOWS\system32;C:\Documents and Setting
s\admin\WINDOWS;C:\Documents and Settings\admin\WINDOWS\System32\Wbem;C:\Program
 Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Prog
ram Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server
\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\admin\WINDOWS
TEMP=C:\Documents and Settings\admin\WINDOWS\TEMP
TMP=C:\Documents and Settings\admin\WINDOWS\TEMP
USERPROFILE=C:\Documents and Settings\admin
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\admin\WINDOWS
***** end environment dump
ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d MAXDB5 -u DBADMIN,DBADMIN  en ENG" 1>C:
\DOCUME~1\admin\WINDOWS\TEMP\s4go..DBM 2>&1

-

As SUNFLOWER\Administrator

dbmcli -d MAXDB5 -u dbm,* load_systab


C:\Documents and Settings\Administrator
#dbmcli -d MAXDB5 -u dbm,* load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\Administrator\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\Administrator\WINDOWS\system32;C:\Documents and
 Settings\Administrator\WINDOWS;C:\Documents and Settings\Administrator\WINDOWS\
System32\Wbem;C:\Program Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program
 Files\Vim\vim71;C:\Program Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Fi
les\Microsoft SQL Server\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\Administrator\WINDOWS
TEMP=C:\Documents and Settings\Administrator\WINDOWS\TEMP
TMP=C:\Documents and Settings\Administrator\WINDOWS\TEMP
USERPROFILE=C:\Documents and Settings\Administrator
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\Administrator\WINDOWS
***** end environment dump
ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d MAXDB5 -u DBADMIN,DBADMIN  en ENG" 1>\s
5ls..DBM 2>&1

dbmcli -d MAXDB5 -u DBADMIN,dbadmin load_systab


dbmcli -d MAXDB5 -u DBADMIN,dbadmin load_systab
C:\Documents and Settings\Administrator
#dbmcli -d MAXDB5 -u DBADMIN,dbadmin load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000001
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\Administrator\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\Administrator\WINDOWS\system32;C:\Documents and
 Settings\Administrator\WINDOWS;C:\Documents and Settings\Administrator\WINDOWS\
System32\Wbem;C:\Program Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program
 Files\Vim\vim71;C:\Program Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Fi
les\Microsoft SQL Server\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\Administrator\WINDOWS
TEMP=C:\Documents and Settings\Administrator\WINDOWS\TEMP
TMP=C:\Documents and Settings\Administrator\WINDOWS\TEMP
USERPROFILE=C:\Documents and Settings\Administrator
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\Administrator\WINDOWS
***** end environment dump
ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d MAXDB5 -u DBADMIN,DBADMIN  en ENG" 1>\s
rs..DBM 2>&1

-

Here is a list of cmd.exe found on SUNFLOWER.


C:\Documents and Settings\admin
#dir /s c:\cmd.exe e:\cmd.exe f:\cmd.exe g:\cmd.exe h:\cmd.exe i:\cmd.exe j:\cmd
.exe
 Volume in drive C is System
 Volume Serial Number is D819-1472

 Directory of c:\WINDOWS\$NtServicePackUninstall$

2005/03/24  05:57 PM           388,096 cmd.exe
               1 File(s)        388,096 bytes

 Directory of c:\WINDOWS\ServicePackFiles\i386

2007/02/17  02:31 AM           389,120 cmd.exe
               1 File(s)        389,120 bytes

 Directory of c:\WINDOWS\system32

2007/02/17  02:31 AM           389,120 cmd.exe
               1 File(s)        389,120 bytes

     Total Files Listed:
               3 File(s)      1,166,336 bytes
               0 Dir(s)  46,714,971,648 bytes free

 Volume in drive E is ProgramFiles
 Volume Serial Number is E40C-2887
File Not Found

 Volume in drive F is File Storage
 Volume Serial Number is D43F-E968

 Volume in drive G is Database Logs
 Volume Serial Number is 8C58-A678

 Volume in drive H is Database
 Volume Serial Number is 788D-EC36

 Volume in drive I is JHB Home
 Volume Serial Number is A0AB-555B

 Volume in drive J is JHB Storage
 Volume Serial Number is A8B1-CBFC

Regards

Bradley

Show replies
Show replies
Former Member
‎11-06-2008 2:37 PM
0 Kudos

Hello

Neither file exists.


C:\Documents and Settings\admin
#dir C:\Documents and Settings\admin\WINDOWS\system32\cmd.exe
The system cannot find the path specified.


C:\Documents and Settings\admin
#dir C:\Documents and Settings\Administrator\WINDOWS\system32\cmd.exe
The system cannot find the path specified.

Regards

Bradley

Edited by: Bradley Patchett on Nov 6, 2008 3:37 PM

Show replies
Show replies
Former Member
‎11-06-2008 4:31 PM
0 Kudos

Bradley,

now we know that something is strange with your environment variable %SYSTEMROOT%. It refers to the directory where Windows is installed. Many other environment variables depend on it.

The value of %SYSTEMROOT% for SUNFLOWER\Administrator and SWEIDAN\admin is C:\Windows. This is corrent in the sense that this directory exists and the Windows installation on SUNFLOWER is in fact in in this directory.

What is going on on SUNFLOWER? Is it a plain Windows installation or is there anything special? I believe you once wrote it's a domain controller. Anything else that comes to your mind? Is it part of a cluster? Did you make experiments with more than one Windows installation in the same machine (with different %SYSTEMROOT% values?

[Here|https://sapmats-de.sap-ag.de/download/download.cgi?id=TRPHUUQZYOLOJMZTOPZ6S45LV7MDMBCGMKA33440YH9AXEVE3F]'s another dbmsrv.exe. Please put it in place and perform the 4 calls again that I asked for today at 2:02 PM (my time, same in you place?). Please provide the output.

Regards,

Marc-Philip

Former Member
‎11-06-2008 1:35 PM
0 Kudos

Hello

As SWEIDAN\admin

dbmcli -d MAXDB5 -u dbm,* load_systab


C:\Documents and Settings\admin
#dbmcli -d MAXDB5 -u dbm,* load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\admin\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\admin\WINDOWS\system32;C:\Documents and Setting
s\admin\WINDOWS;C:\Documents and Settings\admin\WINDOWS\System32\Wbem;C:\Program
 Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Prog
ram Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server
\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\admin\WINDOWS
TEMP=C:\DOCUME~1\admin\LOCALS~1\Temp
TMP=C:\DOCUME~1\admin\LOCALS~1\Temp
USERPROFILE=C:\Documents and Settings\admin
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\admin\WINDOWS
***** end environment dump
ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d MAXDB5 -u DBADMIN,DBADMIN  en ENG" 1>C:
\DOCUME~1\admin\LOCALS~1\Temp\s37o..DBM 2>&1

dbmcli -d MAXDB5 -u DBADMIN,dbadmin load_systab


C:\Documents and Settings\admin
#dbmcli -d MAXDB5 -u DBADMIN,dbadmin load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000001
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\admin\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\admin\WINDOWS\system32;C:\Documents and Setting
s\admin\WINDOWS;C:\Documents and Settings\admin\WINDOWS\System32\Wbem;C:\Program
 Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Prog
ram Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server
\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\admin\WINDOWS
TEMP=C:\DOCUME~1\admin\LOCALS~1\Temp
TMP=C:\DOCUME~1\admin\LOCALS~1\Temp
USERPROFILE=C:\Documents and Settings\admin
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\admin\WINDOWS
***** end environment dump
ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d MAXDB5 -u DBADMIN,DBADMIN  en ENG" 1>C:
\DOCUME~1\admin\LOCALS~1\Temp\s3hc..DBM 2>&1

-

As SUNFLOWER\Administrator

dbmcli -d MAXDB5 -u dbm,* load_systab


C:\Documents and Settings\Administrator
#dbmcli -d MAXDB5 -u dbm,* load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000002
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\Administrator\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\Administrator\WINDOWS\system32;C:\Documents and
 Settings\Administrator\WINDOWS;C:\Documents and Settings\Administrator\WINDOWS\
System32\Wbem;C:\Program Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program
 Files\Vim\vim71;C:\Program Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Fi
les\Microsoft SQL Server\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\Administrator\WINDOWS
TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
USERPROFILE=C:\Documents and Settings\Administrator
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\Administrator\WINDOWS
***** end environment dump
ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d MAXDB5 -u DBADMIN,DBADMIN  en ENG" 1>C:
\DOCUME~1\ADMINI~1\LOCALS~1\Temp\s30k..DBM 2>&1

dbmcli -d MAXDB5 -u DBADMIN,dbadmin load_systab


C:\Documents and Settings\Administrator
#dbmcli -d MAXDB5 -u DBADMIN,dbadmin load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000001
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\Administrator\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\Administrator\WINDOWS\system32;C:\Documents and
 Settings\Administrator\WINDOWS;C:\Documents and Settings\Administrator\WINDOWS\
System32\Wbem;C:\Program Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program
 Files\Vim\vim71;C:\Program Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Fi
les\Microsoft SQL Server\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\Administrator\WINDOWS
TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
USERPROFILE=C:\Documents and Settings\Administrator
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\Administrator\WINDOWS
***** end environment dump
ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d MAXDB5 -u DBADMIN,DBADMIN  en ENG" 1>C:
\DOCUME~1\ADMINI~1\LOCALS~1\Temp\s1d0..DBM 2>&1

Regards

Bradley

Show replies
Show replies
Former Member
‎11-06-2008 2:31 PM
0 Kudos

Bradley,

do the following two files exist?

C:\Documents and Settings\admin\WINDOWS\system32\cmd.exe

C:\Documents and Settings\Administrator\WINDOWS\system32\cmd.exe

Regards,

Marc-Philip

Former Member
‎11-06-2008 12:52 PM
0 Kudos

Hello

I restored a different database backup on 2008/11/04 at 02:25:04 PM. The previous test was run on 2008/11/05. Apart from that I have not done anything.

Here is the output from the DBMGUI create instance, logged on as SUNFLOWER\Administrator. Connect to <Local> host. Custom, use all defaults except auto_extend. Use the same software installation (C:\Program Files\sdb\7605) with the test dbmsrv.exe as database P01.


2008-11-06 14:33:15 0x00001184 INF        226 DBMSrv   DBM Server client disconnected: PID 4836 on computer sunflower.pha.co.za
2008-11-06 14:34:32 0x00001700 INF        216 DBMSrv   DBM Server client connection (established at 2008-11-06 14:34:32): PID 4636 on computer sunflower.pha.co.za
2008-11-06 14:34:32 0x00001700 INF        283 DBMSrv   Command 'db_create -a ...' is being executed.
2008-11-06 14:34:33 0x00001700 INF        419 DBMSrv   Command 'db_create' has ended with return code 0.
2008-11-06 14:34:33 0x00001700 INF        226 DBMSrv   DBM Server client disconnected: PID 4636 on computer sunflower.pha.co.za
2008-11-06 14:34:33 0x00001640 INF          4 DBMSrvLo This DBM Server does not switch its log file to file dbm.prt in the run directory.
                    0x00001640 INF         21 DBMSrv   Parameter RUNDIRECTORY not found
2008-11-06 14:34:33 0x00001640 INF        216 DBMSrv   DBM Server client connection (established at 2008-11-06 14:34:33): PID 4636 on computer sunflower.pha.co.za
2008-11-06 14:34:33 0x00001640 INF        283 DBMSrv   Command 'auto_extend show' is being executed.
2008-11-06 14:34:33 0x00001640 INF        419 DBMSrv   Command 'auto_extend' has ended with return code 0.
2008-11-06 14:34:33 0x00001640 INF        283 DBMSrv   Command 'auto_update_statistics show' is being executed.
2008-11-06 14:34:33 0x00001640 INF        419 DBMSrv   Command 'auto_update_statistics' has ended with return code 0.
2008-11-06 14:34:33 0x00001640 INF        283 DBMSrv   Command 'param_directput _UNICODE "YES"' is being executed.
2008-11-06 14:34:34 0x00001640 INF        419 DBMSrv   Command 'param_directput' has ended with return code 0.
2008-11-06 14:34:34 0x00001640 INF        283 DBMSrv   Command 'param_put CACHE_SIZE "2500"' is being executed.
2008-11-06 14:34:34 0x00001640 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
2008-11-06 14:34:34 0x00001640 INF        283 DBMSrv   Command 'param_put MAXDATAVOLUMES "64"' is being executed.
2008-11-06 14:34:34 0x00001640 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
2008-11-06 14:34:34 0x00001640 INF        283 DBMSrv   Command 'param_put MAXUSERTASKS "20"' is being executed.
2008-11-06 14:34:34 0x00001640 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
2008-11-06 14:34:34 0x00001640 INF        283 DBMSrv   Command 'param_checkall EXTENDED' is being executed.
2008-11-06 14:34:34 0x00001640 INF        419 DBMSrv   Command 'param_checkall' has ended with return code 0.
2008-11-06 14:34:34 0x00001640 INF        283 DBMSrv   Command 'param_commitsession NOCLOSE' is being executed.
2008-11-06 14:34:39 0x00001640 INF        419 DBMSrv   Command 'param_commitsession' has ended with return code 0.
2008-11-06 14:34:42 0x00001640 INF        283 DBMSrv   Command 'param_addvolume 1 DATA "C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB5\data\DISKD0001" F 131072' is being executed.
2008-11-06 14:34:42 0x00001640 INF        419 DBMSrv   Command 'param_addvolume' has ended with return code 0.
2008-11-06 14:34:42 0x00001640 INF        283 DBMSrv   Command 'param_addvolume 1 LOG "C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB5\log\DISKL001" F 6400' is being executed.
2008-11-06 14:34:43 0x00001640 INF        419 DBMSrv   Command 'param_addvolume' has ended with return code 0.
2008-11-06 14:34:56 0x00001640 INF        421 DBMSrv   Command 'backup_media_getall' was executed since 2008-11-06 14:34:56.
2008-11-06 14:34:56 0x00001640 ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'backup_media_getall' has ended and failed with return code -24986.
                    0x00001640 ERR     -24986 DBMSrv   ERR_NOMEDIA: media file not found
2008-11-06 14:34:56 0x00001640 INF        283 DBMSrv   Command 'backup_media_put "INITIALBACKUP" "C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB5\backup\DATA1" FILE DATA 0 0 NO NO "" NONE' is being executed.
2008-11-06 14:34:56 0x00001640 INF        419 DBMSrv   Command 'backup_media_put' has ended with return code 0.
2008-11-06 14:34:56 0x00001640 INF        283 DBMSrv   Command 'backup_media_put "LOGBACKUP" "C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB5\backup\LOG" FILE LOG 0 0 NO NO "" NONE' is being executed.
2008-11-06 14:34:56 0x00001640 INF        419 DBMSrv   Command 'backup_media_put' has ended with return code 0.
2008-11-06 14:35:01 0x00001640 INF        283 DBMSrv   Command 'db_admin -f' is being executed.
2008-11-06 14:35:04 0x00001640 INF        419 DBMSrv   Command 'db_admin' has ended with return code 0.
2008-11-06 14:35:04 0x00001640 INF        283 DBMSrv   Command 'auto_extend show' is being executed.
2008-11-06 14:35:04 0x00001640 INF        419 DBMSrv   Command 'auto_extend' has ended with return code 0.
2008-11-06 14:35:04 0x00001640 INF        283 DBMSrv   Command 'auto_update_statistics show' is being executed.
2008-11-06 14:35:04 0x00001640 INF        419 DBMSrv   Command 'auto_update_statistics' has ended with return code 0.
2008-11-06 14:35:04 0x00001640 INF        283 DBMSrv   Command 'db_activate ...' is being executed.
2008-11-06 14:35:26 0x00001640 INF        419 DBMSrv   Command 'db_activate' has ended with return code 0.
2008-11-06 14:35:26 0x00001640 INF        283 DBMSrv   Command 'load_systab ...' is being executed.
2008-11-06 14:35:26 0x00001640 ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'load_systab' has ended and failed with return code -24967.
                    0x00001640 ERR     -24967 DBMSrv   ERR_SYSTEM: system call error
                    0x00001640 ERR     -24778 DBMSrv   2,ENOENT : no such file or directory
                    0x00001640 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 MAXDB5 -u DBADMIN,dbadmin  en ENG" 1>C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\s5i0..DBM 2>&1

The file C:\DOCUME1\ADMINI1\LOCALS~1\Temp\s5i0..DBM does not exist but the directory C:\DOCUME1\ADMINI1\LOCALS~1\Temp does.

Regards

Bradley

Show replies
Show replies
Former Member
‎11-06-2008 1:02 PM
0 Kudos

Bradley,

perfect. Now please perform the following both as SUNFLOWER\Administrator and SWEIDAN\admin:


dbmcli -d MAXDB5 -u dbm,* load_systab



dbmcli -d MAXDB5 -u DBADMIN,dbadmin load_systab

That makes 4 calls altogether. What is the output?

Regards,

Marc-Philip

Former Member
‎11-06-2008 11:00 AM
0 Kudos

Hello

Downlaod and install the latest test dbmsrv.exe


C:\Program Files\sdb\7605\pgm
#dir dbmsrv.exe
 Volume in drive C is System
 Volume Serial Number is D819-1472

 Directory of C:\Program Files\sdb\7605\pgm

2008/11/06  10:56 AM         2,985,984 dbmsrv.exe
               1 File(s)      2,985,984 bytes
               0 Dir(s)  48,837,722,624 bytes free

As SWEIDAN\admin:


C:\Documents and Settings\admin
#dbmcli -d P01 -u dbm,* load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000000
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\admin\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\admin\WINDOWS\system32;C:\Documents and Setting
s\admin\WINDOWS;C:\Documents and Settings\admin\WINDOWS\System32\Wbem;C:\Program
 Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Prog
ram Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server
\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\admin\WINDOWS
TEMP=C:\DOCUME~1\admin\LOCALS~1\Temp
TMP=C:\DOCUME~1\admin\LOCALS~1\Temp
USERPROFILE=C:\Documents and Settings\admin
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\admin\WINDOWS
***** end environment dump
ERR
-24909,ERR_DBAUNKNOWN: SYSDBA unknown

As SUNFLOWER\Administrator:


C:\Documents and Settings\Administrator
#dbmcli -d P01 -u dbm,* load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\Administrator\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\Administrator\WINDOWS\system32;C:\Documents and
 Settings\Administrator\WINDOWS;C:\Documents and Settings\Administrator\WINDOWS\
System32\Wbem;C:\Program Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program
 Files\Vim\vim71;C:\Program Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Fi
les\Microsoft SQL Server\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\Administrator\WINDOWS
TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
USERPROFILE=C:\Documents and Settings\Administrator
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\Administrator\WINDOWS
***** end environment dump
ERR
-24909,ERR_DBAUNKNOWN: SYSDBA unknown

Regards

Bradley

Show replies
Show replies
Former Member
‎11-06-2008 11:53 AM
0 Kudos

Bradley,

that error is very unexpected. What have you done to your database (resp. installation) between the previous tests and today's? The SYSDBA shouild be known. Could you just try to create a new database from your DBMGUI (using local communication of course; create in on host "<Local>")?

Regards,

Marc-Philip

Former Member
‎11-05-2008 6:16 AM
0 Kudos

Hello

As requested with the latest test dbmsrv.exe installed.

-

As SWEIDAN\admin:


C:\Documents and Settings\admin
#dir C:\DOCUME~1\admin\WINDOWS\TEMP
 Volume in drive C is System
 Volume Serial Number is D819-1472

 Directory of C:\DOCUME~1\admin\WINDOWS\TEMP

2008/11/04  02:25 PM    <DIR>          .
2008/11/04  02:25 PM    <DIR>          ..
               0 File(s)              0 bytes
               2 Dir(s)  49,062,927,360 bytes free

C:\Documents and Settings\admin
#"C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab
.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG 1>C:\DOCUME~1\admi
n\WINDOWS\TEMP\test2..DBM 2>&1

C:\Documents and Settings\admin
#dir C:\DOCUME~1\admin\WINDOWS\TEMP
 Volume in drive C is System
 Volume Serial Number is D819-1472

 Directory of C:\DOCUME~1\admin\WINDOWS\TEMP

2008/11/05  08:08 AM    <DIR>          .
2008/11/05  08:08 AM    <DIR>          ..
2008/11/05  08:08 AM             1,045 test2..DBM
               1 File(s)          1,045 bytes
               2 Dir(s)  49,061,743,616 bytes free

C:\Documents and Settings\admin
#type C:\DOCUME~1\admin\WINDOWS\TEMP\test2..DBM
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

-

As SUNFLOWER\Administartor


C:\Documents and Settings\Administrator
#dir C:\DOCUME~1\admin\WINDOWS\TEMP
 Volume in drive C is System
 Volume Serial Number is D819-1472

 Directory of C:\DOCUME~1\admin\WINDOWS\TEMP

2008/11/05  08:13 AM    <DIR>          .
2008/11/05  08:13 AM    <DIR>          ..
               0 File(s)              0 bytes
               2 Dir(s)  49,061,646,848 bytes free

C:\Documents and Settings\Administrator
#"C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab
.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG 1>C:\DOCUME~1\admi
n\WINDOWS\TEMP\test2..DBM 2>&1

C:\Documents and Settings\Administrator
#dir C:\DOCUME~1\admin\WINDOWS\TEMP
 Volume in drive C is System
 Volume Serial Number is D819-1472

 Directory of C:\DOCUME~1\admin\WINDOWS\TEMP

2008/11/05  08:14 AM    <DIR>          .
2008/11/05  08:14 AM    <DIR>          ..
2008/11/05  08:14 AM             1,045 test2..DBM
               1 File(s)          1,045 bytes
               2 Dir(s)  49,060,464,128 bytes free

C:\Documents and Settings\Administrator
#type C:\DOCUME~1\admin\WINDOWS\TEMP\test2..DBM
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

Regards

Bradley

Edited by: Bradley Patchett on Nov 5, 2008 7:18 AM

Show replies
Show replies
Former Member
‎11-04-2008 2:14 PM
0 Kudos

Hello

Here's the output with the new test dbmsrv.exe installed.

-

As SWEIDAN\admin

With no node specified:


C:\Documents and Settings\admin
#dbmcli -d P01 -u dbm,* load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000000
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\admin\Application Data
ClusterLog=C:\WINDOWS\Cluster\cluster.log
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=SUNFLOWER
ComSpec=C:\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\admin
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
LOGONSERVER=\\DAFFODIL
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\
Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Program Fil
es\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server\90\Too
ls\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
ProgramFiles=C:\Program Files
PROMPT=$M$P$_#
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\admin\LOCALS~1\Temp
TMP=C:\DOCUME~1\admin\LOCALS~1\Temp
USERDNSDOMAIN=PHA.CO.ZA
USERDOMAIN=SWEIDAN
USERNAME=admin
USERPROFILE=C:\Documents and Settings\admin
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\WINDOWS
***** end environment dump
OK
0,OK: everything works fine
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*"
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

With node localhost:


C:\Documents and Settings\admin
#dbmcli -d P01 -u dbm,*-n localhost load_systab
OK
0,OK: everything works fine
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*"
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

-

As SUNFLOWER\Administrator

With no node specified:


C:\Documents and Settings\Administrator
#dbmcli -d P01 -u dbm,* load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000000
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\Administrator\Application Data
ClusterLog=C:\WINDOWS\Cluster\cluster.log
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=SUNFLOWER
ComSpec=C:\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\Administrator
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
LOGONSERVER=\\SUNFLOWER
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\
Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Program Fil
es\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server\90\Too
ls\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
ProgramFiles=C:\Program Files
PROMPT=$M$P$_#
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
USERDOMAIN=SUNFLOWER
USERNAME=Administrator
USERPROFILE=C:\Documents and Settings\Administrator
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\WINDOWS
***** end environment dump
OK
0,OK: everything works fine
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*"
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

With node localhost:


C:\Documents and Settings\Administrator
#dbmcli -d P01 -u dbm,* -n localhost load_systab
OK
0,OK: everything works fine
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*"
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

-

Regards

Bradley

Show replies
Show replies
Former Member
‎11-04-2008 4:02 PM
0 Kudos

Bradley,

I had a typo in something I had asked you to execute (double qoutes behind "en ENG"). Please try again both as SUNFLOWER\Administrator and SWEIDAN\admin:


"C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,DBA  en ENG 1>C:\DOCUME~1\admin\WINDOWS\TEMP\test2..DBM 2>&1

Please post the output. Please check if C:\DOCUME1\admin\WINDOWS\TEMP and/or C:\DOCUME1\admin\WINDOWS\TEMP\test2..DBM exist. If C:\DOCUME~1\admin\WINDOWS\TEMP\test2..DBM exists, please post the content.

Regards,

Marc-Philip

Former Member
‎11-06-2008 8:58 AM
0 Kudos

Bradley,

[here|https://https://sapmats-de.sap-ag.de/download/download.cgi?id=1QM1OT8IYKOJ18KDPIQD54O03C6E6HRCGTUGFFXKUEX9GWP0QZ]'s another dbmsrv.exe. Please download it and put it in place. Please try both as SUNFLOWER\Administrator and SWEIDAN\admin:


dbmcli -d P01 -u dbm,* load_systab

What is the output?

Regards,

Marc-Philip

Edited by: Marc-Philip Werner on Nov 6, 2008 10:58 AM

I replaced the dbmsrv executable. There was something wrong with it!

Former Member
‎11-04-2008 1:24 PM
0 Kudos

Hello

I will download the new test dbmsrv.exe and let you know the results. In the meantime here is the out from the current test dbmsrv.exe for


"C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG" 1>C:\DOCUME~1\admin\WINDOWS\TEMP\test1..DBM 2>&1

As SWEIDAN\admin


C:\Documents and Settings\admin
#"C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab
.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG" 1>C:\DOCUME~1\adm
in\WINDOWS\TEMP\test1..DBM 2>&1
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

As SUNFLOWER\Administrator


C:\Documents and Settings\Administrator
#"C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab
.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,* en ENG" 1>C:\DOCUME~1\admi
n\WINDOWS\TEMP\test1..DBM 2>&1
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

Regards

Bradley

Show replies
Show replies
Former Member
‎11-04-2008 7:27 AM
0 Kudos

Hello

The values of TMP and TEMP for SWEIDAN/admin


#set T
TEMP=C:\DOCUME~1\admin\LOCALS~1\Temp
TMP=C:\DOCUME~1\admin\LOCALS~1\Temp

It is set in the environment variables as:


%USERPROFILE%\Local Settings\Temp

The value of TMP / TEMP for System is:


C:\WINDOWS\TEMP

which is set in the environment variable as:


%SystemRoot%\TEMP

Both directories exists.

SWEIDAN is the domain name.

Yes, SWEIDAN\admin is an administrator on Sunflower.

I have tried loggin on as SUNFLOWER\Administrator but the results are the same. The TMP /TEMP directories exist. load_systab fails if -n localhost is not specified on the command line.

I notice that the TMP / TEMP variable values reported by set and dbmsrv.exe are not the same:


C:\Documents and Settings\admin
#set T
TEMP=C:\DOCUME~1\admin\LOCALS~1\Temp
TMP=C:\DOCUME~1\admin\LOCALS~1\Temp

C:\Documents and Settings\admin
#dbmcli -d P01 -u dbm,* load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000002
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\admin\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\admin\WINDOWS\system32;C:\Documents and Setting
s\admin\WINDOWS;C:\Documents and Settings\admin\WINDOWS\System32\Wbem;C:\Program
 Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Prog
ram Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server
\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\admin\WINDOWS
TEMP=C:\Documents and Settings\admin\WINDOWS\TEMP
TMP=C:\Documents and Settings\admin\WINDOWS\TEMP
USERPROFILE=C:\Documents and Settings\admin
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\admin\WINDOWS
***** end environment dump
ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG" 1>C:\DOCUME~1\a
dmin\WINDOWS\TEMP\s494..DBM 2>&1

Both tmp directories exists:


C:\Documents and Settings\admin
#dir "C:\Documents and Settings\admin\WINDOWS\TEMP"
 Volume in drive C is System
 Volume Serial Number is D819-1472

 Directory of C:\Documents and Settings\admin\WINDOWS\TEMP

2008/10/31  03:39 PM    <DIR>          .
2008/10/31  03:39 PM    <DIR>          ..
               0 File(s)              0 bytes

#dir %TMP%
 Volume in drive C is System
 Volume Serial Number is D819-1472

 Directory of C:\DOCUME~1\admin\LOCALS~1\Temp

2008/11/04  08:49 AM    <DIR>          .
2008/11/04  08:49 AM    <DIR>          ..

. . .

Regards

Bradley

Show replies
Show replies
Former Member
‎11-04-2008 10:51 AM
0 Kudos

Bradley,

I'm close to giving up, because I'm not exactly earning money for SAP when I help you...

A workaround for you would be to register P01 as a remote database in your DBMGUI (with host localhost).

What is the output of this (replace asterisk by password first):


"C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG" 1>C:\DOCUME~1\admin\WINDOWS\TEMP\test1..DBM 2>&1

Please try it as SWEIDAN\admin and as SUNFLOWER\Administrator.

[Here's|https://sapmats-de.sap-ag.de/download/download.cgi?id=26FR606YSDFXCNAON5O8U1O10G2BJXEPLF0G5HZZ3UGSTGAMIN] another dbmsrv.exe. After that tests above, could you please put this one in place and try the following both as SWEIDAN\admin and as SUNFLOWER\Administrator:


dbmcli -d P01 -u dbm,* load_systab
dbmcli -d P01 -u dbm,* -n localhost load_systab

What is the output?

As the other dbmsrv.exe files, this one's also just for testing, no production.

Regards,

Marc-Philip

Edited by: Marc-Philip Werner on Nov 4, 2008 11:58 AM

Edited by: Marc-Philip Werner on Nov 4, 2008 12:02 PM

Edited by: Marc-Philip Werner on Nov 4, 2008 12:08 PM

Former Member
‎11-03-2008 2:38 PM
0 Kudos

Hello

Yes, you are correct, #dbmcli -d P01 -u dbm,* -n localhost runs as NT AUTHORITY\SYSTEM.

#dbmcli -d P01 -u dbm,* runs as SWEIDAN\admin which is the screen user.

The only user environment variables set for SWEIDAN\admin are TMP and TEMP.

Regards

Bradley

Show replies
Show replies
Former Member
‎11-03-2008 3:03 PM
0 Kudos

Bradley,

What are the values of TMP and TEMP for SWEIDAN\admin?

Do these directories exist?

What is SWEIDAN? Aren't we on SUNFLOWER?

Is SWEIDAN\admin an administrator on SUNFLOWER?

Regards,

Marc-Philip

Former Member
‎11-03-2008 7:03 AM
0 Kudos

Hello

I don't know if this has any bearing on the matter but I also tried:

node sunflower

 
C:\Documents and Settings\admin
#dbmcli -d P01 -u dbm,* -n sunflower load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000002
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\admin\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\admin\WINDOWS\system32;C:\Documents and Setting
s\admin\WINDOWS;C:\Documents and Settings\admin\WINDOWS\System32\Wbem;C:\Program
 Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Prog
ram Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server
\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\admin\WINDOWS
TEMP=C:\Documents and Settings\admin\WINDOWS\TEMP
TMP=C:\Documents and Settings\admin\WINDOWS\TEMP
USERPROFILE=C:\Documents and Settings\admin
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\admin\WINDOWS
***** end environment dump
ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG" 1>C:\DOCUME~1\a
dmin\WINDOWS\TEMP\s5uk..DBM 2>&1

and node sunflower.pha.co.za


C:\Documents and Settings\admin
#dbmcli -d P01 -u dbm,* -n sunflower.pha.co.za load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000001
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\admin\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\admin\WINDOWS\system32;C:\Documents and Setting
s\admin\WINDOWS;C:\Documents and Settings\admin\WINDOWS\System32\Wbem;C:\Program
 Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Prog
ram Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server
\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\admin\WINDOWS
TEMP=C:\Documents and Settings\admin\WINDOWS\TEMP
TMP=C:\Documents and Settings\admin\WINDOWS\TEMP
USERPROFILE=C:\Documents and Settings\admin
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\admin\WINDOWS
***** end environment dump
ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG" 1>C:\DOCUME~1\a
dmin\WINDOWS\TEMP\s5ik..DBM 2>&1

I can ping and resolve both node names with nslookup successfully.

Kind regards

Bradley

Show replies
Show replies
Former Member
‎11-03-2008 10:20 AM
0 Kudos

Bradley,

only


#dbmcli -d P01 -u dbm,* -n localhost load_systab

makes MaxDB use remote communication. When using this the dbmsrv.exe runs as SYSTEM . With other values for the -n option, is runs as your screen user accout.

You might want to check this in task manager. This is easier when you use the DBM server in session mode:


#dbmcli -d P01 -u dbm,* -n localhost
#dbmcli on localhost : P01>load_systab

resp.


#dbmcli -d P01 -u dbm,*
#dbmcli on P01>load_systab

You can find out xou dbmsrv process with the command dbm_getpid. Check in task manager after starting the session with the first of the two commands.

The environment for the DBM Server must differ depending on running it as SYSTEM or as your screen user. Comparing the set of environment variables did not help me so far...

Regards,

Marc-Philip

Former Member
‎10-31-2008 1:33 PM
0 Kudos

Hello

If it helps I ran from a cmd prompt:


#"C:\Program Files\sdb\test\bin\x_python" "C:\Program Files\sdb\test\env\lsystab
.py" -R "C:\Program Files\sdb\test" -d MAXDB2 -u DBADMIN,dbadmin  en ENG" 1>C:\D
OCUME~1\admin\WINDOWS\TEMP\s5ig..DBM 2>&1

And here is the output


Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

Kind regards

Bradley

Show replies
Show replies
Former Member
‎10-31-2008 12:11 PM
0 Kudos

Hello

As suggested in

I tried:

Make sure System TMP / TEMP exists.


#dir "C:\Documents and Settings\admin\WINDOWS\TEMP
 Volume in drive C is System
 Volume Serial Number is D819-1472

 Directory of C:\Documents and Settings\admin\WINDOWS\TEMP

2008/10/31  01:53 PM    <DIR>          .
2008/10/31  01:53 PM    <DIR>          ..
               0 File(s)              0 bytes
               2 Dir(s)  51,901,693,952 bytes free

load_systab for P01 from the DBMGUI for P01.


ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,DBA  en ENG" 1>C:\DOCUME~1\admin\WINDOWS\TEMP\s3rg.1.DBM 2>&1

load_sytab with dbmcli (no node specified)


#dbmcli -d P01 -u dbm,* load_systab
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000000
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\admin\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\admin\WINDOWS\system32;C:\Documents and Setting
s\admin\WINDOWS;C:\Documents and Settings\admin\WINDOWS\System32\Wbem;C:\Program
 Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Prog
ram Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server
\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\admin\WINDOWS
TEMP=C:\Documents and Settings\admin\WINDOWS\TEMP
TMP=C:\Documents and Settings\admin\WINDOWS\TEMP
USERPROFILE=C:\Documents and Settings\admin
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\admin\WINDOWS
***** end environment dump
ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,DBA  en ENG" 1>C:\DOCUME~1\a
dmin\WINDOWS\TEMP\s4bo..DBM 2>&1

load_sytab with dbmcli, node localhost


C:\Documents and Settings\admin
#dbmcli -d P01 -u dbm,* -n localhost load_systab
OK
0,OK: everything works fine
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsyst
ab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*"
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

Create new db instance with DBMGUI.

Custom, accept all defaults except auto_extend.

Output from dbmsrv_SUNFLOWER.prt:


2008-10-31 14:03:41 0x00001624 INF        283 DBMSrv   Command 'db_create -a ...' is being executed.
2008-10-31 14:03:41 0x00001624 INF        419 DBMSrv   Command 'db_create' has ended with return code 0.
2008-10-31 14:03:41 0x00001624 INF        226 DBMSrv   DBM Server client disconnected: PID 984 on computer sunflower.pha.co.za
2008-10-31 14:03:41 0x00001650 INF          4 DBMSrvLo This DBM Server does not switch its log file to file dbm.prt in the run directory.
                    0x00001650 INF         21 DBMSrv   Parameter RUNDIRECTORY not found
2008-10-31 14:03:42 0x00001650 INF        216 DBMSrv   DBM Server client connection (established at 2008-10-31 14:03:41): PID 984 on computer sunflower.pha.co.za
2008-10-31 14:03:42 0x00001650 INF        283 DBMSrv   Command 'auto_extend show' is being executed.
2008-10-31 14:03:42 0x00001650 INF        419 DBMSrv   Command 'auto_extend' has ended with return code 0.
2008-10-31 14:03:42 0x00001650 INF        283 DBMSrv   Command 'auto_update_statistics show' is being executed.
2008-10-31 14:03:42 0x00001650 INF        419 DBMSrv   Command 'auto_update_statistics' has ended with return code 0.
2008-10-31 14:03:42 0x00001650 INF        283 DBMSrv   Command 'param_directput _UNICODE "YES"' is being executed.
2008-10-31 14:03:42 0x00001650 INF        419 DBMSrv   Command 'param_directput' has ended with return code 0.
2008-10-31 14:03:42 0x00001650 INF        283 DBMSrv   Command 'param_put CACHE_SIZE "2500"' is being executed.
2008-10-31 14:03:42 0x00001650 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
2008-10-31 14:03:43 0x00001650 INF        283 DBMSrv   Command 'param_put MAXDATAVOLUMES "64"' is being executed.
2008-10-31 14:03:43 0x00001650 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
2008-10-31 14:03:43 0x00001650 INF        283 DBMSrv   Command 'param_put MAXUSERTASKS "20"' is being executed.
2008-10-31 14:03:43 0x00001650 INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
2008-10-31 14:03:43 0x00001650 INF        283 DBMSrv   Command 'param_checkall EXTENDED' is being executed.
2008-10-31 14:03:43 0x00001650 INF        419 DBMSrv   Command 'param_checkall' has ended with return code 0.
2008-10-31 14:03:43 0x00001650 INF        283 DBMSrv   Command 'param_commitsession NOCLOSE' is being executed.
2008-10-31 14:03:48 0x00001650 INF        419 DBMSrv   Command 'param_commitsession' has ended with return code 0.
2008-10-31 14:03:50 0x00001650 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-31 14:03:51 0x00001650 INF        419 DBMSrv   Command 'param_addvolume' has ended with return code 0.
2008-10-31 14:03:51 0x00001650 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-31 14:03:52 0x00001650 INF        419 DBMSrv   Command 'param_addvolume' has ended with return code 0.
2008-10-31 14:04:07 0x00001650 INF        421 DBMSrv   Command 'backup_media_getall' was executed since 2008-10-31 14:04:07.
2008-10-31 14:04:07 0x00001650 ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'backup_media_getall' has ended and failed with return code -24986.
                    0x00001650 ERR     -24986 DBMSrv   ERR_NOMEDIA: media file not found
2008-10-31 14:04:07 0x00001650 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-31 14:04:07 0x00001650 INF        419 DBMSrv   Command 'backup_media_put' has ended with return code 0.
2008-10-31 14:04:07 0x00001650 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-31 14:04:07 0x00001650 INF        419 DBMSrv   Command 'backup_media_put' has ended with return code 0.
2008-10-31 14:04:12 0x00001650 INF        283 DBMSrv   Command 'db_admin -f' is being executed.
2008-10-31 14:04:16 0x00001650 INF        419 DBMSrv   Command 'db_admin' has ended with return code 0.
2008-10-31 14:04:16 0x00001650 INF        283 DBMSrv   Command 'auto_extend show' is being executed.
2008-10-31 14:04:16 0x00001650 INF        419 DBMSrv   Command 'auto_extend' has ended with return code 0.
2008-10-31 14:04:16 0x00001650 INF        283 DBMSrv   Command 'auto_update_statistics show' is being executed.
2008-10-31 14:04:16 0x00001650 INF        419 DBMSrv   Command 'auto_update_statistics' has ended with return code 0.
2008-10-31 14:04:16 0x00001650 INF        283 DBMSrv   Command 'db_activate ...' is being executed.
2008-10-31 14:04:38 0x00001650 INF        419 DBMSrv   Command 'db_activate' has ended with return code 0.
2008-10-31 14:04:38 0x00001650 INF        283 DBMSrv   Command 'load_systab ...' is being executed.
2008-10-31 14:04:38 0x00001650 ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'load_systab' has ended and failed with return code -24967.
                    0x00001650 ERR     -24967 DBMSrv   ERR_SYSTEM: system call error
                    0x00001650 ERR     -24778 DBMSrv   2,ENOENT : no such file or directory
                    0x00001650 ERR     -24778 DBMSrv   0,""C:\Program Files\sdb\test\bin\x_python" "C:\Program Files\sdb\test\env\lsystab.py" -R "C:\Program Files\sdb\test" -d MAXDB2 -u DBADMIN,dbadmin  en ENG" 1>C:\DOCUME~1\admin\WINDOWS\TEMP\s5ig..DBM 2>&1

Kind regards

Bradley

Show replies
Show replies
Former Member
‎10-29-2008 2:33 PM
0 Kudos

Hello

As requested.


#echo %COMSPEC%
C:\WINDOWS\system32\cmd.exe



#dbmcli -d P01 -u dbm,dbm load_systab
ERR
-24967,ERR_SYSTEM: system call error
2,ENOENT : no such file or directory
0,""C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG" 1>\s5e0..DBM 2>&1



C:\Documents and Settings\admin
#"C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG 1>\pyout1.txt 2>&1

C:\Documents and Settings\admin
#type \pyout1.txt
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================



C:\Documents and Settings\admin
#"C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG 1>%TMP%\pyout2.txt 2>&1

C:\Documents and Settings\admin
#type %TMP%\pyout2.txt
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================




C:\Documents and Settings\admin
#"C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG 1>C:\DOCUME~1\admin\LOCALS~1\Temp\1\pyout3.txt 2>&1

C:\Documents and Settings\admin
#type C:\DOCUME~1\admin\LOCALS~1\Temp\1\pyout3.txt
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for WebAgent
Installing tables for Repository (WebDAV)
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
Installing tables for DBAnalyzer
==================================
Installation successfully finished
==================================

Regards

Bradley

Edited by: Bradley Patchett on Oct 30, 2008 9:41 AM

Show replies
Show replies
Former Member
‎10-29-2008 1:57 PM
0 Kudos

Bradley,

long time no see

Suppose you logged on to Windows as user X when you started DBMGUI.

Please try


#echo %COMSPEC%

from the command line as the same user X. What is the output?

Please try


#dbmcli -d P01 -u dbm,* load_systab

from the command line as the same user X. What is the output?

Please try


"C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG 1>\pyout1.txt 2>&1

from the command line as the same user X. What is the output?

Please try


"C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG 1>%TMP%\pyout2.txt 2>&1

from the command line as the same user X. What is the output?

Please try


"C:\Program Files\sdb\7605\bin\x_python" "C:\Program Files\sdb\7605\env\lsystab.py" -R "C:\Program Files\sdb\7605" -d P01 -u DBA,*  en ENG 1>C:\DOCUME~1\admin\LOCALS~1\Temp\1\pyout3.txt 2>&1

from the command line as the same user X. What is the output?

Regards,

Marc-Philip

Edited by: Marc-Philip Werner on Oct 29, 2008 2:57 PM

Edited by: Marc-Philip Werner on Oct 29, 2008 2:58 PM

Edited by: Marc-Philip Werner on Oct 29, 2008 3:02 PM

Edited by: Marc-Philip Werner on Oct 29, 2008 3:16 PM

Show replies
Show replies
Ask a Question