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 ) ; } ) ; }

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Call GP Service

jaykapalczynski

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<SPAN class="punctuation token">:</SPAN> <SPAN class="keyword token">function</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">var</SPAN> dictstring <SPAN class="operator token">=</SPAN> document<SPAN class="punctuation token">.</SPAN><SPAN class="token function">getElementById</SPAN><SPAN class="punctuation token">(</SPAN>JSONstring<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>value<SPAN class="punctuation token">;</SPAN>
            <SPAN class="keyword token">var</SPAN> params1 <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>
                request<SPAN class="punctuation token">:</SPAN> dictstring
            <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>
            window<SPAN class="punctuation token">.</SPAN>gpJSON<SPAN class="punctuation token">.</SPAN><SPAN class="token function">execute</SPAN><SPAN class="punctuation token">(</SPAN>params1<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">then</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">function</SPAN> <SPAN class="punctuation token">(</SPAN>resultVal<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
                console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">log</SPAN><SPAN class="punctuation token">(</SPAN>resultVal<SPAN class="punctuation token">.</SPAN>results<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>value<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                <SPAN class="keyword token">var</SPAN> finalGPResults <SPAN class="operator token">=</SPAN> resultVal<SPAN class="punctuation token">.</SPAN>results<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>value<SPAN class="punctuation token">;</SPAN>
            <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
                <SPAN class="keyword token">function</SPAN> <SPAN class="punctuation token">(</SPAN>err<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
                    console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">log</SPAN><SPAN class="punctuation token">(</SPAN>err<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                <SPAN class="punctuation token">}</SPAN>
            <SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

jaykapalczynski

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

All comments

jaykapalczynski

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

jaykapalczynski

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

    <SPAN class="comment token"># Stop the edit operation.</SPAN>
    edit<SPAN class="punctuation token">.</SPAN>stopOperation<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="comment token"># Stop the edit session and save the changes</SPAN>
    edit<SPAN class="punctuation token">.</SPAN>stopEditing<SPAN class="punctuation token">(</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"edit ended"</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

jaykapalczynski

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.