on 05-08-2013 1:02 AM
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:
--> Why is the database connection depending on the user?
Host and system details:
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
Seems like you have problems with your environmental variables.
Check that dbms_type is set correctly and that the required paths are in place.
You can review the env variables area of the installation guide.
Regards, Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Juan,
many thanks for help!
I am not a SAP admin so that I do not know the required value for dbms_type.
I have copied the env. variables from both users. I cannot see any different regarding the env. variables.
sm1adm (= Solution Manager admin)
DBMS_TYPE --> ada
JAVA_HOME --> C:\usr\sap\SM1\DVEBMGS00\exe\sapjvm_4
PATH --> C:\usr\sap\SM1\SYS\exe\uc\NTAMD64;C:\sapdb\clients\SM1\bin;C:\sapdb\clients\SM1\pgm;C:\sapdb\programs\bin
rsdb_ssfs_connect --> 0
RSEC_SSFS_DATAPATH --> \\WEDOIT-HOST\sapmnt\SM1\SYS\global\security\rsecssfs\data
RSEC_SSFS_KEYPATH --> \\WEDOIT-HOST\sapmnt\SM1\SYS\global\security\rsecssfs\key
SAPEXE --> C:\usr\sap\SM1\SYS\exe\uc\NTAMD64
SAPLOCALHOST --> WEDOIT-HOST
SAPSYSTEMNAME --> SM1
er1adm (= ERP admin)
DBMS_TYPE --> ada
PATH --> C:\usr\sap\ER1\SYS\exe\uc\NTAMD64;C:\sapdb\clients\ER1\bin;C:\sapdb\clients\ER1\pgm;C:\sapdb\programs\bin
rsdb_ssfs_connect --> 0
RSEC_SSFS_DATAPATH --> \\WEDOIT-HOST\sapmnt\ER1\SYS\global\security\rsecssfs\data
RSEC_SSFS_KEYPATH --> \\WEDOIT-HOST\sapmnt\ER1\SYS\global\security\rsecssfs\key
SAPEXE --> C:\usr\sap\ER1\SYS\exe\uc\NTAMD64
SAPLOCALHOST --> WEDOIT-HOST
SAPSYSTEMNAME --> ER1
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.