搜索报错，大家帮忙看下

xiangyalan321 2010-07-19 04:07:45

Server Error in '/' Application.
--------------------------------------------------------------------------------

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> DAOException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not respondin

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> DAOException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

declare @AllCount int
declare @pageCount int
declare @indextable table(id int identity(1,1),nid int)
declare @tmptable table(id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int
declare @Actual int
insert into @indextable(nid) select id from view_UsersBuessiness where status <>99
select @AllCount= count(id) from @indextable c

set @pageCount=(@AllCount+5-1)/5

set @PageLowerBound=(1-1)*5
set @PageUpperBound=@PageLowerBound+5
set rowcount @PageUpperBound --确定返回的数量
select @Actual=count(nid) from @indextable t where t.id<=@PageUpperbound and T.id>@PageLowerBound
select us.*, (select modelFileName from model where id=us.modelid) as ModelFileName,
@Actual as Actual,@PageCount as PageCount, @AllCount as
DataCount
from view_UsersBuessiness us ,@indextable t
where us.status <>99 and us.id=t.nid and t.id<=@PageUpperbound and T.id>@PageLowerBound
at App_Code.BusinessObj.UsersSelPageIndexBO.BusinessActionRtnDS(IDataObj dataObj)
at Service.UsersSelPageIndex(UsersDO Users)
--- End of inner exception stack trace ---

Source Error:

Line 15774: [System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://tempuri.org/UsersSelPageIndex", RequestNamespace="http://tempuri.org/", ResponseNamespace="http://tempuri.org/", Use=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
Line 15775: public System.Data.DataSet UsersSelPageIndex(UsersDO Users) {
Line 15776: object[] results = this.Invoke("UsersSelPageIndex", new object[] {
Line 15777: Users});
Line 15778: return ((System.Data.DataSet)(results[0]));

在我本地是没错误的，传到服务器上了有时搜索报这个错

...全文