topic Re: ArcPY Replica in Python Questions

ArcPY Replica

MauricioRamirez1 — Mon, 29 Jan 2018 19:33:31 GMT

I have two ArcGIS servers running on Linux with and Oracle instance on each. The GIS servers sit behind a 3rd party hardware load balancer and each server has a feature service layer allowing edits. Since we're sitting behind the load balancer, we don't know which server we will hit and as such need to replicate the data from one instance to the other. I can manually push the changes but I need a way to push those changes automatically. I was thinking an ArcPY script could be helpul so I used the model builder and then exported that to a python script. The model runs fine, but the script won't run. I get a runtime error 999999 Error Executing function. There is a reference to a line in the file

import arceditor

Also arceditor.py line 18, gp.setProduct("ArcEditor")

Re: ArcPY Replica

DanPatterson_Retired — Mon, 29 Jan 2018 19:40:50 GMT

I don't use it but

http://pro.arcgis.com/en/pro-app/arcpy/functions/checkproduct.htm

I presume that it works in the model and not in the script is that there isn't an explicit check before you try to set.

Have a look at the code sample, and make sure you 'import arcpy', at one time modelbuilder left out that all important line in certain situations.

Re: ArcPY Replica

JoeBorgione — Mon, 29 Jan 2018 19:43:17 GMT

Perhaps you could post the code here; I've had the same thing happen to me, and there a number of posts here on the forum that suggest that model to python can be finicky. I use Arcpy to create check out replicas and to check them back in.

Re: ArcPY Replica

MauricioRamirez1 — Mon, 29 Jan 2018 21:19:43 GMT

The modelbuilder had the arcpy import there. I'll try the check license to see if that helps.

Re: ArcPY Replica

JakeSkinner — Mon, 29 Jan 2018 21:20:17 GMT

Hi Mauricio,

I ran into this issue recently working with a customer. Delete the reference to arceditor. For example comment or delete the lines:

import arceditor

gp.setProduct("ArcEditor")

You will just need the statement "import arcpy" and the script will most likely work.

Re: ArcPY Replica

MauricioRamirez1 — Mon, 29 Jan 2018 21:30:39 GMT

I added the check, and the license is not available. How can that be?

Re: ArcPY Replica

DanPatterson_Retired — Mon, 29 Jan 2018 21:33:31 GMT

As suggested by Joshua... skip the license check in the script

import arcpy # first line in the script

then see if it works. Working inside modelbuilder or in a script tool, makes things easier. If you are trying to run scripts without arc*whatever open then you have to be careful. If you work in a shared license environment... ditto.

Re: ArcPY Replica

MauricioRamirez1 — Mon, 29 Jan 2018 21:35:08 GMT

# -*- coding: utf-8 -*-
# ---------------------------------------------------------------------------
# SyncChanges.py
# Created on: 2018-01-29 13:24:42.00000
# (generated by ArcGIS/ModelBuilder)
# Description:
# ---------------------------------------------------------------------------

# Set the necessary product code
#import arceditor

# Import arcpy module
import arcpy

# Local variables:
arcgisA_replica_sde = "Database Connections\\arcgisA.replica.sde"
arcgisA_replica_sde__2_ = arcgisA_replica_sde
arcgisB_replica_sde__2_ = arcgisA_replica_sde
arcgisB_replica_sde = "Database Connections\\arcgisB.replica.sde"

if arcpy.CheckProduct("ArcEditor") == "Available":
msg = 'License is available'
print(msg)
# Process: Synchronize Changes
arcpy.SynchronizeChanges_management(arcgisA_replica_sde, "NPTacArea", arcgisB_replica_sde, "BOTH_DIRECTIONS", "IN_FAVOR_OF_GDB1", "BY_OBJECT", "DO_NOT_RECONCILE")
else:
msg = 'License is not available'
print(msg)

I added the check based on another response and I keep falling into the else branch

Re: ArcPY Replica

MauricioRamirez1 — Mon, 29 Jan 2018 21:38:35 GMT

it tells me it's not licensed.

Re: ArcPY Replica

DanPatterson_Retired — Mon, 29 Jan 2018 21:45:14 GMT

You appear to be running this as a standalone script.

Add a toolbox, add the script and see if the script will run as a tool from within arctoolbox.

Otherwise, get your licensing checked, since you are working in a shared environment and it may not be available when arcmap isn't open. Then there is that whole sde thing

Re: ArcPY Replica

MauricioRamirez1 — Mon, 29 Jan 2018 22:00:50 GMT

I skipped the check and just issued the Synchronize command and it worked. Thanks!