English French Notes Complete/Exclude of table INDEX PRIMARY KEY: COLUMN ELEMENT INSERT FAILED INDEX PRIMARY KEY: COLUMN INSERT FAILED INDEX PRIMARY KEY: TABLE ELEMENT INSERT FAILED FOREIGN KEY: NO POINTED-TO FILE IN SPECIFIER FOREIGN KEY: NO TABLE FOR POINTED-TO FILE FOREIGN KEY: NO PRIMARY KEY TABLE ELEMENT FOREIGN KEY: NO ASSOCIATED PRIMARY KEY Foreign key to FOREIGN KEY: TABLE ELEMENT INSERT FAILED FOREIGN KEY: COLUMN ELEMENT INSERT FAILED Foreign key to ancestor FOREIGN KEY: ANCESTOR FOREIGN KEY INSERT FAILED FOREIGN KEY: NO POINTED-TO COLUMN AT LEVEL FOREIGN KEY: NO ANCESTOR PRIMARY KEY FOREIGN KEY: ANCESTOR FOREIGN KEY COLUMN INSERT FAILED INDEX: MISSING DATA DICTIONARY DATA INDEX: IRREGULAR FORMAT INDEX: NO ASSOCIATED COLUMN RECORD Index of INDEX: TABLE INSERT FAILED INDEX: TABLE DOMAIN INSERT FAILED Primary key header for INDEX: PRIMARY KEY ELEMENT INSERT FAILED Index Primary Key # INDEX: COLUMN ELEMENT INSERT FAILED INDEX: COLUMN INSERT FAILED INDEX: PRIMARY KEY INSERT FAILED NO POINTERS You need 'Read' access to one SQLI file to run this report. It is file 1.5212. Contact your system manager to be granted single file access. TABLES POINTING TO FROM TABLE: VIA FOREIGN KEY: TABLES POINTED-TO BY TO TABLE: VA FOREIGN KEY: DMSQ( SQLI TABLE COUNT (EXCLUDING INDEX-TYPE) REGULAR TABLES SQLI COLUMN COUNT FOR ALL TABLES SQLI INDEX COUNT (INDEX-TYPE TABLES) SQLI TABLE ELEMENT TYPE TOTALS TYPE= SQLI COLUMN TOTALS BY TABLE TABLE: SQLI TABLES SORTED BY TOTAL COLUMNS COLUMN COUNT: SQLI COLUMN COUNT FOR REGULAR TABLES (EXCLUDING INDEXES) SQLI COLUMN COUNT, REGULAR TABLES, EXCLUDING TABLE_IDS SQLI COLUMN COUNT BY DOMAIN (REGULAR TABLES, EXCLUDING TABLE_IDS) DOMAIN= You need 'Read' access to four SQLI files to run this report. They are files 1.5211, 1.5212, 1.5214, and 1.5216. Starting File Number Enter the number of the file, e.g. 200 or 1.5215 SQLI table not found. Ending File Number Optionally enter a larger number for a range, e.g. 1.5217 There isn't a table for the file number you've entered. (The highest possible number is Enter a LARGER number to get a range. The highest possible number here is SQLI PROJECTION OF FIELDS AS COLUMNS INTERNAL(#4);C1;S;X,.01;C15;X,7;C15;X,5;C42;X, OF_DATA_TYPE: OF_EXT_EXPR: DM_DATA_TYPE: DM_WIDTH/DM_SCALE: SQLI TABLE NAME: FILE NUMBER: INTERNAL(#6); FILE# FILEMAN FILE NAME SQLI TABLE NAME SQLI TABLES BY FILE NUMBER (1) SELF Tables with Self-referential Pointers (2) UP Tables with Upward Links (3) DOWN Tables Linked from Below (4) OUT Tables Pointing Outward (5) IN Tables with Incoming Pointers (9) QUIT Exit this Menu Select a report: This can take 1-2 minutes. Continue These reports show counts. Or would you prefer details WORD_PROCESSING Please wait... SQLI TABLE POINTER COUNTS FILE/SUBFILE: WORD-PROCESSING TABLE? SELF-REFERENTIAL POINTERS: POINTERS DOWNWARD TO THIS SUBFILE: POINTERS UPWARD FROM DEEPER SUBFILES: POINTERS OUTWARD TO OTHER FILES: POINTERS INWARD FROM OTHER FILES: SQLI WORD-PROCESSING TABLE - SUBSET OF SUBFILES WORD-PROCESSING? SQLI POINTING TABLE - SELF-REFERENTIAL POINTERS TIMES POINTED-TO BY ITSELF: - UPWARD FROM THIS SUBFILE LEVEL TIMES POINTING UPWARD (SUBFILE LEVELS): SQLI POINTED-TO TABLE - UP FROM ONE OR MORE SUBFILE LEVELS TIMES POINTED-TO FROM BELOW: (EXCLUDES SUBFILE POINTERS) TIMES POINTING (GOING OUTWARD): TIMES POINTED-TO (COMING INWARD): WARNING: REPORT JUST WRITES TO THE SCREEN WITHOUT PAGE BREAKS (INTENDED FOR SCREEN CAPTURES) SO PICK ONE TABLE OR A SMALL RANGE WHEN TESTING LABEL;TYPE TBL: COL: SUBFILE OF: This can take 5-10 minutes. Continue Maximum pointing references This cutoff is used as an upper limit on pointer links. Tables with more links than this upper limit are displayed as the set of shared tables. Others with common pointer links are then grouped together. The resulting subsets could be used in SQL Grant statements. Try using cutoffs between 3 and 10, comparing results. Select a Table of Special Interest (Optional): LISTING OF SHARED TABLES SHARED TABLES = (CUTOFF OF DETAILED GROUP REPORT DETAIL OF GROUPS = GROUP: COMPLETE REPORT OF ALL GROUPS TABLE GROUPS = TABLE COUNT= PRINT OF JUST ONE GROUP (INCLUDING THE SPECIFIED TABLE) The selected table doesn't fall in a group; see the shared set. There isn't a group for the selected table; it doesn't have pointer links. GROUP INCLUDING ...... Please wait. Reports take a few minutes to process ...... FileMan SQL/ODBC interface tables SCHEMA: RECORD INSERT FAILED STATS: RECORD INSERT FAILED STATS: KEY COUNT INSERT FAILED EDIT-PROTECTING SQLI FILES... EDIT-UNPROTECTING SQLI FILES... Try again later. An SQLI projection is running right now. It might take a few hours to finish, but then you can try again and get a final status report. SQLI DIAGNOSTICS REPORT No date associated with first SQLI Table record. No dates found in the SQLI Error Log. Different dates on Table and Error Log files. LAST SQLI TABLE UPDATE: LAST SQLI ERROR UPDATE: SQLI was run in the past. DDs may have changed since then. No SQLI Schema records. Has the SQLI projection been run? No records in the SQLI Table file. All regular tables appear to have been built. Not all files appear to have been built as tables. The last regular file to be processed was The next one, file may be the problem. The next one, subfile No records in the SQLI Column file. Columns have been built for the last table processed. It looks like not all columns were processed. The last file processed was The last field processed was The next field to be processed looks like Having finished with all fields of , SQLI was probably trying to process , the next file. The last one ( ) is a subfile of It is field of file That looks like the last field in The next file to be processed looks like The next subfile to be processed looks like SUGGESTION: Investigate this file/subfile as the potential source of the problem. That's: No foreign key records have been built. No table elements have been built for foreign keys. All regular foreign keys have been built (FKs). Parent foreign keys (PFKs) have also been built, the last one being for file/subfile Only regular foreign keys (FKs) have been processed. The last was for file/subfile No records for SQLI index tables. Index tables don't appear to have been built. Index processing stopped at file All index tables appear to have been built. The last was for No problems detected in SQLI data structures themselves. Problems found in SQLI data structures. See SQLI Site Manual, trouble-shooting section, for ideas about how to investigate the problem. For example, RUNONE^DMSQ may be used to explore a potential problem file. DI,DIQUIET,DIFM Time elapsed: FIELD: CALL TO RETRIEVE ATTRIBUTES FAILED DECIMAL DEFAULT FM_MUMPS SET_OF_CODES FM_DATE_TIME FM_MOMENT FM_DATE FM_FLAG VARIABLE_POINTER FM_MUMPS^245 Unable to proceed. Fileman version node ^DD( ) is undefined. Unable to proceed. 0th node of ^DPT missing Fileman version must be at least 17.2 Answer with PATIENT NAME, or SOCIAL SECURITY NUMBER, or last 4 digits of SOCIAL SECURITY NUMBER, or first initial of last name with last 4 digits of SOCIAL SECURITY NUMBER -Entry PATIENT List Load/Edit Patient Data Register a Patient ...Patient not in database, use ADT options to load patient Patient not found...Create stub entry: Could not add patient to patient file There is more than one patient whose last name is ' whose social security number ends with ' Are you sure you wish to continue (Y/N) Warning : You have selected a test patient. IORVOFF;IORVON *** PATIENT ENROLLMENT END *** PATIENT ENROLLMENT ENDING. ENROLLMENT END DATE IS NOT KNOWN. *** Combat Vet Status: BS5,CN,RM CN,RM BS,SSN,CN,RM SSN,CN,RM CN,RM,BS,SSN CN,RM,SSN ADDITIONAL MATCHES FOUND BUT NOT RETURNED ENTER '^' TO STOP, OR ADDITIONAL MATCHES FOUND BUT NOT Unable to Add Patient. Your Fileman Access Code is undefined. ...adding new patient Please enter the following additional information: A NEW PATIENT (THE Enter 'YES' to add a new applicant, or 'NO' not to. Sorry, '^' not allowed! Entry in ) refers to this patient Unable to search for potential duplicates, Date of Birth and Social Security Number must be defined. ...searching for potential duplicates No potential duplicates have been identified. The following patients have been identified as potential duplicates: Do you still want to add ' ' as a new patient Enter 'YES' to add new patient, or 'NO' not to. -1^required parameter not passed -1^Could not add patient to patient file and whose social security number ends with Are you sure you wish to continue? Patient name components-- Family name cannot be deleted! (deletion indicated) Invalid values to file, full name must be at least 3 characters! Ok to file ' ' and its name components Indicate if the edits to the name and its components should be filed. WARNING: Do not enter single name values for patients (no given or first name) unless this is actually their legal name!!! Are you sure you want to enter the patient name in this manner Specify 'YES' to enter a single name value, or 'NO' to discontinue. Input values less than 3 characters in length must be all alpha characters. middle name. Middle names of 'NMI' and 'NMN' are prohibited. name prefix, such as MR or MS. suffix(es), such as JR, SR, II, or II. academic degree, such as BS, BA, MD, or PHD. Answer with this persons The response must be characters in length and may only contain uppercase alpha characters, spaces, hyphens and apostrophes. While editing name components, only jumping to other components is allowed! Edited: >>> Changing name of 'IRT TYPE OF RECORD' file (#393.3) to 'IRT TYPE OF DEFICIENCY'... .01///IRT TYPE OF DEFICIENCY >>> Initialization of Version of DPT Complete. -1^No detailed description found Data -1^Getting submultiples not supported. -1^Only a single field number allowed with the W flag -1^The W flag must be used by itself -1^No data retrieved Field number -1^Error Message -1^Error text FILE, VALUE, #################### #################### #################### #################### #################### #################### #################### #################### #################### #################### #################### #################### #################### #################### ####################