User receives an error running DataMigrator Flow: ICM18040 Return Code = 1406

Diagnostics

Product: DataMigrator

Release: 8207

Primary OS: Linux

Solution Date: 2021-01-20

Symptom

(ICM18040)   Return Code = 1406

Problem

The user receives the error message above running a DataMigrator Flow. The DataMigrator flow log does not provide any further details.

Solution

Enabling the DataMigrator Server traces identified this as a permissions issue within the target RDBMS:

(FOC1400) SQLCODE IS 262 (HEX: 00000106) XOPEN: 42000

(FOC1500)  :  [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]CREATE

(FOC1500)  :  TABLE permission denied in database 'KCUDB_Prologue'.

(FOC1406) SQL OPEN CURSOR ERROR.

To address this, give the user ID adequate permissions.

Information is published on an "as is" basis without a warranty of any kind. Information Builders, Inc. ("IBI") hereby represents that such information has not been subject to any formal testing or review by IBI. IBI assumes no responsibility for usage of such information, including the implementation of solutions associated therewith. The customer assumes responsibility for the results obtained from such information. IBI is not responsible for and shall not be held liable for the results obtained, including but not limited to any errors, delays or omissions. IBI disclaims any liability for the completeness or accuracy of such information.