KB483730: There Is an Error "An Update or Insert Value Is a String That Is Too Long for the Column" While Loading Data in Enterprise Manager

Description

In MicroStrategy 10 and later versions, a line like the one below appears in the DSSErrors.log file while loading data if your database type is DB2 and the byte length of some objects' description, name, or abbreviation is more than 255.

2019-09-01 16:04:34.555-05:00
[HOST:lmwttsccap2p][SERVER:CastorServer][PID:140370][THR:3491215104]
[Database Classes][Error] Execute Parameterized Query failed.
Error type: Odbc error.
Odbc operation attempted: SQLExecute. [22001:-302: on HSTMT]
[MicroStrategy][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and
Linux]Character data, right truncation occurred; for example, an update or
insert value is a string that is too long for the column, or a datetime value
cannot be assigned to a host variable, because it is too small. For more
information, please consult DB2 document for error code SQL0-302.

Connection String: DSN=PROD_EM;UID=mstrem01;ENABLEBATCHSUPPORT=1;
IPADDRESS=msprdaxdb2.nam.nsroot.net;TCPPORT=60012;DATABASE=MSEMP01;.

SQL Statement:
INSERT INTO STG_IS_FILT (EM_ACCESS_ID,EM_MODIF_DATE,EM_HIDDEN_ID,
IS_REPOSITORY_GUID,IS_FILT_LOC,EM_OWNER_GUID,EM_DELETION_DATE,IS_PROJ_GUID,IS_FILT_VER,IS_FILT_GUID,EM_CREATE_DATE,IS_FILT_ABBREV,IS_FILT_NAME,IS_FILT_DESC) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?).

Why is this happening?

The cause is the definition inconsistency between Enterprise Manager warehouse and metadata. In the EM warehouse, the length of some columns is shorter than their definition in the metadata.

Workaround

1. Find a similar log in the 
2. Open
3. Run the following SQL query, assuming that the table name you want to change is
4. Update the warehouse catalog.