SUM Postprocessing fails in step MAIN_POSTP/RUN_RSREGENLOD

[Former Member]

During Sum update the Postprocessing fails Solution Manager 7.1 Stack 10

MAIN_POSTP/RUN_RSREGENLOD!

Last error code set: Batchjob 'RSGEN_LOAD_SHADOW' I get the same dump running sgen

ST 22 Dump

Category ABAP Programming Error
Runtime Errors DBIF_RSQL_TABLE_UNKNOWN
ABAP Program CL_SGEN_DB====================CP
Application Component BC-UPG
Date and Time 21.11.2013 15:41:23
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Short text |
| A table is unknown or does not exist. |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|What happened? |
| Error in the ABAP Application Program |
| |
| The current ABAP program "CL_SGEN_DB====================CP" had to be |
| terminated because it has |
| come across a statement that unfortunately cannot be executed. |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|What can you do? |
| Note down which actions and inputs caused the error. |
| |
| |
| To process the problem further, contact you SAP system |
| administrator. |
| |
| Using Transaction ST22 for ABAP Dump Analysis, you can look |
| at and manage termination messages, and you can also |
| keep them for a long time. |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Error analysis |
| A table is referred to in an SAP Open SQL statement that either does not |
| exist or is unknown to the ABAP Data Dictionary. |
| The table involved is "GENSETM" or another table accessed in the statement. |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|How to correct the error |
| Probably the only way to eliminate the error is to correct the program. |
| - |
| Please check the entries in the system log (Transaction SM21). |
| Internal call code.........: "[RSQL/COUN/GENSETM ]" |
| |
| 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: |
| |
| "DBIF_RSQL_TABLE_UNKNOWN" " " |
| "CL_SGEN_DB====================CP" or "CL_SGEN_DB====================CM002" |
| "IF_SGEN_DB~COUNT_GENSETM" |
| |
| |
| |
| 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..... 702 |
| SAP Basis Level. 0013 |
| |
| Application server... "REK-SAPSM-P01" |
| Network address...... "10.100.32.12" |
| Operating system..... "Windows NT" |
| Release.............. "6.1" |
| Hardware type........ "4x AMD64 Level" |
| Character length.... 16 Bits |
| Pointer length....... 64 Bits |
| Work process number.. 6 |
| Shortdump setting.... "full" |
| |
| Database server... "REK-SQLDB-P15\REK_SQ" |
| Database type..... "MSSQL" |
| Database name..... "SML" |
| Database user ID.. "sml" |
| |
| Terminal.......... "LAP-IST001332" |
| |
| Char.set.... "C" |
| |
| SAP kernel....... 720 |
| created (date)... "Nov 10 2013 23:46:46" |
| create on........ "NT 5.2 3790 S x86 MS VC++ 14.00" |
| Database version. "SQL_Server_9.00 " |
| |
| Patch level. 518 |
| Patch text.. " " |
| |
| Database............. "MSSQL 9.00.2047 or higher" |
| SAP database version. 720 |
| Operating system..... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2, Windows |
| NT 6.0, Windows NT 6.1, Windows NT 6.2, Windows NT 6.3" |
| |
| Memory consumption |
| Roll.... 0 |
| EM...... 8379584 |
| Heap.... 0 |
| Page.... 40960 |
| MM Used. 1088320 |
| MM Free. 3098800 |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|User and Transaction |
| Client.............. 000 |
| User................ "VIDARSV" |
| Language key........ "E" |
| Transaction......... "SGEN " |
| Transaction ID...... "5EC352E3296FF19BA3FC005056896B9F" |
| |
| EPP Whole Context ID.... "005056896B9F1EE394D7CA9CACB723FC" |
| EPP Connection ID....... 00000000000000000000000000000000 |
| EPP Caller Counter...... 0 |
| |
| Program............. "CL_SGEN_DB====================CP" |
| Screen.............. "SAPMSSY0 1000" |
| Screen Line......... 6 |
| Debugger Active..... "none" |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Information on where terminated |
| Termination occurred in the ABAP program "CL_SGEN_DB====================CP" - |
| in "IF_SGEN_DB~COUNT_GENSETM". |
| The main program was "RSPARAGENLODM ". |
| |
| In the source code you have the termination point in line 16 |
| of the (Include) program "CL_SGEN_DB====================CM002". |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Source Code Extract (Source code has changed) |
----------------------------------------------------------------------------------------------------
|Line |SourceCde |
----------------------------------------------------------------------------------------------------
| 1|METHOD if_sgen_db~count_gensetm. |
| 2| IF ev_total IS SUPPLIED. |
| 3| IF iv_machtype IS SUPPLIED. |
| 4| SELECT COUNT(*) FROM gensetm INTO ev_total WHERE machtype = iv_machtype. "#EC CI_NOFIR|
| 5| ELSE. |
| 6| SELECT COUNT(*) FROM gensetm INTO ev_total. "#EC CI_NOWHERE |
| 7| ENDIF. |
| 8| ENDIF. |
| 9| |
| 10| IF ev_not_generated IS SUPPLIED. |
| 11| IF iv_machtype IS SUPPLIED. |
| 12| SELECT COUNT(*) FROM gensetm INTO ev_not_generated WHERE ( genstatus = if_sgen_constan|
| 13| genstatus = if_sgen_constan|
| 14| machtype = iv_machtype. |
| 15| ELSE. |
|>>>>>| SELECT COUNT(*) FROM gensetm INTO ev_not_generated WHERE ( genstatus = if_sgen_constan|
| 17| genstatus = if_sgen_constan|
| 18| ENDIF. |
| 19| ENDIF. |
| 20| |
| 21| IF ev_done IS SUPPLIED. |
| 22| IF iv_machtype IS SUPPLIED. |
| 23| SELECT COUNT(*) FROM gensetm INTO ev_done WHERE ( genstatus = if_sgen_constants=>gc_g|
| 24| OR genstatus = if_sgen_constants=>gc_ge|
| 25| OR genstatus = if_sgen_constants=>gc_ge|
| 26| AND machtype = iv_machtype. |
| 27| ELSE. |
| 28| SELECT COUNT(*) FROM gensetm INTO ev_done WHERE ( genstatus = if_sgen_constants=>gc_g|
| 29| OR genstatus = if_sgen_constants=>gc_ge|
| 30| OR genstatus = if_sgen_constants=>gc_ge|
| 31| ENDIF. |
| 32| ENDIF. |
| 33| |
| 34| IF ev_error IS SUPPLIED. |
| 35| IF iv_machtype IS SUPPLIED. |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Contents of system fields |
----------------------------------------------------------------------------------------------------
|Name |Val. |
----------------------------------------------------------------------------------------------------
|SY-SUBRC|4 |
|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| |
|SY-UCOMM| |
|SY-TITLE|SAP Load Generator - Determine Generation Set |
|SY-MSGTY| |
|SY-MSGID| |
|SY-MSGNO|000 |
|SY-MSGV1| |
|SY-MSGV2| |
|SY-MSGV3| |
|SY-MSGV4| |
|SY-MODNO|0 |
|SY-DATUM|20131121 |
|SY-UZEIT|154123 |
|SY-XPROG|RSDBRUNT |
|SY-XFORM|%_INIT_PBO_FIRST |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Active Calls/Events |
----------------------------------------------------------------------------------------------------
|No. Ty. Program Include Line |
| Name |
----------------------------------------------------------------------------------------------------
| 4 METHOD CL_SGEN_DB====================CP CL_SGEN_DB====================CM002 16 |
| CL_SGEN_DB=>IF_SGEN_DB~COUNT_GENSETM |
| 3 METHOD CL_SGEN_JOB_MANAGER===========CP CL_SGEN_JOB_MANAGER===========CM007 72 |
| CL_SGEN_JOB_MANAGER=>IF_SGEN_JOB_MANAGER~GET_JOB_LIST |
| 2 METHOD CL_SGEN_JOB_MANAGER===========CP CL_SGEN_JOB_MANAGER===========CM004 6 |
| CL_SGEN_JOB_MANAGER=>IF_SGEN_JOB_MANAGER~CHECK_ACTIVE_JOB |
| 1 EVENT RSPARAGENLODM RSPARAGENLODM 170 |
| START-OF-SELECTION |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Chosen variables |
----------------------------------------------------------------------------------------------------
|Name |
| Val. |
----------------------------------------------------------------------------------------------------
|No. 4 Ty. METHOD |
|Name CL_SGEN_DB=>IF_SGEN_DB~COUNT_GENSETM |
----------------------------------------------------------------------------------------------------
|IV_MACHTYPE |
| |
| 22222 |
| 00000 |
| 00000 |
| 00000 |
| 20002000200020002000 |
|EV_TOTAL |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|EV_NOT_GENERATED |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|EV_DONE |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|EV_ERROR |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|EV_SYNTAX_ERROR |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|EV_IN_PROGRESS |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|EV_SUCCESSFUL |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|EV_INITIAL |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|ABAP_FALSE |
| |
| 2 |
| 0 |
| 0 |
| 0 |
| 2000 |
|<%_TABLE_GENSETM> |
| ??? |
| ?????? |
| ?????? |
| ???????????? |
|%_DUMMY$$ |
| |
| 2222 |
| 0000 |
| 0000 |
| 0000 |
| 2000200020002000 |
|SYST-REPID |
| CL_SGEN_DB====================CP |
| 4455444544333333333333333333334522222222 |
| 3CF375EF42DDDDDDDDDDDDDDDDDDDD3000000000 |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 43004C005F005300470045004E005F00440042003D003D003D003D003D003D003D003D003D003D003D003D003D003D|
|SY |
| ############################################################################+#³######### ####|
| 000000000000000000000000000000000000001000000000000000000000000000000000000020B000000000220000|
| 0000100000000000000000001000100000000000000000400000000000000000000000000000B03000000000000400|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 000000000000000000000000000000000000005000000000000000000000000000000000000000000000000000000C|
| 0000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000|
|SY-REPID |
| CL_SGEN_DB====================CP |
| 4455444544333333333333333333334522222222 |
| 3CF375EF42DDDDDDDDDDDDDDDDDDDD3000000000 |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 43004C005F005300470045004E005F00440042003D003D003D003D003D003D003D003D003D003D003D003D003D003D|
|SY-MSGV3 |
| |
| 22222222222222222222222222222222222222222222222222 |
| 00000000000000000000000000000000000000000000000000 |
| 00000000000000000000000000000000000000000000000000 |
| 00000000000000000000000000000000000000000000000000 |
| 2000200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020|
|<%_TABLE_TDEVC> |
| ??? |
| ?????? |
| ?????? |
| ???????????? |
----------------------------------------------------------------------------------------------------
|No. 3 Ty. METHOD |
|Name CL_SGEN_JOB_MANAGER=>IF_SGEN_JOB_MANAGER~GET_JOB_LIST |
----------------------------------------------------------------------------------------------------
|ET_JOBS |
| Table[initial] |
| |
|LS_JOB_LIST-NOT_GENERATED |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|%_DUMMY$$ |
| |
| 2222 |
| 0000 |
| 0000 |
| 0000 |
| 2000200020002000 |
|LS_JOB_LIST |
| 00000000000000####000000###### |
| 22222222222222222222222222222222222222222222223333333333333300003333330000FF |
| 00000000000000000000000000000000000000000000000000000000000000000000000000FF |
| 00000000000000000000000000000000000000000000000000000000000000000000000000FF |
| 00000000000000000000000000000000000000000000000000000000000000000000000000FF |
| 2000200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020|
|SYST |
| ############################################################################+#³######### ####|
| 000000000000000000000000000000000000001000000000000000000000000000000000000020B000000000220000|
| 0000100000000000000000001000100000000000000000400000000000000000000000000000B03000000000000400|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 000000000000000000000000000000000000005000000000000000000000000000000000000000000000000000000C|
| 0000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000|
|LV_NOT_GENERATED |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|<%_TABLE_GENSETM> |
| ??? |
| ?????? |
| ?????? |
| ???????????? |
----------------------------------------------------------------------------------------------------
|No. 2 Ty. METHOD |
|Name CL_SGEN_JOB_MANAGER=>IF_SGEN_JOB_MANAGER~CHECK_ACTIVE_JOB |
----------------------------------------------------------------------------------------------------
|EV_IS_ACTIVE |
| |
| 2 |
| 0 |
| 0 |
| 0 |
| 2000 |
|ET_ACTIVE_JOBS |
| Table[initial] |
| |
|SY-REPID |
| CL_SGEN_JOB_MANAGER===========CP |
| 4455444544454444445333333333334522222222 |
| 3CF375EFAF2FD1E1752DDDDDDDDDDD3000000000 |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 43004C005F005300470045004E005F004A004F0042005F004D0041004E0041004700450052003D003D003D003D003D|
|ME |
| {O:6*\CLASS=CL_SGEN_JOB_MANAGER} |
| F0000000 |
| 90006000 |
| F900000006000000 |
|LT_JOBS |
| Table[initial] |
| |
|LS_JOB |
| 00000000000000####000000###### |
| 22222222222222222222222222222222222222222222223333333333333300003333330000FF |
| 00000000000000000000000000000000000000000000000000000000000000000000000000FF |
| 00000000000000000000000000000000000000000000000000000000000000000000000000FF |
| 00000000000000000000000000000000000000000000000000000000000000000000000000FF |
| 2000200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020|
|SY-UZEIT |
| 154123 |
| 333333 |
| 154123 |
| 000000 |
| 000000 |
| 310035003400310032003300 |
|LS_JOB-JOBSTATUS |
| |
| 2 |
| 0 |
| 0 |
| 0 |
| 2000 |
|SYST-REPID |
| CL_SGEN_JOB_MANAGER===========CP |
| 4455444544454444445333333333334522222222 |
| 3CF375EFAF2FD1E1752DDDDDDDDDDD3000000000 |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 43004C005F005300470045004E005F004A004F0042005F004D0041004E0041004700450052003D003D003D003D003D|
|%_SPACE |
| |
| 2 |
| 0 |
| 0 |
| 0 |
| 2000 |
|%_VIASELSCR |
| # |
| 0 |
| 4 |
| 04 |
----------------------------------------------------------------------------------------------------
|No. 1 Ty. EVENT |
|Name START-OF-SELECTION |
----------------------------------------------------------------------------------------------------
|RSJOBINFO |
| 00000000000000 ## |
| 2222222222222222222222222222222233333333333333222222222222222222222222222222222200 |
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
| 2000200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020|
|SYST |
| ############################################################################+#³######### ####|
| 000000000000000000000000000000000000001000000000000000000000000000000000000020B000000000220000|
| 0000100000000000000000001000100000000000000000400000000000000000000000000000B03000000000000400|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 000000000000000000000000000000000000005000000000000000000000000000000000000000000000000000000C|
| 0000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000|
|GX_SGEN |
| {O:initial} |
| F0000000 |
| F0000000 |
| FF00000000000000 |
|CUR |
| |
| 2 |
| 0 |
| 0 |
| 0 |
| 2000 |
|SY |
| ############################################################################+#³######### ####|
| 000000000000000000000000000000000000001000000000000000000000000000000000000020B000000000220000|
| 0000100000000000000000001000100000000000000000400000000000000000000000000000B03000000000000400|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 000000000000000000000000000000000000005000000000000000000000000000000000000000000000000000000C|
| 0000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000|
|GO_SGEN_LOAD |
| {O:5*\CLASS=CL_SGEN_LOAD} |
| F0000000 |
| A0005000 |
| FA00000005000000 |
|SPACE |
| |
| 2 |
| 0 |
| 0 |
| 0 |
| 2000 |
|GO_SGEN_JOB |
| {O:6*\CLASS=CL_SGEN_JOB_MANAGER} |
| F0000000 |
| 90006000 |
| F900000006000000 |
|GV_IS_ACTIVE |
| |
| 2 |
| 0 |
| 0 |
| 0 |
| 2000 |
|ABAP_TRUE |
| X |
| 5 |
| 8 |
| 0 |
| 0 |
| 5800 |
|LV_NOT_GENERATED |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Internal notes |
| The termination was triggered in function "ab_HandleRsqlErrors" |
| of the SAP kernel, in line 724 of the module |
| "//bas/720_REL/src/krn/runt/absapsql.c#27". |
| The internal operation just processed is "SQLS". |
| Internal mode was started at 20131121154123. |
| Internal call code.........: "[RSQL/COUN/GENSETM ]" |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|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=16932) |
|When : 11/21/2013 15:41:21.780 |
|Threads : 2 |
|Computer Name : REK-SAPSM-P01 |
|User Name : SAPServiceSML |
|Number of Processors: 4 |
|Processor Type: Intel64 Family 6 Model 46 Stepping 6 |
|Windows Version : 6.1 Current Build: 7601 |
|State Dump for Thread Id 40b0 |
|0000000002027C40 00000001418B9D46 000000000254E360 disp+work!DumpStacks [ntstcdbg.c (548)] |
|0000000002027D40 0000000140280364 000000007574A000 disp+work!NTDebugProcess [ntstcdbg.c (383)] |
|0000000002027D70 00000001404CA9BA 000000007574A000 disp+work!CTrcStack [dptstack.c (183)] |
|0000000002027DC0 00000001404D060B 000000004DBB0CC8 disp+work!rabax_CStackSave [abrabax.c (8695)] |
|00000000020286D0 00000001405E9BC6 00000000000002D4 disp+work!ab_rabax [abrabax.c (1442)] |
|0000000002028780 000000014065DFA1 0000F63000200020 disp+work!ab_rsqlerr [abdberr.c (953)] |
|0000000002028920 00000001406667BC 0000000000000000 disp+work!SqlsExecuteCall [absapsql.c (7178)] |
|0000000002028AC0 00000001404B9C91 0000000140000000 disp+work!ab_jsqls [absapsql.c (12012)] |
|0000000002028C30 0000000140531910 0000000000000340 disp+work!ab_extri [abextri.c (676)] |
|0000000002028C80 00000001405320D6 0000000000000000 disp+work!ab_xevent [abrunt1.c (336)] |
|0000000002028D10 000000014050C309 00000001000004EB disp+work!ab_trigg [abrunt1.c (60)] |
|0000000002028DA0 00000001402F65E2 000007DF0000002B disp+work!ab_run [absubmit.c (511)] |
|0000000002028F50 00000001402FB354 0000000000000000 disp+work!dynpmcal [dymainstp.c (2742)] |
|0000000002028FE0 00000001402FA503 0000000000000000 disp+work!dynppai0 [dymainstp.c (1359)] |
|00000000020290B0 00000001402ADC17 0000000000000002 disp+work!dynprctl [dymainstp.c (473)] |
|000000000202F320 0000000140117C17 0000000000000000 disp+work!dynpen00 [dymain.c (2070)] |
|000000000202FDF0 00000001401183D9 FFFFFFFFFFFFFF00 disp+work!TskhLoop [thxxhead.c (4955)] |
|000000000202FE50 0000000140030309 000000000254B438 disp+work!ThStart [thxxhead.c (1194)] |
|000000000202FEF0 00000001400010B1 FFFFFFFF00000001 disp+work!DpMain [dpxxdisp.c (1200)] |
|000000000202FF20 0000000141BF0BF0 0000000002030000 disp+work!nlsui_main [thxxanf.c (80)] |
|000000000202FF50 0000000077A4652D 0000000000000000 disp+work!__tmainCRTStartup [crtexe.c (594)] |
|000000000202FF80 0000000077B7C541 0000000000000000 kernel32!BaseThreadInitThunk |
|000000000202FFD0 0000000000000000 0000000000000000 ntdll!RtlUserThreadStart |
|State Dump for Thread Id 1a68 |
|000000000D95FDE0 000007FEFDC53C2F 0000000059D9AF4C ntdll!NtFsControlFile |
|000000000D95FE50 0000000141AC32BF FFFFFFFFFFFFFFFE KERNELBASE!ConnectNamedPipe |
|000000000D95FEF0 00000000756937D7 000000000254F2C0 disp+work!SigIMsgFunc [signt.c (717)] |
|000000000D95FF20 0000000075693894 00000000757495C0 MSVCR80!endthreadex |
|000000000D95FF50 0000000077A4652D 0000000000000000 MSVCR80!endthreadex |
|000000000D95FF80 0000000077B7C541 0000000000000000 kernel32!BaseThreadInitThunk |
|000000000D95FFD0 0000000000000000 0000000000000000 ntdll!RtlUserThreadStart |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Database Interface Information |
----------------------------------------------------------------------------------------------------
|C|1|ERROR: -1 in function StartSelect (execute) [line 14334] [slodbc.c#16916] |
|C|1|(208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'GENSE|
|C|1|ERROR: -1 in function StartSelect (execute) [line 14334] [slodbc.c#16916] |
|C|1|(8180) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be|
|C|1|Error 103 (dbcode 208) in StartSelect [slodbc.c#14335] |
|C|1|StartSelect: stmt of 0 CL_SGEN_DB====================CP 7340330 20111124170502 [slodbc|
|C|1|SELECT TOP 1 COUNT(*) FROM "GENSETM" WHERE "GENSTATUS" = ? OR "GENSTATUS" = ? [slodbc.c#21079|
|C|1|/ [slodbc.c#21079] |
|C|1|* R3:CL_SGEN_DB====================CP:298 T:GENSETM */ [slodbc.c#21072] |
|B|E|***LOG BZA=> table GENSETM does not exist on database R/3 [dbtran#7617] |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|List of ABAP programs affected |
----------------------------------------------------------------------------------------------------
|Index |Typ|Program |Group |Date |Time |Size |Lang. |
----------------------------------------------------------------------------------------------------
| 0|Prg|RSPARAGENLODM | 0|24.11.2011|17:13:12| 68608|E |
| 1|Prg|SAPMSSY0 | 1|23.08.2013|08:59:07| 111616|E |
| 2|Prg|SAPMSSYD | 1|18.11.2013|09:50:42| 25600|E |
| 3|Prg|SAPFSYSCALLS | 1|17.12.2004|10:47:44| 8192|E |
| 4|Prg|RSDBRUNT | 0|26.08.2013|13:31:55| 306176|E |
| 5|Typ|RSSCR | 0|20.06.1997|14:06:55| 5120| |
| 6|Prg|RSDBSPBL | 0|24.11.2011|13:54:25| 84992|E |
| 7|Prg|SAPDB__S | 0|17.12.2004|10:47:44| 21504|E |
| 8|Prg|RSDBSPMC | 0|04.03.2009|10:50:52| 92160|E |
| 9|Typ|DDSHDESCR | 0|28.11.1997|16:26:30| 4096| |
| 10|Typ|SPPARAMS | 0|07.03.1997|14:48:48| 2048| |
| 11|Prg|SAPLSABE | 11|13.01.2010|15:41:25| 14336|E |
| 12|Prg|SAPLSECU | 12|26.08.2013|13:24:42| 110592|E |
| 13|Typ|RSSUBINFO | 0|28.01.2000|04:14:21| 3072| |
| 14|Prg|SAPFSPOR | 1|15.04.2008|15:34:39| 16384|E |
| 15|Prg|SAPLSCNT | 15|19.02.2005|11:28:30| 34816|E |
| 16|Typ|DYCBOX | 0|04.05.1998|15:32:24| 3072| |
| 17|Prg|SAPLSVSM | 17|04.03.2009|11:28:57| 33792|E |
| 18|Prg|SAPLSGUI | 18|24.11.2011|11:29:29| 105472|E |
| 19|Prg|SAPLSTTM | 19|04.03.2009|11:28:57| 79872|E |
| 20|Prg|SAPLSBDC | 20|04.03.2009|11:28:57| 49152|E |
| 21|Prg|CL_DATAPROVIDER===============CP | 21|02.03.2005|15:37:22| 57344|E |
| 22|Prg|SAPSHDTV | 15|18.11.2013|09:50:43| 38912|E |
| 23|Prg|SAPFS_SECLOG | 1|18.11.2013|09:58:56| 16384|E |
| 24|Typ|INDX | 0|29.04.1998|10:21:27| 6144| |
| 25|Prg|SAPFGUICNTL | 1|19.02.2005|11:28:11| 27648|E |
| 26|Prg|SAPLOLEA | 26|24.11.2011|17:49:39| 111616|E |
| 27|Prg|SAPLSFES | 27|26.08.2013|13:55:30| 317440|E |
| 28|Prg|SAPLSPLUGIN | 28|16.02.2010|23:04:04| 9216|E |
| 29|Typ|ARFCRDATA | 0|13.01.2010|15:40:34| 6144| |
| 30|Prg|SAPLGRFC | 30|13.01.2010|15:40:34| 16384|E |
| 31|Typ|SWCBCONT | 0|07.10.1997|12:13:50| 3072| |
| 32|Typ|OLE_VERBS | 0|09.02.1995|13:23:37| 2048| |
| 33|Typ|OLE_PA | 0|13.01.1995|11:06:59| 2048| |
| 34|Prg|CL_SGEN_DB====================CP | 34|24.11.2011|17:05:02| 52224|E |
| 35|Prg|CL_SGEN_LOG===================CP | 35|24.11.2011|17:05:03| 27648|E |
| 36|Prg|SAPLSUGS | 36|18.11.2013|14:44:31| 92160|E |
| 37|Prg|IF_SGEN_CONSTANTS=============IP | 0|24.11.2011|17:11:33| 22528|E |
| 38|Prg|CL_SGEN_LOAD==================CP | 38|23.08.2013|15:23:30| 133120|E |
| 39|Prg|CL_SGEN_JOB_MANAGER===========CP | 39|24.11.2011|17:05:03| 69632|E |
| 40|Typ|SYST | 0|16.12.2004|20:31:11| 30720| |
| 41|Typ|SGEN_JOB_UI_S | 0|24.11.2011|11:02:46| 4096| |
| 42|Typ|RSJOBINFO | 0|09.02.1995|13:25:17| 3072| |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Directory of Application Tables |
----------------------------------------------------------------------------------------------------
|Name Date Time Lngth |
| Val. |
----------------------------------------------------------------------------------------------------
|Program RSPARAGENLODM |
----------------------------------------------------------------------------------------------------
|SYST 16.12.2004 20:31:11 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 |
|SY . . : : 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 |
|RSJOBINFO . . : : 00000164 |
| 00000000000000 |
----------------------------------------------------------------------------------------------------
|Program SAPFS_SECLOG |
----------------------------------------------------------------------------------------------------
|INDX . . : : 00003104 |
| 000%L%_SeclogExcludedCaller\0\0\0 00000000 |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|ABAP Control Blocks (CONT) (Source code has changed) |
----------------------------------------------------------------------------------------------------
|Index|Name|Fl|PAR0|PAR1|PAR2|PAR3|PAR4|PAR5|PAR6|Source Code |Line |
----------------------------------------------------------------------------------------------------
| 282|PAR2|00|0600|0000|0000| | | | |CL_SGEN_DB====================CM002 | 16|
| 284|SQLS|24|0005| | | | | | |CL_SGEN_DB====================CM002 | 16|
| 285|PAR1|00|0003| | | | | | |CL_SGEN_DB====================CM002 | 16|
| 286|PAR1|00|000A| | | | | | |CL_SGEN_DB====================CM002 | 16|
| 287|WHER|29|0002|0000|0000| | | | |CL_SGEN_DB====================CM002 | 16|
| 289|WHER|20|0000|0006|0029| | | | |CL_SGEN_DB====================CM002 | 16|
| 291|PAR1|80|002B| | | | | | |CL_SGEN_DB====================CM002 | 16|
| 292|WHER|20|0000|0006|0029| | | | |CL_SGEN_DB====================CM002 | 16|
| 294|PAR1|80|002C| | | | | | |CL_SGEN_DB====================CM002 | 16|
| 295|SQLS|39|0027| | | | | | |CL_SGEN_DB====================CM002 | 16|
| 296|SQLS|39|0000| | | | | | |CL_SGEN_DB====================CM002 | 16|
| 297|SQLS|3B|0000| | | | | | |CL_SGEN_DB====================CM002 | 16|
|>>>>>|SQLS|03|C002| | | | | | |CL_SGEN_DB====================CM002 | 16|
| 299|CMPS|41|00E2|C003|C003| | | | |CL_SGEN_DB====================CM002 | 21|
| 301|BRAF|02|003C| | | | | | |CL_SGEN_DB====================CM002 | 21|
| 302|BREL|80|0000| | | | | | |CL_SGEN_DB====================CM002 | 21|
| 303|CMPS|41|02DB|C000|C000| | | | |CL_SGEN_DB====================CM002 | 22|
| 305|BRAF|02|0020| | | | | | |CL_SGEN_DB====================CM002 | 22|
| 306|BREL|80|0000| | | | | | |CL_SGEN_DB====================CM002 | 22|
| 307|SQLS|0A|0000| | | | | | |CL_SGEN_DB====================CM002 | 23|
----------------------------------------------------------------------------------------------------

[Former Member · Accepted solution]

Hello,

Can you check if there is enough space in the database.

[Former Member · Accepted solution]

yes autogrowth is in place

[Reagan · Accepted solution]

What is the status of the job RSGEN_LOAD_SHADOW ?

If it is failed what does the job log say ?

Regards

RB

[Former Member · Accepted solution]

Job log overview for job: RSGEN_LOAD_SHADOW / 08510300

---------------------------------------------------------------------------------------------------------------------------------------------
|Date |Time |Message text |Message class|Message no.|Message type|
---------------------------------------------------------------------------------------------------------------------------------------------
|22.11.2013|08:51:03|Job started | 00 | 516 | S |
|22.11.2013|08:51:03|Step 001 started (program RSGEN_LOAD_SHADOW, variant SAP_REGENLOD, user ID DDIC)| 00 | 550 | S |
|22.11.2013|08:51:04|Internal session terminated with a runtime error (see ST22) | 00 | 671 | A |
|22.11.2013|08:51:04|Job cancelled | 00 | 518 | A |
---------------------------------------------------------------------------------------------------------------------------------------------

[Reagan · Accepted solution]

Could you check whether the tabel GENSETM is present at the database level ?

This table is used by for the SGEN process.

Also connect to the SAP system and check whether the table is present in the SAP.

Regards

RB

[Former Member · Accepted solution]

in se16 Not database tale exist for table GENSETM

[ashish_vikas · Accepted solution]

Did you check other notes what i mentioned earlier ?

Also ckech :

1633118 - SGEN deletes GENSETM when restarting

best regards

ashish

[Former Member · Accepted solution]

Got this going , went into se11 and Activated table GENSETM

[ashish_vikas]

Check if below note helps

1757008 - SGEN for upgrade components fail

Also provide log of RSREGENLOD.ELG

best regards

ashish

[Former Member]

1 ETQ201 Entering upgrade-phase "MAIN_POSTP/RUN_RSREGENLOD" ("20131121151544")

2 ETQ367 Connect variables are set for standard instance access

4 ETQ399 System-nr = '01', GwService = 'sapgw01' Client = '000'

4 ETQ399 Environment variables:

4 ETQ399 dbs_mss_schema=<null>

4 ETQ399 auth_shadow_upgrade=<null>

1 ETQ206 Executing pre-phase DB specific actions.

1 ETQ200 Executing actual phase 'MAIN_POSTP/RUN_RSREGENLOD'.

1 ETQ399 Phase arguments:

2 ETQ399 Arg[0] = 'RSGEN_LOAD_SHADOW'

2 ETQ399 Arg[1] = 'SAP_REGENLOD'

2 ETQ399 Arg[2] = 'NO-IGNORE'

2 ETQ399 Arg[3] = 'RSREGENLOD\.$(SAPSID)'

2 ETQ399 Arg[4] = '10'

2 ETQ399 Arg[5] = 'Refill GENSETM'

1 ETQ399 Using error summary log 'RSREGENLOD.ELG'.

1 ETQ399 Expanded phase arguments:

2 ETQ399 Arg[3] = 'RSREGENLOD\.SML'

2 ETQ399 ParControl = 'STARTEXEC'

4 ETQ265 Starting report "RSGEN_LOAD_SHADOW" with variant "SAP_REGENLOD" in batch

1 ETQ359 RFC Login to: System="SML", AsHost="REK-SAPSM-P01" Nr="01", GwHost="REK-SAPSM-P01", GwService="sapgw01"

2 ETQ232 RFC Login succeeded

4 ETQ010 Date & Time: 20131121151545

1 ETQ233 Calling function module "SUBST_START_REPORT_IN_BATCH" by RFC

2 ETQ373 parameter "IV_ABORT_ON_ERROR" = ""

2 ETQ373 parameter "IV_AUTHCKNAM" = "DDIC"

2 ETQ373 parameter "IV_BATCHHOST" = "REK-SAPSM-P01"

2 ETQ373 parameter "IV_JOBNAME" = "RSGEN_LOAD_SHADOW"

2 ETQ373 parameter "IV_REPNAME" = "RSGEN_LOAD_SHADOW"

2 ETQ373 parameter "IV_SCHEDEVER" = " "

2 ETQ373 parameter "IV_VARIANTTEXT" = "refill GENSETM"

2 ETQ373 parameter "IV_VARNAME" = "SAP_REGENLOD"

2 ETQ373 parameter "IV_LANGUAGE" = "E"

2 ETQ399 Table TT_REPORTPARAM (#2):

3 ETQ399 "REGENER8","P","","","X",""

3 ETQ399 "FILENAME","P","","","RSREGENLOD.SML",""

2 ETQ373 parameter "IV_BATCHINSTANCE" = ""

1 ETQ234 Call of function module "SUBST_START_REPORT_IN_BATCH" by RFC succeeded

4 ETQ010 Date & Time: 20131121151545

2 ETQ373 parameter "EV_JOBCOUNT" = "15154700"

2 ETQ374 parameter "EV_STARTRC" = "0"

2 ETQ374 parameter "EV_VARIWRC" = "0"

4 ETQ311 Batch job "RSGEN_LOAD_SHADOW" with job count "15154700" scheduled

1 ETQ399 SYSMANDEBUG_ASCSSYSNUM: ''.

1 ETQ399 SYSMANDEBUG_ASCSHOST: ''.

1 ETQ207 Executing post-phase DB specific actions.

4 ETQ010 Date & Time: 20131121151545

1 ETQ202 Upgrade phase "RUN_RSREGENLOD" completed sucessfully ("20131121151545")

1 ETQ000 ==================================================

1 ETQ201 Entering upgrade-phase "MAIN_POSTP/RUN_RSREGENLOD" ("20131121151545")

2 ETQ367 Connect variables are set for standard instance access

4 ETQ399 System-nr = '01', GwService = 'sapgw01' Client = '000'

4 ETQ399 Environment variables:

4 ETQ399 dbs_mss_schema=<null>

4 ETQ399 auth_shadow_upgrade=<null>

1 ETQ206 Executing pre-phase DB specific actions.

1 ETQ200 Executing actual phase 'MAIN_POSTP/RUN_RSREGENLOD'.

1 ETQ399 Phase arguments:

2 ETQ399 Arg[0] = 'RSGEN_LOAD_SHADOW'

2 ETQ399 Arg[1] = 'SAP_REGENLOD'

2 ETQ399 Arg[2] = 'NO-IGNORE'

2 ETQ399 Arg[3] = 'RSREGENLOD\.$(SAPSID)'

2 ETQ399 Arg[4] = '10'

2 ETQ399 Arg[5] = 'Refill GENSETM'

1 ETQ399 Using error summary log 'RSREGENLOD.ELG'.

1 ETQ399 Expanded phase arguments:

2 ETQ399 Arg[3] = 'RSREGENLOD\.SML'

2 ETQ399 ParControl = 'CHECKEXEC'

2 ETQ399 'SUBST_CHECK_BATCHJOB' for JOBNAME='RSGEN_LOAD_SHADOW' JOBCOUNT='15154700' returns 'R'.

4 ETQ264 Batchjob "RSGEN_LOAD_SHADOW" still running

1 ETQ399 SYSMANDEBUG_ASCSSYSNUM: ''.

1 ETQ399 SYSMANDEBUG_ASCSHOST: ''.

1 ETQ000 ==================================================

1 ETQ201 Entering upgrade-phase "MAIN_POSTP/RUN_RSREGENLOD" ("20131121151546")

2 ETQ367 Connect variables are set for standard instance access

4 ETQ399 System-nr = '01', GwService = 'sapgw01' Client = '000'

4 ETQ399 Environment variables:

4 ETQ399 dbs_mss_schema=<null>

4 ETQ399 auth_shadow_upgrade=<null>

1 ETQ206 Executing pre-phase DB specific actions.

1 ETQ200 Executing actual phase 'MAIN_POSTP/RUN_RSREGENLOD'.

1 ETQ399 Phase arguments:

2 ETQ399 Arg[0] = 'RSGEN_LOAD_SHADOW'

2 ETQ399 Arg[1] = 'SAP_REGENLOD'

2 ETQ399 Arg[2] = 'NO-IGNORE'

2 ETQ399 Arg[3] = 'RSREGENLOD\.$(SAPSID)'

2 ETQ399 Arg[4] = '10'

2 ETQ399 Arg[5] = 'Refill GENSETM'

1 ETQ399 Using error summary log 'RSREGENLOD.ELG'.

1 ETQ399 Expanded phase arguments:

2 ETQ399 Arg[3] = 'RSREGENLOD\.SML'

2 ETQ399 ParControl = 'CHECKEXEC'

1 ETQ359 RFC Login to: System="SML", AsHost="REK-SAPSM-P01" Nr="01", GwHost="REK-SAPSM-P01", GwService="sapgw01"

2 ETQ232 RFC Login succeeded

4 ETQ010 Date & Time: 20131121151546

1 ETQ233 Calling function module "SUBST_CHECK_BATCHJOB" by RFC

2 ETQ373 parameter "JOBNAME" = "RSGEN_LOAD_SHADOW"

2 ETQ373 parameter "JOBCOUNT" = "15154700"

2 ETQ373 parameter "IV_VERIFY" = " "

1 ETQ234 Call of function module "SUBST_CHECK_BATCHJOB" by RFC succeeded

4 ETQ010 Date & Time: 20131121151546

2 ETQ373 parameter "JOBSTATUS" = "A"

2 ETQ374 parameter "RC_CHECK" = "0"

2 ETQ373 parameter "JOBENDDATE" = "20131121"

2 ETQ373 parameter "JOBENDTIME" = "151547"

2EETQ262 Batchjob "RSGEN_LOAD_SHADOW" aborted

1 ETQ399 SYSMANDEBUG_ASCSSYSNUM: ''.

1 ETQ399 SYSMANDEBUG_ASCSHOST: ''.

1 ETQ207 Executing post-phase DB specific actions.

4 ETQ010 Date & Time: 20131121151546

1 ETQ202 Upgrade phase "RUN_RSREGENLOD" completed sucessfully ("20131121151546")

1 ETQ000 ==================================================

1 ETQ201 Entering upgrade-phase "MAIN_POSTP/RUN_RSREGENLOD" ("20131121151546")

2 ETQ367 Connect variables are set for standard instance access

4 ETQ399 System-nr = '01', GwService = 'sapgw01' Client = '000'

4 ETQ399 Environment variables:

4 ETQ399 dbs_mss_schema=<null>

4 ETQ399 auth_shadow_upgrade=<null>

1 ETQ206 Executing pre-phase DB specific actions.

1 ETQ200 Executing actual phase 'MAIN_POSTP/RUN_RSREGENLOD'.

1 ETQ399 Phase arguments:

2 ETQ399 Arg[0] = 'RSGEN_LOAD_SHADOW'

2 ETQ399 Arg[1] = 'SAP_REGENLOD'

2 ETQ399 Arg[2] = 'NO-IGNORE'

2 ETQ399 Arg[3] = 'RSREGENLOD\.$(SAPSID)'

2 ETQ399 Arg[4] = '10'

2 ETQ399 Arg[5] = 'Refill GENSETM'

1 ETQ399 Using error summary log 'RSREGENLOD.ELG'.

1 ETQ399 Expanded phase arguments:

2 ETQ399 Arg[3] = 'RSREGENLOD\.SML'

2 ETQ399 ParControl = 'FINALIZE'

1 ETQ399 SYSMANDEBUG_ASCSSYSNUM: ''.

1 ETQ399 SYSMANDEBUG_ASCSHOST: ''.

1EETQ399 Last error code set is 'Batchjob 'RSGEN_LOAD_SHADOW' with id '15154700' aborted'

1EETQ204 Upgrade phase "RUN_RSREGENLOD" aborted with severe errors ("20131121151546")

[Former Member]

This note cannot be implemented

[ashish_vikas]

I didnt found any direct SAP note... but you may apply below.. one of them correct IF_SGEN_DB~COUNT_GENSETM which comes in your dump.

1630356 SGEN terminates after 500 generation errors

1737670 Wrong count of syntax errors in SGEN batch job 17.08.2012

1651645 Maximum number of SGEN processes cannot be greater than 9

best regards

ashish

[ashish_vikas]

Check one more Note :

1607853 - Upgrade phase RUN_RSREGENLOD does not run in post-processing

best regards

ashish