Veridata Repair Fails With Ora-00932: Inconsistent Datatypes Expected MDSYS.SDO_GEOMETRY Got Binary (Doc ID 1938826.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate Veridata - Version 11.2.1.0.3 and later
Information in this document applies to any platform.

Symptoms

Veridata repair of spatial type object fails with 'ORA-00932: inconsistent datatypes: expected MDSYS.SDO_GEOMETRY got BINARY

Repair job fails with:

2014-10-21 15:02:23 Submitted (1 of 1) Group (slc03qht11g_slc03qht11g),
Compare Pair (SCOLA_MARKETS=TCOLA_MARKETS) RunId (1015,1,1).
2014-10-21 15:02:23 Abended with errors. Group (slc03qht11g_slc03qht11g),
Compare Pair (SCOLA_MARKETS=TCOLA_MARKETS). (0) Remaining

Agent log shows:

[2014-10-21T15:02:23.274-07:00] [veridata] [ERROR] [OGGVDT-60065]
[oracle.verida
ta.agent] [tid: 41] [ecid:
ab4eb082-05d5-4a91-aca5-5aefd8d2431e-0000031f,0:17:1:
2:2] Caught unexpected SQL exception: 932 retry= false
[2014-10-21T15:02:23.275-07:00] [veridata] [ERROR] [OGGV-60078]
[oracle.veridata
.agent] [tid: 41] [ecid:
ab4eb082-05d5-4a91-aca5-5aefd8d2431e-0000031f,0:17:1:2:
2] Repair apply failed: code: 932, msg: 'ORA-00932: inconsistent datatypes:
expected MDSYS.SDO_GEOMETRY got BINARY[[



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms