cancel
Showing results for 
Search instead for 
Did you mean: 

Problems about disp+work when installing s/4hana

Former Member
0 Kudos

Hello, I am now installing S/4hana on linux suse 11, and now there is a problem when starting the instance. At first, disp+work can start and the status is running, but after a few seconds, the status of disp+work is stopped. Thus, the whole sap system cannot start successfully. Can anyone help me solve the problem? Here attached are the logs of dev_disp and dev_w0

Accepted Solutions (1)

Accepted Solutions (1)

former_member182657
Active Contributor
0 Kudos

Hi,

From the dev_disp log file


Tue Aug 30 17:38:50 2016

***

*** DpRqNoWpHandle: SHUTDOWN request from W6 received (reason=DP_SHUTDOWN_LARGE_TIME_DIFF) ***

Would you please reconfirm timezone settings for the system ? If still issue persists share the dev_w6 log file from the system.

Regards,

Gaurav

Former Member
0 Kudos

Thank you Gaurav, the problem has been solved.

Best Regards,

Josh

isaias_freitas
Advisor
Advisor
0 Kudos

Hello Josh,

It would be nice if you mark this thread as "answered" and assign the "correct answer" to Gaurav's reply .

Best regards,

Isaías

Answers (1)

Answers (1)

former_member686472
Participant
0 Kudos

Hi ,

could you please let me know what kernel release are you using .

Regards

Arpitt

Former Member
0 Kudos

Hi Arpitt,

SAP Kernel version is 7.45

Best Regards

Josh

former_member686472
Participant
0 Kudos

could you please check below things :-

To check the 'source id'

1. Logon to central | ASCS instance and execute

  • sappfpar pf=<path_to_instance_profile> DIR_EXECUTABLE
  • <DIR_EXECUTABLE>/msg_server | grep source

2. Logon to application server and execute

  • sappfpar pf=<DI's profile> DIR_EXECUTABLE
  • <DIR_EXECUTABLE>/disp+work | grep source

If 'source id' is different, change the kernel in <DIR_EXECUTABLE> of affected instance.


and could you send me the error log once again , because from attachment its not showing clearly


Regards ,

Arpit

Former Member
0 Kudos

Hi Arpit,

I checked the source id of msg_server in ASCS and disp+work in application server, there is no difference.

Here are logs of dev_disp and dev_w0:

dev_disp.log:

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

trc file: "dev_disp.new", trc level: 1, release: "745"

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

sysno      04

sid        SSS

systemid   390 (AMD/Intel x86_64 with Linux)

relno      7450

patchlevel 0

patchno    100

intno      20151301

make       multithreaded, Unicode, 64 bit, optimized

profile    /usr/sap/SSS/SYS/profile/SSS_D04_bjg03test014

pid        8685

Tue Aug 30 17:38:24 2016

kernel runs with dp version 3000(ext=117000) (@(#) DPLIB-INT-VERSION-0+3000-UC)

length of sys_adm_ext is 500 bytes

***LOG Q00=> DpSapEnvInit, DPStart (04 8685) [dpInit.c     605]

  shared lib "dw_xml.so" version 100 successfully loaded

  shared lib "dw_xtc.so" version 100 successfully loaded

  shared lib "dw_stl.so" version 100 successfully loaded

  shared lib "dw_gui.so" version 100 successfully loaded

  shared lib "dw_rndrt.so" version 100 successfully loaded

  shared lib "dw_abp.so" version 100 successfully loaded

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

use internal message server connection to port 3905

rdisp/shutdown/disable_login : 0

DpCommonParamInit: rdisp/core_file_size = default --> no change

Tue Aug 30 17:38:34 2016

*** WARNING => DpNetCheck: NiServToNo(64555) took 9 seconds

Tue Aug 30 17:38:38 2016

*** WARNING => DpNetCheck: NiServToNo(sapdp9988) took 4 seconds

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

MtxInit: 30000 0 0

DpIPCInit2: write dp-profile-values into sys_adm_ext

RqQInit: use events to trigger worker

DpIPCInit2: start server >bjg03test014_SSS_04                     <

DpShMCreate: alloate/attach shared memory (mode=CREATE)

DpShMCreate: sizeof(wp_adm) 23184 (1104)

DpShMCreate: sizeof(tm_adm) 52516464 (RDISPTERM=52464,MODEINFO=3008, IMODE_INFO=80)

DpShMCreate: sizeof(ca_adm) 432000 (72)

DpCommTableSize: max/headSize/ftSize/tableSize=1500/8/5484056/5775112

DpShMCreate: sizeof(comm_adm) 5775112 (3648)

DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

DpShMCreate: sizeof(slock_adm) 0 (296)

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

DpShMCreate: sizeof(file_adm) 0 (80)

DpSockTableSize: max/headSize/ftSize/tableSize=1500/8/1536056/1536064

DpShMCreate: sizeof(sock_adm) 1536064 (1016)

DpShMCreate: sizeof(vmc_adm) 0 (3208)

DpShMCreate: sizeof(wall_adm) (ft=200056/fi=205048/hd=64/rec=192)

DpShMCreate: sizeof(amc_rec_adm) (ft=1360056/fi=377048/hd=56/rec=672)

DpShMCreate: sizeof(websocket_adm) (ft=244056/hd=72/rec=480)

DpShMCreate: sizeof(gw_adm) 56

DpShMCreate: sizeof(j2ee_adm) 3928

DpShMCreate: SHM_DP_ADM_KEY (addr: 7f8b7805f000, size: 62779824

DpShMCreate: allocated sys_adm at 7f8b7805f200

DpShMCreate: allocated wp_adm_list at 7f8b780711c0

DpShMCreate: allocated wp_adm at 7f8b780714e0

DpShMCreate: allocated tm_adm_list at 7f8b78077170

DpShMCreate: allocated tm_adm at 7f8b780773f0

DpShMCreate: allocated ca_adm at 7f8b7b28cc60

DpShMCreate: allocated comm_adm at 7f8b7b2f65e0

DpShMCreate: system runs without slock table

DpShMCreate: allocated sock_adm at  7f8b7b8786e8

DpShMCreate: allocated vmc_adm_list at 7f8b7b9ef928

DpShMCreate: system runs without VMC

DpShMCreate: allocated gw_adm at 7f8b7b9efbc8

DpShMCreate: allocated j2ee_adm at 7f8b7b9efe00

DpShMCreate: allocated ca_info at 7f8b7b9f0f58

DpShMCreate: allocated wall_adm (ft) at 7f8b7b9f1198

Tue Aug 30 17:38:38 2016

DpShMCreate: allocated wall_adm (fi) at 7f8b7ba22110

DpShMCreate: allocated wall_adm (head) at 7f8b7ba54408

DpShMCreate: allocated amc_rec_adm (ft) at 7f8b7ba54648

DpShMCreate: allocated amc_rec_adm (fi) at 7f8b7bba0900

DpShMCreate: allocated amc_rec_adm (head) at 7f8b7bbfcbd8

DpShMCreate: allocated websocket_adm (ft) at 7f8b7bbfce10

DpShMCreate: allocated websocket_adm (head) at 7f8b7bc38968

DpShMCreate: initialized 21 eyes

DpSysAdmIntInit: initialize sys_adm

DpSysAdmIntInit: created queue 0 (DispatcherQueue)

DpSysAdmIntInit: created queue 1 (GatewayQueue)

DpSysAdmIntInit: created queue 2 (IcmanQueue)

DpSysAdmIntInit: created queue 3 (StartServiceQueue)

DpSysAdmIntInit: created queue 4 (DpMonQueue)

Scheduler info

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

WP info

  #dia     = 10

  #btc     = 0

  #standby = 0

  #max     = 21

General Scheduler info

  preemptionInfo.isActive           = true

  preemptionInfo.timeslice          = 500

  preemptionInfo.checkLoad          = true

Prio Class High

  maxRuntime[RQ_Q_PRIO_HIGH]     = 600 sec

  maxRuntimeHalf[RQ_Q_PRIO_HIGH] = 300 sec

Prio Class Normal

  maxRuntime[RQ_Q_PRIO_NORMAL]           = 3600 sec

  maxRuntimeHalf[RQ_Q_PRIO_NORMAL]       = 1800 sec

  maxTicketsForPrio[RQ_Q_PRIO_NORMAL]          = 8

  maxTicketsForPrioIncrement[RQ_Q_PRIO_NORMAL] = 0

  withPrioTickets[RQ_Q_PRIO_NORMAL]            = true

Prio Class Low

  maxRuntime[RQ_Q_PRIO_LOW]                 = infinite

  maxRuntimeHalf[RQ_Q_PRIO_LOW]             = infinite

  maxTicketsForPrio[RQ_Q_PRIO_LOW]          = 7

  maxTicketsForPrioIncrement[RQ_Q_PRIO_LOW] = 0

Tue Aug 30 17:38:38 2016

  withPrioTickets[RQ_Q_PRIO_LOW]            = true

Running requests[RQ_Q_PRIO_NORMAL] = 0

Running requests[RQ_Q_PRIO_LOW] = 0

DpCommAttachTable: attached comm table (header=7f8b7b2f65e0/ft=7f8b7b2f65e8/fi=7f8b7b831400)

DpSockAttachTable: attached sock table (header=7f8b7b8786e8/ft=7f8b7b8786f0)

MBUF state OFF

DpCommInitTable: init table for 1500 entries

DpSockInitTable: init table for 1500 entries

EM: Initializing PROC global storage: quota=0 use_stdheap=0

EM: Initializing PROC local storage:  quota=0 use_stdheap=0

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 21 initializing ....

<ES> EsILock: use Mutex for locking

<ES> InitFreeList

<ES> block size is 4096 kByte.

<ES> Info: em/initial_size_MB( 11258MB) not multiple of em/blocksize_KB( 4096KB)

<ES> Info: em/initial_size_MB rounded up to 11260MB

<ES> Info: disclaim threshold = 0 MB

<ES> Info: disclaim coasting/alloc = 300 s

<ES> Info: disclaim coasting/free = 0 s

<ES> Info: blockdisclaimsize_KB = 0 KB

Using implementation std

<ES> Info: use mapped file

EsStdUnamFileMapInit: ES Segment = 0x7f88a9f60000 - 0x7f8b69b60000

EsStdInit: Extended Memory 11260 MB allocated

Linux: Kernel supports shared memory disclaiming

Linux: using madvise(<pointer>, <size>, 9).

Linux: disclaiming for shared memory enabled

<ES> 2814 blocks reserved for free list.

ES initialized.

mm.dump: set global maximum dump mem to 192 MB

EsRegisterEmCheck: Register EmGetEsHandles at 13cfe22

rdisp/calculateLoadAverage : 1

rdisp/snapshot(CREATE): DP_CS_RESOURCES_EXHAUSTED

rdisp/snapshot(PERIOD):300 sec

rdisp/snapshot(LINES):10000 lines

rdisp/snapshot(C-STACK):C-STACK = YES

***LOG Q0K=> DpMsAttach, mscon ( bjg03test014) [dpMessageSer 1685]

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

Tue Aug 30 17:38:38 2016

DpStartStopMsg: start msg sent to message server o.k.

MBUF state LOADING

DpCheckStopStateAfterMsAttach: server supports AMC msg header version 2

MPI: dynamic quotas disabled.

MPI init, created: pipes=4000 buffers=2718 reserved=815 quota=10%, buffer size=65536, total size MB=170

DpAsCreate: forked gwrd (pid 8718)

DpIcmCreate: forked ICM (pid 8719)

DpWpDynCreate: created new work process W0-8720

DpWpDynCreate: created new work process W1-8721

DpWpDynCreate: created new work process W2-8722

DpWpDynCreate: created new work process W3-8723

DpWpDynCreate: created new work process W4-8724

DpWpDynCreate: created new work process W5-8725

DpWpDynCreate: created new work process W6-8726

DpWpDynCreate: created new work process W7-8727

DpWpDynCreate: created new work process W8-8728

DpWpDynCreate: created new work process W9-8729

DpWpDynCreate: created new work process W10-8730

DpWpDynCreate: created new work process W11-8731

DpWpDynCreate: created new work process W12-8732

DpWpDynCreate: created new work process W13-8733

DpWpDynCreate: created new work process W14-8734

DpWpDynCreate: created new work process W15-8735

CGROUPS: changing prio of pid 8685 to medium

CGROUPS: disabled

**START Linux Memory Parameter Check

virtual memory: hard-limit = UNLIMITED

virtual memory: soft-limit = UNLIMITED

core size: hard-limit = UNLIMITED

core size: soft-limit = 0 MB

data segment size: hard-limit = UNLIMITED

data segment size: soft-limit = UNLIMITED

stack size: hard-limit = UNLIMITED

stack size: soft-limit = 8 MB

max open files: hard-limit = 32800

max open files: soft-limit = 32800

Page Size: 4 KB

kernel.shmmax = 36864 MB

kernel.shmall = 4503599627370495 MB

**END   Linux Memory Parameter Check

Linux scheduler "SCHED_OTHER" used with prio 0

Tue Aug 30 17:38:39 2016

CCMS: Initialized monitoring segment of size 60000000.

CCMS: Initialized CCMS Headers in the shared monitoring segment.

CCMS: Checking Downtime Configuration of Monitoring Segment.

CCMS: AlMsUpload called by wp 1024.

CCMS: AlMsUpload successful for /usr/sap/SSS/D04/log/ALMTTREE (335 MTEs).

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

DpCheckPreemptionTicker: created thread for DpPremptionTicker

DpMBufHwIdSet: set Hardware-ID

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

MBUF state ACTIVE

DpMBufTypeMod: MBUF component UP (event=MBUF_DPEVT_UP)

DpMsgProcess: 1 server in MBUF

DpMsCheckServices()

DpMsgProcess: MBUF state is MBUF_ACTIVE

DpMBufReset: state = MBUF_PREPARED

Tue Aug 30 17:38:49 2016

MBUF state ACTIVE

DpMBufTypeMod: MBUF component UP (event=MBUF_DPEVT_UP)

DpMsgProcess: 1 server in MBUF

DpMsCheckServices()

Tue Aug 30 17:38:50 2016

***

*** DpRqNoWpHandle: SHUTDOWN request from W6 received (reason=DP_SHUTDOWN_LARGE_TIME_DIFF) ***

***

********** SERVER SNAPSHOT 1 (Reason: Shutdown) - begin **********

Server bjg03test014_SSS_04, Tue Aug 30 17:38:50 2016

Force W6 in state WP_RUN to dump stack

Scheduler info

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

WP info

DpNumberOfDiaWps: dia_wps 10, standby_wps 0

  #dia     = 10

  #btc     = 3

  #standby = 0

  #max     = 21

General Scheduler info

  preemptionInfo.isActive           = true

  preemptionInfo.timeslice          = 500

  preemptionInfo.checkLoad          = true

Prio Class High

  maxRuntime[RQ_Q_PRIO_HIGH]     = 600 sec

  maxRuntimeHalf[RQ_Q_PRIO_HIGH] = 300 sec

Prio Class Normal

  maxRuntime[RQ_Q_PRIO_NORMAL]           = 3600 sec

  maxRuntimeHalf[RQ_Q_PRIO_NORMAL]       = 1800 sec

  maxTicketsForPrio[RQ_Q_PRIO_NORMAL]          = 8

  maxTicketsForPrioIncrement[RQ_Q_PRIO_NORMAL] = 0

  withPrioTickets[RQ_Q_PRIO_NORMAL]            = true

Prio Class Low

  maxRuntime[RQ_Q_PRIO_LOW]                 = infinite

  maxRuntimeHalf[RQ_Q_PRIO_LOW]             = infinite

  maxTicketsForPrio[RQ_Q_PRIO_LOW]          = 7

  maxTicketsForPrioIncrement[RQ_Q_PRIO_LOW] = 0

  withPrioTickets[RQ_Q_PRIO_LOW]            = true

Actual tickets in use

  actTicketsInUseForPrio[RQ_Q_PRIO_NORMAL]    = 8

  actTicketsInUseForPrio[RQ_Q_PRIO_LOW]    = 7

Running requests[RQ_Q_PRIO_NORMAL] = 0

Running requests[RQ_Q_PRIO_LOW] = 0

Queue Statistics    Tue Aug 30 17:38:50 2016

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

Number of lost wakeup datagrams: 0

Max. number of queue elements : 14000

DIA :     0 (peak     3, writeCount       26, readCount       26)

UPD :     0 (peak     2, writeCount        3, readCount        3)

ENQ :     0 (peak     0, writeCount        0, readCount        0)

BTC :     0 (peak     1, writeCount        3, readCount        3)

SPO :     0 (peak     1, writeCount        1, readCount        1)

UP2 :     0 (peak     1, writeCount        1, readCount        1)

DISP:     0 (peak     2, writeCount       36, readCount       36)

GW  :     1 (peak     1, writeCount        1, readCount        0)

ICM :     0 (peak     1, writeCount        4, readCount        4)

LWP :     0 (peak    15, writeCount       15, readCount       15)

Session queue dump (high priority, 0 elements, peak 2):

Session queue dump (normal priority, 0 elements, peak 0):

Session queue dump (low priority, 0 elements, peak 0):

Requests in queue <GatewayQueue> (1 requests, queue in use):

  - 1 requests for handler REQ_HANDLER_CREATE_SNAPSHOT

Infos about some special queues:

Queue <DispatcherQueue> in slot 0 (port=40435) has no requests

Queue <GatewayQueue> in slot 1 (port=60161) has no requests

Queue <IcmanQueue> in slot 2 (port=54185) has no requests

Queue <StartServiceQueue> in slot 3 (port=0) has no requests

Workprocess Table (long)        Tue Aug 30 17:38:50 2016

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

Current snapshot id: 1

DB clean time (in percent of total time)     : 37.62 %

Number of preemptions                   : 0

|No |Pid     |Type|State  |Cause|Err|Prio|Sess-Key        |Sess-Type|Locked|Sem|Time |Program                                 |Cli|User        |Action              |Action-Info         |

|---|--------|----|-------|-----|---|----|----------------|---------|------|---|-----|----------------------------------------|---|------------|--------------------|--------------------|

|  6|8726    |DIA |WP_RUN |     |   |high|T4_U12_M0       |SERVER_ST|      |   |    1|<SERVER STARTUP PROCESSING>             |000|SAPSYS      |GENERATE            |                    |

Found 1 active workprocesses

Session Table    Tue Aug 30 17:38:50 2016

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

|Logon-Type  |Sess-Key        |Cli|User        |Terminal            |Time    |WP |Program                                 |Prio|Tasks|Application-Info                                  |Tcode     |ES-Mem(KB)|

|------------|----------------|---|------------|--------------------|--------|---|----------------------------------------|----|-----|--------------------------------------------------|----------|----------|

|SERVER_START|T4_U12_M0       |000|SAPSYS      |                    |17:38:49|6  |RSDBAMDP                                |high|     |                                                  |          |37002     |

Found 1 logons with 1 sessions

Communication Table is empty Tue Aug 30 17:38:50 2016

CA Blocks

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

0 ca_blk slots of 6000 in use, 0 currently unowned (in request queues)

********** SERVER SNAPSHOT 1 (Reason: Shutdown) - end **********

Tue Aug 30 17:39:00 2016

DpTriggerSapSnapshot: start /usr/sap/SSS/D04/exe/sapcontrol

DpTriggerSapSnapshot: sapcontrol runs with pid 8821

***LOG Q41=> DpDumpInternalTables,  () [dpxxdisp.c   3443]

DpHalt: shutdown server >bjg03test014_SSS_04                     < (normal)

DpMBufTypeMod: MBUF server state SHUTDOWN (event=MBUF_DPEVT_DSTATE)

DpModState: change server state from STARTING to SHUTDOWN

DpHalt: stop work processes

Tue Aug 30 17:39:02 2016

DpHalt: stop gateway

DpHalt: stop icman

DpHalt: terminate gui connections

DpHalt: wait for end of work processes

DpHalt: wait for end of gateway

DpHalt: waiting for termination of gateway ...

Tue Aug 30 17:39:03 2016

DpHalt: wait for end of icman

DpHalt: waiting for termination of icman ...

Tue Aug 30 17:39:04 2016

DpHalt: waiting for termination of icman ...

Tue Aug 30 17:39:06 2016

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

DpStartStopMsg: stop msg sent to message server o.k.

Tue Aug 30 17:39:07 2016

DpHalt: sync with message server o.k.

DpHalt: detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpMessageSer 2110]

MBUF state OFF

DpMBufTypeMod: MBUF component DOWN (event=MBUF_DPEVT_DOWN)

DpMsServerDown: wakeup waiting sessions

DpHalt: ignore SIGCHLD from now on

SigISetIgnoreAction : SIG_IGN for signal SIGCHLD

DpHalt: cleanup EM

DpHalt: cleanup event management

DpHalt: cleanup shared memory/semaphores

***LOG Q05=> DpHalt, DpHalt ( 8685) [dpInit.c     3649]

DpHalt: *** shutdown completed - server stopped ***

dev_w0.log:

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

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

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

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

M sysno      04

M sid        SSS

M systemid   390 (AMD/Intel x86_64 with Linux)

M relno      7450

M patchlevel 0

M patchno    100

M intno      20151301

M make       multithreaded, Unicode, 64 bit, optimized

M profile    /usr/sap/SSS/SYS/profile/SSS_D04_bjg03test014

M pid        8720

M

M Tue Aug 30 17:38:38 2016

M  kernel runs with dp version 3000(ext=117000) (@(#) DPLIB-INT-VERSION-0+3000-UC)

M  length of sys_adm_ext is 500 bytes

M  ThStart: taskhandler started

M  ThInit: initializing DIA work process W0

X  MMX: use precise segment size globally

M  ThStopHeapLockChecker: stop heap lock checker

M  ***LOG Q01=> ThInit, WPStart (Workp. 0 1 8720) [thxxhead.c   1077]

M Tue Aug 30 17:38:41 2016

M  ThInit: running on host bjg03test014

I  MtxInit: 0 0 0

M  calling db_connect ...

B  Loading DB library '/usr/sap/SSS/D04/exe/dbhdbslib.so' ...

B  Library '/usr/sap/SSS/D04/exe/dbhdbslib.so' loaded

B  Version of '/usr/sap/SSS/D04/exe/dbhdbslib.so' is "745.04", patchlevel (0.100)

C  Callback functions for dynamic profile parameter registered

C  DBHDBSLIB : version 745.04, patch 0.100 (Make PL 0.100)

C  HDB shared library (dbhdbslib) patchlevels (last 10)

C    (0.100) SAP Support Package Stack Kernel 7.45 Patch Level 100 (note 2276394)

C    (0.018) Describe on a decimal datatype with a large scale value (note 2220646)

C    (0.013) Use connection variables instead of table M_CONNECTIONS (note 2207349)

C    (0.008) Session variables processing via dbsl (note 2182777)

C    (0.005) Substitute literals in select list (note 2182777)

C    (0.004) Cancel FDA SQL statement (note 2177669)

C  Loading SQLDBC client runtime ...

C  SQLDBC Module  : /usr/sap/SSS/hdbclient/libSQLDBCHDB.so

C  SQLDBC Runtime : libSQLDBCHDB 1.00.110.00 Build 1447753075-1530

C  SQLDBC client runtime is 1.00.110.00.1447753075

C  Try to connect via secure store (DEFAULT) on connection 0 ...

C  Attach to HDB : 1.00.110.00.1447753075 (fa/newdb100_rel)

C  fa/newdb100_rel : build_weekstone=0000.00.0

C  fa/newdb100_rel : build_time=2015-11-17 10:50:04

C  Database release is HDB 1.00.110.00.1447753075

C  INFO : Database 'AP1/02' instance is running on 'ibmhana166'

C  INFO : Connect to DB as 'SAPABAP1', connection_id=359935

C  INFO : set parameter for SQLSCRIPT, Enable_Select_Into_Scalar_UDF

C  INFO : DATA AGING feature is supported by HANA

C  INFO : FDA feature is supported by HANA

C  INFO : FAE with FDA feature is supported by HANA

C  INFO : DEFERRED LOB WRITING is activated

C  DB max. input host variables  : 32767

C  DB max. statement length      : 104857600

C  DB max. array size            : 100000

C  use decimal precision as length

C  ABAPVARCHARMODE is used

C  use DBSL marker map

C  use DBSL session variable handling

C  INFO : DBSL buffer size = 1048576

C Tue Aug 30 17:38:41 2016

C  Command info enabled

C  Now I'm connected to HDB

C  00: ibmhana166-AP1/02, since=20160830173841, ABAP= <unknown> (0)

B  Connection 0 opened (DBSL handle 0)

B  *-- dbmetadata DbVendorMetaData --------------*

B  Connection   : R/3[0]

B  DB vendor    : HDB,745.04

B  DB vendor    : 7

B  DBSL version : 745.04

B  DBSL features

B     maxstmtsize            : 104857600

B     maxmarkercnt           : 32767

B     maxincnt               : 1024

B     maxlongsize            : 32768

B     maxhistlongsize        : 32768

B     minhistlongsize        : 0

B     maxmarkersize          : 1

B     autorpad               : 0

B     stringspadded          : 0

B     blk1obj1mod            : 1

B     haverownum             : 0

B     havepermanentstmts     : 0

B     fupdlockperm           : 1

B     fupdorder              : 1

B     preferunionall         : 0

B     prefer_join            : 0

B     prefer_join_with_fda   : 1

B     preferinitabopt        : 1

B     useinputsize           : 0

B     preferfixblocking      : 0

B     maxblockingfactor      : 50

B     minblockingfactor      : 0

B     maxinblockingfactor    : 1024

B     mininblockingfactor    : 0

B     maxunionblockingfactor : 0

B     minunionblockingfactor : 0

B     prefer_asterisk        : 15

B     deferred_lob_writing   : 1

B     prefer_count_big       : 0

B     supports_fda_prot      : 1

B Tue Aug 30 17:38:41 2016

B     integer_operation_cast : 0

B     modulo_operator        : 0

B     smallint_cast          : 0

B     integer_division_mode  : 2

B     set_session_variables_always: 1

B  FAE controls

B     supports_fda_prot         : 1

B     prefer_in_itab_opt        : 1

B     prefer_union_all          : 0

B     prefer_join               : 0

B     prefer_join_with_fda      : 1

B     prefer_fix_blocking       : 0

B     max_blocking_factor       : 50

B     min_blocking_factor       : 0

B     max_in_blocking_factor    : 1024

B     min_in_blocking_factor    : 0

B     max_union_blocking_factor : 0

B     min_union_blocking_factor : 0

B  DB feature mode

B     views_parameters_unnamed: 0

B     views_with_parameters : 1

B     release restricion        : true

B     external_views : 1

B     release restricion        : true

B     TABLE_KEYCNT_MAX1 : 1

B     release restricion        : true

B     TABLE_KEYLEN_MAX1 : 1

B     release restricion        : true

B     TABLE_LEN_MAX1 : 1

B     release restricion        : true

B     AMDP_TABLE_FUNCTION : 1

B     release restricion        : true

B     CALL_DATABASE_PROCEDURE : 1

B     release restricion        : true

B     CALL_AMDP_METHOD : 1

B     release restricion        : true

B  Hint settings

B     ABAP hints enabled : 1

B     DBI hints enabled  : 1

B     DBI hints enforced : 0

B Tue Aug 30 17:38:41 2016

B     upto limit         : 0

B  Misc settings

B     DB buffer size: 1048576

B     Reserved characters: {null}

B     UPTO handling: 3

B     Marker Map: 1

B  *------------- DbVendorMetaData --------------*

C  INFO : SAP RELEASE (DB) = 750

M  ThDbConnect: db_connect o.k.

X Tue Aug 30 17:38:43 2016

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X  <ES> client 0 initializing ....

X  Using implementation std

X  <ES> Info: use mapped file

X  Linux: Kernel supports shared memory disclaiming

X  Linux: using madvise(<pointer>, <size>, 9).

X  Linux: disclaiming for shared memory enabled

X  ES initialized.

X  mm.dump: set global maximum dump mem to 192 MB

X  EsRegisterEmCheck: Register EmGetEsHandles at 13cfe22

B  hook function dbdt_trace_lvl_callback registered. Current trace level is 1

B  db_con_shm_ini:  WP_ID = 0, WP_CNT = 21, CON_ID = -1

B  Start CursorInit

B  TBI initializing semaphore lock manager ...

B  tbi_get_buffer_size_MB: rsdb/tbi_buffer_area_MB set to default 1

B    => table buffer size 1363(MB) derived from rtbb/buffer_length=115283(KB) and zcsa/table_buffer_area=1180497347(B)

B  tbi_get_dir_entries: rsdb/tbi_dir_entries set to default 100

B    => directory size 253623 derived from rtbb/max_tables=23057 and zcsa/db_max_buftab=230566

B  tbx_set_req: table buffer is configured with

B    overall size    = 1429209088 bytes

B    directory       = 253623 entries

B    protect_shm     = off

B    displacement    = on

B    request_unit    = 2000

B    sync_reload     = 5

B    inval_reload    = 5

B    free_displ_perc = 3

B    req_displ_perc  = 5

B    max_displ_perc  = 10

B  dbtbxbuf: Buffer TBI64 (addr: 7f8879c940e8, size: 1429209088, end: 7f88cef940e8)

B  DBI: init TBI BUFFER (data):  start=7f88aa461000  length=1380849408  end=7f88fc942700

B  DbSqlObjectFactory created, max = 1000, useCache true

B  DbStatementManager created, max = 1500, useCache true

B  dbprotocol: table logging switched off for all clients

B  DbDmlCursor::maxItabInvalidationThreshold = 20

B  DB FDA shm initialized: ptr=7f887cb152b0 total_size_wp=1048576lu used_size_wp=1048576

B  dbsync[db_syinit]: successfully attached to shared memory, sync_adm_p = 7f8899e49000

B  dbsync[db_syinit]: Buffer synchronisation started with

B    sync_concept      = SEQ_NR

B    sendon            = 0

B    bufreftime        = 120

B    max_gap_wait_time = 60

B    ddlog_del_time    = 60

B    last_counter      = -2147483648

B    oldest_gap        = (2147483647,19700101000000)

B    time_of_last_sync = 20160830173842

B    MySysId           = 'bjg03test014        04'

B  dbexpbuf[EXP_SHB]: successfully attached to shared memory

B  dbexpbuf[EXP_SHB]: buffer installed with the following properties

B    semKey             = 35

B    shmKey             = 54

B    wpCnt              = 21

B    blockSize          = 512

B    maxObjects         = 41172

B    maxObjectSize      = 38288512

B    freeListVectorSize = 489

B    hashVectorSize     = 82349

B    bufferSize         = 168642560

B    maxBlocks          = 299129

B    freeBlocksCnt      = 299129

B    mutexVectorSize    = 82351, ADMIN_MUTEX = 82349, INVAL_MUTEX = 82350

B    tracing            = 0

B    forceChecks        = 0

B    protectShm         = 0

B  dbexpbuf[EXP_SHM]: successfully attached to shared memory

B  dbexpbuf[EXP_SHM]: buffer installed with the following properties

B    semKey             = 56

B    shmKey             = 65

B    wpCnt              = 21

B    blockSize          = 512

B    maxObjects         = 2000

B    maxObjectSize      = 859648

B    freeListVectorSize = 17

B    hashVectorSize     = 4001

B    bufferSize         = 4194304

B    maxBlocks          = 6716

B    freeBlocksCnt      = 6716

B    mutexVectorSize    = 4003, ADMIN_MUTEX = 4001, INVAL_MUTEX = 4002

B    tracing            = 0

B    forceChecks        = 0

B    protectShm         = 0

B  dbexpbuf[EXP_CUA]: successfully attached to shared memory

B  dbexpbuf[EXP_CUA]: buffer installed with the following properties

B    semKey             = 30

B    shmKey             = 47

B    wpCnt              = 21

B    blockSize          = 512

B    maxObjects         = 2000

B    maxObjectSize      = 577920

B    freeListVectorSize = 587

B    hashVectorSize     = 4001

B    bufferSize         = 3072000

B    maxBlocks          = 4515

B    freeBlocksCnt      = 4515

B    mutexVectorSize    = 4003, ADMIN_MUTEX = 4001, INVAL_MUTEX = 4002

B    tracing            = 0

B    forceChecks        = 0

B    protectShm         = 0

B  dbexpbuf[EXP_OTR]: successfully attached to shared memory

B  dbexpbuf[EXP_OTR]: buffer installed with the following properties

B    semKey             = 55

B    shmKey             = 64

B    wpCnt              = 21

B    blockSize          = 256

B    maxObjects         = 2000

B    maxObjectSize      = 859584

B    freeListVectorSize = 33

B    hashVectorSize     = 4001

B    bufferSize         = 4194304

B    maxBlocks          = 13431

B    freeBlocksCnt      = 13431

B    mutexVectorSize    = 4003, ADMIN_MUTEX = 4001, INVAL_MUTEX = 4002

B    tracing            = 0

B    forceChecks        = 0

B    protectShm         = 0

B  NTAB: Structure of NTAB on DB is VERS_B, unicodelg of executable is 2, unicodelg of SVERS in nametab is 2

M  SHM_PRES_BUF (addr: 7f8b7d3f3000, size: 4400000)

M  ThCreateNoBuffer allocated 548152 bytes for 1000 entries at 7f889a142000

M  ThCreateNoBuffer index size: 3000 elems

M  ThCreateVBAdm allocated 33376 bytes (50 server) at 7f885ecc2000

M  ICT: exclude compression: *.zip,*.rar,*.arj,*.z,*.gz,*.tar,*.lzh,*.cab,*.hqx,*.ace,*.jar,*.ear,*.war,*.jpg,*.jpeg,*.pdf,*.gzip,*.uue,*.bz2,*.iso,*.sda,*.sar,*.gif,*.png,*.swc,*.swf

G Tue Aug 30 17:38:43 2016

G  RelWritePermissionForShm( pLocation = 120, pEnforce = 0 )

G  GetWritePermissionForShm( pLocation =  99, pEnforce = 1 )

G  RelWritePermissionForShm( pLocation = 100, pEnforce = 1 )

S  *** init spool environment

S  TSPEVJOB updates outside critical section: event_update_nocsec = 1

S  initialize debug system

T  Stack direction is downwards.

T  debug control: prepare exclude for printer trace

T  new memory block 7f887cc15330

S  spool kernel/ddic check: Ok

S  using table TSP02FX for frontend printing

S  1 spool work process(es) found

S  frontend print via spool service enabled

S  printer list size is 150

S  printer type list size is 50

S  queue size (profile)   = 300

S  hostspool list size = 3000

S  option list size is 30

I  *** INFO  SHM 49 in POOL 40     2172 KB estimated      1632 KB real (    -540 KB    -25 %)

S      found processing queue enabled

S  found spool memory service RSPO-RCLOCKS at 7f889a1c9070

S  doing lock recovery

S  setting server cache root

S  found spool memory service RSPO-SERVERCACHE at 7f889a1c96b0

S    using messages for server info

S  size of spec char cache entry: 297032 bytes (timeout 100 sec)

S  size of open spool request entry: 2512 bytes

S  immediate print option for implicitely closed spool requests is disabled

B  dbtran INFO (init_connection '<DEFAULT>' [HDB:745.04]):

B   max_blocking_factor       =  50,  min_blocking_factor         =  50,

B   max_in_blocking_factor    =1024,  min_in_blocking_factor      =1024,

B   max_union_blocking_factor =  20,  min_union_blocking_factor   =  20,

B   prefer_union_all          =   0,  prefer_join                 =   0,

B   prefer_fix_blocking       =   0,  prefer_in_itab_opt          =   1,

B   convert AVG               =   1,  alias table FUPD            =   0,

B   escape_as_literal         =   0,                                  

B   select *                  =0x0f,  character encoding          = STD / <none>:-,

B   use_hints                 = abap->1, dbif->0x1, upto->0

M  rscpInstLangInit: logon_languages found in TCP0I, value = DE

M  rscpInstLangInit called rscpSetZCSAInstalledLanguages->0 and rscpInstLangSet->0.

M  ThrCreateShObjects allocated 43684 bytes at 7f8b8d0cd000

I  MPI: dynamic quotas disabled.

M  CCMS: SemInMgt: Semaphore Management initialized by AlAttachShm_Doublestack.

M  CCMS: SemInit: Semaphore 38 initialized by AlAttachShm_Doublestack.

A  PXA: using abap/buffersize              2306048

O  PXA: max_map_count = 1000000: ok

O  ***GENER* Trace switched on ***

O  ---PXA-------------------------------------------

O  PXA INITIALIZATION

O Tue Aug 30 17:38:43 2016

O  PXA: Locked PXA-Semaphore.

O  System page size: 4kb, total admin_size: 170776kb, dir_size: 41784kb.

O  Attached to PXA (address 7f87ce755000 - 7f885b355000, size 2306048K, 4 fragments of 533820K )

O  *** using a guard page at PXA start to protect parameters and release info ***

O  abap/pxa = shared protect gen_remote

O  PXA: checking structure sizes: 848|264|16

O  PXA INITIALIZATION FINISHED

O  ---PXA-------------------------------------------

A  ATRA: pfclock execution time = 0

A  abap/force_local_update_task=0

A  ABAP ShmAdm attached (addr=7f88fd0be000 leng=235913216 end=7f890b1ba000)

A  >> Shm MMADM area (addr=7f89005d1650 leng=2773184 end=7f8900876710)

A  >> Shm MMDAT area (addr=7f8900877000 leng=177483776 end=7f890b1ba000)

A  RFC Destination> destination bjg03test014_SSS_04 host bjg03test014 system SSS systnr 4 (bjg03test014_SSS_04)

A  RFC Options> H=bjg03test014,S=04,d=2,

B  dbrda: Redirect database access is disabled via rsdb/rda profile parameter setting.

A  RFC FRFC> fallback ist not active. Do nothing.

A  RFC rfc/signon_error_log = -1

A  RFC rfc/dump_connection_info = 0

A  RFC rfc/dump_client_info = 0

A  RFC rfc/cp_convert/ignore_error = 1

A  RFC rfc/cp_convert/conversion_char = 23

A  RFC rfc/wan_compress/threshold = 251

A  RFC rfc/recorder_pcs not set, use defaule value: 2

A  RFC rfc/delta_trc_level not set, use default value: 0

A  RFC rfc/no_uuid_check not set, use default value: 0

H  HTTP> Parameter icf/ssocookie_mandatory set to 0

Y  dyWpInit

Y    ztta/dynpro_area 1000000

Y    ztta/cua_area    500000

Y    ztta/diag_area   250000

N  MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from shared memory.

N  MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

W  =================================================

W  === ipl_Init() called

W    ITS Plugin: Path dw_gui

W    ITS Plugin: Description ITS Plugin - ITS rendering DLL

W    ITS Plugin: sizeof(SAP_UC) 2

W    ITS Plugin: Release: 745, [7450.0.100.20151301]

W    ITS Plugin: Int.version, [35]

W Tue Aug 30 17:38:43 2016

W    ITS Plugin: Feature set: [34]

W    ===... Calling itsp_Init in external dll ===>

W  === ipl_Init() returns 0, ITSPE_OK: OK

W  =================================================

N  VSI: WP init in ABAP VM completed with rc=0

N Tue Aug 30 17:38:44 2016

N  SsfSapSecin: getenv(SECUDIR)=="/usr/sap/SSS/D04/sec"

N  =================================================

N  === SSF INITIALIZATION:

N  ===...SSF Security Toolkit name SAPSECULIB .

N  ===...SSF library is /usr/sap/SSS/D04/exe/libsapcrypto.so .

N  ===...SSF default hash algorithm is SHA1 .

N  ===...SSF default symmetric encryption algorithm is AES128-CBC .

N  ===...SSF lib codepage is set to 1 .

N  ===...SSF FIPS 140-2 mode is disabled .

N  ===...SECUDIR="/usr/sap/SSS/D04/sec"

N  ===...loading of Security Toolkit successfully completed.

N  ===   CommonCryptoLib (SAPCRYPTOLIB) Version 8.4.48 pl40 (Jan 26 2016) MT-safe

N  =================================================

N Tue Aug 30 17:38:49 2016

N  SignInit: successfully obtained handle for Security Context cache

N  SPNegoInit: SPNego disabled ("spnego/enable" not set to 1)

M  JrfcVmcRegisterNativesDriver o.k.

M  CGROUPS: ThSetProcessPriority workerType=1

M  CGROUPS: changing prio of pid 8720 to medium

M  CGROUPS: disabled

E  EnqId_Initialize: local EnqId initialization o.k.

M  ThrtAmcInit: use DB table AMC_RECEIVER2 for AMC dispatching

M  Set restart flag on 1024 MB os heap (val=1G)

M Tue Aug 30 17:39:00 2016

M  in_ThErrHandle: 1

M  ThIErrHandle: new stat of W0 is WP_SHUTDOWN   

M  ThIErrHandle: I'm during shutdown

M  PfRejectStatistic: clear statistic record

M  PfClearAllRec: clear statistic area

M  PfClearAllRec: set statRecordAction = STAT_RECORD_ACTION_REJECT

M  ThIErrHandle: entering ThSetStatError

M  PfSetError: clear statistic record

M  PfClearAllRec: clear statistic area

M  PfClearAllRec: set statRecordAction = STAT_RECORD_ACTION_REJECT

M  ThWpSetCurrentSession: set WP's current session to NO SESSION (rq_cnt 0, last wp -1, last rq_id 0)

M  ThResetActRequestQueue: Reset queue in slot 33 (T2_U28_M0)

M  ThRqReleaseQueueSelectHandle: release selectable handle of queue 33 (T2_U28_M0) from [thRequest.c:929]

M  RqQQueueReleaseSelectableHandle: Queue <T2_U28_M0> in slot 33 does not have a selectable handle

M  RqQQueueReleaseSelectableHandle: Queue <T2_U28_M0> in slot 33 released selectable hdl -1 (port=0) W-1

M  RqQQueueRelease: Return queue <T2_U28_M0> in slot 33

C  CANCEL rejected, because there is no SQL statement active

B  db_sqlbreak() = 1

M  ThCallDbBreak: no sql statement active

M  ThIErrHandle: action is STOP_WP, skip rollback

M  ThTriggerExecShutDown: shutdown server

M  ThCallHooks: call hooks for event BEFORE_SHUTDOWN

M  PfSemLock: lock sem 42

M  PfSemLock: lock sem 9

M  PfStatIndInit: Initializing Index-Record

M  PfSwitchBuffer: offset = 500000, buffer size = 3384

M  PfWriteIntoFile: write 3384 bytes into stat-file

M  PfWriteIntoFile: writing Index

M   min. start   :1472578729/170509

M   min. end     :1472578729/187589

M   max. end     :1472578730/209609

M   wpid         :11

M   tasktypes    :-2146955227

M   max. resp    :9521705

M   max. cpu     :110000

M   max.db      

M   no. of recs  :13

M   no. of bytes :3384

M  PfWriteIntoFile: updated fileindex for file stat with endtime 1472781144 (02.09.2016 01:52:24)

M  PfWriteIntoFile: updated fileindex

M  PfStatIndInit: Initializing Index-Record

M  PfWriteIntoFile: wrote buffer to file

M  PfSemUnlock: unlocked sem 9

M  PfSemUnlock: unlocked sem 42

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

M  ***

M  *** work process W0 died => ThRqWaitFor: shutdown

M  call ThrShutDown (1)...

B  Disconnecting from ALL connections:

B  Wp  Hdl ConName          ConId     ConState     TX  BC  OC  HC  PRM RCT INF TIM MAX OPT Date     Time   DBUser                           DBHost           Program                                

B  000 000 R/3              000000000 INACTIVE     NO  NO  000 NO  YES NO  NO  000 255 255 20160830 173841 SAPABAP1                         ibmhana166                                              

C Tue Aug 30 17:39:00 2016

C  Disconnecting from connection 0 ...

C  Now I'm disconnected from HDB

B  Disconnected from connection 0

B  statistics db_con_commit (com_total=2, com_tx=0)

B  statistics db_con_rollback (roll_total=0, roll_tx=0)

M  ***LOG Q02=> wp_halt, WPStop (Workp. 0 8720) [dpuxtool.c   317]

Best Regards,

Josh