Return
-
Title
Repair fails on a table with SDO_GEOMETRY datatype when run with onepass option -
Description
The following errors are observed in compare server log (declt log) when running repair on a table with SDO_GEOMETRY datatype when run with onepass option:
desvr 2016-12-12 12:35:27.037992 22874 2 [1] Warning 145 failed to read 8 bytes (de_sock_read,L789) (socket desc=30)
desvr 2016-12-12 12:35:27.050126 22874 2 [1] Warning 145: Connection timed out (de_sock_read,L791)
desvr 2016-12-12 12:35:28.050444 22874 2 [1] Error 1 calling de_sock_read (de_msg_receive_header,L77)
-
Cause
The “onepass” option is not supported for table with SDO_GEOMETRY datatype.
-
Resolution
Run a repair without “onepass” option. If locks on the table are difficult to acquire, then run the repair during quiet times.
-
Additional Information
This restriction of running “onepass” option is expected to be lifted in future versions of SharePlex. The error messages also come in other forms though they do not indicate that the option is not supported.