Ignore non-mandatory information link prompts [Data type: string] in an TIBCO Spotfire Automation Services job execution when replacing data table with information link.
Article ID: KB0082237
Updated On:
| Products | Versions |
|---|---|
| Spotfire Automation Services | All Versions |
| Spotfire Analyst | All Versions |
Description
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:
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 ---
Issue/Introduction
Ignore non-mandatory information link prompts [Data type: string] in an TIBCO Spotfire Automation Services job execution when replacing data table with information link.
Resolution
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.
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.
Feedback
Yes
No
Powered by
