Error in QSHOW
Johnson, Harold A EDUC:EX
Harold.A.Johnson@gems1.gov.bc.ca
Wed, 27 Feb 2002 08:20:45 -0800
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--Boundary_(ID_NWMG+0g5+dCKe8MFuWCiag)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7BIT
710g1 - at this point, I can't even find the table/view that is causing the
error. I tried a job that did a show record of every single table, but the
error didn't show up. It only shows up when doing a display of multiple
tables.
I'll check into the dictionary problem below..
thnx
-----Original Message-----
From: Boyle, Joe [mailto:Joe.Boyle@cognos.com]
Sent: Wednesday, February 27, 2002 4:42 AM
To: Johnson, Harold A EDUC:EX; PowerHouse List (E-mail)
Subject: RE: Error in QSHOW
Hi Harold,
which version of PH are you using ?
there is an old bug logged against 7.10.C, details, including work around,
below,
Problem Description:
Define an RDB field as an element in the dictionary with a
negative output scale will result in the following error...
*W* Data access error. (relationname)
%RDB-E-ARITH_EXCEPT, truncation of a numeric value at runtime
%SYSTEM-F-INTOVF, arithmetic trap, integer overflow at PC=004A2C25, PSL
There is a workaround in the bug details as below,
Remove the negative output scale from PHD and
put negative OUTPUT SCALE when using item in source.
Not very acceptable because clients will have to modify all
source using item instead of enterring once in PHD.
Alternative work arounds suggested by Paul S:
Declare data type as SIGNED LONGWORD in the database
and recompile applications. This is big enough
to hold the returned scaled up value.
OR Leave the type as SIGNED WORD in the database, but
declare it with a SCALE of -4. Thus the meta data
would better reflect the displayed unit type.
If this is done, the OUTPUT SCALE need not
be specified in PDL.
regards,
Joe Boyle.
-----Original Message-----
From: Johnson, Harold A EDUC:EX
[ mailto:Harold.A.Johnson@gems1.gov.bc.ca
<mailto:Harold.A.Johnson@gems1.gov.bc.ca> ]
Sent: 26 February 2002 23:50
To: PowerHouse List (E-mail)
Subject: Error in QSHOW
Hi Experts. I get the following error when trying to do a "show record" in
QSHOW. We have a number of tables and views (> 400) in an RDB database. If
I do this command on an individual table, its OK. But when I try to do a
"show record.. anything" which returns more than one table, this error pops
up.
*E* Relational Database access failed.
%RDB-E-ARITH_EXCEPT, truncation of a numeric value at runtime
%COSI-F-INTOVF, integer overflow
Any idea how I can find the table/view that is causing the problem without
having to examine every single table/view individually? I don't get any
errors when doing the same thing with SQL. e.g. "show table", "show view".
thnx
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
<http://lists.swau.edu/mailman/listinfo/powerh-l>
This list is closed, thus to post to the list you must be a subscriber.
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
--Boundary_(ID_NWMG+0g5+dCKe8MFuWCiag)
Content-type: text/html; charset=iso-8859-1
Content-transfer-encoding: 7BIT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Error in QSHOW</TITLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=302201616-27022002><FONT face=Arial color=#0000ff size=2>710g1
- at this point, I can't even find the table/view that is causing the
error. I tried a job that did a show record of every single table, but the
error didn't show up. It only shows up when doing a display of multiple
tables.</FONT></SPAN></DIV>
<DIV><SPAN class=302201616-27022002><FONT face=Arial color=#0000ff size=2>I'll
check into the dictionary problem below..</FONT></SPAN></DIV>
<DIV><SPAN class=302201616-27022002><FONT face=Arial color=#0000ff
size=2>thnx</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Boyle, Joe
[mailto:Joe.Boyle@cognos.com]<BR><B>Sent:</B> Wednesday, February 27, 2002
4:42 AM<BR><B>To:</B> Johnson, Harold A EDUC:EX; PowerHouse List
(E-mail)<BR><B>Subject:</B> RE: Error in QSHOW<BR><BR></FONT></DIV>
<P><FONT size=2>Hi Harold,</FONT> </P>
<P><FONT size=2>which version of PH are you using ?</FONT> </P>
<P><FONT size=2>there is an old bug logged against 7.10.C, details, including
work around, below,</FONT> </P>
<P><FONT size=2>Problem Description:</FONT> </P>
<P><FONT size=2> Define an RDB field as an element in the dictionary
with a</FONT> <BR><FONT size=2> negative output scale will result in the
following error...</FONT> <BR><FONT size=2> *W* Data access error.
(relationname)</FONT> <BR><FONT size=2> %RDB-E-ARITH_EXCEPT, truncation
of a numeric value at runtime</FONT> <BR><FONT size=2> %SYSTEM-F-INTOVF,
arithmetic trap, integer overflow at PC=004A2C25, PSL</FONT> </P><BR>
<P><FONT size=2>There is a workaround in the bug details as below,</FONT> </P>
<P><FONT size=2>Remove the negative output scale from PHD and</FONT> <BR><FONT
size=2>put negative OUTPUT SCALE when using item in source.</FONT> <BR><FONT
size=2>Not very acceptable because clients will have to modify all</FONT>
<BR><FONT size=2>source using item instead of enterring once in PHD.</FONT>
<BR><FONT size=2>Alternative work arounds suggested by Paul S:</FONT>
<BR><FONT size=2> Declare data type as SIGNED
LONGWORD in the database</FONT> <BR><FONT
size=2> and recompile applications. This
is big enough</FONT> <BR><FONT size=2> to hold
the returned scaled up value.</FONT> <BR><FONT size=2> OR Leave
the type as SIGNED WORD in the database, but</FONT> <BR><FONT
size=2> declare it with a SCALE of -4.
Thus the meta data</FONT> <BR><FONT size=2>
would better reflect the displayed unit type.</FONT> <BR><FONT
size=2> If this is done, the OUTPUT SCALE need
not</FONT> <BR><FONT size=2> be specified in
PDL.</FONT> </P><BR>
<P><FONT size=2>regards,</FONT> <BR><FONT size=2>Joe Boyle.</FONT> </P><BR>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
Johnson, Harold A EDUC:EX</FONT> <BR><FONT size=2>[<A
href="mailto:Harold.A.Johnson@gems1.gov.bc.ca">mailto:Harold.A.Johnson@gems1.gov.bc.ca</A>]</FONT>
<BR><FONT size=2>Sent: 26 February 2002 23:50</FONT> <BR><FONT size=2>To:
PowerHouse List (E-mail)</FONT> <BR><FONT size=2>Subject: Error in
QSHOW</FONT> </P><BR>
<P><FONT size=2>Hi Experts. I get the following error when trying
to do a "show record" in</FONT> <BR><FONT size=2>QSHOW. We have a number
of tables and views (> 400) in an RDB database. If</FONT> <BR><FONT
size=2>I do this command on an individual table, its OK. But when I try
to do a</FONT> <BR><FONT size=2>"show record.. anything" which returns more
than one table, this error pops</FONT> <BR><FONT size=2>up.
</FONT></P>
<P><FONT size=2>*E* Relational Database access failed.</FONT> <BR><FONT
size=2>%RDB-E-ARITH_EXCEPT, truncation of a numeric value at runtime</FONT>
<BR><FONT size=2>%COSI-F-INTOVF, integer overflow</FONT> </P><BR>
<P><FONT size=2>Any idea how I can find the table/view that is causing the
problem without</FONT> <BR><FONT size=2>having to examine every single
table/view individually? I don't get any</FONT> <BR><FONT size=2>errors
when doing the same thing with SQL. e.g. "show table", "show view".</FONT>
</P>
<P><FONT size=2>thnx</FONT> </P>
<P><FONT size=2>= = = = = = = = = = = = = = = = = = = = = = = = = = = =</FONT>
<BR><FONT size=2>Mailing list: powerh-l@lists.swau.edu</FONT> <BR><FONT
size=2>Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu</FONT> <BR><FONT size=2>Unsubscribe:
"unsubscribe" in message body to powerh-l-request@lists.swau.edu</FONT>
<BR><FONT size=2><A href="http://lists.swau.edu/mailman/listinfo/powerh-l"
target=_blank>http://lists.swau.edu/mailman/listinfo/powerh-l</A></FONT>
<BR><FONT size=2>This list is closed, thus to post to the list you must be a
subscriber.</FONT> </P>
<P><FONT size=2>This message may contain privileged and/or confidential
information. If you have received this e-mail in error or are not the
intended recipient, you may not use, copy, disseminate or distribute it; do
not open any attachments, delete it immediately from your system and notify
the sender promptly by e-mail that you have done so. Thank
you.</FONT></P></BLOCKQUOTE></BODY></HTML>
--Boundary_(ID_NWMG+0g5+dCKe8MFuWCiag)--