cancel
Showing results for 
Search instead for 
Did you mean: 

disp+work.exe stopped - after the restoration of database

former_member373052
Discoverer
0 Kudos

Hi Guys,

Please help me with this error. this occurs after the database restoration.

OS: Windows 2012

Database: MS SQL 2012

Here is the dev_w0

C  ERROR: -1 in function CheckCodepageType (SQLExecDirect failed) [line 21795]

C  (208) [42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'DBPROPERTIES'.

C  comm. rd. spid 71

C  unc. rd. spid 72

B  Connection 0 opened (DBSL handle 0)

C  ERROR: -1 in function StartSelect (execute) [line 14752]

C  (208) [42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'SVERS'.

C  ERROR: -1 in function StartSelect (execute) [line 14752]

C  (8180) [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared.

C  Error 103 (dbcode 208) in StartSelect

C  StartSelect: stmt of NULL_STMTID

C  SELECT VERSION FROM SVERS

C  /* R3::0 T:SVERS M:    */

B  ***LOG BZA=> table SVERS does not exist on database  [dblink       1327]

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

M  in_ThErrHandle: 1

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

M  Info for wp 0

M    pid = 3900

M    severity = 0

M    status = 0

M    stat = WP_NEW

M    waiting_for = NO_WAITING

M    reqtype = DP_RQ_DIAWP

M    act_reqtype = NO_REQTYPE

M    req.req_info =

M    req.tid = -1

M    req.uid = 4294967295

M    req.mode = 255

M    req.len = 0

M    req.rq_id = 65535

M    req.rq_source =

M    last_tid = 0

M    last_uid = 0

M    last_mode = 0

M    locked semaphores (), locking ()

M    act_cs_count = 1

M    csTrack = 0

M    csTrackRwExcl = 0

M    csTrackRwShrd = 0

M    mode_cleaned_counter = 0

M    control_flag = 0

M    int_checked_resource(RFC) = 0

M    ext_checked_resource(RFC) = 0

M    int_checked_resource(HTTP) = 0

M    ext_checked_resource(HTTP) = 0

M    report = >                                        <

M    action = 0

M    tab_name = >                              <

M    attachedVm = no VM

M  ThIErrHandle: current request:

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

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

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

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

M  *

M  *  LOCATION    SAP-Server SNPSAP_SNP_00 on host SNPSAP (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Tue May 10 09:53:23 2016

M  *  RELEASE     721

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        11865

M  *  COUNTER     1

M  *

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

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP

M  ThCallHooks: hook >ThrBtcCallLgCl< o.k.

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M  ThIErrHandle: entering ThSetStatError

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

M  Entering ThReadDetachMode

M  call ThrShutDown (1)...

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

Thank you

Ron

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ron,

Please check the below sap note..

1907868 - SAP system cannot connect to SQL Server after Alwayson failover.

Also, please check if Database consistencies is intact by running the below command in SQL studio.

DBCC CHECKDB ('<SID>') WITH NO_INFOMSGS

Regards

Prithviraj.

former_member373052
Discoverer
0 Kudos

Hi Prithviraj,

Im new to sap and sql, do you have a guide on how to execute the stored procedure?

Thank you so much

Former Member
0 Kudos

Hi,

Please go through below wiki...

Stored Procedure Universe Best Practice Guide - Business Intelligence (BusinessObjects) - SCN Wiki

There are few sap notes mentioned at the end of wiki.

Hope this is what you;re looking for.

Regards

Prithviraj.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Nel,

Make sure that SQL is up and running (check the services)

Based in the logs above, it seems your application server can't connect to database.

run Ms SQL Server Management studio and login to the database.

Login as administrator in DB server and try to check the authentication mode of the database, it should be using windows authentication.After that, check SIDadm user access to the database.


Try to login using SIDadm to db server and open Ms SQL Server Management Studio. Can you connect to the database ?

Regards,

Carroll M