Errors: Object reference not set to an instance of an object

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Errors: Object reference not set to an instance of an object

Postby tkdennis » Sat May 17, 2008 1:03 am

My underlying schema changed (table renames, column renames, columns, removed, columns added) and the Data Generator project I had previously created is throwing errors on 2 tables when I try to generate the data. I've looked at each column in each table that throws an error and I can't tell what is causing it. Any ideas how to fix?

Thanks,
Traci
SDG 1.1

System.NullReferenceException: Object reference not set to an instance of an object. at e.a() at e.b() at t..ctor(ConnectionProperties connectionProperties, SDGTable sdgTable, CountAction countAction) at aw.a(CancellableController , Int32 , Int32 , ConnectionProperties , GenerateAction , SqlConnection , SDGProject , GenerationReport )
tkdennis
 
Posts: 75
Joined: Fri Feb 29, 2008 1:13 am

Postby benhall » Mon May 19, 2008 11:34 am

Hello,

I'm sorry you have encountered an error with the application.

In order for us to be able to reproduce this issue, could you please email me your current database schema and your current project file. We can then look at solving the problem.

Thank you

Ben
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am

Postby dlutz » Wed Jul 23, 2008 8:10 pm

I have seen this in the 1.0 version when making a database change while the app is running, refreshing the schema in the UI and then generating data. The database changes included column name change, column type change and removal of foreign key - all done sequentially during the same session of SQLGEN.
I am using 1.1 now but have not been in a position to need to do any database changes while working with SQLGEN.
Hope this is of some help.
dlutz
 
Posts: 8
Joined: Sat Feb 16, 2008 4:54 am

Postby dlutz » Wed Jul 23, 2008 9:01 pm

Shortly, after posting the previous reply in this thread, I encounterd this problem in SQLGEN 1.1. I changed the connection string in a file that I had been editing (and saving) and clicked Generate Data button.
The resulting report started with:
Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at e.a() at e.b() at t..ctor(ConnectionProperties connectionProperties, SDGTable sdgTable, CountAction countAction) at aw.a(CancellableController , Int32 , Int32 , ConnectionProperties , GenerateAction , SqlConnection , SDGProject , GenerationReport )

Repeated attempts in same session failed. Restarting the app fixed the problem.
dlutz
 
Posts: 8
Joined: Sat Feb 16, 2008 4:54 am


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests