Platform Evolution
Assessment run-2026-07-27-1 · 213 of 213 repos assessed
Repos / phenix-task-reminder-wcf

phenix-task-reminder-wcf

WCF Task Reminder service, owned TaskReminder database and a Windows-service daily email job that generate and deliver task reminders for Phenix users.

27 · redhighkernelOn-premZDD: a long roadservicesecrets in source

Health score

27

0 to 100 across seven weighted factors; nothing is hidden. Green is 75 and above, amber 50 to 74, red below 50. How scoring works.


Runtime currency / 25
0
.NET Framework, out of mainstream support
Legacy transport / 15
2
Hosts WCF or SOAP endpoints with no successor on modern .NET
Test posture / 15
8
Some tests, coverage is thin
Security hygiene / 15
0
Credentials or keys committed to source
Dangerous coupling / 15
3
shares a core database (sqlserver:Phenix); depends on pinning component(s): application-framework, phenix-feature-service, mail-service
Activity / 10
10
Actively maintained
Deployment hygiene / 5
5
CI in place
Health over time
2026-07-24 (run-2026-07-24-1): 272026-07-27 (run-2026-07-27-1): 27
No change since 2026-07-24 (27 to 27).

Facts

Languagescsharp, sql
FrameworksWCF, MSTest
Runtimes.NET Framework 4.7.2
Tests / CIsome / CI in place
Last commit2026-07-16
OwnerOwner unknown (mapping to be curated)
DomainBookings and fulfilment (system generated; curate in repo-owners.json to override)
Product areaPhenix
HostedOn-prem Deployed to our own machines
  • Release "\marketing\phenix-task-reminder-wcf": Development WCF: deployment-group phase (agents on our own machines)
  • Release "\marketing\phenix-task-reminder-wcf": Development DB: deployment-group phase (agents on our own machines)
  • Release "\marketing\phenix-task-reminder-wcf": Staging WCF: deployment-group phase (agents on our own machines)
  • Release "\marketing\phenix-task-reminder-wcf": Staging DB: deployment-group phase (agents on our own machines)
  • Release "\marketing\phenix-task-reminder-wcf": Production WCF: deployment-group phase (agents on our own machines)
Releases3 release pipeline(s): \marketing\phenix-task-reminder-wcf; \marketing\phenix-task-reminder-wcf packages; \marketing\phenix-task-reminder-wcf stealth
Integrationwcf
SourceOpen in Azure DevOps

Risk flags

Each flag links to its glossary definition.

Dependencies in context

Laying out the graph…
greenamberreddata store (square, dashed link)Node size follows fan-in. Click any node to open it.

Entanglement

kernel Bound into the core by 3 mechanism(s).

Detaches when its pinning dependencies are cut or multi-targeted (application-framework, phenix-feature-service, mail-service); and when its WCF surface gains a modern interface or its WCF calls move to one; and when the shared database group it belongs to gains an owned API or completes schema separation (sqlserver:Phenix).

Migration playbooks

Generated from this repo's assessment data: what is feasible, what blocks it, and the steps in order. Ratings: green means actionable now, amber means sequence other work first, red means blocked, grey means not applicable.

ZDD adoption

A long road

Technically eligible one day, but the blockers are structural: hosted WCF or SOAP contracts that cannot run two versions at once, or heavy legacy coupling. Sequence the modernisation work first. Hosts WCF or SOAP endpoints: strict serialization contracts cannot safely run two versions at once (the shared-enum trap). End-of-life runtime compounds the work. Shares sqlserver:Phenix: schema changes move in convoy.

Blockers
Dependencies and gotchas
  • 4 system(s) depend on this repo; during a rolling deploy they will talk to old and new versions at once, so responses must stay compatible
  • Shares sqlserver:Phenix with 21 system(s): destructive schema change is prohibited in a single release; expand and contract only
  • Feature flags come from phenix-feature-service (WCF-only): flag reads themselves are a legacy dependency to watch
  • Runs as a Windows service or scheduled task: deploy between runs or use overlapping instances; the load-balancer drain pattern does not apply directly
Steps
  1. Adopt the four-stage discipline from the ZDD engineering standard: pre-deployment compatibility, deployment, feature activation behind a flag, post-release cleanup.
  2. Raise automated test coverage first: ZDD trades the end-of-sprint manual gate for continuous automated confidence, so the tests are the entry ticket.
  3. Make every change dual-version safe: backwards-compatible APIs (new major version for breaking wire changes), expand and contract for any schema change, and consumers tolerant of unknown fields.
  4. Audit serialized data: anything in Redis, queues or shared caches must deserialize cleanly across adjacent versions.
  5. Wrap behaviour changes in feature flags so code deploys dark and release becomes a business decision, not a deployment event.
  6. Route deployments through the Workflow Engine's automated drain, deploy, health-check, return cycle (the path proven by the first automated production run in mid-2026).
  7. Verify with area-scoped regression rather than the whole-platform cycle, and watch error rates after rollout with automated rollback on alert.

SQL Server exit

Blocked by a shared core database

sqlserver:Phenix is shared, so this system cannot change engine on its own: every sharer moves in convoy. The stage 4 work (named owner, declarative schema, owned API) has to land first; after that, the steps below apply to whatever slice this system ends up owning.

Blockers
Steps
  1. Inventory the schema and query surface of sqlserver:TaskReminder, sqlserver:Phenix: tables, stored procedures, triggers, cross-database joins and anything else engine-specific.
  2. Confirm the target: PostgreSQL (relational model; keep transactions and joins, swap the engine).
  3. Replatform to modern .NET first (see the recommended actions): current PostgreSQL and MongoDB drivers and EF Core providers target modern .NET, and doing one risky change at a time is cheaper than doing two.
  4. Data access is not through an ORM, so port the SQL by hand: translate T-SQL constructs, replace stored procedures with application code or target-native equivalents, and add integration tests around the queries that matter first.
  5. Stand up the target alongside SQL Server, backfill with an ETL pass (pgloader or an export/import job), then dual-write or replicate until parity is proven.
  6. Move reads to the target, watch correctness and latency, then cut writes over and keep SQL Server read-only until confidence is earned.
  7. Decommission the SQL Server database and remove the connection strings and firewall paths that pointed at it.

Containerisation

Feasible after replatforming

Appropriate eventually, but not from here: the legacy runtime and the hosted WCF surface both have to go first, and that work is already in this repo's recommended actions.

Blockers
Steps
  1. Replatform to modern .NET first (see the recommended actions), replacing the hosted WCF/SOAP surface with REST, gRPC or messaging so consumers can follow. Containerising then becomes routine.
  2. Convert the Windows service or scheduled task into a .NET worker service (or an ECS scheduled task) so it has a container-shaped lifecycle.
  3. Add a Dockerfile and make the app read all configuration from environment variables and the secrets manager, never from machine-local files.
  4. Log to stdout and expose a health check endpoint so ECS can supervise it.
  5. Adopt the shared ci.yml pipeline template with the container parameters (awsRegion, containerAfterBuild, ecsTerraformRepo), which is exactly how the estate's existing AWS services deploy.
  6. Define the service in the Terraform repo, deploy to a non-production environment, then shift traffic and disarm the deployment-group release pipeline.

Recommended actions

Rotate the credentials committed to phenix-task-reminder-wcf

Risk flags indicate credentials or keys in source (plaintext-credentials). Rotate now and enable secret scanning in CI; this is independent of all other work.

Impact: Closes a live security exposure at near-zero cost

proposed

Replatform phenix-task-reminder-wcf to modern .NET

Runs on .NET Framework 4.7.2, out of mainstream support. Blocked until stage 2 cuts: application-framework, phenix-feature-service, mail-service. Shares sqlserver:Phenix, so batch it with its database group (stage 4).

Impact: Unblocks 4 dependent system(s)

proposed

Assessment notes

phenix-task-reminder-wcf

Purpose

Backend of the Phenix task-reminder capability: an IIS-hosted WCF service (TaskReminderServiceHost.svc, plus a "secure" endpoint) implementing reminder definitions, schedules and rule-driven task generation; the TaskReminderDatabase sqlproj with create/change scripts; and TC.TaskReminder.DailyEmail, a Windows service that emails users their daily reminders. Contract and client NuGet packages are published for consumers (the companion phenix-task-reminder-web UI).

Tech stack

All projects target .NET Framework 4.7.2 with old-style csproj and packages.config. WCF wsHttpBinding endpoints (secure and unsecure), stored-procedure data access, per-environment Web/App config transforms, and an HTML email template for the daily job.

Deployment

Three release pipelines under \marketing\ (main, packages, stealth; release_count 3) fed by YAML builds in the repo (azure-pipelines.yml versioned 23.4.x, azure-pipelines-packages.yml for the contract/client packages) using shared InternalOSS templates. The DailyEmail component deploys as a Windows service.

Dependencies

Internal packages: TC.Exceptions, TC.Phenix.ApplicationFramework/Configuration, TC.Phenix.CompanyInfo, TC.Phenix.Feature, TC.Mail.ServiceClient (mail-service) for sending the daily emails, and TC.UserAccount.ServiceClient. No third-party services.

Data stores

Owns the TaskReminder SQL Server database (sqlproj with rule-implementation stored procedures such as TaskRuleImplementation_Enquiry). Also reads the shared Phenix database (connection strings present in DailyEmail App.config).

Integration points

Inbound WCF (wsHttpBinding) consumed via the published TC.TaskReminder.ServiceClient. Outbound calls to the mail and user-account services. No REST surface.

Code health

Two MSTest projects (~44 tests) covering task generation, recurring dates and the service host — reasonable for its age. Minimal but real README. Actively maintained (last commit 2026-07-16). Web.config/App.config transforms contain plaintext SQL credentials, including preproduction and production entries.

Modernisation risks

High: an actively developed .NET Framework 4.7.2 WCF service with a Windows-service job, packages.config and checked-in production credentials. Downstream consumers bind to the WCF contract package, so replacement needs a REST facade or client migration; the owned database and rule stored procedures carry the real business logic.