I wrote a tool to call SYSCS_UTIL.SYSCS_CHECK_TABLE on each table in the
database and not just stop on error.
I have a database returns the error:
Checking CORE_V1.DEVICE_ENTITY failed with exception: Restore of a
serializable or SQLData object of class , attempted to read more data than was
originally stored
The table has 1261157 rows in it. I can query each of the columns in the
table individually like:
SELECT ID FROM CORE_V1.DEVICE_ENTITY;
SELECT DTYPE FROM CORE_V1.DEVICE_ENTITY;
...
SELECT DESCRIPTION FROM CORE_V1.DEVICE_ENTITY;
These all return 1261157 rows for each select result.
If I select multiple columns such as
SELECT ID, DTYPE FROM CORE_V1.DEVICE_ENTITY;
Then I get:
ERROR XSDA7: Restore of a serializable or SQLData object of class , attempted
to read more data than was originally stored
ERROR XJ001: Java exception: ': java.io.EOFException'.
ij>
The table schema looks like:
ij> describe core_v1.device_entity;
COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
DTYPE |VARCHAR |NULL|NULL|64 |NULL |128 |YES
OPLOCK |INTEGER |0 |10 |10 |0 |NULL |NO
RELATIVE_POSITION |SMALLINT |0 |10 |5 |NULL |NULL |YES
ALIAS_NAME |VARCHAR |NULL|NULL|255 |NULL |510 |YES
DESCRIPTION |VARCHAR |NULL|NULL|255 |NULL |510 |YES
DEVICE_NAME |VARCHAR |NULL|NULL|255 |NULL |510 |YES
PARENTENTITY_ID |INTEGER |0 |10 |10 |NULL |NULL |YES
ID |INTEGER |0 |10 |10 |NULL |NULL |NO
8 rows selected
I am trying to figure out how to recover and correct this table. Once thought
is to query each column separately and then join the output externally back
together and re-import the data. I wonder however if I query each column if
the order of the rows returned will be the same. This will be necessary
because I cannot select the ID with the other column to identify the rows.
Any thoughts will be most welcome.
Canoga Perkins
20600 Prairie Street
Chatsworth, CA 91311
(818) 718-6300
This e-mail and any attached document(s) is confidential and is intended only
for the review of the party to whom it is addressed. If you have received this
transmission in error, please notify the sender immediately and discard the
original message and any attachment(s).
