GUID Issue with Write To Data Store Entity

We are generating the GUID from Appian side and trying to insert the data to database with the help of Write To Data Store Entity.

Example: AB_Asset (Table)

{AssetID: "15866454-9B93-43B1-BF55-B39D5BECD132", AssetName: "Laptop", AssetBrand: "APPLE"}

While trying to insert the above record through the Write To Data Store Entity we are getting below error.

An error occurred while trying to write to the entity “AB_Asset” [id=cc46109f-6ecb-4c8e-94f2-3d9767d2f0fe@6376, type=AB_Asset (id=3464)] (data store: AB Transaction Tables). Details: org.hibernate.exception.SQLGrammarException: could not insert: [ABAssetDT2949]: com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting from a character string to uniqueidentifier. Data: TypedValue[it=3465,v={{15866454-9B93-43B1-BF55-B39D5BECD132, "Laptop", "APPLE"}}]

But we are facing uniqueIdentifier issue when we use Query Database node.

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data