Press "Enter" to skip to content

Category: Error Handling

Finding Missing Data-Driven Subscriptions after an SSRS Upgrade

Published 2026-03-19 by Kevin Feasel

Sandra Delany has misplaced some subscriptions:

After migrating SSRS from SQL 2016 Enterprise Edition to SSRS SQL 2022 Standard Edition Data-driven subscriptions disappeared from within the SSRS web portal. However, I could see the subscriptions in the ReportServer.dbo.Subscriptions table.

SSRS was migrated from an EC2 instance where SQL and SSRS, etc. was installed by a DBA to an EC2 instance that was built using a template where all components were installed. When this was originally built out, we asked that they test. They said they did some testing, but they did not look at subscriptions in the portal nor did they create a subscription.

Click through to see how Sandra was able to troubleshoot and resolve the issue. But then how that led to the next issue, and how Sandra resolved that. And so on. This is what I refer to as an IT shaggy dog story. I don’t mean it in a negative sense for Sandra (or any author) but more along the lines of, “I want to solve problem X, which should take about 5-10 minutes. As I start to solve problem X, I now need to solve problem Y to solve X. But as I start to solve Y, now I need to fix Z. Oh, and then here come problems A, B, and C to make my life a pain. Three days later, I finally got X done.” It seems like the life of your average IT professional is one shaggy dog story after another.

Leave a Comment

Troubleshooting a Vanishing CU Install

Published 2026-03-16 by Kevin Feasel

Sean Gallardy digs into an issue:

Someone asked if I’ve ever had a CU install where you run it and it goes through the extraction process, then right as it hits 100% just exists and nothing happens. Well, that’s pretty weird, and no, I hadn’t. I was, however, intrigued! Since I love my readers, I made a repro of what the person this was occurring to, saw.

Click through for the expectations and what it actually turned out to be.

Leave a Comment

Eventstream Not Sending Data to KQL Database after Resuming Fabric Capacity

Published 2026-03-11 by Kevin Feasel

Olivier Van Steenlandt troubleshoots an issue:

To continue the development of my mobile app, whose core ability is to scan barcodes of consumable articles and send them over for analytics, I’m resuming my capacity, starting to scan barcodes again, sending them to my Eventstream, and finally saving them in my KQL database.

After a couple of minutes, I wanted to validate all the scanned results in my KQL database and navigate to my scanned_barcode table.

Read on to see how Olivier diagnosed and corrected the problem.

Leave a Comment

Troubleshooting Bad Request in ADF Pipelines

Published 2026-03-09 by Kevin Feasel

Koen Verbeeck said something bad:

A while ago I blogged about a use case where a pipeline fails during debugging with a BadRequest error, even though it validates successfully. If you’re wondering, this is the helpful error message that you get:

Click through for an image of the 400 Bad Request message, how Koen fixed it originally, and then a different scenario in which that 400 message popped up.

Ultimately, a 400 Bad Request comes down to “You sent me information that doesn’t make sense and I can’t fulfill your request, so fix it, dummy.” 400 status codes are very rude and insulting. Especially 418–that thing has a mouth like a sailor’s.

Leave a Comment

SQL Server 2025 Installation on a Disk with Large Sector Size

Published 2026-03-02 by Kevin Feasel

Reitse Eskens runs into a problem:

This warning felt benign; more like you can run into errors. Well, as I found out, this lets you run into an SQL Server installation that just fails.

The error logs fill up with stack dumps and a fatal error that makes no sense. The installation log, however, shows you a more meaningful error.

Click through for the error message, as well as one way to fix the problem.

Leave a Comment

Kerberos Error: It’s Always SPNs

Published 2026-03-02 by Kevin Feasel

Mike Lynn shares a story:

We were setting up a brand-new SQL Server 2022 instance and couldn’t connect remotely using valid Windows credentials. Every attempt gave us the same error: “Login is from an untrusted domain and cannot be used with Windows authentication.” The client only has one domain. Permissions and firewalls checked out. Local connections with domain accounts worked fine. So why was the server rejecting us from every remote machine, no matter how we connected? The answer turned out to be a change in Windows Server 2025 that more and more DBAs are going to run into.

My advice for every DBA is as follows: make sure you have at least a rudimentary understanding of SPNs, including what they are, what can go wrong when they aren’t set correctly, what “set correctly” even means, and how to set them. You don’t need to be an expert on Kerberos, but I think you do need to be a technician who can note a specific error code and troubleshoot the issue from there.

If you ever had to deal with SSRS or SSIS double-hop issues, you’ve likely already dealt with SPNs in some fashion. Just bite the bullet and spend a few hours boning up on the topic.

Leave a Comment

Diagnosing a Driver Error

Published 2026-03-02 by Kevin Feasel

Sean Gallardy troubleshoots an error:

The symptoms of this issue were interesting, every so often the instance would just kind of get “stuck” – at least that is how it was described to me. Nothing would work, cancelling queries, attempting to kill queries, submitting anything new, nothing seemed to really do anything except restarting the service. Once the service was restarted, the instance (and AG) would hum along nicely… until some random time later when submitting different queries would just grind to a halt. Fun.

The answer is just as dumb as you’d think. But I won’t spoil the punch line here.

Leave a Comment

Failure Tracking in SSIS

Published 2026-02-26 by Kevin Feasel

Andy Brownsword keeps a log:

SSIS packages provide great flexibility for integration between systems, but when they go wrong you can end up digging through logs or reports because every package logs differently. A standarised framework for tracking failures can drastically cut down troubleshooting time.

I reminisced recently about old code, I said “it’s not enough to make it work correctly. It needs to fail correctly too”. So in this post we’ll demonstrate a simple way to consistently track errors and failures in packages to help make troubleshooting much easier.

My recollection is that this kind of failure logging is less important if you have the SSISDB catalog, as it collects a lot of the information as well. But then again, I haven’t really used SSIS in a while, so that memory could be fuzzy.

Comments closed

An Edge Case with Row Locks and Joins in PostgreSQL

Published 2026-02-25 by Kevin Feasel

Haki Benita digs into a problem:

Here’s a database riddle: you have two tables with data connected by a foreign key. The foreign key field is set as not null and the constraint is valid and enforced. You execute a query that joins these two tables and you get no results! How is that possible? We thought it wasn’t possible, but a recent incident revealed an edge case we never thought about.

If you answered “READ COMMITTED isolation level is weird,” congratulations: you win a prize.

Comments closed

Modifying an Azure SQL Database with Mirroring to Fabric Enabled

Published 2026-02-12 by Kevin Feasel

Olivier Van Steenlandt runs into an issue:

Over the past few weeks, I have been doing some experimenting with Azure SQL mirroring to Microsoft Fabric. In the process, I ran into a couple of issues and challenges. In this data recipe, I will be going through one of my challenges when I got Azure SQL mirroring to Microsoft Fabric setup and running.

At first, everything seemed to be working as expected, and the integration felt very smooth. At that point, I continued to develop my test database in Azure SQL to learn a bit more about mirroring. I made a couple of minor changes to my test database and tried to publish them from my SQL Database Project.

Read on for the issue, as well as the solution—that is, assuming you don’t actually want to change any of the things you’re actively moving over into Fabric.

Comments closed