I am trying to get an old v2.6 project working in v5

I've converted the project file successfully and changed the ResetFieldOrderBasedOnTargetOrderAtRelationalModelDataSync property of the project to true.

When I go to sync the relational model, I get the following error in the Actions taken for catalog section:

• Error: 'Exception caught during retrieval of User defined types: Failed to create AppDomain "master.sys[runtime].3".

• Could not load file or assembly 'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Not enough storage is available to process this command. (Exception from HRESULT: 0x80070008)'

It does show the database changes further down.

I don't know why it's saying there's not enough storage space - there is plenty of space on the drive LLBL Gen Pro is installed on, the network drive where the .llblgenproj file is and on the database server itself.

Is this something I can ignore? What is it trying to do?

Thanks

James

Never saw that error... What's the sqlserver version you're using? Did you select only a single catalog in the element selection wizard (which allows you to pick which tables etc. to refresh) ?

Googling the error gives a problem with memory on sqlserver: https://ask.sqlservercentral.com/questions/115014/failed-to-create-appdomain-selecting-view-that-ref.html

https://social.technet.microsoft.com/Forums/azure/en-US/7ae421ae-6fe1-4ab8-a2b5-174c0e8d8a2b/not-enough-storage-is-available-to-process-this-command-exception-from-hresult-0x80070008?forum=sqlnetfx

The UDT retrieval code wasn't part of v2.6, and wants to obtain the CLR types defined in the catalog.

The database is SQL Server 2014

It was retrieving tables, views and stored procedures from two schemas under the same database.

The server has 8 GB of RAM and Task Manager says it's running at 65% - I'll look through those links with my manager, who is responsible for the server and see if I can see anything useful.

JMitchell wrote:

The database is SQL Server 2014

It was retrieving tables, views and stored procedures from two schemas under the same database.

The server has 8 GB of RAM and Task Manager says it's running at 65% - I'll look through those links with my manager, who is responsible for the server and see if I can see anything useful.

In any case: for your LLBLGen Pro model you can safely ignore the error if you don't use CLR based UDTs in your schema