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

Error accessing report from anywhere but local server

I am trying to view a report that i created and I get an error everywhere but on the server, where it runs fine. the report uses the sharepoint lists.asmx web service as a datasource, and I'm using Windows Authentication on the datasource. I'm logged on to my desktop with the same account i use on the server, but on the server it runs and on the desktop i get the following error:

"An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'SiteTripList'. (rsErrorExecutingCommand) Get Online Help Failed to execute web request for the specified URL. (rsXmlDataProviderError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors "

After checking the event log I found a System.FormatException being thrown with the message "Input String was not in a correct format."

Any help would be greatly appreciated!!

josh meyer

What does the Properties -> Security look like?
|||I added my account specifically with full permissions. i just remembered that the list web service i'm accessing is actually not on the same server as reporting services. is this related to the "double-hop" issue? is there some workaround?|||Try this, I had problems connecting on my PC also until I ensured that my data source was shared. I thought I had done so when I specified it to be a shared data source when creating it in VS 2005 but I also had to do this:

In Report Manager

1) Click on Properties
2) Click on Data Sources
3) Make your Data Source Shared|||

Hi

It does not allow making it share as it throws error.Also even in my case muy reporting services is on other machine and sharepoint on other machine.Hence unable to get access to datasource(maybe).

Will certainly like to get soln to this problem

Error accessing report from anywhere but local server

I am trying to view a report that i created and I get an error everywhere but on the server, where it runs fine. the report uses the sharepoint lists.asmx web service as a datasource, and I'm using Windows Authentication on the datasource. I'm logged on to my desktop with the same account i use on the server, but on the server it runs and on the desktop i get the following error:

"An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'SiteTripList'. (rsErrorExecutingCommand) Get Online Help Failed to execute web request for the specified URL. (rsXmlDataProviderError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors "

After checking the event log I found a System.FormatException being thrown with the message "Input String was not in a correct format."

Any help would be greatly appreciated!!

josh meyer

What does the Properties -> Security look like?
|||I added my account specifically with full permissions. i just remembered that the list web service i'm accessing is actually not on the same server as reporting services. is this related to the "double-hop" issue? is there some workaround?|||Try this, I had problems connecting on my PC also until I ensured that my data source was shared. I thought I had done so when I specified it to be a shared data source when creating it in VS 2005 but I also had to do this:

In Report Manager

1) Click on Properties
2) Click on Data Sources
3) Make your Data Source Shared|||

Hi

It does not allow making it share as it throws error.Also even in my case muy reporting services is on other machine and sharepoint on other machine.Hence unable to get access to datasource(maybe).

Will certainly like to get soln to this problem

Error accessing report from anywhere but local server

I am trying to view a report that i created and I get an error everywhere but on the server, where it runs fine. the report uses the sharepoint lists.asmx web service as a datasource, and I'm using Windows Authentication on the datasource. I'm logged on to my desktop with the same account i use on the server, but on the server it runs and on the desktop i get the following error:

"An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'SiteTripList'. (rsErrorExecutingCommand) Get Online Help Failed to execute web request for the specified URL. (rsXmlDataProviderError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors "

After checking the event log I found a System.FormatException being thrown with the message "Input String was not in a correct format."

Any help would be greatly appreciated!!

josh meyer

What does the Properties -> Security look like?
|||I added my account specifically with full permissions. i just remembered that the list web service i'm accessing is actually not on the same server as reporting services. is this related to the "double-hop" issue? is there some workaround?|||Try this, I had problems connecting on my PC also until I ensured that my data source was shared. I thought I had done so when I specified it to be a shared data source when creating it in VS 2005 but I also had to do this:

In Report Manager

1) Click on Properties
2) Click on Data Sources
3) Make your Data Source Shared|||

Hi

It does not allow making it share as it throws error.Also even in my case muy reporting services is on other machine and sharepoint on other machine.Hence unable to get access to datasource(maybe).

Will certainly like to get soln to this problem