Process Chain Monitoring – Approach and Correction

Process Chain Monitoring – Approach and Correction By (Shimeles Amanu)

Description

Approach/Analysis

Correction

Failure in  the Delete Index or Create Index step

Go to the target and check if any load is running

Trigger the chain ahead if indexes are already deleted in other process chain

Long running Delete Index or Create Index job

Compare the last run time of job. If it taking more time, check system logs in SM21 and server processes in SM51

Inform BASIS team with system log and server processes details

Check  the SM12 transaction entries for any locks on target from some other step

Stop the delete index or create index and repeat it once lock is released

Attribute change run failure

Check the error message

Check the lock on Master Data objects used in Infocube and repeat the step

Roll up failure

Error message “roll up failed due to Master Data table lock in attribute change run

Wait till attribute change run is completed and start the roll up again

Open RSDDBIAMON2 transaction to check any issues in BI Accelerator server.

Failure in Full data load

SQL error

 

Manually delete the indexes of target and start the load again

This happens generally due insufficient memory space available while reading data from tables.

Coordinate with BASIS team to analyze the database space (DB02) and take necessary action to reduce the database size.

Incorrect data records in PSA table

 

Check the data in PSA table for any lower case letter or special characters etc

Ask concerned R/3 person to correct the data at R/3 side and load the data again

It is very important to check the PSA table to have complete data in PSA before reconstruction. Otherwise all the data will not be updated in target.

On immediate basis, delete the request from target, correct the data in PSA table and reconstruct the request

Delta data load Failure

 

Delta load failed without any error message.

Go to infopackage and check for last delta load in target if it is successful or not.

Wait till last delta load is completed or correct it then start the infopackage again.

 

PSA update failed due to job termination or target lock

Make sure that all data records are available in PSA table and reconstruct the request

 

Delta load job failed in R/3 system or EDWH system after all data has come to PSA table

Delete the request from targets and reconstruct it.

 

Delta load job failed at R/3 side without data PSA table

Make the status of the request “Red” in process monitor and repeat the delta load again. Make sure that data is not doubled as repeat delta brings last successful records as well. Check the update mode of all key figures i.e. overwrite or addition mode for this.

 

Delta load job failed in EDWH system without data PSA table

Remove “data mart” tick from below source and start the delta package again.

Or make the status of the load to “Red” in case all key figures are in overwrite mode.

Long running delta load

Check  the R/3 job in SM37 if it is not released

Ask BASIS team to release the job from R/3 system

Compare the last successful delta load time along with R/3 connection

Ask BASIS team to repair the R/3 connection

DSO Activation

Activation failure due to incorrect value in the ODS field.

Correct the data in PSA or check the update logic for the corresponding source field

Activation job termination

Try to activate the data manually else check the jobs in SM37. If most of the activation jobs are failing, contact BASIS team.

Miscellaneous

Some process types are not triggered even if above process type is completed. Triggering line doesn’t show any status.

Chain logs takes time to update in chain log table i.e. RSPCPROCESSLOG. Check the system performance with BASIS team as well.

    • Related Articles

    • Step to run Schedule Manger Script monitoring and How to check the script was run correctly

      Dear  Greetings! Find the attached steps to run the Schedule Manager script. D+7:     ./ ET_mc_ssm_D7.sh  D+3:   ./ET_mc_ssm.sh Use the below path: /MC/ASM_NEW_BKP== to check the script was runing or not on FTP /u01/avnprod/batch/logs == to check on ...
    • staff travel couldn't update the payment status on the mobile payment table

      Description of turn back The staff travel couldn't update the payment status on the mobile payment table after the payment was processed from flowcash  starting from Jul 09/2018. Possible cause:                                There was certification ...
    • ALMS Access level

      To grant or adjust the access levels  of ALMS do note the below . CALLCENTERET---For agents to enroll, update contact and mailing addresses, order replacement cards and request retro claims. CALLSUPLESS----For agents to enroll, update contact and ...
    • SAP-HCM Time Management Attendance is not coming on CAT2

      When attendance is not visible on CAT2 : 1- check on KABA data base - View my attendance functionnality on ET Portal 2- If attendances data are visible on KABA "View my attendances" functionality please run Z_Program of CAT2 update 3- If  attendances ...
    • 24220:- Repair an Outlook data file (.pst)

      Repair an Outlook data file (.pst) file Exit Outlook and browse to one of the following file locations: Outlook 2019: C:\Program Files (x86)\Microsoft Office\root\Office16 Outlook 2016: C:\Program Files (x86)\Microsoft Office\root\Office16 Outlook ...