Endless ajax call possible??
Hi 2 all!
I would like to implement a meeting room display - apex application. It is a very small application which runs on a tablet mounted beside the door a meeting room.
The application has two pages:
Page 1 to set some cookies (meetingroom, site, timezone)
Page 2 displays the defined meetingroom name, the actual datetime and the current booking situation. This page should run for at least one month without any interaction.
Just always displaying the current booking situation.
The current booking situation is located in an own region and the region content gets refreshed periodically by a an ajax call which calls an application.
Some details...
The application process (LOAD_MEETINGS):
Begin
owa_util.mime_header('plain/text', FALSE);
htp.p('Cache-Control: no-cache');
htp.p('Pragma: no-cache');
owa_util.http_header_close;
HTP.p (ers_display.display_mr(apex_application.g_x02,apex_application.g_x01)); --returns the html content
End;
The javascript code in the page header:
<script language="JavaScript">
//Loads the actual time
window.onload=worldClockZone("datetime");
//refresh of the booking status
var refresh_content = function(){
var ajaxRequest = new htmldb_Get(null, 500, 'APPLICATION_PROCESS=LOAD_MEETINGS', 1);
ajaxRequest.addParam("x02", $.cookies.get('MEETINGROOM_COOKIE'));
ajaxRequest.addParam("x01", $.cookies.get('SITE_CODE_COOKIE'));
var ajaxResult = ajaxRequest.get();
$("#BOOKING_CONTENT").html(ajaxResult);
$("#themeetingroom").html($.cookies.get('MEETINGROOM_COOKIE'));
$("#theclockclass").attr("name",$.cookies.get('JS_CLOCK_CLASS_COOKIE'));
setTimeout("refresh_content()", 1000);
}
</script>
<script language="JavaScript">
var refresh_page = function(){
apex.submit('REFRESH');
}
</script>
Javascript executed when page loads:
window.onload=worldClockZone("datetime");
refresh_content();
setTimeout("refresh_page()", 7200000);
The problem:
Every thing runs fine for about 20 hours. Then suddenly the following error appears:
Mon, 7 Oct 2013 06:28:27 GMT wwv_flow.show:SIGNATURE (parameter names) MISSMATCH VARIABLES IN FORM NOT IN PROCEDURE:
P NON-DEFAULT VARIABLES IN PROCEDURE NOT IN FORM: DATA name: devsystem PROCEDURE: wwv_flow.show URL :
http://devsystem.int.com:7779/apex/devsystem/wwv_flow.show?p=::52342342343234: PARAMETERS : =========== P: ::52342342343234:
ENVIRONMENT: =========== PLSQL_GATEWAY= WebDb GATEWAY_IVERSION=3
SERVER_SOFTWARE=Oracle-Application.Server.10g/10.1.2.0.2 Oracle -HTTP-Server GATEWAY_INTERFACE=CGI/1.1 SERVER_PROT=7779 SERVER_NAME=devsystem.int.com
REQUEST_METHODE=GET QUERY_STRING= p=::52342342343234: PATH_INFO=/wwv_flow.show SCRIPT_NAME=/apex/devsystem
....
....
Why does this error occure? Is this an apex problem? Or does it come from the application server?
I already set the application
max session length in seconds = 0
max sessionidle time = 0
Any ideas where to search for a solution?
Best regards,
Mike
