SYMPTOM:
The following error is obtained when attempting to run a report against Vertica 4.0 warehouse in Strategy:
SQLEngine got an Exception from DFC: Engine Logic: The column #####'s datatype 18 with precision 1000 scale -2147483648 is not supported.
Following entries are caught in the DSSErrors.log:
SQLEngine got an Exception from DFC: Engine Logic: The column ####'s datatype 18 with precision 1000 scale -2147483648 is not supported.
(Data type conversion failed: from DSS type to native type. Database type: Data type conversion failed: from DSS type to native type. Database type: SQLEngine got an Exception from DFC: Engine Logic: The column ####'s datatype 18 with precision 1000 scale -2147483648 is not supported.Error in Process method of Component: SQLEngineServer, Project ####, Job 263, Error Code= -2147212800.)
It is noticed that the concerned Vertica 4.0 NVarChar column's Byte length has been set as 1000 as shown below:
CAUSE:
This is a known issue in Strategy Engine. Vertica column type NVarChar with precision greater than 255 characters is not supported.
ACTION:
Launch the attribute editor, and change the NVarChar column precision to be a number lower than 255.
