This discussion is archived
4 Replies Latest reply: Mar 23, 2013 11:50 AM by jb000308 RSS

Forms to apex issue - upload xml file

991506 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    prease, someone?
  • 4. Re: Forms to apex issue - upload xml file
    jb000308 Newbie
    Currently Being Moderated
    Same issue here trying to upload sample forms from Oracle developer day tutorial. How can I check for my APEX listener version?

Legend

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