SICK - ECC6 MS-SQL 2005/W3K
Installed ECC 6 on MS-SQL 2005/W3K Server after generating SGEN system is throwing the the following runtime error whenever we login.
-------------------------------------------------------------
Runtime Errors START_CALL_SICK
Date and Time 17.09.2006 09:22:40
Short text
Database inconsistency: Start Transaction SICK.
What happened?
The current program had to be terminated because of an
error when installing the R/3 System.
The error occurred when initializing the R/3 System.
-
What can you do?
Please call the Transaction SICK. The list generated here
contains an installation error.
Note which actions and input led to the error.
For further help in handling the problem, contact your SAP administrator
.
You can use the ABAP dump analysis transaction ST22 to view and manage
termination messages, in particular for long term reference.
Error analysis
The error probably occurred when installing the
R/3 system.
Error text of the first reported error:
"DB CHECK Jobs are created with wrong backup parameters. Please see note
126973".
How to correct the error
Report the error to the group responsible for installing your
R/3 System.
If the error occures in a non-modified SAP program, you may be able to
find an interim solution in an SAP Note.
If you have access to SAP Notes, carry out a search with the following
keywords:
"START_CALL_SICK" " "
"SAPMSYST" or "SAPMSYST"
"D020_SNC_CHECK_EXTID"
If you cannot solve the problem yourself and want to send an error
notification to SAP, include the following information:
1. The description of the current problem (short dump)
To save the description, choose "System->List->Save->Local File
(Unconverted)".
2. Corresponding system log
Display the system log by calling transaction SM21.
Restrict the time interval to 10 minutes before and five minutes
after the short dump. Then choose "System->List->Save->Local File
(Unconverted)".
3. If the problem occurs in a problem of your own or a modified SAP
program: The source code of the program
In the editor, choose "Utilities->More
Utilities->Upload/Download->Download".
4. Details about the conditions under which the error occurred or which
actions and input led to the error.
System environment
SAP-Release 700
Application server... "----------------"
Network address...... "--------------"
Operating system..... "Windows NT"
Release.............. "5.2"
Hardware type........ "4x Intel 801586"
Character length.... 16 Bits
Pointer length....... 32 Bits
Work process number.. 0
Shortdump setting.... "full"
Database server... "--------------\E6D"
Database type..... "MSSQL"
Database name..... "E6D"
Database user ID.. "e6d"
Char.set.... "C"
SAP kernel....... 700
created (date)... "Apr 2 2006 23:08:16"
create on........ "NT 5.0 2195 Service Pack 4 x86 MS VC++ 13.10"
Database version. "SQL_Server_8.00 "
Patch level. 52
Patch text.. " "
Database............. "MSSQL 7.00.699 or higher, MSSQL 8.00.194"
SAP database version. 700
Operating system..... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2"
Memory consumption
Roll.... 8176
EM...... 2090448
Heap.... 0
Page.... 0
MM Used. 782640
MM Free. 1306288
User and Transaction
Client.............. 000
User................ "SAP*"
Language key........ "E"
Transaction......... "SESSION_MANAGER "
Program............. "SAPMSYST"
Screen.............. "SAPMSYST 0020"
Screen line......... 74
Information on where terminated
Termination occurred in the ABAP program "SAPMSYST" - in
"D020_SNC_CHECK_EXTID".
The main program was "SAPMSYST ".
In the source code you have the termination point in line 1766
of the (Include) program "SAPMSYST".
Contents of system fields
Name Val.
SY-SUBRC 0
SY-INDEX 0
SY-TABIX 1
SY-DBCNT 0
SY-FDPOS 0
SY-LSIND 0
SY-PAGNO 0
SY-LINNO 1
SY-COLNO 1
SY-PFKEY 0020
SY-UCOMM
SY-TITLE System Program
SY-MSGTY
SY-MSGID
SY-MSGNO 000
SY-MSGV1
SY-MSGV2
SY-MSGV3
SY-MSGV4
SY-MODNO 0
SY-DATUM 20060917
SY-UZEIT 092232
SY-XPROG SAPCNVE
SY-XFORM CONVERSION_EXIT
Active Calls/Events
No. Ty. Program Include Line
Name
1 MODULE (PAI) SAPMSYST SAPMSYST 1766
D020_SNC_CHECK_EXTID
Chosen variables
Name
Val.
No. 1 Ty. MODULE (PAI)
Name D020_SNC_CHECK_EXTID
RC
0
0000
0000
SY-REPID
SAPMSYST
5454555522222222222222222222222222222222
310D393400000000000000000000000000000000
0000000000000000000000000000000000000000
0000000000000000000000000000000000000000
RSYST-FCODE
22222222222222222222
00000000000000000000
00000000000000000000
00000000000000000000
C_MAXUSR
312
3000
8100
RSYST-MANDT
000
333
000
000
000
SYST-REPID
SAPMSYST
5454555522222222222222222222222222222222
310D393400000000000000000000000000000000
0000000000000000000000000000000000000000
0000000000000000000000000000000000000000
RSYST-BNAME
SAP*
545222222222
310A00000000
000000000000
000000000000
RSYST-BCODE
2222222222222222222222222222222222222222
0000000000000000000000000000000000000000
0000000000000000000000000000000000000000
0000000000000000000000000000000000000000
SCREEN
IUSRACL-BNAME
4555444244444222222222222222222222222222222222222222222222222222222222222222222222222222222222
953213CD2E1D5000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
SY-MSGID
22222222222222222222
00000000000000000000
00000000000000000000
00000000000000000000
NEWCODE
22222222
00000000
00000000
00000000
PWD_RC
0
0000
0000
SPACE
2
0
0
0
SY-MSGNO
000
333
000
000
000
C_LOW_DATE
19000101
33333333
19000101
00000000
00000000
SY-MSGV1
##################################################
00000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000
SY-MSGV2
##################################################
00000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000
SY-MSGV3
##################################################
00000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000
SY-MSGV4
##################################################
00000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000
Internal notes
The termination was triggered in function "ab_check_sick"
of the SAP kernel, in line 2810 of the module
"//bas/700_REL/src/krn/runt/abinit.c#11".
The internal operation just processed is "----".
Internal mode was started at 20060917092210.
Active Calls in SAP Kernel
Lines of C Stack in Kernel (Structure Differs on Each Platform)
SAP (R) - R/3(TM) Callstack, Version 1.0
Copyright (C) SAP AG. All rights reserved.
Callstack without Exception:
App : disp+work.EXE (pid=2384)
When : 9/17/2006 9:22:40.905
Threads : 2
Computer Name : DEVR01D3801
User Name : SAPServiceE6D
Number of Processors: 4
Processor Type: x86 Family 15 Model 4 Stepping 10
Windows Version : 5.2 Current Build: 3790
State Dump for Thread Id 954
eax=0000abc6 ebx=00000350 ecx=00000040 edx=00000000 esi=00000350 edi=00000000
eip=7c82ed54 esp=053fceb4 ebp=053fcf24 iopl=0 nv up ei ng nz ac po cy
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000297
function : KiFastSystemCallRet
7c82ed54 c3 ret
7c82ed55 8da42400000000 lea esp,[esp] ss:053fceb4=7c822124
7c82ed5c 8d642400 lea esp,[esp] ss:6621b4c7=????????
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
053fcf24 77e6ba42 00000350 0001d4c0 00000000 053fcf5c ntdll!KiFastSystemCallRet
053fcf38 0100b3aa 00000350 0001d4c0 00000001 7c38b5c8 kernel32!WaitForSingleObject
053fcf5c 0055b4ac 0055b4e5 7c38b5c8 7c38b5c8 7c38b5c8 disp+work!NTDebugProcess [ntstcdbg.c (501)]
053fcf60 0055b4e5 7c38b5c8 7c38b5c8 7c38b5c8 01d35ab0 disp+work!NTStack [dptstack.c (1365)]
053fcf7c 0055b519 7c38b5c8 00000000 008536a8 7c38b5c8 disp+work!CTrcStack2 [dptstack.c (352)]
053fcf88 008536a8 7c38b5c8 00000000 005f0059 00300030 disp+work!CTrcStack [dptstack.c (182)]
053fcfac 008569fa 00000000 29e9dc66 00000000 053fd078 disp+work!rabax_CStackSave [abrabax.c (6871)
053fd084 00872b39 0144f6ac 0144f68c 00000afa 5a796de8 disp+work!ab_rabax [abrabax.c (1213)]
053fd09c 005e15f0 29e9dc50 00000000 29e9dc7e 053fd148 disp+work!ab_check_sick [abinit.c (2810)]
053fd0b0 005e42d9 29e9dc60 053fd0e8 29e9dd6e 00000041 disp+work!DyISigni [sign.c (1428)]
053fd148 00596b3d 29ea0c90 29ea54de 00000000 00590053 disp+work!syssigni [sign.c (720)]
053fd270 00598503 00000000 29ea0c90 00000001 00000000 disp+work!dynpmcal [dymainstp.c (2273)]
053fd284 00597b13 00000001 29ea0c90 00000003 053ffd04 disp+work!dynppai0 [dymainstp.c (1108)]
053fd2a0 0056dcf1 29ea0c90 00000001 00000000 00000002 disp+work!dynprctl [dymainstp.c (359)]
053ffd04 00471848 00000002 ffffffff 00000001 00494960 disp+work!dynpen00 [dymain.c (1405)]
053ffd0c ffffffff 00000001 00494960 00000002 01c72400 disp+work!Thdynpen00 [thxxhead.c (4632)]
053ffee0 00494ee2 00000001 00000000 00000000 00430000 <nosymbols>
053fff00 00421150 00000000 00000000 7ffd4000 053fff60 disp+work!ThStart [thxxhead.c (1145)]
053fff14 00401080 00000003 003f6680 00000001 00000000 disp+work!DpMain [dpxxdisp.c (1113)]
053fff60 011a94a0 00000003 003f6680 003f7208 01bd5000 disp+work!nlsui_main [thxxanf.c (82)]
053fffc0 77e523e5 00000000 00000000 7ffd4000 8a308300 disp+work!wmainCRTStartup [crtexe.c (395)]
053ffff0 00000000 011a935d 00000000 00905a4d 00000003 kernel32!IsProcessorFeaturePresent
State Dump for Thread Id 9bc
eax=00000001 ebx=00000103 ecx=fffffffe edx=003f0000 esi=00000000 edi=00000000
eip=7c82ed54 esp=06d2fec0 ebp=06d2ff04 iopl=0 nv up ei pl zr na po nc
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000246
function : KiFastSystemCallRet
7c82ed54 c3 ret
7c82ed55 8da42400000000 lea esp,[esp] ss:06d2fec0=7c821514
7c82ed5c 8d642400 lea esp,[esp] ss:67b4e4d3=????????
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
06d2ff04 010f7ffc 000006c8 00000000 00000000 003ffd70 ntdll!KiFastSystemCallRet
06d2ff84 7c349565 00000000 00000000 00000000 003ffcd8 disp+work!SigIMsgFunc [signt.c (594)]
06d2ffb8 77e6608b 003ffcd8 00000000 00000000 003ffcd8 MSVCR71!endthreadex
06d2ffec 00000000 7c3494f6 003ffcd8 00000000 00000000 kernel32!GetModuleFileNameA
List of ABAP programs affected
Index Typ Program Group Date Time Size Lang.
0 Prg SAPMSYST 0 15.09.2006 12:52:49 110592 E
1 Typ RSYST 0 19.07.2004 10:44:06 11264
2 Prg SAPMSSYD 0 15.09.2006 12:52:43 21504 E
3 Prg SAPFSYSCALLS 0 09.09.2004 14:18:32 8192 E
4 Typ DOKIL 0 12.05.1997 16:46:17 3072
5 Typ TLINE 0 08.03.1992 00:19:59 2048
6 Prg %_CCXTAB 0 18.02.2005 14:15:08 7168 E
7 Typ SCXTAB_CONTROL 0 18.05.2004 14:07:29 6144
8 Prg SAPLSNCA 8 15.09.2006 11:20:11 35840 E
9 Typ SCXTAB_CONTROL 0 18.05.2004 14:07:29 6144
10 Prg SAPCNVE 10 09.09.2004 14:36:10 8192 E
11 Prg SAPLLANG 11 09.09.2004 14:18:35 10240 E
12 Prg SAPFSPOR 0 09.09.2004 14:18:32 15360 E
13 Prg SAPLSCNT 13 18.02.2005 14:16:06 30720 E
14 Typ DYCBOX 0 20.08.1998 11:16:53 3072
15 Prg SAPLSVSM 15 18.02.2005 14:16:06 27648 E
16 Prg SAPLSGUI 16 15.09.2006 12:52:47 82944 E
17 Prg SAPLSTTM 17 05.07.2005 13:10:18 69632 E
18 Prg SAPLSBDC 18 05.07.2005 13:10:18 44032 E
19 Prg CL_DATAPROVIDER===============CP 19 28.02.2005 21:00:46 49152 E
20 Prg %_CCNTL 19 18.02.2005 14:15:08 15360 E
21 Typ OBJ_RECORD 0 14.02.1998 08:30:43 2048
22 Prg SAPLSTUP 22 08.03.2005 19:04:31 73728 E
23 Prg SAPLCNDP 23 15.09.2006 11:17:39 193536 E
24 Prg SAPSHDTV 13 05.01.2005 16:26:16 33792 E
25 Prg SAPFGUICNTL 0 18.02.2005 14:15:08 24576 E
26 Prg SAPLOLEA 26 05.07.2005 13:10:18 96256 E
27 Prg SAPLSFES 27 15.09.2006 12:52:47 254976 E
28 Prg SAPLTHFB 28 15.09.2006 12:52:47 389120 E
29 Typ WPINFO 0 26.02.1999 14:49:01 6144
30 Prg SAPLURFC 30 15.06.2005 11:39:01 22528 E
31 Prg SAPLSPLUGIN 31 09.09.2004 14:18:36 8192 E
32 Typ SWCBCONT 0 15.11.2000 17:55:11 3072
33 Typ OLE_VERBS 0 04.04.1995 16:02:20 2048
34 Typ OLE_PA 0 04.04.1995 16:02:19 2048
35 Prg CL_GUI_PROPS_CONSUMER=========CP 35 18.02.2005 14:15:08 30720 E
36 Typ EUDB 0 06.11.2003 20:28:08 8192
37 Prg CL_DYNAMIC_GUI_EXTENSIONS=====CP 37 18.02.2005 14:15:28 37888 E
38 Prg CL_GUI_DATAMANAGER============CP 38 05.07.2005 13:10:15 75776 E
39 Prg CL_ABAP_CHAR_UTILITIES========CP 39 05.07.2005 13:10:15 13312 E
40 Typ ARFCRDATA 0 13.02.2005 18:20:24 7168
41 Prg SAPLGRFC 41 13.02.2005 18:20:25 16384 E
42 Typ SYST 0 09.09.2004 14:18:12 31744
Directory of Application Tables
Name Date Time Lngth
Val.
Program SAPMSYST
SYST . . : : 00004612
\0\0\0\0\x0001\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\x0001
RSYST 19.07.2004 10:44:06 00001574
000SAP*
Program CL_GUI_PROPS_CONSUMER=========CP
EUDB . . : : 00004068
%L00010000E644FE8E7D7A489582116C630FFF4706 \0\0\0
ABAP Control Blocks (CONT)
Index Name Fl PAR0 PAR1 PAR2 PAR3 PAR4 PAR5 PAR6 Source Code Line
2432 BRAT 02 0003 SAPMSYST 1759
2433 CMPS 20 0242 01C6 01C6 SAPMSYST 1759
2435 BRAF 02 000C SAPMSYST 1759
2436 MOVL 00 0002 00A5 004B SAPMSYST 1762
2438 mlq1 02 0005 0F50 0045 SAPMSYST 1762
2440 MOVL 00 0008 00A6 00E7 SAPMSYST 1762
2442 CLEA 00 00A7 SAPMSYST 1762
2443 CLEA 00 00A8 SAPMSYST 1762
2444 CLEA 00 00A9 SAPMSYST 1762
2445 CLEA 00 00AA SAPMSYST 1762
2446 MESS 00 00E7 SAPMSYST 1762
2447 ENDM 00 0000 SAPMSYST 1766
>>>>> ---- 00 0000 SAPMSYST 1766
2449 PERP 00 0003 SAPMSYST 1781
2450 PERP 10 0000 SAPMSYST 1781
2451 PERP 10 0000 SAPMSYST 1781
2452 PERP 11 0000 SAPMSYST 1781
2453 mvqs 04 0083 0000 0000 SAPMSYST 1786
2455 BREL 04 0000 SAPMSYST 1788
2456 cmpr 00 00CA 8001 0001 SAPMSYST 1789
--------------------------------------------
Tcode SICK
--------------------------------------------
SAP System Check
DB CHECK Jobs are created with wrong backup parameters. Please see note 126973
DB CHECK DB CHECK DB CHECK DB CHECK DB CHECK DB CHECK DB CHECK DB CHECK DB
Severe problems were detected during initial system check.
Please, do not use that system before fixing these problems.
As per note 142731 I executed Database consistancy check and got the following result.
"Command(s) completed successfully."
Tcode SICK
--------------------------------------------
SAP System Check
DB CHECK Jobs are created with wrong backup parameters. Please see note 126973
DB CHECK DB CHECK DB CHECK DB CHECK DB CHECK DB CHECK DB CHECK DB CHECK DB
Severe problems were detected during initial system check.
Please, do not use that system before fixing these problems.
-------------------------------------------
Any help will be appreciated
Regards
mrPal
Try to implement the latest SAP kernel and DLL files.
Kernel yes I did and patches applied latest minus one, but did not solve the problem.
Just executed RSMSSDELSQLJOBS and solved the issue.
Amazing !!! just to find out this spend more than 10 hours.
Tx. Reg
mrPal
The ABAP you just mentioned is for DB13 jobs and upgrades. Right? And you did a fresh install. Right?
Yes it is DB13 jobs, I did not perform fresh installation. If I schedule backup jobs the problem exist, please tell me how to schedule backup jobs for MS-SQL 2005.
Tx. & Reg
mrPal
Installed ECC 6 on MS-SQL 2005/W3K Server after generating SGEN system
Looks a fresh install to me.....