Tom I’ve seen this happen when someone is trying to make a structure change while there are users in the database. It also has happened for reasons unknown.
What I have done in the past was to get the RB1 (one I know wasn’t a problem) copy it to the current database. You will then have to RBSYNC. Next run a reload you get a lot of errors with the counts not matching. After that unload the database structure and data. Recreate the database from the unload. One thing you might want to try is R:Scope before trying anything else. I guess it goes without saying make a copy of the database before doing anything. Buddy From: [email protected] [mailto:[email protected]] On Behalf Of TOM HART Sent: Tuesday, June 09, 2015 10:36 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Strange sys_table I had posted about the corrupt database which is giving my fits, what I have found out is that a temp table shows up as a sys_table as follows(the highlighted is the temp table) SYS_TABLE_QUAL SYS_TABLE_OWNER SYS_TABLE_NAME SYS_TABLE_TYPE SYS_COMMENT SYS_SCHEMA_NAME SYS_TABLE_ID SYS_NUM_COLUMNS SYS_NUM_ROWS SYS_ROW_SIZE SYS_TEMPORARY NONE SYS_COMMENTS SYSTEM TABLE temp1 1 2 238 4104 NONE SYS_DEFAULTS SYSTEM TABLE temp1 2 4 8 80 NONE SYS_RULES SYSTEM TABLE temp1 3 6 4 4120 NONE SYS_VIEWS SYSTEM TABLE temp1 4 3 2 4108 NONE SYS_CONSTRAINTS SYSTEM TABLE temp1 7 7 30 4124 NONE SYS_TABLES SYSTEM TABLE temp1 8 11 -4 4200 NONE SYS_COLUMNS SYSTEM TABLE temp1 9 14 -4 4170 NONE SYS_INDEXES SYSTEM TABLE temp1 10 24 -4 138 NONE SYS_FORMS SYSTEM TABLE temp1 11 3 92 NONE SYS_REPORTS SYSTEM TABLE temp1 12 3 92 NONE SYS_LABELS SYSTEM TABLE temp1 13 3 92 NONE SYS_LAYOUTS SYSTEM TABLE temp1 14 2 4138 NONE SYS_TYPES SYSTEM TABLE temp1 15 14 -4 4170 NONE SYS_FORMS2 SYSTEM TABLE temp1 16 4 4152 NONE tomtinventorytab SYSTEM TABLE inventory table temp1 17 23 -16 274 NONE SYS_LABELS2 SYSTEM TABLE temp1 18 4 4152 NONE SYS_SERVERS SYSTEM TABLE temp1 19 4 4112 NONE SYS_PROCEDURES SYSTEM TABLE temp1 20 10 4164 NONE SYS_PROC_MODS SYSTEM TABLE temp1 21 8 4156 NONE SYS_PROC_COLS SYSTEM TABLE temp1 22 10 4136 NONE SYS_TRIGGERS SYSTEM TABLE temp1 23 4 16 NONE SYS_FORMS3 SYSTEM TABLE temp1 24 5 130 4168 NONE SYS_REPORTS3 SYSTEM TABLE temp1 25 5 52 4168 NONE SYS_LABELS3 SYSTEM TABLE temp1 26 5 7 4168 NONE SYS_MERGE SYSTEM TABLE temp1 27 6 4172 NONE SYS_LAYOUTS3 SYSTEM TABLE temp1 28 3 4154 What happened? If I do a reload it is still there. I also have tried unloading but Rbase crashes. Any help Tom Hart
