5 Replies Latest reply on Oct 24, 2017 11:46 AM by Kim Mertens

    APEX 5.0.4 Cannot load new page in designer

    Kim Mertens

      Hi all,

       

      Currently we are facing the following issue.

       

      We make a new page in our application ( via wizard => blank page just click next next next ).

      When we try to open this page in the designer the loading icon keeps spinning and the page doesn't load.

      In the background we can see the message "No page or page has no template" ( see screenshot )

      page_not_loading.PNG

      When we switch to component view there is no problem.

       

      In the Chrome Developer Tools we can see the following error:

      Uncaught TypeError: Cannot read property 'themeId' of undefined
          at t (f4000_p4500_all.min.js?v=5.0.4.00.12:1)
          at u (f4000_p4500_all.min.js?v=5.0.4.00.12:1)
          at G._setGridProperties (f4000_p4500_all.min.js?v=5.0.4.00.12:3)
          at b (f4000_p4500_all.min.js?v=5.0.4.00.12:1)
          at H (f4000_p4500_all.min.js?v=5.0.4.00.12:1)
          at Object.setCurrentPageId (f4000_p4500_all.min.js?v=5.0.4.00.12:3)
          at Array.<anonymous> (f4000_p4500_all.min.js?v=5.0.4.00.12:9)
          at j (jquery-2.1.3.min.js?v=5.0.4.00.12:2)
          at Object.fireWith [as resolveWith] (jquery-2.1.3.min.js?v=5.0.4.00.12:2)
          at Object.<anonymous> (jquery-2.1.3.min.js?v=5.0.4.00.12:2)
      

       

      We debugged the issue and did following steps in Google Chrome:

      1. Open the file mentioned in the console
      2. Press the {} icon on the bottom to pretty print the JavaScript-file.
      3. The line on which the error occurs changes to 230 which is the following piece of code
         return ea.themes[ha.themeId]
      4. ha is here undefined which is the reason for the error
      5. Debugging led us to line 3024 in the JavaScript file
        ha = ea.userInterfaces[ra[ia.PAGE][ga].getProperty(ja.USER_INTERFACE).getValue()],
      6. Via breakpoints we managed to see the values of all the variables involved
        ia.PAGE = 5000
        ga = <PAGE_ID>
        ja.USER_INTERFACE = 253
      7. When checking the value of this property ( ra[5000][<PAGE_ID>]._properties[253] ) we saw that this was empty.
      8. In a page where there is no error the value = USER_INTERFACE_ID
        This USER_INTERFACE_ID can be found with the following statement
        select      *
        from        wwv_flow_steps
        where       id = <PAGE_ID>
        and         flow_id = <APPLICATION_ID>;

       

      Anyone managed to resolve this issue?

      Seen this a few times posted already but not with a solution that works for us.

       

      We already tried exporting and importing the application again but this only temporarily solved the issue.

      Info: Our application has 76 pages.

       

       

      Thanks in advance.

       

      Kind regards,

       

      Kim

        • 1. Re: APEX 5.0.4 Cannot load new page in designer
          Patrick Wolf-Oracle

          Hi Kim,

           

          if you export/import the app, how does it solve it temporarily? Can the page be loaded after the export/import and only new pages will have the same issue? If you import your app into a workspace on apex.oracle.com, can you reproduce the issue?

           

          Regards

          Patrick

          • 2. Re: APEX 5.0.4 Cannot load new page in designer
            Kim Mertens

            Hi Patrick,

             

            if you export/import the app, how does it solve it temporarily?

            Last time we had this issue we deleted the page that wasn't loading and then started the export.
            After this we imported the application as a new application ID and we could create new pages and open them in the designer.

             

            Can the page be loaded after the export/import and only new pages will have the same issue?

            I just tried to export / import the application including the "faulty" page and after importing again the page now opens OK.

            When I create a new page ( in the new imported application ) everything seems to work.

             

            We have had this issue before and it seems to reappear after some time ( no idea how many pages were added in the meantime / how long ago it was)

            If you import your app into a workspace on apex.oracle.com, can you reproduce the issue?

            I imported the application into my workspace at apex.oracle.com but the issue is not there anymore.

            Just as with the export / import mentioned above.

             

            Some extra information:

            • We also tried adding multiple new pages in the imported application but it doesn't seem to occur anymore.
            • We aren't using a custom theme, we use the Universal Theme (42) just with our own Style.
            • Another thing that doesn't seem to work on the "faulty" page is the creation of a breadcrumb region ( via Component View, + sign next to "Regions" and choose Breadcrumb )
              This gives following error:
              ORA-01403: no data found
              Error computing item default value for page item P263_DISPLAY_POINT.

             

            Hope this information helps you.

            It's annoying we can't reproduce it after importing again.

             

            Kind regards,

             

            Kim

            • 3. Re: APEX 5.0.4 Cannot load new page in designer
              Patrick Wolf-Oracle

              Hi Kim,

               

              can you mail me (firstname.lastname@oracle.com) the export file and the page# which is effected. Maybe I see something in the export file which could cause that issue.  When you create a new blank page in the original app, does the issue still reproduce?

               

              Regards

              Patrick

              • 4. Re: APEX 5.0.4 Cannot load new page in designer
                Kim Mertens

                Hi Patrick,

                 

                When you create a new blank page in the original app, does the issue still reproduce?

                Yes, the issue also happens on new pages.

                 

                I have sent you an e-mail with the export file and the page information.

                 

                Kind regards,

                 

                Kim

                • 5. Re: APEX 5.0.4 Cannot load new page in designer
                  Kim Mertens

                  Hi Patrick,

                   

                  Did you get any more information about this issue from what you could see in the export file I sent you ?

                   

                  Kind regards,

                   

                  Kim