Problem with error: System.InvalidOperationException: No value was provided for parameter inputValue

[Dieter Becker]

I cannot get passed this error. The inputValue is a parameter for a stored procedure to be called. The Information Link works, If I directly add the parameter on the Information Link and click "Open Data" I get the respective result. So the stored procedure can be reached and executed. Thanks a lot for any hints to get this resolved

ilParams = InformationLinkParameter.CreateNamedParameter(paramName, paramValues)

print ilParams.Values

# second is info link paramateters created above

ilDataSource = InformationLinkDataSource("60fa95ce-83c1-4856-9dbf-5f6f2e0e575f", [ilParams])

print ilDataSource

#Check if new table already exists

if dt != None:

#If exists, replace it

dt.ReplaceData(ilDataSource)

else:

#If it does not exist, create new

Document.Data.Tables.Add("Results",ilDataSource) --> HERE IS THE ERROR

Here the output:

Cannot find data table: Results. Returning None

34681

Array[object](('34681'))

Traceback (most recent call last):

File "", line 70, in

Exception: Failed to execute data source query for data source "".

 

Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query for data source "". ---> Spotfire.Dxp.Data.Exceptions.ImportException: Failed to open data source. ---> System.InvalidOperationException: No value was provided for parameter inputValue

at Spotfire.Dxp.Data.DataProperties.ConfigurationParameterManager.GetOrPromptForParameterValue(String parameterName, Type type)

at Spotfire.Dxp.Data.Import.InformationLinkDataSource.UpdateNamedParameters(JobSpec jobSpec, ConfigurationParameterManager parameterManager)

at Spotfire.Dxp.Data.Import.InformationLinkDataSource.ConnectCore(IServiceProvider serviceProvider, DataSourcePromptMode promptMode, DataLoadSettings loadSettings)

at Spotfire.Dxp.Data.DataSource.ConnectWithoutPrompting(IServiceProvider serviceProvider, DataSourcePromptMode promptMode, Boolean updateInternalState, DataLoadSettings loadSettings)

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

at Spotfire.Dxp.Data.DataSource.ConnectWithoutPrompting(IServiceProvider serviceProvider, DataSourcePromptMode promptMode, Boolean updateInternalState, DataLoadSettings loadSettings)

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

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

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

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

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)