Wednesday, May 18, 2011

SQL Server 2005 Jobs Fail to delete (Microsoft SQL Server, Error: 547)

SO I have been having this really weird issue whereby when I create a maintenance plain in SQL Server 2005 Management studio, it fails to save it finally, hence wont be able to execute the plan. In this case I was trying to create a scheduled backup. And it keeps failing to save, and worse of all, it would not even delete when you try to remove it afterward. I had to ask THE GOOGLE for some help, and it turns out that I am not alone.

After a little bit of searching around,using this phrase from the error log "The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_job_id". The conflict occurred in database "msdb", table "dbo.sysmaintplan_subplans", column 'job_id'.The statement has been terminated. (Microsoft SQL Server, Error: 547)" I was able to find a way to delete the plan, thank to this link: http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/4a973abc-6675-4b5d-8c47-967ffc3679ea/ .

This specific post that solved it is:

Guys, On SQL2005, I had the same problem. Based on the previous Tips, I have cleaned up the Job Activity monitor.

Here is the steps followed.



1) Prefix the name of all the Jobs that you are having trouble deleting with 'DEL'

using Job Activity Monitor

2)

use msdb

go

-- Check whether the next Delete Statment deletes only the jobs you want to delete

select * from sysjobs where name like 'DEL%'

go

3)-- Run the following SQL to delete

delete from sysmaintplan_subplans

where job_id in(

select job_id from sysjobs where name like 'DEL%')

go

4) Go to Job Activity Monitor and Right Click to Delete Jobs



Cheers,

JamesPJ



So there it is!.. In case anyone stumbles across similar error. But I have a feeling I will need to reference this again sometime in the future.

By the way, the error was created because the sa login credential in sql is left with a blank password, hence using that authentication for the maintenance plan throws up the error. I didnt want to put a password on it to resolve the issue because I have an application that used that credential, so I ended up creating the plain with windows authentication.

Friday, March 19, 2010

Sunday, November 15, 2009

My View of the World

I try to be poetic sometimes..though every other poem I've written is about one person that has been in my head and just wouldn't leave!..even though..well that's for another day I guess..

Here is My View of The World!..I hope it make sense:

Perspective defines everything
I may see it narrow
Only because am at one side
Is it really narrow?
Tell that to one with fortune.
Its my view of the world.
And its different from yours.

The world is a beautiful place.
That though could be wrong.
'Cos what you see of her
Another man is blind
What I know for sure
Is what we want we get
Again, is that really true?

I know I want a good life
So does one torn with war
How come I get to taste some
And my brother carries gun
A part of it is human
We could be worse than beast
The bad deeds of a few
Could hold much more to will

In life we learn to love
'Cos live without love is lost
The love you have for him
Will make you show respect
How great the world could be
And peaceful for mankind
If we show the love we preach

What paradox we call money
Same as she to him
These represent the causes
Of evil man do to man
We can't have it good though
With these elements out our way
Life without them is vague!

Kenniy Olorunnimbe
**Sent from my SE X1i**

Wednesday, November 11, 2009

Seriously??no good blog tool on WinMo???

I almost couldn't believe that there is no good blog tool on WinMo!

I took it for granted that there definitely should me a blog tool for windows mobile, something comparable to live writer on the desktop. I have tried a few (3 or 4), moblog and tblogger been the most recent, nothing just works right!

Guess this is another reason I need to leave the WinMo platform. I probably should think about developing that tool I have in mind..hmm..except that am not a developer. I should be developing for android when I get my next phone though (SE X10??)..

I have checked the android apps store for some blog tool, and I saw some reasonable ones, most are platform specific though. I can only imagine that the iphone OS has got a bunch too.

I guess I should just email to blogger for now. :-(

Kenniy Olorunnimbe
**Sent from my SE X1i**

Friday, October 02, 2009

Business Intelligence: Fraud Detection in a Life Insurance Company Using Data Mining..

That (the subject) is the topic of a project I need to write. It looks like a big deal to me, since my knowledge of SQL is very basic, but from all that I have read, it looks like the key to this is SQL Server Analysis Services (SSAS). Within the next one week, I will really put some time into this and make sure I get what I need to do in clear outlines.

I'v got 3 great books I am tearing into for this: Microsoft SQL Server 2008 All In One Reference For Dummies (well, am still a little bit of a dummy in this), Delivering Business Intelligence with SQL Server 2008, and Smart Business Intelligence Solutions with Microsoft SQL Server 2008. Between this great books, I just shouldn't go wrong.

I got the source database and today, I will try and identify the table so I know where the data to use are. That shouldn't be so difficult since I have full access (I think) to the original software developer and the rapport is ok. I will keep the blog posted on my progress.

First Moblog!

Checking out moblog from my phone (Sony Ericsson Xperia X1,WinMo 6.1)...trying to see which does fine between moblog and writer for mobile.. (Next post)..Tblogger apparently doesn't work with blogger or require some more setup, which I don't have the patience for.

Friday, August 14, 2009

Word 2007 not accepting mouse/touchpad inputs, opening a blank document on open and alway closing with a crash

A very quick one..

I had this error earlier in the day, whereby I cant seem to use the mouse/touchpad for anything on Word 2007; it just wouldnt accept any input from the device. What that means it I was only able to use the keyboard for everything I was doing. A blank document also opens when I try to open any word document on my computer and Word crashes when closed.

While I manage to just do the very urgent things I needed to do, it was not exactly easy, and very very annoying. I manage to get a fix to it (thanks to google) just when I got fed-up with the issue. I quite figure its a registry error, was able to pin it down to this key eventually:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word

Deleting that Word data key, by going to the registry (type regedit and enter from the command prompt; with administrative previlege if on Vista/Windows7) and navigating to the above key, right clicking and deleting fixed the issue.

Here is the microsoft article that supports that: http://support.microsoft.com/kb/822005/en-us

My 2cents. Have a great weekend. And I really hope I get to blog more (mean..blogging my problems and fixes alone is enough!).




Monday, September 22, 2008

Corel Draw X4 Startup Crashes?!..a working fix!!

Now, I wont claim I fixed this myself, as I got the fix from http://designer.com/forums/t/8250.aspx?PageIndex=2. but just in cash you were almost frustrated like me with coreldraw X4 crashes, follow the steps below to get it done, and trust me, it works!:

"Hi all,

So, I bit the bullet and installed SQL server 2008 express.  Sure enough, I can no longer run Draw. 


Alex V. and I did some debugging and discovered that a new version
of the MFC dlls are installed (version 1833) with SQL2008.  Although
Draw specifies in it's manifest that it should use version 762, it uses
the newer version instead.


Unfortunately, there seems to be a bug in the newer version of
MFC and Draw crashes whenever a docker is opened which uses Internet
Explorer control in the docker (e.g. the hints docker, concept share,
any internet docker addons (like my table styles addon)).


There doesn't seem to be any symbols for the new MFC dll, so for now, we can't debug into it.


For the time being, you can start Draw by turning off the hints docker (which is defaulted on).


Open up DrawUI.xml (you may want to back up the file) found in
<DRAW INSTALL>\Programs\UIConfig\CorelDRAW\, and find the line


<dockPage guidRef="bc1e2f70-3b58-41cd-8406-aaa550482972" visible="true" selected="true" />


and replace with:


<dockPage guidRef="bc1e2f70-3b58-41cd-8406-aaa550482972" visible="false" />


Similarly, in Photopaint, PPUI.xml in UIConfig\Corel PHOTO-PAINT\, find the line



<dockPage guidRef="1c56c2ec-07c1-46f0-baf7-441a555d595c" visible="true" selected="true" />


And replace with:


<dockPage guidRef="1c56c2ec-07c1-46f0-baf7-441a555d595c" visible="false" />


You'll have to run while holding F8 the first time after doing this to overwrite the old settings.


If you open up conceptshare or the hints docker, Draw/Photopaint will crash.


I'll have a bug logged and hopefully we'll be able to find a real fix for it.


Regards,
Hendrik"

As I said I got it from coreldraw.com/forum, and apparently, it was fixed by a corel employee. As indicated there, it seems to have something to do with SQL2008.