Skip to main content
marcusm0003
Inspiring
Dec 29, 2022 8:48 AM UTC
Question

How to map a unique column VARBINARY(16) to a Record's Data Modal when the data type is RAW(16) DEFAULT SYS_GUID() to prevent sync failure

Dear Appian Community Team,

I am having at a Record's Data Modal using data sync to the SQL database table.

I would like to check with the team whether anyone knows whether we can map a Unique Column which is perceived as VARBINARY(16) on Appian Data Modal to ensure data sync successfully when the source code for the SQL is as below.

"ABCD" RAW(16) DEFAULT SYS_GUID() NOT NULL ENABLE, 

In terms of the error: 

1 reply

marcusm0003
Inspiring
Jan 3, 2023 7:57 AM UTC

Additional Information - Sync records are failing because of this one field. Failure to sync records information can be found here -docs.appian.com/.../Records_Monitoring_Details.html