Data type compatibility while replacing or appending files

Column data types in the original and incoming file must be compatible to replace or append data in uploaded files.

Otherwise, IBM® Cognos® Analytics might return the MSR-UPL-2128 error. This error is thrown when the column data type in the original file is incompatible with the detected data type for the same column in the incoming file. The error is returned to prevent data type changes that might cause problems in existing dashboards, reports, or other content.

To avoid this error, ensure that the data types of columns in the original file and in the file that is used to replace or append data are compatible.

The following table shows compatible data types for the Replace file functionality:

Data type in the original file	Compatible data types in the incoming file
VARCHAR	VARCHAR, BIGINT, DOUBLE, DATE, TIME, TIMESTAMP
BIGINT	BIGINT, DOUBLE
DOUBLE	BIGINT, DOUBLE
DATE	DATE
TIME	TIME
TIMESTAMP	TIMESTAMP

Note: Please note the following scenarios when replacing a file:

The compatible data type replaces the data type BIGINT or DOUBLE in the original file. As a result, you might see the MSR-UPL-2128 error for the original file. For example, a file containing DOUBLE values was replaced with a file containing BIGINT values. Now, you can no longer append the original file containing the DOUBLE values.
A text (VARCHAR) column retains a text data type.

The following table shows compatible data types for the Append file functionality:

Data type in the original file	Compatible data types in the incoming file
VARCHAR	VARCHAR, BIGINT, DOUBLE, DATE, TIME, TIMESTAMP
BIGINT	BIGINT
DOUBLE	BIGINT, DOUBLE
DATE	DATE
TIME	TIME
TIMESTAMP	TIMESTAMP

Note: When appending a file with a compatible data type, the data type in the original file is preserved. In this case, you can see this type of error message:

MSR-UPL-2128 Original
column "Price" type “BIGINT" doesn't match column "Price" type "DOUBLE" at the same
position