Odd error message from maintenance plan

Question

Odd error message from maintenance plan

richardmgreen1

SSChampion

Points: 10303
More actions
August 7, 2018 at 8:27 am

#414834

Hi all
We've got a maintenance plan (newly created) that does the following:-
Update statistics
Reorganise indices
Rebuild indices
Backup databases
We're getting a strange error message as follows:-
Executing the query "UPDATE STATISTICS [dbo].[Dim_Date] WITH FULLSCAN..." failed with the following error: "An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
The odd thing about this is that there are no triggers on that table.
Am I looking for the trigger in the wrong palce or am I just completely misreading the error message?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110639 More actions · Answer 1

There are other types of triggers than those that exist on a table. In particular, DDL triggers might be a place to look. I never remember where these appear, and SSMS appears to have at least two places other than a table where Triggers is within an area - one location is in the Server Objects area, and the other is within the Programmability section of a given database, where it says "Database Triggers". I would look there and if nothing, you'll have to Google it.

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

richardmgreen1 SSChampion Points: 10303 More actions · Answer 2

Thanks for that. I found one under Server objects.
It's DDL trigger from the RedGate DLM dashboard that looks like it tracks changes.

I'm going to disable it for now and see if that helps with the statistics.
If it does, I'll let them know.

Thanks for pointing me in the right direction.

sgmunson SSC Guru Points: 110639 More actions · Answer 3

richardmgreen1 - Wednesday, August 8, 2018 3:47 AM
Thanks for that. I found one under Server objects.
It's DDL trigger from the RedGate DLM dashboard that looks like it tracks changes.
I'm going to disable it for now and see if that helps with the statistics.
If it does, I'll let them know.
Thanks for pointing me in the right direction.

You're very welcome... glad I could help out...

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)