none
Forums Web-Service: WebService broken! in method "GetForum(Guid forumId)" RRS feed

  • Question

  • Hi!

    The forums web-service is broken starting from yesterday. It seems that you have changed the internal database design and now the method "GetForum(Guid id)" always throws an exception that the Columns "CategoryGroupId" and "CategoryGroupName" are not available.

    Here is the reported callstack from the server-side (your side) of the exception:

    {An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
    
    System.Data.SqlClient.SqlException: Invalid column name 'CategoryGroupId'.
    
    Invalid column name 'CategoryGroupName'.
    
     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    
     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
    
     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    
     at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
    
     at System.Data.SqlClient.SqlDataReader.get_MetaData()
    
     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
    
     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    
     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
    
     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    
     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
    
     at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
    
     at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
    
     at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
    
     at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
    
     at Microsoft.Com.Forums.Data.ForumsMainDataContext.GetCategories(Guid forumId)
    
     at Microsoft.Com.Forums.Data.Provider.Linq.LinqDiscussionGroupProvider.GetCategories(Guid discussionGroupId)
    
     at Microsoft.Com.Forums.Data.Provider.Caching.CachedDiscussionGroupProvider.GetCategories(Guid discussionGroupId)
    
     at Microsoft.Com.Forums.Data.DiscussionGroupRepository.GetCategories(Guid discussionGroupId)
    
     at Microsoft.Com.Forums.Service.Providers.ForumsProvider.PopulateForumResult(DiscussionGroup dg, ForumFacts facts)
    
     at Microsoft.Com.Forums.Service.Providers.ForumsProvider.CommonGetForum[T](Guid forumId, String methodName)
    
     at Microsoft.Com.Forums.Service.Providers.ForumsProvider.GetForum[T](Guid forumId)
    
     at Microsoft.Com.Forums.Service.ForumsService.GetForum(Guid forumId)
    
     at SyncInvokeGetForum(Object , Object[] , Object[] )
    
     at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
    
     at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
    
     at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
    
     at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
    
     at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)}

      

    Client-Side-Exception:   
       

     Exception:
    
     Type System.ServiceModel.FaultException`1[[System.ServiceModel.ExceptionDetail, System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]
    
     Source: mscorlib
    
     Message: Invalid column name 'CategoryGroupId'.
    
     Invalid column name 'CategoryGroupName'.
    
     Stack-Trace:
    
     
    
     Server stack trace: 
    
      at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)
    
      at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
    
      at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
    
      at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)
    
      at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
    
      at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
    
     
    
     Exception rethrown at [0]: 
    
      at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
    
      at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
    
      at CommunityForumsNNTPServer.WebServiceDataSource.Forums.IForumsService.GetForum(Guid id)

    Jochen Kalmbach (MVP VC++)
    Saturday, July 10, 2010 8:53 AM

Answers