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 .
Creating a connection to an existing database gives this error: Could not add database connection.; Could not add database connection.; System.Web.Services.Protocols.SoapException: Could not add database connection.
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 issue is that the accelerator database that ships with AOD does not have the “add new users as a resource” enabled. So when the customer started adding users they were not be added as resources. The affect of this is that you could not assign any users to the stories/tasks.
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.
To fix this run the two sql scripts against the agile database . update PES_DesignerForm set dfm_Layout=REPLACE(Cast(dfm_Layout as nvarchar(max)),'appVersion=2009.03.00.9999','appVersion=2010.01.00.9999') update PES_DesignerForm set dfm_Layout=REPLACE(Cast(dfm_Layout as nvarchar(max)),'help.serena.com/mariner','help.serena.com/alm')
