Itgenclr113 Unexpected character following indexer: a on Freshdesk survey_questions_accepted_ratings

Questions
, , ,
1

I’m trying to query our Freshdesk survey data, but on one of the tables (freshdesk.survey_questions_accepted_ratings), I receive the error:

unexpected character following indexer: a (DEFAULT). An unknown error occurred

I tried this in both the Power BI connector and the Invantive Query Tool. I don’t have any issues querying any of the other survey tables.

itgenclr113: Unexpected character following indexer: a. (DEFAULT)
An unknown error occurred.
Message ID: 77f08de2-017b-46a4-8c10-005fcc430e1f
Occurred (UTC): 13/12/21 09:56:47
select * from Freshdesk.Freshdesk.survey_questions_accepted_ratings limit 50
Newtonsoft.Json.JsonException
at Newtonsoft.Json.Linq.JsonPath.JPath.ParsePath(List`1 filters, Int32 currentPartStartIndex, Boolean query)
at Newtonsoft.Json.Linq.JsonPath.JPath.ParseMain()
at Newtonsoft.Json.Linq.JToken.SelectTokens(String path)
at Invantive.Data.Providers.OData.ODataProvider.RDQ.MoveNext()
at Invantive.Data.Providers.OData.ODataProvider.ExtractRowsFromData(GlobalState owner, ExecutionOptions executionOptions, ObjectDefinition objectDefinition, QueryObject queryObject, ParameterList parameters, List`1 rows, String basePath, List`1 allFieldTypes, JToken dataToken, JsonDatabaseColumnDefinitionCollection fields, AdditionalResultInformation additionalInfo, String partitionCode, HashSet`1 selectFields)
at Invantive.Data.Providers.Freshdesk.FreshdeskProvider.ReadDataFromJsonToken(GlobalState owner, ExecutionOptions executionOptions, JToken token, ExecutionStatistics executionStatistics, String basePath, List`1 allFieldTypes, List`1 rows, ODataObjectDefinition objectDefinition, JsonDatabaseColumnDefinitionCollection fields, QueryObject queryObject, ParameterList parameters, Int32& rowsRetrieved, AdditionalResultInformation additionalInfo, String url, String partitionCode, HashSet`1 selectFields)
at Invantive.Data.Providers.Freshdesk.FreshdeskProvider.GetAndReadTextFromServiceResponse(GlobalState owner, ExecutionOptions executionOptions, List`1 rows, String basePath, List`1 allFieldTypes, String url, String partitionCode, ODataObjectDefinition objectDefinition, JsonDatabaseColumnDefinitionCollection fields, QueryObject queryObject, ParameterList parameters, Int32& pagesRetrieved, Int32& rowsRetrieved, Int64& bytesRetrieved, AdditionalResultInformation additionalInfo, String callSafeNameOverrule, Boolean allowRetry, Boolean preventRetryOnAuthenticationFailure, HashSet`1 selectFields)
at Invantive.Data.Providers.OData.ODataProvider.LBK.MoveNext()
at System.Linq.Enumerable.d__17`2.MoveNext()
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Linq.Enumerable.d__17`2.MoveNext()
at Invantive.Sql.V1.DataSourceOrFunctionTree.d__51.MoveNext()
at Invantive.Data.CompressedEnumerable`1.d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.VL.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.PL.MoveNext()
at Invantive.Data.CompressedEnumerable`1.d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.VL.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.PL.MoveNext()
at Invantive.Sql.V1.ChainedFirehose.TL.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.PL.MoveNext()
at Invantive.Sql.V1.SelectListIterator.JW.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.PL.MoveNext()
at Invantive.Data.CompressedEnumerable`1.d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.VL.MoveNext()
at Invantive.Data.ExtensionMethods.HFY`1.MoveNext()
at Invantive.Sql.V1.TopIterator.NH.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.PL.MoveNext()
at Invantive.Data.CompressedEnumerable`1.d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.VL.MoveNext()
at Invantive.Sql.V1.MaterializeSparseArrayIterator.d__1.MoveNext()
at Invantive.Sql.V1.QueryPlan.MW.MoveNext()
at Invantive.Data.ExtensionMethods.LFY`1.NFY.MoveNext()
at System.Collections.Generic.List`1…ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Invantive.Data.ConnectionManager.TF.K(QueryPlan )
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Linq.Buffer`1…ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Invantive.Data.ConnectionManager.ExecuteAndCombineQueryPlansV1(GlobalState owner, ExecutionOptions executionOptions, QueryPlan queryPlans, String sqlStatement, ParameterList parameters)
at Invantive.Data.ConnectionManager.ExecuteProviderPassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Invantive.Data.ConnectionManager.ExecuteProviderPassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)
at Invantive.Data.ConnectionManager.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Invantive.Data.ConnectionManager.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)
at Invantive.Data.ActionProceduresBase.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters)
at Invantive.Producer.Windows.Forms.DescribeTabData.XML(GlobalState , ExecutionOptions ) in C:\Users\gle3.WS212\Documents\ws-master\Invantive.Producer\src\Invantive.Producer.Windows.Forms\DetailsBase.cs:line 444

2

The error code itgenclr113 refers to invalid data in terms of the expected so-called JSON format.

The problem is caused by a bug in the metadata in the SQL-driver for Freshdesk specifically for accepted ratings on questions.

We have been unable to test this table’s correctness due to missing data and functionality, and it seems unused.

A fix has been applied to be included in the next release. This fix will solve the issue for you with high probability. Please test again with the next release of Invantive Query Tool, bound to be shipped before end of this week. The release will be noted as a separate answer once available. In case the table then still raises issues we will need access to your environment for limited time to ensure that the issue is resolved.

3

The release that fixes the issue has gone live.

4

Thanks for the update.

Unfortunately I’m now getting a different error:

Syntax error between the two '***' on line 1, column 19:
Freshdesk.Freshdesk***.***survey_questions_accepted_ratings...
Error: mismatched input '.' expecting {'@', '('}."
5

What is the precise query you are executing?

Is there some itgen... error code included?