Troubleshooting
Problem
A model or query referencing a Snowflake table, view or expression describes a character column with the precision 16777216.
Symptom
Reduces the size calculated for ibmcognos.fetchBufferSize.
Cause
A data type was declared as varchar without a precision or an expression which returns a varchar and Snowflake defaults to the largest precision.
Diagnosing The Problem
The precision of a column in a model has a very large precision.
Resolving The Problem
Explicitly define a precision when declaring a column in Snowflake.
Cast the column or expression to a Varchar with a smaller precision.
For further details, please refer to the Snowflake documentation on data types or contact Snowflake customer support.
Cast the column or expression to a Varchar with a smaller precision.
For further details, please refer to the Snowflake documentation on data types or contact Snowflake customer support.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7J","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl3zAAC","label":"Administration"},{"code":"a8m500000008d6oAAA","label":"Modeling"},{"code":"a8m0z0000001jkbAAA","label":"Reporting-\u003EPerformance"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Was this topic helpful?
Document Information
Modified date:
08 May 2025
UID
ibm17230126