I ran into an unusual Error in SQL “Msg 15331, Level 11, State 1″ “cannot take the action auto_fix due to duplicate SID”. I had restored a database from another server and decided to update the database owner name to one that had a mismatched SID.
Here is how to find it:
SELECT u.name, u.sid, sp.name, sp.sid
FROM sys.sysusers u
LEFT JOIN sys.server_principals sp
ON u.name = sp.name
WHERE u.sid != sp.sid
So at first I tried to fix it myself by updating that SID and found:
Msg 259, Level 16, State 1, Line 1
Ad hoc updates to system catalogs are not allowed.
The SID for the owner would not repair until I changed the owner of the database to “sa” or myself. (go to db properties, select files, change owner value.) Once this was updated the autofix statement will repair the user: EXEC sp_change_users_login ‘Auto_Fix’, ‘username’
At that point I could set the db owner back to the desired name.
Pirate weekend starts today in Bisbee. I had to upgrade the van to a landship. (While I wait for the funds to build a real landship.) Does adding a mast and some paint count? The text in the back says “Seek Ye First.” I know the font is small but I had a stencil made and it’s not ready in time. The graphic is how I reconcile Godliness with Pirate theme. Go straight to the cross!
I was perusing the MSSQL Agent logs and came across a job that kept printing errors every 20 seconds. It has an id with a long number. How can you find what job this is by name?
Here is what the error looks like: “Request to run job 0x17DF82795C5C224CBF7DC88E8E3C4E12 (from Alert 2618) refused because the job is not currently enabled.”
To find the job I must assume that this mess of numbers is a GUID, and therefore it relates to a name?
select * from dbo.sysjobs
I find a job_id that relates to the problem above by just grabbing the last part of the guid without dashes. Here is the real job_id:
I can also look for when this job might fire again:
select top 100 * from sysjobschedules where job_id like ‘%C88E8E3C4E12%’
The job is disabled and there are no schedules for it. So why is it erroring every 20 seconds? It is an alert:
select * from dbo.sysalerts where id = 2618
Someone created a check for blocking transaction job, and fired it upon Blocking Alert. Then they found out that they didn’t want the thousands of emails so they disabled the job. The alert is enabled, calling a disabled job. Error logs get filled now instead of inboxes. The solution was to disable the alert.
The mortgage is burnt thanks to God’s prompting and providence. (And for pointing to Dave Ramsey) Everyone’s fellowship was a huge blessing and refreshed our spirits. Thanks to everyone who rejoiced with us! Attached is what we played with after everyone ran off. Laser beams and long exposures. You can tell its me by the chin in the profile.
Arizona is one of the few states blessed with Ethiopian Food. Zemam’s in Tucson is best of class! They have high standards of cleanliness in a slightly run-down building. Also the tiny but amazing Babylon market gets the surplus Injera from Zemam’s so we can grab some and make our own meal! Phoenix has a couple that are not impressive, Lallibella is a vegetarian place with more traditional decor. Below is the Ethiopian Alphabet. Seems way too complicated for the amount of words in the language.
We were also blessed with the opportunity to visit Little Ethiopia in Los Angeles. Like Little Tokyo and other cultural minority areas, Little Ethiopia seems to be drying up and moving away. There were basically a handful of stores on one street about a city block long. We got lentils and Injera from each one as a sample. Here are our findings compared to Zemam’s:
Second Hand Smoke permeated the room. Lentils at 9.50 were not edible. Injera was bland.
Injera was way too sour. Lentils at 10.70 were more of a soup, not pleasant.
Tried Kik Wat and split peas. They were watered with potato and had bland Injera. Lentils were 11.00
Injera lacked a sour edge. Dark but not overcooked, possibly better Teff used? The lentils were good, and had spice. Garbanzos were undercooked and the chicken not edible. Doro 12 dollars, Kik 5.00
Injera was better than the others. Undercooked collards and the lentils tasted weak, but acceptable. Chickpeas were too oily. We tried a veggie sampler. The meatballs were scary. Overcharged Dinner prices at Lunch time.