Skip to main content
  • EN
  • I am running a workbench to validate overlapping
    polygons

  • My table structure is versioned spatial tables

  • I have ran the validation workbench against one
    version, using a published parameter setting the override version. This has been successful for a single
    version.

  • I want to automate validating a large number of
    table versions.

  • I have attempted to use the workspace runner to achieve
    this. In order to change the override
    version. With the idea that this will run for each table version.

  • I have a tried using a CSV list of the versions and
    I have tried reading directly from the Oracle version table list.

  • I have been unable to produce an output with
    test cases, these test cases produce an output when run against an individual
    version.
  • I think the workspace runner is failing to
    change the override version published parameter instead running against the
    SDE.default version for the same amount of versions within the CSV list.

I would be greatful for any help or advice, at a bit of a loss.

Thanks, Scott

@sw667 - Hi Scott, do you have a workspace (.fmw) that you can share with us?

 

Reading your summary, I think you had a great idea to use a CSV list of the versions. Perhaps it needs to be coupled with a loop (implemented with a Custom Transformer).

 

*It will also help if you can share that simple CSV file.

 

It looks like there is an arcpy function that returns a list of versions: http://pro.arcgis.com/en/pro-app/arcpy/functions/listversions.htm. Could you use PythonCaller to get the list of versions and then pass that to your validation workspace through the WorkspaceRunner instead of using a static CSV file? If you can't get the Geodb (ArcSDE reader) to accept the new version, perhaps the FeatureReader would work

@RylanAtSafe @MarkAtSafe Thank you both for your advice, I tried all of your suggestions and it was the FeatureReader that was successful in reading each of the versions from SDE.

Reply


Community Stats

30,615
Posts
115,995
Replies
38,251
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.