DB disconnect errors in Portfolio Server access

[gnishant]

I am occassionally seeing some errors in the application log as shown below. Users get a timeout expired message on the page whatever they are accessing.

It either correct itself in next 5-10 minutes, otherwise I have to restart IIS on portfolio server.

Any hints on what can be the issue...

Thanks,
Nishant
=======================
Session['Security.AccountID'] = 1
Session['Security.NAME'] = <username>
Session['SessionID'] = qk0zglub1r1zbgblwo4jejan633670878139120990
Session['Security.UserID'] = 84
Session['AccountID'] = 1
Session['PortfolioID'] = 44
Session['GUI_1_84_2'] = 1
Session['GROUP_BY_1_84_2'] = 0
Session['DISPLAY_ENTITIES_1_84_2'] = 16
Session['FILTER_ID_1_84_2'] = -1
Session['QUICK_SEARCH_1_84_2'] = Flexi
SessionID:qk0zglub1r1zbgblwo4jejan
Form Data: No Form Data Found
1: Error Description:Timeout expired
1: Source:Microsoft OLE DB Provider for SQL Server
1: Stack Trace: at System.Data.OleDb.OleDbDataReader.ProcessResults(O leDbHResult hr)
1: at System.Data.OleDb.OleDbDataReader.NextResult()
1: at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method)
1: at System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
1: at System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandBehavior behavior)
1: at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
1: at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
1: at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
1: at Microsoft.Office.Project.PortfolioServer.DataLayer .Core.DLCache.FillCacheByEntity1Type(String entity1Type, Boolean bClear)
1: at Microsoft.Office.Project.PortfolioServer.BusinessL ayer.BLCache.GetCacheByEntity1Type(String entity1Type, Boolean bClear)
1: at Microsoft.Office.Project.PortfolioServer.BusinessL ayer.MainView.BLUserView.PrepareExpiration()
1: at Microsoft.Office.Project.PortfolioServer.BusinessL ayer.MainView.BLUserView.FillMainViewDataTable()
1: at Microsoft.Office.Project.PortfolioServer.PSWA.Part s.Generic.MainView.BindGrid(Int32 autoExpandToLevel)
1: at Microsoft.Office.Project.PortfolioServer.PSWA.Part s.Generic.MainView.DataInit()
1: at Microsoft.Office.Project.PortfolioServer.PSWA.Part s.Generic.MainView.Page_Load(Object sender, EventArgs e)
1: at System.Web.Util.CalliHelper.EventArgFunctionCaller (IntPtr fp, Object o, Object t, EventArgs e)
1: at System.Web.Util.CalliEventHandlerDelegateProxy.Cal lback(Object sender, EventArgs e)
1: at System.Web.UI.Control.OnLoad(EventArgs e)
1: at System.Web.UI.Control.LoadRecursive()
1: at System.Web.UI.Control.LoadRecursive()
1: at System.Web.UI.Control.LoadRecursive()
1: at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
1: Target Site:Void ProcessResults(System.Data.OleDb.OleDbHResult)


For more information, see Help and Support Center at Events and Errors Message Center: Basic Search.
=================