We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE: [sap-basis] Not able to connect to my SAP system

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by D. Caddick (SAP NetWeaver/BASIS Consultant)
on Mar 26 at 12:42 AM 		Mark this reply as helpfulMark as helpful
Hi Priya,



As I suggested when posting Developer trace files you must remove the rows
containing '---'or '===', Toolbox truncates messages with these rows on the
web page.

The E-mail posting shows the trace files but I do not see any errors:



trc file: "dev_w0", trc level: 1, release: "46D"

*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, M
*
M
M Thu Mar 25 18:49:08 2010
M relno 4640
M patchlevel 0
M patchno 1512
M intno 0
M pid 13802
M
M ***LOG Q01=> tskh_init, WPStart (Workproc 0 1 13802) [thxxhead.c 991]
M ThSysUsrCheck: clear T0
M calling db_connect ...
C DBSL: unsupported control command 29. ignored.
C DBSL: unsupported control command 57. ignored.
C PRF PARAM SAPDBHOST SET TO 'xxxxxx'
C ENV PARAM INFORMIX_DBID SET TO 'xxx'
C PRF PARAM dbs/inf/stmt_cache_size SET TO '225'
C PRF PARAM dbs/inf/array_fetch_off SET TO 'FALSE'
C PRF PARAM dbs/inf/select_buffer_size SET TO '67584'
C PRF PARAM dbs/inf/cursor_insert_off SET TO 'FALSE'
C PRF PARAM dbs/inf/insert_buffer_size SET TO '4096'
C PRF PARAM dbs/inf/free_cursor_off SET TO 'FALSE'
C PRF PARAM dbs/inf/blob_truncation_off SET TO 'FALSE'
C PRF PARAM dbs/inf/optmsg_level SET TO '15'
C PRF PARAM dbs/inf/optofc_off SET TO 'FALSE'
C PRF PARAM dbs/inf/stmt_cache_reset_time SET TO '0'
C PRF PARAM dbs/inf/stmt_cache_reset_size SET TO '10000000'
C
C INFORMIX DATABASE INTERFACE (DBSL) INFO:
C

C SELECT option = array (buffer size = 67584)
C INSERT option = cursor (buffer size = 4096)
C OPTMSG option = active (level = 15)
C OPTOFC option = active
C
C INFORMIX DATABASE VERSION INFO:
C
C MK version = ESQL/C 9.30
C FE version = CONNECT 9.24
C BE version = IDS 7.31
B Connection 0 opened
B Wp Hdl ConName ConCnt ConState TX PRM RCT Date Time
B 000 000 R/3 000000 ACTIVE NO YES NO 20100325 184908
C DBSL: unsupported control command 51. ignored.
C DBSL: unsupported control command 43. ignored.
M db_connect o.k.
I MtxInit: 0 0 0
X EmInit: MmSetImplementation( 2 ).
X <ES> client 0 initializing ....
X Using implementation std
X ES initialized.
B
B Thu Mar 25 18:49:10 2010
B db_con_shm_ini: WP_ID = 0, WP_CNT = 16
B
B Thu Mar 25 18:49:19 2010
B dbtbxbuf: Profile: max_objects = 10000, displace = 1, reorg = 1
B dbtbxbuf: request_unit = 2000, sync_reload = 0, inval_reload = 5
B dbtbxbuf: protect_shm = 0
B ***LOG BB0=> buffer TABL started with length 51200000 bytes [dbtbxbuf1691
2]
B ***LOG BB0=> buffer TABLP started with length 020480000 bytes [dbbfe 0973
]
B Layout of EIBUF buffer shared memory:
B 0: 1 * 4 = 4
B 1: 1 * 320 = 320
B 2: 16 * 20 = 320
B 3: 8009 * 56 = 448504
B 4: 4000 * 128 = 512000
B 5: 8009 * 4 = 32036
B 6: 1 * 100 = 100
B 7: 65 * 4 = 260
B 8: 25005 * 128 = 3200640
B Tracing = 0, Shm Protection = 0, Force checks = 0
B ***LOG BB0=> buffer EIBUF started with length 4096k bytes [dbexpbuf2020 ]
B Layout of CUA buffer shared memory:
B 0: 1 * 4 = 4
B 1: 1 * 320 = 320
B 2: 16 * 20 = 320
B 3: 15013 * 56 = 840728
B 4: 7500 * 128 = 960000
B 5: 15013 * 4 = 60052
B 6: 1 * 100 = 100
B 7: 193 * 4 = 772
B 8: 52725 * 256 = 13497600
B Tracing = 0, Shm Protection = 0, Force checks = 0
B ***LOG BB0=> buffer CUA started with length 15000k bytes [dbexpbuf2020 ]
B ***LOG BB0=> buffer CALE started with length 500000 bytes [dbcalbuf2165 ]
B dbtran INFO (init_connection '<DEFAULT>' [INFORMIX:46D.00]):
B max_blocking_factor = 10, max_in_blocking_factor = 20,
B min_blocking_factor = 5, min_in_blocking_factor = 2,
B prefer_union_all = 1, prefer_union_for_select_all = 0,
B prefer_fix_blocking = 1, prefer_in_itab_opt = 1,
B convert AVG = 0, alias table FUPD = 0,
B escape_as_literal = 0, opt GE LE to BETWEEN = 0,
B select * = 0x3,
B use_hints = abap->1, dbif->1, upto->0, rule_in->0,
B rule_fae->0, concat_fae->0, concat_fae_or->0
M
M Thu Mar 25 18:49:22 2010
M PfReadDBVersion: use compatibility mode for stat-files
M PfInitShm: use compatibility mode for stat-files



trc file: "dev_ms", trc level: 1, release: "46D"

Thu Mar 25 18:49:06 2010
MsSSetTrcLog: trc logging not active
relno 4640
patchlevel 0
patchno 1495
intno 0
pid 13799
***LOG Q01=> MsSInit, MSStart (Msg Server 1 13799) [msxxserv.c 1301]
*** I listen to port sapmsXXX (3601) ***
CUSTOMER KEY: >xxxxxx<

Regards





From: priya patel via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 26 March 2010 02:10
To: D. Caddick
Subject: [sap-basis] Not able to connect to my SAP system








Posted by priya patel
on Mar 25 at 10:13 PM



Hi,

SAP :46.d, DB Informix 9.4, OS : HP UX

I am not able to connect to my SAP system. The issue isn't related to GUI.
As part of post refresh activity, had to bounce the server. It went into
hung state, bounce it again. After that i face this issue.

Am pasting the Dev_ms,Dev_w0 for reference


-------------------------------------------------- -
trc file: "dev_w0", trc level: 1, release: "46D"
-------------------------------------------------- -
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, M
*
M
M Thu Mar 25 18:49:08 2010
M relno 4640
M patchlevel 0
M patchno 1512
M intno 0
M pid 13802
M
M ***LOG Q01=> tskh_init, WPStart (Workproc 0 1 13802) [thxxhead.c 991]
M ThSysUsrCheck: clear T0
M calling db_connect ...
C DBSL: unsupported control command 29. ignored.
C DBSL: unsupported control command 57. ignored.
C PRF PARAM SAPDBHOST SET TO 'xxxxxx'
C ENV PARAM INFORMIX_DBID SET TO 'xxx'
C PRF PARAM dbs/inf/stmt_cache_size SET TO '225'
C PRF PARAM dbs/inf/array_fetch_off SET TO 'FALSE'
C PRF PARAM dbs/inf/select_buffer_size SET TO '67584'
C PRF PARAM dbs/inf/cursor_insert_off SET TO 'FALSE'
C PRF PARAM dbs/inf/insert_buffer_size SET TO '4096'
C PRF PARAM dbs/inf/free_cursor_off SET TO 'FALSE'
C PRF PARAM dbs/inf/blob_truncation_off SET TO 'FALSE'
C PRF PARAM dbs/inf/optmsg_level SET TO '15'
C PRF PARAM dbs/inf/optofc_off SET TO 'FALSE'
C PRF PARAM dbs/inf/stmt_cache_reset_time SET TO '0'
C PRF PARAM dbs/inf/stmt_cache_reset_size SET TO '10000000'
C
C INFORMIX DATABASE INTERFACE (DBSL) INFO:
C ----------------------------------------
C SELECT option = array (buffer size = 67584)
C INSERT option = cursor (buffer size = 4096)
C OPTMSG option = active (level = 15)
C OPTOFC option = active
C
C INFORMIX DATABASE VERSION INFO:
C -------------------------------
C MK version = ESQL/C 9.30
C FE version = CONNECT 9.24
C BE version = IDS 7.31
B Connection 0 opened
B Wp Hdl ConName ConCnt ConState TX PRM RCT Date Time
B 000 000 R/3 000000 ACTIVE NO YES NO 20100325 184908
C DBSL: unsupported control command 51. ignored.
C DBSL: unsupported control command 43. ignored.
M db_connect o.k.
I MtxInit: 0 0 0
X EmInit: MmSetImplementation( 2 ).
X <ES> client 0 initializing ....
X Using implementation std
X ES initialized.
B
B Thu Mar 25 18:49:10 2010
B db_con_shm_ini: WP_ID = 0, WP_CNT = 16
B
B Thu Mar 25 18:49:19 2010
B dbtbxbuf: Profile: max_objects = 10000, displace = 1, reorg = 1
B dbtbxbuf: request_unit = 2000, sync_reload = 0, inval_reload = 5
B dbtbxbuf: protect_shm = 0
B ***LOG BB0=> buffer TABL started with length 51200000 bytes [dbtbxbuf1691
2]
B ***LOG BB0=> buffer TABLP started with length 020480000 bytes [dbbfe 0973
]
B Layout of EIBUF buffer shared memory:
B 0: 1 * 4 = 4
B 1: 1 * 320 = 320
B 2: 16 * 20 = 320
B 3: 8009 * 56 = 448504
B 4: 4000 * 128 = 512000
B 5: 8009 * 4 = 32036
B 6: 1 * 100 = 100
B 7: 65 * 4 = 260
B 8: 25005 * 128 = 3200640
B Tracing = 0, Shm Protection = 0, Force checks = 0
B ***LOG BB0=> buffer EIBUF started with length 4096k bytes [dbexpbuf2020 ]
B Layout of CUA buffer shared memory:
B 0: 1 * 4 = 4
B 1: 1 * 320 = 320
B 2: 16 * 20 = 320
B 3: 15013 * 56 = 840728
B 4: 7500 * 128 = 960000
B 5: 15013 * 4 = 60052
B 6: 1 * 100 = 100
B 7: 193 * 4 = 772
B 8: 52725 * 256 = 13497600
B Tracing = 0, Shm Protection = 0, Force checks = 0
B ***LOG BB0=> buffer CUA started with length 15000k bytes [dbexpbuf2020 ]
B ***LOG BB0=> buffer CALE started with length 500000 bytes [dbcalbuf2165 ]
B dbtran INFO (init_connection '<DEFAULT>' [INFORMIX:46D.00]):
B max_blocking_factor = 10, max_in_blocking_factor = 20,
B min_blocking_factor = 5, min_in_blocking_factor = 2,
B prefer_union_all = 1, prefer_union_for_select_all = 0,
B prefer_fix_blocking = 1, prefer_in_itab_opt = 1,
B convert AVG = 0, alias table FUPD = 0,
B escape_as_literal = 0, opt GE LE to BETWEEN = 0,
B select * = 0x3,
B use_hints = abap->1, dbif->1, upto->0, rule_in->0,
B rule_fae->0, concat_fae->0, concat_fae_or->0
M
M Thu Mar 25 18:49:22 2010
M PfReadDBVersion: use compatibility mode for stat-files
M PfInitShm: use compatibility mode for stat-files


--------------------------------------------------
----------------------------------------

-------------------------------------------------- -
trc file: "dev_ms", trc level: 1, release: "46D"
-------------------------------------------------- -

Thu Mar 25 18:49:06 2010
MsSSetTrcLog: trc logging not active
relno 4640
patchlevel 0
patchno 1495
intno 0
pid 13799
***LOG Q01=> MsSInit, MSStart (Msg Server 1 13799) [msxxserv.c 1301]
*** I listen to port sapmsXXX (3601) ***
CUSTOMER KEY: >xxxxxx<



Please let me know where can i check for?
__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
D. Caddick
SAP Basis Top Contributor

Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language