4 Replies Latest reply: Mar 23, 2013 1:50 PM by jb000308 RSS

    Forms to apex issue - upload xml file

    991506
      Hi, guys!

      I have the following problem: when I am uploading my file arquivo_fmb.xml in a migration project, the error "500 internal server error" appears.
      This not happen with all xml files, just some. I already tried to use the oracle's sample xml files (employees_fmb.xml, order_fmb.xml, customers_fmb.xml) in the environment apex 4.2 (xe 11g) and apex.oracle.com. To the file orders_fmb.xml, the error is showed and the file is uploaded to project without components.
      I also tried to use my own converted files, but without success (same error).
      In my form happens in a file with blocks master-detail.

      Any help is welcome. I need this for my final paper.

      Thanks a lot.
        • 1. Re: Forms to apex issue - upload xml file
          scott.wesley
          Can you tell us about your environment?

          APEX Version
          Middle tier - glassfish / OHS / APEX Listener

          If you're using Oracle XE with APEX Listener on your laptop, I suggest you upgrade to 2.0.1 - released March 2013.
          This fixed a few uploading issues.

          Scott
          • 2. Re: Forms to apex issue - upload xml file
            991506
            I just installed the oracle 11g express edition. My environment is the following:

            About

            Product Build:     4.0.2.00.09
            Schema Compatibility:     2010.05.13



            CGI Environment

            APEX_LISTENER_VERSION     
            PLSQL_GATEWAY     WebDb
            GATEWAY_IVERSION     2
            SERVER_SOFTWARE     Oracle Embedded PL/SQL Gateway/11.2.0.2.0
            GATEWAY_INTERFACE     CGI/1.1
            SERVER_PORT     8080
            SERVER_NAME     XDB HTTP Server
            REQUEST_METHOD     GET
            QUERY_STRING     p=4350:9:1762730213216690:::::
            PATH_INFO     /f
            SCRIPT_NAME     /apex
            REMOTE_ADDR     127.0.0.1
            SERVER_PROTOCOL     HTTP/1.1
            REQUEST_PROTOCOL     HTTP
            REMOTE_USER     ANONYMOUS
            HTTP_USER_AGENT     Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.172 Safari/537.22
            HTTP_HOST     127.0.0.1:8080
            HTTP_ACCEPT_ENCODING     gzip,deflate,sdch
            HTTP_ACCEPT_LANGUAGE     pt-BR,pt;q=0.8,en-US;q=0.6,en;q=0.4
            HTTP_ORACLE_ECID     
            WEB_AUTHENT_PREFIX     
            DAD_NAME     apex
            DOC_ACCESS_PATH     docs
            DOCUMENT_TABLE     wwv_flow_file_objects$
            PATH_ALIAS     
            REQUEST_CHARSET     AL32UTF8
            REQUEST_IANA_CHARSET     UTF-8
            SCRIPT_PREFIX     



            Database version

            CORE     11.2.0.2.0     Production
            NLSRTL Version 11.2.0.2.0 - Production
            Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
            PL/SQL Release 11.2.0.2.0 - Production
            TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
            • 3. Re: Forms to apex issue - upload xml file
              991506
              prease, someone?
              • 4. Re: Forms to apex issue - upload xml file
                jb000308
                Same issue here trying to upload sample forms from Oracle developer day tutorial. How can I check for my APEX listener version?