How can we help you today? How can we help you today?
bretlowery
Activity overview Badges (0) Posts (2) Comments (8)

Comments

Sort by recent activity
Looks like it's blowing up on some custom generators we've written. This is the log file: 09 Feb 2011 13:05:34,533 [ProgressTask] DEBUG RedGate.SQLDataGenerator.Engine.DataGeneratorController - OnLoadProject file C:\Users\bret.lowery\Documents\ATS_5_18.sqlgen datasource null 09 Feb 2011 13:05:35,694 [ProgressTask] DEBUG am - Could not create the type iCRGDataGenerator.RandomEmail, No valid constructor found 09 Feb 2011 13:05:35,696 [ProgressTask] ERROR aA - Error trying to assign Generator iCRGDataGenerator.RandomEmail to field [dbo].[Ad].[dbo].[Ad].[CreatedBy] 09 Feb 2011 13:05:35,698 [ProgressTask] DEBUG am - Could not create the type iCRGDataGenerator.CreatedAt, No valid constructor found 09 Feb 2011 13:05:35,700 [ProgressTask] ERROR aA - Error trying to assign Generator iCRGDataGenerator.CreatedAt to field [dbo].[Ad].[dbo].[Ad].[CreatedAt] 09 Feb 2011 13:05:35,707 [ProgressTask] DEBUG am - Could not create the type iCRGDataGenerator.DateTimeInLast30Days, No valid constructor found 09 Feb 2011 13:05:35,708 [ProgressTask] ERROR aA - Error trying to assign Generator iCRGDataGenerator.DateTimeInLast30Days to field [dbo].[Address].[dbo].[Address].[CreatedOn] 09 Feb 2011 13:05:35,710 [ProgressTask] DEBUG am - Could not create the type iCRGDataGenerator.RandomEmail, No valid constructor found 09 Feb 2011 13:05:35,711 [ProgressTask] ERROR aA - Error trying to assign Generator iCRGDataGenerator.RandomEmail to field [dbo].[Address].[dbo].[Address].[CreatedBy] 09 Feb 2011 13:05:35,713 [ProgressTask] DEBUG am - Could not create the type iCRGDataGenerator.CreatedAt, No valid constructor found 09 Feb 2011 13:05:35,714 [ProgressTask] ERROR aA - Error trying to assign Generator iCRGDataGenerator.CreatedAt to field [dbo].[Address].[dbo].[Address].[CreatedAt] I'll try to figure this out and get back to you, thanks! / comments
  1. Community
  2. SQL Data Generator Previous Versions
  3. Error "The given key was not present in the dictionary"
Looks like it's blowing up on some custom generators we've written. This is the log file: 09 Feb 2011 13:05:34,533 [ProgressTask] DEBUG RedGate.SQLDataGenerator.Engine.DataGeneratorController - OnL...
0 votes
Belay that; those errors were caused by the cumulative patch install. I had to re-reference and rebuild my custom generator project to match the new RedGate DLLs, which made those errors go away. Now, I still get the original permissions error, with no obvious error in the log file: 09 Feb 2011 13:13:52,718 [1] INFO RedGate.SQLDataGenerator.Engine.Logging.LogService - Starting new SQL Data Generator session 09 Feb 2011 13:14:11,655 [1] INFO an - interclick.ODBC Query (integer results) [Return a single-column integer result from an ODBC query] {Integer32} 09 Feb 2011 13:14:11,662 [1] INFO an - interclick.ODBC Query (double/float results) [Return a single-column double precision/float result from an ODBC query] {Float} 09 Feb 2011 13:14:11,664 [1] INFO an - interclick.ODBC Query (char/varchar/nchar/nvarchar results) [Return a single-column string result from an ODBC query] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:11,666 [1] INFO an - interclick.Dynamic Expression [Evaluates a dynamic expression via IronRuby] {Binary,Varbinary,Char,Varchar,NChar,NVarchar,DateTime,SmallDatetime,Decimal,Numeric,Float,Real,Integer64,Integer32,Integer16,Byte,Money,SmallMoney,Boolean,Timestamp,Guid,Image,NText,Text,Variant,Xml,Other,ClrType,Date,Time,DateTime2,DateTimeOffset} 09 Feb 2011 13:14:11,668 [1] INFO an - interclick.Created At [Fake PC names that match none of ours] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:11,670 [1] INFO an - interclick.Email (Random) [In a.b@interclick.com format] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:11,671 [1] INFO an - interclick.External Email (Random) [In a.b@cdefghijk.com format] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:11,672 [1] INFO an - interclick.Email (Ordered) [In a.b@interclick.com format] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:11,674 [1] INFO an - interclick.DT (In Last 8 Hours) [Sequential datetime in last 8 hours] {DateTime2,Date,DateTime,SmallDatetime} 09 Feb 2011 13:14:11,675 [1] INFO an - interclick.DT (In Last 24 Hours) [Sequential datetime in last 24 hours] {DateTime2,Date,DateTime,SmallDatetime} 09 Feb 2011 13:14:11,677 [1] INFO an - interclick.DT (In Last 7 Days) [Sequential datetime in last 7 days] {DateTime2,Date,DateTime,SmallDatetime} 09 Feb 2011 13:14:11,678 [1] INFO an - interclick.DT (In Last 30 Days) [Sequential datetime in last 30 days] {DateTime2,Date,DateTime,SmallDatetime} 09 Feb 2011 13:14:11,679 [1] INFO an - interclick.StartDate [Sequential DT w/00:00:00 time] {DateTime2,Date,DateTime,SmallDatetime} 09 Feb 2011 13:14:11,681 [1] INFO an - interclick.EndDate [Sequential DT w/00:00:00 time, guaranteed AFTER StartDate, 4% NULLs] {DateTime2,Date,DateTime,SmallDatetime} 09 Feb 2011 13:14:11,682 [1] INFO an - interclick.Always TRUE [Returns 100% TRUE] {Boolean} 09 Feb 2011 13:14:11,684 [1] INFO an - interclick.Always FALSE [Returns 100% FALSE] {Boolean} 09 Feb 2011 13:14:11,685 [1] INFO an - interclick.Always ONE [Returns 100% 1s] {Integer16} 09 Feb 2011 13:14:11,686 [1] INFO an - interclick.Always ZERO [Returns 100% 0s] {Integer32} 09 Feb 2011 13:14:11,688 [1] INFO an - interclick.Always NULL (numeric) [Returns 100% NULLs] {Integer32} 09 Feb 2011 13:14:11,689 [1] INFO an - interclick.Always NULL (string) [Returns 100% NULLs] {Integer32} 09 Feb 2011 13:14:11,690 [1] INFO an - interclick.Always NULL (datetime) [Returns 100% NULLs] {DateTime2,Date,DateTime,SmallDatetime} 09 Feb 2011 13:14:12,707 [1] INFO an - Generic.Text Shuffler [Shuffles word blocks] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:12,812 [1] INFO an - Generic.File List [Generates list from given file] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:12,814 [1] INFO an - Generic.RegexpGenerator [Used for formatted data] {Binary,Varbinary,Char,Varchar,NChar,NVarchar,DateTime,SmallDatetime,Decimal,Numeric,Float,Real,Integer64,Integer32,Integer16,Byte,Money,SmallMoney,Boolean,Timestamp,Guid,Image,NText,Text,Variant,Xml,Other,ClrType,Date,Time,DateTime2,DateTimeOffset} 09 Feb 2011 13:14:12,910 [1] INFO an - SQL Type.binary [Generates BLOBS] {Binary,Varbinary} 09 Feb 2011 13:14:12,911 [1] INFO an - SQL Type.Image [Generates images] {Image} 09 Feb 2011 13:14:12,913 [1] INFO an - SQL Type.geography [Generates geography types] {} 09 Feb 2011 13:14:12,914 [1] INFO an - SQL Type.geometry [Generates geometry types] {} 09 Feb 2011 13:14:12,916 [1] INFO an - SQL Type.hierarchyid [Generates hierarchyid types] {} 09 Feb 2011 13:14:12,918 [1] INFO an - SQL Type.date [Generates date values] {Date} 09 Feb 2011 13:14:12,919 [1] INFO an - SQL Type.datetime2 [Generates datetime2 values] {DateTime2} 09 Feb 2011 13:14:12,920 [1] INFO an - SQL Type.datetime [Generates datetime values] {DateTime} 09 Feb 2011 13:14:12,922 [1] INFO an - SQL Type.datetimeoffset [Generates datetimeoffset values] {DateTimeOffset} 09 Feb 2011 13:14:12,923 [1] INFO an - SQL Type.smalldatetime [Generates smalldatetime values] {SmallDatetime} 09 Feb 2011 13:14:12,924 [1] INFO an - SQL Type.time [Generates time values] {Time} 09 Feb 2011 13:14:12,925 [1] INFO an - Generic.Weighted List [Weighted list of results] {Binary,Varbinary,Char,Varchar,NChar,NVarchar,DateTime,SmallDatetime,Decimal,Numeric,Float,Real,Integer64,Integer32,Integer16,Byte,Money,SmallMoney,Boolean,Timestamp,Guid,Image,NText,Text,Variant,Xml,Other,ClrType,Date,Time,DateTime2,DateTimeOffset} 09 Feb 2011 13:14:12,926 [1] INFO an - Generic.File Import [Contents of files from folder] {Image,Xml,Text,Varchar,Char,NText,NVarchar,NChar,Binary,Variant,Varbinary} 09 Feb 2011 13:14:12,928 [1] INFO an - SQL Type.bit [(TRUE,FALSE)] {Boolean} 09 Feb 2011 13:14:12,929 [1] INFO an - SQL Type.tinyint [Generates tinyint values (8-bit)] {Byte} 09 Feb 2011 13:14:12,930 [1] INFO an - SQL Type.decimal/numeric [Generates decimal and numeric values] {Numeric,Decimal} 09 Feb 2011 13:14:12,932 [1] INFO an - SQL Type.float [Generates floats (double-precision)] {Float} 09 Feb 2011 13:14:12,933 [1] INFO an - SQL Type.int [Generates ints (32-bit)] {Integer32} 09 Feb 2011 13:14:12,934 [1] INFO an - SQL Type.smallint [Generates smallints (16-bit)] {Integer16} 09 Feb 2011 13:14:12,935 [1] INFO an - SQL Type.bigint [Generates bigints (64-bit)] {Integer64} 09 Feb 2011 13:14:12,937 [1] INFO an - SQL Type.money [Generates money values] {Money} 09 Feb 2011 13:14:12,938 [1] INFO an - SQL Type.real [Generates floats (single-precision)] {Real} 09 Feb 2011 13:14:12,939 [1] INFO an - SQL Type.smallmoney [Generates smallmoney values] {SmallMoney} 09 Feb 2011 13:14:12,941 [1] INFO an - Generic.CSV [Reads data from a CSV File] {Binary,Varbinary,Char,Varchar,NChar,NVarchar,DateTime,SmallDatetime,Decimal,Numeric,Float,Real,Integer64,Integer32,Integer16,Byte,Money,SmallMoney,Boolean,Timestamp,Guid,Image,NText,Text,Variant,Xml,Other,ClrType,Date,Time,DateTime2,DateTimeOffset} 09 Feb 2011 13:14:12,942 [1] INFO an - SQL Type.Foreign Key (manual) Generator [Lets you reference a column from another table] {Binary,Varbinary,Char,Varchar,NChar,NVarchar,DateTime,SmallDatetime,Decimal,Numeric,Float,Real,Integer64,Integer32,Integer16,Byte,Money,SmallMoney,Boolean,Timestamp,Guid,Image,NText,Text,Variant,Xml,Other,ClrType,Date,Time,DateTime2,DateTimeOffset} 09 Feb 2011 13:14:12,943 [1] INFO an - SQL Type.sql_variant [Generates Variants] {Variant} 09 Feb 2011 13:14:12,945 [1] INFO an - SQL Type.uniqueidentifier (Seedable) [Generates Repeatable Unique Identifiers] {Guid} 09 Feb 2011 13:14:12,946 [1] INFO an - SQL Type.uniqueidentifier [Generates Unique Identifiers] {Guid} 09 Feb 2011 13:14:12,947 [1] INFO an - SQL Type.string (ASCII) [Generates strings] {Text,Varchar,NVarchar,NChar,NText,Char} 09 Feb 2011 13:14:12,948 [1] INFO an - SQL Type.xml [Generates XML strings] {Xml} 09 Feb 2011 13:14:12,950 [1] INFO an - Generic.SQL Statement [Reads data from SELECT statement] {Binary,Varbinary,Char,Varchar,NChar,NVarchar,DateTime,SmallDatetime,Decimal,Numeric,Float,Real,Integer64,Integer32,Integer16,Byte,Money,SmallMoney,Boolean,Timestamp,Guid,Image,NText,Text,Variant,Xml,Other,ClrType,Date,Time,DateTime2,DateTimeOffset} 09 Feb 2011 13:14:12,951 [1] INFO an - SQL Type.string (Unicode) [Used to generate unicode strings] {NChar,NText,NVarchar} 09 Feb 2011 13:14:13,086 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\5 Digit Ids.xml Business.5 Digit Ids [67815,98234, 71333, 89620, 04231...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,089 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Account Number.xml Business.Account Number [RET36662, BAZ78722, JAT21492, NOR79692, NIX44201] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,102 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Address Line (Street number).xml Geographical.Address Line (Street number) [123 West Second Way, 6 Fabien Boulevard, 567 Hague St., 11 Oak Drive... ] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,112 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Address Line 1.xml Geographical.Address Line 1 [Suite 208,7th Floor,APT 68, Flanklin Building,Sales Group...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,113 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Building Unit.xml Geographical.Building Unit [Apartment,Basement,Floor,Lower,Penthouse...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,115 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\businessSectors.xml Business.Sector [Aerospace (Civil),Agriculture, Horticulture & Fisheries,Airports,Automotive...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,116 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Category.xml Business.Categories [Cereals, Grain, Confections, Produce...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,118 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Color.xml Personal.Color [AliceBlue, AntiqueWhite, Aqua, Aquamarine...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,120 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Company Name.xml Business.Company Name [Cipobin Direct Inc, Varadupin Direct, Cipzaponar Corporation...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,122 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Contact Title.xml Personal.Contact Title [Sales Manager, Owner, Marketting Associate...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,124 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Country.xml Geographical.Country [Aruba, Afghanistan, Angola...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,126 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\CountryCode.xml Geographical.Country Code [ABW, AFG, AGO, AIA, ALA, ALB, AND...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,135 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\CountryCode2.xml Geographical.Country Code(short) [AD, AE, AF, AG, AI, AL...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,141 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Credit Card Date.xml Payment.Credit Card Date [mm/yy: 03/04, 10/14, 02/18, 11/05...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,144 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Credit Card Issue Number.xml Payment.Credit Card Issue Number [3, 1, 5, 7, 6...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,147 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Credit Card Number.xml Payment.Credit Card Number [Credit Card Numbers with valid checksum] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,149 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Credit Card Type.xml Payment.Credit Card Type [AmEx, Mastercard, VISA] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,152 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Currency Names.xml Payment.Currency Name [Euro, Pound Sterling, US dollar...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,154 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Currency.xml Payment.Currency Code [USD, AED, AFN, ALL, ANG, EUR, AOA...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,156 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Department.xml Business.Department [Corporate Sales, Service, Prepaid Customer, Corporate Care... ] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,158 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Email (Internet Safe).xml Personal.Email (Internet Safe) [a1@example.com, qtaj@example.com, zxzdx@example.com...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,160 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Email.xml Personal.Email [Email Addresses (generated)] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,162 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Extensions.xml Personal.Extensions [3,123,1034,21,768...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,164 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\File Extension.xml Business.File Extensions [bmp,jpg,gif,doc,xls...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,166 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Filename.xml Business.Filename [rjqggri.bmp, uuebzfywhi.xls, knoyqknjob.txt...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,175 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Folder (Dos).xml Business.Folder (Dos) [U:\Program Files\Sales\Temp\Product\qqqc.doc, C:\Windows\Red Gate\Builds\Sales\gunit.txt] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,177 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Folder (Web).xml Business.Folder (Web) [http://pen.net17/olbs.pdf, [/email]http://xbj.net13/sqcas/htjtl/snr.bmp...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,179 [1] INFO ag - File C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Ids.xml. Ignoring serialization of 'UIGeneratorStyle'. 09 Feb 2011 13:14:13,181 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Ids.xml Business.IDs [1,2,3,4,5,6....] {Integer32} 09 Feb 2011 13:14:13,182 [1] INFO ag - File C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Ids.xml. Ignoring serialization of 'UIGeneratorStyle'. 09 Feb 2011 13:14:13,184 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Ids.xml Business.IDs [1,2,3,4,5,6....] {Integer64} 09 Feb 2011 13:14:13,185 [1] INFO ag - File C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Ids.xml. Ignoring serialization of 'UIGeneratorStyle'. 09 Feb 2011 13:14:13,187 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Ids.xml Business.IDs [1,2,3,4,5,6....] {Integer16} 09 Feb 2011 13:14:13,188 [1] INFO ag - File C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Ids.xml. Ignoring serialization of 'UIGeneratorStyle'. 09 Feb 2011 13:14:13,190 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Ids.xml Business.IDs [1,2,3,4,5,6....] {Byte} 09 Feb 2011 13:14:13,195 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Initials.xml Personal.Initials [HR, TP, P, Y, Q, RD...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,198 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\NameFull.xml Personal.Full Names [Emma Smith, John Brown, Andrew Clarke, Tom O'Hare, Claire Harris...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,202 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\NamesFirst.xml Personal.First Name [Emma, Lionel, Charlotte, David, Tanya, Marine...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,205 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\NamesFirstFemale.xml Personal.First Name (Female) [Jennifer, Amy, Heather, Melissa, Angela...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,207 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\NamesFirstMale.xml Personal.First Name (Male) [Michael, Jason, Christopher, James...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,211 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\NamesLast.xml Personal.Last Name [Smith, Brown, Clarke, O'Hare, Harris...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,214 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\NamesNick.xml Personal.Nick Name [Mike124, Chris1, Tom78, Jenny39, Amy12, Mel54...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,216 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\NameSuffix.xml Personal.Name (Suffix) [Sr., jr, Ph.D.,BA...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,218 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\P.O. Box.xml Geographical.P.O. Box [P.O. Box 139, PO Box 12, P.O. Box 7039...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,223 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Phone Number (Short).xml Personal.Phone Number (Short) [476-391-0239, 114-479-4304, 829-310-4824...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,233 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Phone Number.xml Personal.Phone Number [(476) 391-0239, 114-479-4304, (829) 310-4824...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,236 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Product Name.xml Shopping.Product Name [Product Names] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,238 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Region.xml Geographical.Region [IK-MU, NC-JY, TX-NN, AL-BA, MA-YD...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,240 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Social Security Number.xml Personal.Social Security Number [950-95-8060, 626-39-6597, 763-98-0639...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,242 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Source of leads.xml Business.Source of leads [Sales, Word of mouth...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,245 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\State.xml Geographical.US State [Alabama, Alaska, Arizona, Arkansas, California, Colorado...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,247 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\StateCode.xml Geographical.US State Code [AL, AK, AZ, AR, CA, CO, CT...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,250 [1] INFO ag - File C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\TextLatin.xml. Ignoring serialization of 'UIGeneratorStyle'. 09 Feb 2011 13:14:13,251 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\TextLatin.xml Shopping.Description [Id eudis quo] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,253 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Title.xml Personal.Title [Mr, Dr., Ms, Miss.] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,258 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\URL (Web).xml Business.URL (Web) [http://pen.net17/olbs.html, http://xbj.net13/sqcas/htjtl/snr.aspx...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,260 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\USCity.xml Geographical.US City [New York, Los Angeles, Chicago...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,262 [1] INFO ag - File C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\WorkingAge.xml. Ignoring serialization of 'UIGeneratorStyle'. 09 Feb 2011 13:14:13,264 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\WorkingAge.xml Personal.Working Age [29,30,35,18...] {Integer64,Integer32,Integer16,Byte} 09 Feb 2011 13:14:13,266 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\ZIP Code.xml Geographical.ZIP Code [83243, 55727, 75802, 03614...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,269 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\ZIP Plus 4.xml Geographical.ZIP Plus 4 [14764-9160, 37173-8576, 90946-1203...] {Char,Varchar,NChar,NVarchar,Text,NText} 09 Feb 2011 13:14:13,273 [1] INFO ag - C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config\Images\ImagesByFile.xml Personal.Images of people [peoples faces...] {Image} / comments
  1. Community
  2. SQL Data Generator Previous Versions
  3. Error "The given key was not present in the dictionary"
Belay that; those errors were caused by the cumulative patch install. I had to re-reference and rebuild my custom generator project to match the new RedGate DLLs, which made those errors go away. N...
0 votes
I'm not running 2008 R2 (it's 2008 SP2), but I'll try it. / comments
  1. Community
  2. SQL Data Generator Previous Versions
  3. Error "The given key was not present in the dictionary"
I'm not running 2008 R2 (it's 2008 SP2), but I'll try it.
0 votes
The cumulative patch did not correct the issue. / comments
  1. Community
  2. SQL Data Generator Previous Versions
  3. Error "The given key was not present in the dictionary"
The cumulative patch did not correct the issue.
0 votes
Got it, thx. Pls close. / comments
  1. Community
  2. SQL Data Generator Previous Versions
  3. Custom Generator string return val limitations?
Got it, thx. Pls close.
0 votes
Stumped no longer; I figured it out. DataGenerator will not allow me to create a custom string generator on a varchar or nvarchar column if there is a unique index on the column. Once I removed the unique index, the custom generator appeared in the drop-down. For my purposes, my custom generator will generate unique values as it's enumerated. Is there a way that this restraint can be removed? Thanks for the support! / comments
  1. Community
  2. SQL Data Generator Previous Versions
  3. Custom Generator string return val limitations?
Stumped no longer; I figured it out. DataGenerator will not allow me to create a custom string generator on a varchar or nvarchar column if there is a unique index on the column. Once I removed the...
0 votes
Tried it, and it did not fix the problem. I've also tried reinstalling Data Generator, renaming the problematic table, the column in the table, and dropping then recreating my database; nothing worked. I've also checked my rights to the Data Generator folder and subfolders and I have full R/W access. Again, on some columns in other tables with or without the same datatype and length, it worked both with and without the xml file. I also modified my .sqlgen file by hand, copying the custom generator from a different table and column where it worked correctly, and pasting the generator block in the problematic column's generator tag. I was able to save and load the project successfully, but it still had the same problem, and after I saved the project again it overwrote my sqlgen file change. I'm stumped. / comments
  1. Community
  2. SQL Data Generator Previous Versions
  3. Custom Generator string return val limitations?
Tried it, and it did not fix the problem. I've also tried reinstalling Data Generator, renaming the problematic table, the column in the table, and dropping then recreating my database; nothing wor...
0 votes
I can send config file. Can you tell me which one you need? Interestingly, the problem doesn't appear to be related to the data type, data length, nullability, or ordinal position of the column in the tables. I see my custom generator on most tables in my database, but not all. Weird. I tried specifying a new "category" of generators by changing this: [Generator(typeof(String), "Generic", "Company Emails", "In [url=a.b@nowhere.com]a.b@nowhere.com[/url] format")] to: [Generator(typeof(String), "Interclick", "Company Emails", "In [url=a.b@nowhere.com]a.b@nowhere.com[/url] format")] which gave me the same symptoms on the same tables. I also reinstalled Data Generator, and created a brand new project on the same database, and have the same problem on the same tables. Really weird. I can send the entire generator .cs file to you if you'd like. / comments
  1. Community
  2. SQL Data Generator Previous Versions
  3. Custom Generator string return val limitations?
I can send config file. Can you tell me which one you need? Interestingly, the problem doesn't appear to be related to the data type, data length, nullability, or ordinal position of the column in ...
0 votes
Total activity
12
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2