Wednesday, March 21, 2012

Error creating object SQL 7.0 using sp_oaCreate

Hi,
I am trying to troubleshoot an issue that came up suddenly on a SQL Server 7
that I support.
There is a sp that runs every five minutes and one of the functions in the
sp uses the sp_oaCreate to create and object which returns some free disk
space information. This sp has been working fine for over six years now and
all of a sudden, last w, it started failing. After some debugging, I foun
d
that the following call is failing with the attached error;
exec @.hr = sp_oaCreate 'CqDiskSpace.clsDiskSpace', @.ds OUTPUT
if @.hr <> 0
begin
set @.ErrMsg = 'Could not create CqDiskSpace.clsDiskSpace -- error ' +
cast(@.hr as varchar(15))
goto EH
end
And the error is:
Could not create CqDiskSpace.clsDiskSpace -- error -2147221164.
I've been searching google and other things and found some information on
this forum with a similar error but the odd thing is that it it was working
fine and there was nothing done to the system at that time.
I should mention that I can create the object from outside the stored
procedure with no problems. It is SQL Server 7.0 7.00.961.
Can anyone possibly point me in a direction of what to look for?
Thanks a bunchNever Mind,
Stopping and starting the SQL Server fixed the issue.
I should have started with that.
Thanks
"Ryan Gaudet" wrote:

> Hi,
> I am trying to troubleshoot an issue that came up suddenly on a SQL Server
7
> that I support.
> There is a sp that runs every five minutes and one of the functions in the
> sp uses the sp_oaCreate to create and object which returns some free disk
> space information. This sp has been working fine for over six years now an
d
> all of a sudden, last w, it started failing. After some debugging, I fo
und
> that the following call is failing with the attached error;
> exec @.hr = sp_oaCreate 'CqDiskSpace.clsDiskSpace', @.ds OUTPUT
> if @.hr <> 0
> begin
> set @.ErrMsg = 'Could not create CqDiskSpace.clsDiskSpace -- error ' +
> cast(@.hr as varchar(15))
> goto EH
> end
> And the error is:
> Could not create CqDiskSpace.clsDiskSpace -- error -2147221164.
> I've been searching google and other things and found some information on
> this forum with a similar error but the odd thing is that it it was workin
g
> fine and there was nothing done to the system at that time.
> I should mention that I can create the object from outside the stored
> procedure with no problems. It is SQL Server 7.0 7.00.961.
> Can anyone possibly point me in a direction of what to look for?
> Thanks a bunchsql

No comments:

Post a Comment