ReconcileVersions Command needs different workspace in Web Tool

Question

I have a script tool in Pro 2.9.5 that uses arcpy.management.ReconcileVersions. The input for the workspace is supposed to be a feature layer, for branch versioning, which we are using. When I run the script tool, it succeeds and does exactly what I want.

Explanation of the input_database below (arcpy.management.ReconcileVersions(input_database....):

The enterprise geodatabase that contains the versions to be reconciled. The default is to use the geoprocessing workspace environment.

For branch versioning, this will be the feature service URL (that is, https://mysite.mydomain/server/rest/services/ElectricNetwork/FeatureServer).

My code is getting the url of the item, which ends up being the feature service url. Again, works great in Pro. When I publish the tool to our federated server as a Web Tool, it fails, and says the workspace type is not correct.

Full error in GP tool when run at REST service:

ReconcileVersions retval = convertArcObjectToPythonObject(gp.ReconcileVersions_management(*gp_fixargs((input_database, reconcile_mode, target_version, edit_versions, acquire_locks, abort_if_conflicts, conflict_definition, conflict_resolution, with_post, with_delete, out_log, proceed_if_conflicts_not_reviewed, reconcile_checkout_versions), True))) File "E:\ArcGIS\Server\framework\runtime\ArcGIS\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda> return lambda *args: val(*gp_fixargs(args, True)) arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid. ERROR 000837: The workspace is not the correct workspace type. Failed to execute (ReconcileVersions).

I have tried everything I can think of, including using the .sde workspace and nothing seems to work. Any ideas?!

George_Thompson · Answer

The original defect listed was a duplicate and closed as such (https://support.esri.com/en-us/bug/when-reconciling-via-a-geoprocessing-service-created-wi-bug-000155921).

The correct defect # BUG-000142108 information can be found here: https://support.esri.com/en-us/bug/the-reconcile-versions-web-tool-fails-and-returns-the-e-bug-000142108

If you need any other information, I would recommend contacting support and discussing with them.

benito · Answer

Do you know at what version this bug was resolved?  The reconcileversions works at Pro 3.3 for a workspace with a feature service url but I need to run it on an older box with Pro 3.1.  Was a workaround ever found for getting reconcilversions to work on older versions using featureservice urls as the workspace?

RyanKelley2023 · Answer

This is a confirmed bug, FYI.

* BUG-000155921 - Receiving error "Error 000837: The workspace is not the correct workspace type." when reconciling via a GP service created from a script.
* Environments in which issue was reproducible:* ArcGIS Enterprise 10.9.1 & ArcGIS Pro 3.03
* ArcGIS Enterprise 11 & ArcGIS Pro 3.03