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.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21700893