#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 |  | |
| 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. |  | |
DP1 | _Tech: Current Month |
|
| DP2 | Forecast month |
|
| DP3 | _Tech: Current Month |
|
| DP4 | ||
| DP5 | ||
| DiP1 | TECH : Current Month |
|
| DiP2 | TECH : Current Month |
|
| DiP3 | 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. | NULL |
DP1 | DP1 - AUTO_Monthly_FirstDay (get connection to SQL Server) |
|
DP2 | DP2 - TECH : Horizon Rotation (get connection to SQL Server) |
|
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) |
| |
DP3 | DP3 - AUTO_Monthly_FirstDay (get connection to SQL Server) |
|
DiP1 | DiP1 - TECH : Horizon Rotation (get connection to SQL Server) |
|
| DiP1 - AUTO_EOM_Archive (get connection to SQL Server) |
| |
DiP2 | DiP2 - AUTO_Daily_Rot_Horizon (get connection to SQL Server) |
|
DiP3 | DiP3 - AUTO_Daily_Rot_Horizon (get connection to SQL Server) |
|
| DiP4 | ||
DiP5 | ||
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 DiP2 | 1> Get connected to DSCP DiP2 2> Explorer → Structure → User models → U01 - SPECHEM → Archive template → S&OP Validated |
|
| DSCP DiP3 | 1> Get connected to DSCP DiP3 2> Explorer → Structure → User models → U01 - NOVECARE → Archive template → MONTHLY ARCHIVE |
|
#Prod Server Logs
To cross check in Prod Server Logs if the sequence is executed correctly
Application | Instructions | Screenshot |
|---|---|---|
| DSCP DiP2 | 1> Get connected to Prod Server Logs https://dynasysprd.eua.solvay.com/RDWeb/Pages/en-US/Default.aspx/Files PROD folder:/Files → Prod Server Logs |
|
2> Cross check inside the logs Open Dip2 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 *DiP2 - before horizon shift, archives will be run within Horizon rotation. ( Archive first, then Shift the Horizon) |
|
#Get connection to SQL Server
Application | Batch | Server name | Databases | SQL request |
|---|---|---|---|---|
Auto_Montly_Firstday → TECH : Horizon Rotation | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dp1' order by START_DT desc | |
| DSCP DP2 | TECH : Horizon Rotation | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dp2' order by START_DT desc |
| DSCP DP3 | AUTO_Monthly_FirstDay → TECH : Horizon Rotation | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dp3' order by START_DT desc |
| DSCP DP4 | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dp4' order by START_DT desc | |
| DSCP DP5 | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dp5' order by START_DT desc | |
| DSCP DiP1 | TECH : Horizon Rotation | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dip1' order by START_DT desc |
| DSCP DiP2 | AUTO_Daily_Rot_Horizon → TECH : Horizon Rotation | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dip2' order by START_DT desc |
| DSCP DiP3 | AUTO_Daily_Rot_Horizon → TECH : Horizon Rotation | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dip3' order by START_DT desc |
| DSCP DiP4 | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dip4' order by START_DT desc | |
| DSCP DiP5 | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dip5' order by START_DT desc | |
| DSCP 1 | TECH : Horizon Rotation (Monthly) | acew1pdscp22 | DYNASYS_ITF_DSCP1 | select * from sys_history where source = 'dscp 1' order by START_DT desc |
| DSCP 2 | DSCP2 - TECH : Horizon Rotation | acew1pdscp21 | DYNASYS_ITF_DSCP2 | select * from sys_history where source = 'dscp 2' order by START_DT desc |