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

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

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: 6670
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: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests