December 4, 2014

Errors during the upgrade to EHP7 - Part 1

Number Error Solution
1.
4 EPU201XBEGIN OF SECTION BEING ANALYZED LASTOFFSET                 2294 NOW BEGIN OF JOB_RSVBCHCK_PRE =========
1 ETH010XRSVBCHCK: Check of open update requests
2EETG050 Update records still exist - Please process
A2EEMCEX 151 Entries for application "13" still exist in the extraction queue ->
A2EEMCEX 141 Struct. appl. "04" cannot be changed due to setup table -> Long text" ""MC04P_0ARBSETUP""100"
A2EEMCEX 141 Struct. appl. "04" cannot be changed due to setup table -> Long text" ""MC04P_0COMSETUP""100"
A2EEMCEX 141 Struct. appl. "04" cannot be changed due to setup table -> Long text" ""MC04P_0MATSETUP""100"
4 EPU202X====MARK ANALYZED SECTION==== END OF JOB_RSVBCHCK_PRE ======== BEGIN OF JOB_RSVBCHCK2 =============
1 ETH010XRSVBCHCK: Check of open update requests
2EETG050 Update records still exist - Please process
A2EEMCEX 151 Entries for application "04" still exist in the extraction queue ->
A2EEMCEX 141 Struct. appl. "04" cannot be changed due to setup table -> Long text" ""MC04P_0ARBSETUP""100"
A2EEMCEX 141 Struct. appl. "04" cannot be changed due to setup table -> Long text" ""MC04P_0COMSETUP""100"
A2EEMCEX 141 Struct. appl. "04" cannot be changed due to setup table -> Long text" ""MC04P_0MATSETUP""100"
4 EPU202X====MARK ANALYZED SECTION==== END OF JOB_RSVBCHCK2 =========== BEGIN OF JOB_RSVBCHCK_D ============
1 ETH010XRSVBCHCK: Check of open update requests
A2EEMCEX 151 Entries for application "04" still exist in the extraction queue ->
A2EEMCEX 141 Struct. appl. "04" cannot be changed due to setup table -> Long text" ""MC04P_0ARBSETUP""100"
A2EEMCEX 141 Struct. appl. "04" cannot be changed due to setup table -> Long text" ""MC04P_0COMSETUP""100"
A2EEMCEX 141 Struct. appl. "04" cannot be changed due to setup table -> Long text" ""MC04P_0MATSETUP""100"
4 EPU202X====MARK ANALYZED SECTION==== END OF JOB_RSVBCHCK_D ========== BEGIN OF JOB_RSVBCHCK_D ============
1 ETH010XRSVBCHCK: Check of open update requests
A2EEMCEX 141 Struct. appl. "04" cannot be changed due to setup table -> Long text" ""MC04P_0ARBSETUP""100"
A2EEMCEX 141 Struct. appl. "04" cannot be changed due to setup table -> Long text" ""MC04P_0COMSETUP""100"
A2EEMCEX 141 Struct. appl. "04" cannot be changed due to setup table -> Long text" ""MC04P_0MATSETUP""100"
4 EPU202XEND OF SECTION BEING ANALYZED END OF JOB_RSVBCHCK_D ===============================================
Clean up the structures using transaction LBWG, for example with this error mesages we had to delete the structures 04 and 13
2.
DB Requests pending
SE14 -> DB Requests -> Mass Processing -> All requests
Then process or delete the pending mass processing requests.
3.
Modifications/corrections have to be done on the primary or shadow instances when these are locked by the upgrade.
  1. To unlock the SAP system, enter the following commands (here or DEFAULT.TPP is the transport profile of the transport domain to which the system is connected): The system may be either the original SAP system or the shadow system, depending on which one the error occurred.
    • Original SAP system
      cd \\abap\exe
      tp unlocksys pf=..\var\DEFAULT.TPP
      tp unlock_eu pf=..\var\DEFAULT.TPP
    • Shadow system
      cd \\abap\bin
      SAPup unlockshd
  2. Log on to the SAP system or shadow system and correct the error.
  3. To lock the original SAP system or shadow system again, enter the
    following commands:
    • Original SAP system
      cd \usr\sap\abap\exe
      tp lock_eu pf=..\var\DEFAULT.TPP
      tp locksys pf=..\var\DEFAULT.TPP
    • Shadow system
      cd \\abap\bin
      SAPup lockshd

Source: 
4. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
MVNTABS ERRORS: ddlntabs and RETURN CODE in PD001125.GCD
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3 ETP000 PRIMARY KEY CLUSTERED
3 ETP000 ( [SPRAS] ,
3 ETP000 [ACTIVITY] )
3 ETP000 ON [PRIMARY]
3 ETP000
2EETP345 17:44:06: Retcode 1: SQL-error "1505-The CREATE UNIQUE INDEX statement terminated because
2EETP345 a duplicate key was found for the object name 'gcd.CUS_IMGACT~' and the index name 'CUS_IM
2EETP345 GACT^0'. The duplicate key value is (A,  OHAEHU001D)." in DDL statement for "CUS_IMGACT
2EETP345                  "
2 ETP000  --------------- DB-ROLLBACK() ---------------
2EETP334 17:44:06: error in DDL, nametab for "CUS_IMGACT" not activated
Shadow table was recreated from the original table.

USE [TST]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SELECT * INTO [tst].[TMENU01T~] FROM [tst].[TMENU01T]
GO
5. Entries in outbound queue Clean-up the queues using SMQ1 and SMQ2, if there are two many entries in the outbound queue it could be easier to truncate the table TRFCQOUT.
6.

...
4 EDA093 "DDL time(___2):" ".........1" milliseconds
3 EGT279XProjection view "V_QCMBSEG" for data transfer will be created
3EEMC778 Field "MNDID": Position relative to Basis table cannot be exchanged
2EED0800 "STEP 2": Operation "CREATE_PROJECTION_VIEW" failed
2EEGT239 Error in step "BSEG-STEP2"
4 EGT253XTotal time for table "BSEG": "000:00:09"
2 EGT067 Request for "BSEG" could not be executed
1 ED0302X=========================================================================
1 ED0314 DD: Execution of Database Operations
1 ED0302 =========================================================================
1 ED0327 Process..................: "SAPSERVER_32_15580"
1EED0319 Return code..............: "8"
1 ED0309 Program runtime..........: "00:00:09"
1 ED0305 Date, time...............: "09.12.2014", "13:07:42"
1 ED0318 Program end==============================================================
4 EPU202XEND OF SECTION BEING ANALYZED END OF PARCONV_UPG ==================================================

Go to SE14 -> DB Requests -> Created with import

Search the table causing problems

Double click it


Unlock the table


Abapers to implement note 1846998

This issue can be avoided by implementing note 1861585.