Quiz problem (QDUMP)

Fri, 24 Aug 2001 11:00:22 -0400

Thanks Michelle, that did it. The programmer told me she purged the file in the job and I thought I asked about any file equations, but ...... you know how that goes. It turns out (for some reason) the programmer wanted the subfile to go into our report repository (VISTA) and set a file eq for it. Removing that eq solved our problem.

Thanks again,
/pat

>>> "Holland, Michelle" <Michelle.Holland@Cognos.COM> 08/24/01 10:16AM >>>
Hi Pat,

Fatal Error 870 occurs when Quiz is trying to write create a subfile where
the name is already used by the Operating System. For example, the file
already exists in a non-subfile format, or is used in a file equation to
point to a non-subfile.  

Do you still have the MUM100F9 file on the system from when you were
creating a portable subfile (MUM100F9 will be an ascii file - the
mini-dictionary for your portable subfile)?  Or do you have another file
with this name?  Purge the existing file or give the subfile in your Quiz
job a new name to resolve the problem.

Michelle Holland
Cognos Customer Support
Michelle.Holland@Cognos.com 

-----Original Message-----
From: Pat Shugart [mailto:ShugartP@trinity-health.org] 
Sent: Friday, August 24, 2001 9:58 AM
To: powerh-l@lists.swau.edu 
Subject: Quiz problem (QDUMP)

Listers,

We're having a strange problem occur with a Quiz routine: It will
sporadically run in a job, and always interactively. We're on version
7.29.C8 on a brand new HP e3000-979, MPEi/X version 6.5.

The routine has been run any number of ways in a job and almost always fails
with the same error message.

Originally, the subfile statement had a PORTABLE on it  -- it was going to
another system and the author wanted to convert numerics to ASCII. Now,
we're just trying to get it to work.

Any thoughts by anyone????

> ;***********************************************************
> ;* Save off flat file.                                     *
> ;***********************************************************
>  ACCESS *MUM100F6
>  DEF DEL CHAR*1 = '~'
>  REPORT SUMMARY FDATE DEL DIV# DEL CONT# DEL NAME DEL DIFF
>  SET REPORT LIMIT 3999999
>  SET SUB NAME MUM100F9 KEEP
>  GO
*Fatal Error* *870* Notify Cognos Customer Support

QDUMP dump file created

   RUN QUIZ.CURRENT.COGNOS;INFO="AUTO=MUMB100Z.QUIZUSE ";XL="*PHLIBODX
*PHLIBXL "
Program terminated in an error state. (CIERR 976)

The QDUMP file doesn't really give me a clue as to what's going on either:

Command me: print qdump.tempdata
        PC=a.00fab864 NL.PUB.SYS/stackdump_prime+$264
 NM* 0) SP=41854990 RP=a.01407dcc stackdump2+$798
        DP=c0202008 PSP=41854850 PCPRIV=2
 NM  1) SP=41854850 RP=a.01408568 STACKDUMP+$190
        DP=c0202008 PSP=41854690 PCPRIV=2
 NM  2) SP=41854690 RP=a.014083c4 ?STACKDUMP+$8
        DP=c0202008 PSP=418545d0 PCPRIV=2
          export stub: 577.000e9604 QUIZ.CURRENT.COGNOS/qAbortPh+$f8
 NM  3) SP=418545d0 RP=577.000da7e8 qMsgEditPut+$a70
        DP=41644000 PSP=41854550 PCPRIV=3
 NM  4) SP=41854550 RP=577.000da8f8 qMsgPut+$18
        DP=41644000 PSP=41853e10 PCPRIV=3
 NM  5) SP=41853e10 RP=577.000e6e3c rFError+$54
        DP=41644000 PSP=41853dd0 PCPRIV=3
 NM  6) SP=41853dd0 RP=577.000ed8cc sfcrInquiry+$934
        DP=41644000 PSP=41853d50 PCPRIV=3
 NM  7) SP=41853d50 RP=577.000929f0 zOpenSubfile+$214
        DP=41644000 PSP=41853b90 PCPRIV=3
 NM  8) SP=41853b90 RP=577.0008f028 zExecuteGo+$1b44
        DP=41644000 PSP=41853990 PCPRIV=3
 NM  9) SP=41853990 RP=577.0008f434 zCmd08Go+$a0
        DP=41644000 PSP=418536d0 PCPRIV=3
 NM  a) SP=418536d0 RP=577.0008a018 prActions+$2f4
        DP=41644000 PSP=41853690 PCPRIV=3
 NM  b) SP=41853690 RP=577.000e171c prCommand+$4dc
        DP=41644000 PSP=41853650 PCPRIV=3
 NM  c) SP=41853650 RP=577.000e1b80 prInput+$e8
        DP=41644000 PSP=41853590 PCPRIV=3
 NM  d) SP=41853590 RP=577.000e249c prParser+$28
        DP=41644000 PSP=41853450 PCPRIV=3
 NM  e) SP=41853450 RP=577.000655c0 qRunProduct+$178
        DP=41644000 PSP=41853410 PCPRIV=3
 NM  f) SP=41853410 RP=577.00064310 main+$cc
        DP=41644000 PSP=41853350 PCPRIV=3
 NM 10) SP=41853350 RP=577.001785cc _start+$7c
        DP=41644000 PSP=41853310 PCPRIV=3
 NM 11) SP=41853310 RP=577.00062f04 $START$+$1c
        DP=41644000 PSP=418521b0 PCPRIV=3
 NM 12) SP=418521b0 RP=577.00000000
        DP=41644000 PSP=41852130 PCPRIV=3
      (end of NM stack)

TIA,

<><><><><><><><><><><>
Pat Shugart
Trinity Information Services
Farmington Hills, MI 48331
248.489.6123
248.488.9195 (fax)

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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 
This list is closed, thus to post to the list you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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 
This list is closed, thus to post to the list you must be a subscriber.