Memes World Table Sanity Report: Fri Jun 09 16:18:38 PDT 2000
This report is automatically produced by a Tcl script called tabsan.
Fri Jun 09 16:18:38 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.ESI KECKCCD.LRIS KECKCCD.deimos
KECKCCD2 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 10330: SELECT permission denied on object Mirrors, database metabase, owner dbo
WARN : SYBACCFAIL : Cannot access table metabase.dbo.Vendor: ERROR 10330: 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 01807 records, s/b checked: metabase.dbo.KTLconfig
INFO : SANCHKTABL : Table has 00022 records, s/b checked: metabase.dbo.Mask
INFO : SANCHKTABL : Table has 06782 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 04109 records, s/b checked: metabase.dbo.Memes
INFO : SANCHKTABL : Table has 00108 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