cancel
Showing results for 
Search instead for 
Did you mean: 

SAP NW702 SP6 - SAP console is not working

Former Member
0 Kudos

Dear Team,

I have installed SAP NW702 trail version in Windows Server 2008 R2, after a weeks i have encountered this issue. SAP MMC console is not started and still in idle status.

Please find the below error messages,

"SAP Basis System: Initialization DB-Connect Failed, Return Code 008192"

Could you please help me to resolve this issue.

Thanks

S.Jeeva

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

What is the name of the database that you have installed before installing SAP?

Thanks

SM

Former Member
0 Kudos

Hi,

This is my DEFAULT profile details,

SAPDBHOST = DEV2K10

j2ee/dbtype = sap

j2ee/dbname = NSP

j2ee/dbhost = DEV2K10

SAPSYSTEMNAME = NSP

SAPGLOBALHOST = DEV2K10

system/type = ABAP

#----


  1. SAP Message Server for ABAP

#----


rdisp/mshost = DEV2K10

rdisp/msserv = 0

rdisp/msserv_internal = 3900

login/system_client = 001

I have used "MAXDB" database for SAP installaing.

Could you please let me know how to find the environment variables in my system.

I am using "Windows Server 2008 R2 Data Centre" for my SAP system.

Thanks

S.Jeeva

Former Member
0 Kudos

Hi,

Login with the <sid>adm user. Right click on My computer -> Properties -> Advanced -> Environment Variable.

For this user, the dbms_type variable should be set. Furthermore, this variable should also be added to the system's default profile.

Regards,

Srikishan

Former Member
0 Kudos

Hi,

Thanks for your response.

I have set the enviroment varaible as you suggested, but now i got the new error message,

Application Server shutdown

Time : Friday 08/07/2011

Component : DPTM

Release: 720

Version: 10

Return Code: -17

Counter: 3

I have found the SAP MMC error message like "SAP Basis System: Initialization DB-Connect Failed, Return Code 008192"

Could you please help me to fix this issue.

Thanks

Former Member
0 Kudos

Hi,

Kindly post the dev_w0 logs after setting the environment variable.

This should give more details.

Regards,

Srikishan

Former Member
0 Kudos

Hi,

Please find the dev_w0 log details,

M Mon Jul 11 09:49:28 2011

M ThInit: initializing DIA work process W0

M

M Mon Jul 11 09:49:31 2011

M ThInit: running on host DEV2K10

M

M Mon Jul 11 09:49:32 2011

M calling db_connect ...

B

B Mon Jul 11 09:49:33 2011

B create_con (con_name=R/3)

B

B Mon Jul 11 09:49:34 2011

B Loading DB library 'E:\usr\sap\NSP\DVEBMGS00\exe\dbsdbslib.dll' ...

M

M Mon Jul 11 09:49:36 2011

M *** ERROR => DlLoadLib()==DLENOACCESS - LoadLibrary("E:\usr\sap\NSP\DVEBMGS00\exe\dbsdbslib.dll")

Error 126 = "The specified module could not be found." [dlnt.c 255]

B *** ERROR => Couldn't load library 'E:\usr\sap\NSP\DVEBMGS00\exe\dbsdbslib.dll'

[dbcon.c 5249]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 008192) [thxxhead.c 1461]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 11087]

M

M Info for wp 0

I have checked this 'E:\usr\sap\NSP\DVEBMGS00\exe\dbsdbslib.dll' file and permission to the current user, file is exist in the folder and current user have the full permission to access this file.

Please help me to resolve this issue.

Thanks

S.Jeeva

Former Member
0 Kudos

Hi,

Could you please help me to resolve this issue.

Thanks

S.Jeeva

former_member185031
Active Contributor
0 Kudos

Can you check sap directory is shared by name sapmnt or not ?

Regards,

Subhash

Former Member
0 Kudos

Hi,

Previously its not shared and now i have shared the folder but still i have the same issue.

Thanks

S.Jeeva

former_member185031
Active Contributor
0 Kudos

Please Post the trace file dev_w0. You will find it on work directory

Regards,

Subhash

Former Member
0 Kudos

Hi,

Please find the dev_w0 log details,

trc file: "dev_w0", trc level: 1, release: "720"

----


++*

+ ACTIVE TRACE LEVEL 1+*

+ ACTIVE TRACE COMPONENTS all, MJ+*

++*

M sysno 00

M sid NSP

M systemid 562 (PC with Windows NT)

M relno 7200

M patchlevel 0

M patchno 46

M intno 20020600

M make multithreaded, Unicode, 64 bit, optimized

M profile
DEV2K10\sapmnt\NSP\SYS\profile\NSP_DVEBMGS00_DEV2K10

M pid 2240

M

M

M Thu Jul 07 16:12:59 2011

M kernel runs with dp version 125000(ext=118000) (@(#) DPLIB-INT-VERSION-125000-UC)

M length of sys_adm_ext is 588 bytes

*M ***LOG Q0Q=> tskh_init, WPStart (Workp. 0 2240) [dpxxdisp.c 1314]*

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is active

M DpIPCInit2: read dp-profile-values from sys_adm_ext

M DpShMCreate: sizeof(wp_adm) 31696 (2264)

M DpShMCreate: sizeof(tm_adm) 5517056 (27448)

M DpShMCreate: sizeof(wp_ca_adm) 64000 (64)

M DpShMCreate: sizeof(appc_ca_adm) 64000 (64)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/584064/584080

M DpShMCreate: sizeof(comm_adm) 584080 (1144)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=512/48/65600/90416/156064

M DpShMCreate: sizeof(slock_adm) 156064 (104)

M DpFileTableSize: max/headSize/ftSize/tableSize=2800/16/268864/268880

M DpShMCreate: sizeof(file_adm) 268880 (80)

M DpShMCreate: sizeof(vmc_adm) 30128 (2152)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: sizeof(j2ee_adm) 3936

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000DE40050, size: 6812336)

M DpShMCreate: allocated sys_adm at 000000000DE40060

M DpShMCreate: allocated wp_adm_list at 000000000DE43030

M DpShMCreate: allocated wp_adm at 000000000DE43220

M DpShMCreate: allocated tm_adm_list at 000000000DE4AE00

M DpShMCreate: allocated tm_adm at 000000000DE4AE50

M DpShMCreate: allocated wp_ca_adm at 000000000E38DD60

M DpShMCreate: allocated appc_ca_adm at 000000000E39D770

M DpShMCreate: allocated comm_adm at 000000000E3AD180

M DpShMCreate: allocated slock_adm at 000000000E43BB20

M DpShMCreate: allocated file_adm at 000000000E461CD0

M DpShMCreate: allocated vmc_adm_list at 000000000E4A3730

M DpShMCreate: allocated vmc_adm at 000000000E4A37E0

M DpShMCreate: allocated gw_adm at 000000000E4AADA0

M DpShMCreate: allocated j2ee_adm at 000000000E4AADE0

M DpShMCreate: allocated ca_info at 000000000E4ABD50

M DpShMCreate: allocated wall_adm at 000000000E4ABD70

M DpCommAttachTable: attached comm table (header=000000000E3AD180/ft=000000000E3AD190)

M DpSesCreateTable: attached session table at 00000000029C0050 (len=161328)

M DpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm

M rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M DpVmcSetActive: set vmc state DP_VMC_ENABLED

M DpVmcSetActive: set vmc state DP_VMC_ACTIVE

M DpVmcInit2: o.k.

M ThStart: taskhandler started

M

M Thu Jul 07 16:13:00 2011

M ThInit: initializing DIA work process W0

M

M Thu Jul 07 16:13:04 2011

M ThInit: running on host DEV2K10

M calling db_connect ...

B create_con (con_name=R/3)

*B *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library*

[dbcon.c 5070]

*M ***LOG R19=> ThInit, db_connect ( DB-Connect 008192) [thxxhead.c 1461]*

M in_ThErrHandle: 1

M

M Thu Jul 07 16:13:05 2011

*M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 11087]*

M

M Info for wp 0

M

M pid = 2240

M severity = 0

M status = 0

M stat = WP_NEW

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M req.req_info =

M req.tid = -1

M req.uid = 4294967295

M req.mode = 255

M req.len = -1

M req.rq_id = 65535

M req.rq_source =

M req.vm = no VM

M last_tid = 0

M last_uid = 0

M last_mode = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M attachedVm = no VM

M

M ThIErrHandle: current request:

M

M -IN-- sender_id ? tid -1 wp_ca_blk -1 wp_id -1

M -IN-- action - uid -1 appc_ca_blk -1 type -

M -IN-- new_stat NO_CHANGE mode 255 len -1 rq_id -1

M

*M ******************************************************************************

*M **

*M * LOCATION SAP-Server DEV2K10_NSP_00 on host DEV2K10 (wp 0)*

*M * ERROR ThInit: db_connect*

*M **

*M * TIME Thu Jul 07 16:13:05 2011*

*M * RELEASE 720*

*M * COMPONENT Taskhandler*

*M * VERSION 1*

*M * RC 13*

*M * MODULE thxxhead.c*

*M * LINE 11364*

*M * COUNTER 1*

*M **

*M ******************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP

M ThCallHooks: hook >ThrBtcCallLgCl< o.k.

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

*M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 779]*

*M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 303]*

M ThCallHooks: hook >ThrSaveSPAFields< o.k.

M ThIErrHandle: entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

*M ***LOG Q02=> wp_halt, WPStop (Workp. 0 2240) [dpnttool.c 339]*

"

Edited by: MOSSSAP on Jul 7, 2011 12:55 PM

former_member185031
Active Contributor
0 Kudos
*** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = , cannot load DB library

Chech your environment variable and profile parameter on default profile.

dbms_type=ada

Regards,

Subhash