Connect to Blue prism data base from process studio
Execute certain query
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.
I fixed my case by removing typeof(object) from red line below and I am able to get the result into BP Collection.
my code e.g. foreach (var field in fields) { //if (!dataTable.Columns.Contains(field.Name) && !field.Name.StartsWith("@odata.etag")) if (!dataTable.Columns.Contains(field.Name)) { dataTable.Columns.Add(field.Name, typeof(object)); // Add column if it doesn't exist } } break;
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).
I fixed my case by removing typeof(object) from red line below and I am able to get the result into BP Collection.
my code e.g. foreach (var field in fields) { //if (!dataTable.Columns.Contains(field.Name) && !field.Name.StartsWith("@odata.etag")) if (!dataTable.Columns.Contains(field.Name)) { dataTable.Columns.Add(field.Name, typeof(object)); // Add column if it doesn't exist } } break;
