topic Synchronize Replica Failed (ORA-00936: missing expression) in Data Management Questions

Synchronize Replica Failed (ORA-00936: missing expression)

MarceloEdy_Peinado — Thu, 15 May 2014 10:57:59 GMT

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

Re: Synchronize Replica Failed (ORA-00936: missing expression)

AsrujitSengupta — Thu, 15 May 2014 14:23:30 GMT

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.

Re: Synchronize Replica Failed (ORA-00936: missing expression)

MarceloEdy_Peinado — Thu, 15 May 2014 16:20:58 GMT

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

Re: Synchronize Replica Failed (ORA-00936: missing expression)

MarceloEdy_Peinado — Thu, 15 May 2014 16:56:18 GMT

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

Re: Synchronize Replica Failed (ORA-00936: missing expression)

AsrujitSengupta — Thu, 15 May 2014 19:23:16 GMT

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

Re: Synchronize Replica Failed (ORA-00936: missing expression)

Sravan_KumarUddarraju — Wed, 22 Oct 2014 21:00:22 GMT

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

Thanks,

Sravan

Re: Synchronize Replica Failed (ORA-00936: missing expression)

AsrujitSengupta — Wed, 22 Oct 2014 23:43:09 GMT

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

Re: Synchronize Replica Failed (ORA-00936: missing expression)

Sravan_KumarUddarraju — Thu, 23 Oct 2014 15:24:22 GMT

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

Thanks,

Sravan

Re: Synchronize Replica Failed (ORA-00936: missing expression)

SteveSalas — Mon, 10 Nov 2014 15:11:58 GMT

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

Re: Synchronize Replica Failed (ORA-00936: missing expression)

AsrujitSengupta — Mon, 10 Nov 2014 18:01:06 GMT

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?

Re: Synchronize Replica Failed (ORA-00936: missing expression)

SteveSalas — Mon, 10 Nov 2014 18:10:30 GMT

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!

Re: Synchronize Replica Failed (ORA-00936: missing expression)

AsrujitSengupta — Mon, 10 Nov 2014 18:14:07 GMT

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.