topic Call GP Service in ArcGIS API for Python Questions

Call GP Service

jaykapalczynski — Sun, 12 Dec 2021 10:48:26 GMT

I had a python script that I published to a service. I was calling that service as such below and everything was working great.

In the database i created a table and then a relationship class that references the Feature Class I was previously updating.
Immediately this started throwing errors when I tried to run the python script calling for an edit session.
I modified the python script to include an edit start and edit close
I can now successfully run this script from ArcCatalog
After running from ArcCatalog I republished this to a service
As I have been doing all along I call this service and pass it a parameter.

Now the job fails. Not sure why. I can manually run this from ArcCatalog but not when I call from JavaScript like I did in the past.

Do I have to do something differently now that this Feature Class I am trying to write too is a part of a Relationship Class?????

        btnGISPush_Click: function () {
            var dictstring = document.getElementById(JSONstring).value;
            var params1 = {
                request: dictstring
            };
            window.gpJSON.execute(params1).then(function (resultVal) {
                console.log(resultVal.results[0].value);
                var finalGPResults = resultVal.results[0].value;
            },
                function (err) {
                    console.log(err);
                }
            );
        }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Call GP Service

jaykapalczynski — Wed, 22 Apr 2020 14:06:38 GMT

This is the error I am getting.....funny though when I run it from the GP Tool in ArcCatalog it runs fine

Re: Call GP Service

jaykapalczynski — Sun, 12 Dec 2021 10:48:28 GMT

I went in and removed the Relationship Class from the Database

Republished the Service and the GP Tool Service

Reran my code from JavaScript to send the GP Tool a parameter and everything worked perfect...

So it seems that the Relationship Class is causing the error....Not sure where or what I have to modify to get this to work with a Relationship class....

QUESTIONS:

Does the Python code need to change to handle the Relationship Class???

How would I write to the Feature Class as seen below and then write to the related table as well...

Say I am creating anew feature and pass it the geometry and fields as seen below.

Then I update a Field (Field1) in the related table with the 'UnqiueID'

Is my issue on the JavaScript side??? I cant see how that would be the case but the Relationship Class is definitly causing the error...

    workspace = r"E:/ArcGISProjects/CountySelection/cccc.sde"
    edit = arcpy.da.Editor(workspace)
    # Edit session is started without an undo/redo stack for versioned data
    #  (for second argument, use False for unversioned data)
    edit.startEditing(False, False)
    print "edit started"
    # Create update cursor
    with arcpy.da.InsertCursor(inputFeatureclass, ['SHAPE@', 'ADDRESSgeocode', 'DISTANCEparameter', 'UNIQUEIDparameter', 'COUNTYLIST', 'UnqiueID']) as cursor:
        # Start an edit operation
        edit.startOperation()
        # Perform edits
        ## CREATE THE NEW MULTI PART POLYGON IN THE FC
        cursor.insertRow([geometries[0], searchAddress, searchDistance, searchid, txt_list, validGuid])
        ## Delete cursor object
        del cursor

    # Stop the edit operation.
    edit.stopOperation()
    # Stop the edit session and save the changes
    edit.stopEditing(True)
    print "edit ended"‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Call GP Service

jaykapalczynski — Thu, 23 Apr 2020 22:36:06 GMT

I have no idea what happened...I deleted everything including FC and tables and rebuilt everything moving forward....it works now....sometimes don't ask why...