Search code examples
jsonsql-servercoldfusioncoldfusion-2016

Error converting Data to JSON in ColdFusion

I have an application that has MS SQL Server as the backend database, ColdFusion server and front end is Angular. I am getting the following error when trying to retrieve data from a few tables in the database. It doesn't impact all data but only a few tables

message=JSON serialization failure: Unable to serialize binary data to JSON

Code to serialize data:

<cfset responseString = serializeJSON( apiResponse.data )>

Any ideas how to resolve this issue?

Solution

  • I was able to resolve the issue with Miguel's direction. The SQL Server database included a few tables which were migrated from another Access database and these tables included a column named SSMA_Timestamp. The value in this column was a binary one. I cleansed the database and queries to exclude this column and all worked fine.

    Thanks to @Miguel-F for a quick response.