UDT Problem

Posts   
 
    
lsberman
User
Posts: 16
Joined: 22-Feb-2006
# Posted on: 21-Mar-2007 17:07:12   

Hi! I'm trying to use LLBLGen with my SQL Server 2005 database biut I ran into the following UDT-related errors. How can I resolve this issue?

CreateNewProject::Exception caught while instantiating UDT type 'TrueFalse' from assembly 'TrueFalse, WkhConfig.SqlCode, Version=1.0.2622.18932, Culture=neutral, PublicKeyToken=null': Couldn't find type: 'TrueFalse' using type description: 'TrueFalse, WkhConfig.SqlCode, Version=1.0.2622.18932, Culture=neutral, PublicKeyToken=null'. Type skipped. CreateNewProject::Exception caught while instantiating UDT type 'Isbn13' from assembly 'Isbn13, WkhConfig.SqlCode, Version=1.0.2622.18932, Culture=neutral, PublicKeyToken=null': Couldn't find type: 'Isbn13' using type description: 'Isbn13, WkhConfig.SqlCode, Version=1.0.2622.18932, Culture=neutral, PublicKeyToken=null'. Type skipped. CreateNewProject::Exception caught while instantiating UDT type 'TriState' from assembly 'TriState, WkhConfig.SqlCode, Version=1.0.2622.18932, Culture=neutral, PublicKeyToken=null': Couldn't find type: 'TriState' using type description: 'TriState, WkhConfig.SqlCode, Version=1.0.2622.18932, Culture=neutral, PublicKeyToken=null'. Type skipped. CreateNewProject::Table 'Audience' removed from list due to an internal exception in Field population: Table Audience contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Author' removed from list due to an internal exception in Field population: Table Author contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Blob' removed from list due to an internal exception in Field population: Table Blob contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Category' removed from list due to an internal exception in Field population: Table Category contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'CatItem' removed from list due to an internal exception in Field population: Table CatItem contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Journal' removed from list due to an internal exception in Field population: Table Journal contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Media' removed from list due to an internal exception in Field population: Table Media contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Publisher' removed from list due to an internal exception in Field population: Table Publisher contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Section' removed from list due to an internal exception in Field population: Table Section contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Series' removed from list due to an internal exception in Field population: Table Series contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Sku' removed from list due to an internal exception in Field population: Table Sku contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Thumbnail' removed from list due to an internal exception in Field population: Table Thumbnail contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Toc' removed from list due to an internal exception in Field population: Table Toc contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Vendor' removed from list due to an internal exception in Field population: Table Vendor contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Volume' removed from list due to an internal exception in Field population: Table Volume contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'XmlKind' removed from list due to an internal exception in Field population: Table XmlKind contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'XmlSource' removed from list due to an internal exception in Field population: Table XmlSource contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'XsltKind' removed from list due to an internal exception in Field population: Table XsltKind contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Exception caught while instantiating UDT type 'TrueFalse' from assembly 'TrueFalse, WkhConfig.SqlCode, Version=1.0.2622.18932, Culture=neutral, PublicKeyToken=null': Couldn't find type: 'TrueFalse' using type description: 'TrueFalse, WkhConfig.SqlCode, Version=1.0.2622.18932, Culture=neutral, PublicKeyToken=null'. Type skipped. CreateNewProject::Exception caught while instantiating UDT type 'Isbn13' from assembly 'Isbn13, WkhConfig.SqlCode, Version=1.0.2622.18932, Culture=neutral, PublicKeyToken=null': Couldn't find type: 'Isbn13' using type description: 'Isbn13, WkhConfig.SqlCode, Version=1.0.2622.18932, Culture=neutral, PublicKeyToken=null'. Type skipped. CreateNewProject::Exception caught while instantiating UDT type 'TriState' from assembly 'TriState, WkhConfig.SqlCode, Version=1.0.2622.18932, Culture=neutral, PublicKeyToken=null': Couldn't find type: 'TriState' using type description: 'TriState, WkhConfig.SqlCode, Version=1.0.2622.18932, Culture=neutral, PublicKeyToken=null'. Type skipped. CreateNewProject::Table 'Audience' removed from list due to an internal exception in Field population: Table Audience contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Author' removed from list due to an internal exception in Field population: Table Author contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Blob' removed from list due to an internal exception in Field population: Table Blob contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Category' removed from list due to an internal exception in Field population: Table Category contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'CatItem' removed from list due to an internal exception in Field population: Table CatItem contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Journal' removed from list due to an internal exception in Field population: Table Journal contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Media' removed from list due to an internal exception in Field population: Table Media contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Publisher' removed from list due to an internal exception in Field population: Table Publisher contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Section' removed from list due to an internal exception in Field population: Table Section contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Series' removed from list due to an internal exception in Field population: Table Series contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Sku' removed from list due to an internal exception in Field population: Table Sku contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Thumbnail' removed from list due to an internal exception in Field population: Table Thumbnail contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Toc' removed from list due to an internal exception in Field population: Table Toc contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Vendor' removed from list due to an internal exception in Field population: Table Vendor contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'Volume' removed from list due to an internal exception in Field population: Table Volume contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'XmlKind' removed from list due to an internal exception in Field population: Table XmlKind contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'XmlSource' removed from list due to an internal exception in Field population: Table XmlSource contains a user defined datatype which is isn't found in the assembly list. 'TriState' CreateNewProject::Table 'XsltKind' removed from list due to an internal exception in Field population: Table XsltKind contains a user defined datatype which is isn't found in the assembly list. 'TriState'

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 21-Mar-2007 18:01:24   

You have defined some UDTs using CLR types I pressume? To be able to re-construct the UDT type, the driver has to be able to resolve the type. This is only possible if the assembly with the UDT is known on the system on which you run the LLBLGen Pro designer. So place the assembly which contains the UDT into the GAC and retry. The SQLServer driver will then be able to resolve the UDT and the table with a field of that type will be accepted.

Frans Bouma | Lead developer LLBLGen Pro
lsberman
User
Posts: 16
Joined: 22-Feb-2006
# Posted on: 26-Mar-2007 15:12:41   

Thanks! I missed this answer. Please ignore my most recent response to a related UDT question.