IBM Support

Error: AEQMJ0100E: Script error (The size of String or binary data is
too large for column, it should be truncated.)

Question & Answer


Question

The IBM SPSS Modeler DB Export node field sizes have been validated with predefined DB table fields. The insert still fails, why? Information: Executing SQL: INSERT INTO HCM."NO89_PRODUCTS" ("PRODUCT_ID", "LPAR_NAME", "CPC_SERIAL_NO", "CPC_MODEL_NO", "PRODUCT_NAME") VALUES (?, ?, ?, ?, ?) Error: The size of String or binary data is too large for column, it should be truncated. Information: Stream execution complete, Elapsed=53.67 sec, CPU=0.06 sec Warning: Execution was interrupted. Error: AEQMJ0100E: Script error (The size of String or binary data is too large for column, it should be truncated.)

Cause

Review system files being used as source file into the stream. Ensure all blank spaces have been stripped from the source data.

Answer

For this situation the system source file no89_parsed.csv was manually updated to reflect the following changes:

From:


//NO89LF
* NETVIEW PERF MONITOR V2 LF
5655-043=*NONE LF

To:
//NO89LF
* NETVIEW PERF MONITOR V2LF
5655-043=*NONELF

Where suffix LF is a LineFeed character normally hidden but shown here to give context.


Also, it would be possible within IBM SPSS Modeler to strip the trailing spaces through
the 'Expression' builder within various nodes.

[{"Product":{"code":"SSUFRL","label":"Capacity Management Analytics on z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF016","label":"Linux"}],"Version":"1.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21700893