Processing DDF data from Staging tables to Production tables

[Former Member]

Hello Friends,

During the data replication Via DRF we have issue in clearing the data from Staging tables in to production tables.

We have managed to successfully update the staging tables in CAR with the S4 outbound implementation of PMCH, PMAT, PPLT, PMPL, PSPR. However when tried to execute the "/DMF/PROCESS_STAGING" to process the data from Staging to production we get no output.

When analysed the exception description : Successful execution for Product HR Master Data Inbound,

AppAr: /DMF/MSG_HL.

I have already did the configuration related to "Define Logical system" where we have provided the S4 system logical name and the client details.

Am i missing any more configuration?

Regards

Ram

[former_member335292 · Accepted solution]

Hi Ramakrishna,

Thanks for sharing the snapshots. Can you do the following.

1.Execute the program /DMF/PROCESS_STAGING_TABLES in background mode.

2.Once its completed, click on the erroneous records in monitor imports screen

3.On your right side, click on the individual line item and choose "Exceptions" button(Not the system Exceptions), you will see the individual error message, as there may be different reasons why these items have failed.

If you don't find any error message check for any system dumps that might give you some more details to why they have failed.

Hope it helps.

Thanks,

Aram.

[Former Member]

Hi Aram,

Thanks for the reply, Managed to proceed further as we realized the below issues while processing program /DMF/PROCESS_STAGING_TABLES

1) Issue related to Defining the Logical System.

2) One of the Hierarchy has multiple node level.

Appreciated your response.

Regards
Ram

[Former Member]

Hi Aram,

thanks for the reply. I have attached the steps and the related screen shots to understand the issue more clearly.

The message is error type and does not provide any output, which means no changes to the staging table entries after the execution/Manual processing from Monitor import Web screen and no production table (/DMF/PROD) is updated.

Attached the steps and Screen shots of Monitor Imports and Manage Exceptions for the closer look to help.

Regards
Ram

step-3-manage-exceptions.pngstep-1-monitor-imports.pngstep-2-monitor-imports.png

[former_member335292]

Hi Ramakrishna,

Don't worry about the message as it says "successful execution only" !

First of all, have you checked the Monitor Import screen, where it would show you the items that are in error.

For example you are checking message type Product, wherein you would be able to track the Status, Total no of records, erroneous records, not processed and In process records.

If you see any errors in the Erroneous records column, click on it, wherein you can choose individual item and see the exception detail.

Also once the job is finished, you can check the /DMF/MDIF_PROD(Staging table) table and compare it with the /DMF/PROD(Production table) table. This would give you an exact picture of what's going on. Also it's worthwhile checking if there any dumps as well.

Likewise you can validate the other details for the other message types such as Hierarchy, location ,product location etc.

Hope it helps.

Thanks,

Aram.