Hi, It looks like you have a Database error have you performed a checkdb? The database problem could be due to hardware issues. Check SAP note 1478133 Regards
| | | ---------------Original Message--------------- From: Balamurugan R Sent: Friday, July 01, 2011 10:56 AM Subject: Job is in ready status in ECC HI All, I am using ECC 6.0 with SQL 2008 Windows NT server 2003. We are releasing jobs from tivoli and run in SAP, Jobs are successfully released from tivoli and work process is not allocated for the job and it hungs in ready state for long time. im attaching the error log from SM21 during the which the job is in ready state.It is frequently happening and most of the critical jobs is getting stuck. kindly advice. Fri Jun 17 23:30:58 2011 C ERROR: -1 in function StartSelect (execute) [line 10756] C (10054) [08S01] [Microsoft][SQL Server Native Client 10.0]TCP Provider: An existing connection was forcibly closed by the remote host. C C native_db_err 10054 severity 0 errclass set to DBSL_EC_RESTART C sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART C ERROR: -1 in function StartSelect (execute) [line 10756] C (10054) [08S01] [Microsoft][SQL Server Native Client 10.0]Communication link failure B ***LOG BYM=> severe DB error 10054 ; work process in reconnect status [dbsh#3 @ 1127] [dbsh 1127 ] B ***LOG BY4=> sql error 10054 performing SEL on table TST01 [dbtrtab#7 @ 3914] [dbtrtab 3914 ] B ***LOG BY0=> [Microsoft][SQL Server Native Client 10.0]TCP Provider: An existing connection was forcibly closed by the remote host. [dbtrtab#7 @ 3914] [dbtrtab 3914 ] M ***LOG GZZ=> retry creation JOBLGX [btctlgow.c 216] C ERROR: -1 in function StartSelect (execute) [line 10756] C (0) [08S01] [Microsoft][SQL Server Native Client 10.0]Communication link failure C 1 times error (0,0) or (-1,0) in sequence B ***LOG BY4=> sql error 0 performing SEL on table TST01 [dbtrtab#7 @ 3914] [dbtrtab 3914 ] B ***LOG BY0=> [Microsoft][SQL Server Native Client 10.0]Communication link failure [dbtrtab#7 @ 3914] [dbtrtab 3914 ] M ***LOG GZZ=> retry creation JOBLGX [btctlgow.c 216] C ERROR: -1 in function StartSelect (execute) [line 10756] C (0) [08S01] [Microsoft][SQL Server Native Client 10.0]Communication link failure C 2 times error (0,0) or (-1,0) in sequence B ***LOG BY4=> sql error 0 performing SEL on table TST01 [dbtrtab#7 @ 3914] [dbtrtab 3914 ] B ***LOG BY0=> [Microsoft][SQL Server Native Client 10.0]Communication link failure [dbtrtab#7 @ 3914] [dbtrtab 3914 ] M ***LOG GZZ=> retry creation JOBLGX [btctlgow.c 216] C ERROR: -1 in function StartSelect (execute) [line 10756] C (0) [08S01] [Microsoft][SQL Server Native Client 10.0]Communication link failure C 3 times error (0,0) or (-1,0) in sequence B ***LOG BY4=> sql error 0 performing SEL on table TST01 [dbtrtab#7 @ 3914] [dbtrtab 3914 ] B ***LOG BY0=> [Microsoft][SQL Server Native Client 10.0]Communication link failure [dbtrtab#7 @ 3914] [dbtrtab 3914 ] L *** ERROR => BtcEnvPrep: BtcLgOw failed: jobname=SAPSD_SEV2NA-ECC-A-D-INSIEBNA , jobcount=23304601, rc=4 [btcjcntl.c 1555] C ERROR: -1 in function StartSelect (execute) [line 10756] C (10054) [08S01] [Microsoft][SQL Server Native Client 10.0]TCP Provider: An existing connection was forcibly closed by the remote host. C C native_db_err 10054 severity 0 errclass set to DBSL_EC_RESTART C sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART C ERROR: -1 in function StartSelect (execute) [line 10756] C (10054) [08S01] [Microsoft][SQL Server Native Client 10.0]Communication link failure B ***LOG BYM=> severe DB error 10054 ; work process in reconnect status [dbsh#3 @ 1127] [dbsh 1127 ] B ***LOG BY4=> sql error 10054 performing SEL on table TBTCO [dbtrtab#7 @ 3914] [dbtrtab 3914 ] B ***LOG BY0=> [Microsoft][SQL Server Native Client 10.0]TCP Provider: An existing connection was forcibly closed by the remote host. [dbtrtab#7 @ 3914] [dbtrtab 3914 ] L *** ERROR => BtcDbGet: db_rtab(RT_READ_FOR_UPDATE) failed: jobname=SAPSD_SEV2NA-ECC-A-D-INSIEBNA , jobcount=23304601, rc=1 [btcdbif.c 936] M ThICommit3: db unusable C C Fri Jun 17 23:31:08 2011 C ERROR: -1 in function DoPing (SQLExecDirect failed) [line 11243] C (10054) [08S01] [Microsoft][SQL Server Native Client 10.0]TCP Provider: An existing connection was forcibly closed by the remote host. C C native_db_err 10054 severity 0 errclass set to DBSL_EC_RESTART C sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART C ERROR: -1 in function DoPing (SQLExecDirect failed) [line 11243] C (10054) [08S01] [Microsoft][SQL Server Native Client 10.0]Communication link failure B Reconnect state is entered by connection: B 000: name = R/3, con_id = 000000000, state = ACTIVE , tx = YES, hc = NO , perm = YES, B reco = YES, frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO B RECONNECT: rsdb/reco_trials: 3 B RECONNECT: rsdb/reco_sleep_time: 5 B RECONNECT: rsdb/reco_sync_all_server: OFF B db_con_reconnect: reconnecting to connection 0: B 000: name = R/3, con_id = 000000000, state = ACTIVE , tx = YES, hc = NO , perm = YES, B reco = YES, frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO B disconnecting from connection 0 ... C ERROR: -1 in function DbSlRollback (ROLLBACK) [line 3042] C (-2147467259) [08S01] [Microsoft][SQL Server Native Client 10.0]Communication link failure C Rollback Work (99) B disconnected from connection 0 B opening connection 0 ... C Thread ID:204 C Thank You for using the SLODBC-interface C Using dynamic link library 'E:\usr\sap\ECP\D16\exe\dbmssslib.dll' C dbmssslib.dll patch info C SAP patchlevel 0 C SAP patchno 289 C Last MSSQL DBSL patchlevel 0 C Last MSSQL DBSL patchno 289 C Last MSSQL DBSL patchcomment Syntax error caused by SQL hints (1555289) C Network connection used from USLEXECP08 to ECPDSQL01 using tcp:ECPDSQL01 C Network connection used from USLEXECP08 to ECPDSQL01 using tcp:ECPDSQL01 C Driver: sqlncli10.dll Driver release: 10.00.2531 C GetDbRelease: 10.00.4000 C GetDbRelease: Got DB release numbers (10,0,4000) B Connection 0 opened (DBSL handle 0) B successfully reconnected to connection 0 A | | __.____._ Copyright © 2011 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251 | | D. Caddick SAP Basis Top Contributor
Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement Popular White Papers In the Spotlight _.____.__ |