Activity Manager error when opening

Yesterday a user was unable to open their activity manager.  When they did they got this error:

——————————————–
SqlException
Incorrect syntax near the keyword ‘ORDER’.

Module:Deltek.Vision.Ancestors.BaseClass
Method:QueryDataTable

Call Stack
Deltek.Vision.SysData.SelectBO.GetDataMulti(xml As String) at line number: 82
Deltek.Vision.Ancestors.BaseClass.QueryDataTable(query As String) As VisionDataTable at line number: 575
Deltek.Vision.Ancestors.BaseClass.QueryDataTable(query As String, conn As SqlConnection) As VisionDataTable at line number: 621
System.Data.Common.DbDataAdapter.Fill(dataTable As DataTable) As Int32

————————————–
Not very helpful right?

I figured it had to be something to do with the initial load of the activity manager since they were unable to open at all.

So I ran a sql trace on a sandbox version of the database and after searching and testing the different statements and tables referenced I finally found the offending table that holds the default filter options for the activity manager.

The default options that were stored for this user had a syntax error in the sql (I have no idea how it got in there) so all I had to do was delete those options then Deltek Vision rebuilt them for that user and the activity manager was able to be opened again.  Easy once you’ve figured out where the offending sql lives.

In any case here is the statement:

delete clientsidesettings 
where (Type = ‘ActivityGrid’ and UserName = ” and Page = ‘ActivityManager.aspx’)
Easy!

Comments or questions for Loren?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s