You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 60 Next »

#Horizon Roll 

To monitor  (all GBUs) if the Horizon Roll is shifted correctly.

ApplicationInstructionsScreenshot
Dscp DPx / Dipx / DSCPx
  1. Get connected:
NULL

2. Open the RP web portal of the right company

S COMPANY or E COMPANY


3.  Input your user ID to get connected.(The User ID = Windows ID), no need to input Password.
4. In the ribbon, click on 'Explorer'

5. In Structure tab, open 'Horizons' under Structure → Horizons → Horizons → _Tech:Current Month

Please find the Tech name in each application in below to check if the current month of each horizon is shifted to current month of the year.


DP1

 _Tech: Current Month

DP2Forecast month

DP3_Tech: Current Month

DP4_Tech: Current Month

DP5_Tech: Current Month

DiP1TECH : Current Month

DiP3TECH : Current Month

DiP4TECH : Current Month

DiP5TECH : Current Month

DSCP1 _TECH: Current Month

DSCP2_Tech: Current Month

BACK to 6. Monitoring


#Batch Status 

To monitor specific controls on batchs

Application

Instructions

Screenshot

Dscp DPx / Dipx / DSCPx

To verify the batch status in SQL datahub of each application. 

To verify the current month in each application.

To check if the monthly archive is created correctly in the application if needed.

To check in SQL Datahub in COMMENT column to see if the TECH ends by 'ok'.

NULL

DP1

DP1 - AUTO_Monthly_FirstDay (get connection to SQL Server)

DP2

DP2 -  TECH : Horizon Rotation (get connection to SQL Server)

DP3

DP3 - AUTO_Monthly_FirstDay (get connection to SQL Server)

DP4DP4 - AUTO_Monthly_FirstDay (get connection to SQL Server)

DP5DP5 - AUTO_Monthly_FirstDay (get connection to SQL Server)

DiP1

DiP1 - TECH : Horizon Rotation (get connection to SQL Server)

DiP3

DiP3 - AUTO_Daily_Rot_Horizon (get connection to SQL Server)

DiP4DiP4 - AUTO_Daily_Rot_Horizon (get connection to SQL Server)

DiP5

DiP5 - AUTO_Daily_Rot_Horizon (get connection to SQL Server)

DSCP 1

DSCP1 -  TECH : Horizon Rotation (Monthly) (get connection to SQL Server)

DSCP 2

DSCP2 - TECH : Horizon Rotation (get connection to SQL Server)

BACK to 6. Monitoring


#Monthly Archive 

To cross check the Monthly Archive

Application

How to Do

Screenshot

DSCP DP2

DP2 -  GBU - AERO - DP Monthly Archive (get connection to application DP2)

*DP2 - Warn functional team in case of Dynamic batch not executed (DP : copy of gross history + stat calculation / DIP : inventories)

DSCP DiP3

1> Get connected to DSCP DiP3

2> Explorer → Structure → User models → U01 - NOVECARE → Archive template → MONTHLY ARCHIVE


DSCP DiP4DiP4 - AUTO_EOM_Archive (get connection to SQL Server)

DSCP DiP5

1> Get connected to DSCP DiP5

2> Explorer → Structure → User models → U01 - SPECHEM → Archive template → S&OP Validated

BACK to 6. Monitoring


#Prod Server Logs 

To cross check in Prod Server Logs if the sequence is executed correctly

Application

Instructions

Screenshot

DSCP DP1Check DP1 Dynamic import logs to see if copy of gross history of M-1 is correctly executed the 1st of the month.

DSCP DP3

1> Get connected to Prod Server Logs

https://dynasysprdsco.solvay.com/RDWeb/Pages/en-US/Default.aspx/Logs

Production folder: /Logs → PROD Server Logs

To check the statistical calculation launch into Dynamic Batch in DP3 on 1st of the Month.

DSCP DiP5

1> Get connected to Prod Server Logs

https://dynasysprdeco.eua.solvay.com/RDWeb/Pages/en-US/Default.aspx/Logs

Production folder: /Logs → PROD Server Logs



2> Cross check inside the logs

Open DiP5 folder, find the log file, right click, open with Notepad++

To cross check if the Sequence is executed without error

Sequence: [STATIC IMPORT][MONTHLY] 00.Last day of the Month

*DiP5 - before horizon shift, archives will be run within Horizon rotation. ( Archive first, then Shift the Horizon)

BACK to 6. Monitoring


#Get connection to SQL Server 

Application

Batch

Server name

Databases

SQL request

DSCP DP1

Auto_Montly_Firstday → TECH : Horizon Rotation

asew1pdscpapp01

DYNASYS_ITF_SCoselect * from sys_history where source  = 'dscp dp1' order by START_DT desc
DSCP DP2AUTO_Daily_Static → TECH : Horizon Rotationasew1pdscpapp01DYNASYS_ITF_SCoselect * from sys_history where source  = 'dscp dp2' order by START_DT desc
DSCP DP3AUTO_Monthly_FirstDay →  TECH : Horizon Rotationasew1pdscpapp01DYNASYS_ITF_SCoselect * from sys_history where source  = 'dscp dp3' order by START_DT desc
DSCP DP4AUTO_Monthly_FirstDay →  TECH : Horizon Rotationacew1pdscpappe5DYNASYS_ITF_ECoselect * from sys_history where source  = 'dscp dp4' order by START_DT desc
DSCP DP5AUTO_Monthly_FirstDay →  TECH : Horizon Rotationacew1pdscpappe5DYNASYS_ITF_ECoselect * from sys_history where source  = 'dscp dp5' order by START_DT desc
DSCP DiP1AUTO_Daily_Rot_Horizon → TECH : Horizon Rotationasew1pdscpapp01DYNASYS_ITF_SCoselect * from sys_history where source  = 'dscp dip1' order by START_DT desc
DSCP DiP3AUTO_Daily_Rot_Horizon → TECH : Horizon Rotationasew1pdscpapp01DYNASYS_ITF_SCoselect * from sys_history where source  = 'dscp dip3' order by START_DT desc
DSCP DiP4AUTO_Daily_Rot_Horizon → TECH : Horizon Rotationacew1pdscpappe5DYNASYS_ITF_ECoselect * from sys_history where source  = 'dscp dip4' order by START_DT desc
DSCP DiP5AUTO_Daily_Rot_Horizon → TECH : Horizon Rotationacew1pdscpappe5DYNASYS_ITF_ECoselect * from sys_history where source  = 'dscp dip5' order by START_DT desc
DSCP 1AUTO_Daily_Static → TECH : Horizon Rotation (Monthly)acew1pdscpappe5DYNASYS_ITF_DSCP1select * from sys_history where source  = 'dscp 1' order by START_DT desc

#Export of Forecast to SAP (WP1) - TS

ApplicationInstructionsScreenshot
DSCP DIP1

DIP1 (TS) with forecast export to SAP - the 1st day of the month

1>> Batches  (get connection to SQL Server - Select * from sys_history where source = 'dscp dip1' order by start_dt desc)

DIP1 - TECH : Export SAP TS



2>> DynaSys Export Forecast to SAP WP1 (Transaction Code AL11)
2.1  files generated in SAP WP1 (Directory :/exploit/PP/data/DYN/FCST)


BACK to 6. Monitoring


  • No labels