| |
Results |
|
KM-Dim7: 11929-Information: Unable to determine the User ID who owns database NAME>
|
and pcms_db != '*'; From this list you can then submit commands like: SQL> grant <basedb>_user to <userdb>;
|
|
|
|
TRK INET: When Logging into the Tracker Inet Configuration Page, the list that usually shows the Database Types gives a list of Database Drivers and 'not available' DSN Descriptions.
|
There are subkeys for each of the System Data Sources Names that are created. These will usually be labeled:
|
|
|
|
KM-Dim7: I have deleted my database but when I list the users the user is still there.
|
SQL> drop user <USERNAME> cascade; SQL> delete from users_profile where user_ name = '<USER_ NAME >';
|
|
|
|
How do I get a list of all Agile items that have documents attached as well as the path on the file system in the doc store repository?
|
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
|
|
|
|
How do I get a list of all PPM items that have documents attached as well as the path on the file system in the doc store repository?
|
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 PPM_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
|
|
|
|
How do you know who shared or created a report when you only know the report name? Or how do you know who owns a report?
|
The following sql can be run against the Mariner database and will show a list of who a report is shared with and who shared.
|
|
|
|
Error: Attempt to locate entry in Sysdatabases for database by name failed - no entry found under that name. Make sure that name is entered properly.
|
Query the sysdatabases in the Master database, make sure the project db name is there, and is correct. Query the trkprj in the trkmaster db , make sure this project db name (prjDbName) is exactly same as in sysdatabases. In Control Panel | ODBC, check User DSN (and System DSN if running INET), make sure Tracker SQL Server ODBC driver configuration does not contain any entries for Server and Database.
|
|
|
|
How can I find the name of the report associated with a "Reference Name" and the project it resides in to troubleshoot the Embedded Report Widget?
|
Running the following sql query against the application database will give a list of all reports along with their "Reference Name " and "Report Name " SELECT TS_PROJECTS.TS_NAME AS Project_Name, TS_REPORTS.TS_NAME AS Report_Name, TS_REPORTS.TS_REFERENCENAME AS Reference_Name, TS_PROJECTS.TS_INTERNALNAME AS Internal_Name
|
|
|
|
Error: Oracle returns "Invalid User or Role" -- database name is numerical
|
Error: Oracle returns "Invalid User or Role" -- database name is numerical
|
|
|
|
The specified schema name either does not exist or you do not have permission to use it
|
The specified schema name either does not exist or you do not have permission to use it
|
|
|
