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.....
Still nothing on my end, just ran into this problem while trying to update a survey after weeks of work. What is ESRI thinking?
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:
As we test the SQLite keywords we plan to expand this list.
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!
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.
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.
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.
Thank you for the reply. I am opening up an ESRI support ticket to further troubleshoot. Thanks
@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.
@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:
Any updates on this "fix"?
@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.
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.
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.
AGOL was updated last night which could be it? https://doc.arcgis.com/en/arcgis-online/reference/whats-new.htm
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.)
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?
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?
@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.
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.
AABSABSENTACCESSACCORDINGACCOUNTACTIVATEADAADDADMINADVISEAFTERALLALL_ROWSALLOCATEALLOWALTERANALYSEANALYZEANDANYARCHIVEARCHIVELOGAREAREAARRAYARRAY_AGGARRAY_MAX_CARDINALITYASASCASENSITIVEASSOCIATEASUTIMEASYMMETRICATATOMICATTRIBUTESAUDITAUTHENTICATEDAUTHORIZATIONAUTOEXTENDAUTOMATICAUXAUXILIARYAVGBACKUPBASE64BECOMEBEFOREBEGINBEGIN_FRAMEBEGIN_PARTITIONBERNOULLIBETWEENBFILEBINARYBIT_LENGTHBITMAPBLOBBLOCKBLOCKEDBODYBOMBOTHBREADTHBREAKBROWSEBUFFERPOOLBULKBYCCACHECACHE_INSTANCESCALLCANCELCAPTURECARDINALITYCASCADECASCADEDCASECASTCATALOG_NAMECCSIDCEILCEILINGCFILECHAINEDCHANGECHARCHAR_CSCHAR_LENGTHCHARACTERCHARACTER_LENGTHCHARACTER_SET_CATALOGCHARACTER_SET_NAMECHARACTER_SET_SCHEMACHARACTERSCHECKCHECKPOINTCHOOSECHUNKCLASS_ORIGINCLEARCLOBCLONECLOSECLOSE_CACHED_OPEN_CURSORSCLUSTERCLUSTEREDCOALESCECOBOLCOLLATECOLLATIONCOLLATION_CATALOGCOLLATION_NAMECOLLATION_SCHEMACOLLECTCOLLECTIONCOLLIDCOLUMNCOLUMN_NAMECOLUMNSCOMMAND_FUNCTIONCOMMAND_FUNCTION_CODECOMMENTCOMMITCOMMITTEDCOMPATIBILITYCOMPILECOMPLETECOMPOSITE_LIMITCOMPRESSCOMPUTECONCATCONCURRENTLYCONDITIONCONDITION_NUMBERCONNECTCONNECT_TIMECONNECTIONCONNECTION_NAMECONSTRAINTCONSTRAINT_CATALOGCONSTRAINT_NAMECONSTRAINT_SCHEMACONSTRAINTSCONSTRUCTORCONTAINSCONTAINSTABLECONTENTCONTENTSCONTINUECONTROLCONTROLFILECONVERTCORRCORRESPONDINGCOSTCOUNTCOVAR_POPCOVAR_SAMPCPU_PER_CALLCPU_PER_SESSIONCREATECREATIONDATECREATORCROSSCUBECUME_DISTCURREN_USERCURRENTCURRENT_CATALOGCURRENT_CONNECTIONCURRENT_DATECURRENT_DEFAULT_TRANSFORM_GROUPCURRENT_LC_CTYPECURRENT_PATHCURRENT_ROLECURRENT_ROWCURRENT_SCHEMACURRENT_TIMECURRENT_TIMESTAMPCURRENT_TRANSFORM_GROUP_FOR_TYPECURRENT_USERCURRENT_UTCDATECURRENT_UTCTIMECURRENT_UTCTIMESTAMPCURRVALCURSORCURSOR_NAMECYCLEDANGLINGDATADATABASEDATAFILEDATAFILESDATALINKDATAOBJNODATEDATETIME_INTERVAL_CODEDATETIME_INTERVAL_PRECISIONDAYDAYSDBDBADBCCDBHIGHDBINFODBLOWDBMACDEALLOCATEDEBUGDECDECIMALDECLAREDEFAULTDEFERRABLEDEFERREDDEFINEDDEGREEDELETEDENSE_RANKDENYDEPTHDEREFDERIVEDDESCDESCRIBEDESCRIPTORDETERMINISTICDIAGNOSTICSDIRECTORYDISABLEDISALLOWDISCONNECTDISKDISMOUNTDISPATCHDISTINCTDISTRIBUTEDDLNEWCOPYDLPREVIOUSCOPYDLURLCOMPLETEDLURLCOMPLETEONLYDLURLCOMPLETEWRITEDLURLPATHDLURLPATHONLYDLURLPATHWRITEDLURLSCHEMEDLURLSERVERDLVALUEDMLDODOCUMENTDOUBLEDROPDSSIZEDUMPDYNAMICDYNAMIC_FUNCTIONDYNAMIC_FUNCTION_CODEEACHEDITDATEEDITOREDITPROCELEMENTELSEELSEIFELSIFEMAXXEMAXYEMAXZEMINXEMINYEMINZEMPTYENABLEENCODINGENCRYPTIONENDEND_FRAMEEND_PARTITIONEND-EXECENDINGENFORCEENFORCEDENTITYENTRYEQUALSERASEERRLVLESCAPEEVERYEXCEPTEXCEPTIONEXCEPTIONSEXCHANGEEXCLUDINGEXCLUSIVEEXECEXECUTEEXISTSEXITEXPEXPIREEXPLAINEXPRESSIONEXTENTEXTENTSEXTERNALEXTERNALLYFAILED_LOGIN_ATTEMPTSFALSEFASTFENCEDFETCHFIDFIELDPROCFILEFILLFACTORFILTERFINALFIRSTFIRST_ROWSFIRST_VALUEFLAGFLAGGERFLOATFLOBFLOORFLUSHFORFORCEFOREIGNFORTRANFOUNDFRAME_ROWFREEFREELISTFREELISTSFREETEXTFREETEXTTABLEFREEZEFROMFSFULLFUNCTIONFUSIONGGENERALGENERATEDGETGLOBALGLOBAL_NAMEGLOBALIDGLOBALLYGOGOTOGRANTGROUPGROUPINGGROUPSHANDLERHASHHASHKEYSHAVINGHEADERHEAPHEXHIERARCHYHOLDHOLDLOCKHOURHOURSIDIDENTIFIEDIDENTITYIDENTITY_INSERTIDENTITYCOLIDGENERATORSIDLE_TIMEIFIGNOREILIKEIMMEDIATEIMMEDIATELYIMPLEMENTATIONIMPORTININCLUDINGINCLUSIVEINCREMENTIND_PARTITIONINDENTINDEXINDEXEDINDEXESINDICATORINHERITINITIALINITIALLYINITRANSINNERINOUTINSENSITIVEINSERTINSTANCEINSTANCESINSTANTIABLEINSTEADINTINTEGERINTEGRITYINTERMEDIATEINTERSECTINTERSECTIONINTOISISNULLISOBIDISOLATIONISOLATION_LEVELITERATEJARJOINKKEEPKEYKEY_MEMBERKEY_TYPEKILLLABELLAGLANGUAGELASTLAST_VALUELATERALLAYERLC_CTYPELEADLEADINGLEAVELEFTLENLENGTHLESSLEVELLIBRARYLIKELIKE_REGEXLIMITLINENOLINKLISTLNLOADLOBLOCALLOCALELOCALTIMELOCALTIMESTAMPLOCATORLOCATORSLOCKLOCKEDLOCKMAXLOCKSIZELOGLOGFILELOGGINGLOGICAL_READS_PER_CALLLOGICAL_READS_PER_SESSIONLONGLOOPLOWERMMAINTAINEDMANAGEMAPMASTERMATCHEDMATERIALIZEDMAXMAX_CARDINALITYMAX_MEASUREMAXARCHLOGSMAXDATAFILESMAXEXTENTSMAXINSTANCESMAXLOGFILESMAXLOGHISTORYMAXLOGMEMBERSMAXSIZEMAXTRANSMAXVALUEMEMBERMERGEMESSAGE_LENGTHMESSAGE_OCTET_LENGTHMESSAGE_TEXTMETHODMICROSECONDMICROSECONDSMINMIN_MEASUREMINEXTENTSMINIMUMMINUSMINUTEMINUTESMINVALUEMLS_LABEL_FORMATMLSLABELMODMODEMODIFIESMODIFYMODULEMONTHMONTHSMOREMOUNTMOVEMTS_DISPATCHERSMULTISETMUMPSNAMESPACENATIONALNATURALNCHARNCHAR_CSNCLOBNEEDEDNESTEDNESTINGNETWORKNEWNEXTNEXTVALNFCNFDNFKCNFKDNILNONOARCHIVELOGNOAUDITNOCACHENOCHECKNOCOMPRESSNOCYCLENOFORCENOLOGGINGNOMAXVALUENOMINVALUENONCLUSTEREDNONENOORDERNOOVERRIDENOPARALLELNOREVERSENORMALNORMALIZENORMALIZEDNOSORTNOTNOTHINGNOTNULLNOWAITNTH_VALUENTILENULLNULLABLENULLIFNULLSNUMBERNUMERICNUMOFPTSNUMPARTSNVARCHAR2OBIDOBJECTOBJECTIDOBJNOOBJNO_REUSEOCCURRENCES_REGEXOCTET_LENGTHOCTETSOFOFFOFFLINEOFFSETOFFSETSOIDOIDINDEXOLDONONLINEONLYOPCODEOPENOPENDATASOURCEOPENQUERYOPENROWSETOPENXMLOPTIMALOPTIMIZATIONOPTIMIZEOPTIMIZER_GOALOPTIONORORDERORDERINGORDINALITYORGANIZATIONOSLABELOTHERSOUTOUTEROUTPUTOVEROVERFLOWOVERLAPSOVERRIDINGOWNPPACKAGEPADPADDEDPARALLELPARAMETERPARAMETER_MODEPARAMETER_NAMEPARAMETER_ORDINAL_POSITIONPARAMETER_SPECIFIC_CATALOGPARAMETER_SPECIFIC_NAMEPARAMETER_SPECIFIC_SCHEMAPARTPARTITIONPARTITIONEDPARTITIONINGPASCALPASSTHROUGHPASSWORDPASSWORD_GRACE_TIMEPASSWORD_LIFE_TIMEPASSWORD_LOCK_TIMEPASSWORD_REUSE_MAXPASSWORD_REUSE_TIMEPASSWORD_VERIFY_FUNCTIONPATHPCTFREEPCTINCREASEPCTTHRESHOLDPCTUSEDPCTVERSIONPERCENTPERCENT_RANKPERCENTILE_CONTPERCENTILE_DISCPERIODPERMANENTPERMISSIONPIECESIZEPIVOTPLACINGPLANPLIPLSQL_DEBUGPOINTSPORTIONPOSITION_REGEXPOST_TRANSACTIONPOWERPRECEDESPRECISIONPREPAREPRESERVEPREVVALPRIMARYPRINTPRIORPRIQTYPRIVATEPRIVATE_SGAPRIVILEGEPRIVILEGESPROCPROCEDUREPROFILEPROGRAMPSIDPUBLICPURGEQUERYQUERYNOQUEUEQUOTARAISERRORRANGERANKRAWRBAREADREADSREADTEXTREADUPREALREBUILDRECONFIGURERECOVERRECOVERABLERECOVERYREFREFERENCESREFERENCINGREFRESHREGR_AVGXREGR_AVGYREGR_COUNTREGR_INTERCEPTREGR_R2REGR_SLOPEREGR_SXXREGR_SXYREGR_SYYRELEASERENAMEREPEATREPLACEREPLICATIONREQUIRINGRESETRESETLOGSRESIGNALRESIZERESOURCERESPECTRESTORERESTRICTRESTRICTEDRESULTRESULT_SET_LOCATORRETURNRETURNED_CARDINALITYRETURNED_LENGTHRETURNED_OCTET_LENGTHRETURNED_SQLSTATERETURNINGRETURNSREUSEREVERSEREVERTREVOKERIGHTROLEROLESROLLBACKROLLUPROUND_CEILINGROUND_DOWNROUND_FLOORROUND_HALF_DOWNROUND_HALF_EVENROUND_HALF_UPROUND_UPROUTINEROUTINE_CATALOGROUTINE_NAMEROUTINE_SCHEMAROWROW_COUNTROW_NUMBERROWCOUNTROWGUIDCOLROWIDROWNUMROWSROWSETRULERUNSAMPLESAVESAVEPOINTSB4SCALESCAN_INSTANCESSCHEMASCHEMA_NAMESCNSCOPESCOPE_CATALOGSCOPE_NAMESCOPE_SCHEMASCRATCHPADSD_ALLSD_INHIBITSD_SHOWSECONDSECONDSSECQTYSECTIONSECURITYSECURITYAUDITSEG_BLOCKSEG_FILESEGMENTSELECTSELECTIVESELFSEMANTICKEYPHRASETABLESEMANTICSIMILARITYDETAILSTABLESEMANTICSIMILARITYTABLESENSITIVESEQUENCESERIALIZABLESERVER_NAMESESSIONSESSION_CACHED_CURSORSSESSION_USERSESSIONS_PER_USERSETSETSSETUSERSHAPESHARESHAREDSHARED_POOLSHRINKSHUTDOWNSIGNALSIMILARSIMPLESIZESKIPSKIP_UNUSABLE_INDEXESSMALLINTSNAPSHOTSOMESORTSOURCESPACESPECIFICSPECIFIC_NAMESPECIFICATIONSPECIFICTYPESPLITSQLSQL_TRACESQLCODESQLERRORSQLEXCEPTIONSQLSTATESQLWARNINGSQRTSTANDARDSTANDBYSTARTSTATESTATEMENTSTATEMENT_IDSTATICSTATISTICSSTAYSTDDEV_POPSTDDEV_SAMPSTOGROUPSTOPSTORAGESTORESTORESSTRUCTURESTYLESUBCLASS_ORIGINSUBMULTISETSUBSTRING_REGEXSUCCEEDSSUCCESSFULSUMSUMMARYSWITCHSYMMETRICSYNONYMSYS_OP_ENFORCE_NOT_NULL$SYS_OP_NTCIMG$SYSDATESYSDBASYSOPERSYSTEMSYSTEM_TIMESYSTEM_USERSYSTIMESYSTIMESTAMPSYSUUIDTTABLETABLE_NAMETABLESTABLESAMPLETABLESPACETABLESPACE_NOTABNOTEMPORARYTEXTSIZETHANTHETHENTHREADTIESTIMETIMESTAMPTIMEZONE_HOURTIMEZONE_MINUTETOTOKENTOPTOP_LEVEL_COUNTTOPLEVELTRACETRACINGTRAILINGTRANTRANSACTIONTRANSACTION_ACTIVETRANSACTIONS_COMMITTEDTRANSACTIONS_ROLLED_BACKTRANSFORMTRANSFORMSTRANSITIONALTRANSLATETRANSLATE_REGEXTRANSLATIONTRIGGERTRIGGER_CATALOGTRIGGER_NAMETRIGGER_SCHEMATRIGGERSTRIM_ARRAYTRUETRUNCATETRY_CONVERTTSEQUALTXTYPEUB2UBAUESCAPEUIDUNARCHIVEDUNDERUNDOUNIONUNIQUEUNLIMITEDUNLINKUNLOCKUNNAMEDUNNESTUNPIVOTUNRECOVERABLEUNTILUNTYPEDUNUSABLEUNUSEDUPDATABLEUPDATEUPDATETEXTUPPERURIUSAGEUSEUSERUSER_DEFINED_TYPE_CATALOGUSER_DEFINED_TYPE_CODEUSER_DEFINED_TYPE_NAMEUSER_DEFINED_TYPE_SCHEMAUSINGUTCDATEUTCTIMEUTCTIMESTAMPVALIDATEVALIDATIONVALIDPROCVALUEVALUE_OFVALUESVAR_POPVAR_SAMPVARBINARYVARCHARVARCHAR2VARIABLEVARIADICVARIANTVARYINGVCATVERBOSEVERSIONINGVIEWVOLATILEVOLUMESWAITFORWHENWHENEVERWHEREWHILEWIDTH_BUCKETWINDOWWITHWITHINWITHIN GROUPWITHOUTWLMWORKWRITEWRITEDOWNWRITETEXTWRITEUPXIDXMLAGGXMLBINARYXMLCASTXMLCOMMENTXMLDECLARATIONXMLDOCUMENTXMLEXISTSXMLITERATEXMLNAMESPACESXMLQUERYXMLSCHEMAXMLTABLEXMLTEXTXMLVALIDATEYEARYEARSZONE
Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
