General presentation
The aim of the document is to list daily and monthly checks to do and following actions.
All checks are done by CGI team.
In case of BW assistance, contact Saints Zhang (Competence Center / SCMS domain)
In case of DynaSys assistance, contact DynaSys.Interface.Team@solvay.com
In case of MFT/Webservice assistance, contact support.xml@solvay.com
Please register all production issue in following google spreasheet
Due to several complaints from DynaSys Team and DynaSys users, it is important to fill the document with detailed information
Every day by 9.15 am CET
In WBP with transaction ST13 / BW-Tools, use the variants DYNASYS_INTERF and DYNASYS_REPORT to have all the chains of interface and reporting
Check Interfaces chains - Steps to follow & Actions to do
Check following chains has run, and ended ok.
| Chain | Type | Description | Frequency | Criticity |
|---|---|---|---|---|
PC_DPS_DYNASYS_01 | Interface | DPS DynaSys: META PART1 - D - Daily Meta-Chain Part 1 | Daily after Global sales chains (Not on week-ends or certains bank holidays ) => starter = EVENT Z_EVT_END_GL006 | HIGH |
PC_DPS_DYNASYS_25 | Interface | DPS DynaSys: META PART2 - D - Daily Meta-Chain Part 2 | Daily after Global sales chains (Not on week-ends or certains bank holidays ) => starter = EVENT Z_EVT_END_GL003 | HIGH |
| PC_DPS_DYNASYS_03 | Interface | DPS Dynasys: META - W - Weekly Meta-Chain | Weekly on saturdays à 9am CET | HIGH Certain GBUs are weekly refreshed on DynaSys => In case of issue, inform DynaSys team on Monday CAUTION : This chain should not be repaired on Mondays as daily chain is replacing it |
If both daily chains have not finished by 7 am, identify the root cause and estimate the ended time (if possible)
Inform DynaSys Interface Team before by 9:15 am CET => DynaSys Interface Team : Interface Issue
Check Reporting chains - Steps to follow & Actions to do
Check the process chain from the night before 6pm until current day 7am.
| Chain | Type | Description | Frequency | Criticity | Comment |
|---|---|---|---|---|---|
PC_DPS_DYNASYS_15 | Reporting | DPS Dynasys: META - D - 6.Reporting DynaSys (Dynamic KPIs) | Daily at 7am , 2pm , 6pm , 11pm (Not on week-ends or certains bank holidays ) | HIGH | |
PC_DPS_DYNASYS_09 | Reporting | DPS Dynasys: META - M - 6.Reporting DynaSys (Snapshots) | Every 6th of month at 6am | HIGH | |
| PC_DPS_DYNASYS_23 | Reporting | DPS Dynasys: META - M - 6.Reporting DynaSys (MasterData) | Daily at 10pm (Not on week-ends or certains bank holidays ) | MEDIUM | |
| PC_DPS_DYNASYS_33 | Reporting | DPS Dynasys: TD - D - Reporting Dynasys (DIP Inventory KPIs) | Daily at 10am (or 11am), 2pm , 6pm , 11pm (Not on week-ends or certains bank holidays ) | MEDIUM | |
| removed from scheduling 07/07/2020 (Special Chem Go-Live) | ||||
| removed from scheduling 07/07/2020 (Special Chem Go-Live) |
If chain PC_DPS_DYNASYS_15 has not run at 6pm CET previous night or 11pm CET previous night
=> inform DynaSys.Interface.Team@solvay.com
If chain PC_DPS_DYNASYS_15 has not run at 7am CET
=> get last timestamp in DPS DPDYN39 / DYN - Table SYS_TIMESTAMP ( Write-Optimized ) by running IP "IP: DTS_SYS_TIMESTAMP (Dynasys) - Full with filters"
=> check time stamps date + time
=> inform DynaSys.Interface.Team@solvay.com
If timestamp is over 7am, BW DynaSys Team will analyse if it is worth it to force an intermediate upload.
In case of intermediate load, no need to inform users. Otherwise users will be noticed by DynaSys.Interface.Team@solvay.com => DynaSys Interface Team : Reporting Issue
If no timestamp at all, inform DynaSys.Interface.Team@solvay.com => DynaSys Interface Team : Reporting Issue
If chain PC_DPS_DYNASYS_33 has not run at 6pm CET previous night or 11pm CET previous night
=> inform DynaSys.Interface.Team@solvay.com
If chain PC_DPS_DYNASYS_33 has not run at 10am CET or 11am CET
=> get last timestamp in DPS DPDYN39 / DYN - Table SYS_TIMESTAMP ( Write-Optimized ) by running IP "IP: DTS_SYS_TIMESTAMP (Dynasys) - Full with filters"
Daynasys Source = BW
Dynasys - Table Name = EXP_DIP_BW
Dynasys - Type = TECH : EXPORT BW
=> check time stamps date + time
=> inform DynaSys.Interface.Team@solvay.com
If timestamp is over 11am, BW DynaSys Team will analyse if it is worth it to force an intermediate upload.
In case of intermediate load, no need to inform users. Otherwise users will be noticed by DynaSys.Interface.Team@solvay.com => DynaSys Interface Team : Reporting Issue
If no timestamp at all, inform DynaSys.Interface.Team@solvay.com => DynaSys Interface Team : Reporting Issue
Every day by 2.45 pm CET
Check following chain or check you have received the automatic email called "Demand planning BW report successfully update" (for PC_DPS_DYNASYS_15) and "DiP-PP reporting in BW successfully updated" (PC_DPS_DYNASYS_33).
| Chain | Type | Description | Frequency | Criticity |
|---|---|---|---|---|
PC_DPS_DYNASYS_15 | Reporting | DPS Dynasys: META - D - 6.Reporting DynaSys (Dynamic KPIs) | Daily at 7am , 2pm , 6pm , 11pm (Not on week-ends or certains bank holidays ) | HIGH |
| PC_DPS_DYNASYS_33 | Reporting | DPS Dynasys: TD - D - Reporting Dynasys (DIP Inventory KPIs) | Daily at 10am (or 11am), 2pm , 6pm , 11pm (Not on week-ends or certains bank holidays ) | Medium |
if no, refer to action described for morning reporting checks.
Communication
DynaSys Interface Team : Interface Issue
Email address: DynaSys.Interface.Team@solvay.com
If only PC_DPS_DYNASYS_25 is late => adapt object and content of the email refering to DP
if both chains are late => adapt object and content of the email refering to both DP / DiP-PP
Email Object : /!\ [DP/DiP-PP] Dynamic import will be late today
Email Content (to be adjusted according to impact DP and / or DiP-PP):
"Hello,
Due to an issue on BW side, data files will not be available for Dynasys integration before 11:00 CET.
The integration in Dynasys will be ended approximatively round 12:00 CET for DiP1/DiP2/DiP3 and 12:30 CET for DP1/DP2/DP3.
Regards,"
* give more details about the issue (Global Sales delay, Global Sales error, DynaSys chain issue, Source System PF1/WP1 issue...)
DynaSys Interface Team : Reporting Issue
email or tchat DynaSys.Interface.Team@solvay.com with DPDYN39 contain
DynaSys Team : Interface/Reporting Issue
KeyUsers : Reporting message
Message to users by using last received emails called (or create new message)
- "Demand planning BW report successfully update"
- "CM Aero-Demand planning in BW successfully updated"
- "DiP-PP reporting in BW successfully updated"
Add distribution list :
$SBS-IS-DynaSys team => IS Team
$DynaSysDP2-KeyUsers (DP2 = CM Aero) => for CM Aero message
$DynaSysDP3-KeyUsers (DP3 = Novecare) => for others GBUs
$DynaSysDP-KeyUsers (DP = rest of GBUs) => for others GBUs
=> inform QV team if necessary guillaume.viaux-exterieur@solvay.com (depending of the issue)
Check impact on QV - Demand Review for SBS Dashboard - All except CM (Aero)
Change Email Object
Demand planning BW report => Not up to date or Not available => for others GBUs
CM Aero-Demand planning BW report => Not up to date or Not available => for CM Aero
Put Email content
"Hello,
Due to an issue, Demand planning BW reports are not up to date or not available
I will keep you informed when report are available."
KeyUsers : Interface message
$DynasysDP1-KeyUsers
$DynasysDP2-KeyUsers
$DynasysDP3-KeyUsers
$DynasysUsersDiP1 (Silica Soad Perox) <DynasysUsersDiP-PP@solvay.com>
$DynaSysUsersDiP2 (TS - Aroma) <DynaSysUsersDiP-PP2@solvay.com>
$DynaSysUsersDiP3 (Novecare) <DynasysUsersDiP3@solvay.com>
If there is a requirement for follow-up (on incident status), a wiki or google doc could be
Contacts
CGI team for WBP Chains Issues
Generic email address (caution 23 members) : SB S-IS-Appli-Techno-Report-BW.CGI@solvay.com
DynaSys team for DYNASYS PROD Issues
DynaSys.Interface.Team@solvay.com
Know Issues
Interface Flat files are generated but not archived or not received by DynaSys
Currently webmethod/MFT first archives files, secondly transfers files to DynaSys
First : check files are archived
In archive directory /exploit/BW/archive/DYNASYS you should have at least all this zip files with date of the day
DYS_BW_PART2.zip => PART2 file
DYS_BW_PART1.zip => PART1 file
DYS_BW_MASTER.zip => MASTER file
If files are archived it means issue is concerning the file transfer part.
Secondly : create an 'high' incident to support group IT Slalom MFT
MFT team receive an automatic incident but seems not re-running transfert nor alert anyone else 
Create a ticket similar to INC%210644 to ask MFT the root cause and why no alert, nor re-run transfert has been done
https://solvay-smartit.onbmc.com/smartit/app/#/incident/IDGEMRVSDG4EQAR0MPXDRJN5LASVMI
If incident is not taken into account email support.xml@solvay.com and put in copy DynaSys.Interface.Team@solvay.com
Thirdly : create an 'high' incident to support group IT Data Stellar L3 BW
Ask CGI team to process again MFT part by launching wanted part PART1 or PART2 or MASTER :
- MASTER => Run PC PC_DPS_DYNASYS_Z03 (DPS DynaSys: Files transfer only - OnDemand - MASTER files)
- PART1 => Run PC PC_DPS_DYNASYS_Z01 (DPS DynaSys: Files transfer only - OnDemand - PART1 files)
- PART2 => Run PC PC_DPS_DYNASYS_Z02 (DPS DynaSys: Files transfer only - OnDemand - PART2 files)
Field XXX is not a member of XXX
See Connection with UD CONNECT
Weekly and Monthly release days for DynaSys team (impact on loadings)
DynaSys DP = Weekly release all Mondays from 12pm to 12h45pm + Monthly release every 1st Thursday of the month
DynaSys DIP = Monthly Release every 2nd Thurdays of the month
Note that during the days of the monthly release, Demand Planning BW report is not updated at 2pm and sometimes also 6pm.
Below, an example of email to inform users:
"Hello,
Due to Release on DynaSys side, Demand Planning BW report will not be updated at 2pm CET. The next update is scheduled today at 6pm CET.
Thanks for your understanding.
Regards, "
Issue on APD => Dump on ST22 : TSV_TNEW_PAGE_ALLOC_FAILED
Sometimes it can be possible to have an issue at APD level when there is no more memory available.
ST22 Dump log :
When it's happened, try to modify the Performance settings at APD Level :
- Goto => performance Setttings
By default the flag is active.
TODO :
Uncheck the Process Data in Memory, activate the APD and repeat the step in issue at the process chain level.
If WBP is not available Saturday
If WBP in not available during Saturday morning, you have to manually generate weekly files
- DYS_BW_SKU_PW_DYNAMIC.csv
- DYS_BW_BOM.csv