Unexpected error can't convert system.object to a blue prism data type

[GiriGurijala]

I intended to do the following

1. Connect to Blue prism data base from process studio
2. Execute certain query
3. Retrieve the output as collection able to connect successfully to database but facing below error at 'get collection ' stage-- Internal: Unexpected error can't convert system.object to a blue prism data type.

------------------------------
Giri Gurijala
------------------------------

[Michael_S]

[Mod Note: Moved to Blue Prism RPA forum]

------------------------------
💙 Michael
(I'm part of the SS&C Blue Prism Community Team)
------------------------------

[LeonardoSQueiroz]

Hello,

You will probably need to handle the output data type, see this article: https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=145&MID=4443&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab =digestviewer

The solution is very similar.

Regards,

------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------

[andber]

I'm getting "Page not found"

[John__Carter]

It's likely that there are data types from the DB that do not naturally match the BP datatypes, and some sort of manipulation is required. GUID is a typical example, it's everywhere in the DB and needs to be converted to make it output-able as the Text BP data type, e.g. CONVERT(NVARCHAR(36), ProcessID).