IBM Support

Getting an error when trying to enable Search 360 after upgrading IBM i2 iBase database.

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)

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"}]

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