User receives an error when a DM flow tries to create a new target table: FOC209

Diagnostics

Product: DataMigrator

Release: 8205

Primary OS: Windows

Solution Date: 2019-10-15

Symptom

(FOC209) THE DATA VALUE EXCEEDS ITS LENGTH SPECIFICATION: rollup_bootstrap_markers_bacebbde18e243a7b3fb4bbdf2b2c0ef_crm_hive

Problem

The user receives the error message above when a DataMigrator flow tries to create a new target table.

Solution

The segment names for the new target synonym files are longer than the 64 characters size limit. To address this issue, use values that are 64 characters or less.

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.