If the user's settings seem to be causing display issues, you can delete the settings from the database using the command below. NOTE: SQL scripts should be run by your DBA
The user setup as the Anonymous user in IIS needs to have full permissions to this file. By default this is the IUSR account. On a Windows 2008 system the IIS_IUSRS group has permission to this file but the IUSR account isn't a member of this group by default.
This may be an issue with the way users were imported / created in SBM. Perhaps, this is caused by an upgrade from an old version of TeamTrack. Check the TS_TIMEPREFERENCES column in the TS_ USERS table in the Application Engine database for the user . The only valid values for TS_TIMEPREFERENCES are 0 or 1. If you have any other value in TS_TIMEPREFERENCES, replace it with a 0 or 1.
By altering the following sql to match your database names it will show all the items in the docstore as well as the corresponding file system path. SELECT obj_UID as Item_ID ,obj_Name as Agile_Item_Name ,'root_'+ Cast(doc_RootFolderID as nvarchar(100)) as Doc_Root, Cast(doc_GUID as nvarchar(100)) + doc_FileName as SubFolder, doc_FileName as Original_Filename
The PPM or Agile Admin tool may show you have X number of licenses available but when you try to add a user to a license it may say you don't have any left. The following sql statements can be run against the database to help troubleshoot where the discrepancy may be.
The following example code can be put in the onselectionchange event of a list box. When the value is changed a alert should show the currently selected text value. The underlying value is actually a numeric value that will be stored in the database .
