Synchronize Replica Failed (ORA-00936: missing expression)

[MarceloEdy_Peinado]

Hello,

I have a problem when I try synchronize my replica with the enterprise geodatase in Oracle.

The error message said:

---------------------------
Synchronize Replica Failed
---------------------------
Synchronize Replica failed
Underlying DBMS error [ORA-00936: missing expression
] [OWNER.table_name]

Somebody already had the same problem?

The curious is that we have others replica working without problem!

Thanks.

Marcelo E. Peinado
GIS Analyst
Optimus GIS & IT Solutions

[MarceloEdy_Peinado]

Hi Marcelo,

Have you recently made any changes to the schema of the layers in the database OR have you added any layers to either of the database?

Have you checked the replica manager and validated the schema, you may also want to try and manually export data changes messages and import messages...

You may want to include the version of ArcGIS(9.3, 10, 10.1, 10.2, SP1, SP2) you are using and the replica type (One way, Two way, etc.)

Sol

Hi Sol,

No, the only changes made was in the version of ArcGIS for Desktop.

Recently, we upgrade the ArcGIS for Desktop from 10.1 to 10.2 version.

The ArcGIS for Server (ArcSDE and Geodatabase) remain in the 10.1 version.

I think that this is the cause of the error!

Thanks for help!

Marcelo E. Peinado
GIS Analyst
Optimus GIS and IT Solutions

[AsrujitSengupta]

can you please try to synchronize the replica using Desktop 10.1/10.0 and check whether the issue is still reproducible.