cancel
Showing results for 
Search instead for 
Did you mean: 

Error Code (0012) connection failed R3trans

Former Member
0 Kudos

Hi Expertise,

I am getting error (0012) while executing command R3trans -d for connecting database to sap. Here, I am sharing db2daig.log. please advice me how could i resolve it. This is a new installation & no data is there. All the services are running & working. I can able to access only database thorough command level when executing command connect to database but sap instance stopped within 10 mint.

SAP: ECC6

Database : DB2 9.7

Regards

Abhijit

Accepted Solutions (0)

Answers (5)

Answers (5)

sivakumar_kilari3
Active Contributor
0 Kudos

Did you resolved the issue?

Former Member
0 Kudos

Hi,

No, I will try today night. After that i will let you know.

Regards

Abhijit

sivakumar_kilari3
Active Contributor
0 Kudos

Is it production server or sandbox server?

Former Member
0 Kudos

Hi,

Sandbox system.

Regards

Abhijit

Former Member
0 Kudos

Hi,

Same error is getting so here, we can start fresh installation or others.

Regards

Abhijit

andreas_herzog
Active Contributor
0 Kudos

hi...without the trans.log it will be difficult to examine the matter please provide the file...it will be written within the directory where R3trans -d has been executed  (usually the home directory of the <sid>adm user on Windows)

GreetZ, AH

Former Member
0 Kudos

Hi,

Thanks for giving quick response & shared trns.log and dev_w0 log.

4 ETW000 R3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 24.03.2014 - 21:06:09

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [dev trc     ,00000]  Mon Mar 24 21:06:12 2014                            1001  0.001001

4 ETW000  [dev trc     ,00000]  db_con_init called                                    84  0.001085

4 ETW000  [dev trc     ,00000]  create_con (con_name=R/3)                            235  0.001320

4 ETW000  [dev trc     ,00000]  Loading DB library 'dbdb6slib.dll' ...                68  0.001388

4 ETW000  [dev trc     ,00000]  load shared library (dbdb6slib.dll), hdl 0         74322  0.075710

4 ETW000  [dev trc     ,00000]      using "D:\usr\sap\SAN\SYS\exe\uc\NTAMD64\dbdb6slib.dll"

4 ETW000                                                                              24  0.075734

4 ETW000  [dev trc     ,00000]  Library 'dbdb6slib.dll' loaded                         8  0.075742

4 ETW000  [dev trc     ,00000]  function DbSlExpFuns loaded from library dbdb6slib.dll

4 ETW000                                                                              19  0.075761

4 ETW000  [dev trc     ,00000]  Version of 'dbdb6slib.dll' is "700.08", patchlevel (0.52)

4 ETW000                                                                          296197  0.371958

4 ETW000  [dev trc     ,00000]  function dsql_db_init loaded from library dbdb6slib.dll

4 ETW000                                                                              36  0.371994

4 ETW000  [dev trc     ,00000]  function dbdd_exp_funs loaded from library dbdb6slib.dll

4 ETW000                                                                              25  0.372019

4 ETW000  [dev trc     ,00000]  New connection 0 created                             570  0.372589

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                              40  0.372629

4 ETW000  [dev trc     ,00000]  db_con_connect (con_name=R/3)                         30  0.372659

4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection for reuse:

4 ETW000                                                                              12  0.372671

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                              14  0.372685

4 ETW000  [dev trc     ,00000]  DB6 (DB2 UDB) UNICODE database interface 700.08 [opt]

4 ETW000                                                                           22202  0.394887

4 ETW000  [dev trc     ,00000]  DB6 shared library (dbdb6slib) patchlevels            13  0.394900

4 ETW000  [dev trc     ,00000]    (0.8) DB6: V8.2.2 optguidelines in OPEN SQL (note 150037)

4 ETW000                                                                              32  0.394932

4 ETW000  [dev trc     ,00000]    (0.8) Support of SDBUPDEXCL (note 847616)            7  0.394939

4 ETW000  [dev trc     ,00000]    (0.9) DB6: use export file for dbdb6slib (note 835135)

4 ETW000                                                                              15  0.394954

4 ETW000  [dev trc     ,00000]    (0.9) DB6: Core in getAndBindSQLDA (note 833183)

4 ETW000                                                                               9  0.394963

4 ETW000  [dev trc     ,00000]    (0.10) DB6: link dbdb6slib.dll on windows with libdb6.obj (note 761159)

4 ETW000                                                                              11  0.394974

4 ETW000  [dev trc     ,00000]    (0.10) DB6: DUPLICATE_KEY on MERGE -> repeat (note 851474)

4 ETW000                                                                              78  0.395052

4 ETW000  [dev trc     ,00000]    (0.15) DB6: wrong CAST for short string ABAP type (note 861905)

4 ETW000                                                                              37  0.395089

4 ETW000  [dev trc     ,00000]    (0.17) DB6: special characters in sidadm passwd (note 865839)

4 ETW000                                                                              15  0.395104

4 ETW000  [dev trc     ,00000]    (0.21) DB6: no SAP_INFO comments (note 873889)

4 ETW000                                                                              14  0.395118

4 ETW000  [dev trc     ,00000]    (0.22) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000                                                                              10  0.395128

4 ETW000  [dev trc     ,00000]    (0.23) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000                                                                              15  0.395143

4 ETW000  [dev trc     ,00000]    (0.26) DB6: DB6_DBSL_CLP_COMMAND STRING_BAD_REF (note 883402)

4 ETW000                                                                              14  0.395157

4 ETW000  [dev trc     ,00000]    (0.27) DB6: activate value compression (note 886231)

4 ETW000                                                                               9  0.395166

4 ETW000  [dev trc     ,00000]    (0.28) DB6: optimization guidelines on views part 2 (note 868888)

4 ETW000                                                                              10  0.395176

4 ETW000  [dev trc     ,00000]    (0.30) DB6: no SQL trace for SQLCancel (note 892111)

4 ETW000                                                                              14  0.395190

4 ETW000  [dev trc     ,00000]    (0.33) DB6: append SAP_TA comment (note 873889)

4 ETW000                                                                              13  0.395203

4 ETW000  [dev trc     ,00000]    (0.34) DB6: activate value compression with quoted names (note 886231)

4 ETW000                                                                              11  0.395214

4 ETW000  [dev trc     ,00000]    (0.36) DB6: Repeat isolated DDL statements after SQL0911 (note 901338)

4 ETW000                                                                              14  0.395228

4 ETW000  [dev trc     ,00000]    (0.41) DB6: add V9 to list of supported DB2 releases (note 912386)

4 ETW000                                                                              15  0.395243

4 ETW000  [dev trc     ,00000]    (0.50) DB6: reread passwords for secondary connections (note 931742)

4 ETW000                                                                              14  0.395257

4 ETW000  [dev trc     ,00000]    (0.52) DB6: double quote table names in optguidelines (note 868888)

4 ETW000                                                                              14  0.395271

4 ETW000  [dev trc     ,00000]  Supported features:                                    6  0.395277

4 ETW000  [dev trc     ,00000]    - CLI LOAD for INSERT ... FULLSELECT                 7  0.395284

4 ETW000  [dev trc     ,00000]  ..retrieving configuration parameters                  6  0.395290

4 ETW000  [dev trc     ,00000]  ..done                                               284  0.395574

4 ETW000  [dev trc     ,00000]  Running with UTF-8 Unicode                             7  0.395581

4 ETW000  [dev trc     ,00000]  Mon Mar 24 21:06:13 2014                         1229962  1.625543

4 ETW000  [dev trc     ,00000]  DB2 client driver version '09.07.0009'                49  1.625592

4 ETW000  [dev trc     ,00000]  Connected to DB2 version '09.07.0009'                 44  1.625636

4 ETW000  [dev trc     ,00000]  Code page check canceled on this server ( sqlfxdb: rc= -1013 ) -> to be ignored

4 ETW000                                                                           11924  1.637560

4 ETW000  [dev trc     ,00000]  *** ERROR in ExecuteDirect[dbdb6.c, 5148] (BEGIN)

4 ETW000                                                                          169670  1.807230

4 ETW000  [dev trc     ,00000]  &+     DbSlConnectDB6( SQLExecDirect 😞 [IBM][CLI Driver][LU62SPM] SQL30070N  "Unsupported function for SPMDB connect" Co

4 ETW000                                                                              18  1.807248

4 ETW000  [dev trc     ,00000]  &+     mmand is not supported.  SQLSTATE=58014                                                                          

4 ETW000                                                                              14  1.807262

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                              13  1.807275

4 ETW000  [dev trc     ,00000]  &+     SET CURRENT SCHEMA 'SAPSAN' -- SYSTEM( SAN , SAPSAN )                                                            

4 ETW000                                                                              14  1.807289

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                              14  1.807303

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                              13  1.807316

4 ETW000  [dev trc     ,00000]  *** ERROR in ExecuteDirect[dbdb6.c, 5148] (END)        8  1.807324

4 ETW000  [dev trc     ,00000]  Mon Mar 24 21:06:14 2014                          155502  1.962826

4 ETW000  [dev trc     ,00000]  *** ERROR in prepareStatement[dbdb6.c, 10607] (BEGIN)

4 ETW000                                                                              22  1.962848

4 ETW000  [dev trc     ,00000]  &+     DbSlConnectDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][LU62SPM] SQL30070N  "Unsupported function for SPMDB connec

4 ETW000                                                                              15  1.962863

4 ETW000  [dev trc     ,00000]  &+     t" Command is not supported.  SQLSTATE=58014                                                                     

4 ETW000                                                                              13  1.962876

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                              13  1.962889

4 ETW000  [dev trc     ,00000]  &+     SELECT COUNT(*) FROM TABLE( REG_LIST_VARIABLES() ) AS X  WHERE REG_VAR_NAME = 'DB2_WORKLOAD' AND UPPER( REG_VAR_VA

4 ETW000                                                                              14  1.962903

4 ETW000  [dev trc     ,00000]  &+     LUE ) = 'SAP'                                                                                                    

4 ETW000                                                                              13  1.962916

4 ETW000  [dev trc     ,00000]  &+       cursor type=NO_HOLD, isolation=UR, cc_release=NO, optlevel=5, degree=0, buffer_lobs=YES, op_type=40, reopt=0   

4 ETW000                                                                              17  1.962933

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                              14  1.962947

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                              13  1.962960

4 ETW000  [dev trc     ,00000]  *** ERROR in prepareStatement[dbdb6.c, 10607] (END)

4 ETW000                                                                              55  1.963015

4 ETW000  [dev trc     ,00000]  Could not check DB2 registry settings.                22  1.963037

4 ETW000  [dev trc     ,00000]  disconnected from 'ECC', con_hdl=0                 10358  1.973395

2EETW169 no connect possible: "DBMS = DB6                              --- DB2DBDFT = 'ECC'"

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

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

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

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

B Sun Mar 23 16:44:28 2014

B  create_con (con_name=R/3)

B  Loading DB library 'D:\usr\sap\SAN\DVEBMGS00\exe\dbdb6slib.dll' ...

B  Library 'D:\usr\sap\SAN\DVEBMGS00\exe\dbdb6slib.dll' loaded

B Sun Mar 23 16:44:29 2014

B  Version of 'D:\usr\sap\SAN\DVEBMGS00\exe\dbdb6slib.dll' is "700.08", patchlevel (0.52)

C  DbSl trace SM50: switch request to level 1

B  New connection 0 created

M sysno      00

M sid        SAN

M systemid   562 (PC with Windows NT)

M relno      7000

M patchlevel 0

M patchno    52

M intno      20050900

M make:      multithreaded, Unicode, 64 bit, optimized

M pid        2188

M

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

M  length of sys_adm_ext is 572 bytes

M  ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2188) [dpxxdisp.c   1293]

I  MtxInit: 30000 0 0

M  DpSysAdmExtCreate: ABAP is active

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

M  DpShMCreate: sizeof(wp_adm) 12816 (1424)

M  DpShMCreate: sizeof(tm_adm) 5217968 (25960)

M  DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M  DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M  DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M  DpShMCreate: sizeof(comm_adm) 552080 (1088)

M  DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M  DpShMCreate: sizeof(file_adm) 0 (72)

M  DpShMCreate: sizeof(vmc_adm) 0 (1760)

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

M  DpShMCreate: sizeof(gw_adm) 48

M  DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000F150050, size: 5901456)

M  DpShMCreate: allocated sys_adm at 000000000F150050

M  DpShMCreate: allocated wp_adm at 000000000F151EE0

M  DpShMCreate: allocated tm_adm_list at 000000000F1550F0

M  DpShMCreate: allocated tm_adm at 000000000F155150

M  DpShMCreate: allocated wp_ca_adm at 000000000F64F000

M  DpShMCreate: allocated appc_ca_adm at 000000000F654DC0

M  DpShMCreate: allocated comm_adm at 000000000F656D00

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 000000000F6DD990

M  DpShMCreate: allocated gw_adm at 000000000F6DDA10

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated ca_info at 000000000F6DDA40

M  DpShMCreate: allocated wall_adm at 000000000F6DDA50

X  EmInit: MmSetImplementation( 2 ).

X  MM diagnostic options set: 0

X  <ES> client 0 initializing ....

X  Using implementation flat

M  <EsNT> Memory Reset disabled as NT default

X  ES initialized.

M Sun Mar 23 16:44:30 2014

M  ThInit: running on host ecc

M  calling db_connect ...

C  Registering callback for dynamic profile parameters

C Sun Mar 23 16:44:31 2014

C  DB6 (DB2 UDB) UNICODE database interface 700.08 [opt]

C  DB6 shared library (dbdb6slib) patchlevels

C    (0.8) DB6: V8.2.2 optguidelines in OPEN SQL (note 150037)

C    (0.8) Support of SDBUPDEXCL (note 847616)

C    (0.9) DB6: use export file for dbdb6slib (note 835135)

C    (0.9) DB6: Core in getAndBindSQLDA (note 833183)

C    (0.10) DB6: link dbdb6slib.dll on windows with libdb6.obj (note 761159)

C    (0.10) DB6: DUPLICATE_KEY on MERGE -> repeat (note 851474)

C    (0.15) DB6: wrong CAST for short string ABAP type (note 861905)

C    (0.17) DB6: special characters in sidadm passwd (note 865839)

C    (0.21) DB6: no SAP_INFO comments (note 873889)

C    (0.22) DB6: hints: get correlation names from view texts (note 868888)

C    (0.23) DB6: hints: get correlation names from view texts (note 868888)

C    (0.26) DB6: DB6_DBSL_CLP_COMMAND STRING_BAD_REF (note 883402)

C    (0.27) DB6: activate value compression (note 886231)

C    (0.28) DB6: optimization guidelines on views part 2 (note 868888)

C    (0.30) DB6: no SQL trace for SQLCancel (note 892111)

C    (0.33) DB6: append SAP_TA comment (note 873889)

C    (0.34) DB6: activate value compression with quoted names (note 886231)

C    (0.36) DB6: Repeat isolated DDL statements after SQL0911 (note 901338)

C    (0.41) DB6: add V9 to list of supported DB2 releases (note 912386)

C    (0.50) DB6: reread passwords for secondary connections (note 931742)

C    (0.52) DB6: double quote table names in optguidelines (note 868888)

C  Supported features:

C    - CLI LOAD for INSERT ... FULLSELECT

C  ..retrieving configuration parameters

C  ..done

C  Running with UTF-8 Unicode

C Sun Mar 23 16:44:32 2014

C  DB2 client driver version '09.07.0009'

C  Connected to DB2 version '09.07.0009'

C  Code page check canceled on this server ( sqlfxdb: rc= -1013 ) -> to be ignored

C  *** ERROR in ExecuteDirect[dbdb6.c, 5148] (BEGIN)

C  &+     DbSlConnectDB6( SQLExecDirect 😞 [IBM][CLI Driver][LU62SPM] SQL30070N  "Unsupported function for SPMDB connect" Co

C  &+     mmand is not supported.  SQLSTATE=58014                                                                          

C  &+                                                                                                                      

C  &+     SET CURRENT SCHEMA 'SAPSAN' -- SYSTEM( SAN , SAPSAN )                                                            

C  &+                                                                                                                      

C  *** ERROR in ExecuteDirect[dbdb6.c, 5148] (END)

C  *** ERROR in prepareStatement[dbdb6.c, 10607] (BEGIN)

C  &+     DbSlConnectDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][LU62SPM] SQL30070N  "Unsupported function for SPMDB connec

C  &+     t" Command is not supported.  SQLSTATE=58014                                                                     

C  &+                                                                                                                      

C  &+     SELECT COUNT(*) FROM TABLE( REG_LIST_VARIABLES() ) AS X  WHERE REG_VAR_NAME = 'DB2_WORKLOAD' AND UPPER( REG_VAR_VA

C  &+     LUE ) = 'SAP'                                                                                                    

C  &+       cursor type=NO_HOLD, isolation=UR, cc_release=NO, optlevel=5, degree=0, buffer_lobs=YES, op_type=40, reopt=0   

C  &+                                                                                                                      

C  *** ERROR in prepareStatement[dbdb6.c, 10607] (END)

C  Could not check DB2 registry settings.

C  disconnected from 'ECC', con_hdl=0

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

M  in_ThErrHandle: 1

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

M  Info for wp 0

M    stat = 4

M    reqtype = 1

M    act_reqtype = -1

M    rq_info = 0

M    tid = -1

M    mode = 255

M    len = -1

M    rq_id = 65535

M    rq_source = 255

M    last_tid = 0

M    last_mode = 0

M    semaphore = 0

M    act_cs_count = 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    vm = V-1

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

M  *

M  *  LOCATION    SAP-Server ecc_SAN_00 on host ecc (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Sun Mar 23 16:44:32 2014

M  *  RELEASE     700

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        10204

M  *  COUNTER     1

M  *

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

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M  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 (Workproc 0 2188) [dpnttool.c   327]

Regards

Abhijit

andreas_herzog
Active Contributor
0 Kudos

new to me

please go through http://scn.sap.com/thread/3462276 - maybe it'll settle the problem...

how was the db2 Software installed? manually?


GreetZ, AH

Frank-Martin
Product and Topic Expert
Product and Topic Expert
0 Kudos

Yes. I can remember having problems with invalid SPM_NAME parameters in the past although I can not repro with DB2 V10.5 any more.

db2 update dbm cfg using SPM_NAME NULL

may help.

Regards

               Frank

Former Member
0 Kudos

Hi,

yes. DB2 9.7 setup was installed manually & then, I created new database named SAN. Is there any profile path issue because of i did not found profile path of dev_disp.log which is attached already in this above log. Please advise & assist me.

Regards

Abhijit

Former Member
0 Kudos

Hi,

I applied this command " db2 update dbm cfg using SPM_NAME NULL "  but result same. Instance stopped after a few second.

Regards

Abhijit

former_member188883
Active Contributor
0 Kudos

Hi Abhijit,

The solution provided above on parameter SPM_NAME should work.

Refer IBM blog which is valid for 10.5 as well.

By default, SPM_NAME in database manager configuration is set to the hostname of the machine.

For hostnames that are greater than 8 characters, SPM_NAME can be updated to any values that is unique in the network up to 8 characters. The maximum length allowed for SPM_NAME setting is 8.

SPM_NAME does not need to be set to the hostname of the machine.

You can set this to any value unique in the network that is 8 characters or less.

Reference

IBM SQL5132N returned when SPM_NAME in database manager configuration is updated - United States

Hope this helps.

Regards,

Deepak Kori

Former Member
0 Kudos

Hi,

How to find correct SPM_NAME ?

Regards

Abhijit

former_member188883
Active Contributor
0 Kudos

Hi Abhjiit,

Please check existing value using command

db2 get dbm cfg

Look out for parameter SPM_NAME.

Set the new value to unique name in network like <First 3 Characters of  HOSTNAME><SID><INST No> using the command

stop sap application

db2 update dbm cfg using SPM_NAME <new VALUE>

restart db2 database

start sap application.


Hope this helps.


Regards,

Deepak Kori

sivakumar_kilari3
Active Contributor
0 Kudos

Hi ,

What is the below parameter value  below parameter value ?

TCP/IP Service name                          (SVCENAME) = sapdb<SID>    ( at database level)

please check this tcp/ip service ( sapdb<SID>) in your services file ( at OS level)

Thanks

siva

Former Member
0 Kudos

Hi,

As per above process, i did but same problem found. is there have any other option for resolving this issue.

Regards

Abhijit

sivakumar_kilari3
Active Contributor
0 Kudos

Hi ,

What is the below parameter value ?

db2 get dbm cfg

TCP/IP Service name                          (SVCENAME) = sapdb<SID>    ( at database level  )

please check this tcp/ip service ( sapdb<SID>) in your services file ( at OS level)

Thanks

siva

Former Member
0 Kudos

Hi,

When i am executing this command & it is being executed successfully & SPM_NAME has been changed after executing this command but error is getting same as earlier so what kind log will help to find out the actual error.

Regards

Abhijit

andreas_herzog
Active Contributor
0 Kudos

why did you create a new database? this was a new/fresh Installation using sapinst/swpm? usually the database instance and the db itself will be created through the installation tools...maybe it's better to start from scratch and let the tools handle the job...

GreetZ, AH

Former Member
0 Kudos

Hi,

Actually due to improper shutdown, database was crashed & failed to connect then, i started to install DB2 fixed pack 9.7. In my mistake, i installed advance DB2 v9.7 which was wrong for the exiting setup so next i removed it & installed proper DB2 v9.7  version as well as license was installed successfully & found that no database there so i had to create new database because of no option was there. So i am just confirming that is this situation is very critical for me & looking for solution. Which tools may i use here or could help to reconnect sap 

Regards

Abhijit

Frank-Martin
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Abhijit,

I do not see how this situation can be critical. Since you created a new database and SAP tools have not been able to connect since then I conclude that your database is empty.

So you should be able to clean up the mess and start a fresh install with the SAP install tools.

Regards

                Frank

Former Member
0 Kudos

Hello.

after this your database is empty and so SAP is unable to connect to database. First is after your new database installation works fine you can use a redirect restore from your source system with same database version you installed new.

Regards

Olaf

Former Member
0 Kudos

Hi,

Thanks for assisting me, but i did not understand meaning of clean up the mess & is it possible to install in our exiting setup or only fresh installation is required. Please could you say how to start it in our exiting system step by step.

Regards

Abhijit

andreas_herzog
Active Contributor
0 Kudos

due to your re-installation and re-creation of the db software and the database instance/database there is no data you either have a backup which is usable or have to install a standard SAP database (which will have no user data...)

the backup could be applied using a redirected restore from another db...see SAPnotes

if i were you i'd prefer to do the whole installation from scratch....

GreetZ, AH

Former Member
0 Kudos

Hi,

when i stared re installation of sap installation manager with exiting system then, i got error as follows.

INFO 2014-03-25 21:27:57

Connection request to guiengine backend by host 192.168.100.102 .

INFO 2014-03-25 21:28:00

Copied file 'C:/Program Files/sapinst_instdir/ERP/SYSTEM/DB6/CENTRAL/AS/inifile.xml' to 'C:/Program Files/sapinst_instdir/ERP/SYSTEM/DB6/CENTRAL/AS/inifile.6.xml'.

INFO 2014-03-25 21:28:00

Copied file 'C:/Program Files/sapinst_instdir/ERP/SYSTEM/DB6/CENTRAL/AS/inifile.xml' to 'C:/Program Files/sapinst_instdir/ERP/SYSTEM/DB6/CENTRAL/AS/inifile.7.xml'.

INFO 2014-03-25 21:28:01

Copied file 'C:/Program Files/sapinst_instdir/ERP/SYSTEM/DB6/CENTRAL/AS/keydb.xml' to 'C:/Program Files/sapinst_instdir/ERP/SYSTEM/DB6/CENTRAL/AS/keydb.4.xml'.

INFO 2014-03-25 21:28:01

Execute step runRSWBOINS of component |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0.

INFO 2014-03-25 21:28:18

RFC parameter CLIENT set to value 000.

INFO 2014-03-25 21:28:18

RFC parameter USER set to value DDIC.

INFO 2014-03-25 21:28:18

RFC parameter LCHECK set to value 1.

INFO 2014-03-25 21:28:18

RFC parameter PCS set to value 1.

INFO 2014-03-25 21:28:18

RFC parameter LANG set to value EN.

INFO 2014-03-25 21:28:18

RFC parameter ASHOST set to value ecc.

INFO 2014-03-25 21:28:18

RFC parameter SYSNR set to value 00.

INFO 2014-03-25 21:28:18

RFC connection information checked successfully.

ERROR 2014-03-25 21:28:19

FRF-00007  Unable to open RFC connection.

ERROR 2014-03-25 21:28:19

MUT-03025  Caught ERfcExcept in Modulecall: Connect to SAP gateway failedConnect_PM  GWHOST=ecc, GWSERV=sapgw00, SYSNR=00

ERROR 2014-03-25 21:28:19

FCO-00011  The step runRSWBOINS with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS was executed with status ERROR .

INFO 2014-03-25 21:43:21

An error occured and the user decided to retry the current step: "|NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS".

INFO 2014-03-25 21:43:22

RFC parameter CLIENT set to value 000.

INFO 2014-03-25 21:43:22

RFC parameter USER set to value DDIC.

INFO 2014-03-25 21:43:22

RFC parameter LCHECK set to value 1.

INFO 2014-03-25 21:43:22

RFC parameter PCS set to value 1.

INFO 2014-03-25 21:43:22

RFC parameter LANG set to value EN.

INFO 2014-03-25 21:43:22

RFC parameter ASHOST set to value ecc.

INFO 2014-03-25 21:43:22

RFC parameter SYSNR set to value 00.

INFO 2014-03-25 21:43:22

RFC connection information checked successfully.

ERROR 2014-03-25 21:43:23

FRF-00007  Unable to open RFC connection.

ERROR 2014-03-25 21:43:23

MUT-03025  Caught ERfcExcept in Modulecall: Connect to SAP gateway failedConnect_PM  GWHOST=ecc, GWSERV=sapgw00, SYSNR=00

ERROR 2014-03-25 21:43:23

FCO-00011  The step runRSWBOINS with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS was executed with status ERROR .

INFO 2014-03-25 21:43:24

An error occured and the user decided to retry the current step: "|NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS".

INFO 2014-03-25 21:43:24

RFC parameter CLIENT set to value 000.

INFO 2014-03-25 21:43:24

RFC parameter USER set to value DDIC.

INFO 2014-03-25 21:43:24

RFC parameter LCHECK set to value 1.

INFO 2014-03-25 21:43:24

RFC parameter PCS set to value 1.

INFO 2014-03-25 21:43:24

RFC parameter LANG set to value EN.

INFO 2014-03-25 21:43:24

RFC parameter ASHOST set to value ecc.

INFO 2014-03-25 21:43:24

RFC parameter SYSNR set to value 00.

INFO 2014-03-25 21:43:24

RFC connection information checked successfully.

ERROR 2014-03-25 21:43:25

FRF-00007  Unable to open RFC connection.

ERROR 2014-03-25 21:43:25

MUT-03025  Caught ERfcExcept in Modulecall: Connect to SAP gateway failedConnect_PM  GWHOST=ecc, GWSERV=sapgw00, SYSNR=00

ERROR 2014-03-25 21:43:25

FCO-00011  The step runRSWBOINS with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS was executed with status ERROR .

INFO 2014-03-25 22:28:12

An error occured and the user decided to retry the current step: "|NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS".

INFO 2014-03-25 22:28:12

RFC parameter CLIENT set to value 000.

INFO 2014-03-25 22:28:12

RFC parameter USER set to value DDIC.

INFO 2014-03-25 22:28:12

RFC parameter LCHECK set to value 1.

INFO 2014-03-25 22:28:12

RFC parameter PCS set to value 1.

INFO 2014-03-25 22:28:12

RFC parameter LANG set to value EN.

INFO 2014-03-25 22:28:12

RFC parameter ASHOST set to value ecc.

INFO 2014-03-25 22:28:12

RFC parameter SYSNR set to value 00.

INFO 2014-03-25 22:28:12

RFC connection information checked successfully.

ERROR 2014-03-25 22:28:13

FRF-00007  Unable to open RFC connection.

ERROR 2014-03-25 22:28:13

MUT-03025  Caught ERfcExcept in Modulecall: Connect to SAP gateway failedConnect_PM  GWHOST=ecc, GWSERV=sapgw00, SYSNR=00

ERROR 2014-03-25 22:28:13

FCO-00011  The step runRSWBOINS with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS was executed with status ERROR .

INFO 2014-03-25 22:28:14

An error occured and the user decided to retry the current step: "|NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS".

INFO 2014-03-25 22:28:14

RFC parameter CLIENT set to value 000.

INFO 2014-03-25 22:28:14

RFC parameter USER set to value DDIC.

INFO 2014-03-25 22:28:14

RFC parameter LCHECK set to value 1.

INFO 2014-03-25 22:28:14

RFC parameter PCS set to value 1.

INFO 2014-03-25 22:28:14

RFC parameter LANG set to value EN.

INFO 2014-03-25 22:28:14

RFC parameter ASHOST set to value ecc.

INFO 2014-03-25 22:28:14

RFC parameter SYSNR set to value 00.

INFO 2014-03-25 22:28:14

RFC connection information checked successfully.

ERROR 2014-03-25 22:28:15

FRF-00007  Unable to open RFC connection.

ERROR 2014-03-25 22:28:15

MUT-03025  Caught ERfcExcept in Modulecall: Connect to SAP gateway failedConnect_PM  GWHOST=ecc, GWSERV=sapgw00, SYSNR=00

ERROR 2014-03-25 22:28:15

FCO-00011  The step runRSWBOINS with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS was executed with status ERROR .

INFO 2014-03-25 22:28:51

An error occured and the user decided to retry the current step: "|NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS".

INFO 2014-03-25 22:28:51

RFC parameter CLIENT set to value 000.

INFO 2014-03-25 22:28:51

RFC parameter USER set to value DDIC.

INFO 2014-03-25 22:28:51

RFC parameter LCHECK set to value 1.

INFO 2014-03-25 22:28:51

RFC parameter PCS set to value 1.

INFO 2014-03-25 22:28:51

RFC parameter LANG set to value EN.

INFO 2014-03-25 22:28:51

RFC parameter ASHOST set to value ecc.

INFO 2014-03-25 22:28:51

RFC parameter SYSNR set to value 00.

INFO 2014-03-25 22:28:51

RFC connection information checked successfully.

ERROR 2014-03-25 22:28:52

FRF-00007  Unable to open RFC connection.

ERROR 2014-03-25 22:28:52

MUT-03025  Caught ERfcExcept in Modulecall: Connect to SAP gateway failedConnect_PM  GWHOST=ecc, GWSERV=sapgw00, SYSNR=00

ERROR 2014-03-25 22:28:52

FCO-00011  The step runRSWBOINS with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS was executed with status ERROR .

INFO 2014-03-25 22:30:04

An error occured and the user decided to retry the current step: "|NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS".

INFO 2014-03-25 22:30:04

RFC parameter CLIENT set to value 000.

INFO 2014-03-25 22:30:04

RFC parameter USER set to value DDIC.

INFO 2014-03-25 22:30:04

RFC parameter LCHECK set to value 1.

INFO 2014-03-25 22:30:04

RFC parameter PCS set to value 1.

INFO 2014-03-25 22:30:04

RFC parameter LANG set to value EN.

INFO 2014-03-25 22:30:04

RFC parameter ASHOST set to value ecc.

INFO 2014-03-25 22:30:04

RFC parameter SYSNR set to value 00.

INFO 2014-03-25 22:30:04

RFC connection information checked successfully.

ERROR 2014-03-25 22:30:05

FRF-00007  Unable to open RFC connection.

ERROR 2014-03-25 22:30:05

MUT-03025  Caught ERfcExcept in Modulecall: Connect to SAP gateway failedConnect_PM  GWHOST=ecc, GWSERV=sapgw00, SYSNR=00

ERROR 2014-03-25 22:30:05

FCO-00011  The step runRSWBOINS with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS was executed with status ERROR .

INFO 2014-03-25 22:30:07

An error occured and the user decided to retry the current step: "|NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS".

INFO 2014-03-25 22:30:07

RFC parameter CLIENT set to value 000.

INFO 2014-03-25 22:30:07

RFC parameter USER set to value DDIC.

INFO 2014-03-25 22:30:07

RFC parameter LCHECK set to value 1.

INFO 2014-03-25 22:30:07

RFC parameter PCS set to value 1.

INFO 2014-03-25 22:30:07

RFC parameter LANG set to value EN.

INFO 2014-03-25 22:30:07

RFC parameter ASHOST set to value ecc.

INFO 2014-03-25 22:30:07

RFC parameter SYSNR set to value 00.

INFO 2014-03-25 22:30:07

RFC connection information checked successfully.

ERROR 2014-03-25 22:30:08

FRF-00007  Unable to open RFC connection.

ERROR 2014-03-25 22:30:08

MUT-03025  Caught ERfcExcept in Modulecall: Connect to SAP gateway failedConnect_PM  GWHOST=ecc, GWSERV=sapgw00, SYSNR=00

ERROR 2014-03-25 22:30:08

FCO-00011  The step runRSWBOINS with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS was executed with status ERROR .

INFO 2014-03-25 23:35:32

An error occured and the user decided to retry the current step: "|NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS".

INFO 2014-03-25 23:35:32

RFC parameter CLIENT set to value 000.

INFO 2014-03-25 23:35:32

RFC parameter USER set to value DDIC.

INFO 2014-03-25 23:35:32

RFC parameter LCHECK set to value 1.

INFO 2014-03-25 23:35:32

RFC parameter PCS set to value 1.

INFO 2014-03-25 23:35:32

RFC parameter LANG set to value EN.

INFO 2014-03-25 23:35:32

RFC parameter ASHOST set to value ecc.

INFO 2014-03-25 23:35:32

RFC parameter SYSNR set to value 00.

INFO 2014-03-25 23:35:32

RFC connection information checked successfully.

ERROR 2014-03-25 23:35:33

FRF-00007  Unable to open RFC connection.

ERROR 2014-03-25 23:35:33

MUT-03025  Caught ERfcExcept in Modulecall: Connect to SAP gateway failedConnect_PM  GWHOST=ecc, GWSERV=sapgw00, SYSNR=00

ERROR 2014-03-25 23:35:33

FCO-00011  The step runRSWBOINS with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|1|0|runRSWBOINS was executed with status ERROR .

Regards

Abhijit

Former Member
0 Kudos

1. Is the system up and running and can you logon with both DDIC and SAP* user in client 000.                                          

2. If yes, proceed as follows:                                      

3. Logon with user DDIC in client 000 and execute the jobs RSWBOINS and RADDBDIFF in transaction SE38, if no errors then procced.                                      

4. Ensure that all sapinst-processes are stopped.Copy keydb.xml to keydb.xml.org and then modifiy keydb.xml as follows:                                                         

Look for the string SAPINST_INST_STATUS and afterwards for the             

string CDATA[ERROR] replace 'CDATA[ERROR]' by 'CDATA[OK]'.                 

5. Proceed with the installation as usual.

If RADDBDIFF doesn't exist, still follow all the steps with RSWBOINS.

If it dont runs please check installation log for rswboins in your installation directory.

Olaf

Former Member
0 Kudos

Hi,

System is not running, that's why i started re-installation. This error is getting in last stage of face 42 to 43. so now what to do next.

Regards

Abhijit

Former Member
0 Kudos

If it is the last step of the sap installation sap is up and running. I´m a little bit irritated about your gateway host name:

MUT-03025  Caught ERfcExcept in Modulecall: Connect to SAP gateway failedConnect_PM  GWHOST=ecc, GWSERV=sapgw00, SYSNR=00

In my opinion this should be the server name. If ECC is correct then ok but I´m in doubt with this. But if sap is up and running you can login into client 000 and run the report rswboins in se38.

Regards

Olaf

Former Member
0 Kudos

Hi,

ECC is a server name but SAP is not running.

Regards

Abhijit

Former Member
0 Kudos

Hello,

ok, are you able to start database or is it up? If yes then take a R3trans -d as <SID>adm and send the log file for this?

If sap is not online are you able to start this?

Regards

Olaf

Former Member
0 Kudos

Hi,

Database is working & here, i shared trans log as follows.

4 ETW000 R3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 24.03.2014 - 21:06:09

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [dev trc     ,00000]  Mon Mar 24 21:06:12 2014                            1001  0.001001

4 ETW000  [dev trc     ,00000]  db_con_init called                                    84  0.001085

4 ETW000  [dev trc     ,00000]  create_con (con_name=R/3)                            235  0.001320

4 ETW000  [dev trc     ,00000]  Loading DB library 'dbdb6slib.dll' ...                68  0.001388

4 ETW000  [dev trc     ,00000]  load shared library (dbdb6slib.dll), hdl 0         74322  0.075710

4 ETW000  [dev trc     ,00000]      using "D:\usr\sap\SAN\SYS\exe\uc\NTAMD64\dbdb6slib.dll"

4 ETW000                                                                              24  0.075734

4 ETW000  [dev trc     ,00000]  Library 'dbdb6slib.dll' loaded                         8  0.075742

4 ETW000  [dev trc     ,00000]  function DbSlExpFuns loaded from library dbdb6slib.dll

4 ETW000                                                                              19  0.075761

4 ETW000  [dev trc     ,00000]  Version of 'dbdb6slib.dll' is "700.08", patchlevel (0.52)

4 ETW000                                                                          296197  0.371958

4 ETW000  [dev trc     ,00000]  function dsql_db_init loaded from library dbdb6slib.dll

4 ETW000                                                                              36  0.371994

4 ETW000  [dev trc     ,00000]  function dbdd_exp_funs loaded from library dbdb6slib.dll

4 ETW000                                                                              25  0.372019

4 ETW000  [dev trc     ,00000]  New connection 0 created                             570  0.372589

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                              40  0.372629

4 ETW000  [dev trc     ,00000]  db_con_connect (con_name=R/3)                         30  0.372659

4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection for reuse:

4 ETW000                                                                              12  0.372671

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                              14  0.372685

4 ETW000  [dev trc     ,00000]  DB6 (DB2 UDB) UNICODE database interface 700.08 [opt]

4 ETW000                                                                           22202  0.394887

4 ETW000  [dev trc     ,00000]  DB6 shared library (dbdb6slib) patchlevels            13  0.394900

4 ETW000  [dev trc     ,00000]    (0.8) DB6: V8.2.2 optguidelines in OPEN SQL (note 150037)

4 ETW000                                                                              32  0.394932

4 ETW000  [dev trc     ,00000]    (0.8) Support of SDBUPDEXCL (note 847616)            7  0.394939

4 ETW000  [dev trc     ,00000]    (0.9) DB6: use export file for dbdb6slib (note 835135)

4 ETW000                                                                              15  0.394954

4 ETW000  [dev trc     ,00000]    (0.9) DB6: Core in getAndBindSQLDA (note 833183)

4 ETW000                                                                               9  0.394963

4 ETW000  [dev trc     ,00000]    (0.10) DB6: link dbdb6slib.dll on windows with libdb6.obj (note 761159)

4 ETW000                                                                              11  0.394974

4 ETW000  [dev trc     ,00000]    (0.10) DB6: DUPLICATE_KEY on MERGE -> repeat (note 851474)

4 ETW000                                                                              78  0.395052

4 ETW000  [dev trc     ,00000]    (0.15) DB6: wrong CAST for short string ABAP type (note 861905)

4 ETW000                                                                              37  0.395089

4 ETW000  [dev trc     ,00000]    (0.17) DB6: special characters in sidadm passwd (note 865839)

4 ETW000                                                                              15  0.395104

4 ETW000  [dev trc     ,00000]    (0.21) DB6: no SAP_INFO comments (note 873889)

4 ETW000                                                                              14  0.395118

4 ETW000  [dev trc     ,00000]    (0.22) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000                                                                              10  0.395128

4 ETW000  [dev trc     ,00000]    (0.23) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000                                                                              15  0.395143

4 ETW000  [dev trc     ,00000]    (0.26) DB6: DB6_DBSL_CLP_COMMAND STRING_BAD_REF (note 883402)

4 ETW000                                                                              14  0.395157

4 ETW000  [dev trc     ,00000]    (0.27) DB6: activate value compression (note 886231)

4 ETW000                                                                               9  0.395166

4 ETW000  [dev trc     ,00000]    (0.28) DB6: optimization guidelines on views part 2 (note 868888)

4 ETW000                                                                              10  0.395176

4 ETW000  [dev trc     ,00000]    (0.30) DB6: no SQL trace for SQLCancel (note 892111)

4 ETW000                                                                              14  0.395190

4 ETW000  [dev trc     ,00000]    (0.33) DB6: append SAP_TA comment (note 873889)

4 ETW000                                                                              13  0.395203

4 ETW000  [dev trc     ,00000]    (0.34) DB6: activate value compression with quoted names (note 886231)

4 ETW000                                                                              11  0.395214

4 ETW000  [dev trc     ,00000]    (0.36) DB6: Repeat isolated DDL statements after SQL0911 (note 901338)

4 ETW000                                                                              14  0.395228

4 ETW000  [dev trc     ,00000]    (0.41) DB6: add V9 to list of supported DB2 releases (note 912386)

4 ETW000                                                                              15  0.395243

4 ETW000  [dev trc     ,00000]    (0.50) DB6: reread passwords for secondary connections (note 931742)

4 ETW000                                                                              14  0.395257

4 ETW000  [dev trc     ,00000]    (0.52) DB6: double quote table names in optguidelines (note 868888)

4 ETW000                                                                              14  0.395271

4 ETW000  [dev trc     ,00000]  Supported features:                                    6  0.395277

4 ETW000  [dev trc     ,00000]    - CLI LOAD for INSERT ... FULLSELECT                 7  0.395284

4 ETW000  [dev trc     ,00000]  ..retrieving configuration parameters                  6  0.395290

4 ETW000  [dev trc     ,00000]  ..done                                               284  0.395574

4 ETW000  [dev trc     ,00000]  Running with UTF-8 Unicode                             7  0.395581

4 ETW000  [dev trc     ,00000]  Mon Mar 24 21:06:13 2014                         1229962  1.625543

4 ETW000  [dev trc     ,00000]  DB2 client driver version '09.07.0009'                49  1.625592

4 ETW000  [dev trc     ,00000]  Connected to DB2 version '09.07.0009'                 44  1.625636

4 ETW000  [dev trc     ,00000]  Code page check canceled on this server ( sqlfxdb: rc= -1013 ) -> to be ignored

4 ETW000                                                                           11924  1.637560

4 ETW000  [dev trc     ,00000]  *** ERROR in ExecuteDirect[dbdb6.c, 5148] (BEGIN)

4 ETW000                                                                          169670  1.807230

4 ETW000  [dev trc     ,00000]  &+     DbSlConnectDB6( SQLExecDirect 😞 [IBM][CLI Driver][LU62SPM] SQL30070N  "Unsupported function for SPMDB connect" Co

4 ETW000                                                                              18  1.807248

4 ETW000  [dev trc     ,00000]  &+     mmand is not supported.  SQLSTATE=58014                                                                         

4 ETW000                                                                              14  1.807262

4 ETW000  [dev trc     ,00000]  &+                                                                                                                     

4 ETW000                                                                              13  1.807275

4 ETW000  [dev trc     ,00000]  &+     SET CURRENT SCHEMA 'SAPSAN' -- SYSTEM( SAN , SAPSAN )                                                           

4 ETW000                                                                              14  1.807289

4 ETW000  [dev trc     ,00000]  &+                                                                                                                     

4 ETW000                                                                              14  1.807303

4 ETW000  [dev trc     ,00000]  &+                                                                                                                     

4 ETW000                                                                              13  1.807316

4 ETW000  [dev trc     ,00000]  *** ERROR in ExecuteDirect[dbdb6.c, 5148] (END)        8  1.807324

4 ETW000  [dev trc     ,00000]  Mon Mar 24 21:06:14 2014                          155502  1.962826

4 ETW000  [dev trc     ,00000]  *** ERROR in prepareStatement[dbdb6.c, 10607] (BEGIN)

4 ETW000                                                                              22  1.962848

4 ETW000  [dev trc     ,00000]  &+     DbSlConnectDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][LU62SPM] SQL30070N  "Unsupported function for SPMDB connec

4 ETW000                                                                              15  1.962863

4 ETW000  [dev trc     ,00000]  &+     t" Command is not supported.  SQLSTATE=58014                                                                    

4 ETW000                                                                              13  1.962876

4 ETW000  [dev trc     ,00000]  &+                                                                                                                     

4 ETW000                                                                              13  1.962889

4 ETW000  [dev trc     ,00000]  &+     SELECT COUNT(*) FROM TABLE( REG_LIST_VARIABLES() ) AS X  WHERE REG_VAR_NAME = 'DB2_WORKLOAD' AND UPPER( REG_VAR_VA

4 ETW000                                                                              14  1.962903

4 ETW000  [dev trc     ,00000]  &+     LUE ) = 'SAP'                                                                                                   

4 ETW000                                                                              13  1.962916

4 ETW000  [dev trc     ,00000]  &+       cursor type=NO_HOLD, isolation=UR, cc_release=NO, optlevel=5, degree=0, buffer_lobs=YES, op_type=40, reopt=0  

4 ETW000                                                                              17  1.962933

4 ETW000  [dev trc     ,00000]  &+                                                                                                                     

4 ETW000                                                                              14  1.962947

4 ETW000  [dev trc     ,00000]  &+                                                                                                                     

4 ETW000                                                                              13  1.962960

4 ETW000  [dev trc     ,00000]  *** ERROR in prepareStatement[dbdb6.c, 10607] (END)

4 ETW000                                                                              55  1.963015

4 ETW000  [dev trc     ,00000]  Could not check DB2 registry settings.                22  1.963037

4 ETW000  [dev trc     ,00000]  disconnected from 'ECC', con_hdl=0                 10358  1.973395

2EETW169 no connect possible: "DBMS = DB6                              --- DB2DBDFT = 'ECC'"

Regards

Abhijit

Former Member
0 Kudos

Hi,

sorry but this is an old R3trans -d after this you told you reinstall database and sap so now you should post a new R3trans -d from now.

Regards

Olaf

Former Member
0 Kudos

Hi,

Sorry for this sharing Trans.log as follows on today.

4 ETW000 R3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 27.03.2014 - 21:11:46

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [dev trc     ,00000]  Thu Mar 27 21:11:48 2014                            1276  0.001276

4 ETW000  [dev trc     ,00000]  db_con_init called                                    37  0.001313

4 ETW000  [dev trc     ,00000]  create_con (con_name=R/3)                            154  0.001467

4 ETW000  [dev trc     ,00000]  Loading DB library 'dbdb6slib.dll' ...                39  0.001506

4 ETW000  [dev trc     ,00000]  load shared library (dbdb6slib.dll), hdl 0         64607  0.066113

4 ETW000  [dev trc     ,00000]      using "D:\usr\sap\SAN\SYS\exe\uc\NTAMD64\dbdb6slib.dll"

4 ETW000                                                                              44  0.066157

4 ETW000  [dev trc     ,00000]  Library 'dbdb6slib.dll' loaded                         7  0.066164

4 ETW000  [dev trc     ,00000]  function DbSlExpFuns loaded from library dbdb6slib.dll

4 ETW000                                                                              12  0.066176

4 ETW000  [dev trc     ,00000]  Thu Mar 27 21:11:49 2014                          322892  0.389068

4 ETW000  [dev trc     ,00000]  Version of 'dbdb6slib.dll' is "700.08", patchlevel (0.52)

4 ETW000                                                                             125  0.389193

4 ETW000  [dev trc     ,00000]  function dsql_db_init loaded from library dbdb6slib.dll

4 ETW000                                                                             165  0.389358

4 ETW000  [dev trc     ,00000]  function dbdd_exp_funs loaded from library dbdb6slib.dll

4 ETW000                                                                              34  0.389392

4 ETW000  [dev trc     ,00000]  New connection 0 created                             621  0.390013

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                              41  0.390054

4 ETW000  [dev trc     ,00000]  db_con_connect (con_name=R/3)                         80  0.390134

4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection for reuse:

4 ETW000                                                                              12  0.390146

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                              14  0.390160

4 ETW000  [dev trc     ,00000]  DB6 (DB2 UDB) UNICODE database interface 700.08 [opt]

4 ETW000                                                                           19403  0.409563

4 ETW000  [dev trc     ,00000]  DB6 shared library (dbdb6slib) patchlevels             8  0.409571

4 ETW000  [dev trc     ,00000]    (0.8) DB6: V8.2.2 optguidelines in OPEN SQL (note 150037)

4 ETW000                                                                              53  0.409624

4 ETW000  [dev trc     ,00000]    (0.8) Support of SDBUPDEXCL (note 847616)            7  0.409631

4 ETW000  [dev trc     ,00000]    (0.9) DB6: use export file for dbdb6slib (note 835135)

4 ETW000                                                                              10  0.409641

4 ETW000  [dev trc     ,00000]    (0.9) DB6: Core in getAndBindSQLDA (note 833183)

4 ETW000                                                                              10  0.409651

4 ETW000  [dev trc     ,00000]    (0.10) DB6: link dbdb6slib.dll on windows with libdb6.obj (note 761159)

4 ETW000                                                                              10  0.409661

4 ETW000  [dev trc     ,00000]    (0.10) DB6: DUPLICATE_KEY on MERGE -> repeat (note 851474)

4 ETW000                                                                             100  0.409761

4 ETW000  [dev trc     ,00000]    (0.15) DB6: wrong CAST for short string ABAP type (note 861905)

4 ETW000                                                                              10  0.409771

4 ETW000  [dev trc     ,00000]    (0.17) DB6: special characters in sidadm passwd (note 865839)

4 ETW000                                                                              10  0.409781

4 ETW000  [dev trc     ,00000]    (0.21) DB6: no SAP_INFO comments (note 873889)

4 ETW000                                                                               9  0.409790

4 ETW000  [dev trc     ,00000]    (0.22) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000                                                                              11  0.409801

4 ETW000  [dev trc     ,00000]    (0.23) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000                                                                              10  0.409811

4 ETW000  [dev trc     ,00000]    (0.26) DB6: DB6_DBSL_CLP_COMMAND STRING_BAD_REF (note 883402)

4 ETW000                                                                              10  0.409821

4 ETW000  [dev trc     ,00000]    (0.27) DB6: activate value compression (note 886231)

4 ETW000                                                                               9  0.409830

4 ETW000  [dev trc     ,00000]    (0.28) DB6: optimization guidelines on views part 2 (note 868888)

4 ETW000                                                                              10  0.409840

4 ETW000  [dev trc     ,00000]    (0.30) DB6: no SQL trace for SQLCancel (note 892111)

4 ETW000                                                                              10  0.409850

4 ETW000  [dev trc     ,00000]    (0.33) DB6: append SAP_TA comment (note 873889)

4 ETW000                                                                               9  0.409859

4 ETW000  [dev trc     ,00000]    (0.34) DB6: activate value compression with quoted names (note 886231)

4 ETW000                                                                              10  0.409869

4 ETW000  [dev trc     ,00000]    (0.36) DB6: Repeat isolated DDL statements after SQL0911 (note 901338)

4 ETW000                                                                              10  0.409879

4 ETW000  [dev trc     ,00000]    (0.41) DB6: add V9 to list of supported DB2 releases (note 912386)

4 ETW000                                                                              10  0.409889

4 ETW000  [dev trc     ,00000]    (0.50) DB6: reread passwords for secondary connections (note 931742)

4 ETW000                                                                              10  0.409899

4 ETW000  [dev trc     ,00000]    (0.52) DB6: double quote table names in optguidelines (note 868888)

4 ETW000                                                                              10  0.409909

4 ETW000  [dev trc     ,00000]  Supported features:                                    6  0.409915

4 ETW000  [dev trc     ,00000]    - CLI LOAD for INSERT ... FULLSELECT                 7  0.409922

4 ETW000  [dev trc     ,00000]  ..retrieving configuration parameters                  6  0.409928

4 ETW000  [dev trc     ,00000]  ..done                                               312  0.410240

4 ETW000  [dev trc     ,00000]  Running with UTF-8 Unicode                             8  0.410248

4 ETW000  [dev trc     ,00000]  *** ERROR in DB6Connect[dbdb6.c, 1379] (BEGIN)    445081  0.855329

4 ETW000  [dev trc     ,00000]  &+     DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL1013N  The database alias name or database name "ECC" could not

4 ETW000                                                                              98  0.855427

4 ETW000  [dev trc     ,00000]  &+      be found.  SQLSTATE=42705                                                                                       

4 ETW000                                                                              81  0.855508

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                              16  0.855524

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                              23  0.855547

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                              13  0.855560

4 ETW000  [dev trc     ,00000]  *** ERROR in DB6Connect[dbdb6.c, 1379] (END)           8  0.855568

4 ETW000  [dbdb6.c     ,00000]  *** ERROR => DbSlConnect to 'ECC' as 'sapsan' failed

4 ETW000                                                                            1315  0.856883

2EETW169 no connect possible: "DBMS = DB6                              --- DB2DBDFT = 'ECC'"

Regards

Abhijit

sivakumar_kilari3
Active Contributor
0 Kudos

Hi ,

Try this below command, and provide out put.



db2 list db directory




Thanks

siva


Former Member
0 Kudos

Hi,

Here, i mentioned below db2 list directory log.

C:\Documents and Settings\sanadm>db2 list db directory

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias                       = SAN

Database name                        = SAN

Local database directory             = C:

Database release level               = d.00

Comment                              =

Directory entry type                 = Indirect

Catalog database partition number    = 0

Alternate server hostname            =

Alternate server port number         =

C:\Documents and Settings\sanadm>

Regards

Abhijit

sivakumar_kilari3
Active Contributor
0 Kudos

Hi ,


4 ETW000  [dev trc     ,00000]  Running with UTF-8 Unicode                             8  0.410248

4 ETW000  [dev trc     ,00000]  *** ERROR in DB6Connect[dbdb6.c, 1379] (BEGIN)    445081  0.855329

4 ETW000  [dev trc     ,00000]  &+     DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL1013N  The database alias name or database name "ECC" could not

4 ETW000                                                                              98  0.855427

4 ETW000  [dev trc     ,00000]  &+      be found.  SQLSTATE=42705              

Database name is ecc or san ?

Thanks

siva

sivakumar_kilari3
Active Contributor
0 Kudos

Hi ,

Check below environmental variable

no connect possible: "DBMS = DB6                              -

DB2DBDFT = 'ECC'"     - I think this should be san not ecc



Thanks

Siva

Former Member
0 Kudos

Hi,

Database name is SAN as follows.

C:\Documents and Settings\sanadm>db2

(c) Copyright IBM Corporation 1993,2007

Command Line Processor for DB2 Client 9.7.9

You can issue database manager commands and SQL statements from the command

prompt. For example:

    db2 => connect to sample

    db2 => bind sample.bnd

For general help, type: ?.

For command help, type: ? command, where command can be

the first few keywords of a database manager command. For example:

? CATALOG DATABASE for help on the CATALOG DATABASE command

? CATALOG          for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside

interactive mode, all commands must be prefixed with 'db2'.

To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 => connect to san

   Database Connection Information

Database server        = DB2/NT64 9.7.9

SQL authorization ID   = SANADM

Local database alias   = SAN

db2 => connect to ecc

SQL1013N  The database alias name or database name "ECC" could not be found.

SQLSTATE=42705

db2 =>

Regards

Abhijit

sivakumar_kilari3
Active Contributor
0 Kudos

Hi ,

Please check environmental variables with sanadm & db2san users..

check below variable s

DB2DBDFT

Default value: <SAPSID>

DB2INSTANCE

Default value: db2<sapsid>

Thanks

siva

Former Member
0 Kudos

Hi,

I found this variable as follows.


From (SANADM USER VARIABLE)


DB2DBDFT ECC

DB2INSTANCE DB2ECC


Not found DB2SAN user. only DN2ECC or DB2admin user found in the user list of the server.


Regards

Abhijit

sivakumar_kilari3
Active Contributor
0 Kudos

hi ,

Change like below from sanadm user.

DB2DBDFT  SAN

DB2INSTANCE  DB2SAN


Thanks

siva


Former Member
0 Kudos

Hi,

I changed variable but error code (0012) is getting after executing command R3trans -d.

Regards

Abhijit

sivakumar_kilari3
Active Contributor
0 Kudos

Paste r3trans logs here

Restart the server and try r3trans. Paste the logs here.

Former Member
0 Kudos

Hi,

Trans.log as mentioned below.

4 ETW000 R3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 27.03.2014 - 22:56:18

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [dev trc     ,00000]  Thu Mar 27 22:56:20 2014                                  0.000000

4 ETW000  [dev trc     ,00000]  db_con_init called                                        0.000000

4 ETW000  [dev trc     ,00000]  create_con (con_name=R/3)                                 0.000000

4 ETW000  [dev trc     ,00000]  Loading DB library 'dbdb6slib.dll' ...                    0.000000

4 ETW000  [dev trc     ,00000]  load shared library (dbdb6slib.dll), hdl 0          7076  0.007076

4 ETW000  [dev trc     ,00000]      using "D:\usr\sap\SAN\SYS\exe\uc\NTAMD64\dbdb6slib.dll"

4 ETW000                                                                              51  0.007127

4 ETW000  [dev trc     ,00000]  Library 'dbdb6slib.dll' loaded                         8  0.007135

4 ETW000  [dev trc     ,00000]  function DbSlExpFuns loaded from library dbdb6slib.dll

4 ETW000                                                                              11  0.007146

4 ETW000  [dev trc     ,00000]  Version of 'dbdb6slib.dll' is "700.08", patchlevel (0.52)

4 ETW000                                                                           84995  0.092141

4 ETW000  [dev trc     ,00000]  function dsql_db_init loaded from library dbdb6slib.dll

4 ETW000                                                                              17  0.092158

4 ETW000  [dev trc     ,00000]  function dbdd_exp_funs loaded from library dbdb6slib.dll

4 ETW000                                                                              35  0.092193

4 ETW000  [dev trc     ,00000]  New connection 0 created                              59  0.092252

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                              21  0.092273

4 ETW000  [dev trc     ,00000]  db_con_connect (con_name=R/3)                         43  0.092316

4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection for reuse:

4 ETW000                                                                              12  0.092328

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                              14  0.092342

4 ETW000  [dev trc     ,00000]  DB6 (DB2 UDB) UNICODE database interface 700.08 [opt]

4 ETW000                                                                          143956  0.236298

4 ETW000  [dev trc     ,00000]  DB6 shared library (dbdb6slib) patchlevels            10  0.236308

4 ETW000  [dev trc     ,00000]    (0.8) DB6: V8.2.2 optguidelines in OPEN SQL (note 150037)

4 ETW000                                                                              33  0.236341

4 ETW000  [dev trc     ,00000]    (0.8) Support of SDBUPDEXCL (note 847616)            7  0.236348

4 ETW000  [dev trc     ,00000]    (0.9) DB6: use export file for dbdb6slib (note 835135)

4 ETW000                                                                              10  0.236358

4 ETW000  [dev trc     ,00000]    (0.9) DB6: Core in getAndBindSQLDA (note 833183)

4 ETW000                                                                               9  0.236367

4 ETW000  [dev trc     ,00000]    (0.10) DB6: link dbdb6slib.dll on windows with libdb6.obj (note 761159)

4 ETW000                                                                              10  0.236377

4 ETW000  [dev trc     ,00000]    (0.10) DB6: DUPLICATE_KEY on MERGE -> repeat (note 851474)

4 ETW000                                                                              74  0.236451

4 ETW000  [dev trc     ,00000]    (0.15) DB6: wrong CAST for short string ABAP type (note 861905)

4 ETW000                                                                              13  0.236464

4 ETW000  [dev trc     ,00000]    (0.17) DB6: special characters in sidadm passwd (note 865839)

4 ETW000                                                                              10  0.236474

4 ETW000  [dev trc     ,00000]    (0.21) DB6: no SAP_INFO comments (note 873889)

4 ETW000                                                                               9  0.236483

4 ETW000  [dev trc     ,00000]    (0.22) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000                                                                              10  0.236493

4 ETW000  [dev trc     ,00000]    (0.23) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000                                                                              10  0.236503

4 ETW000  [dev trc     ,00000]    (0.26) DB6: DB6_DBSL_CLP_COMMAND STRING_BAD_REF (note 883402)

4 ETW000                                                                              10  0.236513

4 ETW000  [dev trc     ,00000]    (0.27) DB6: activate value compression (note 886231)

4 ETW000                                                                              10  0.236523

4 ETW000  [dev trc     ,00000]    (0.28) DB6: optimization guidelines on views part 2 (note 868888)

4 ETW000                                                                              10  0.236533

4 ETW000  [dev trc     ,00000]    (0.30) DB6: no SQL trace for SQLCancel (note 892111)

4 ETW000                                                                               9  0.236542

4 ETW000  [dev trc     ,00000]    (0.33) DB6: append SAP_TA comment (note 873889)

4 ETW000                                                                              10  0.236552

4 ETW000  [dev trc     ,00000]    (0.34) DB6: activate value compression with quoted names (note 886231)

4 ETW000                                                                              10  0.236562

4 ETW000  [dev trc     ,00000]    (0.36) DB6: Repeat isolated DDL statements after SQL0911 (note 901338)

4 ETW000                                                                              10  0.236572

4 ETW000  [dev trc     ,00000]    (0.41) DB6: add V9 to list of supported DB2 releases (note 912386)

4 ETW000                                                                              10  0.236582

4 ETW000  [dev trc     ,00000]    (0.50) DB6: reread passwords for secondary connections (note 931742)

4 ETW000                                                                              10  0.236592

4 ETW000  [dev trc     ,00000]    (0.52) DB6: double quote table names in optguidelines (note 868888)

4 ETW000                                                                              10  0.236602

4 ETW000  [dev trc     ,00000]  Supported features:                                    6  0.236608

4 ETW000  [dev trc     ,00000]    - CLI LOAD for INSERT ... FULLSELECT                 6  0.236614

4 ETW000  [dev trc     ,00000]  ..retrieving configuration parameters                  7  0.236621

4 ETW000  [dev trc     ,00000]  ..done                                               290  0.236911

4 ETW000  [dev trc     ,00000]  Running with UTF-8 Unicode                             8  0.236919

4 ETW000  [dev trc     ,00000]  Thu Mar 27 22:56:24 2014                         4225409  4.462328

4 ETW000  [dev trc     ,00000]  DB2 client driver version '09.07.0009'                75  4.462403

4 ETW000  [dev trc     ,00000]  Connected to DB2 version '09.07.0009'                111  4.462514

4 ETW000  [dev trc     ,00000]  IMPORTANT NOTICE:                                  34854  4.497368

4 ETW000  [dev trc     ,00000]  -----------------                                    155  4.497523

4 ETW000  [dev trc     ,00000]  Your database has not been created with the right collation sequence.

4 ETW000                                                                              65  4.497588

4 ETW000  [dev trc     ,00000]  SAP databases must be created with collating sequence

4 ETW000                                                                              12  4.497600

4 ETW000  [dev trc     ,00000]  IDENTITY for non unicode systems or IDENTITY_16BIT for unicode systems.

4 ETW000                                                                              11  4.497611

4 ETW000  [dev trc     ,00000]  Other collating sequences may lead to unexpected sorting problems and are not supported.

4 ETW000                                                                              11  4.497622

4 ETW000  [dev trc     ,00000]                                                         5  4.497627

4 ETW000  [dev trc     ,00000]  If you temporarily need to override this check,       15  4.497642

4 ETW000  [dev trc     ,00000]  please refer to note 376746 .                          8  4.497650

4 ETW000  [dev trc     ,00000]  *** ERROR in checkCodepageSettings[dbdb6.c, 13448] (BEGIN)

4 ETW000                                                                             229  4.497879

4 ETW000  [dev trc     ,00000]  &+     DbSlConnectDB6: Database has been created with wrong collating sequence.                                         

4 ETW000                                                                              15  4.497894

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                              55  4.497949

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                              26  4.497975

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                              14  4.497989

4 ETW000  [dev trc     ,00000]  *** ERROR in checkCodepageSettings[dbdb6.c, 13448] (END)

4 ETW000                                                                              11  4.498000

2EETW169 no connect possible: "DBMS = DB6                              --- DB2DBDFT = 'SAN'"

Regards

Abhijit

sivakumar_kilari3
Active Contributor
0 Kudos

Hi ,

Now error is different , please check below mentioned sap note.


4 ETW000  [dev trc     ,00000]  IMPORTANT NOTICE:                                  34854  4.497368

4 ETW000  [dev trc     ,00000]  -----------------                                    155  4.497523

4 ETW000  [dev trc     ,00000]  Your database has not been created with the right collation sequence.

4 ETW000                                                                              65  4.497588

4 ETW000  [dev trc     ,00000]  SAP databases must be created with collating sequence

4 ETW000                                                                              12  4.497600

4 ETW000  [dev trc     ,00000]  IDENTITY for non unicode systems or IDENTITY_16BIT for unicode systems.

4 ETW000                                                                              11  4.497611

4 ETW000  [dev trc     ,00000]  Other collating sequences may lead to unexpected sorting problems and are not supported.

4 ETW000                                                                              11  4.497622

4 ETW000  [dev trc     ,00000]                                                         5  4.497627

4 ETW000  [dev trc     ,00000]  If you temporarily need to override this check,       15  4.497642

4 ETW000  [dev trc     ,00000]  please refer to note 376746 .                          8  4.497650

4 ETW000  [dev trc     ,00000]  *** ERROR in checkCodepageSettings[dbdb6.c, 13448] (BEGIN)

4 ETW000                                                                             229  4.497879

4 ETW000  [dev trc     ,00000]  &+     DbSlConnectDB6: Database has been created with wrong collating sequence.                                        

4 ETW000                                                                              15  4.497894

4 ETW000  [dev trc     ,00000]  &+                                                                                                                     

4 ETW000                                                                              55  4.497949

4 ETW000  [dev trc     ,00000]  &+                                                                                                                     

4 ETW000                                                                              26  4.497975

4 ETW000  [dev trc     ,00000]  &+                                                                                                                     

4 ETW000                                                                              14  4.497989

4 ETW000  [dev trc     ,00000]  *** ERROR in checkCodepageSettings[dbdb6.c, 13448] (END)

4 ETW000                                                                              11  4.498000

2EETW169 no connect possible: "DBMS = DB6                              --- DB2DBDFT = 'SAN'"

376746 - DB6: Display of COLLATING SEQUENCE from database




Thanks

siva

Former Member
0 Kudos

Hi,

As per this note 376746, I applied as follows.

C:\Documents and Settings\sanadm>

C:\Documents and Settings\sanadm>db6util -dg COLLATE_INFO

This is the DB6 (DB2 UDB) utility program for SAP kernel 700.

(I) Performing actions for option -dg COLLATE_INFO .

(I) Starttime: 20140327231922

(I) Connecting to SAN as user sanadm .

(I) Successfully connected to database SAN .

(I) Disconnected from database.

(I) Endtime: 20140327231925

COLLATE_INFO x'000102030405060708090A0B0C0D0E0F101112131415161718191A1B1C1D1E1F2

02122232425262728292A2B2C2D2E2F303132333435363738393A3B3C3D3E3F40414243444546474

8494A4B4C4D4E4F505152535455565758595A5B5C5D5E5F606162636465666768696A6B6C6D6E6F7

07172737475767778797A7B7C7D7E7F808182838485868788898A8B8C8D8E8F90919293949596979

8999A9B9C9D9E9FA0A1A2A3A4A5A6A7A8A9AAABACADAEAFB0B1B2B3B4B5B6B7B8B9BABBBCBDBEBFC

0C1C2C3C4C5C6C7C8C9CACBCCCDCECFD0D1D2D3D4D5D6D7D8D9DADBDCDDDEDFE0E1E2E3E4E5E6E7E

8E9EAEBECEDEEEFF0F1F2F3F4F5F6F7F8F9FAFBFCFDFEFF02000000' ( IDENTITY )

db6util  successfully finished (exit 0).

C:\Documents and Settings\sanadm>R3trans -d

This is R3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = DB6                              --- DB2DB

DFT = 'SAN'"

R3trans finished (0012).

C:\Documents and Settings\sanadm>

Regards

Abhijit

sivakumar_kilari3
Active Contributor
0 Kudos

Hi ,

As per this note : 376746 - DB6: Display of COLLATING SEQUENCE from database

please find below instructions.

If the establishing of a connection to your database is cancelled by the SAP kernel due to an incorrect sort sequence of the database, that security check can be deactivated via a profile parameter or an environment variable.

Environment:  DB6_DBSL_IGNORE_COLLATE_INFO=1

or

Profile:      dbs/db6/dbsl_ignore_collate_info=1

CAUTION:

If you decide to ignore an incorrect sort sequence of the database, this is at your own risk. Do not use such a system for production. Database which were created with an incorrect sort sequence are not supported by SAP



Thanks

siva

Former Member
0 Kudos

Could you please also share dev_w0 trace file.

Regards

Olaf

Former Member
0 Kudos

Hi,

can you please confirm on below steps.

1.Have you changed any IP's after installation?

2.What is the DB2 Fix pack version and patch level?

3.could you please paste R3trans -d log (trans.log)

Regrads,

Balaram

Former Member
0 Kudos

Hi,

As well as here, I shared dev_disp log as follows.

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

trc file: "dev_disp", trc level: 1, release: "700"

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

sysno      00

sid        SAN

systemid   562 (PC with Windows NT)

relno      7000

patchlevel 0

patchno    52

intno      20050900

make:      multithreaded, Unicode, 64 bit, optimized

pid        3016

Sun Mar 23 16:44:12 2014

kernel runs with dp version 210000(ext=109000) (@(#) DPLIB-INT-VERSION-210000-UC)

length of sys_adm_ext is 572 bytes

*** SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (00 3016) [dpxxdisp.c   1231]

  shared lib "dw_xml.dll" version 52 successfully loaded

  shared lib "dw_xtc.dll" version 52 successfully loaded

  shared lib "dw_stl.dll" version 52 successfully loaded

  shared lib "dw_gui.dll" version 52 successfully loaded

rdisp/softcancel_sequence :  -> 0,5,-1

use internal message server connection to port 3900

Sun Mar 23 16:44:26 2014

*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 14 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c  5233]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: VMC (JAVA VM in WP) is not active

DpIPCInit2: start server >ecc_SAN_00                              <

DpShMCreate: sizeof(wp_adm) 12816 (1424)

DpShMCreate: sizeof(tm_adm) 5217968 (25960)

DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

DpShMCreate: sizeof(comm_adm) 552080 (1088)

DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (1760)

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

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000F150050, size: 5901456)

DpShMCreate: allocated sys_adm at 000000000F150050

DpShMCreate: allocated wp_adm at 000000000F151EE0

DpShMCreate: allocated tm_adm_list at 000000000F1550F0

DpShMCreate: allocated tm_adm at 000000000F155150

DpShMCreate: allocated wp_ca_adm at 000000000F64F000

DpShMCreate: allocated appc_ca_adm at 000000000F654DC0

DpShMCreate: allocated comm_adm at 000000000F656D00

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 000000000F6DD990

DpShMCreate: allocated gw_adm at 000000000F6DDA10

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 000000000F6DDA40

DpShMCreate: allocated wall_adm at 000000000F6DDA50

MBUF state OFF

Sun Mar 23 16:44:27 2014

EmInit: MmSetImplementation( 2 ).

MM diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 4096 kByte.

Using implementation flat

<EsNT> Memory Reset disabled as NT default

<ES> 127 blocks reserved for free list.

ES initialized.

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c   1617]

***LOG Q0K=> DpMsAttach, mscon ( ecc) [dpxxdisp.c   11414]

Sun Mar 23 16:44:28 2014

DpStartStopMsg: send start message (myname is >ecc_SAN_00                              <)

DpStartStopMsg: start msg sent

Sun Mar 23 16:44:29 2014

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

Sun Mar 23 16:44:30 2014

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 7000, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c   1050]

DpMsgAdmin: Set patchno for this platform to 52

Release check o.K.

Sun Mar 23 16:45:09 2014

*** ERROR => W0 (pid 2188) died [dpxxdisp.c   14021]

*** ERROR => W1 (pid 2196) died [dpxxdisp.c   14021]

*** ERROR => W2 (pid 1584) died [dpxxdisp.c   14021]

*** ERROR => W3 (pid 1632) died [dpxxdisp.c   14021]

my types changed after wp death/restart 0xbf --> 0xbe

*** ERROR => W4 (pid 740) died [dpxxdisp.c   14021]

my types changed after wp death/restart 0xbe --> 0xbc

*** ERROR => W5 (pid 2372) died [dpxxdisp.c   14021]

my types changed after wp death/restart 0xbc --> 0xb8

*** ERROR => W6 (pid 580) died [dpxxdisp.c   14021]

my types changed after wp death/restart 0xb8 --> 0xb0

*** ERROR => W7 (pid 1640) died [dpxxdisp.c   14021]

my types changed after wp death/restart 0xb0 --> 0xa0

*** ERROR => W8 (pid 1528) died [dpxxdisp.c   14021]

my types changed after wp death/restart 0xa0 --> 0x80

*** DP_FATAL_ERROR => DpWPCheck: no more work processes

*** DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:19 2014

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Sun Mar 23 11:15:19 2014

========================

No Ty. Pid      Status  Cause Start Err Sem CPU    Time  Program  Cl  User         Action                    Table

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

0 DIA     2188 Ended         no      1   0             0                                                             

1 DIA     2196 Ended         no      1   0             0                                                             

2 DIA     1584 Ended         no      1   0             0                                                             

3 DIA     1632 Ended         no      1   0             0                                                             

4 UPD      740 Ended         no      1   0             0                                                             

5 ENQ     2372 Ended         no      1   0             0                                                             

6 BTC      580 Ended         no      1   0             0                                                             

7 SPO     1640 Ended         no      1   0             0                                                             

8 UP2     1528 Ended         no      1   0             0                                                             

Dispatcher Queue Statistics Sun Mar 23 11:15:19 2014

===========================

+------+--------+--------+--------+--------+--------+

|  Typ |    now |   high |    max | writes |  reads |

+------+--------+--------+--------+--------+--------+

| NOWP |      0 |      2 |   2000 |      6 |      6 |

+------+--------+--------+--------+--------+--------+

|  DIA |      5 |      5 |   2000 |      5 |      0 |

+------+--------+--------+--------+--------+--------+

|  UPD |      0 |      0 |   2000 |      0 |      0 |

+------+--------+--------+--------+--------+--------+

|  ENQ |      0 |      0 |   2000 |      0 |      0 |

+------+--------+--------+--------+--------+--------+

|  BTC |      0 |      0 |   2000 |      0 |      0 |

+------+--------+--------+--------+--------+--------+

|  SPO |      0 |      0 |   2000 |      0 |      0 |

+------+--------+--------+--------+--------+--------+

|  UP2 |      0 |      0 |   2000 |      0 |      0 |

+------+--------+--------+--------+--------+--------+

max_rq_id 12

wake_evt_udp_now 0

wake events       total     8,  udp     7 ( 87%),  shm     1 ( 12%)

since last update total     8,  udp     7 ( 87%),  shm     1 ( 12%)

Dump of tm_adm structure: Sun Mar 23 11:15:19 2014

=========================

Term    uid  man user    term   lastop  mod wp  ta   a/i (modes)

Workprocess Comm. Area Blocks Sun Mar 23 11:15:19 2014

=============================

Slots: 300, Used: 1, Max: 0

+------+--------------+----------+-------------+

|   id | owner        |   pid    | eyecatcher  |

+------+--------------+----------+-------------+

|    0 | DISPATCHER   |       -1 | *WPCAAD000* |

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:24 2014

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >ecc_SAN_00                              < (normal)

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIModState: change state to SHUTDOWN

DpModState: change server state from STARTING to SHUTDOWN

Switch off Shared memory profiling

ShmProtect( 57, 3 )

ShmProtect(SHM_PROFILE, SHM_PROT_RW

ShmProtect( 57, 1 )

ShmProtect(SHM_PROFILE, SHM_PROT_RD

DpWakeUpWps: wake up all wp's

Stop work processes

Stop gateway

killing process (1620) (SOFT_KILL)

Stop icman

killing process (2128) (SOFT_KILL)

Terminate gui connections

wait for end of work processes

wait for end of gateway

[DpProcDied] Process lives  (PID:1620  HANDLE:340)

waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:25 2014

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died  (PID:1620  HANDLE:340)

wait for end of icman

[DpProcDied] Process lives  (PID:2128  HANDLE:348)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:26 2014

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2128  HANDLE:348)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:27 2014

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2128  HANDLE:348)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:28 2014

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2128  HANDLE:348)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:29 2014

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2128  HANDLE:348)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:30 2014

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2128  HANDLE:348)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:31 2014

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2128  HANDLE:348)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:32 2014

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2128  HANDLE:348)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:33 2014

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2128  HANDLE:348)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:34 2014

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2128  HANDLE:348)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:35 2014

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:2128  HANDLE:348)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=373

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Mar 23 16:45:36 2014

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died  (PID:2128  HANDLE:348)

DpStartStopMsg: send stop message (myname is >ecc_SAN_00                              <)

NiIMyHostName: hostname = 'ecc'

AdGetSelfIdentRecord: >                                                                           <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0

DpConvertRequest: net size = 189 bytes

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=562,pac=1,MESG_IO)

MsINiWrite: sent 562 bytes

send msg (len 110+452) to name                    -, type 4, key -

DpStartStopMsg: stop msg sent

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 recv would block (errno=EAGAIN)

NiIRead: read for hdl 2 timed out (0ms)

DpHalt: no more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=114,pac=1,MESG_IO)

MsINiWrite: sent 114 bytes

send msg (len 110+4) to name           MSG_SERVER, type 0, key -

MsSndName: MS_NOOP ok

Send 4 bytes to MSG_SERVER

NiIRead: hdl 2 recv would block (errno=EAGAIN)

NiIPeek: peek successful for hdl 2 (r)

NiIRead: hdl 2 received data (rcd=114,pac=1,MESG_IO)

NiBufIIn: NIBUF len=114

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 114 bytes

MSG received, len 110+4, flag 3, from MSG_SERVER          , typ 0, key -

Received 4 bytes from MSG_SERVER                             

Received opcode MS_NOOP from msg_server, reply MSOP_OK

MsOpReceive: ok

MsSendKeepalive : keepalive sent to message server

NiIRead: hdl 2 recv would block (errno=EAGAIN)

Sun Mar 23 16:45:37 2014

NiIPeek: peek for hdl 2 timed out (r; 1000ms)

NiIRead: read for hdl 2 timed out (1000ms)

DpHalt: no more messages from the message server

DpHalt: sync with message server o.k.

detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c   11698]

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiBufISelUpdate: new MODE -- (r-) for hdl 2 in set0

SiSelNSet: set events of sock 296 to: ---

NiBufISelRemove: remove hdl 2 from set0

SiSelNRemove: removed sock 296 (pos=2)

SiSelNRemove: removed sock 296

NiSelIRemove: removed hdl 2

MBUF state OFF

AdGetSelfIdentRecord: >                                                                           <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/9

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 15)

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 2 / sock 296

NiBufIClose: clear extension for hdl 2

MsIDetach: detach MS-system

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 3016) [dpxxdisp.c   10087]

Good Bye .....

Regards

Abhijit