To monitor (all GBUs) with Horizon Roll
| Application | Instructions | Screenshot |
|---|---|---|
Dscp DPx / Dipx / DSCPx |
https://dynasysprd.eua.solvay.com/RDWeb/Pages/en-US/Default.aspx | NULL |
| 2. Choose the application |
| |
3. Input your user ID to get connected. ( Usually the User ID = Windows ID), no need to input Password. |
| |
| 4. In the ribbon, click on 'Explorer' |
| |
5. in Structure tab, open 'Horizons' Structure → Horizons → Horizons → _Tech:Current Month |
| |
6. For each below application double click on the related Horizon to check if the month is the current one. |
|
BACK to 6. Monitoring
To monitor (all GBUs) with Horizon Roll ， Batch status
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) |
|
| DP1 - _Tech: Current Month (get connection to application DP1) |
| |
DP2 | DP2 - TECH : Horizon Rotation (get connection to SQL Server) |
|
| DP2 - Forecast month (get connection to application 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) |
| |
DP3 | DP3 - AUTO_Monthly_FirstDay (get connection to SQL Server) |
|
| DP3 - _Tech: Current Month (get connection to application DP3) |
| |
DiP1 | DiP1 - TECH : Horizon Rotation (get connection to SQL Server) |
|
| DiP1 - AUTO_EOM_Archive (get connection to SQL Server) |
| |
| DiP1 - TECH : Current Month (get connection to application DiP1) |
| |
DiP2 | DiP2 - AUTO_Daily_Rot_Horizon (get connection to SQL Server) |
|
| DiP2 - TECH : Current Month (get connection to application DiP2) |
| |
| DiP2 - CH - S&OP Validated Archive (get connection to application DiP2) |
| |
DiP2 - TECH : Horizon Rotation (get connection to PROD folder:/Files Prod Server Logs - DiP2) *DiP2 - before horizon shift, archives will be run within Horizon rotation. ( Archive first, then Shift the Horizon) |
| |
DiP3 | DiP3 - AUTO_Daily_Rot_Horizon (get connection to SQL Server) |
|
| DiP3 - TECH : Current Month (get connection to application DiP3) |
| |
| DiP3 - User models - U01 - NOVECARE - Monthly Archive (get connection to application DiP3) |
| |
DSCP 1 | DSCP1 - TECH : Horizon Rotation (Monthly) (get connection to SQL Server) |
|
DSCP1 - _TECH: Current Month (get connection to application DSCP1) | ||
DSCP 2 | DSCP2 - TECH : Horizon Rotation (get connection to SQL Server) |
|
| DSCP2 - _Tech: Current Month (get connection to application DSCP2) |
#Monthly Archive
Description | Application | How to Do | Screenshot |
|---|---|---|---|
| To cross check the Monthly Archive | 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 |
|
BACK to 6. Monitoring
#Prod Server Logs
Description | Application | Instructions | Screenshot |
|---|---|---|---|
| To cross check in Prod Server Logs if the sequence is executed correctly | 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 |
|
#Get connection to SQL Server
Application | Batch | Server name | Databases | SQL request |
|---|---|---|---|---|
| Auto_Montly_Firstday | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dp1' order by START_DT desc | |
| DSCP DP2 | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dp2' order by START_DT desc | |
| DSCP DP3 | 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 | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dip1' order by START_DT desc | |
| DSCP DiP2 | acew1pdscp21 | DYNASYS_ITF | select * from sys_history where source = 'dscp dip2' order by START_DT desc | |
| DSCP DiP3 | 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 | acew1pdscp22 | DYNASYS_ITF_DSCP1 | select * from sys_history where source = 'dscp 1' order by START_DT desc | |
| DSCP 2 | acew1pdscp21 | DYNASYS_ITF_DSCP2 | select * from sys_history where source = 'dscp 2' order by START_DT desc |