Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

System.Byte[] Error when Loading Binary Data Type

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

System.Byte[] Error when Loading Binary Data Type

Last Update:

Oct 28, 2021 3:39:42 AM

Updated By:

Sonja_Bauernfeind

Created date:

Apr 9, 2019 10:14:48 AM

The error System.Byte[] was occurring when attempting to load data from a binary data type column from MS SQL Server database.

Environment:
Qlik Sense Enterprise on Windows any version

Resolution:

This issue was resolved by creating a new column in the SQL Server database and converting the column to be varchar data type. Then this new varchar column could be read into Qlik Sense without any error.

This type of conversion function was used in the database in the process to create the new column:
Convert(NVARCHAR(MAX), "FieldName", 1) as Varchar_FieldName.

See Data Types for available Data Types in Qlik Sense. 

Labels (1)
Comments
janyf
Partner - Contributor III
Partner - Contributor III

I was able to extract varchar(max) binary as base64  into qlik via this select 

select id,
cast('' as xml).value(
'xs:base64Binary(sql:column("tbl_data.BINARYDATA"))', 'varchar(max)'
) as Data_binary
from "db".dbo."tbl_data";

Contributors
Version history
Last update:
‎2021-10-28 03:39 AM
Updated by: