Red Gate forums :: View topic - Errors: Object reference not set to an instance of an object
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

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

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
tkdennis



Joined: 29 Feb 2008
Posts: 75

PostPosted: Sat May 17, 2008 1:03 am    Post subject: Errors: Object reference not set to an instance of an object Reply with quote

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 )
Back to top
View user's profile Send private message
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Mon May 19, 2008 11:34 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
dlutz



Joined: 16 Feb 2008
Posts: 18

PostPosted: Wed Jul 23, 2008 8:10 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
dlutz



Joined: 16 Feb 2008
Posts: 18

PostPosted: Wed Jul 23, 2008 9:01 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group