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

[AsrujitSengupta]

Which Desktop version are you using to synchronize the changes? As Sol suggested, always try to provide your configuration details(Desktop version, DBMS version,etc) for a more appropriate answer/suggestions/links.

There is a known issue while trying to synchronize a replica using Desktop 10.2.
http://support.esri.com/en/bugs/nimbus/TklNMDk0NjY5

[ NIM094669 - Synchronizing replica after deleting 1000 or more records from parent geodatabase fails using ArcGIS Desktop 10.2.]

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

[MarceloEdy_Peinado]

Hello,

Sorry!

ArcGIS for Desktop 10.2 (replica Two-way on Microsoft SQL Server Express 2008)
ArcGIS for Server 10.1 (ArcSDE 10.1) with Oracle 10g

Thanks for help!

Marcelo E. Peinado
GIS Analyst
Optimus GIS & IT Solutions

[Sravan_KumarUddarraju]

Any resolution on this issue? I am getting the same error during Synchronization process.

Thanks,

Sravan

[AsrujitSengupta]

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

The Bug has been fixed at 10.3 as per the information provided in below link:

NIM094669 - Synchronizing replica after deleting 1000 or more ..

[Sravan_KumarUddarraju]

I will install 10.1 today and try synchronization. Let you know how it goes.

Thanks,

Sravan

[SteveSalas]

The link to the bug report does not work - can you check and re-post?  Thanks!

[AsrujitSengupta]

Steve Salas‌ Yes, that link doesn't seem to be working presently.  I'll look into that.

Any particular information that you are looking for related to that Bug?

[SteveSalas]

Based on this discussion and another one, I am currently attempting the same synchronize using Desktop 10.1 instead of 10.2.  The synchronize is still running on 10.1 which is better than the crash we experienced on 10.2 within 30 seconds so I am hopeful!

[AsrujitSengupta]

If you were indeed hitting that Bug, them I'm pretty sure that the synchronize will complete successfully on Desktop 10.1

Post back here if you still observe any issues on 10.1.

Note: This Bug is supposedly fixed at 10.3.