After creating a query in the diagram, it can be run and results are retrieved. But if the query is edited in any way, it cannot be visualized again. It gives the error:
"Query cannot be modeled. You can execute the query without modeling it or corect the flagged problem to continue".
Steps to replicate:
1. Manually create the query from the diagram view in Query Builder (used a single table from an Oracle database)
2. Create a calculated field using to_char(nvl(...))
SELECT EMPLOYEES.*,
EMPLOYEE_ID,
FIRST_NAME,
LAST_NAME,
TO_CHAR (NVL (EMPLOYEES.PROB_DATE, EMPLOYEES.HIRE_DATE)) AS HIRED
FROM EMPLOYEES EMPLOYEES
3. Run the query... runs fine.
4. Go to the query tab... query displays.
5. Make a change (how ever slight, i.e. add then remove comment, or change FROM table alias) then right click | "visualize query"
It will error out, and will not visualize.
The "flagged problem" is noted as "Object reference not set to an instance of the object" and underlines the whole statement.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center