{"card_source":"vikunja","counts":{"cards":7,"milestones":1,"units":7},"generated":"2026-10-05T14:07:39.105533","note":"Unit bars: start = first weekly plan mentioning the item, end = latest date written in the plan text (capped at the plan week). Card bars: work-item start -> completed (open cards run to today). Black bars are literal \"due\" dates. No dates are estimated.","plan":{"file":"n-and-i-week-41-plan-2026-10-05.md","week":41,"week_end":"2026-10-11","week_start":"2026-10-05"},"tasks":[{"custom_class":"tl-red","dependencies":"","detail":"Why first: the QG PROD side has no access to the AWS Oracle RDS targets, and that access is the precondition for the ARCOR target access through QueryGrid. It is also the one open item out of the connectivity verification pair. \u00b7 Measured state 09.09.2026 03:41 (INC000100651608): all 8 flows time out, silent drop, no TCP handshake. Two sources (dea105yr 198.19.187.171, de6404yr 46.190.226.46) against four targets (BAT 46.108.219.87, ONL 46.108.219.119, CDRCOL 198.18","end":"2026-10-05","group":1,"id":"p1-1","kind":"unit","name":"CCP 254345 fix: QG PROD connector nodes to AWS RDS","progress":0,"rank":0,"start":"2026-09-21","status":"red"},{"custom_class":"tl-ready","dependencies":"p1-1","detail":"vikunja card (ready), 2 comments","end":"2026-10-05","group":1,"id":"card-t_2855c395","kind":"card","name":"\u21b3 t_2855c395 \u00b7 CCP 254345 fix: QG PROD connector nodes to AWS RDS (P1, 21.0","progress":0,"rank":1,"start":"2026-09-21","status":"ready"},{"custom_class":"tl-red","dependencies":"","detail":"Why: the roles and the users are the precondition for putting the QG nodes into productive use for ARCOR. \u00b7 State: role concept \"one role per DB, assigned to sysadmin\" went out 09.09 13:42 to Tadas, Guido, Gaurav and Sven. No reply after 7 working days.","end":"2026-10-05","group":2,"id":"p1-2","kind":"unit","name":"QueryGrid roles definition ARCOR and user creation","progress":0,"rank":0,"start":"2026-09-21","status":"red"},{"custom_class":"tl-ready","dependencies":"p1-2","detail":"vikunja card (ready), 4 comments","end":"2026-10-05","group":2,"id":"card-t_663744dd","kind":"card","name":"\u21b3 t_663744dd \u00b7 QueryGrid roles definition ARCOR + user creation (P1, 21.09)","progress":0,"rank":1,"start":"2026-09-21","status":"ready"},{"custom_class":"tl-amber","dependencies":"","detail":"Why: the bulk loads (ARCOR 7 TB, COPS BI 28 TB, CDWH 90 TB, UMDWH Kerpen open) depend on agreed rates and windows. Without them no transfer time and no target date is defensible. \u00b7 Basis: Daniel's diagram of 21.09, filed at `programme/bandwidth-overview-2026-09-21.drawio`, with the extraction in `reference/bandwidth-overview-2026-09-21.md`. Figures: ARCOR 7 TB over 5 Gbps = 2.25 TB/h = ~3.1 h; COPS BI 28 TB at 3 Gbps ","end":"2026-10-05","group":3,"id":"p1-3","kind":"unit","name":"Bandwidth alignment with the network team and with Teradata, incl. UMDWH Kerpen","progress":0,"rank":0,"start":"2026-09-21","status":"amber"},{"custom_class":"tl-ready","dependencies":"p1-3","detail":"vikunja card (ready), 3 comments","end":"2026-10-05","group":3,"id":"card-t_835a00b1","kind":"card","name":"\u21b3 t_835a00b1 \u00b7 Bandwidth alignment: network team + Teradata, incl. UMDWH Ke","progress":0,"rank":1,"start":"2026-09-21","status":"ready"},{"custom_class":"tl-green","dependencies":"","detail":"Input: Klaus Meyer 18.09 15:02, retrospective deck `TD DWH Consolidation - TD Workshop Next Steps.pptx` (2 slides, DWH_Consolidation/inbox/email/attachments/). \u00b7 Three VF-side next steps out of the workshop:","end":"2026-10-05","group":4,"id":"also-4","kind":"unit","name":"TD workshop follow-through: internal governance + HLD","progress":0,"rank":0,"start":"2026-09-21","status":"green"},{"custom_class":"tl-ready","dependencies":"also-4","detail":"vikunja card (ready), 1 comments","end":"2026-10-05","group":4,"id":"card-t_ade2c334","kind":"card","name":"\u21b3 t_ade2c334 \u00b7 Workshop follow-through: internal governance + HLD (2nd bloc","progress":0,"rank":1,"start":"2026-09-21","status":"ready"},{"custom_class":"tl-milestone","dependencies":"also-4","detail":"due 24.09","end":"2026-09-25","group":4,"id":"ms-also-4-2026-09-24","kind":"milestone","name":"due 24.09 \u2014 TD workshop follow-through: internal governance + ","progress":0,"rank":2,"start":"2026-09-24","status":"due"},{"custom_class":"tl-green","dependencies":"","detail":"DATE Board recommended Airflow (Cloud Composer) on 15.09 as the MDWH scheduler: add-ons 200k EUR one-time, ~132k EUR recurring, against Control-M licences >1M EUR recurring. \u00b7 The management decision is NOT taken. What runs now is the preparation of that decision.","end":"2026-10-05","group":5,"id":"also-5","kind":"unit","name":"Airflow scheduler: preparation of the management decision","progress":0,"rank":0,"start":"2026-09-21","status":"green"},{"custom_class":"tl-ready","dependencies":"also-5","detail":"vikunja card (ready), 4 comments","end":"2026-10-05","group":5,"id":"card-t_4e975695","kind":"card","name":"\u21b3 t_4e975695 \u00b7 Airflow Scheduler - SteerCo Adoption (P1)","progress":0,"rank":1,"start":"2026-09-17","status":"ready"},{"custom_class":"tl-amber","dependencies":"","detail":"(carry over from week 38, topic 10; state of 18.09) \u00b7 Christian Wilkat 12:34: DB transfer over proxy is NOT valid. The only Internet-to-GCP path is an additional local server with a public interface to the Internet and an inside interface to the DB (the Octopus solution that was skipped in the","end":"2026-10-05","group":6,"id":"also-6","kind":"unit","name":"Berlin -> GCP migration pipeline: Octopus and Equinix 10G decision","progress":0,"rank":0,"start":"2026-09-21","status":"amber"},{"custom_class":"tl-ready","dependencies":"also-6","detail":"vikunja card (ready), 6 comments","end":"2026-10-05","group":6,"id":"card-t_7a9f2cb9","kind":"card","name":"\u21b3 t_7a9f2cb9 \u00b7 Berlin -> GCP Migration Pipe Options (incl. Octopus re-open)","progress":0,"rank":1,"start":"2026-09-15","status":"ready"},{"custom_class":"tl-amber","dependencies":"","detail":"CCP 256924 (BODS DEV) and 256923 (BODS PROD) are with Sanjay for implementation (asked by Stefanos 11.09). Will Lok checking the IDPS/PCS/TD change need. \u00b7 Routing restriction: two IPs are not permitted (10.32.7.251/32, 10.32.243.141/32). Allowed KDG -> TD set is prefix-set KDG-CSP-TRANSIT-LM (10.32.0.0/22, 10.32.26.0/23, 172.19.129.0/24, 172.28.0.0/16, 10.101.64.0/28, .32/27, .64/26, .160/27,","end":"2026-10-11","group":7,"id":"also-7","kind":"unit","name":"BODS connectivity: partial implementation go and downstream confirmation","progress":0,"rank":0,"start":"2026-09-21","status":"amber"},{"custom_class":"tl-ready","dependencies":"also-7","detail":"vikunja card (ready), 6 comments","end":"2026-10-11","group":7,"id":"card-t_01f6b3de","kind":"card","name":"\u21b3 t_01f6b3de \u00b7 BODS Downstream Connectivity (P1)","progress":0,"rank":1,"start":"2026-08-10","status":"ready"}]}