Error in QSHOW
Boyle, Joe
Joe.Boyle@cognos.com
Wed, 27 Feb 2002 16:39:41 -0000
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.
------_=_NextPart_001_01C1BFAD.5A7BE140
Content-Type: text/plain;
charset="iso-8859-1"
you might want to consider the following options,
a full recompile of the dictionary
search the pdl source file for 'scale' strings in order to check if any are
negative
try "qshow , set lan sql, gen all", and then check the output file, perhaps
there are more tables than you realise, or even "qshow , set lan pdl, gen
all", there might be an RMS file in there somewhere
upgrade to 7.10.G4. This has not reported as a problem in the 7.10.G line
in the past, but it might fix the problem,
-----Original Message-----
From: Johnson, Harold A EDUC:EX [mailto:Harold.A.Johnson@gems1.gov.bc.ca]
Sent: 27 February 2002 16:21
To: 'Boyle, Joe'; PowerHouse List (E-mail)
Subject: RE: Error in QSHOW
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.
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.
------_=_NextPart_001_01C1BFAD.5A7BE140
Content-Type: text/html;
charset="iso-8859-1"
<!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 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=301452716-27022002><FONT size=2><FONT color=#0000ff><FONT
face=Arial><SPAN class=093452916-27022002>you might want to consider the
following options,</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=301452716-27022002><FONT size=2><FONT color=#0000ff><FONT
face=Arial><SPAN
class=093452916-27022002></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=301452716-27022002><FONT size=2><FONT color=#0000ff><FONT
face=Arial><SPAN class=093452916-27022002>a full recompile of the
dictionary</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=301452716-27022002><FONT size=2><FONT color=#0000ff><FONT
face=Arial><SPAN
class=093452916-27022002></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=301452716-27022002><FONT size=2><FONT color=#0000ff><FONT
face=Arial>search the pdl <SPAN class=093452916-27022002>source file
</SPAN>for <SPAN class=093452916-27022002>'</SPAN>scale' strings in order
to check if any are negative</FONT></FONT></FONT></SPAN></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=301452716-27022002><SPAN
class=093452916-27022002></SPAN></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=301452716-27022002><SPAN
class=093452916-27022002>try "qshow , set lan sql, gen all", and then check
the output file, perhaps there are more tables than you realise, or even
"qshow , set lan pdl, gen all", there might be an RMS file in there
somewhere</SPAN></SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=301452716-27022002><SPAN
class=093452916-27022002></SPAN></SPAN></FONT> </DIV>
<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial><SPAN
class=301452716-27022002>upgrade to 7.10.G4<SPAN
class=093452916-27022002>. This has not reported as a problem in the
7.10.G line in the past, but it might fix the
problem,</SPAN></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial><SPAN
class=301452716-27022002><SPAN
class=093452916-27022002></SPAN></SPAN></FONT></FONT></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Johnson, Harold A EDUC:EX
[mailto:Harold.A.Johnson@gems1.gov.bc.ca]<BR><B>Sent:</B> 27 February 2002
16:21<BR><B>To:</B> 'Boyle, Joe'; PowerHouse List (E-mail)<BR><B>Subject:</B>
RE: Error in QSHOW<BR><BR></DIV></FONT>
<DIV><SPAN class=302201616-27022002><FONT color=#0000ff face=Arial
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 color=#0000ff face=Arial size=2>I'll
check into the dictionary problem below..</FONT></SPAN></DIV>
<DIV><SPAN class=302201616-27022002><FONT color=#0000ff face=Arial
size=2>thnx</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><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></BLOCKQUOTE></BODY></HTML>
<BR>
<P><FONT SIZE=2 FACE="Arial">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>
------_=_NextPart_001_01C1BFAD.5A7BE140--