DB disconnect errors in Portfolio Server 2007 access

N

Nishant

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(OleDbHResult hr)
1: at System.Data.OleDb.OleDbDataReader.NextResult()
1: at
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method)
1: at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior
behavior)
1: at
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
1: at System.Data.Common.DbDataAdapter.FillInternal(DataSet 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.BusinessLayer.BLCache.GetCacheByEntity1Type(String entity1Type, Boolean bClear)
1: at
Microsoft.Office.Project.PortfolioServer.BusinessLayer.MainView.BLUserView.PrepareExpiration()
1: at
Microsoft.Office.Project.PortfolioServer.BusinessLayer.MainView.BLUserView.FillMainViewDataTable()
1: at
Microsoft.Office.Project.PortfolioServer.PSWA.Parts.Generic.MainView.BindGrid(Int32 autoExpandToLevel)
1: at
Microsoft.Office.Project.PortfolioServer.PSWA.Parts.Generic.MainView.DataInit()
1: at
Microsoft.Office.Project.PortfolioServer.PSWA.Parts.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.Callback(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
http://go.microsoft.com/fwlink/events.asp.
=================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top