|
Home > Archive > Commerce Server General > December 2004 > CS Web Services - Failed to get the connection string?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
CS Web Services - Failed to get the connection string?
|
|
| Olav Tollefsen 2004-11-23, 5:56 pm |
| How can I troubleshoot this?
Olav
An exception occurred in the 'CatalogWebService' Web service. Exception
details follow:
System.Configuration.ConfigurationException: Exception in configuration
section handler. (c:\inetpub\wwwroot\CatalogWebService\we
b.config line
52) ---> Microsoft.CatalogServer.CatalogInitializationException: Failed to
get the connection string of the product catalog resource for the specified
site. ---> System.Runtime.InteropServices.COMException (0x800A0CC1): Item
cannot be found in the collection corresponding to the requested name or
ordinal.
at ADODB.Fields.get_Item(Object Index)
at ADODB.InternalFields.get_Item(Object index)
at
Microsoft.CatalogServer.Internal.CommonHelpers.GetConnectionString(String
siteName, Int32& numberOfFullTextCatalogsToCreate)
--- End of inner exception stack trace ---
at
Microsoft.CatalogServer.Internal.CommonHelpers.GetConnectionString(String
siteName, Int32& numberOfFullTextCatalogsToCreate)
at
Microsoft.CatalogServer.Configuration.CatalogWebServiceConfig..ctor(String
siteName, DebugMode debugLevel, String authorizationPolicyPath, String
uploadPath, Int32 chunkSize, Int32 timeOutHours, Int64 maxFileSize)
at
Microsoft.CatalogServer.Configuration.CatalogWebServiceSectionHandler.Create(Object
parent, Object context, XmlNode section)
at
System.Web.Configuration.HttpConfigurationRecord. EvaluateRecursive(IConfigurationSectionH
andler
factory, Object config, String[] keys, Int32 iKey, XmlUtil xml)
--- End of inner exception stack trace ---
at System.Web.Configuration.HttpConfigurationRecord.Evaluate(String
configKey, SectionRecord section)
at System.Web.Configuration.HttpConfigurationRecord.GetConfig(String
configKey, Boolean cacheResult)
at System.Web.Configuration.HttpConfigurationRecord.GetConfig(String
configKey, Boolean cacheResult)
at System.Web.HttpContext.GetConfig(String name)
at
Microsoft.CatalogServer.Internal.WebServiceUtility.GetWebServiceConfig()
at
Microsoft.CatalogServer.Internal.WebServiceUtility.GetCatalogExecutionContext()
at
Microsoft.CatalogServer.WebService.CatalogWebService.GetServiceVersion()
For more information, see Help and Support Center at
| |
| Robert Bogue [MVP] 2004-11-23, 8:46 pm |
| It looks like it's having trouble determining what the Commerce Server site
name is -- or it's not finding a product catalog in the site. Is this
something that was working?
"Olav Tollefsen" <x@y.com> wrote in message
news:OWRgA2a0EHA.3976@TK2MSFTNGP09.phx.gbl...
> How can I troubleshoot this?
>
> Olav
>
> An exception occurred in the 'CatalogWebService' Web service. Exception
> details follow:
>
> System.Configuration.ConfigurationException: Exception in configuration
> section handler. (c:\inetpub\wwwroot\CatalogWebService\we
b.config line
> 52) ---> Microsoft.CatalogServer.CatalogInitializationException: Failed to
> get the connection string of the product catalog resource for the
> specified site. ---> System.Runtime.InteropServices.COMException
> (0x800A0CC1): Item cannot be found in the collection corresponding to the
> requested name or ordinal.
> at ADODB.Fields.get_Item(Object Index)
> at ADODB.InternalFields.get_Item(Object index)
> at
> Microsoft.CatalogServer.Internal.CommonHelpers.GetConnectionString(String
> siteName, Int32& numberOfFullTextCatalogsToCreate)
> --- End of inner exception stack trace ---
> at
> Microsoft.CatalogServer.Internal.CommonHelpers.GetConnectionString(String
> siteName, Int32& numberOfFullTextCatalogsToCreate)
> at
> Microsoft.CatalogServer.Configuration.CatalogWebServiceConfig..ctor(String
> siteName, DebugMode debugLevel, String authorizationPolicyPath, String
> uploadPath, Int32 chunkSize, Int32 timeOutHours, Int64 maxFileSize)
> at
> Microsoft.CatalogServer.Configuration.CatalogWebServiceSectionHandler.Create(Object
> parent, Object context, XmlNode section)
> at
> System.Web.Configuration.HttpConfigurationRecord. EvaluateRecursive(IConfigurationSectionH
andler
> factory, Object config, String[] keys, Int32 iKey, XmlUtil xml)
> --- End of inner exception stack trace ---
> at System.Web.Configuration.HttpConfigurationRecord.Evaluate(String
> configKey, SectionRecord section)
> at System.Web.Configuration.HttpConfigurationRecord.GetConfig(String
> configKey, Boolean cacheResult)
> at System.Web.Configuration.HttpConfigurationRecord.GetConfig(String
> configKey, Boolean cacheResult)
> at System.Web.HttpContext.GetConfig(String name)
> at
> Microsoft.CatalogServer.Internal.WebServiceUtility.GetWebServiceConfig()
> at
> Microsoft.CatalogServer.Internal.WebServiceUtility.GetCatalogExecutionContext()
> at
> Microsoft.CatalogServer.WebService.CatalogWebService.GetServiceVersion()
>
> For more information, see Help and Support Center at
>
| |
| Olav Tollefsen 2004-11-25, 2:48 am |
| No, this has never worked. I just installed Commerce Server 2002 + FP1. I
get this event when trying to connect with the FP1 CatalogManager. I use the
site name from the Commerce Server Manager under "Commerce Sites".
Olav
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote in
message news:OnlvrSd0EHA.3832@TK2MSFTNGP10.phx.gbl...
> It looks like it's having trouble determining what the Commerce Server
> site name is -- or it's not finding a product catalog in the site. Is
> this something that was working?
>
> "Olav Tollefsen" <x@y.com> wrote in message
> news:OWRgA2a0EHA.3976@TK2MSFTNGP09.phx.gbl...
>
>
| |
| Robert Bogue [MVP] 2004-11-25, 7:46 am |
| Have you looked at the connection string you're getting back to make sure
that it looks right? Have you looked at the site name to make sure that
it's coming back right?
This error appears to be telling you that there are pieces missing in the
connection string -- maybe the whole connection string.
Rob
"Olav Tollefsen" <x@y.com> wrote in message
news:OECZHcr0EHA.3596@TK2MSFTNGP12.phx.gbl...
> No, this has never worked. I just installed Commerce Server 2002 + FP1. I
> get this event when trying to connect with the FP1 CatalogManager. I use
> the site name from the Commerce Server Manager under "Commerce Sites".
>
> Olav
>
> "Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote in
> message news:OnlvrSd0EHA.3832@TK2MSFTNGP10.phx.gbl...
>
>
| |
| Olav Tollefsen 2004-11-27, 7:46 am |
| What do you mean by "the connection string you're getting back". I get this
event when I try to connect using the CatalogManager application and I don't
see any places where I get a connection string back.
Olav
"Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote in
message news:O4cfPNv0EHA.1652@TK2MSFTNGP11.phx.gbl...
> Have you looked at the connection string you're getting back to make sure
> that it looks right? Have you looked at the site name to make sure that
> it's coming back right?
>
> This error appears to be telling you that there are pieces missing in the
> connection string -- maybe the whole connection string.
>
> Rob
>
> "Olav Tollefsen" <x@y.com> wrote in message
> news:OECZHcr0EHA.3596@TK2MSFTNGP12.phx.gbl...
>
>
| |
| Robert Bogue [MVP] 2004-11-30, 5:49 pm |
| Catalog Manager application? BizDesk?
"Olav Tollefsen" <x@y.com> wrote in message
news:ePOtgmH1EHA.3596@TK2MSFTNGP12.phx.gbl...
> What do you mean by "the connection string you're getting back". I get
> this event when I try to connect using the CatalogManager application and
> I don't see any places where I get a connection string back.
>
> Olav
>
> "Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote in
> message news:O4cfPNv0EHA.1652@TK2MSFTNGP11.phx.gbl...
>
>
| |
| Madhur Joshi 2004-12-03, 8:46 pm |
| Are you able to connect to the WebService directly? i.e.: launch the
webservice from a Internet Explorer window.
Try doing that and running a simple API from the Internet Explorer window
(such as GetWebServiceVersion()).
If that throws the same error as you are getting below, there may be a
problem with the Connection String to the Catalog database.
In this case, you can try removing and recreating the Catalog Resource in
the site (make sure to save your data before you do this).
Hope that helps,
madhur
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
© 2004 Microsoft Corporation. All rights reserved.
--------------------
From: "Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com>
References: <OWRgA2a0EHA.3976@TK2MSFTNGP09.phx.gbl>
<OnlvrSd0EHA.3832@TK2MSFTNGP10.phx.gbl>
<OECZHcr0EHA.3596@TK2MSFTNGP12.phx.gbl>
<O4cfPNv0EHA.1652@TK2MSFTNGP11.phx.gbl>
<ePOtgmH1EHA.3596@TK2MSFTNGP12.phx.gbl>
Subject: Re: CS Web Services - Failed to get the connection string?
Date: Tue, 30 Nov 2004 12:01:52 -0500
Lines: 99
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
Message-ID: <ew6IN5v1EHA.1260@TK2MSFTNGP12.phx.gbl>
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: 57.194.205.68.cfl.rr.com 68.205.194.57
Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:15165
X-Tomcat-NG: microsoft.public.commerceserver.general
Catalog Manager application? BizDesk?
"Olav Tollefsen" <x@y.com> wrote in message
news:ePOtgmH1EHA.3596@TK2MSFTNGP12.phx.gbl...
> What do you mean by "the connection string you're getting back". I get
> this event when I try to connect using the CatalogManager application and
> I don't see any places where I get a connection string back.
>
> Olav
>
> "Robert Bogue [MVP]" <robert[dot]bogue[at]crowechizek[nospam]com> wrote
in
> message news:O4cfPNv0EHA.1652@TK2MSFTNGP11.phx.gbl...
sure[vbcol=seagreen]
the[vbcol=seagreen]
Microsoft.CatalogServer.Internal.CommonHelpers. GetConnectionString(String[vbcol=seagree
n]
Microsoft.CatalogServer.Internal.CommonHelpers. GetConnectionString(String[vbcol=seagree
n]
Microsoft.CatalogServer.Configuration.CatalogWebServiceConfig..ctor(String[vbcol=seagreen]
String[vbcol=seagreen]
Microsoft.CatalogServer.Configuration.CatalogWebServiceSectionHandler.Create
(Object[vbcol=seagreen]
System.Web.Configuration.HttpConfigurationRecord.EvaluateRecursive(IConfigur
ationSectionHandler[vbcol=seagreen]
System.Web.Configuration.HttpConfigurationRecord.GetConfig(String[vbcol=seagreen]
System.Web.Configuration.HttpConfigurationRecord.GetConfig(String[vbcol=seagreen]
Microsoft.CatalogServer.Internal.WebServiceUtility.GetWebServiceConfig()[vbcol=seagreen]
Microsoft.CatalogServer.Internal.WebServiceUtility.GetCatalogExecutionContex
t()[vbcol=seagreen]
Microsoft.CatalogServer.WebService.CatalogWebService.GetServiceVersion()[vbcol=seagreen]
>
>
|
|
|
|
|