Saturday, 16 March 2019

SUM:MAIN_POSTCLEAN/RUN_RSAIMMERGE_TRANSFER long running

Symptom

In the postprocessing module of an upgrade or an Enhancement Package installation, you notice extreme runtimes of the phase RUN_RSAIMMERGE_TRANSFER.

Reason and Prerequisites

In the phase RUN_RSAIMMERGE_TRANSFER, selects on the table E071 need to be performed.

On some customer databases these selects on the table E071 are very slow.

Solution

1. Recreate the index 1 on the table E071 (defined for the fields PGMID, OBJECT and OBJ_NAME).

2. Refresh the statistics for the table E071.

Alternatively, if creating an additional index is an option:

1. Create an index on the table E071 for the fields TRKORR, PGMID, OBJECT and OBJ_NAME.

2. Refresh the statistics for the table E071.

Repeat the phase RUN_RSAIMMERGE_TRANSFER.



Hope this helps!!!
Abraham

Wednesday, 13 March 2019

1909524 - "M_PREMA", "V_7BR_PREMA" and "V_T7BRAP" tables error in ACT_TRANS or ACT_UPG phase

Symptom

During upgrade process, the ACT_UPG phase terminates with DDIC ACTIVATION errors "TABLE XXXX was not activated" as per the below error message:

Directory:    <DIR_PUT>/SUM/abap/log
Name:         ACTUPG.ELG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DDIC ACTIVATION ERRORS and RETURN CODE in SAPAAAA731.ABC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


   3 EDT014XActivate dependent table "M_PREMA"
   2WEAD275 Foreign key "M_PREMA"-"BUKRS" (dependency factor "REF" is
   incorrect here)
   2WEAD275 Foreign key "M_PREMA"-"OBRA" (dependency factor "REF" is
   incorrect here)
    1EEDT354 Search field "M_PREMA"-"FILIA" not contained in search help
    attachment
   3 EDT015 Dependent table "M_PREMA" was not activated
   3 EDO525XActivate dependent view "M_PREMA"
   1 EDH202 Check dependent search help "PREMA"
   1 EDH103 Search help "PREMA" is consistent
   3 EMC763 Key field "T7BRAP"-"GRPBR" missing
   2WEMC732 All fields are evaluated as key field
   3 EMC726 View must be created in the database
   3 EDO526 View was activated with warnings"M_PREMA"
    1EEDO519 "Table" "M_PREMA" could not be activated


   3 EDT014XActivate dependent table "V_7BR_PREMA"
   2WEAD275 Foreign key "V_7BR_PREMA"-"BUKRS" (dependency factor "REF" is
   incorrect here)
   2WEAD275 Foreign key "V_7BR_PREMA"-"OBRA" (dependency factor "REF" is
   incorrect here)
    1EEDT354 Search field "V_7BR_PREMA"-"FILIA" not contained in search help
    attachment
   3EDT015 Dependent table "V_7BR_PREMA" was not activated

   3 EDO525XActivate dependent view "V_7BR_PREMA"
   1 EDH202 Check dependent search help "HRPADBRA"
   1 EDH103 Search help "HRPADBRA" is consistent
   3 EMC763 Key field "T7BRAP"-"GRPBR" missing
   2WEMC732 All fields are evaluated as key field
   3 EMC726 View must be created in the database
   3 EDO526 View was activated with warnings"V_7BR_PREMA"
    1EEDO519 "Table" "V_7BR_PREMA" could not be activated

   3 EDT014XActivate dependent table "V_T7BRAP"
   1EEDT354 Search field "V_T7BRAP"-"FILIA" not contained in search help
   attachment
   3 EDT015 Dependent table "V_T7BRAP" was not activated
   3 EDO525XActivate dependent view "V_T7BRAP"
    1EEDO519 "Table" "V_T7BRAP" could not be activated
   1 ETP111 exit code : "8"



Environment

ABAP System, Enhancement Package Installation, Release Upgrade.

Reproducing the Issue

Start SUM tool.
In ACT_UPG phase, the error occurs.
Cause
The root cause of the issue is some fields were removed from the table T7BRAP. This action is delivered by standard packages however this is not reflecting in other objects like M_PREMA.

On the other hand M_PREMA is a Match code object which is obsolete.

Resolution

You can ignore this error and continue with the upgrade only for the specified tables.

Continue the upgrade by choosing the option 'Accept non-severe errors and repeat phase MAIN_SHDRUN/ACT_UPG' in SUM tool.


Hope this helps!!!
Abraham

2596913 - ACT_UPG: indexes for table "J_1BNFE_ACTIVE" have identical fields

Symptom

During upgrade to EHP 7 for ERP 6.0, below errors happen in phase MAIN_SHDRUN/ACT_UPG for Table J_1BNFE_ACTIVE

EDT012XActivate table "J_1BNFE_ACTIVE"
1EEDT509 Indexes "009" and "H33" for table "J_1BNFE_ACTIVE" have identical fields
1EEAD010 "Is valid for following DB systems:" " " " " " "
1EEAD010 "HDB" "(" "SAP HANA Database" ")"
1EEDT509 Indexes "008" and "HBE" for table "J_1BNFE_ACTIVE" have identical fields
1EEAD010 "Is valid for following DB systems:" " " " " " "
1EEAD010 "HDB" "(" "SAP HANA Database" ")"
2WEDT135 Flag: 'Incorrect enhancement category' could not be updated
3 EDT013 Table "J_1BNFE_ACTIVE" was not activated
3 EDT014XActivate dependent table "J_1BNFE_ACTIVE"
3 EDT038 Activation of dependent table "J_1BNFE_ACTIVE" successful
1EEDO519X"Table" "J_1BNFE_ACTIVE" could not be activated

Environment

EHP7 for ERP 6.0

Cause
This is a bug that new version of index still exists despite the deletion request.

Resolution

Refer Note : 

2596913 - ACT_UPG: indexes for table "J_1BNFE_ACTIVE" have identical fields



As introduced in below note, you need to manually delete below indexes by SE11 in the shadow instance. After this you can continue the upgrade by repeat the phase from where it stops.

Note 1737650 - EHP7 for SAP ERP 6.0 SP Stacks - Release & Information Note

---------------------------------------------------------------
The ABAP Dictionary activation might fail due to duplicate indexes on table "J_1BNFE_ACTIVE". In that case delete indexes 008 and 009 in ABAP Dictionary and repeat the phase.
---------------------------------------------------------------


Hope this helps!!!
Abraham

2704297 -EDT201 Table "SSCPARADETERM" for logging is too long (key<"250", data division<"16.000" necessary)

Symptom

Activation error occurred in ACT_UPG, ACT_TRANS or DDIC_ACTIVATION phase during system update/upgrade using SUM tool or SPAM tool as below:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DDIC ACTIVATION ERRORS and RETURN CODE in SAPAB73115.<SID>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3 EDT619XActivate technical settings for "SSCPARADETERM"

1EEDT201 Table "SSCPARADETERM" for logging is too long (key<"250", data division<"16.000" necessary)

3 EDT622 Technical settings for "SSCPARADETERM" were not activated

1EEDO536X"Technical Settings" "SSCPARADETERM" could not be activated


TP 199 ######################################
TP 155 ABAP Dictionary: Activation

DO 578 The following errors or warnings have occurred:

DO 536 Technical Settings SSCPARADETERM could not be activated
D0 313 (E- Table SSCPARADETERM for logging is too long (key<, data division< necessary))
DO 536 Technical Settings SSC_SUBACT could not be activated
D0 313 (E- Table SSC_SUBACT for logging is too long (key<, data division< necessary))



Important: This error can occurs with different tables, as long as the 'Log Data Changes' is enable for that table.

Environment

SAP NetWeaver release independent

Reproducing the Issue

Repeat the upgrade phase using SUM or SPAM tool.

Cause
Table logging was switched on (activated) for a table whose row width is larger than 16,000 bytes or key field length larger than 250 bytes, during system update/upgrade by the corresponding package.

In this example, table logging for table SSCPARADETERM was delivered by package SAPK-73122INSAPBSFND (SAP_BS_FND, release 731 SP22). As in the newly-delivered version, its key field length is larger than 250 bytes, error occurred.


Solution


In order to avoid this error, the implementation of the SAP Note 2513147 is necessary previous to the start of the Upgrade. If this is not possible, the following workarounds can be applied:

1. Implement the corrections of the SAP Note 2513147 manually as SNOTE is locked during system update/upgrade. Important: If the SUM tool is used the corrections should be applied on the Shadow Instance;
2. It is possible to disable the table logging (SAP Help) and repeat the phase. After the upgrade is complete, you can enable the table logging again and implement SAP Note 2513147; To do so, proceed as below:

Go to SE11 and input table name in field 'Database table';

Select change (F6);

Select Technical Settings (Ctrl + Shift + F9);

Uncheck the box 'Log Data Changes';

Save the technical settings;

Save the table;

Repeat the upgrade phase.

If the activation error of tables "SSCPARADETERM" and "SSC_SUBACT" are the only activation errors in ACT_UPG or ACT_TRANS phase, then you can simply ignore this error. You can activate the tables after the upgrade has been finished (using SE11 transaction) and implement the SAP Note 2513147 as well.

After ignoring the activation error in ACT_UPG or ACT_TRANS phase during system update/upgrade, the new version will remained non-activated after system update/upgrade and a "Revised" version for technical setting on the table will be created. It is necessary for to activate the "Revised" version on the technical setting for the table manually in transaction SE11.
In this example, for table SSCPARADETERM, you need to display table SSCPARADETERM in SE11, then click icon "Technical Settings", you will find an icon named "Revised<->Active", click it to switch between "Revised" version and "Active" version. You will find that in "Revised" version, "Log data changes" is checked, but in active version not. You need to activate the Revised version manually.


Hope this helps!!!
Abraham






Sunday, 10 March 2019

Only startdbs.cmd process available in SAP MMC

Symptom:

When you try starting a SAP system  from SAP MMC , you will see only startdbs.cmd in Process List.
The message server will be started , but dispatcher will not be seen in Process list.

Solution:

1. Check if you have the correct Kernel installed in the SAP system, check with the Product Availability Matrix(PAM).

2. Check if you have the correct oracle instant client installed.
     Refer below SAP Note:



Hope this helps!!!
Abraham