View Source

#Horizon Roll

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

Application	Instructions	Screenshot
Dscp DPx / Dipx / DSCPx	Get connected:	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*

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)
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)
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)
DiP1	*DiP1 - AUTO_EOM_Archive* (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)
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 DiP3

1> Get connected to DSCP DiP3

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

SBS - DynaSys Team - Techno > 6.1 - The 1st day - Rotation Horizon > image2022-12-30_14-41-4.png

DSCP DiP5

1> Get connected to DSCP DiP5

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

SBS - DynaSys Team - Techno > 6.1 - The 1st day - Rotation Horizon > image2023-2-8_14-55-53.png

BACK to 6. Monitoring

#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~~

SBS - DynaSys Team - Techno > 6.1 - The 1st day - Rotation Horizon > image2022-12-30_14-54-14.png

~~2> Cross check inside the logs~~

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

SBS - DynaSys Team - Techno > 6.1 - The 1st day - Rotation Horizon > image2022-12-30_14-59-52.png

~~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)

SBS - DynaSys Team - Techno > 6.1 - The 1st day - Rotation Horizon > image2022-12-30_15-1-48.png

BACK to 6. Monitoring

#Get connection to SQL Server

Application	Batch	Server name	Databases	SQL request
DSCP DP1	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

BACK to 6. Monitoring