Horkay Blog
The postings on this site are my own and do not represent my Employer's positions, advice or strategies.
Saturday, 31 May 2008

I have a mystery wire in my 77 Volkswagen Bus, Westfalia.

I can't figure out where it goes, and have been unable to identify what it goes to.  It is a positive wire, coming out of an inline fuse, right under the steering wheel, it is black with green and white stripe.

Everything works fine, which confounds me even more !

Any help is appreciated:

 

 


Update - Received a suggestion that this wire looks the one that goes the pump for the sink, tonight I'll trace the sink wiring out and see if it is possible that it leads to that.
Saturday, 31 May 2008 10:09:16 (Central Standard Time, UTC-06:00) | Comments [0] |  VW Bus#
Thursday, 29 May 2008

Recently we had some issues with stored procedures having quoted identifiers set differently.  We wanted to run a query to get a listing of any other procedures having quoted identifiers set on or off.

With some help from people at work we found two queries using the DMV's.

select * from sys.sql_modules
where uses_quoted_identifier <> 1

and

Select name
From
sys.all_objects
where ObjectPropertyEx(Object_ID, 'ExecIsQuotedIdentOn') = 0 and type = 'p'

Thursday, 29 May 2008 11:54:24 (Central Standard Time, UTC-06:00) | Comments [0] | SQL Server#
Friday, 23 May 2008

Started receiving this error on some new installations of SQL Server 2005, sp2 + Cumulative Update 6.

I don't know what the root cause is, but we have many servers running this same configuration without the error, I have no idea why this started happenning.

Database Engine Tuning Wizard: "Failed to initialize MSDB database for
tuning (exit code: -1). (DTAClient)

These objects were missing from the server that was failing, so I scripted them from a server that was working.  Once I created the objects in the MSDB database, Database Tuning Advisor now works.

I wish I new what changed in the server / installs that started this happenning, I've checked the last few recent installs of SQL Server 2005 and notice that it is missing from most of them, both 32 bit and 64 bit installs.  Very odd, makes me nervous that something else was missing from the install or that an error happenned and didn't "bubble" up to the installer. 

I'm going to open a case with Microsoft on monday and see what they say, I need confidence that these installations of the DBMS are complete and without any issue, if the Database Tuning Advisor stored procedures and tables were missed, what about service broker, encryption or many of the other features we haven't touched on yet for these particular installations that we expect to be there installed and ready to use ?

I've created a script files of the objects to create, it is available here, DTA_Objects_SQL.txt (433.76 KB)

Friday, 23 May 2008 14:11:17 (Central Standard Time, UTC-06:00) | Comments [1] | SQL Server#
Saturday, 17 May 2008

Just another Saturday.

EJ Breaks ceiling Fan in living room.

TJ Breaks light switch in ceiling fan in his room.

Dad (me) breaks garage door window.

Sunday will be a day of repairs....

Saturday, 17 May 2008 14:12:43 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#

Wow, was this a pain...the below error was received:


An installaton package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package ‘sqlncli.msi’


The history of the install, is most likely the root cause, this was on a application server, we first installed the SQL Native Client and applied SP2.  Then we had a requirement for SQL Reporting Services, than of course another new requirement, Integration Services and Work Station components.  We were able to bring up the install and select the new components, but then the error above happenned.  I think it all revolved around SP2 being applied first.

Some quick research indicated that a possible solution may be to uninstall the SNAC, SQL Native Client, and re-run the setup, selecting the new components.

How to un-install SNAC that was applied with SP2 ?  Manuall extract it and then find the sqlncli.msi, execute the msi (double click on it) and select un-install.

This worked for us !

Saturday, 17 May 2008 14:08:24 (Central Standard Time, UTC-06:00) | Comments [0] | SQL Server#

While upgrading our CRM SQL Server to sql 2005 (or rather testing the application after the upgrade), we received the error below.


The transaction active in this session has been committed or aborted by another session.

Error: 3971, Severity: 16, State: 1

The server failed to resume the transaction. Desc:3300000008.


This was not really an upgrade, but a move to a new server.

I found several references to this error, mostly dealing with MS DTC and SQL 2000, but this was 2005 and did not involve linked servers, so the error was odd.  It also did not show up in any of our testing for this migration.

The only thing we could think of was that something on the client wasn't working right.  We quickly pointed the QA Web layer, which did not have this error, at the new production server, no error.  This allowed us to quickly determine the Database layer was working good.  We realized that we had not upgraded or rebuilt the web servers, and both the development and QA web servers were fairly new.

We applied mdac 2.8 with no success.

We then applied SNAC, SQL Native Client, and all began working.

MS DTC - http://support.microsoft.com/default.aspx?scid=kb;en-us;329332 

A post on google (Link below), combined with the QA success, is what got us thinking that the issue had something to do with MDAC / the client:

Post on google... 

 

Saturday, 17 May 2008 09:11:21 (Central Standard Time, UTC-06:00) | Comments [0] | SQL Server#
Tuesday, 13 May 2008

Team working an issue with an SSIS package failing on a new installation of SQL Server.

Not sure why, but  basically we had an existing instance on a server.  We had capacity to install a second instance on the server.  We installed and prepared the new instance, all works great.

We have an administrative DTS Package that pumps data to an excel spreadsheet and emails the data.

Could not get the package to run, received the below error.  Note the error in green, this option is set to false, we tried all kinds of items to change it with no luck.


Message
Executed as user: VSQLCRM\SYSTEM. ...ute Package Utility  Version 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  10:27:21 AM  Error: 2008-05-13 10:28:52.79     Code: 0xC0014019     Source: Tracing_SSIS      Description: The connection manager "DestinationConnectionExcel" will not acquire a connection because the package OfflineMode property is TRUE. When the OfflineMode is TRUE, connections cannot be acquired.  End Error  Error: 2008-05-13 10:28:52.79     Code: 0xC00291EC     Source: Drop Baseline Tab Execute SQL Task     Description: Failed to acquire connection "DestinationConnectionExcel". Connection may not be configured correctly or you may not have the right permissions on this connection.  End Error  Warning: 2008-05-13 10:28:52.79     Code: 0x80019002     Source: Populate Baseline Tab      Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of e...  Process Exit Code 0.  The step succeeded.

Only solution was to uninstall Client components and re-install them.

Not sure why this works, but somehow the installation of the 2nd instance, and applying the associated service pack 2 and CU 6 caused this.  It's also possible that the automated push install from Polyserve somehow causes this, though all the Polyserve push is an un-intattended install setup script, so the bug would be with that utility that is run through Polyserve.

Lost 4+ hours worth of work chasing this bug down.

Tuesday, 13 May 2008 14:42:03 (Central Standard Time, UTC-06:00) | Comments [0] | Polyserve |  SSIS#
Friday, 09 May 2008

Finally found the root cause of the leak.

After much trouble, a crack was found in the case of the transmission, that under high pressure was squirting / leaking transmission fluid onto the power steering components.  Since both fluids happen to be red, and hydraulic it was easy to confuse the two.

Car still runs fine, but the crack was caused by something "internal" breaking, so it may not run fine for long. 

I'm going to park and sit on it for a week or two.

Replacement is 2000-2500, but I don't think I can find a used car for that amount, but Windstar's seem to just be frought with issues, so I may ditch it and get a good used car.

Definetly I'll be babying and preparing to sell my other windstar before it does the same thing, from what I understand this seems to be a common problem with 1998-2002 windstar around 100,000+ miles.

Update, I'm ditching the windstar, i don't trust this dog enough to put $2500 into it, "this dog won't hunt no more".

 

Friday, 09 May 2008 08:59:29 (Central Standard Time, UTC-06:00) | Comments [0] |  Windstar#
Wednesday, 07 May 2008

Windows\Installer Files (The Patch Cache).

 

The Windows root directory usually contains a folder, c:\windows\installer; we have noticed over time that this folder can grow to consume a significant amount of space, 2-6 gigabytes of space.  Many of these installer files are “dead” and can be moved, not removed !  Moving them to another partition may free up space.  Be careful as some installtion programs or modifications to existing programs will reference this directory, and if you can not move the files back, you have a very big problem.  Specifically installations of SQL Server 2005 require this directory for adding additional instances or options not selected, and if the files are not found in c:\windows\installer, you can not install or modify the programs.

 

The Patch Cache and Freeing Space

 

 Reference from http://blogs.msdn.com/heaths/archive/2007/01/17/the-patch-cache-and-freeing-space.aspx

When you install a patch using Windows Installer, the .msp file is cached in the %WINDIR%\Installer directory. This accounts for some of the space required by Visual Studio 2005 Service Pack 1.  A single patch is cached only once regardless to how many products the patch applies.

Starting with Windows Installer 3.0, any patches that contain the MSIPatchSequence table cause the Windows Installer service to cache any of the original files being replaced into the baseline cache.  Any files being replaced in the latest minor upgrade by small update patches with this table are also cached. It is this baseline cache that consumes a lot of drive space on the system drive after installing VS 2005 SP1. The baseline cache facilitates patch uninstall by storing the original files so that they can be copied back to the target locations. Files in existing patches do not need to be cached because they are contained within the cached .msp files. For this reason and because Windows Installer will require these patches during repair and future patch scenarios, the .msp files should not be deleted except by uninstalling the patch from each product to which it's applied. The baseline cache also improves performance when using binary deltas.

Baseline caches are created separately for per-user unmanaged installations, and for both per-user managed and per-machine installations. If you enable Windows Explorer to display system files or type dir /a:s under %WINDIR%\Installer you'll find a directory structure like the following:

  • %WINDIR%\Installer
    • $PatchCache$
      • UnManaged
        • {UserSID}
          • {Squished ProductCode}
            • {ProductVersion}
      • Managed
        • {Squished ProductCode}
          • {ProductVersion}

Be careful doing any modifications under %WINDIR%\Installer. Like registry changes, making mistakes here could cause problems that may require the difficult task of rebuiling the Windows Installer cache or even reinstalling Windows.

To free up space, you can remove the baseline cache for Visual Studio 2005 under %WINDIR%\Installer\$PatchCache$\Managed by deleting the directory with the squished GUID representing the ProductCode for whichever Visual Studio 2005 products you have installed. The squished GUID is a transformed ProductCode. Attached you'll find a list of product names, product codes, product languages, product editions, and squished GUIDs for Visual Studio 2005 and the .NET Framework 2.0.

Again, be aware that by removing the baseline cache for a product, future repair, patch install, and patch uninstall scenarios may require your original installation media. If you have the drive space it is recommended that you keep the baseline caches available.

 

Wednesday, 07 May 2008 08:15:36 (Central Standard Time, UTC-06:00) | Comments [0] | General Technology#
Tuesday, 06 May 2008

This windstar is racking up the little issues.

Pull into parking garage at work, smelling that tell-tale odor of hydraulic fluid burning.  I've known that that 1998-2000 Ford Windstar's are known for transmission issues, of i've got that sinking feeling of having to decide on what to do, put $2500 into a car worth $3500 ? or move on to a different vehicle.  Of course it's not just a leak, it's a flood and right over the catalytic converter too !  No driving this thing, too much risk of fire with little ones to tote around.

Overall this car has been good to me, a great buy at $4,000, so i've got my money's worth, but sure would like to get more miles out of her.

I decide it needs a professional diagnosis, so I take her up to Certified Transmission.  Good news, maybe, it's not transmission fluid, but Power steering fluid, shop didn't charge me anything, nice.  Being a transmission shop they can't determine the problem, but they also can't find where it's leaking from, not the pump, maybe the high pressure line or the Steering rack and pinion itself, yikes !

Definetly cheaper than a transmission, but now I'll have to take it to a shop that can hopefully put some dye into the power steering resevoir and figure out where the leak is...hopefully just a hose. 

(If anybody in Kansas City knows where to get this elusive power steering fluid dye, let me know, it maybe an urban legend.  I visited 5 FLAPS (Friendly Local Auto Parts Store), and called several others, none carried it, though they all knew of it).

Now I'll be taking the vehicle to Monte's Safety Line, a friend with the same year windstar had a similiar problem and Monte fixed him up for 380, so maybe I'll get lucky.

UPDATE - 5/9 - WRONG, Monte reviewed and found no issue with the power steering, upon review with me, Monte drove the car up to Certified Transmission and helped diagnose the issue properly.

 

Tuesday, 06 May 2008 13:44:41 (Central Standard Time, UTC-06:00) | Comments [0] |  Windstar#
Monday, 05 May 2008

2000 Ford Windstar, 3.8l v6 - Odd squeal and hesitation and general "bad" noise detected while driving.

I'm not 100% sure if it was the tensioner or idler pulley, but they were cheap enough parts to get and put in. 

If you have the $250-$300 to pay to have it done, go ahead, this was about a two hour job and $75.00 for the two parts.

The idler pulley of course did not have enough clearance between the frame pulley to remove the bolt:, so go:

    • loosen the motor mounts
    • find a 6 foot breaker bar (i used a chain link fence post)
    • Insert breaker bar between fram and engine (solid peice next to water pump)
    • Gently move the engine the 1/8 of an inch and remove pulley with bolt
    • repeat in reverse for re-installation, don't forget to tightent he motor mounts

The tensioner and pulley is sold as a unit.  This is a difficult task, due to the limited space.  3 Bolts.  the one on the bottom is easy, the two on top were quite difficult.  10mm Bolts, top 2 require the smallest ratchet you can find; I have a 1/4" set, so it worked nicely.  The smaller your hands the easier the job will be, I found it easier to get the top two bolts, from the top of the engine for both removal and installation.

Hopefully this solves the problem...

 

Monday, 05 May 2008 08:17:37 (Central Standard Time, UTC-06:00) | Comments [0] |  Windstar#
Friday, 02 May 2008

   Anything put off will surely come back to haunt you.

 

I've been putting off tuning up my 69 VW for a good month, today, you could hear the occasional mis-fire, back-fire and late detonation of a vw needing a valve adjustment and tune-up!

 

ALWAYS adjust the valves in your Volkswagen yourself, it's a personal thing.  Get back there, and get your hands in that engine.

 

Overall the valves were not that far out of adjustment, the points (for those that remember them !), were pitting and the nub of the points that rides on the cam inside the distributor had started to deterioate and was leaving some matter on the cam and cam lobe itself.  Most likely this was the cause, I always carry a spare set of points (along with fuel filter and various other parts), and should have stopped and checked them right when I heard the misfire.

 

I also threw in a set of new plugs, rotor and cap, wires looked ok so I left them in.  The misfire had caused some arcin inside the cap and on the rotor, physically causing some deterioation of where the rotor contacts the metal stub inside the cap leading to the plug wires.

 

She runs great now, fweeemmmm....

 

This has not been my week for vehicles, i've had issues with all three of them !

We'll see if the guy at FLAPS knows what points are this time...

Friday, 02 May 2008 08:28:27 (Central Standard Time, UTC-06:00) | Comments [0] | #
Thursday, 01 May 2008

SQL Server install fails with the following error:


Error: Action "LaunchPatchedBootstrapAction" threw an exception during execution.  Error information reported during run:
"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 1612
Aborting queue processing as nested installer has completed
Message pump returning: 1612


Digging deeper in the logs we find:


Installing: msxml6 on target: BCPLYSQL01
Error: MsiOpenDatabase failed with 6e
Failed to install package
The installation source for this product is not available.  Verify that the source exists and that you can access it.
Error: MsiOpenDatabase failed with 6e for MSI {A8803AB4-1B37-4B0C-9BC4-95257CCDA8F5}
Setting package return code to: 64c
Complete: InstallSqlAction.9 at: 7d8/4/1 b:9:2b, returned false


This was caused by moving files from the windows installer cache, c:\windows\installer.  We occasionally run low on disk space and have to move files off the os.

Moving the files back to the windows installer cache solved the problem.

For information on the Installer Cache, see: Recovering Space on a windows Server.

Thursday, 01 May 2008 11:38:13 (Central Standard Time, UTC-06:00) | Comments [0] | SQL Server#

77 Volkswagen westfalia camper.  Automatic, fuel injected. 

Experienced extremely heavy winds in the Kansas City area all day, difficult to drive even 60 mph in the bus, and even when you can it is so squirelly from the winds one must slow down to maintain control.

3 Blocks from the house, she cuts out, whoo, near a gas station, i try to coast her in, but that final bump over the hump turning in is too much.  No way to push her up, to much of a hump, I roll her backwards to an apartment complex.

Quick assesment yields no easy observation of the issue.  I squirt some starting fluid in the s-boot leading to the intake manifold and she fires right up and dies, i detect no humming sound of a running fuel pump.

Crawl underneath, sure enough fuel pump is not running.  Wires all look good, but it is too hot to touch for more than 10-15 seconds.  Check out all electrical connections, looks good, try to start again, nothing.

Preparing to walk home and get tow rope and friends, but wait a bit.

After about 20 minutes, I try to start her again, and she comes right to life, no waiting or hesitation i get the 3 blocks home and park.

She probably needs a new fuel pump anyway, by the looks of it, this is the original pump.  May also be a blocked or clogged fuel filter causing the pump to work too hard.  Based on the fact that a new pump is $100-175, I may try the fuel filter first...

Thursday, 01 May 2008 08:25:50 (Central Standard Time, UTC-06:00) | Comments [0] |  VW Bus#
Search
Popular Posts
Unpatched Vulnerabiltiy discovered ...
Spring Fornicator brewed...
DTA - Failed to initialize MSDB dat...
SQL Server Security, not where it n...
Check the Uptime of a Windows Serve...
Recent Posts
Archive
May, 2017 (2)
April, 2017 (1)
March, 2017 (1)
February, 2017 (1)
December, 2016 (2)
October, 2016 (2)
September, 2016 (1)
August, 2016 (1)
July, 2016 (1)
March, 2016 (2)
February, 2016 (3)
December, 2015 (4)
November, 2015 (6)
September, 2015 (1)
August, 2015 (2)
July, 2015 (1)
March, 2015 (2)
January, 2015 (1)
December, 2014 (3)
November, 2014 (1)
July, 2014 (2)
June, 2014 (2)
May, 2014 (3)
April, 2014 (3)
March, 2014 (1)
December, 2013 (1)
October, 2013 (1)
August, 2013 (1)
July, 2013 (1)
June, 2013 (2)
May, 2013 (1)
March, 2013 (3)
February, 2013 (3)
January, 2013 (1)
December, 2012 (3)
November, 2012 (1)
October, 2012 (1)
September, 2012 (1)
August, 2012 (1)
July, 2012 (4)
June, 2012 (3)
April, 2012 (1)
March, 2012 (3)
February, 2012 (3)
January, 2012 (4)
December, 2011 (3)
October, 2011 (2)
September, 2011 (2)
August, 2011 (8)
July, 2011 (4)
June, 2011 (3)
May, 2011 (3)
April, 2011 (1)
March, 2011 (2)
February, 2011 (3)
January, 2011 (1)
September, 2010 (1)
August, 2010 (2)
May, 2010 (2)
April, 2010 (3)
March, 2010 (1)
February, 2010 (4)
January, 2010 (1)
December, 2009 (3)
November, 2009 (2)
October, 2009 (2)
September, 2009 (5)
August, 2009 (4)
July, 2009 (8)
June, 2009 (2)
May, 2009 (3)
April, 2009 (9)
March, 2009 (6)
February, 2009 (3)
January, 2009 (8)
December, 2008 (8)
November, 2008 (4)
October, 2008 (14)
September, 2008 (10)
August, 2008 (7)
July, 2008 (7)
June, 2008 (11)
May, 2008 (14)
April, 2008 (12)
March, 2008 (17)
February, 2008 (10)
January, 2008 (13)
December, 2007 (7)
November, 2007 (8)
Links
Categories
Admin Login
Sign In
Blogroll