Builds admin-configurable navigation in ASP.NET Core without weakening security: models each item as a typed setting, validates it server-side on save and at startup, builds internal hrefs from named routes and external hrefs from an allowlisted Uri check, and filters items per user with IAuthorizationService. Use for…
Fixes Notion policy wiki error duplicate policy pages with conflicting rules in Notion by applying the specific fix in the steps and proving it on one employee group or policy page first. Use when this failure blocks a policy rollout, a handbook acknowledgment or a policy announcement. Not for platform outages or unre…
Fixes vendor master duplicate error same supplier created in two ERPs in vendor master by applying the specific fix in the steps and proving it on one vendor first. Use when this failure blocks a vendor onboarding, a payment setup or a vendor record. Not for platform outages or unrelated supplier cleanup.
Shows how to build a public audit history projection for document approvals that cannot leak private review notes: filter at projection time on both document status and event visibility, store the public read model in a separate table with no private columns, and handle unpublish, rebuilds and counts. Use when exposin…
Shows how to build an approval workflow in ASP.NET Core with EF Core where a submitted revision is an immutable snapshot, optimistic concurrency stops overwrites, and notifications are written to a transactional outbox in the same transaction as the submit and published afterwards. Use when approvers must approve exac…
Fixes the duplicate thread merge agent failure Scraper failed on the forum search query log - empty results during thread merging by applying the specific fix in the steps, proving it on one small scope first, then rerunning and reconciling counts. Use when this problem blocks moderation, community operations or a mem…
Vectle found the following relevant skills: - dbt test failed: relationships test on orders" - dbt test error: accepted_values test failed with unexpected value error - [d…
Do not widen the anomaly bounds to silence it: open the Elementary test result, read the observed row count against the training window average and standard deviation, and check whether a real load change explains the jump before touching the test configuration. Use when an Elementary-monitored dbt project where a tab…
Vectle found the following relevant skills: - dbt test failed: unique_combination_of_columns failed with duplicate keys error - dbt test failed: unique_combination_of_columns failed with duplicate keys error
Vectle found the following relevant skills: - dbt test failed: unique_combination_of_columns failed with duplicate keys error - dbt test failed: unique_combination_of_columns failed with duplicate keys error
Query the source grouped by the key to find the duplicated keys, fix the upstream join or dedupe rule that produced the second row, and only then re-run the refresh. Use when you see this exact failure in Power BI and the affected record or object can be named. Not for a different Power BI error with another message, …
Vectle found the following relevant skills: - dbt singular test failure: assertion failed error rows returned - agent loop detected: agent retrying failed dbt test in infinite loop error
Count the duplicates precisely, then find the load or join that creates them: group the table by its full business key, measure how many duplicate groups exist and how far above the allowed tolerance they sit, and fix the creating step. Use when a data quality check reporting more duplicate rows than allowed. Not for …
Find the duplicated key combination before touching the test: run the test query grouped by the key columns, inspect the duplicate groups, and fix the join or fan-out that creates them, or correct the key if the declared combination is not actually unique in the business data. Use when a dbt model whose declared uniqu…
Vectle found the following relevant skills: - dbt test failed: unique_combination_of_columns failed with duplicate keys error - Unique test failed: duplicate values in primary key" dbt
Vectle found the following relevant skills: - context overflow when agent tried to compare all annotator pairs failed error - context overflow when agent tried to load all anomaly alerts error failed memory