Memes World Table Sanity Report: Fri Jun 09 16:12:23 PDT 2000


This report is automatically produced by a Tcl script called tabsan.
Fri Jun 09 16:12:23 PDT 2000 Checking on Sybase table definitions

NOTE : Table column tests are case-insensitized


AAAFIXTHIS ============================================================= AAAFIXTHIS

FIX! : table contains real data and has problems (see below) : metabase.dbo.Acontexts
FIX! : table contains real data and has problems (see below) : metabase.dbo.Agents
FIX! : table contains real data and has problems (see below) : metabase.dbo.Filters
FIX! : table contains real data and has problems (see below) : metabase.dbo.Gratings
FIX! : table contains real data and has problems (see below) : metabase.dbo.Mask
FIX! : table contains real data and has problems (see below) : metabase.dbo.Mcontexts
FIX! : table contains real data and has problems (see below) : metabase.dbo.Memes
FIX! : table contains real data and has problems (see below) : metabase.dbo.Mpaths
FIX! : table contains real data and has problems (see below) : metabase.dbo.Mpinouts


BADKEYVALS ============================================================= BADKEYVALS

WARN : BADKEYVALS : Mpaths pcontext -> Pcontexts pcontext, has values not in Pcontexts:
			DEIMOS.HW.interface DEIMOS.OverKTL DEIMOS.overMod.A 
			DEIMOS.overMod.B ESI.focus.proposal ESI.hardware.conn 
			Joke MOS.poc deimos.dca.figdisp deimos.dca.noaortd 
			esi.dca.figdisp esi.init esi.init.dispatcher esi.init.figdisp 
			esi.init.infoman esi.init.lickserv esi.init.traffic 
			esi.init.watch_ccd foo 
WARN : BADKEYVALS : Mpaths formid -> Formats formid, has values not in Formats:
			asc 
WARN : BADKEYVALS : Mports pname -> Mports portid, has values not in Mports:
			AIN_MUX_SEL_0 AIN_MUX_SEL_1 AIN_MUX_SEL_2 AIR_POWER_PRESSURE 
			AIR_PRESSURE_STATUS AIR_PRESS_STATUS ALS_OVERLOADED 
			ALS_RESET_CTRL ANALOG_POWER_CTRL APMSK_ENCODER_QUAL 
			APMSK_FID_OUT APMSK_SECLIM CAMERA_TEMP COLL1_ENCODER_QUAL 
			COLL1_FID_OUT COLL1_SECLIM COLL2_ENCODER_QUAL COLL2_FID_OUT 
			COLL2_SECLIM COLL3_ENCODER_QUAL COLL3_FID_OUT COLL3_SECLIM 
			COLLIMATOR COLLIMATOR_TEMP COOLANT_FLOW_STATUS COOLANT_IN_TEMP 
			COOLANT_OUT_TEMP COOLANT_PRESS_STATUS COOLING_FANS_CTRL 
			DWFIL_ENCODER_QUAL DWFIL_FID_OUT DWFIL_SECLIM DWFOC_FID_OUT 
			DWFOC_SECLIM ELECTRONICS_BOX_TEMP ELECTRONICS_TEMP 
			FRAME_1_TEMP FRAME_2_TEMP HATCH_CLOSED_IN HATCH_CLOSED_OUT 
			HATCH_OPEN_IN HATCH_OPEN_OUT IMFLT_BRAKE IMFLT_SECLIM 
			INSTRUME_POWER_CTRL IONPUMP_AC_STATUS IONPUMP_MODE 
			IONPUMP_START ION_PUMP_CURRENT LAMP_ARGON_1 LAMP_ARGON_2 
			LAMP_COPPER_1 LAMP_COPPER_2 LAMP_FAN LAMP_NEON_1 LAMP_NEON_2 
			LAMP_QUARTZ_1 LAMP_TEMP LDFLT_BRAKE LDFLT_FID_OUT 
			LDFLT_SECLIM MANU0_AMBIT MANU0_FWDBIT MANU0_LEDFWD 
			MANU0_LEDMOV MANU0_LEDREV MANU0_MODEBIT0 MANU0_MODEBIT1 
			MANU0_MODEBIT2 MANU0_REVBIT MANU0_SELBIT0 MANU0_SELBIT1 
			MANU0_SELBIT2 MANU0_STOPBIT MANU0_TOGL1BIT MANU0_TOGL2BIT 
			MANU1_AMBIT MANU1_FWDBIT MANU1_LEDFWD MANU1_LEDMOV 
			MANU1_LEDREV MANU1_MODEBIT0 MANU1_MODEBIT1 MANU1_MODEBIT2 
			MANU1_REVBIT MANU1_SELBIT0 MANU1_SELBIT1 MANU1_SELBIT2 
			MANU1_STOPBIT MANU1_TOGL1BIT MANU1_TOGL2BIT MUX_LINE_1 
			MUX_LINE_2 MUX_LINE_3 OSS_TEMP PMT_POWER_CTRL PMT_TRIGGER_CTRL 
			POWER_12_VOLT_STAT POWER_24_VOLT_STAT POWER_5_VOLT_STAT 
			PRISM_BRAKE PRISM_FID_OUT PRISM_SECLIM PRISM_TEMP 
			PROP_IN_PARK_POS PROP_IN_READ_POS SLMSK_ENCODER_QUAL 
			SLMSK_FID_OUT SLMSK_SECLIM SPEC_EXTERNAL_TEMP SPEC_INTERNAL_TEMP 
			TVFIL_FID_OUT TVFIL_SECLIM TVFOC_FID_OUT TVFOC_SECLIM 
			TVHRZ_FID_OUT TV_POWER_CTRL {10 Mb/s AUI(f)} {10 Mbps AUI(f)} 
			{10 base 2 coax (m)} {10 base T (f)} {10/100 Mb/s AUI(f)} 
			{10/100bT RJ45(f) 1} {10/100bT RJ45(f) 2} {10/100bT RJ45(f) 3} 
			{10/100bT RJ45(f) 4} {10/100bT RJ45(f) 5} {10/100bT RJ45(f) 6} 
			{10/100bT RJ45(f) 7} {10/100bT RJ45(f) 8} {17-pin MilSpec (m)} 
			{61-pin MilSpec (m)} {62.5um fiber 4Mb/s r} {62.5um fiber 4Mb/s t} 
			{62.5um fiber 50Mb/s} {AUI ethernet (f)} {AUI ethernet (m)} 
			{RJ45 10 base T (f)} {RJ45 10/100 (f)} {RJ45 serial 1} 
			{RJ45 serial 2} {RJ45 serial 3} {RJ45 serial 4} {RJ45 serial 5} 
			{RJ45 serial 6} {RJ45 serial 7} {RJ45 serial 8} {VIDEO 1 BNC (m)} 
			{VIDEO 2 BNC (m)} {Video 1 BNC (m)} {Video 2 BNC (m)} 
			{aux DB9 serial (f)} {main DB9 serial (m)} {} 
WARN : BADKEYVALS : Agents ref -> Acontexts acontext, has values not in Acontexts:
			Keck esi esifocus expo pfcam {} 
WARN : BADKEYVALS : Mpaths timid -> Timing timid, has values not in Timing:
			125 od 
WARN : BADKEYVALS : Memes mfid -> Mformats mfid, has values not in Mformats:
			0 
WARN : BADKEYVALS : Mports devmid -> Memes mid, has values not in Memes:
			0 
WARN : BADKEYVALS : Mports dispmid -> Memes mid, has values not in Memes:
			0 
WARN : BADKEYVALS : Memes context -> Mcontexts mcontext, has values not in Mcontexts:
			Applications CommandLine Concepts DEIMOS DEIMOS.Calib 
			DEIMOS.Glass DEIMOS.ccd DEIMOSdash Database Documentary 
			Environment EventLogs FIORD HFWG_R7 IRCAL KECK1ACS 
			KECK1CCDlickserv KECKCCD.deimos KECKDCS2 KTLinst KTLruntime 
			KeckCCD.ESI KeckCCD.LRIS KeckCCD.deimos KeckCCD2 KeckCCD2lickserv 
			LICK.MOS.old LICK.fubar LogTables Map MapFuncs MapTuples 
			MapUnits MemeFlow Memes MultiObjectSpect MynahCmds 
			NotYet Operation SLA SharedMemeMap Template UglyMusic 
			WCS99 ccd cleanup deimos2 deimos3 dispatch2 environment 
			esi expedient expo gdt infoman ircal lamps pfbar pfcam 
			pfcam+deimos template traffic 
WARN : BADKEYVALS : Mpaths medid -> Media medid, has values not in Media:
			FF fd ktl pap sqw 


BADPRIKEYS ============================================================= BADPRIKEYS

 ERR : BADPRIKEYS : Memes says primarykey(s) of metabase.dbo.rtDevices is/are timid 
			but Sybase says vendorid


FORKEYLIST ============================================================= FORKEYLIST

INFO : FORKEYLIST : Agents atype --> AgentTypes atype
INFO : FORKEYLIST : Memes mfid --> Mformats mfid
INFO : FORKEYLIST : Mpaths sport --> Mports portid
INFO : FORKEYLIST : Mpaths rport --> Mports portid
INFO : FORKEYLIST : Mports pname --> Mports portid
INFO : FORKEYLIST : Mpaths sendr --> Agents agentid
INFO : FORKEYLIST : Mpaths rcvr --> Agents agentid
INFO : FORKEYLIST : Mpaths ctrlr --> Agents agentid
INFO : FORKEYLIST : Mpaths owner --> Agents agentid
INFO : FORKEYLIST : Mask NCagent --> Agents agentid
INFO : FORKEYLIST : Mask MillId --> Agents agentid
INFO : FORKEYLIST : Agents owner --> Agents agentid
INFO : FORKEYLIST : Mports agentid --> Agents agentid
INFO : FORKEYLIST : Mpinouts mbid --> Mbundles mbid
INFO : FORKEYLIST : Mpaths pcontext --> Pcontexts pcontext
INFO : FORKEYLIST : Mpaths formid --> Formats formid
INFO : FORKEYLIST : Agents ref --> Acontexts acontext
INFO : FORKEYLIST : Memes isa_mid --> Memes mid
INFO : FORKEYLIST : Memes map_mid --> Memes mid
INFO : FORKEYLIST : Memes ctrl_mid --> Memes mid
INFO : FORKEYLIST : Memes rpt_mid --> Memes mid
INFO : FORKEYLIST : Memes usa_mid --> Memes mid
INFO : FORKEYLIST : Mbundles tmid --> Memes mid
INFO : FORKEYLIST : Mbundles emid --> Memes mid
INFO : FORKEYLIST : KTLconfig Atty --> Memes mid
INFO : FORKEYLIST : KTLconfig Device --> Memes mid
INFO : FORKEYLIST : KTLconfig Attribute --> Memes mid
INFO : FORKEYLIST : Mports devmid --> Memes mid
INFO : FORKEYLIST : Mports dispmid --> Memes mid
INFO : FORKEYLIST : Mpaths medid --> Media medid
INFO : FORKEYLIST : Mpaths timid --> Timing timid
INFO : FORKEYLIST : Memes context --> Mcontexts mcontext


MEMNEWCOLS ============================================================= MEMNEWCOLS

 ERR : MEMNEWCOLS : Bundle Filters contains cols not in Table metabase.dbo.Filters:
			kservice 
 ERR : MEMNEWCOLS : Bundle Gratings contains cols not in Table metabase.dbo.Gratings:
			kservice 
 ERR : MEMNEWCOLS : Bundle Mask contains cols not in Table metabase.dbo.Mask:
			bluid maskexp millbypid millid millqual 
			milltemp ncagent shiptodate shiptopid stamp 
			toolangl tooldiam uid 


SYBACCFAIL ============================================================= SYBACCFAIL

WARN : SYBACCFAIL : Cannot access table metabase.dbo.Mirrors: ERROR 229: SELECT permission denied on object Mirrors, database metabase, owner dbo
WARN : SYBACCFAIL : Cannot access table metabase.dbo.Vendor: ERROR 229: SELECT permission denied on object Vendor, database metabase, owner dbo


SYBADLENG ============================================================= SYBADLENG

 ERR : BADLENG : Table metabase.dbo.Acontexts col descrip is a char 40, 
			but meme table says varchar 255
 ERR : BADLENG : Table metabase.dbo.Agents col author is a varchar 80, 
			but meme table says varchar 40
 ERR : BADLENG : Table metabase.dbo.Alarms col uri is a varchar 100, 
			but meme table says varchar 255
 ERR : BADLENG : Table metabase.dbo.Mpaths col timid is a char 12, 
			but meme table says char 10
 ERR : BADLENG : Table metabase.dbo.Mpinouts col dwgno is a char 14, 
			but meme table says char 12
 ERR : BADLENG : Table metabase.dbo.Mpinouts col sense is a char 4, 
			but meme table says char 3
 ERR : BADLENG : Table metabase.dbo.Mpinouts col sigtype is a char 48, 
			but meme table says char 6
 ERR : BADLENG : Table metabase.dbo.Mpinouts col acctype is a char 16, 
			but meme table says char 6
 ERR : BADLENG : Table metabase.dbo.Mpinouts col accid is a char 6, 
			but meme table says char 4
 ERR : BADLENG : Table metabase.dbo.Mpinouts col pinid is a char 6, 
			but meme table says char 4


SYBADTYPE ============================================================= SYBADTYPE

 ERR : BADTYPE : Table metabase.dbo.Acontexts col descrip is type char,
			but meme table says varchar
 ERR : BADTYPE : Table metabase.dbo.KTLgrp col sidlist is type char,
			but meme table says varchar
 ERR : BADTYPE : Table metabase.dbo.Mcontexts col authority is type char,
			but meme table says varchar
 ERR : BADTYPE : Table metabase.dbo.Memes col uid is type int,
			but meme table says smallint


SYBNEWCOLS ============================================================= SYBNEWCOLS

 ERR : SYBNEWCOLS : Table metabase.dbo.Filters contains cols not in Bundle Filters:
			service 
 ERR : SYBNEWCOLS : Table metabase.dbo.Gratings contains cols not in Bundle Gratings:
			service 
 ERR : SYBNEWCOLS : Table metabase.dbo.Mask contains cols not in Bundle Mask:
			distid finish maskdec maskname maskra material 
			millby_pid pa pid shipto_pid thickness 


SYBNODATA ============================================================= SYBNODATA

WARN : SYBNODATA  : Sybase table is empty : metabase.dbo.Alarms
WARN : SYBNODATA  : Sybase table is empty : metabase.dbo.KTLgrp


SYBNOSCHEM ============================================================= SYBNOSCHEM

WARN : SYBNOSCHEM : Table does not appear in any schema : metabase.dbo.Controller
WARN : SYBNOSCHEM : Table does not appear in any schema : metabase.dbo.Filters
WARN : SYBNOSCHEM : Table does not appear in any schema : metabase.dbo.Gratings
WARN : SYBNOSCHEM : Table does not appear in any schema : metabase.dbo.
WARN : SYBNOSCHEM : Table does not appear in any schema : metabase.dbo.Mformats
WARN : SYBNOSCHEM : Table does not appear in any schema : metabase.dbo.Mirrors
WARN : SYBNOSCHEM : Table does not appear in any schema : metabase.dbo.MusicMessages
WARN : SYBNOSCHEM : Table does not appear in any schema : metabase.dbo.MusicMsgNums
WARN : SYBNOSCHEM : Table does not appear in any schema : metabase.dbo.Mvalues
WARN : SYBNOSCHEM : Table does not appear in any schema : stb.dbo.common
WARN : SYBNOSCHEM : Table does not appear in any schema : stb.dbo.guider
WARN : SYBNOSCHEM : Table does not appear in any schema : stb.dbo.hires
WARN : SYBNOSCHEM : Table does not appear in any schema : stb.dbo.stb_index
WARN : SYBNOSCHEM : Table does not appear in any schema : stb.dbo.lris
WARN : SYBNOSCHEM : Table does not appear in any schema : stb.dbo.nirc_spkl
WARN : SYBNOSCHEM : Table does not appear in any schema : stb.dbo.pcs
WARN : SYBNOSCHEM : Table does not appear in any schema : metabase.dbo.Vendor
WARN : SYBNOSCHEM : Table does not appear in any schema : telemetry.ktlw.dcs2_Log
WARN : SYBNOSCHEM : Table does not appear in any schema : KTL.service.deimos
WARN : SYBNOSCHEM : Table does not appear in any schema : telemetry.ktlw.esi_Log_1
WARN : SYBNOSCHEM : Table does not appear in any schema : telemetry.ktlw.esi_Log_2
WARN : SYBNOSCHEM : Table does not appear in any schema : omnibus.dbo.hires_Log_1
WARN : SYBNOSCHEM : Table does not appear in any schema : omnibus.dbo.hires_Log_2
WARN : SYBNOSCHEM : Table does not appear in any schema : metabase.dbo.hitmplog
WARN : SYBNOSCHEM : Table does not appear in any schema : oper.guest.mirdat
WARN : SYBNOSCHEM : Table does not appear in any schema : stb.dbo.nirc
WARN : SYBNOSCHEM : Table does not appear in any schema : omnibus.dbo.pfcam_Log
WARN : SYBNOSCHEM : Table does not appear in any schema : metabase.dbo.playpen


SYBNOXTABL ============================================================= SYBNOXTABL

WARN : SYBNOXTABL : No Sybase table exists for Meme table Amplifier
WARN : SYBNOXTABL : No Sybase table exists for Meme table CCD
WARN : SYBNOXTABL : No Sybase table exists for Meme table Coeff1
WARN : SYBNOXTABL : No Sybase table exists for Meme table Coeff2
WARN : SYBNOXTABL : No Sybase table exists for Meme table Controller
WARN : SYBNOXTABL : No Sybase table exists for Meme table Defect
WARN : SYBNOXTABL : No Sybase table exists for Meme table DefectType
WARN : SYBNOXTABL : No Sybase table exists for Meme table Dewar
WARN : SYBNOXTABL : No Sybase table exists for Meme table Lambdas
WARN : SYBNOXTABL : No Sybase table exists for Meme table Layers
WARN : SYBNOXTABL : No Sybase table exists for Meme table Maintain
WARN : SYBNOXTABL : No Sybase table exists for Meme table MusicMsgNums
WARN : SYBNOXTABL : No Sybase table exists for Meme table Mvalues
WARN : SYBNOXTABL : No Sybase table exists for Meme table STBcommon
WARN : SYBNOXTABL : No Sybase table exists for Meme table STBguider
WARN : SYBNOXTABL : No Sybase table exists for Meme table STBhires
WARN : SYBNOXTABL : No Sybase table exists for Meme table STBindex
WARN : SYBNOXTABL : No Sybase table exists for Meme table STBlris
WARN : SYBNOXTABL : No Sybase table exists for Meme table STBnspkl
WARN : SYBNOXTABL : No Sybase table exists for Meme table STBpcs
WARN : SYBNOXTABL : No Sybase table exists for Meme table SelfTable
WARN : SYBNOXTABL : No Sybase table exists for Meme table Setup
WARN : SYBNOXTABL : No Sybase table exists for Meme table Spectra
WARN : SYBNOXTABL : No Sybase table exists for Meme table Waveform
WARN : SYBNOXTABL : No Sybase table exists for Meme table ccdTest
WARN : SYBNOXTABL : No Sybase table exists for Meme table dcs2_Log
WARN : SYBNOXTABL : No Sybase table exists for Meme table deimosA
WARN : SYBNOXTABL : No Sybase table exists for Meme table esi_Log_1
WARN : SYBNOXTABL : No Sybase table exists for Meme table esi_Log_2
WARN : SYBNOXTABL : No Sybase table exists for Meme table hires_Log_1
WARN : SYBNOXTABL : No Sybase table exists for Meme table hires_Log_2
WARN : SYBNOXTABL : No Sybase table exists for Meme table hitmplog
WARN : SYBNOXTABL : No Sybase table exists for Meme table mirdat
WARN : SYBNOXTABL : No Sybase table exists for Meme table nirc
WARN : SYBNOXTABL : No Sybase table exists for Meme table pfcam_Log
WARN : SYBNOXTABL : No Sybase table exists for Meme table playpen
WARN : SYBNOXTABL : No Sybase table exists for Meme table rtConfigs
WARN : SYBNOXTABL : No Sybase table exists for Meme table rtDeviceDescrip
WARN : SYBNOXTABL : No Sybase table exists for Meme table rtDevices


XXXCHKTABL ============================================================= XXXCHKTABL

INFO : SANCHKTABL : Table has 00015 records, s/b checked: metabase.dbo.Acontexts
INFO : SANCHKTABL : Table has 00010 records, s/b checked: metabase.dbo.AgentTypes
INFO : SANCHKTABL : Table has 00172 records, s/b checked: metabase.dbo.Agents
INFO : SANCHKTABL : Table has 00007 records, s/b checked: metabase.dbo.Filters
INFO : SANCHKTABL : Table has 00043 records, s/b checked: metabase.dbo.Formats
INFO : SANCHKTABL : Table has 00004 records, s/b checked: metabase.dbo.Gratings
INFO : SANCHKTABL : Table has 01955 records, s/b checked: metabase.dbo.KTLconfig
INFO : SANCHKTABL : Table has 00022 records, s/b checked: metabase.dbo.Mask
INFO : SANCHKTABL : Table has 06720 records, s/b checked: metabase.dbo.Mbundles
INFO : SANCHKTABL : Table has 00071 records, s/b checked: metabase.dbo.Mcontexts
INFO : SANCHKTABL : Table has 00031 records, s/b checked: metabase.dbo.Media
INFO : SANCHKTABL : Table has 04079 records, s/b checked: metabase.dbo.Memes
INFO : SANCHKTABL : Table has 00111 records, s/b checked: metabase.dbo.Mformats
INFO : SANCHKTABL : Table has 00292 records, s/b checked: metabase.dbo.Mpaths
INFO : SANCHKTABL : Table has 00442 records, s/b checked: metabase.dbo.Mpinouts
INFO : SANCHKTABL : Table has 00226 records, s/b checked: metabase.dbo.Mports
INFO : SANCHKTABL : Table has 00643 records, s/b checked: metabase.dbo.MusicMessages
INFO : SANCHKTABL : Table has 00004 records, s/b checked: metabase.dbo.pcontexts
INFO : SANCHKTABL : Table has 00013 records, s/b checked: metabase.dbo.Timing

Questions about this report? talk to de@ucolick.org