Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Info |  Source |  Entry Points |  Interaction Calls
Print Page as PDF
Routine: DMSQT

Package: VA FileMan

Routine: DMSQT


Information

DMSQT ;SFISC/EZ-TROUBLE SHOOTING ;11/13/97 12:25

Source Information

Source file <DMSQT.m>

Entry Points

Name Comments DBIA/ICR reference
EN ; main driver logic
; follows flow of ALLF^DMSQF, checking that each step completed
DQ
INIT ; initialize variables
PAGE
DATE ; check when projection run, compare with today
SCHEMA ; check if schema node set
A ; were all regular tables built?
B ; were all columns built?
BADFILE(NUM) ;
C ; were all foreign keys built?
D ; were all index tables built?
DONE ; come here if all checks succeed
ERROR ; come here on error
EXIT

Interaction Calls

Name Line Occurrences
Function Call: WRITE
  • Prompt: !?5,"Try again later. An SQLI projection is running right"
  • Line Location: EN+3
Function Call: WRITE
  • Prompt: !?5,"now. It might take a few hours to finish, but then you"
  • Line Location: EN+4
Function Call: WRITE
  • Prompt: !?5,"can try again and get a final status report."
  • Line Location: EN+5
Function Call: WRITE
  • Prompt: @IOF
  • Line Location: PAGE+0
Function Call: WRITE
  • Prompt: !?10," TODAY'S DATE: ",Y,!
  • Line Location: DATE+1
Function Call: WRITE
  • Prompt: !?5,"No date associated with first SQLI Table record."
  • Line Location: DATE+3
Function Call: WRITE
  • Prompt: !?5,"No dates found in the SQLI Error Log."
  • Line Location: DATE+5
Function Call: WRITE
  • Prompt: !?5,"Different dates on Table and Error Log files."
  • Line Location: DATE+7
Function Call: WRITE
  • Prompt: !?10,"LAST SQLI TABLE UPDATE: ",Y
  • Line Location: DATE+8
Function Call: WRITE
  • Prompt: !?10,"LAST SQLI ERROR UPDATE: ",Y,!
  • Line Location: DATE+9
Function Call: WRITE
  • Prompt: !?5,"SQLI was run in the past. DDs may have changed since then.",!
  • Line Location: DATE+12
Function Call: WRITE
  • Prompt: !?5,"No SQLI Schema records. Has the SQLI projection been run?"
  • Line Location: SCHEMA+2
Function Call: WRITE
  • Prompt: !!?5,"No records in the SQLI Table file."
  • Line Location: A+2
Function Call: WRITE
  • Prompt: !?5,"All regular tables appear to have been built."
  • Line Location: A+4
Function Call: WRITE
  • Prompt: !!?5,"Not all files appear to have been built as tables."
  • Line Location: A+6
Function Call: WRITE
  • Prompt: !?5,"The last regular file to be processed was ",DMLFILE,"."
  • Line Location: A+7
Function Call: WRITE
  • Prompt: !?5,"The next one, file ",DMNFILE," may be the problem."
  • Line Location: A+9
Function Call: WRITE
  • Prompt: !?5,"The next one, subfile ",DMNFILE," may be the problem."
  • Line Location: A+13
Function Call: WRITE
  • Prompt: !!?5,"No records in the SQLI Column file."
  • Line Location: B+2
Function Call: WRITE
  • Prompt: !!?5,"Columns have been built for the last table processed."
  • Line Location: B+6
Function Call: WRITE
  • Prompt: !!?5,"It looks like not all columns were processed."
  • Line Location: B+8
Function Call: WRITE
  • Prompt: !?5,"The last file processed was ",DMLCFILE,"."
  • Line Location: B+12
Function Call: WRITE
  • Prompt: !?5,"The last field processed was ",DMLCFLD,"."
  • Line Location: B+13
Function Call: WRITE
  • Prompt: !!?5,"The next field to be processed looks like ",DMNCFLD,"."
  • Line Location: B+15
Function Call: WRITE
  • Prompt: !?5,"Having finished with all fields of ",DMLCFILE,", SQLI was probably"
  • Line Location: B+18
Function Call: WRITE
  • Prompt: !?5,"trying to process ",DMNCFILE,", the next file."
  • Line Location: B+19
Function Call: WRITE
  • Prompt: !?5,"The last one (",DMLCFILE,") is a subfile of ",DMPARENT,"."
  • Line Location: B+22
Function Call: WRITE
  • Prompt: !?5,"It is field ",DMTOPFLD," of file ",DMPARENT,"."
  • Line Location: B+24
Function Call: WRITE
  • Prompt: !?5,"The next field to be processed looks like ",DMNXTFLD,"."
  • Line Location: B+26
Function Call: WRITE
  • Prompt: !?5,"That looks like the last field in ",DMPARENT,"."
  • Line Location: B+29
Function Call: WRITE
  • Prompt: !?5,"The next file to be processed looks like ",DMNEXTF,"."
  • Line Location: B+32
Function Call: WRITE
  • Prompt: !?5,"The next subfile to be processed looks like ",DMNEXTSF,"."
  • Line Location: B+35
Function Call: WRITE
  • Prompt: !!?5,"SUGGESTION: Investigate this file/subfile as the potential"
  • Line Location: BADFILE+4
Function Call: WRITE
  • Prompt: !?5,"source of the problem. That's: ",NUM," ",DMNAME,!
  • Line Location: BADFILE+5
Function Call: WRITE
  • Prompt: !!?5,"No foreign key records have been built."
  • Line Location: C+2
Function Call: WRITE
  • Prompt: !?5,"No table elements have been built for foreign keys."
  • Line Location: C+5
Function Call: WRITE
  • Prompt: !!?5,"All regular foreign keys have been built (FKs)."
  • Line Location: C+12
Function Call: WRITE
  • Prompt: !?5,"Parent foreign keys (PFKs) have also been built, the"
  • Line Location: C+13
Function Call: WRITE
  • Prompt: !?5,"last one being for file/subfile ",DMFKFILE,"."
  • Line Location: C+14
Function Call: WRITE
  • Prompt: !!?5,"Only regular foreign keys (FKs) have been processed."
  • Line Location: C+16
Function Call: WRITE
  • Prompt: !?5,"The last was for file/subfile ",DMFKFILE,"."
  • Line Location: C+17
Function Call: WRITE
  • Prompt: !!?5,"No records for SQLI index tables."
  • Line Location: D+2
Function Call: WRITE
  • Prompt: !!?5,"Index tables don't appear to have been built."
  • Line Location: D+4
Function Call: WRITE
  • Prompt: !!?5,"Index processing stopped at file ",DMLOF,"."
  • Line Location: D+11
Function Call: WRITE
  • Prompt: !!?5,"All index tables appear to have been built. The last was for"
  • Line Location: D+13
Function Call: WRITE
  • Prompt: !?5,"file/subfile ",$P(^DMSQ("T",DMASTER,0),U,7),"."
  • Line Location: D+14
Function Call: WRITE
  • Prompt: !!?5,"No problems detected in SQLI data structures themselves.",!
  • Line Location: DONE+1
Function Call: WRITE
  • Prompt: !!?5,"Problems found in SQLI data structures."
  • Line Location: ERROR+1
Function Call: WRITE
  • Prompt: !?5,"---------------------------------------"
  • Line Location: ERROR+2
Function Call: WRITE
  • Prompt: !?5,"See SQLI Site Manual, trouble-shooting section, for ideas about"
  • Line Location: ERROR+3
Function Call: WRITE
  • Prompt: !?5,"how to investigate the problem. For example, RUNONE^DMSQ may be"
  • Line Location: ERROR+4
Function Call: WRITE
  • Prompt: !?5,"used to explore a potential problem file."
  • Line Location: ERROR+5
Info |  Source |  Entry Points |  Interaction Calls