Error retrieving Entities: One or more errors occurred with Azure database

Error retrieving Entities: One or more errors occurred with Azure database

  

I am evaluating Outsystems, so created an AdventureWorks database in Azure.

I created a database connection to it, and allowed Outsystems access via Azure database firewall settings.

When I attempt to generate entities in Integration Studio, I get an error "Error retrieving Entities: One or more errors occurred.".

Is there a way of finding out more detail of the error?

Stuart Harris wrote:

I am evaluating Outsystems, so created an AdventureWorks database in Azure.

I created a database connection to it, and allowed Outsystems access via Azure database firewall settings.

When I attempt to generate entities in Integration Studio, I get an error "Error retrieving Entities: One or more errors occurred.".

Is there a way of finding out more detail of the error?

It turns out Outsystems failed to generate entities when a column used a user defined data type.

However, when I added a table with an ID (tried int and uniqueidentifier) and columns with all the SQL datatypes it worked fine.

Hi Stuart

Unfortunately OutSystems currently doesn't support user defined types, only SQL Server default types.