topic Re: applyEdits of a related table record fails occasionally in ArcGIS JavaScript Maps SDK Questions

applyEdits of a related table record fails occasionally

KarenRobine — Tue, 28 Mar 2017 19:23:46 GMT

I am attempting to applyEdits of a record for a related table that is being updated. My steps are to first set the attributes using record.setAttributes(attributes); I've included all the attributes (including the ObjectID). I then run applyEdits on the proper feature layer. Most of the time it works. Occasionally, however, I receive the following error: "Cannot read property 'attributes' of undefined". I've noticed that even though I receive this error message, the update still works. And as I mentioned above, this doesn't occur every time. Thoughts on why I'm getting this, and how to adjust my code so that this never occurs?

Re: applyEdits of a related table record fails occasionally

SarojThapa1 — Tue, 28 Mar 2017 19:34:17 GMT

Karen,

Is the OBJECTID in READONLY mode? It would be easier for us to tell what is wrong if you can post your codes.

Check this sample if you haven't already done so.

Using the attribute inspector | ArcGIS API for JavaScript 3.20

Re: applyEdits of a related table record fails occasionally

KarenRobine — Tue, 28 Mar 2017 20:57:39 GMT

No, it shouldn't be in READONLY mode, but what is the mechanism to place the OBJECTID in READONLY mode? I have been deleting, adding, and updating to the table without problems so I'm assuming that's not the problem.

I'm skipping a little code, but here is concept. Please keep in mind that most of the time it works.

var attributes = recrd.attributes;

//do some changes

recrd.setAttributes(attributes);

//now apply edits, but I use a deferred since I am handling adds, updates and deletes (I do deletes a bit differently which is why its null). I also don't do adds and updates at the same time. Typically, I'd either only do an update, or combine adds and deletes .

var def = new Deferred();

fLayer.applyEdits(newAttributes, updateAttributes, null).then(function(adds, updates, deletes) {

if (requestType === "add" && adds && adds.length > 0) {

//just get the first one

def.resolve({adds: adds[0]});

} else if (requestType === "update" && updates && updates.length > 0) {

//just get the first one

def.resolve({updates: updates[0]});

}

}, function(error) {

if (requestType === "update" && error && error.message && error.message.indexOf("Cannot read property 'attributes' of undefined") > -1) {

console.log("SaveEditsHandler.js: _prepareAllRequests() we got the Cannot read property 'attributes' of undefined error but we pass it back");

def.resolve({updates: {success: true}}); //TODO: I think this needs the objectId

} else {

def.reject();

}

});

return def.promise;

Re: applyEdits of a related table record fails occasionally

SarojThapa1 — Sat, 11 Dec 2021 06:33:49 GMT

I strongly believe you should not be editing objectid. The OBJECTID is a system primary key index of guaranteed unique values for that table that is read only, used by geoprocessing tools, scrolling and other system functions.

There are two ways you can make OBJECTID in READONLY mode:

1. Do not display objectid in the attribute table

var layerInfos = [{
    'featureLayer': featureLayer,
    'showAttachments': false,
    'isEditable': true,
    'showDeleteButton': false,
    'fieldInfos': [
        {'fieldName': 'Name', 'isEditable': false, 'label': '<b> Site Name:</b>'},

I don't see anything wrong with your code. If you have time, create a new database table with the same fields and data and don't mess up with objectid at all this time.

Good luck!

Re: applyEdits of a related table record fails occasionally

KarenRobine — Tue, 28 Mar 2017 21:50:37 GMT

interesting...

So regarding Item #1: Do not display objected in the attribute table, would the change be made on the Web Map? If I show the tables for all my related tables in ArcGIS Online, I do notice that the OBJECTID field does not appear. When I click "Options" and show/Hide columns, the OBJECTID field is always turned off. Therefore, I think I'm good, right?

Regarding Item #2: I'm not following where you're going with that?

So, in my setAttributes() method, should I pull out OBJECTID field? Should I ONLY set attributes on "changed" attributes?

Out of curiosity, do you know if this documented anywhere?

Thanks so much for your help.

Re: applyEdits of a related table record fails occasionally

KarenRobine — Tue, 28 Mar 2017 22:11:30 GMT

I tried by removing the OBJECTID field, as well as any other fields I'm not changing. I get the following error (see below):

I also checked and my Feature Service has OBJECTID set as follows:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)

Error: Must declare the scalar variable "@OBJECTID". at Object.constructor (https://js.arcgis.com/3.19/init.js:2035:385) at new <anonymous> (https://js.arcgis.com/3.19/init.js:160:49) at Object._editHandler (https://js.arcgis.com/3.19/init.js:2006:423) at Object.load (https://js.arcgis.com/3.19/init.js:1965:346) at https://js.arcgis.com/3.19/init.js:993:143 at c (https://js.arcgis.com/3.19/init.js:103:393) at d (https://js.arcgis.com/3.19/init.js:103:182) at b.Deferred.resolve.callback (https://js.arcgis.com/3.19/init.js:105:10) at c (https://js.arcgis.com/3.19/init.js:104:96) at d (https://js.arcgis.com/3.19/init.js:103:182)
objectId:-1
success:false
__proto__:Object
__proto__:Object
length:1
__proto__:Array[0]

Re: applyEdits of a related table record fails occasionally

SarojThapa1 — Wed, 29 Mar 2017 13:39:22 GMT

Karen,

Did you try set attributes only on "changed" attributes?

Re: applyEdits of a related table record fails occasionally

SarojThapa1 — Wed, 29 Mar 2017 13:49:07 GMT

Hopefully, these threads are helpful.

ObjectID's change when editing

http://stackoverflow.com/questions/24459795/how-can-you-edit-the-objectid-of-a-row-in-an-arcgis-geodatabase

Re: applyEdits of a related table record fails occasionally

KarenRobine — Wed, 29 Mar 2017 14:47:11 GMT

Thanks Saroj. I'll try that. But based on my previous comment, it seems like I have to include the OBJECTID as well (otherwise, I get that error I noted in my previous post).

Re: applyEdits of a related table record fails occasionally

thejuskambi — Wed, 29 Mar 2017 15:00:21 GMT

Hello Karen,

Can you share the part of the code where you create the variable "newAttributes" and "updateAttributes". The error message looks like it is not getting a graphic object passed to the applyEdits method. Can you check if a null or undefined is passed as an array item.

Hope this was helpful.

Re: applyEdits of a related table record fails occasionally

KarenRobine — Wed, 29 Mar 2017 15:22:36 GMT

Thanks Thejus:
For the case where I insert new table records, every once in a while, I do get an 'undefined' attribute which is sending the same error message. Since it only happens like 2% of the time, it's hard to put my finger on the problem. I'm guessing a problem with my asynchronous calls. I'll look at this some more regarding my update attributes as well. Thanks.