#Horizon Roll
To monitor (all GBUs) if the Horizon Roll is shifted correctly.
| Application | Instructions | Screenshot |
|---|---|---|
| Dscp DPx / Dipx / DSCPx |
| NULL |
2. Choose the application S COMPANY https://dynasysprdsco.eua.solvay.com/RDWeb/Pages/en-US/Default.aspx/NonAuto |
| |
E COMPANY https://dynasysprdeco.eua.solvay.com/RDWeb/Pages/en-US/Default.aspx/NonAuto |
| |
| 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 |
|
| DP2 | Forecast month |
|
| DP3 | _Tech: Current Month |
|
| DP4 | _Tech: Current Month |
|
| DP5 | _Tech: Current Month |
|
| DiP1 | TECH : Current Month |
|
| DiP3 | TECH : Current Month |
|
| DiP4 | TECH : Current Month |
|
| DiP5 | TECH : Current Month |
|
| DSCP1 | _TECH: Current Month |
|
| DSCP2 | _Tech: Current Month |
|
#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) |
|
| DP4 | DP4 - AUTO_Monthly_FirstDay (get connection to SQL Server) |
|
| DP5 | DP5 - 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) |
|
| DiP4 | DiP4 - AUTO_Daily_Rot_Horizon (get connection to SQL Server) |
|
| DiP4 - AUTO_EOM_Archive (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) |
|
#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 DiP5 | 1> Get connected to DSCP DiP5 2> Explorer → Structure → User models → U01 - SPECHEM → Archive template → S&OP Validated |
|
#Prod Server Logs
To cross check in Prod Server Logs if the sequence is executed correctly
Application | Instructions | Screenshot |
|---|---|---|
| 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) |
| |
| !!Dip1 the sequence Last day of the Month to be checked. |
#Get connection to SQL Server
Application | Batch | Server name | Databases | SQL request |
|---|---|---|---|---|
Auto_Montly_Firstday → TECH : Horizon Rotation | acew1pdscpapps5 | DYNASYS_ITF_SCo | select * from sys_history where source = 'dscp dp1' order by START_DT desc | |
| DSCP DP2 | AUTO_Daily_Static → TECH : Horizon Rotation | acew1pdscpapps5 | DYNASYS_ITF_SCo | select * from sys_history where source = 'dscp dp2' order by START_DT desc |
| DSCP DP3 | AUTO_Monthly_FirstDay → TECH : Horizon Rotation | acew1pdscpapps5 | DYNASYS_ITF_SCo | select * from sys_history where source = 'dscp dp3' order by START_DT desc |
| DSCP DP4 | AUTO_Monthly_FirstDay → TECH : Horizon Rotation | acew1pdscpappe5 | DYNASYS_ITF_ECo | select * from sys_history where source = 'dscp dp4' order by START_DT desc |
| DSCP DP5 | AUTO_Monthly_FirstDay → TECH : Horizon Rotation | acew1pdscpappe5 | DYNASYS_ITF_ECo | select * from sys_history where source = 'dscp dp5' order by START_DT desc |
| DSCP DiP1 | AUTO_Daily_Rot_Horizon → TECH : Horizon Rotation | acew1pdscpapps5 | DYNASYS_ITF_SCo | select * from sys_history where source = 'dscp dip1' order by START_DT desc |
| DSCP DiP3 | AUTO_Daily_Rot_Horizon → TECH : Horizon Rotation | acew1pdscpapps5 | DYNASYS_ITF_SCo | select * from sys_history where source = 'dscp dip3' order by START_DT desc |
| DSCP DiP4 | AUTO_Daily_Rot_Horizon → TECH : Horizon Rotation | acew1pdscpappe5 | DYNASYS_ITF_ECo | select * from sys_history where source = 'dscp dip4' order by START_DT desc |
| DSCP DiP5 | AUTO_Daily_Rot_Horizon → TECH : Horizon Rotation | acew1pdscpappe5 | DYNASYS_ITF_ECo | select * from sys_history where source = 'dscp dip5' order by START_DT desc |
| DSCP 1 | AUTO_Daily_Static → TECH : Horizon Rotation (Monthly) | acew1pdscpappe5 | DYNASYS_ITF_DSCP1 | select * from sys_history where source = 'dscp 1' order by START_DT desc |
| DSCP 2 | AUTO_Daily_Static → DSCP2 - TECH : Horizon Rotation | acew1pdscpapps5 | DYNASYS_ITF_DSCP2 | select * from sys_history where source = 'dscp 2' order by START_DT desc |