https://community.blueprism.com/t5/Product-Forum/Unable-to-perform-Get-Collection-action-in-Data-SQL-Server-VBO/m-p/85604#M36576 works, thankyou ! Tue, 03 May 2016 15:54:00 GMT sneha_komatinen 2016-05-03T15:54:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-perform-Get-Collection-action-in-Data-SQL-Server-VBO/m-p/85599#M36571 I intend to do the following: 1. Connect to BluePrism Database from Process Studio 2. Execute certain query 3. Retrieve the output as a collection Able to connect successfully to database but facing below error at 'get collection' stage -- Internal : Unexpected error Can't convert System.Guid to a Blue Prism data type. I have tried 'Get CSV/Get CSV file' actions - which are working fine. Could you please help with this error. Let me know if you need any more info. Tue, 03 May 2016 11:09:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-perform-Get-Collection-action-in-Data-SQL-Server-VBO/m-p/85599#M36571 sneha_komatinen 2016-05-03T11:09:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-perform-Get-Collection-action-in-Data-SQL-Server-VBO/m-p/85600#M36572 If you are using windows authentication, please do not use username and password in ""Set Connection"" stage. Also write your query without using * symbol(Include column names in query). example:- Select name, id, description from [test].[dbo].[BPAPackage] Tue, 03 May 2016 11:48:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-perform-Get-Collection-action-in-Data-SQL-Server-VBO/m-p/85600#M36572 psagar 2016-05-03T11:48:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-perform-Get-Collection-action-in-Data-SQL-Server-VBO/m-p/85601#M36573 Thanks Sagar, yes 'Set connection' stage is working fine. And my query specifies the column list. Problem is specific to 'Get Collection' action. Error as below. Internal : Unexpected error Can't convert System.Guid to a Blue Prism data type. Tue, 03 May 2016 12:37:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-perform-Get-Collection-action-in-Data-SQL-Server-VBO/m-p/85601#M36573 sneha_komatinen 2016-05-03T12:37:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-perform-Get-Collection-action-in-Data-SQL-Server-VBO/m-p/85602#M36574 BluePrism does not support GUID data type. If you have guid column in your query, please exclude that column from the query or you can convert that column into varchar like "" Select name, convert(varchar(50), userid) as userID from [test].[dbo].[BPAPackage] Tue, 03 May 2016 13:12:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-perform-Get-Collection-action-in-Data-SQL-Server-VBO/m-p/85602#M36574 psagar 2016-05-03T13:12:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-perform-Get-Collection-action-in-Data-SQL-Server-VBO/m-p/85603#M36575 This error occurs because Blue Prism has specific data types, and Guid isn't one of these, so to get around the issue the code stage needs to be amended so that if a variable is of Guid type, it is first cast to string and then this will be held as a Blue Prism Text type in the collection. Because this involves modifying a VBO provided by Blue Prism, I'd recommend creating a copy and modifying that instead, but when doing so make sure you use the set connection from this ""copy"" object to ensure the global variables are set. Within the code you will need to use specifier D to maintain the same format that Blue Prism uses (https://msdn.microsoft.com/en-us/library/97af8hh4(v=vs.110).aspx) Tue, 03 May 2016 13:17:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-perform-Get-Collection-action-in-Data-SQL-Server-VBO/m-p/85603#M36575 hassan_chaudhry 2016-05-03T13:17:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-perform-Get-Collection-action-in-Data-SQL-Server-VBO/m-p/85604#M36576 works, thankyou ! Tue, 03 May 2016 15:54:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-perform-Get-Collection-action-in-Data-SQL-Server-VBO/m-p/85604#M36576 sneha_komatinen 2016-05-03T15:54:00Z