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