Commerce Server Webservice Exception [英] Commerce server Webservice Exception

问题描述

我在使用页面时遇到了打击错误。我在我的服务器上有一个商业服务器2007和Sharepoint 2007，我创建了一个Commerce服务器Shspoint站点模板站点，并部署了一些使用Commerce服务器Web服务的webpart。

I am getting the blow error while using the page. I have a commerce server 2007 and Sharepoint 2007 on my server, I have created a Commerce server Shspoint site template site, and deployed some webparts which uses Commerce server web services.

 

当我访问该页面时，我收到以下错误。我的商务服务器和共享点位于同一台计算机上，而SQL服务器位于另一台计算机上。

While i access the page, i get the below error. My commerce server and share point is on the same machine, and SQL server is on another machine.

 

' CatalogWebService的Web服务。异常详细信息如下：System.Threading.ThreadAbortException：线程正在中止。在SNIReadSync（SNI_Conn *，SNI_Packet **，Int32）处于系统的System.Data.SqlClient.TdsParserStateObject.ReadSni（DbAsyncResult asyncResult，TdsParserStateObject stateObj）的SNINativeMethodWrapper.SNIReadSync（SafeHandle pConn，
IntPtr&数据包，Int32超时） System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket（）在系System.Data.SqlClient.TdsParser.ReadSqlValue中的.Data.SqlClient.TdsParser.ReadSqlValueInternal（SqlBuffer值，字节tdsType，Int32 typeId，Int32长度，TdsParserStateObject stateObj）（SqlBuffer
值，SqlMetaDataPriv md，Int32 length，TdsParserStateObject stateObj ）System.Data.SqlClient.SqlDataReader.ReadColumn（Int32 i，Boolean setTimeout）中System.Data.SqlClient.SqlDataReaderColumnData（。 Data.SqlClient。 SqlDataReader.GetValues（Object [] values）在System.Data.ProviderBase.SchemaMapping.LetadDataRow（）的System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues（Object [] values）处于System.Data.Common.DataAdapter.FillLoadDataRow（ System.Data.Common.DataAdapter上的System.Data.Common.DataAdapter.FillFromReader（DataSet数据集，DataTable数据表，String srcTable，DataReaderContainer dataReader，Int32 startRecord，Int32 maxRecords，DataColumn parentChapterColumn，Object parentChapterValue）中的SchemaMapping
mapping） System.Data.Common.DbDataAdapter.FillInternal（DataSet数据集，DataTable []数据表，Int32 startRecord，Int32 maxRecords，String srcTable，填充（DataSet
dataSet，String srcTable，IDataReader dataReader，Int32 startRecord，Int32 maxRecords）， System.Data.Common.DbDataAdapter.Fill中的IDbCommand命令，CommandBehavior
行为）（DataSet数据集，Int32 startRecord，Int32 maxRecords，String srcTable，IDbCommand命令，CommandBehavior be在Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset上的System.Data.Common.DbDataAdapter.Fill（DataSet dataSet，String srcTable）（SqlConnection
连接，CommandType commandType，String commandText，CatalogDataSetType catalogDataSetType，SqlParameter [ ] commandParameters，String outParameterName，Object&在Microsoft.CommerceServer.Catalog上的Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset（String
connectionString，CommandType commandType，String commandText，SqlParameter [] commandParameters，CatalogDataSetType catalogDataSetType，String outParameterName，Object& outParameterValue）中的outParameterValue。在Microsoft.CommerceServer.Catalog.Internal.CommonHelpers.Search（CatalogExecutionContext executionContext，$ b $）中的Internal.SqlHelper.ExecuteDataset（String
connectionString，String spName，Object [] parameterValues，CatalogDataSetType catalogDataSetType，String outParameterName，Object& outParameterValue） b StringCollection catalogsToSearchCollection，String sqlClause，String ftsPhrase，String advancedFtsPhrase，String language，CatalogSearchOptions searchOptions，InventoryOptions inventoryOptions，JoinTableInformation joinTableInformation，String categoryClause，
Boolean recursive，Int32& totalRecords，Boolean returnTotalRecords）at Microsoft.Com merceServer.Catalog.Internal.CatalogContext.Search（CatalogExecutionContext catalogExecutionContext，StringCollection catalogsToSearch，String sqlClause，String ftsPhrase，
String advancedFtsPhrase，String language，CatalogSearchOptions searchOptions，InventoryOptions inventoryOptions，JoinTableInformation joinTableInformation，String categoryClause，Boolean recursive，Int32& totalRecords）at Microsoft.CommerceServer.Catalog.Internal.CatalogSearch.Search（Int32&
totalRecords，Boolean returnTotalRecords）at Microsoft.CommerceServer.Catalog.Internal.CatalogServerContextBase.SearchWithCount（CatalogSearchParameters catalogSearchParameters，CatalogSearchOptions searchOptions，InventoryOptions inventoryOptions，JoinTableInformation
joinTableInformation，Int32& totalRecords）

An exception occurred in the 'CatalogWebService' Web service. Exception details follow: System.Threading.ThreadAbortException: Thread was being aborted. at SNIReadSync(SNI_Conn* , SNI_Packet** , Int32 ) at SNINativeMethodWrapper.SNIReadSync(SafeHandle pConn, IntPtr& packet, Int32 timeout) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.ReadByteArray(Byte[] buff, Int32 offset, Int32 len) at System.Data.SqlClient.TdsParserStateObject.ReadInt32() at System.Data.SqlClient.TdsParser.ReadSqlValueInternal(SqlBuffer value, Byte tdsType, Int32 typeId, Int32 length, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ReadColumnData() at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i) at System.Data.SqlClient.SqlDataReader.GetValues(Object[] values) at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values) at System.Data.ProviderBase.SchemaMapping.LoadDataRow() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, CatalogDataSetType catalogDataSetType, SqlParameter[] commandParameters, String outParameterName, Object& outParameterValue) at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters, CatalogDataSetType catalogDataSetType, String outParameterName, Object& outParameterValue) at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues, CatalogDataSetType catalogDataSetType, String outParameterName, Object& outParameterValue) at Microsoft.CommerceServer.Catalog.Internal.CommonHelpers.Search(CatalogExecutionContext executionContext, StringCollection catalogsToSearchCollection, String sqlClause, String ftsPhrase, String advancedFtsPhrase, String language, CatalogSearchOptions searchOptions, InventoryOptions inventoryOptions, JoinTableInformation joinTableInformation, String categoryClause, Boolean recursive, Int32& totalRecords, Boolean returnTotalRecords) at Microsoft.CommerceServer.Catalog.Internal.CatalogContext.Search(CatalogExecutionContext catalogExecutionContext, StringCollection catalogsToSearch, String sqlClause, String ftsPhrase, String advancedFtsPhrase, String language, CatalogSearchOptions searchOptions, InventoryOptions inventoryOptions, JoinTableInformation joinTableInformation, String categoryClause, Boolean recursive, Int32& totalRecords) at Microsoft.CommerceServer.Catalog.Internal.CatalogSearch.Search(Int32& totalRecords, Boolean returnTotalRecords) at Microsoft.CommerceServer.Catalog.Internal.CatalogServerContextBase.SearchWithCount(CatalogSearchParameters catalogSearchParameters, CatalogSearchOptions searchOptions, InventoryOptions inventoryOptions, JoinTableInformation joinTableInformation, Int32& totalRecords)

推荐答案

你的sql server是否可以访问Catalog web服务？

Is your sql server reachable to Catalog web service?

试试这个

打开Commerce Server管理器 - >商务网站 - > 您的站点名称 - >网站资源 - >产品目录

Open Commerce Server Manager -> Commerce Sites ->  Your Site Name -> Site Resources -> Product Catalog

右键单击 并选择产品目录上的属性，然后在属性窗口中选择连接字符串选项卡单击修改。在修改窗口中，检查您的服务器和产品目录以及测试连接。 

Right click and choose Properties on Product Catalog, and in Properties window Connection Strings Tab Click on Modify. In modify window, Check your server and Product Catalog and Test connection. 

这篇关于Commerce Server Webservice Exception的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！