Automation Services Job fails on server not locally

[Brian van der Veer]

Hello,

We are trying to setup automated refresh of data tables in Automation Services Job Builder.

The data tables have an ODBC connection that is saved in the library (user and password).

If the job is run locally it works but not on the server. However, opening an embedded library item and then saving it on the server does work.

My guess is that though the user and password aresaved in the library, these credentials need to be given as an input on the server.

At this point we are lost how to do this for data tables with an ODBC connection.

Sincerely,

Brian van der Veer

Starting job Untitled on server http://mumc_spotfire/

FAILED: Task 1 'Open Analysis from Library' failed with: Spotfire.Dxp.Framework.Library.LibraryException: Import failed ---> Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query for data source "soa_query". ---> Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query for data source "soa_query". ---> System.InvalidOperationException: User input is need

at Spotfire.Dxp.Data.Import.DatabaseDataSource.d__a.MoveNext()

at Spotfire.Dxp.Data.DataSourceConnection.d__2.MoveNext()

--- End of inner exception stack trace ---

at Spotfire.Dxp.Data.DataSourceConnection.d__2.MoveNext()

at Spotfire.Dxp.Data.DataFlow.d__0.MoveNext()

at Spotfire.Dxp.Data.DataFlow.DataFlowConnection.d__d.MoveNext()

at Spotfire.Dxp.Data.DataSourceConnection.d__2.MoveNext()

--- End of inner exception stack trace ---

at Spotfire.Dxp.Data.DataSourceConne

Done