cancel
Showing results for 
Search instead for 
Did you mean: 

disp+work.exe won't run after sybase restore

Beyçelik
Explorer
0 Kudos

Hi dear, I have a problem when start dispatcherwork after sybase database restore, its my logs file please help me, my database version is 16.0

#####################################################################################

dew_w0

--------------------------------------------------- trc file: "dev_w0", trc level: 1, release: "753" --------------------------------------------------- * * ACTIVE TRACE LEVEL 1 * ACTIVE TRACE COMPONENTS all, MJ * M sysno 00 M sid CO2 M systemid 562 (PC with Windows NT) M relno 7530 M patchlevel 0 M patchno 413 M intno 20170305 M make multithreaded, Unicode, 64 bit, optimized M profile \\asesys\sapmnt\CO2\SYS\profile\CO2_DVEBMGS00_asesys M pid 3792 M M M Fri Apr 12 09:48:06:611 2019 M kernel runs with dp version 60000(ext=119000) (@(#) DPLIB-INT-VERSION-0+60000-UC) M length of sys_adm_ext is 524 bytes M ***LOG Q0Q=> tskh_init, WPStart (Workp. 0 3792) [dpInit.c 845] I MtxInit: ABAP_WP_0 0 0 M DpIPCInit2: read dp-profile-values from sys_adm_ext M DpCommTableSize: max/headSize/ftSize/tableSize=1500/16/5712064/6003152 M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0 M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0 M DpSockTableSize: max/headSize/ftSize/tableSize=1500/16/1560064/1560080 M DpShMCreate: ATTACH shared memory. Protection via classic eyecatchers M DpShMCreate: SHM_DP_ADM_KEY(addr: 0xdd0050, size: 66322176) M DpShMCreate: sys_adm 0xdd0250, 1 x 95208 (95208) M DpShMCreate: wp_adm_list 0xde7840, 9 x 32 (288) M DpShMCreate: wp_adm 0xde7b60, 21 x 1496 (31416) M DpShMCreate: tm_adm_list 0xdef820, 4 x 32 (128) M DpShMCreate: tm_adm 0xdefaa0, 1001 x 55344 (55399344) M DpShMCreate: ca_adm 0x42c5050, 6000 x 72 (432000) M DpShMCreate: comm_adm 0x432e9d0, 1 x 6003152 (6003152) M DpShMCreate: slock_adm 1 x 0 - no allocation M DpShMCreate: file_adm 1 x 0 - no allocation M DpShMCreate: sock_adm 0x48e85a0, 1 x 1560080 (1560080) M DpShMCreate: vmc_adm_list 0x4a655b0, 5 x 32 (160) M DpShMCreate: vmc_adm 0 x 3224 - no allocation M DpShMCreate: ca_info 0x4a65850, 1 x 60 (60) M DpShMCreate: gw_adm 0x4a65a90, 1 x 52 (52) M DpShMCreate: j2ee_adm 0x4a65cd0, 1 x 3928 (3928) M DpShMCreate: wall_adm_ft 0x4a66e30, 1 x 208064 (208064) M DpShMCreate: wall_adm_fi 0x4a99cf0, 1 x 205072 (205072) M DpShMCreate: wall_adm_head 0x4acc000, 1 x 60 (60) M DpShMCreate: amc_rec_adm_ft 0x4acc240, 1 x 1408064 (1408064) M DpShMCreate: amc_rec_adm_fi 0x4c24080, 1 x 377072 (377072) M DpShMCreate: amc_rec_adm_head 0x4c80370, 1 x 60 (60) M DpShMCreate: comp_msg_adm_ft 0x4c805b0, 1 x 96064 (96064) M DpShMCreate: comp_msg_adm_fi 0x4c97ef0, 1 x 119072 (119072) M DpShMCreate: comp_msg_adm_head 0x4cb5210, 1 x 96 (96) M DpShMCreate: logon_cnt_adm_ft 0x4cb5470, 1 x 64 (64) M DpShMCreate: logon_cnt_adm_fi 0x4cb56b0, 1 x 33072 (33072) M DpShMCreate: logon_cnt_adm_head 0x4cbd9e0, 1 x 96 (96) M DpShMCreate: websocket_adm_ft 0x4cbdc40, 1 x 336064 (336064) M DpShMCreate: websocket_adm_head 0x4d0ff00, 1 x 76 (76) M M Fri Apr 12 09:48:06:658 2019 M DpShMCreate: system runs without VMC M DpCommAttachTable: attached comm table (header=432e9d0/ft=432e9e0/fi=48a12a0) M DpSockAttachTable: attached sock table (header=48e85a0/ft=48e85b0) X EM: Initializing PROC global storage: quota=0 use_stdheap=0 X EM: Initializing PROC local storage: quota=0 use_stdheap=0 X EmInit: MmSetImplementation( 2 ). X MM global diagnostic options set: 0 X EmSetReserve: set EM reserve to 57 EM blocks X <ES> client 0 initializing .... X EsSetImplementation: Using implementation view X <ES> EsILock: use Mutex for locking X <ES> Info: TimeMeasurementActive = 0 X <EsNT> Memory Reset disabled as NT default X ES initialized. X mm.dump: set global maximum dump mem to 192 MB X EsRegisterEmCheck: Register EmGetEsHandles at 7f74b75dce4 M M Fri Apr 12 09:48:06:831 2019 M ThStart: taskhandler started M ThInit: initializing DIA work process W0 X MM global diagnostic options set: 0 M M Fri Apr 12 09:48:11:154 2019 M ThInit: running on host asesys I MtxInit: ABAP_WP_0 0 0 M M Fri Apr 12 09:48:13:404 2019 M calling db_connect ... B Loading DB library 'E:\usr\sap\CO2\DVEBMGS00\exe\dbsybslib.dll' ... B Library 'E:\usr\sap\CO2\DVEBMGS00\exe\dbsybslib.dll' loaded B Version of 'E:\usr\sap\CO2\DVEBMGS00\exe\dbsybslib.dll' is "753.02", patchlevel (0.400) C trace file set C Callback functions for dynamic profile parameter registered B read_con_info_ssfs(): DBSL supports extended connect protocol B ==> connect info for default DB will be read from ssfs C C Fri Apr 12 09:48:14:660 2019 C dbs/syb/fetchArraySize: 1000 C database is local: connect_timeout: 3 C Thread ID:3236 C lib_dbsl 753 10/18/2018 11:50:00 C Using dynamic link library 'E:\usr\sap\CO2\DVEBMGS00\exe\dbsybslib.dll' C dbsybslib.dll patch info C SAP patchlevel 0 C SAP patchno 400 C Last SYBASE DBSL patchlevel 0 C Last SYBASE DBSL patchno 400 C Last SYBASE DBSL patchcomment SAP Support Package Stack Kernel 7.53 Patch Level 400 (2752112) C C Fri Apr 12 09:48:16:036 2019 C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 6164] C (950) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Database 'CO2' is currently of C fline. Please wait and try your command again later. C C syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 6164] C (4001) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Cannot open default database ' C CO2'. C C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 6164] C (30131) [08S01] [SAP][ASE ODBC Driver]Connection to the server has been lost, connection to the C next available HA server also failed. All active transactions have been rolled b C ack C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 6164] C (5704) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Changed client character set s C etting to 'utf8'. C C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 6164] C (5701) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Changed database context to 'm C aster'. C C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 6164] C (5703) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Changed language setting to 'u C s_english'. C C Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=asesys;port=4901;uid=SAPSR3;db=CO2;pwd=xxxxxxxxx;TextSize=2147483647;CRC=0;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;QuotedIdentifier=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=1;EnableLOBLocator=0;app=R3D000 00 comm rd ODBC;logintimeout=3;ProtocolCapture=cap_w0_comm_rd;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1; C B ***LOG BV3=> severe db error 950; work process is stopped [dbsh 1258] B ***LOG BY2=> sql error 950 performing CON [dblink 644] B ***LOG BY0=> [ASE Error SQL950][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Database 'CO2' is currently offline. Please wait and try your command again later. [dblink 644] M ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 87] M in_ThErrHandle: 1 M *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c 2782] M M Info for wp 0 M M pid = 3792 M severity = 0 M status = 0 M stat = WP_NEW M waiting_for = NO_WAITING M workerType = DP_WORKER_DIAWP M act_cs_count = 0 M csTrack = 0 M csTrackRwExcl = 0 M csTrackRwShrd = 0 M mode_cleaned_counter = 0 M Fri Apr 12 09:48:16:037 2019 M control_flag = 0x0 M report = > < M action = 0 M tab_name = > < M M ThIErrHandle: no current incoming request M M M ***************************************************************************** M * M * LOCATION SAP-Server asesys_CO2_00 on host asesys (wp 0) M * ERROR ThInit: db_connect M * M * TIME Fri Apr 12 09:48:16 2019 M * RELEASE 753 M * COMPONENT Taskhandler M * VERSION 1 M * RC 16797709 M * MODULE D:/depot/bas/753_REL/src/krn/si/th/thxxhead.c M * LINE 2971 M * COUNTER 1 M * M ***************************************************************************** M M PfRejectStatistic: clear statistic record M PfClearAllRec: clear statistic area M PfClearAllRec: set statRecordAction = STAT_RECORD_ACTION_REJECT M Entering TH_CALLHOOKS M ThCallHooks: call hooks for event BEFORE_DUMP M ThIErrHandle: entering PfSetError M PfSetError: clear statistic record M PfClearAllRec: clear statistic area M PfClearAllRec: set statRecordAction = STAT_RECORD_ACTION_REJECT M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0) M M *** M *** work process W0 died => ThInit: db_connect M call ThrShutDown (1)... M ***LOG Q02=> wp_halt, WPStop (Workp. 0 3792) [dpnttool.c 334]

################################################################

dev_ms

--------------------------------------------------- trc file: "dev_ms", trc level: 1, release: "753" --------------------------------------------------- [Thr 109360] Mon Jul 23 20:14:38 2018 [Thr 109360] SAP_RELEASE = 753 [Thr 109360] compatibility level = 0 [Thr 109360] Server state INIT [Thr 109360] MsSSetTrcLog: trc logging active, max size = 52428800 bytes [Thr 109360] * SWITCH TRC-RESOLUTION from 1 to 10 systemid 562 (PC with Windows NT) relno 7530 patchlevel 0 patchno 201 intno 20170305 make multithreaded, Unicode, 64 bit, optimized pid 109028 [Thr 109360] Mon Jul 23 20:14:38:188 2018 [Thr 109360] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 109028) [msxxserv.c 2750] [Thr 109360] load acl file = E:\usr\sap\CO2\SYS\global\ms_acl_info.DAT [Thr 109360] List of entries found in E:\usr\sap\CO2\SYS\global\ms_acl_info.DAT [Thr 109360] [001] * [::] (VALID) [Thr 109360] MsGetOwnIpAddr: my host addresses are : [Thr 109360] 1 : [192.168.11.182] (HOSTNAME) [Thr 109360] 2 : [127.0.0.1] (LOCALHOST) [Thr 109360] Mon Jul 23 20:14:38:289 2018 [Thr 109360] MsHttpInit: full qualified hostname = asesys [Thr 109360] HTTP logging is switch off [Thr 109360] *** I listen to port 3600 (3600) *** [Thr 109360] *** I listen to internal port 3900 (3900) *** [Thr 109360] CUSTOMER KEY: >C1800511013< [Thr 109360] compatibility level = 0 [Thr 109360] build version=753.2018.03.16 [Thr 109360] Server state ACTIVE [Thr 109360] Mon Jul 23 20:14:43:097 2018 [Thr 109360] LOGIN: asesys_CO2_00 [192.168.11.182] (DIA UPD BTC UP2 ICM ) [Thr 109360] Mon Jul 23 21:48:12:485 2018 [Thr 109360] LOGOUT: asesys_CO2_00 [192.168.11.182] (DIA UPD BTC UP2 ICM ) [Thr 109360] Mon Jul 23 21:48:13:247 2018 [Thr 109360] MsSExit: received SIGINT (2) [Thr 109360] Server state SHUTDOWN [Thr 109360] ***LOG Q02=> MsSHalt, MSStop (Msg Server 109028) [msxxserv.c 8414] [Thr 109360] Good Bye .....

Accepted Solutions (1)

Accepted Solutions (1)

BJarkowski
Active Contributor
0 Kudos

Was the recovery succesfull? Have a look at this line:

***LOG BY0=> [ASE Error SQL950][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Database 'CO2' is currently offline. Please wait and try your command again later.

There is a SAP Note available that describes the recovery process step-by-step:

1618817 - SYB: How to restore an SAP ASE database server (UNIX)

1611715 - SYB: How to restore an SAP ASE database server (Windows)

If the recovery was successfull, try to set the database to online:

online database <DB_NAME>

Beyçelik
Explorer
0 Kudos

hi dear, recovery was succesfull i tried some way but i haven't any reaction.

Answers (2)

Answers (2)

Beyçelik
Explorer
0 Kudos

Thank you Jong-un Seo, Bartosz Jarkowski.I sloved it.

jong-un_seo
Participant
0 Kudos

Hi,

After connecting to the ASE server using isql, please check the status of CO2 database.

sp_helpdb CO2
go

As Bartosz mentioned, CO2 database is not online yet.
If CO2 is online now, you can change to CO2 as the current database.

use CO2
go

Regards,
Jongun