Skip to Content
0
Former Member
May 08, 2013 at 12:02 AM

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

322 Views

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