Customer’s might see below notification banner in SME tile - this message banner is a proactive notfication to inform customers of any missing columns which are used in SME which should be reviewed and corrected. This message should not have any SME/user impact.
Please click Learn More on the Banner Message to get error details as following: this message will continue to appear untill all objects/columns/sme listed are reviewed and updated/fixed.
For example In this test instance we can see following warning/errors:
Above error/warning messages are generally to notify that there are some columns which don’t exists but are used in SME steps and should be corrected as soon as possible.
Scenario 1: These warning/errors should not cause any functional impact on the FAW application. Please go through each error message and validate the columns if they exist as shown in following validation example –
PERSON_ID Column Missing From Augmentation DW_EB_X_RCRTMNT_EVENT_F |
|---|
|
Next as per above error we can go and check Augmentation DW_EB_X_RCRTMNT_EVENT_F
As we can see in following this augmentation doesn’t exists and needs to be removed from "Core"."Dim - Custom_DW_EB_X_RCRTMNT_EVENT_F"
All Scenario 1 errors should be reviewed fixed by customers.
Scenario 2: In the following example where in support validation we found a scenario in DA where column does exists :
ATTRIBUTE1 Column Missing from Augmentation DW_FA_X_ZEFT
Next we go and check the augmentation for the above message.
We can see the above augmentation exists. To check the column, we will edit the augmentation:
We can see ATTRIBUTE1 Column is available in Augmentation DW_FA_X_ZEFT
If you find that the column does exists in Data Augmentation and the particular warning needs support review then please raise a support SR with all the details for valid column pasted in a word document so that support can validate and guide on next steps.
For more details please review Support KM : FAW/FDI/FDIP: DA For EPCM Connector Export Failed (Doc ID 3020158.1)
