This discussion is archived
2 Replies Latest reply: Jan 25, 2013 7:45 AM by Splendid Alex RSS

Error when trying to run Advisor

Splendid Alex Newbie
Currently Being Moderated
Hi!

I get the following error when trying to run the Advisor (Application Builder > Application xxx > Utilities > Advisor) over our application:

Unknown type! View: APEX_APPLICATION_PAGE_PROC Column: CONDITION_EXPRESSION1 Value: WHEN_ANY_ITEM_IN_COMMA_DELIMITED_LIST_OF_PAGES_HAS_CHANGED

... this happens every time, even if I uncheck all boxes except one (e.g. "References with substitution syntax").

I'm wondering if there is something wrong with our Apex installation as I can't see any other references to this problem in the forum. We don't seem to be suffering any other problems so I expect it's something small...

Has anyone else ever encountered this and does anyone know of a solution? I would like to use the Advisor for some QA processes as it looks like a handy tool.

Many thanks in advance,

Alex.

Versions:
Apex 4.1.1.00.23
Oracle DB 10.2.0.2
  • 1. Re: Error when trying to run Advisor
    Patrick Wolf Employee ACE
    Currently Being Moderated
    Hi Alex,

    very interesting. Looks like one of your processes uses the WHEN_ANY_ITEM_IN_COMMA_DELIMITED_LIST_OF_PAGES_HAS_CHANGED condition which has been deprecated for a very long time.
    If you execute the following query in your workspace schema, you should find those processes which do use the condition. You might want to check if the reported pages/processes are still used in your application.
    select application_id,
           application_name,
           page_id,
           page_name,
           process_name
      from APEX_APPLICATION_PAGE_PROC
     where CONDITION_EXPRESSION1 = 'WHEN_ANY_ITEM_IN_COMMA_DELIMITED_LIST_OF_PAGES_HAS_CHANGED';
    Regards
    Patrick
    -----------
    My Blog: http://www.inside-oracle-apex.com
    APEX Plug-Ins: http://apex.oracle.com/plugins
    Twitter: http://www.twitter.com/patrickwolf
  • 2. Re: Error when trying to run Advisor
    Splendid Alex Newbie
    Currently Being Moderated
    Thanks Patrick,

    Sorry for the slow reply, I didn't see the notification that someone had replied to my question!

    It was actually the condition_type field that contained the afflicted value.
    I found it with this query:
    select application_id,
    application_name,
    page_id,
    page_name,
    process_name
    from APEX_APPLICATION_PAGE_PROC
    WHERE CONDITION_TYPE = 'WHEN_ANY_ITEM_IN_COMMA_DELIMITED_LIST_OF_PAGES_HAS_CHANGED';

    Not sure why my original error message referred to CONDITION_EXPRESSION1, but removing this condition seems to have fixed it!

    Thanks,

    Alex.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points