Troubleshooting
Problem
An error occurs when you create the Information Store database in a deployment of i2 Analyze version 4.3.2 or earlier with SQL Server on Red Hat Linux.
Symptom
When the Information Store database is being created, the following error message is displayed:
```
Sqlcmd: '/tmp/iap.4077143618555635781.create-database-storage.sql': Unexpected argument. Enter '-?' for help.
Ignoring error caught while creating database and assuming that the database already exists.
Error message: java.io.IOException: SQL Server sqlcmd utility returned an unexpected exit value: 1.
```
Please note that the number on the error (here, 4077143618555635781) might be different.
Cause
This is caused by an issue in the Microsoft SQL CMD tools version 17.4 to 17.6.
Resolving The Problem
The issue is fixed in the SQL CMD tools version 17.7 and later. To deploy the Information Store, install version 17.7 or later of the SQL CMD tools. For more information about installing or updating the tools, see https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-tools?view=sql-server-2017#RHEL
Document Location
Worldwide
[{"Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXVTH","label":"i2 Analyze"},"ARM Category":[{"code":"a8m0z000000cwkBAAQ","label":"i2 Enterprise Insight Analysis->Deployment"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.3.0"}]
Was this topic helpful?
Document Information
More support for:
i2 Analyze
Component:
i2 Enterprise Insight Analysis->Deployment
Software version:
4.3.0
Document number:
6410848
Modified date:
02 February 2021
UID
ibm16410848