Error "The given key was not present in the dictionary"

The simplest way to populate your database with test data.

Error "The given key was not present in the dictionary"

Postby bretlowery » Tue Feb 08, 2011 4:38 pm

Using Data Generator V1.2.0.286.

At project open, I'm getting an error when loading project, reading permissions: "The given key was not present in the dictionary". This was working fine on Friday, and nobody else opened or used the project over the weekend. It's a fatal error and I can't open my project at all.
bretlowery
 
Posts: 10
Joined: Sat Oct 09, 2010 2:43 pm

Postby Brian Donahue » Wed Feb 09, 2011 10:36 am

It may be you have the case-sensitive issue described in the release notes for the cumulative patch to Data Generator. Getting the cumulative patch may help.
Brian Donahue
 
Posts: 6590
Joined: Mon Aug 23, 2004 10:48 am

Postby bretlowery » Wed Feb 09, 2011 1:49 pm

I'm not running 2008 R2 (it's 2008 SP2), but I'll try it.
bretlowery
 
Posts: 10
Joined: Sat Oct 09, 2010 2:43 pm

Postby bretlowery » Wed Feb 09, 2011 1:54 pm

The cumulative patch did not correct the issue.
bretlowery
 
Posts: 10
Joined: Sat Oct 09, 2010 2:43 pm

Postby bretlowery » Wed Feb 09, 2011 2:06 pm

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!
bretlowery
 
Posts: 10
Joined: Sat Oct 09, 2010 2:43 pm

Postby bretlowery » Wed Feb 09, 2011 2:16 pm

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, 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}
bretlowery
 
Posts: 10
Joined: Sat Oct 09, 2010 2:43 pm

Postby Brian Donahue » Wed Feb 09, 2011 2:19 pm

Yes, the log files aren't very thorough. I will contact you directly via email with the debugging instructions.
Brian Donahue
 
Posts: 6590
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest