Library Data Import via Custom Automation Job

[Walter Mauch]

I am trying to import data to the Spotfire via custom Automation job. I am using Spotfire 10.3.3 HF-024

I also tried this on Spotfire 11.4.1 with the same result.

The job downloads a CSV dataset i from the web service, opens a new analysis document from the file data source, and then saves the table to the Library.

It works perfectly, when I execute the job locally, but on the server it throws an exception:

 

10/21/2021 2:08:05 PM.109 | info | Saved file to C:Windowssystem32configsystemprofileAppDataRoamingentimoSpotfireimpae63770422085018.csv

10/21/2021 2:08:05 PM.128 | error | Exception while saving file to library

10/21/2021 2:08:05 PM.128 | error | Failed to execute data source query for data source "impae63770422085018". - Spotfire.Dxp.Data

10/21/2021 2:08:05 PM.128 | error | at Spotfire.Dxp.Data.DataSourceConnection.d__37.MoveNext()

at Spotfire.Dxp.Data.Persistence.DataPool.d__15.MoveNext()

at Spotfire.Dxp.Data.Producers.SourceColumnProducer.OnConfigure()

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.DocumentModel.Node.c.b__47_0(Node node)

at Spotfire.Dxp.Framework.DocumentModel.UndoableListAvlLeaf`1.ForEachChild(Action`1 action, Boolean includeFrozen)

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.DocumentModel.Node.c.b__47_0(Node node)

at Spotfire.Dxp.Framework.DocumentModel.UndoableList`1.ForEachChild(Action`1 action, Boolean includeFrozen)

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.DocumentModel.Node.c.b__47_0(Node node)

at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.c__DisplayClass92_0.b__0(IDocumentNodeChild documentNodeChild)

at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.ForEachChild(IDocumentNodeChild[] children, Action`1 action)

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, IndeterminateProgressFormatter progressFormatter, ProgressOperation operation)

at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.ConfigureAndAttachFromNew()

at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.AttachSubTreeWhileExecuting(UndoableNodeBase newOwner)

at Spotfire.Dxp.Framework.DocumentModel.UndoableNode.Spotfire.Dxp.Framework.DocumentModel.IUndoableNode.AttachItemToUndoableNode(Object item)

at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.c__DisplayClass43_0.b__0()

at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException, Boolean isStreamingProperty)

at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.Insert(Int32 index, TNode item)

at Spotfire.Dxp.Data.DataTableCollection.c__DisplayClass89_0.b__0()

at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException, Boolean isStreamingProperty)

at Spotfire.Dxp.Data.DataTableCollection.Add(DataTable dataTable)

at Spotfire.Dxp.Application.PartiallyOpenedDataSource.d__9.MoveNext()

at Spotfire.Dxp.Application.AnalysisApplication.d__91.MoveNext()

at Spotfire.Dxp.Application.AnalysisApplication.d__84.MoveNext()

at Spotfire.Dxp.Application.AnalysisApplication.ConsumeDataLoadPromptRequests(IEnumerable`1 prompts)

at Spotfire.Dxp.Application.AnalysisApplication.Open(DataSource source, DocumentOpenSettings settings)

at EntimiceAutomationTask.EntimICETask.openDatasource(String source, String tableName) in V:SpotfireSpotfireAutomationTaskEntimICETask.cs:line 279

at EntimiceAutomationTask.EntimICETask.saveSingleSource(String localFile, SystemNode node) in V:SpotfireSpotfireAutomationTaskEntimICETask.cs:line 172

10/21/2021 2:08:05 PM.128 | info | Tools - remove file C:Windowssystem32configsystemprofileAppDataRoamingentimoSpotfireimpae63770422085018.csv

Is there a way to solve this

Thanks