IEEE Invalid operation (TRAPS 13)
Georgia Miller
Georgia Miller <georgia_miller@mail.gfps.k12.mt.us>
15 Feb 2005 17:04:09 -0700
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.
>
>