Error 42S22
SQ063: No column _host.
while executing the following statement:
#line 1982 "/DAV/VAD/conductor/robot_process.vspx-sql"
create method vc_render_page_d8c6d35f642126874d8a31087113a898D_conductor_robot__process_vspx (inout control vspx_page) for "DB"."dba".page_d8c6d35f642126874d8a31087113a898D_conductor_robot__process_vspx
{
--no_c_escapes-
declare path, params, lines any;
declare hdr, page_state varchar;
path := self.vc_event.ve_path;
params := self.vc_event.ve_params;
lines := self.vc_event.ve_lines;
hdr := http_header_get ();
declare hdr_add varchar;
hdr_add := 'Cache-Control: no-cache, must-revalidate\r\nPragma: no-cache\r\nExpires: -1;\r\n';
if (strcasestr (http_request_header (lines, 'User-Agent', NULL, ''), 'MSIE') is not null)
hdr_add := 'Cache-Control: Public\r\nPragma: no-cache\r\nExpires: -1;\r\n';
if (hdr is null)
http_header (hdr_add);
else if (strcasestr (hdr, 'Cache-Control:') is null)
{
hdr := concat (hdr, hdr_add);
http_header (hdr);
}
page_state := self.vc_view_state;
self.vc_view_state := DB.DBA.vspx_do_compact (page_state);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN">
<!-- -->
<html<?vsp vspx_print_html_attrs (self); ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" href="yacutia_style.css" type="text/css" />
<link type="text/css" rel="stylesheet" href="syntax/SyntaxHighlighter.css" />
<link rel="alternate" type="application/rss+xml" title="Virtuoso Screencast Demos" href="http://support.openlinksw.com/viewlets/virtuoso_viewlets_rss.vsp" />
<link rel="alternate" type="application/rss+xml" title="Virtuoso Tutorials" href="http://demo.openlinksw.com/tutorial/rss.vsp" />
<link rel="alternate" type="application/rss+xml" title="Virtuoso Product Blog (RSS 2.0)" href="http://www.openlinksw.com/weblogs/virtuoso/gems/rss.xml" />
<link rel="alternate" type="application/atom+xml" title="Virtuoso Product Blog (Atom)" href="http://www.openlinksw.com/weblogs/virtuoso/gems/atom.xml" />
<link rel="alternate" type="application/rss+xml" title="ODBC for Mac OS X Screencast Demos" href="http://support.openlinksw.com/viewlets/mac_uda_viewlets_rss.vsp" />
<link rel="alternate" type="application/rss+xml" title="Data Access Drivers Screencast Demos" href="http://support.openlinksw.com/viewlets/uda_viewlets_rss.vsp" />
<link rel="alternate" type="application/rss+xml" title="Benchmark & Troubleshooting Utilities Screencasts" href="http://support.openlinksw.com/viewlets/utilities_viewlets_rss.vsp" />
<title>WebDAV Content Management</title>
<script type="text/javascript" src="toolkit/loader.js"></script>
<script type="text/javascript">
OAT.Preferences.imagePath = "images/";
OAT.Loader.load(["combolist", "ajax", "tab", "json", "calendar"], function(){OAT.MSG.send(OAT, 'PAGE_LOADED');});
</script>
</head>
<body><noscript xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:vm="http://www.openlinksw.com/vspx/macro" xmlns:vdeps="http://www.openlinksw.com/vspx/deps/" xmlns:ev="http://www.w3.org/2001/xml-events">
Your browser either does not support JavaScript or it is
disabled in your browser's settings. Please consult your browser's
documentation for information about enabling this feature.
</noscript>
<table id="MTB" cellspacing="0" cellpadding="0" width="100%">
<tr id="MB2">
<td colspan="2" align="left">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="left"><img src="images/con_banner.gif" border="0" />
</td>
<td width="80%" align="left">
<div class="login_info"><img src="images/icons/user_16.png" /><?vsp if (connection_get ('vspx_user') is not null) { ?>
logged in as <?V connection_get ('vspx_user') ?> |
<?vsp
{
vspx_url_render_ex (
null
, 'Log out'
, 'main_tabs.vspx?logout=1'
, self.sid, self.realm, 0, vector ( NULL)
);
}
?><?vsp } else { ?>
not logged in
<?vsp }?> | <img src="images/vglobe_16.png" alt="Start" title="Start Menu" hspace="2" /><a href="/">Home</a>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr id="MT">
<td id="LC" style="white-space: nowrap;">
<script type="text/javascript">
function adm_post (f, btn)
{
var s = f.password_plain.value;
f.__submit_func.value = '__submit__';
f.__submit_func.name = btn.name;
f.password.value = hex_md5 (f.nonce.value + f.password_plain.value);
f.password_plain.value = "";
f.submit ();
f.password_plain.value = s;
}
</script>
<?vsp
{
control.vc_render ('admin_login');
}
?>
<ul class="left_toolbox">
<li><img src="images/icons/apps_16.png" alt="ISQL" title="Interactive SQL popup" /><?vsp
control.vc_render('browse_button1');
?>
</li><?vsp if (connection_get ('vspx_user') is not null)
{
?>
<li><img src="images/icons/foldr_16.png" alt="WebDAV browser" title="WebDAV browser" /><?vsp
control.vc_render('ctrl_id0x7f9740702118');
?>
</li><?vsp }
if (vad_check_version ('Framework') is not null)
{
?>
<li><img src="images/vglobe_16.png" alt="WA" title="Data Space Applications" /><a href="<?V wa_link () ?>">OpenLink Data Spaces</a>
</li><?vsp }
?>
<li><img src="images/vglobe_16.png" alt="Start" title="Start Menu" /><a href="/">Virtuoso Start Menu</a>
</li>
</ul>
<ul class="left_nav">
<li><img src="images/icons/docs_16.png" alt="Documentation" title="Documentation" hspace="2" /><?vsp if (vad_check_version ('doc') is not null)
{
?>
<a href="/doc/html/" target="_top">Documentation<small> (local)</small>
</a><?vsp }
else
{
?>
<a href="http://docs.openlinksw.com/virtuoso/" target="_top">Documentation<small> (web)</small>
</a><?vsp }
?>
</li>
<li><img src="images/icons/tour_16.png" alt="Tutorials" title="Tutorials" hspace="2" /><?vsp if (vad_check_version ('tutorial') is not null)
{
?>
<a href="/tutorial/" target="_top">Tutorials<small> (local)</small>
</a><?vsp }
else
{
?>
<a href="http://demo.openlinksw.com/tutorial/" target="_top">Tutorials<small> (web)</small>
</a><?vsp }
?>
</li>
</ul>
<ul class="left_nav">
<li class="xtern"><img src="images/icons/web_16.png" alt="Virtuoso Web Site" title="Virtuoso Web Site" hspace="2" /><a href="http://virtuoso.openlinksw.com/">Virtuoso Web Site</a>
</li>
<li class="xtern"><img src="images/icons/web_16.png" alt="OpenLink Software" title="OpenLink Software" hspace="2" /><a href="http://www.openlinksw.com">OpenLink Software</a>
</li>
</ul>
<ul class="left_id">
<li>Version: <?V sys_stat ('st_dbms_ver') ?>
</li>
<li>Build: <?V sys_stat ('st_build_date') ?>
</li>
</ul>
</td>
<td id="RC">
<table id="RTB">
<tr>
<td id="RT"><?vsp control.vc_render ('navbar1'); ?>
</td>
</tr>
<tr>
<td id="RB">
<div class="subpage_header_area">
<?vsp if (self.nav_pos_fixed) { ?>
<h1 class="page_title">Content Import Queues</h1>
<?vsp } ?>
<?vsp if (self.nav_pos_fixed) { ?>
<td class="SubInfo">
<?vsp
{
vspx_url_render_ex (
'%s'
, 'Import Targets'
, 'robot_control.vspx'
, self.sid, self.realm, 0, vector ( NULL)
);
}
?>
</td>
<td class="SubInfo">
<?vsp
{
vspx_url_render_ex (
'%s'
, 'Retrieved Sites'
, 'robot_sites.vspx'
, self.sid, self.realm, 0, vector ( NULL)
);
}
?>
</td>
<?vsp } ?>
<?vsp
{
control.vc_render ('ctrl_id0x7f97405c21f8');
}
?>
</div>
<div class="main_page_area">
<?vsp if (self.nav_pos_fixed) { ?>
<H3>Site Download Status</H3>
<?vsp declare _err_cnt integer;
_host := get_keyword ('host', params);
_root := get_keyword ('root', params);
_upd := atoi (get_keyword ('upd', params));
_url := get_keyword ('url', params);
if (_upd < 2)
{
http('<br>\n');
declare _start_t, _end_t integer;
declare _t_int, updated_l integer;
declare sttime datetime;
declare continue handler for not found { sttime := now (); };
{
select max(VU_CPTIME) into sttime from WS.WS.VFS_URL where VU_ROOT = _root and VU_HOST = _host;
}
updated_l := 0;
if (_upd = 0)
{
-- always do re-fetch
if (_url is null)
_url := coalesce ((select VS_URL from WS.WS.VFS_SITE where VS_ROOT = _root and VS_HOST = _host), '/');
delete from WS.WS.VFS_URL where VU_ROOT = _root and VU_HOST = _host;
delete from WS.WS.VFS_QUEUE where VQ_ROOT = _root and VQ_HOST = _host and VQ_URL <> _url;
update WS.WS.VFS_QUEUE set VQ_STAT = 'waiting' where VQ_HOST = _host and VQ_ROOT = _root and VQ_URL = _url;
}
_start_t := msec_time ();
-- disable the following code to enable old behaviour
if (1)
{
http_rewrite ();
http_header(sprintf('Location: robot_status.vspx?host=%U&root=%U&url=%U&start=%d&sid=%s&stime=%s\r\n', _host, _root, _url, _start_t, sid, cast(sttime as varchar)));
http_request_status('HTTP/1.1 302 Found');
http_flush();
}
WS.WS.SERV_QUEUE_TOP(_host, _root, _upd, _dbg, null, null);
_end_t := msec_time ();
_t_int := _end_t - _start_t;
declare continue handler for not found
{
updated_l := 0;
};
select count(*) into updated_l from WS.WS.VFS_URL where VU_ROOT = _root and VU_HOST = _host and VU_CPTIME > sttime and VU_URL not like '%/';
if (_upd = 1)
{
if (updated_l > 0)
http (sprintf ('<p><small><strong>Total updated : %d</strong></small></p>', updated_l), res_ses);
else
http (sprintf ('<p><small><strong>No updates</strong></small></p>', updated_l), res_ses);
}
http (concat ('<p><strong> Total time: ', cast (_t_int as varchar), ' (msec) </strong></p>'), res_ses);
_err_cnt := coalesce ((select count(*) from WS.WS.VFS_QUEUE where VQ_HOST = _host and VQ_ROOT = _root and VQ_STAT = 'error'), 0);
if (_err_cnt > 1)
http (concat ('<p>Errors while retrieving target. Wrong entries : ', cast (_err_cnt as varchar) ,'. Select "Stop" and "Reset" to return initial state</p>'), res_ses);
}
else if (_upd = 2)
{
update WS.WS.VFS_QUEUE set VQ_STAT = 'waiting' where VQ_HOST = _host and VQ_ROOT = _root and VQ_URL = _url;
}
else if (_upd = 3)
{
delete from WS.WS.VFS_QUEUE where VQ_HOST = _host and VQ_ROOT = _root and VQ_URL <> _url and VQ_STAT <> 'pending';
}
commit work;
http (string_output_string (res_ses));
?>
<?vsp }
?>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr id="FT"><td id="copyright_ctr" colspan="2">
Copyright © 1998-<?V "LEFT" (datestring (now ()), 4)?> OpenLink Software
</td>
</tr>
</table>
<?vsp http('<script type="text/javascript" src="md5.js"></script>\n');
http('<script type="text/javascript" src="cond_common.js"></script>\n');
-- http('<script type="text/javascript" src="cond_help.js"></script>\n');
?>
</body>
</html>
<?vsp declare ht_stat varchar;
ht_stat := http_request_status_get ();
if (ht_stat is not null and ht_stat like 'HTTP/1._ 30_ %')
http_rewrite ();
?>
<?vsp
if (length (self.sid))
{
declare vars any;
connection_set ('error_str', self.error_str);
connection_set ('robot_control_ref_allowed', self.robot_control_ref_allowed);
connection_set ('robot_sites_ref_allowed', self.robot_sites_ref_allowed);
;
vars := connection_vars ();
if (connection_is_dirty ())
{
update VSPX_SESSION set VS_STATE = serialize (vars) where VS_SID = self.sid and VS_REALM = self.realm;
}
}
}