Issue on Getting Count of Intersect in Arccade Attribute Rule

Question

Having  two feature classes in SDE geodatabase like

-  EGDB.North.Parcels

-  EGDB.North.ProjectsInvest

I am trying to get the total count of Intersection between  EGDB.North.Projects in EGDB.North.ProjectsInvest using Attribute rules like this

var intersects = Intersects(FeatureSetByName($datastore, "EGDB.North.Parcels"), Geometry($feature)); return Count(intersects) ;

but I am getting this error

002717: Invalid Arcade expression

var intersects = Intersects(FeatureSetByName($datastore, "EGDB.North.Parcels"), Geometry($feature));
if(Count(intersects)>0){
  return Count(intersects);
}
else{
  return 0;
}

TedHoward2 · Answer

I believe this is the same issue found here

https://community.esri.com/t5/attribute-rules-questions/attribute-rule-not-working-anymore-in-3-1/td-p/1271804

I recommend contacting Tech support for a way forward

MarcoMob · Answer

Well, this is weird!

As you recommended I copied both

-  EGDB.North.Parcels

-  EGDB.North.ProjectsInvest

into a local FGDB and this is working now

var inters = Intersects(FeatureSetByName($datastore, "Parcels"), Geometry($feature)); 
return Count(inters)

So, why this is happening in SDE? how can I fix this? Is there any solution for this? Thanks

TedHoward2 · Answer

That looks valid.

You could try exporting those features classes to FGDB or MGDB to see if the problem is specific to SDE.