nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Accepted answers

All comments

SteveSalas

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

Sravan_KumarUddarraju

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

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

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

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

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

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.