1 Reply Latest reply: Jan 18, 2012 2:25 PM by Udo RSS

    Different Behavior Webserver- Application Server  Bug ?

    user481488
      Hi

      I have an Upload Form to upload xls File as described in Blog of Dimitri [APEX Listener EA2 with native Excel Upload|http://dgielis.blogspot.com/2010/02/apex-listener-ea2-with-native-excel.html]

      It works !

      Added a validation Rule for the File Name. Even when I select a File Name a get an error "File Name must have some value"

      Running same Page over the Webserver Validation is ok, it's clear I get no Collection ..


      See difference between Debug Message App Server and Web Server


      Have I forgotten something or is this a Bug?

      Regards Patrick

      APP SERVER
      ========

      0.04701     0.00074     A C C E P T: Request="XLS2COLLECTION"     4     
      1
           0.04773     0.00160     Metadata: Fetch application definition and shortcuts     4     
      3
           0.04933     0.00086     Reset NLS settings     4     
      2
           0.05020     0.00076     alter session set nls_language="AMERICAN"     4     
      1
           0.05095     0.00077     alter session set nls_territory="AMERICA"     4     
      1
           0.05171     0.00062     ...NLS: Set Decimal separator="."     4     
      1
           0.05233     0.00072     ...NLS: Set NLS Group separator=","     4     
      1
           0.05305     0.00069     ...NLS: Set g_nls_date_format="DD-MON-RR"     4     
      1
           0.05374     0.00075     ...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"     4     
      1
           0.05449     0.00084     ...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"     4     
      1
           0.05531     0.00172     ...Setting session time_zone to +01:00     4     
      3
           0.05703     0.00155     NLS: wwv_flow.g_flow_language_derived_from=0: wwv_flow.g_browser_language=en     4     
      3
           0.05858     0.00139     Authentication check: Application Express Authentication (NATIVE_APEX_ACCOUNTS)     4     
      2
           0.05997     0.00071     ... sentry+verification success     4     
      1
           0.06068     0.00060     ...Session ID 2229629705141587 can be used     4     
      1
           0.06128     0.00057     ...Check session 2229629705141587 owner     4     
      1
           0.06184     0.00108     ...Check for session expiration:     4     
      2
           0.06292     0.00050     ...Metadata: Fetch Page, Computation, Process, and Branch     4     
      1
           0.06342     0.00057     Session: Fetch session header information     4     
      1
           0.06399     0.00190     ...metadata, fetch page info     4     
      3
           0.06590     0.00062     ...Validate item page affinity.     4     
      1
           0.06651     0.00041     ...Validate hidden_protected items.     4     
      1
           0.06692     0.00046     ...Check authorization security schemes     4     
      1
           0.06738     0.00072     Session State: Save form items and p_arg_values     4     
      1
           0.06810     0.00080     ...Session State: Save "P3_FILE_NAME" - saving same value: ""     4     
      1
           0.06890     0.00062     ...Session State: Save "P3_FIRST_ROW" - saving same value: ""     4     
      1
           0.06952     0.00052     Processes - point: ON_SUBMIT_BEFORE_COMPUTATION     4     
      1
           0.07004     0.00046     Branch point: Before Computation     4     
      1
           0.07050     0.00044     Computation point: After Submit     4     
      1
           0.07093     0.00067     Tabs: Perform Branching for Tab Requests     4     
      1
           0.07160     0.00056     Branch point: Before Validation     4     
      1
           0.07215     0.00098     Validations:     4     
      2
           0.07313     0.00181     Perform basic and predefined validations:     4     
      3
           0.07494     0.00064     Perform custom validations:     4     
      1
           0.07558     0.00061     ...Validation "P3_FILE_NAME" - Type: ITEM_NOT_NULL     4     
      1
           0.07619     0.00071     ......Did NOT pass     4     
      1
           0.07689     0.00077     Add error onto error stack     4     
      1
           0.07766     0.00074     ...Error data:     4     
      1
           0.07840     0.00078     ......message: #LABEL# must have some value.     4     
      1
           0.07918     0.00076     ......display_location: INLINE_WITH_FIELD_AND_NOTIFICATION     4     
      1
           0.07994     0.00074     ......association_type: PAGE_ITEM     4     
      1
           0.08067     0.00074     ......page_item_name: P3_FILE_NAME     4     
      1
           0.08141     0.00078     ......is_internal_error: false     4     
      1
           0.08218     0.00079     ......error_backtrace: ----- PL/SQL Call Stack ----- object line object handle number name 0xac914d98 676 package body APEX_040100.WWV_FLOW_ERROR 0xac914d98 785 package body APEX_040100.WWV_FLOW_ERROR 0xb76169f8 153 package body APEX_040100.WWV_FLOW_VALIDATION 0xb76169f8 199 package body APEX_040100.WWV_FLOW_VALIDATION 0xb76169f8 777 package body APEX_040100.WWV_FLOW_VALIDATION 0xb76169f8 898 package body APEX_040100.WWV_FLOW_VALIDATION 0xc1413d70 9869 package body APEX_040100.WWV_FLOW 0xb75e2bc8 2 anonymous block      4     
      1
           0.08298     0.00078     ......component.type: APEX_APPLICATION_PAGE_VAL     4     
      1
           0.08376     0.00073     ......component.id: 16864826705396663     4     
      1
           0.08449     0.00062     ......component.name: P3_FILE_NAME     4     
      1
           0.08511     0.00054     ...Inline validation error count = 1     4     
      1
           0.08565     0.00056     Show current page with inline errors     4     
      1
           0.08620     0.00058     S H O W: application="102" page="3" workspace="" request="" session="2229629705141587"     4     
      1
           0.08678     0.00106     Application 102, Authentication: PLUGIN, Page Template: 4455760508556498     4     
      2
           0.08784     0.00118     Authentication check: Application Express Authentication (NATIVE_APEX_ACCOUNTS)     4     
      2
           0.08902     0.00063     ... sentry+verification success     4     
      1
           0.08964     0.00051     ...Session ID 2229629705141587 can be used     4     
      1
           0.09015     0.00088     ...Application session: 2229629705141587, user=ADMIN     4     
      2
           0.09103     0.00179     ...Check for session expiration:     4     
      3
           0.09283     0.04835     Branch point: Before Header     4     
      86
           0.14119     0.00165     Fetch application meta data     4     
      3
           0.14283     0.00071     ...metadata, fetch computations     4     
      1
           0.14354     0.00084     ...metadata, fetch buttons     4     
      2
           0.14438     0.00059     ...http header processing     4     
      1
           0.14497     0.00091     ...set mime type: text/html     4     
      2
           0.14588     0.00068     ...set additional http headers     4     
      1
           0.14657     0.00067     Computation point: Before Header     4     
      1
           0.14723     0.00060     Processes - point: BEFORE_HEADER     4     
      1
           0.14783     0.00059     ...close http header     4     
      1
           0.14847     0.00087     ...metadata, fetch item type settings     4     
      2
           0.14929     0.00270     ...metadata, fetch items     4     
      5
           0.15200     0.00285     ...Recompute field lables for fields in error and adjust notification.     4     
      5
           0.15484     0.00258     Show page template header     4     
      5
           0.15742     0.00063     Computation point: After Header     4     
      1
           0.15804     0.00253     Processes - point: AFTER_HEADER     4     
      5
           0.16057     0.00331     Region: Data Load Process Train     4     
      6
           0.16388     0.00053     Computation point: Before Box Body     4     
      1
           0.16441     0.00067     Processes - point: BEFORE_BOX_BODY     4     
      1
           0.16508     0.00283     Region: Data Load Source     4     
      5
           0.16791     0.00133     Item: P3_FILE_NAME NATIVE_FILE     4     
      2
           0.16924     0.00197     Item: P3_FIRST_ROW NATIVE_CHECKBOX     4     
      4
           0.17121     0.02112     ...Execute Statement: select decode(lov_template,null,lov_disp_value,replace(lov_template,'#DISPLAY_VALUE#',lov_disp_value)) lov_disp_value, lov_return_value from wwv_flow_list_of_values_data_v where lov_id = 9731737716778982 and (required_patch is null or (required_patch > 0 and (wwv_flow_item.fetch_g_build_options_excluded is null or instr(wwv_flow_item.fetch_g_build_options_excluded,':'||required_patch||':') = 0) ) or (required_patch < 0 and (wwv_flow_item.fetch_g_build_options_included is null or instr(wwv_flow_item.fetch_g_build_options_included,':'||(0-required_patch)||':') = 0) ) ) and exists (select 1 from wwv_flow_lists_of_values$_v where id = 9731737716778982) order by lov_disp_sequence, LOV_DISP_VALUE     4     
      38
           0.19233     0.00061     Computation point: After Box Body     4     
      1
           0.19294     0.00065     Processes - point: AFTER_BOX_BODY     4     
      1
           0.19359     0.00057     Computation point: Before Footer     4     
      1
           0.19416     0.05606     Processes - point: BEFORE_FOOTER     4     
      100
           0.25023     0.00203     Show page tempate footer     4     
      4
           0.25225     0.00059     Computation point: After Footer     4     
      1
           0.25283     0.00098     Processes - point: AFTER_FOOTER     4     
      2
           0.25381     0.00051     v$sesstat.statistic# = 436: execute count=2     4     
      1
           0.25432     0.00128     Final commit     4     
      2
           0.25560     0.00058     End Page Rendering     4     
      1
           0.25618     0.00072     Stop APEX Engine detected     4     
      1
           0.25693     0.00108     Final commit     4     
      2
           0.25798     -     End Page Processing


      WEB SERVER
      =========

           0.03894     0.00109     A C C E P T: Request="XLS2COLLECTION"     4     
      6
           0.04000     0.00199     Metadata: Fetch application definition and shortcuts     4     
      11
           0.04201     0.00078     Reset NLS settings     4     
      4
           0.04278     0.00061     alter session set nls_language="AMERICAN"     4     
      3
           0.04337     0.00069     alter session set nls_territory="AMERICA"     4     
      4
           0.04406     0.00054     ...NLS: Set Decimal separator="."     4     
      3
           0.04460     0.00070     ...NLS: Set NLS Group separator=","     4     
      4
           0.04529     0.00087     ...NLS: Set g_nls_date_format="DD-MON-RR"     4     
      5
           0.04616     0.00063     ...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"     4     
      4
           0.04679     0.00067     ...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"     4     
      4
           0.04746     0.00047     ...Setting session time_zone to +01:00     4     
      3
           0.04793     0.00166     NLS: wwv_flow.g_flow_language_derived_from=0: wwv_flow.g_browser_language=en     4     
      9
           0.04960     0.00070     ...fetch session state from database     4     
      4
           0.05029     0.00064     fetch items     4     
      4
           0.05093     0.00066     ...fetched 4 session state items     4     
      4
           0.05159     0.00118     Authentication check: Application Express Authentication (NATIVE_APEX_ACCOUNTS)     4     
      7
           0.05277     0.00063     ... sentry+verification success     4     
      4
           0.05339     0.00050     ...Session ID 3169981653484483 can be used     4     
      3
           0.05390     0.00045     ...Check session 3169981653484483 owner     4     
      3
           0.05434     0.00110     ...Check for session expiration:     4     
      6
           0.05544     0.00044     ...Metadata: Fetch Page, Computation, Process, and Branch     4     
      3
           0.05588     0.00058     Session: Fetch session header information     4     
      3
           0.05646     0.00205     ...metadata, fetch page info     4     
      12
           0.05852     0.00061     ...Validate item page affinity.     4     
      3
           0.05913     0.00040     ...Validate hidden_protected items.     4     
      2
           0.05952     0.00050     ...Check authorization security schemes     4     
      3
           0.06002     0.00116     Session State: Save form items and p_arg_values     4     
      7
           0.06118     0.00081     ...Session State: Saved Item "P3_FILE_NAME" New Value="F1623012264/upload.xls"     4     
      5
           0.06199     0.00118     ...Session State: Save "P3_FIRST_ROW" - saving same value: ""     4     
      7
           0.06317     0.00059     Processes - point: ON_SUBMIT_BEFORE_COMPUTATION     4     
      3
           0.06376     0.00046     Branch point: Before Computation     4     
      3
           0.06422     0.00040     Computation point: After Submit     4     
      2
           0.06461     0.00066     Tabs: Perform Branching for Tab Requests     4     
      4
           0.06527     0.00061     Branch point: Before Validation     4     
      3
           0.06589     0.00087     Validations:     4     
      5
           0.06677     0.00197     Perform basic and predefined validations:     4     
      11
           0.06873     0.00066     Perform custom validations:     4     
      4
           0.06939     0.00057     ...Validation "P3_FILE_NAME" - Type: ITEM_NOT_NULL     4     
      3
           0.06995     0.01762     Branch point: Before Processing     4     
      100
           0.08758     0.00057     Processes - point: AFTER_SUBMIT     4     
      3
           0.08814     0.00053     Branch point: After Processing     4     
      3
           0.08867     0.00102     ...Evaluating Branch: AFTER_PROCESSING type: "REDIRECT_URL" button: (No Button Pressed) branch: (Unconditional)      4     
      6
           0.08969     0.00074     Stop APEX Engine detected     4     
      4
           0.09043     0.00058     Stop APEX Engine detected     4     
      3
           0.09107     0.00145     Final commit     4     
      8
           0.09245     -     End Page Processing     4     -
        • 1. Re: Different Behavior Webserver- Application Server  Bug ?
          Udo
          Hi Patrick,

          from what we can see in the APEX debug output you've posted, the validation fails when using APEX Listener, because the file name doesn't seem to be transmitted.
          Could you provide some additional information on your setup? APEX version seems to be 4.1 from what I can see in your log, but which APEX Listener version do you use on which JEE Container (if not running APEX Listener in Standalone Mode), and which Database version is the home for your APEX?
          The blog post you've referenced contains a step that seems to be incomplete. It says
          I was interested to test the new Excel upload feature, to get to work I added following line to the config file (apache-tomcat/temp/apex/apex-config.xml)
          true
          I don't know if this is a temporary error on that page, but it indicates you've perhaps made changes to apex-config.xml and possibly to web.xml due to other configuration task as well. Can you please describe what kind of changes you've implemented to configure your APEX Listener?

          Last, but not least: Do you receive any error in the APEX Listeners log for that action?
          Is your web server running on the same machine you run your APEX Listener on? If so, did you configure a different port for APEX Listener?

          -Udo