oncheck -cc reporting Errors on sysmaster
Posted in 2005
Topics: Error Codes & Troubleshooting, Data Types & Schema Design
Hi,
During oncheck -cc against sysmaster Errors are being generatad:
ERROR: No table found for syscolumns record.
ISAM error: no record found.Column name iso_cod
Tabid 360
Column number 1
Column type 256
These records refer to tabid-s not present in the systables table.
Can I delete these records (also in sysconstraints, systabauth and sysindexes)?
No errors are reported on systables table.
I was thinking about:
delete from syscolumns where tabid not in
(select tabid from sysmaster:systables);
But I am not very comfortable with hacking in the sysmaster database.
Can I please have your comments?
Thank you.
I
wouldn't. Hope your support contract's up-to-date this is a job for tech
support.
Art S. Kagel
----- Original Message -----
From: Gerrit Leppers <gelepper@q8.nl>
At: 10/13 10:38
Hi,
During oncheck -cc against sysmaster Errors are being generatad:
ERROR: No table found for syscolumns record.
ISAM error: no record found.Column name iso_cod
Tabid 360
Column number 1
Column type 256
These records refer to tabid-s not present in the systables table.
Can I delete these records (also in sysconstraints, systabauth and sysindexes)?
No errors are reported on systables table.
I was thinking about:
delete from syscolumns where tabid not in
(select tabid from sysmaster:systables);
But I am not very comfortable with hacking in the sysmaster database.
Can I please have your comments?
Thank you.
FYI
A few years back with version 7.3, I recreated the sysmaster database.
Of course, I had the tech support on line talking to me.
Thank you,
Kannan Thirugnanam
-----Original Message-----
From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On
Behalf Of ART KAGEL, ....
Sent: Friday, October 14, 2005 9:22 AM
To: ids@iiug.org
Subject: Re: oncheck -cc reporting Errors on sysmaster [5832]
I wouldn't. Hope your support contract's up-to-date this is a job for
tech
support.
Art S. Kagel
----- Original Message -----
From: Gerrit Leppers <gelepper@q8.nl>
At: 10/13 10:38
Hi,
During oncheck -cc against sysmaster Errors are being generatad:
ERROR: No table found for syscolumns record.
ISAM error: no record found.Column name iso_cod
Tabid 360
Column number 1
Column type 256
These records refer to tabid-s not present in the systables table.
Can I delete these records (also in sysconstraints, systabauth and
sysindexes)?
No errors are reported on systables table.
I was thinking about:
delete from syscolumns where tabid not in
(select tabid from sysmaster:systables);
But I am not very comfortable with hacking in the sysmaster database.
Can I please have your comments?
Thank you.
***** Jackson Hewitt Email Disclaimer *****
The sender believes that this E-mail and any attachments were free of any
virus, worm,
Trojan horse, and/or malicious code when sent. This message and its
attachments could
have been infected during transmission. By reading the message and opening any
attachments, the recipient accepts full responsibility for taking protective
and remedial
action about viruses and other defects. The sender's business entity is not
liable for any
loss or damage arising in any way from this message or its attachments.
Privileged/Confidential Information may be contained in this message. If you
are not the
addressee indicated in this message (or responsible for delivery of the
message to such
person), you may not copy or deliver this message to anyone. In such case, you
should
destroy this message and kindly notify the sender by reply email.