topic Re: SQL Keywords Blocking inclusion of certain fields in Form Builder in ArcGIS Field Maps Questions

SQL Keywords Blocking inclusion of certain fields in Form Builder

JosephHilliard94 — Fri, 16 Jun 2023 13:07:26 GMT

Hi there,

The new ArcGIS Online update (which clearly doesn't state this update) means you cannot use SQL keywords as field names in ArcGIS Online. Is there a definitive list of SQL keywords that we aren't allowed to use in ArcGIS Online? Going to mean quite a lot of re-configuration to existing feature services without prior warning.....

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

DougBrowning — Tue, 20 Jun 2023 16:12:42 GMT

That is a big one to change for sure.

Most of my stuff is in 123 so I use their list which has a lot of the SQL keywords on there. This may be a decent place to start since it has SQL, SQL Lite, and AGOL items on this list. Not sure how complete it is though.

A
ABS
ABSENT
ACCESS
ACCORDING
ACCOUNT
ACTIVATE
ADA
ADD
ADMIN
ADVISE
AFTER
ALL
ALL_ROWS
ALLOCATE
ALLOW
ALTER
ANALYSE
ANALYZE
AND
ANY
ARCHIVE
ARCHIVELOG
ARE
AREA
ARRAY
ARRAY_AGG
ARRAY_MAX_CARDINALITY
AS
ASC
ASENSITIVE
ASSOCIATE
ASUTIME
ASYMMETRIC
AT
ATOMIC
ATTRIBUTES
AUDIT
AUTHENTICATED
AUTHORIZATION
AUTOEXTEND
AUTOMATIC
AUX
AUXILIARY
AVG
BACKUP
BASE64
BECOME
BEFORE
BEGIN
BEGIN_FRAME
BEGIN_PARTITION
BERNOULLI
BETWEEN
BFILE
BINARY
BIT_LENGTH
BITMAP
BLOB
BLOCK
BLOCKED
BODY
BOM
BOTH
BREADTH
BREAK
BROWSE
BUFFERPOOL
BULK
BY
C
CACHE
CACHE_INSTANCES
CALL
CANCEL
CAPTURE
CARDINALITY
CASCADE
CASCADED
CASE
CAST
CATALOG_NAME
CCSID
CEIL
CEILING
CFILE
CHAINED
CHANGE
CHAR
CHAR_CS
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHARACTER_SET_CATALOG
CHARACTER_SET_NAME
CHARACTER_SET_SCHEMA
CHARACTERS
CHECK
CHECKPOINT
CHOOSE
CHUNK
CLASS_ORIGIN
CLEAR
CLOB
CLONE
CLOSE
CLOSE_CACHED_OPEN_CURSORS
CLUSTER
CLUSTERED
COALESCE
COBOL
COLLATE
COLLATION
COLLATION_CATALOG
COLLATION_NAME
COLLATION_SCHEMA
COLLECT
COLLECTION
COLLID
COLUMN
COLUMN_NAME
COLUMNS
COMMAND_FUNCTION
COMMAND_FUNCTION_CODE
COMMENT
COMMIT
COMMITTED
COMPATIBILITY
COMPILE
COMPLETE
COMPOSITE_LIMIT
COMPRESS
COMPUTE
CONCAT
CONCURRENTLY
CONDITION
CONDITION_NUMBER
CONNECT
CONNECT_TIME
CONNECTION
CONNECTION_NAME
CONSTRAINT
CONSTRAINT_CATALOG
CONSTRAINT_NAME
CONSTRAINT_SCHEMA
CONSTRAINTS
CONSTRUCTOR
CONTAINS
CONTAINSTABLE
CONTENT
CONTENTS
CONTINUE
CONTROL
CONTROLFILE
CONVERT
CORR
CORRESPONDING
COST
COUNT
COVAR_POP
COVAR_SAMP
CPU_PER_CALL
CPU_PER_SESSION
CREATE
CREATIONDATE
CREATOR
CROSS
CUBE
CUME_DIST
CURREN_USER
CURRENT
CURRENT_CATALOG
CURRENT_CONNECTION
CURRENT_DATE
CURRENT_DEFAULT_TRANSFORM_GROUP
CURRENT_LC_CTYPE
CURRENT_PATH
CURRENT_ROLE
CURRENT_ROW
CURRENT_SCHEMA
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TRANSFORM_GROUP_FOR_TYPE
CURRENT_USER
CURRENT_UTCDATE
CURRENT_UTCTIME
CURRENT_UTCTIMESTAMP
CURRVAL
CURSOR
CURSOR_NAME
CYCLE
DANGLING
DATA
DATABASE
DATAFILE
DATAFILES
DATALINK
DATAOBJNO
DATE
DATETIME_INTERVAL_CODE
DATETIME_INTERVAL_PRECISION
DAY
DAYS
DB
DBA
DBCC
DBHIGH
DBINFO
DBLOW
DBMAC
DEALLOCATE
DEBUG
DEC
DECIMAL
DECLARE
DEFAULT
DEFERRABLE
DEFERRED
DEFINED
DEGREE
DELETE
DENSE_RANK
DENY
DEPTH
DEREF
DERIVED
DESC
DESCRIBE
DESCRIPTOR
DETERMINISTIC
DIAGNOSTICS
DIRECTORY
DISABLE
DISALLOW
DISCONNECT
DISK
DISMOUNT
DISPATCH
DISTINCT
DISTRIBUTED
DLNEWCOPY
DLPREVIOUSCOPY
DLURLCOMPLETE
DLURLCOMPLETEONLY
DLURLCOMPLETEWRITE
DLURLPATH
DLURLPATHONLY
DLURLPATHWRITE
DLURLSCHEME
DLURLSERVER
DLVALUE
DML
DO
DOCUMENT
DOUBLE
DROP
DSSIZE
DUMP
DYNAMIC
DYNAMIC_FUNCTION
DYNAMIC_FUNCTION_CODE
EACH
EDITDATE
EDITOR
EDITPROC
ELEMENT
ELSE
ELSEIF
ELSIF
EMAXX
EMAXY
EMAXZ
EMINX
EMINY
EMINZ
EMPTY
ENABLE
ENCODING
ENCRYPTION
END
END_FRAME
END_PARTITION
END-EXEC
ENDING
ENFORCE
ENFORCED
ENTITY
ENTRY
EQUALS
ERASE
ERRLVL
ESCAPE
EVERY
EXCEPT
EXCEPTION
EXCEPTIONS
EXCHANGE
EXCLUDING
EXCLUSIVE
EXEC
EXECUTE
EXISTS
EXIT
EXP
EXPIRE
EXPLAIN
EXPRESSION
EXTENT
EXTENTS
EXTERNAL
EXTERNALLY
FAILED_LOGIN_ATTEMPTS
FALSE
FAST
FENCED
FETCH
FID
FIELDPROC
FILE
FILLFACTOR
FILTER
FINAL
FIRST
FIRST_ROWS
FIRST_VALUE
FLAG
FLAGGER
FLOAT
FLOB
FLOOR
FLUSH
FOR
FORCE
FOREIGN
FORTRAN
FOUND
FRAME_ROW
FREE
FREELIST
FREELISTS
FREETEXT
FREETEXTTABLE
FREEZE
FROM
FS
FULL
FUNCTION
FUSION
G
GENERAL
GENERATED
GET
GLOBAL
GLOBAL_NAME
GLOBALID
GLOBALLY
GO
GOTO
GRANT
GROUP
GROUPING
GROUPS
HANDLER
HASH
HASHKEYS
HAVING
HEADER
HEAP
HEX
HIERARCHY
HOLD
HOLDLOCK
HOUR
HOURS
ID
IDENTIFIED
IDENTITY
IDENTITY_INSERT
IDENTITYCOL
IDGENERATORS
IDLE_TIME
IF
IGNORE
ILIKE
IMMEDIATE
IMMEDIATELY
IMPLEMENTATION
IMPORT
IN
INCLUDING
INCLUSIVE
INCREMENT
IND_PARTITION
INDENT
INDEX
INDEXED
INDEXES
INDICATOR
INHERIT
INITIAL
INITIALLY
INITRANS
INNER
INOUT
INSENSITIVE
INSERT
INSTANCE
INSTANCES
INSTANTIABLE
INSTEAD
INT
INTEGER
INTEGRITY
INTERMEDIATE
INTERSECT
INTERSECTION
INTO
IS
ISNULL
ISOBID
ISOLATION
ISOLATION_LEVEL
ITERATE
JAR
JOIN
K
KEEP
KEY
KEY_MEMBER
KEY_TYPE
KILL
LABEL
LAG
LANGUAGE
LAST
LAST_VALUE
LATERAL
LAYER
LC_CTYPE
LEAD
LEADING
LEAVE
LEFT
LEN
LENGTH
LESS
LEVEL
LIBRARY
LIKE
LIKE_REGEX
LIMIT
LINENO
LINK
LIST
LN
LOAD
LOB
LOCAL
LOCALE
LOCALTIME
LOCALTIMESTAMP
LOCATOR
LOCATORS
LOCK
LOCKED
LOCKMAX
LOCKSIZE
LOG
LOGFILE
LOGGING
LOGICAL_READS_PER_CALL
LOGICAL_READS_PER_SESSION
LONG
LOOP
LOWER
M
MAINTAINED
MANAGE
MAP
MASTER
MATCHED
MATERIALIZED
MAX
MAX_CARDINALITY
MAX_MEASURE
MAXARCHLOGS
MAXDATAFILES
MAXEXTENTS
MAXINSTANCES
MAXLOGFILES
MAXLOGHISTORY
MAXLOGMEMBERS
MAXSIZE
MAXTRANS
MAXVALUE
MEMBER
MERGE
MESSAGE_LENGTH
MESSAGE_OCTET_LENGTH
MESSAGE_TEXT
METHOD
MICROSECOND
MICROSECONDS
MIN
MIN_MEASURE
MINEXTENTS
MINIMUM
MINUS
MINUTE
MINUTES
MINVALUE
MLS_LABEL_FORMAT
MLSLABEL
MOD
MODE
MODIFIES
MODIFY
MODULE
MONTH
MONTHS
MORE
MOUNT
MOVE
MTS_DISPATCHERS
MULTISET
MUMPS
NAMESPACE
NATIONAL
NATURAL
NCHAR
NCHAR_CS
NCLOB
NEEDED
NESTED
NESTING
NETWORK
NEW
NEXT
NEXTVAL
NFC
NFD
NFKC
NFKD
NIL
NO
NOARCHIVELOG
NOAUDIT
NOCACHE
NOCHECK
NOCOMPRESS
NOCYCLE
NOFORCE
NOLOGGING
NOMAXVALUE
NOMINVALUE
NONCLUSTERED
NONE
NOORDER
NOOVERRIDE
NOPARALLEL
NOREVERSE
NORMAL
NORMALIZE
NORMALIZED
NOSORT
NOT
NOTHING
NOTNULL
NOWAIT
NTH_VALUE
NTILE
NULL
NULLABLE
NULLIF
NULLS
NUMBER
NUMERIC
NUMOFPTS
NUMPARTS
NVARCHAR2
OBID
OBJECT
OBJECTID
OBJNO
OBJNO_REUSE
OCCURRENCES_REGEX
OCTET_LENGTH
OCTETS
OF
OFF
OFFLINE
OFFSET
OFFSETS
OID
OIDINDEX
OLD
ON
ONLINE
ONLY
OPCODE
OPEN
OPENDATASOURCE
OPENQUERY
OPENROWSET
OPENXML
OPTIMAL
OPTIMIZATION
OPTIMIZE
OPTIMIZER_GOAL
OPTION
OR
ORDER
ORDERING
ORDINALITY
ORGANIZATION
OSLABEL
OTHERS
OUT
OUTER
OUTPUT
OVER
OVERFLOW
OVERLAPS
OVERRIDING
OWN
P
PACKAGE
PAD
PADDED
PARALLEL
PARAMETER
PARAMETER_MODE
PARAMETER_NAME
PARAMETER_ORDINAL_POSITION
PARAMETER_SPECIFIC_CATALOG
PARAMETER_SPECIFIC_NAME
PARAMETER_SPECIFIC_SCHEMA
PART
PARTITION
PARTITIONED
PARTITIONING
PASCAL
PASSTHROUGH
PASSWORD
PASSWORD_GRACE_TIME
PASSWORD_LIFE_TIME
PASSWORD_LOCK_TIME
PASSWORD_REUSE_MAX
PASSWORD_REUSE_TIME
PASSWORD_VERIFY_FUNCTION
PATH
PCTFREE
PCTINCREASE
PCTTHRESHOLD
PCTUSED
PCTVERSION
PERCENT
PERCENT_RANK
PERCENTILE_CONT
PERCENTILE_DISC
PERIOD
PERMANENT
PERMISSION
PIECESIZE
PIVOT
PLACING
PLAN
PLI
PLSQL_DEBUG
POINTS
PORTION
POSITION_REGEX
POST_TRANSACTION
POWER
PRECEDES
PRECISION
PREPARE
PRESERVE
PREVVAL
PRIMARY
PRINT
PRIOR
PRIQTY
PRIVATE
PRIVATE_SGA
PRIVILEGE
PRIVILEGES
PROC
PROCEDURE
PROFILE
PROGRAM
PSID
PUBLIC
PURGE
QUERY
QUERYNO
QUEUE
QUOTA
RAISERROR
RANGE
RANK
RAW
RBA
READ
READS
READTEXT
READUP
REAL
REBUILD
RECONFIGURE
RECOVER
RECOVERABLE
RECOVERY
REF
REFERENCES
REFERENCING
REFRESH
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
RELEASE
RENAME
REPEAT
REPLACE
REPLICATION
REQUIRING
RESET
RESETLOGS
RESIGNAL
RESIZE
RESOURCE
RESPECT
RESTORE
RESTRICT
RESTRICTED
RESULT
RESULT_SET_LOCATOR
RETURN
RETURNED_CARDINALITY
RETURNED_LENGTH
RETURNED_OCTET_LENGTH
RETURNED_SQLSTATE
RETURNING
RETURNS
REUSE
REVERSE
REVERT
REVOKE
RIGHT
ROLE
ROLES
ROLLBACK
ROLLUP
ROUND_CEILING
ROUND_DOWN
ROUND_FLOOR
ROUND_HALF_DOWN
ROUND_HALF_EVEN
ROUND_HALF_UP
ROUND_UP
ROUTINE
ROUTINE_CATALOG
ROUTINE_NAME
ROUTINE_SCHEMA
ROW
ROW_COUNT
ROW_NUMBER
ROWCOUNT
ROWGUIDCOL
ROWID
ROWNUM
ROWS
ROWSET
RULE
RUN
SAMPLE
SAVE
SAVEPOINT
SB4
SCALE
SCAN_INSTANCES
SCHEMA
SCHEMA_NAME
SCN
SCOPE
SCOPE_CATALOG
SCOPE_NAME
SCOPE_SCHEMA
SCRATCHPAD
SD_ALL
SD_INHIBIT
SD_SHOW
SECOND
SECONDS
SECQTY
SECTION
SECURITY
SECURITYAUDIT
SEG_BLOCK
SEG_FILE
SEGMENT
SELECT
SELECTIVE
SELF
SEMANTICKEYPHRASETABLE
SEMANTICSIMILARITYDETAILSTABLE
SEMANTICSIMILARITYTABLE
SENSITIVE
SEQUENCE
SERIALIZABLE
SERVER_NAME
SESSION
SESSION_CACHED_CURSORS
SESSION_USER
SESSIONS_PER_USER
SET
SETS
SETUSER
SHAPE
SHARE
SHARED
SHARED_POOL
SHRINK
SHUTDOWN
SIGNAL
SIMILAR
SIMPLE
SIZE
SKIP
SKIP_UNUSABLE_INDEXES
SMALLINT
SNAPSHOT
SOME
SORT
SOURCE
SPACE
SPECIFIC
SPECIFIC_NAME
SPECIFICATION
SPECIFICTYPE
SPLIT
SQL
SQL_TRACE
SQLCODE
SQLERROR
SQLEXCEPTION
SQLSTATE
SQLWARNING
SQRT
STANDARD
STANDBY
START
STATE
STATEMENT
STATEMENT_ID
STATIC
STATISTICS
STAY
STDDEV_POP
STDDEV_SAMP
STOGROUP
STOP
STORAGE
STORE
STORES
STRUCTURE
STYLE
SUBCLASS_ORIGIN
SUBMULTISET
SUBSTRING_REGEX
SUCCEEDS
SUCCESSFUL
SUM
SUMMARY
SWITCH
SYMMETRIC
SYNONYM
SYS_OP_ENFORCE_NOT_NULL$
SYS_OP_NTCIMG$
SYSDATE
SYSDBA
SYSOPER
SYSTEM
SYSTEM_TIME
SYSTEM_USER
SYSTIME
SYSTIMESTAMP
SYSUUID
T
TABLE
TABLE_NAME
TABLES
TABLESAMPLE
TABLESPACE
TABLESPACE_NO
TABNO
TEMPORARY
TEXTSIZE
THAN
THE
THEN
THREAD
TIES
TIME
TIMESTAMP
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TOKEN
TOP
TOP_LEVEL_COUNT
TOPLEVEL
TRACE
TRACING
TRAILING
TRAN
TRANSACTION
TRANSACTION_ACTIVE
TRANSACTIONS_COMMITTED
TRANSACTIONS_ROLLED_BACK
TRANSFORM
TRANSFORMS
TRANSITIONAL
TRANSLATE
TRANSLATE_REGEX
TRANSLATION
TRIGGER
TRIGGER_CATALOG
TRIGGER_NAME
TRIGGER_SCHEMA
TRIGGERS
TRIM_ARRAY
TRUE
TRUNCATE
TRY_CONVERT
TSEQUAL
TX
TYPE
UB2
UBA
UESCAPE
UID
UNARCHIVED
UNDER
UNDO
UNION
UNIQUE
UNLIMITED
UNLINK
UNLOCK
UNNAMED
UNNEST
UNPIVOT
UNRECOVERABLE
UNTIL
UNTYPED
UNUSABLE
UNUSED
UPDATABLE
UPDATE
UPDATETEXT
UPPER
URI
USAGE
USE
USER
USER_DEFINED_TYPE_CATALOG
USER_DEFINED_TYPE_CODE
USER_DEFINED_TYPE_NAME
USER_DEFINED_TYPE_SCHEMA
USING
UTCDATE
UTCTIME
UTCTIMESTAMP
VALIDATE
VALIDATION
VALIDPROC
VALUE
VALUE_OF
VALUES
VAR_POP
VAR_SAMP
VARBINARY
VARCHAR
VARCHAR2
VARIABLE
VARIADIC
VARIANT
VARYING
VCAT
VERBOSE
VERSIONING
VIEW
VOLATILE
VOLUMES
WAITFOR
WHEN
WHENEVER
WHERE
WHILE
WIDTH_BUCKET
WINDOW
WITH
WITHIN
WITHIN GROUP
WITHOUT
WLM
WORK
WRITE
WRITEDOWN
WRITETEXT
WRITEUP
XID
XMLAGG
XMLBINARY
XMLCAST
XMLCOMMENT
XMLDECLARATION
XMLDOCUMENT
XMLEXISTS
XMLITERATE
XMLNAMESPACES
XMLQUERY
XMLSCHEMA
XMLTABLE
XMLTEXT
XMLVALIDATE
YEAR
YEARS
ZONE

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

ColinLawrence — Wed, 21 Jun 2023 18:04:46 GMT

@JosephHilliard94 this wasnt an intentional change and will be fixed in the next couple of days. We should continue to ignore existing fields with reserved keywords created from another source (ie Pro) and loaded into Designer. There should only be an error when creating new fields in Designer with the restricted keywords.

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

SamiHammer — Thu, 27 Jun 2024 17:11:49 GMT

Hmm, I just had this happen this morning - was there another update that caused this problem again? I haven't looked fully though, but I have fields called EDITDATE and OBJECTID that look like they are reserved. What's going on?

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

D_AnneHammond — Thu, 27 Jun 2024 17:52:55 GMT

I just ran into this issue as well when trying to update a field map with offline areas, and I have an array of offline field maps (!) Seems like every time I turn around Esri does something that makes me reconfigure on-the-fly increasing my workload substantially... so frustrating... even worse, I don't see any field names that are reserved SQL words, can someone can point out which field names in the list below are reserved SQL words?

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

SamiHammer — Thu, 27 Jun 2024 18:27:08 GMT

Looks like you have GLOBALID and FID in that list that Doug posted above.

We have various maps that were working fine before today that also have these errors, so it's definitely an ESRI problem. (I'm also getting a weird error on some other layers that "this layer requires true curve editing, which is not currently supported in Field Maps.)

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

DougBrowning — Thu, 27 Jun 2024 18:52:50 GMT

AGOL was updated last night which could be it? https://doc.arcgis.com/en/arcgis-online/reference/whats-new.htm

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

TrevorDenson — Thu, 27 Jun 2024 19:49:40 GMT

This is my nightmare. I have 10+ maps and over 40 people not being able to collect data because of the updates. I can't find out what fields are throwing the error. They are unable to download offline areas now.

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

LauraBedoyan — Thu, 27 Jun 2024 20:55:03 GMT

Hi D_AnneHammond,

If you could please change your "Range" field to a different name, such as "Range_Field" or another option that doesn't use "Range" exactly as the field name This change is necessary because "Range" is a recognized SQL Lite Keyword, and we've introduced checks for such keywords for offline use. For a list of these keywords, visit https://sqlite.org/lang_keywords.html. Let me know if you encounter any problems.

This isn't a new restriction we've implemented; it's an existing one that would have previously prevented taking the map offline if it contained SQLite keywords. We've just enhanced the messaging during the authoring process to make this clearer.

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

JustinColville — Thu, 27 Jun 2024 21:00:33 GMT

@TrevorDenson sorry to hear that you are having problems.

Can you tell me a little more about your workflow? What are the error message? Where are you seeing these error message, Field Maps Designer or Field Maps Mobile? When the users are trying to take the maps offline what errors are they seeing? Would you be able to send troubleshooting logs from mobile?

If you would like please submit an issue with support as well

SQLite keywords as fields have never been supported when taking a map offline, the maps will fail when trying to take them offline in mobile or fail packaging in Online. This was not a new restriction, but we made changes in this release to error at authoring time so that we can more easily tell there is an issue with a layer and offline usage.

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

TAMRAO_HALLORAN — Thu, 27 Jun 2024 23:49:08 GMT

Any updates on this "fix"?

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

TrevorDenson — Fri, 28 Jun 2024 14:51:12 GMT

@JustinColville

Hi. I am seeing this error message in the Offline tab of Field Maps Designer:

When I go to click on the layer, it does not give me any indication of what field(s) are causing the issue. It is preventing folks from downloading offline areas now. There was a statement earlier in this thread by @ColinLawrence that said:

"this wasnt an intentional change and will be fixed in the next couple of days. We should continue to ignore existing fields with reserved keywords created from another source (ie Pro) and loaded into Designer. There should only be an error when creating new fields in Designer with the restricted keywords."

My workflow is to publish from ArcGIS Pro because of my program's use of Subtypes/Templates. I have to have everything setup in Pro before I can publish in order for it to work. The ability to work with Subtypes in AGOL is rather challenging and any modification to field or list values breaks it. The fields haven't been giving me issues for the last several years and I wonder why it's a problem now.

My staff is unable to download offline areas all of a sudden and I will likely just have to republish each of the 10 maps if it continues to be an issue. Some folks that have had offline areas downloaded already are still able to sync, but it is not consistent across the board.

Do you have a list of SQL Keywords available that are prohibited? I have changed fields like "Year" to "Year_". I would doubt my use of Field Aliases/labels would cause this issue...

Thanks. Sorry if I am being dramatic... I am just confused why all of a sudden, in the middle of field season with remote workers, that it broke after working for the last three+ months.

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

JustinColville — Fri, 28 Jun 2024 16:10:11 GMT

@TrevorDenson Sorry for the confusion this is causing. Thank-you for the details.

A list of SQLite keywords is available here - https://sqlite.org/lang_keywords.html. If possible would you be able to send me the schema of the layer that is giving you the error message?

"I would doubt my use of Field Aliases/labels would cause this issue"

You are correct, this is for field names.

Colin's comment was from June 2023 and was in regards to a change to the Forms tab in Field Maps Designer and a fix was made shortly after Colin's comment around the end of June last year. His comment was not about the new messaging you are seeing in the Offline tab. The change that we added in this release was to add the new error messaging in the Offline tab. Prior to this release you would not have seen that error message, but SQLite keywords as fields have never been supported when taking a map offline. The maps will fail when trying to take them offline in mobile or fail when packaging map areas in Online/Field Maps Designer. This restriction with SQLite keywords is not new at this release, we have just made this more visible to help avoid packaging/offline download errors that would have been occurring.

"My staff is unable to download offline areas all of a sudden"

This change was just in Field Maps Designer and did not change anything in Field Maps mobile. If your staff are taking maps offline from the mobile device, this change would not come into play. There might be another issue happening as well. What errors are your staff seeing on the mobile devices? Would you be able to send a troubleshooting log from Field Maps mobile?

I would encourage you to reach out to support and submit an issue as well.

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

TrevorDenson — Fri, 28 Jun 2024 16:21:21 GMT

Thank you for the reply. I am opening up an ESRI support ticket to further troubleshoot. Thanks

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

D_AnneHammond — Fri, 28 Jun 2024 16:25:56 GMT

Thanks Laura, our feature class hasn't changed and didn't throw an error previously. Also, this is an authoritative feature class with many dependencies so changing the base field name might be an issue, I'll have to check with our Coordinator. Why was it working previously and then all of a sudden it's not? Also, @SamiHammer noted above that GlobalID and FID are also reserved words and we can't publish field apps that have, or will collect, attachments or related tables without GlobalID.

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

RichardKauffman — Fri, 28 Jun 2024 17:11:21 GMT

Thanks Justin for the update on this issue. What I don't understand is that I have not had any issues creating offline maps in the Field Maps Designer, as of yesterday I am getting this issue on only 2 layers. If this is a SQL issue I should have had the problems before yesterday, and on all of my layers since I have an Object ID field.

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

JustinColville — Fri, 28 Jun 2024 17:31:30 GMT

Hello @RichardKauffman

Sorry that you are having problem. Would you be able to share the schema of the layers you are having problems with?

Object ID is not an SQLite keyword. A list of SQLite keywords is available here - https://sqlite.org/lang_keywords.html.

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

TAMRAO_HALLORAN — Mon, 01 Jul 2024 13:24:49 GMT

Laura-

We were experiencing the same issue and nothing in our Offline maps has changed. Can you please share what changed and any updates to this issue?

Thanks!

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

JustinColville — Mon, 01 Jul 2024 15:28:26 GMT

Hello, can you please share more details of what you are seeing? What is the error message? Can you share the schema of the effected layer(s)? Are you able to take the map offline in Field Maps Mobile? If not what error message(s) are you seeing there (and if possible please share a troubleshooting log from mobile)?

Can you please share what changed and any updates to this issue?

On Friday evening, based on comments in this post and a couple other posts, we reduced the set of keywords used when showing this new message as we test the complete of SQLite keywords (https://sqlite.org/lang_keywords.html). Currently we are only showing this message for the following 10 keywords which will cause an error when taking a map offline:

select
commit
set
then
foreign
group
index
unique
intersect
join

As we test the SQLite keywords we plan to expand this list.

Re: SQL Keywords Blocking inclusion of certain fields in Form Builder

SamiHammer — Mon, 01 Jul 2024 17:57:47 GMT

The Friday evening update seems to have fixed the issue for our group. We have a couple layers with the keyword DO (for dissolved oxygen as a water quality parameter) and some with TEMP (for temperature). Just mentioning that in case those are common ones that may cause other people problems if you block them.

Justin, you indicated that "SQLite keywords as fields have never been supported when taking a map offline, the maps will fail when trying to take them offline in mobile or fail packaging in Online. This was not a new restriction, but we made changes in this release to error at authoring time so that we can more easily tell there is an issue with a layer and offline usage." But these are maps and layers my group and others in this thread taken offline for years with no problems that did contain some SQL keywords.

Thank you for at least getting the temporary fix going. And if there needs to be a broader fix, many people have layers that would be difficult to change - please figure out how to notify folks in advance, help them make changes, and try to do it at a time of year where fewer people are in the field.