STMT_GEN_ERROR occurred in the PARDIST_ORIG phase

ioh1 · ‎06-10-2022

Hi.

I'm facing an error in the SUM and I found the matching Note3201550. So I followed that.
I replaced the kernel file (SAP Kernel release 785 PL124) in the shadow system --> SUM/abap/exe directory

But the error persists. Has anyone ever been able to solve this?

################################################################################################

# Phase: PARDIST_ORIG

# Description: DISTRIBUTION ERRORS

################################################################################################

#==============================================================================================#

# Find the detailed information in log 'DS220608.PEA':

#==============================================================================================#

2 ED0315 Log......................: "F", "D:\SUM\abap\tmp\DS220608.PEA"

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

4 EDA507 -> "CALCTBLSTOBPPROD" - - - "CONV-AP_33_8596" "21:39:59" "08.06.2022" - - - - - - - - - - - - - - - - - - - -

4 EDA656 Analysis strategy: "CL_DD_DIST_STRATEGY_SHADOW"

4 EDA657 Decided by handler class "CL_DD_DISTHANDLER_ACTN_DCDE_SH"

A2EESDDL_PARSER_MSG 052 This path must end only with a field or a structure

A4EEDD_DBAL 021 View "CALCTBLSTOBPPROD": Failed to generate CREATE statements; Error code: "STMT_GEN_ERROR"

2EEDA471 Result "CALCTBLSTOBPPROD": Action: " " Mode flag: "E" Internal SUBRC: "90"

4 EDA438 Object: "TCOLL" contains data

4 EDA657 Decided by handler class "CL_DD_DISTHANDLER_CMP_FLDS_SH"

4 EDA471 Result "TCOLL": Action: "MDF" Mode flag: "C" Internal SUBRC: "0"

2 ED0302X=========================================================================

2 ED0327 Process..................: "CONV-AP_33_8596"

2EED0319 Return code..............: "8"

diana_haase1 · ‎06-10-2022

Hi

just encounter the same issue, kernel patch did not helped...

diana_haase1 · ‎06-10-2022

A4 EDD_RUNTIMEOBJ 002 Runtime object for "CMPEEXECHIST" with state "ACTIVE" not found
4 EDA656 Analysis strategy: "CL_DD_DIST_STRATEGY_SHADOW"
A2EESDDL_PARSER_MSG 050 The component "_MATERIALCOMPONENTTEXT" does not exist or is not active
A4EEDD_DBAL 021 View "CMPEEXECHIST": Failed to generate CREATE statements; Error code: "STMT_GEN_ERROR"
2EEDA665 Error during statement generation
2EESY530 An exception was raised
4EEDA559 Result "CMPEEXECHIST": "DIRECT_DECISION" Action: " " Mode flag: "E"

diana_haase1 · ‎06-10-2022

Hello,

we unlocked the shadow instance and corrected the errors there (see all errors in the long log file):

unlock shadow:

cd /usr/sap/SID/SUM/abap/bin

<sid>adm> ./SAPup unlockshd

correct errors:

SE11, SE80 or eclipse, activate objects and repeat phase.

For example...

Data Definition C_SHOPFLOORORDDISASSEMBLEDMATL

If CAST with type is on Data Element (LICHN, type CHAR), type and length must be the same

Than we successfully repeated the phase.
RegardsDiana

ioh1 · ‎06-27-2022

Thanks for your answer.

This issue was sloved.

Reason is that DDL source C_AllocTableStoreObjPgProduct was corrupt in the shadow system.

The path entry at line 70

_AllocationTableItem._Product.CrossPlantConfigurableProduct._Text[1:Language=$session.system_language].ProductName as CrsPlntConfigurableProductName,

is not correct, it should be

_AllocationTableItem._Product._CrossPlantConfigurableProduct._Text[1:Language=$session.system_language].ProductName as CrsPlntConfigurableProductName,

So we fixed as above using eclipse.

This correction either needs to be present in the source system before start of upgrade but as the conversion was planned, It should be a part of target support pack , which was missing in current scenario .

So the issue highlighted in the note 3153388 - CDS to parent association in union was because of the kernel patch but issue 2990354 - Syntax error in Allocation Table Object Page is cause because of the missing correction for CDS views delivered with the note.

We needed the help of OSS to get to this answer.

SolmanSystemsDA · ‎06-23-2022

Please again consider the following OSS Notes: https://launchpad.support.sap.com/#/notes/3201550 (Resolution Instructions) and https://launchpad.support.sap.com/#/notes/3153388 (Updated SAP Kernel patch).

It seemed to work for us. We the same issue related to A2EESDDL_PARSER_MSG 322 Child entity "R_MAINTORDEROPRELATIONSHIPTP" does not have a to-parent association with "R_MAINTENANCEORDEROPERATIONTP"

This was resolved from updating SUM SAPkernel 785 DISP+DW patch from 100 to 126. Then successfully repeating the phase; without need to activate objects in the shadow.

Best regards,

ioh1 · ‎06-27-2022