I'm trying to make a (dynamic) feature layer from join analysis in AGOL. I own both feature layers and the join is based on attributes. However, I keep getting an ""Unable to add feature service definition" error, with a corrupted layer being created as a result.
One of the feature layers is a view. Is that a problem? I have attempted the join using the original feature layer that the view is based on and still get the error.
Layer 1 has the following fields: Username, Port, County, Email, Vessel, SurveyYear, Initials.
Layer 2 (the view) has a lot more fields, which include: start, end, username, email, deviceid, version, datesSurveyStart, datesSurveyEnd, surveyID, datesTrip, datesTripDay, dateTrip. The other field names are specific to the project and are clearly not reserved words.
Are there any reserved words that jump out from those lists as causing the problem?
The intention is for the one-to-many join to be based on Layer 1's 'Username' and Layer 2's hidden 'Creator' attributes.
Thanks for any help.