Show All Projects
This is a tool I made to explain some very unobvious problems I've run into at work. The utility mimics behavior of KTM 4.5 SP1/5.0's relational database dialog and assists in troubleshooting issues documented in SPR 85394 (as well as SPR 85165 and SPR 84870). These issues involve the inconsistency of how KTM checks whether a name evaluates to a valid table or view.

These issues are resolved as of KTM 4.5 SP1 Patch 2 and KTM 5.0 SP1.


Timeline

Files

Screenshots

Examples of table names that would fail for confusing reasons.
  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Project / Id )  0.0122
Total Execution Time  0.0141
  GET DATA  
No GET data exists
  MEMORY USAGE  
905,896 bytes
  POST DATA  
No POST data exists
  URI STRING  
project/id/22/KTM_Oracle_Test
  CLASS/METHOD  
project/id
  DATABASE:  smkprojects (Project:$db)   QUERIES: 5 (0.0039 seconds)  (Hide)
0.0007   SELECT *
FROM `ProjectResources`
WHERE `ProjectID` = '22' 
0.0004   SELECT *
FROM `Projects`
WHERE `ProjectID` = '22' 
0.0004   SELECT *
FROM `ProjectTags`
WHERE `ProjectID` = '22' 
0.0012   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) >
0.0012   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) > 
  HTTP HEADERS  (Show)
  CONFIG VARIABLES  (Show)