IEEE Invalid operation (TRAPS 13)
Joe Boyle
atla38@dsl.pipex.com
Thu, 17 Feb 2005 18:39:31 -0000
I read Steve's email from Cognos and wonder if the details are correct. I
think that subtotalled items would map to float items, or else decimal parts
would be lost if summed into an integer, unless quiz first evaluates how
many decimal places are present and multiplies up to an integer; even then,
you would need to know how to scale down the results ?
Regards, Joe.
-----Original Message-----
From: Joe Boyle [mailto:atla38@dsl.pipex.com]
Sent: 16 February 2005 04:14
To: 'Georgia Miller'; 'PowerHouse Listserv'
Subject: RE: IEEE Invalid operation (TRAPS 13)
a few more thoughts.
1.
You could check that all index subfile parts have been purged ( I think
there are 2 or 3 on MPE), it may be that one of the original parts is lying
around and incompatible between qtp and quiz.
2.
assuming the error reference to IEEE is not a red herring, you could try
commenting out the define D-ENC-AMOUNT and all its references to see if this
clears the error; if it does, it might be worth considering changing from
numeric*12 to integer*12 if that's possible; I recall that only num*n types
get the IEEE/NONIEEE float default, and probably the subtotaled D-ENC-AMOUNT
is getting the IEEE mapping, and the NON subtotaled D-ENC-AMOUNT is getting
the NONIEEE mapping, or v/v. ( it might be that one is mapped as a 4 byte
float and the other an 8 byte, either of which could conflict the subfile
structure )
3.
Last of all, I have seen issues when using go's in line with quiz. It might
be worth replacing with e.g. build qz1, build qz2, build qz3, and code the
run as below,
Quiz
> exe qz1
> exe qz2
> exe qz3
or putting the 4 line code below in a file e.g. qzall3s and using syntax
like
quiz auto=qzall3s
exe qz1
exe qz2
exe qz3
exit
Regards, Joe.
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Georgia Miller
Sent: 16 February 2005 00:04
To: PowerHouse Listserv
Subject: Re: IEEE Invalid operation (TRAPS 13)
I am recreating my subfile each time.
I tried to just access the subfile created with Quiz and this is the
results:
Q U I Z (PowerHouse 8.19.C3)
Copyright 1998 COGNOS INCORPORATED
GREAT FALLS PUBLIC SCHOOL DISTRICT
> acc *sbaphist
> rep all
> set rep limit 5000
> go
**** IEEE invalid operation (TRAPS 13).
ABORT: QUIZ.PH819C3.COGNOS
File error: #93
NM PROG 85.000caa90 qNFormat+$13c
RUN QUIZ.PH819C3.COGNOS;INFO=" "; XL="PHLIBXLS.PH819C3.COGNOS
PHLIBODX.PH819C3
.COGNOS"
Program terminated in an error state. (CIERR 976)
So it is definitely a problem with the subfile created with Quiz. This used
to work when I created the subfile with QTP. Taking Joe's Advice, of
showing the elements, I did find that a date field was listed as Type: 9(0).
I thought this looked funny so I defined it as a Num*8 item and recreated
the subfile. I am still getting the error above. Now the Date item lists
as:
Element: D-DETL-DATE
Type: Date with century included
Date Picture: MM/DD/YYYY
Heading: "D-DETL-DATE"
I did get 4 data conversion errors when I ran the Quiz code that created the
subfile, that I don't think I got before the date change.
The strange thing is, last week I converted a similar QTP source to QUIZ
that creates a subfile of the same YTD data, while this one creates a
subfile of monthly data. I have tried creating the subfile with 3 different
month's data, and I still get the same problem.
I am sure that the problem is in the creation of the subfile with Quiz. Here
is the Quiz Code is someone can see if I am doing something wrong:
;APZMTDT2 - EXPENDITURE STATEMENT MONTHLY DETAIL BY BUDGET UNIT
; BUILD DETAIL SUBFILES
;02/14/2005 G. Miller -Created to replace APTBYORG to run majority in Quiz
not Q
TP
;REQUEST TO ADD APHIST RECORDS TO SBAPHIST SUBFILE
USE QUIZS132.USE NOL
SET REP LIMIT 50000
ACCESS MONITOR &
LINK CURRENT-PERIOD OF MONITOR TO PERIOD OF APHIST
DEFINE D-VENDOR-DESCR CHA*40 = PACK(PAYEE OF APHIST + "/" + &
DESCRIPTION OF APHIST) &
IF PAYEE OF APHIST NE DESCRIPTION OF APHIST &
AND DESCRIPTION OF APHIST NE " " &
ELSE PAYEE OF APHIST
DEFINE D-RQ-NUMBER CHA*8 = " "
DEFINE D-PO-NUMBER CHA*6 = PO-NUMBER OF APHIST[5:6]
DEFINE D-INVOICE CHA*12 = INVOICE OF APHIST[9:12]
DEFINE D-CHECK-NO CHA*6 = REFERENCE OF APHIST[5:6]
DEFINE D-ENC-AMOUNT NUM*12 = 0
SORT ON EXP-ACCOUNT OF APHIST, &
REFERENCE OF APHIST, &
PO-NUMBER OF APHIST, &
PAYEE OF APHIST, &
TRAN-CODE OF APHIST, &
BATCH-CONTROL-NO OF APHIST, &
INVOICE OF APHIST
DEFINE T-AMOUNT INTEGER SIGNED SIZE 8 = AMOUNT OF APHIST
DEFINE D-ACCOUNT CHA*24 = EXP-ACCOUNT OF APHIST
DEFINE D-DETL-DATE NUM*8 = CHECK-DATE OF APHIST
DEFINE D-TRAN-CODE CHA*2 = TRAN-CODE OF APHIST
SET SUBFILE NAME SBAPHIST KEEP &
AT INVOICE &
INDEX D-ACCOUNT
REPORT SUMMARY &
D-ACCOUNT &
D-DETL-DATE &
D-RQ-NUMBER &
D-PO-NUMBER &
D-INVOICE &
D-CHECK-NO &
D-TRAN-CODE &
T-AMOUNT SUBTOTAL &
PERIOD OF APHIST &
D-ENC-AMOUNT &
D-VENDOR-DESCR
GO
;Request to add Open Encumberances
ACCESS P-O &
LINK (" ") TO COMPANY OF MONITOR &
LINK PO-NUMBER OF P-O TO PO-NUMBER OF POTRAN
SELECT P-O IF STATUS-CODE OF P-O = "EP" OR STATUS-CODE OF P-O="PE"
SELECT POTRAN IF VOUCHER-NO = " " AND &
ENCUM-ACCOUNT OF POTRAN <> " " AND &
ENCUMBERANCE OF POTRAN > 0
SELECT IF PERIOD OF P-O > YB-PERIOD OF MONITOR AND &
PERIOD OF P-O <= CURRENT-PERIOD OF MONITOR
SORT ON ENCUM-ACCOUNT OF POTRAN, PO-NUMBER OF POTRAN, &
ITEM-SEQ OF POTRAN D
DEFINE D-VENDOR-DESCR CHA*40 = PACK(PAYEE OF P-O + "/" + &
RQ-DESC OF POTRAN)
DEFINE D-RQ-NUMBER CHA*8 = RQ-NUMBER OF POTRAN[4:7] &
IF "000" = RQ-NUMBER OF POTRAN[1:3] &
ELSE RQ-NUMBER OF POTRAN[3:8]
DEFINE D-PO-NUMBER CHA*6 = PO-NUMBER OF P-O[5:6]
DEFINE D-INVOICE CHA*12 = DEPARTMENT OF P-O
DEFINE D-CHECK-NO CHA*6 = " "
DEFINE D-ENC-AMOUNT NUM*12 = ENCUMBERANCE OF POTRAN
DEFINE T-AMOUNT INTEGER SIGNED SIZE 8 = 0
DEFINE D-TRAN-CODE CHA*2 = "PO"
DEFINE D-ACCOUNT CHA*24 = ENCUM-ACCOUNT OF POTRAN
DEFINE D-DETL-DATE num*8 = DETL-DATE OF P-O
SET SUBFILE NAME SBAPHIST KEEP APPEND &
AT PO-NUMBER &
INDEX D-ACCOUNT
REPORT SUMMARY &
D-ACCOUNT &
D-DETL-DATE &
D-RQ-NUMBER &
D-PO-NUMBER &
D-INVOICE &
D-CHECK-NO &
D-TRAN-CODE &
T-AMOUNT &
PERIOD OF P-O &
D-ENC-AMOUNT SUBTOTAL &
D-VENDOR-DESCR
GO
;Request to add Transactions from GLTRAN
ACCESS GLMAST &
LINK (" ") TO COMPANY OF MONITOR &
LINK (CURRENT-PERIOD OF MONITOR + ACCOUNT OF GLMAST) &
TO PERIOD-ACCT OF GLTRAN
SELECT GLMAST IF STATEMENT-FLAG OF GLMAST = "E"
SELECT GLTRAN IF TRAN-CODE OF GLTRAN = "JE" OR &
TRAN-CODE OF GLTRAN = "PS" OR &
TRAN-CODE OF GLTRAN = "PJ" OR &
TRAN-CODE OF GLTRAN = "TR" OR &
TRAN-CODE OF GLTRAN = "RX" OR &
TRAN-CODE OF GLTRAN = "XR"
SORT ON ACCOUNT OF GLTRAN, DETL-DATE OF GLTRAN, TRAN-CODE OF GLTRAN
DEFINE D-VENDOR-DESCR CHA*40 = PACK(DESCRIPTION OF GLTRAN + " " + &
DESC2 OF GLTRAN)
DEFINE D-RQ-NUMBER CHA*8 = RQ-NUMBER OF GLTRAN[4:7] &
IF "000" = RQ-NUMBER OF GLTRAN[1:3] &
ELSE RQ-NUMBER OF GLTRAN[3:8]
DEFINE D-PO-NUMBER CHA*6 = PO-NUMBER OF GLTRAN[5:6]
DEFINE D-INVOICE CHA*12 = INVOICE OF GLTRAN
DEFINE D-CHECK-NO CHA*6 = REFERENCE OF GLTRAN[5:6]
DEFINE D-ENC-AMOUNT NUM*12 = 0
DEFINE T-AMOUNT INTEGER SIGNED SIZE 8 = AMOUNT OF GLTRAN
DEFINE D-ACCOUNT CHA*24 = ACCOUNT OF GLTRAN
DEFINE D-DETL-DATE num*8 = DETL-DATE OF GLTRAN
DEFINE D-TRAN-CODE CHA*2 = TRAN-CODE OF GLTRAN
SET SUBFILE NAME SBAPHIST KEEP APPEND INDEX D-ACCOUNT
REPORT SUMMARY &
D-ACCOUNT &
D-DETL-DATE &
D-RQ-NUMBER &
D-PO-NUMBER &
D-INVOICE &
D-CHECK-NO &
D-TRAN-CODE &
T-AMOUNT &
PERIOD OF GLTRAN &
D-ENC-AMOUNT &
D-VENDOR-DESCR
GO
On 2/15/2005 12:54 PM, Joe Boyle <atla38@dsl.pipex.com> wrote:
>you could try running command syntax below in qshow and compare the
>subfile
>elements with any items that you might be initializing from in your
>dictionary files; I seem to recall that there are both IEEE and non-IEEE
>elements and it could be that your current dictionary default is
>out of sync
>with your subfile,
>
>qshow
>> sho subfile 'subfile-spec' element detail
>
>Also, was the subfile created in an earlier version of PH, or are
>you
>creating a new one in each run ?
>
>It might also be worth listing your source code to see if there is
>a problem
>with qtp syntax running in quiz, and possibly not being picked up
>by the
>compiler.
>
>
>Regards, Joe.
>
>This e-mail and all information contained in it is confidential and
>may be
>legally privileged. If you are not the intended recipient, your access
>to
>this e-mail is unauthorized. Any use, dissemination, distribution,
>publication or copying by you of this e-mail or any of the information
>contained within it is prohibited and may be unlawful. Do not open
>any
>attachments, delete it immediately from your system and notify the
>sender
>promptly by e-mail that you have done so. The content of this e-mail
>and any
>attachments sent with it may have been altered without the consent
>or
>knowledge of the author.
>
>-----Original Message-----
>From: powerh-l-admin@lists.sowder.com
>[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Georgia Miller
>Sent: 15 February 2005 18:43
>To: PowerHouse Listserv
>Subject: IEEE Invalid operation (TRAPS 13)
>
>Does Anyone know what causes this error in Quiz? I have never seen
>it
>before.
>
>Q U I Z (PowerHouse 8.19.C3)
>Copyright 1998 COGNOS INCORPORATED
>GREAT FALLS PUBLIC SCHOOL DISTRICT
>
>> EXE APZBYORG.OBJECT
>**** IEEE invalid operation (TRAPS 13).
>
>ABORT: QUIZ.PH819C3.COGNOS
> File error: #93
>NM PROG 5a0.000caa90 qNFormat+$13c
>
> RUN QUIZ.PH819C3.COGNOS;INFO=" "; XL="PHLIBXLS.PH819C3.COGNOS
>PHLIBODX.PH819C3
>.COGNOS"
>Program terminated in an error state. (CIERR 976)
>
>This is on an HP3000 with Quiz 8.19.C3.
>
>This quiz source is about 170 lines of code. I changed the Subfile
>used by
>this and several other reports to create the subfile with Quiz instead
>of
>QTP. I believe this problem is being caused by data, because the
>report
>does print about 4 lines before it gets the above error.
>
>I have run several other reports that use the same subfile and they
>all get
>the same error. One that sorts differently prints 31 pages before
>it stops
>with this error.
>
>Thanks for the help.
>Georgia Miller
>Great Falls Public Schools.
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.