Large string fields in DWH after 16.4.2 upgrade
Article ID: 444309
Updated On:
Products
Issue/Introduction
After upgrading Clarity from 16.4.1 to 16.4.2 large string fields that are enabled for DWH can not be found on the Data Providers Objects tab when expanding the object they belong to.
If we type in the attribute name on the search box, the field is visible. But we are unable to select it as the checkbox does not properly work.
And if selected, we can not move it from the Available section to the Selected section.
Large string attributes created once upgraded to 16.4.2 are fine.
Is there a known issue?
Environment
Clarity 16.4.2
Cause
In Clarity 16.4.2 Large String (Plan Text and Rich Text) fields have been enhanced.
Resolution
Proceed as follows in order to make the 16.4.1 Large Text fields available in reporting:
- Exclude the affected attribute from DWH
- Run the Full Load DWH job
- Include the affected attribute in DWH
- Run the Full Load DWH job
The fields will now be available for Reporting
Additional Information
Additionally, if the Large String field ID format contains a name_txt format, i.e my_large_string_txt, this will not be available for Reporting.
Feedback
