Troubleshooting
Problem
If you have upgraded the iBase database and try to enable Search 360, it will cause the following error even if you have switched off the Search 360 before the upgrade.
System.Data.SqlClient.SqlException(0x80131904): Incorrect syntax near the keyword 'AS'.
Symptom
Snippet of the error message when you try to enable Search 360 after the upgrade.
System.Data.SqlClient.SqlException(0x80131904): Incorrect syntax near the keyword 'AS'.
at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, BooleanbreakConnection, Action`1 wrapCloseInAction)
at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at
System.Data.SqlClient.TdsParser.TryRun(RunBehaviorrunBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at
System.Data.SqlClient.SqlDataReader.get_MetaData()
at
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReaderds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, BooleanforDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReaderds, Boolean describeParameterEncryptionRequest)
at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, BooleanbreakConnection, Action`1 wrapCloseInAction)
at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at
System.Data.SqlClient.TdsParser.TryRun(RunBehaviorrunBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at
System.Data.SqlClient.SqlDataReader.get_MetaData()
at
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReaderds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, BooleanforDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReaderds, Boolean describeParameterEncryptionRequest)
Resolving The Problem
Please contact the technical Support team for a solution and further investigation.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXW43","label":"i2 iBase"},"ARM Category":[{"code":"a8m0z000000bo5KAAQ","label":"i2 iBase and i2 Analyst's WorkStation->Install\/Configure\/Upgrade"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
More support for:
i2 iBase
Component:
i2 iBase and i2 Analyst's WorkStation->Install/Configure/Upgrade
Software version:
All Versions
Operating system(s):
Windows
Document number:
6492957
Modified date:
27 September 2021
UID
ibm16492957