Troubleshooting
Problem
In Framework Manager an error is returned when validating a query that uses a string data type.
Symptom
XQE-DAT-0013 cannot copy 551 characters to a varchar of length 512
Cause
In cases where the defined precision in the driver and the actual string length on the database don't match, Cognos throws an error.
Example with Databricks:
In Cognos, we evaluate the data and see that the largest string is at least 1002 which does not line up with what the Databricks default value is, which is 255.
In Cognos, we evaluate the data and see that the largest string is at least 1002 which does not line up with what the Databricks default value is, which is 255.
Resolving The Problem
To correct for this, we can update the data source connection string and override the default value with a larger one to allow this larger number to go through. See the vendors jdbc driver documentation for the connection parameter that can be used to increase the default value.
Databricks example:
Add the following connection parameter to the data source(you can change the size from 800 to whatever size you require for your data):
DefaultStringColumnLength=800
Based on the JDBC driver guide, this can be up to 32767
DefaultStringColumnLength=800
Based on the JDBC driver guide, this can be up to 32767
Related Information
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl3zAAC","label":"Administration"},{"code":"a8m50000000Cl6nAAC","label":"Data Source"}],"ARM Case Number":"TS014896563","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
10 January 2024
UID
ibm17106936