topic Re: Arcade Expression saving error in Geodatabase Questions

Arcade Expression saving error

vijaybadugu — Tue, 09 Jan 2024 22:01:45 GMT

I am getting an error while saving calculation Attribute rule in ArcGIS Pro 3.2.1

Re: Arcade Expression saving error

MarlonAmaya — Wed, 10 Jan 2024 00:15:34 GMT

This is not an error I would expect. Are you working with EGDB? Have you tried refreshing the DB connection, close/open pro? What is your data type for the acres column?

I just tried your expressions and it works for me.

Marlon

Re: Arcade Expression saving error

vijaybadugu — Wed, 10 Jan 2024 01:00:34 GMT

Yes . I’m using EGDB SQL Server acres data type is double( 7,4 ). I did refresh database, connected as owner and reopened arcgis pro. Nothing is working ..

Re: Arcade Expression saving error

ChrisUnderwood — Wed, 10 Jan 2024 11:37:22 GMT

Hello @vijaybadugu , did you check that your dataset is free for you to Lock it ?

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/create-modify-and-delete-attribute-rules.htm#ESRI_SECTION1_1ECF37183E8145C6B1B5150F51139DCE

"Before you create an attribute rule, ensure the data source is supported for the rule type and there is an exclusive lock on the underlying dataset. This means that no connections or services can be accessing the dataset."

Re: Arcade Expression saving error

vijaybadugu — Wed, 10 Jan 2024 12:37:45 GMT

If dataset is locked , it would throw a different error “exclusive locks …… “ .

Re: Arcade Expression saving error

MarlonAmaya — Wed, 10 Jan 2024 15:41:13 GMT

Hi @vijaybadugu ,

I have tested with Pro 3.2 with no issue using the same double (7,4) on SQL.

Are you able to create any attribute rule? what about another feature class?

Marlon

Re: Arcade Expression saving error

vijaybadugu — Wed, 10 Jan 2024 15:46:42 GMT

I tried with different feature class and this time, I did it for long data type. I am getting same error . is something issue with EGDB?

Re: Arcade Expression saving error

vijaybadugu — Wed, 10 Jan 2024 15:51:34 GMT

I was able to do same in our development database. I don't know what exactly issue is

Re: Arcade Expression saving error

MarlonAmaya — Wed, 10 Jan 2024 16:35:24 GMT

Almost seems as your DB connection is unable to access the feature class. Are you able to view the FC properties via catalog? Create a new FC and add global ID's and see what happens.

Marlon

Re: Arcade Expression saving error

vijaybadugu — Wed, 10 Jan 2024 16:44:49 GMT

I tried Creating a new feature class and same error. I updated the geodabase to latest and nothing is working

Re: Arcade Expression saving error

MarlonAmaya — Wed, 10 Jan 2024 16:57:41 GMT

@vijaybadugu

Please submit a Support Ticket.

Marlon

Re: Arcade Expression saving error

vijaybadugu — Wed, 10 Jan 2024 16:58:38 GMT

I already did