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

Question

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:

marcusm0003 · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO