Issue with PI SUM upgrade process

[daniel_piggott-genge]

Hello,

I'm currently stuck.

I have been upgrading our QA PI system to NW7.40.  I managed this fine with our Development system but unfortunately I've hit a problem that I can't seem to work out so hoping people here might be able to help.

Basically SUM has got to the step  MAIN_SHDRUN/PARDIST_SHD.

Unfortunately it had now fallen over with the following:

2EEDA122 Error generating the program for "SEPM_SDDL_V_GIH" " "
2EEDA476 Code for creating view "SEPM_SDDL_V_GIH" could not be generated
2EEDA471 Result "SEPM_SDDL_V_GIH": Action: "CRE" Mode flag: "E" Return code: "95"

It also gives the same message for SEPM_SDDL_V_GII and SEPM_SDDL_V_SOIH.

I have investigated and found that these views exist in our DEV system but don't in QA so I tried using the DEV DDL to create the tables in QA but that then just changes the error message to:

2EEDA122 Error generating the program for "SEPM_SDDL_V_GIH" " "
2EEDA476 Code for creating view "SEPM_SDDL_V_GIH" could not be generated
2EEDA471 Result "SEPM_SDDL_V_GIH": Action: "CNV" Mode flag: "E" Return code: "95"

I found this note:

http://service.sap.com/sap/support/notes/2028165

Which suggests upgrading the SUM version to SP 10 and trying again..... trouble is I have SUM SP 11

I suspect restoring and starting again might be my only option which is a pain but if that's what I have to do fair enough.  My concern is, will it just happen again, in which case that would be several hours wasted.

Anyway, any thoughts or input would be appreciated. 

Full content of the PARDSHD.ELG file from the step:

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

DISTRIBUTION ERRORS and RETURN CODE in DS140922.XQ1

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

2 ED0307 Platform.................: "CUSTOMER"-"XQ1"("740")/"MSSQL/WindowsNT/vmsapqapidb"

2 ED0311 Tool.....................: "BATCH"/"LSDSBU02"

2 ED0315 Log......................: "F", "C:\SUM\abap\tmp\DS140922.XQ1"

2 ED0302 =========================================================================

4 EDA507 -> "SEPM_SDDL_V_GIH"            - - - "vmsapqapidb_7_7044"  "15:35:18"  "22.09.2014" - - - - - - - - - - - - - - - - - - - -

2EEDA122 Error generating the program for "SEPM_SDDL_V_GIH" " "

2EEDA476    Code for creating view "SEPM_SDDL_V_GIH" could not be generated

2EEDA471    Result   "SEPM_SDDL_V_GIH":    Action: "CRE"      Mode flag: "E"    Return code: "95"

4 EDA507 -> "SEPM_SDDL_V_GII"            - - - "vmsapqapidb_7_7044"  "15:35:18"  "22.09.2014" - - - - - - - - - - - - - - - - - - - -

2EEDA122 Error generating the program for "SEPM_SDDL_V_GII" " "

2EEDA476    Code for creating view "SEPM_SDDL_V_GII" could not be generated

2EEDA471    Result   "SEPM_SDDL_V_GII":    Action: "CRE"      Mode flag: "E"    Return code: "95"

4 EDA507 -> "SEPM_SDDL_V_SOIH"            - - - "vmsapqapidb_7_7044"  "15:35:18"  "22.09.2014" - - - - - - - - - - - - - - - - - - - -

2EEDA122 Error generating the program for "SEPM_SDDL_V_SOIH" " "

2EEDA476    Code for creating view "SEPM_SDDL_V_SOIH" could not be generated

2EEDA471    Result   "SEPM_SDDL_V_SOIH":    Action: "CRE"      Mode flag: "E"    Return code: "95"

2 ED0309 Program runtime..........: "< 1 sec."

2 ED0305 Date, time...............: "22.09.2014", "15:35:18"

2 ED0318 Program end==============================================================

4 EDA469 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

4 EDA449 ------   Summary of error messages and warnings:               ---------

2EEDA122 Error generating the program for "SEPM_SDDL_V_GIH" " "

2EEDA122 Error generating the program for "SEPM_SDDL_V_GII" " "

2EEDA122 Error generating the program for "SEPM_SDDL_V_SOIH" " "

[Former Member]

Hi,

I just had the same issue and in my case the solution was downgrading kernel to 741.

Updating to the latest SUM version made no difference in my case(SP11pl8)

Br

[divyanshu_srivastava3]

Hi Daniel,

Raise a high incident with SAP. Let them look and suggest once.

Might be they can cast some magic on this and you can proceed without any reset.

Regards,

[Former Member]

Hi Daniel,

As mentioned in the note, Did you selected the option "Accept non-severe errors" in the ACT_UPG phase?

Regards,

Raja. G

[daniel_piggott-genge]

Unfortunately yes I did.

[Former Member]

Hi Daniel,

Then we don't have any other option have to follow SAP suggested.

Maintaining the values manually might fix the issue however we don't know the consequences as these are views.  Hope we can reset the upgrade in this phase.

Regards,

Raja. G

[daniel_piggott-genge]

Thank you for the advice. I think I probably will need to start the process again.  To be honest I don't actually need the Shadow instance anyway so hopefully it might cut a bit of the time off the process.

[Former Member]

Hi Daniel,

Please proceed with resource minimized and complete the process.

All the best for your efforts.

Regards,

Raja. G