Product: TIBCO Spotfire®
Ignore non-mandatory information link prompts [Data type: string] in an TIBCO Spotfire Automation Services job execution when replacing data table with information link.
When you try to execute a TIBCO Spotfire Automation Services job which has a few tasks:
Task 1: Open from analysis file from library
Task 2: Replace Data table with Information Link (This Information links has prompts which are not mandatory).
Task 3: Save analysis back to library
You may encounter an error while executing the job:
Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query for data source "...". ---> Spotfire.Dxp.Data.Exceptions.InformationModelException: Failed to execute query: Incorrect syntax near ')'. ---> Spotfire.Dxp.Services.Data.InformationModel.InformationModelServiceException: Failed to execute query: Incorrect syntax near ')'. at Spotfire.Dxp.Services.WebServiceBase`1.InvokeService[T](ServiceMethod`1 serviceMethod, ExceptionFactoryMethod exceptionFactoryMethod) at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock() --- End of inner exception stack trace --- at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock() at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.Read(Byte buffer, Int32 offset, Int32 count) at Spotfire.Dxp.Internal.Utilities.SeekableStream.Read(Byte buffer, Int32 offset, Int32 count) at System.IO.BinaryReader.FillBuffer(Int32 numBytes) at System.IO.BinaryReader.ReadUInt16() at Spotfire.Dxp.Data.Formats.Sbdf.SbdfSectionHeader.ReadMagicNumber(BinaryReader reader) at Spotfire.Dxp.Data.Formats.Sbdf.SbdfSectionHeader.ReadSectionType(BinaryReader reader, SbdfSectionTypeId expectedType) at Spotfire.Dxp.Data.Import.SbdfDataRowReader.DelayedInit() at Spotfire.Dxp.Data.Import.InformationLinkDataSourceConnection.ExecuteQueryCore2() at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2() --- End of inner exception stack trace ---By default a "null" value was passed by the Automation services Job builder to the web service when executing the job. The job fails because it cannot accept null values. Since data type for the values is String, we can pass a "" [double quotes] instead.
On Task 2: Replace Data table with Information Link (This Information links has prompts which are not mandatory), select columns and click Edit. Enter "" [double quotes] into List of values(separated by comma) filed and click OK. Now, execute the job and it should succeed.