January 10, 2010 at 9:06 am
REcently i installed hotfix (GDR 4053 2005 ENU(KB970892) for all services on my sql server.From then i keep on getting errors for my sql agent job starting with
Error 1:
Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.IObjectWithSite'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{FC4801A3-2BA9-11CF-A229-00AA003D7352}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).
Implemented this solution:
1. Open the command prompt
2. Navigate to C:\Program Files\Microsoft SQL Server\90\DTS\Binn
3. Run C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll
Now i am getting another Error:
creating an instance of the com component with clsid for sql job
What actually is hte problem with this hotfix and how to handle this ?
January 11, 2010 at 8:21 am
any suggestions to fix this ?
January 11, 2010 at 8:48 am
any way you could roll back this hotfix ??..see if that fixes your problem.
It is always recommended that any hotfix or CU be thoroughly tested before deploying to any critical environment
HTH....
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 11, 2010 at 9:07 am
How do i rollback just the hotfix which i recently installed without effecting sql server installations or any sql server datbases on that box.
January 11, 2010 at 9:19 am
You can find the updates you installed on your machine in your control panel.
To uninstall this hotfix, follow these steps:
1. Click Start, click Control Panel, and then click Add or Remove programs.
2. In the Add or Remove Programs window, click the Add or Remove Programs icon.
3. To see the rollup that is listed under your Microsoft SQL Server 2005 installation, select the Show Updates check box.
4. You must uninstall the component packages in the order in which they are listed in this article.
here is the KB article for it..http://support.microsoft.com/kb/918222
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 11, 2010 at 9:41 am
When i click on remove from Add/Remove Programms i get this which scares me to go ahead as that may uninstall my sql server
T
he following products can be uninstalled by the HotFix setup. To Proceed select instances to uninstall and select next.
January 11, 2010 at 12:08 pm
Update on this problem;
I can not even connect to Integration services on this servers, i get the error that says
TITLE: Connect to Server
------------------------------
Cannot connect to OBBEAVER.
------------------------------
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Connect to SSIS Service on machine "OBBEAVER" failed:
No such interface supported.
------------------------------
Connect to SSIS Service on machine "OBBEAVER" failed:
No such interface supported.
------------------------------
BUTTONS:
OK
------------------------------
January 11, 2010 at 12:22 pm
Tara-1044200 (1/11/2010)
Update on this problem;I can not even connect to Integration services on this servers, i get the error that says
TITLE: Connect to Server
------------------------------
Cannot connect to OBBEAVER.
------------------------------
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Connect to SSIS Service on machine "OBBEAVER" failed:
No such interface supported.
------------------------------
Connect to SSIS Service on machine "OBBEAVER" failed:
No such interface supported.
------------------------------
BUTTONS:
OK
------------------------------
Your problem seems to have compounded over the time. Are you sure you did not face any such issues before the hotfix?
Also, you can follow the procedure for un-installation of a hotfix as per my previous post. It should not uninstall SQL server as long as you select only the hotfix, by its name and date...
HTH...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 11, 2010 at 12:30 pm
OK here is the soluciton for my recent problem which allowed me to connect to SSI services.
I have to register the dll file as below
regsvr32.exe "\90\DTS\Binn\MsDtsSrvrUtil.dll
But my problem with packages opening with errors still exist after installing Cumulative Update, please let me know if any has solution for it ?
January 11, 2010 at 1:33 pm
I feel that the issues caused after installing cumulative updates is that dll files failed to re-register and so we run into problems.
Assuming this i would like to register all dll's that are related to SSIS as i see problems inthat area. Could some one list me dll's with reference to SSIS.
Question : Will there be a problem if i register all dll files on sql server 2005, hoping that would resolve all my issues ?
July 2, 2014 at 12:12 am
i have install MSSQL SERVER 2008 enterprise edition and SSIS package,
but in SSIS given the error of create new project the error show
"Micosoft visual studio is unable to load this document:
Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageSigning100'. The operation failed because the QueryInterface call on the COM component for the interface with IID'{A896D87C-D1B2-4FAE-9339-CFAFEFE617BE}'failed due to the following error. No such interface supported (Exxeption from HRESULT:0x80004002 (E_NOINTERFACE))."
plz giving me solution of that above error.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply