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.
Health score
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.
Facts
| Languages | csharp, sql |
| Frameworks | WCF, MSTest |
| Runtimes | .NET Framework 4.7.2 |
| Tests / CI | some / CI in place |
| Last commit | 2026-07-16 |
| Owner | Owner unknown (mapping to be curated) |
| Domain | Bookings and fulfilment (system generated; curate in repo-owners.json to override) |
| Product area | Phenix |
| Hosted | On-prem Deployed to our own machines
|
| Releases | 3 release pipeline(s): \marketing\phenix-task-reminder-wcf; \marketing\phenix-task-reminder-wcf packages; \marketing\phenix-task-reminder-wcf stealth |
| Integration | wcf |
| Source | Open in Azure DevOps |
Risk flags
Each flag links to its glossary definition.
Dependencies in context
Entanglement
kernel Bound into the core by 3 mechanism(s).
- Pinning dependency: application-framework, phenix-feature-service, mail-service
- Speaks WCF (host)
- Shares core database sqlserver:Phenix
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 roadTechnically 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.
- 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
- Adopt the four-stage discipline from the ZDD engineering standard: pre-deployment compatibility, deployment, feature activation behind a flag, post-release cleanup.
- Raise automated test coverage first: ZDD trades the end-of-sprint manual gate for continuous automated confidence, so the tests are the entry ticket.
- 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.
- Audit serialized data: anything in Redis, queues or shared caches must deserialize cleanly across adjacent versions.
- Wrap behaviour changes in feature flags so code deploys dark and release becomes a business decision, not a deployment event.
- 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).
- 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 databasesqlserver: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.
- Inventory the schema and query surface of sqlserver:TaskReminder, sqlserver:Phenix: tables, stored procedures, triggers, cross-database joins and anything else engine-specific.
- Confirm the target: PostgreSQL (relational model; keep transactions and joins, swap the engine).
- 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.
- 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.
- 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.
- Move reads to the target, watch correctness and latency, then cut writes over and keep SQL Server read-only until confidence is earned.
- Decommission the SQL Server database and remove the connection strings and firewall paths that pointed at it.
Containerisation
Feasible after replatformingAppropriate 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.
- .NET Framework only runs on Windows; practical (Linux) containers need modern .NET
- Hosts WCF or SOAP endpoints, which have no home on modern .NET; consumers need a modern interface first
- 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.
- Convert the Windows service or scheduled task into a .NET worker service (or an ECS scheduled task) so it has a container-shaped lifecycle.
- Add a Dockerfile and make the app read all configuration from environment variables and the secrets manager, never from machine-local files.
- Log to stdout and expose a health check endpoint so ECS can supervise it.
- 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.
- 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
proposedReplatform 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)
proposedAssessment 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.