on 05-10-2016 4:07 AM
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: */
C
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
M Info for wp 0
M
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
M ThIErrHandle: current request:
M
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 *
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
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.