<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>try 'show file in mydbname'</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Harold.A.Johnson@gov.bc.ca
href="mailto:Harold.A.Johnson@gov.bc.ca">Johnson, Harold A EDUC:EX</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=powerh-l@lists.sowder.com
href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, February 14, 2006 8:03
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Show files error</DIV>
<DIV><BR></DIV>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=r_ansi
size=2><SPAN class=636155719-14022006>Hi all. I get the following error
when I try to do a "Show files" command in quiz or qshow (for
example). Any ideas what is causing this? I get the same error in
all of our environments for a particular system (ie: deve, test, prod). It's
been occuring for some time (months) but there doesn't seem to be any other
problems with either the database or with Powerhouse.</SPAN></FONT></P>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=r_ansi
size=2><SPAN class=636155719-14022006>A QSHOW "show record" of the
product_component_version" comes back fine. <BR></SPAN></FONT><FONT
face=r_ansi size=2><SPAN class=636155719-14022006>A "show table" in SQL is
fine.<BR></SPAN></FONT><FONT face=r_ansi size=2><SPAN
class=636155719-14022006></SPAN></FONT></P>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=r_ansi
size=2><SPAN class=636155719-14022006>OpenVMS v7.3-2<BR>Oracle RDB
v7.1-241<BR>Powerhouse v710g1</SPAN></FONT></P>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=r_ansi
size=2><SPAN class=636155719-14022006>$quiz</SPAN></FONT></P>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=r_ansi
size=2><SPAN class=636155719-14022006>>show file</SPAN></FONT></P>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
size=+0><FONT face=r_ansi><FONT size=2><SPAN
class=636155719-14022006>...</SPAN></FONT></FONT></FONT></P>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
size=+0><FONT size=+0><SPAN class=636155719-14022006></SPAN><FONT
face=r_ansi><FONT size=2><SPAN class=636155719-14022006>... lots of
tables</SPAN></FONT></FONT></FONT></FONT></P>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
size=+0><FONT size=+0><FONT size=+0><SPAN
class=636155719-14022006></SPAN><FONT face=r_ansi><FONT size=2><SPAN
class=636155719-14022006>...</SPAN></FONT></FONT></FONT></FONT></FONT></P>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
size=+0><FONT size=+0><FONT size=+0><FONT face=r_ansi><FONT
size=2>ALL_SNAPSHOTS IN SFAS_DATABASE</FONT></FONT></FONT></FONT></FONT></P>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=r_ansi
size=2>USER_SNAPSHOTS IN SFAS_DATABASE</FONT></P>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=r_ansi
size=2>PRODUCT_COMPONENT_VERSION IN SFAS_DATABASE</FONT></P>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=r_ansi
size=2>*E* Relational Database access failed.</FONT></P>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=r_ansi
size=2>%RDB-E-ARITH_EXCEPT, truncation of a numeric value at
runtime</FONT></P>
<P class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=r_ansi
size=2>%COSI-F-INTOVF, integer overflow</FONT></P>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><SPAN
class=636155719-14022006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><SPAN
class=636155719-14022006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><SPAN
class=636155719-14022006></SPAN> </DIV>
<P>
<HR>
<P></P>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe: "subscribe" in
message body to powerh-l-request@lists.sowder.com<BR>Unsubscribe: "unsubscribe
&lt;password&gt;" in message body to
powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This
list is closed, thus to post to the list you must be a
subscriber.<BR></BLOCKQUOTE></BODY></HTML>