Return
-
Title
Clicking on View SQL Text in PI spawn an empty popup -
Description
Select a SQL Statement in SQL PI and then clicked on View SQL Text and then it spawns an empty pop-up increase of downloading .ora file to be used by SQL Optimizer. -
Cause
Defect -
Resolution
WORKAROUND
- Go to Configuration | Definition | Databases | Oracle | NewPI | Performance | Highlights
- Switch to "Function" (from view)
- Search and edit "Call To Get Full Text"
- Replace the script content
- Save change
- Check if View SQL Text works
Users most be logged into Supportlink to view and download an attachment from this Knowledgebase article (below) in Attachments.
STATUS
This issue has been logged as defect FOG-3735 and has been fixed in the 6.3.0.10 and higher releases of the Oracle cartridge.
-
Defect ID
FOG-3735