Synchronize Replica Failed (ORA-00936: missing expression)

4189
11
05-15-2014 03:57 AM
MarceloEdy_Peinado
New Contributor III
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
0 Kudos
11 Replies
AsrujitSengupta
Regular Contributor III
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.
0 Kudos
MarceloEdy_Peinado
New Contributor III
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
0 Kudos
Sravan_KumarUddarraju
New Contributor

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

Thanks,

Sravan

0 Kudos
AsrujitSengupta
Regular Contributor III

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 ..

0 Kudos
Sravan_KumarUddarraju
New Contributor

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

Thanks,

Sravan

0 Kudos
SteveSalas
Occasional Contributor

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

0 Kudos
AsrujitSengupta
Regular Contributor III

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?

0 Kudos
SteveSalas
Occasional Contributor

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!

0 Kudos
AsrujitSengupta
Regular Contributor III

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.

0 Kudos