When executing a an update workflow in Quick Connect for Base Systems, the following error is generated on committing the workflow:
The identifier that starts with '<queryContainer query="SELECT dbo.database.field" is too long. Maximum length is 128.
See Screenshot: Error Message
Double Quotes are used for object identifiers for example: "hotel", and the SQL Server has the option QUOTED_IDENTIFIER = ON.
The identifier clause being passed in greater than 128 characters for example: Select * from Database Where (more then 128 characters in this where clause)
Plae this string in the very first line of the SQL SELECT Statement in the SQL connector Connection String to the SQL Server being used. QUOTED_IDENTIFIER = OFF
Create a view directly on the SQL Server and create a Query to connect directly to the view that has a shorter identifier clause than 128 characters.