DB connection only works for some admin user but not for all

[Former Member]

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

[JPReyes]

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

[Former Member]

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

[JPReyes]

Can you check that both users have localadmin rights?

Regards, Juan

[Former Member]

yes, both are admin users

[JPReyes]

Is your server time correct?... I see in your other thread that you have an issue with the time server.

Regards, Juan