DB connection only works for some admin user but not for all
Hi,
I have installed an ERP system, Solution Manager and SAP MaxDB on the same host (using as a demo system). That environment was already working but the ERP system is broken for the last two days.
These are the failure:
- In the ERP system, the disp+work.EXE process has the status 'Running but Dialog Queue standstill' and none of the work processes are running. But all Solution Manager work processes are running ok.
- The database connection does NOT work for the ERP admin and Windows user. But the DB connection works for the solution manager admin.
--> Why is the database connection depending on the user?
Host and system details:
- I have installed an ERP system and Solution Manager on the same Windows box
- The host is Amazon EC2 instance running Windows 2008R2 SP1 Server 64 bit (total memory 15 GB and Processing Power 8 ECUs) .
- The ERP system is ERP 6.0 Support Release 3, MaxDB 7.8, Central System.
- The Solution Manager 7.1 Support Release 1, MaxDB 7.8, Central System.
- SAP MaxDB version 7.8.02.26, the ERP and Solution Manager have their own DB.
Installation Properties for the database DB2 which is used by the ERP system:
OK
VERSION = 7.8.02.26
INSTROOT = C:\sapdb\DB2\db
SYSTEM = NO
ISOLATED = YES
XServerState = Running
SSLPortNoOrService = 7205
NIPortNoOrService = 7204
PortNoOrService = 7203
XserverAutostart = yes
DataPath = C:\sapdb\DB2\data
Name = DB2
Installation Properties for the database DB1 which is used by the Solution Manager system:
OK
VERSION = 7.8.02.26
INSTROOT = C:\sapdb\DB1\db
SYSTEM = NO
ISOLATED = YES
XServerState = Running
SSLPortNoOrService = 7202
NIPortNoOrService = 7201
PortNoOrService = 7200
XserverAutostart = yes
DataPath = C:\sapdb\DB1\data
Name = DB1
Testing database connection with Solution Manager admin sm1adm user:
C:\usr\sap\SM1\SYS\profile>r3trans -d
This is r3trans version 6.24 (release 720 - 19.03.13 - 20:13:03 ).
unicode enabled version
sizeof(Selection_t) = 272
R3trans=>sapparam(1c): No Profile used.
R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
r3trans finished (0000).
C:\usr\sap\ER1\SYS\profile>r3trans -d
This is r3trans version 6.24 (release 720 - 19.03.13 - 20:13:03 ).
unicode enabled version
sizeof(Selection_t) = 272
R3trans=>sapparam(1c): No Profile used.
R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
r3trans finished (0000).
Testing database connection with ERP admin user er1adm user:
C:\usr\sap\SM1\SYS\profile>r3trans -d
This is r3trans version 6.23 (release 720 - 15.05.12 - 20:12:03).
unicode enabled version
R3trans=>sapparam(1c): No Profile used.
R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
C:\usr\sap\ER1\SYS\profile>r3trans -d
This is r3trans version 6.23 (release 720 - 15.05.12 - 20:12:03).
unicode enabled version
R3trans=>sapparam(1c): No Profile used.
R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
--> both tests do not complete returning a validation code
Testing database connection with Windows admin user:
C:\usr\sap\SM1\SYS\profile>r3trans -d
This is r3trans version 6.24 (release 720 - 19.03.13 - 20:13:03 ).
unicode enabled version
sizeof(Selection_t) = 272
R3trans=>sapparam(1c): No Profile used.
R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."
r3trans finished (0012).
C:\usr\sap\ER1\SYS\profile>r3trans -d
This is r3trans version 6.24 (release 720 - 19.03.13 - 20:13:03 ).
unicode enabled version
sizeof(Selection_t) = 272
R3trans=>sapparam(1c): No Profile used.
R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."
r3trans finished (0012).
--> return code indicates kernel issue
What is causing the different behavior? Why is the database connection depending on the user?
Many thanks for your help.
Regards,
Andreas