service account can not reload data from Excel/CSV in Web Player

[Wei Li]

Hi,

I created a service account in Google and used it in Web Player for loading data from Excel/CSV file. (This issue doesn't occur for Google Sheet.)

However it doesn't work in Web Player when trying to reload the data.

I always go "Missing Data" error in Web Player. It works fine if not using service account. Also I have shared the Excel/CSV files with the service account.

Please kindly help to fix this.

The error is as below,

DEBUG;2021-10-12T10:05:21,972+09:00;2021-10-12 01:05:21,972;cb48d9a0-5529-4b83-a983-811d80a7dbd4;1209400f55P57j;WorkThread 123_1209;admin WAT 3;226f66a774d5e37eea7486b894679aed;Spotfire.Dxp.Data.Access.QueryExecution.QueryTrackerService;"03a894e7-ac07-408b-9848-e60e63ac7c90: Executing query (SELECT [demographic.csv].[iD] AS [iD], [demographic.csv].[AGE_IN_YEARS] AS [AGE_IN_YEARS], [demographic.csv].[LEVEL_OF_EDUCATION] AS [LEVEL_OF_EDUCATION], [demographic.csv].[YEARS_WITH_CURRENT_EMPLOYER] AS [YEARS_WITH_CURRENT_EMPLOYER], [demographic.csv].[YEARS_AT_CURRENT_ADDRESS] AS [YEARS_AT_CURRENT_ADDRESS]

FROM [demographic.csv] AS [demographic.csv]) failed after 837 ms (Number of columns = N/A). Cause: An error occurred in the external data source.

External error:

Google Sheet contained no rows"

DEBUG;2021-10-12T10:05:22,082+09:00;2021-10-12 01:05:22,082;cb48d9a0-5529-4b83-a983-811d80a7dbd4;1209400f55P57j;WorkThread 123_1209;admin WAT 3;226f66a774d5e37eea7486b894679aed;Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink;"B214281A-FAC3-43E6-B7AD-4A3E71AAECC2 Execution Time 979 ms"

DEBUG;2021-10-12T10:05:22,083+09:00;2021-10-12 01:05:22,083;cb48d9a0-5529-4b83-a983-811d80a7dbd4;1209400f55P57j;WorkThread 123_1209;admin WAT 3;226f66a774d5e37eea7486b894679aed;Spotfire.Dxp.Data.Queries.External;"(none) - (none)"

WARN ;2021-10-12T10:05:22,084+09:00;2021-10-12 01:05:22,084;cb48d9a0-5529-4b83-a983-811d80a7dbd4;1209400f55P57j;WorkThread 123_1209;admin WAT 3;226f66a774d5e37eea7486b894679aed;Spotfire.Dxp.Data.DataTable;"Prompting for failed to open table."

Spotfire.Dxp.Data.Exceptions.ImportException: An error occurred in the external data source.

External error:

Google Sheet contained no rows

 

Data connection:

Google Sheets (Custom)

 

Document ID:

1_KuE38Kx1eNyd2b4wQiyNm6tWz1ugzwI

 

Document Name:

demographic.csv

 

Document Type:

CSV

 

Items:

demographic.csv

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.CreateView(ManagedDataConnection dataConnection, Guid virtualJoinViewId, DataTableSchema schema, Guid promptCollectionId, CxxSession session, IServiceProvider serviceProvider, GlobalMethodRegistry globalMethodRegistry, NotificationService notificationService, Int32 rowLimit, PendingViewRequestsManager pendingViewRequestsManager)

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.GetColumnsAndProperties()

at Spotfire.Dxp.Data.Persistence.DataItem.PerformUpdate(DataColumnProducer producer, Boolean forceUpdate)

at Spotfire.Dxp.Data.Persistence.DataPool.GetDerivedData(DataColumnProducer producer, Boolean loadingPre50CalculatedColumnProducer, DataPoolReferenceType dataPoolReferenceType)

at Spotfire.Dxp.Data.Persistence.DataPool.GetData(DataColumnProducer producer, Boolean loadingPre50CalculatedColumnProducer, DataPoolReferenceType dataPoolReferenceType)

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.PoolReferenceCompute_(DocumentNode node)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.ComputeValue(NonSharedRuntimePropertyValue`1 runtimePropertyValue, StatelessPropertyComputer`1 propertyComputer, DocumentNode ownerNode)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.c__DisplayClass33_1.b__0()

at Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.EvaluateWithLimitationTarget(ILimitationTarget limitationTarget, Executor executor)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.LookupOrEvaluateValue(StatelessPropertyComputer`1 propertyComputer, DocumentNode ownerNode, StatelessDependencyDeclarer dependencyDeclarer)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.GetValue(StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.c__DisplayClass29_0.b__2()

at Spotfire.Dxp.Framework.DocumentModel.DocumentView.Use(DocumentView documentView, DocumentViewExecutionState documentViewExecutionState, Action action)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.b__29_0()

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.LoadData(Boolean willPotentiallyLoadData)

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.d__120.MoveNext()

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.d__95.MoveNext()

at Spotfire.Dxp.Data.DataTable.d__292.MoveNext()

DEBUG;2021-10-12T10:05:22,088+09:00;2021-10-12 01:05:22,088;cb48d9a0-5529-4b83-a983-811d80a7dbd4;1209400f55P57j;114;admin;226f66a774d5e37eea7486b894679aed;Spotfire.Dxp.Framework.Utilities.ServerLoggerManager;"ServiceInstanceId will not be added since the position is already occupied: Spotfire.GoogleSheetsCustomAdapter, Connection type: Google Sheets (Custom)

Document ID: 1_KuE38Kx1eNyd2b4wQiyNm6tWz1ugzwI

Document Name: demographic.csv

Document Type: CSV

Items: demographic.csv

, SELECT "demographic.csv"."ID" AS "ID", "demographic.csv"."AGE_IN_YEARS" AS "AGE_IN_YEARS", "demographic.csv"."LEVEL_OF_EDUCATION" AS "LEVEL_OF_EDUCATION", "demographic.csv"."YEARS_WITH_CURRENT_EMPLOYER" AS "YEARS_WITH_CURRENT_EMPLOYER", "demographic.csv"."YEARS_AT_CURRENT_ADDRESS" AS "YEARS_AT_CURRENT_ADDRESS" FROM "demographic.csv" AS "demographic.csv", 0, 979, , "

DEBUG;2021-10-12T10:05:22,088+09:00;2021-10-12 01:05:22,088;cb48d9a0-5529-4b83-a983-811d80a7dbd4;1209400f55P57j;114;admin;226f66a774d5e37eea7486b894679aed;Spotfire.Dxp.Framework.Utilities.ServerLoggerManager;"Server log manager did not log Audit since category is disabled: 2021-10-12T10:05:22,088+09:00, 172.31.45.31, data_connector_wp, get_data, False, , , Spotfire.GoogleSheetsCustomAdapter, Connection type: Google Sheets (Custom) Document ID: 1_KuE38Kx1eNyd2b4wQiyNm6tWz1ugzwI Document Name: demographic.csv Document Type: CSV Items: demographic.csv , SELECT "demographic.csv"."ID" AS "ID", "demographic.csv"."AGE_IN_YEARS" AS "AGE_IN_YEARS", "demographic.csv"."LEVEL_OF_EDUCATION" AS "LEVEL_OF_EDUCATION", "demographic.csv"."YEARS_WITH_CURRENT_EMPLOYER" AS "YEARS_WITH_CURRENT_EMPLOYER", "demographic.csv"."YEARS_AT_CURRENT_ADDRESS" AS "YEARS_AT_CURRENT_ADDRESS" FROM "demographic.csv" AS "demographic.csv", 0, 979, , ."

 

Thanks.

Regards,

Wei Li

[Manpreet Singh]

does the custom connector in webplayer only work with service account I am able to connect to sheets in Analyst, but in webplayer I always get authorization error.

[Dave Leigh]

Please download the newest version 10.3.0.17 or 11.5.0.17 and try again. This issue.should be resolved.