Red Gate forums :: View topic - More useful error messages
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

More useful error messages

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Carl M



Joined: 06 Apr 2009
Posts: 1

PostPosted: Mon Apr 06, 2009 2:59 am    Post subject: More useful error messages Reply with quote

Hi,

When I am trying to pacakge a db it gets to Generating SQL script, then falls over saying "Value cannot be null. Parameter name format".

According to Profiler, the last thing Pacakger was doing was selecting from a table. The table has no data in it, and no referencet to "format" anywhere, so the error means absoultely nothing to me. If we could get some meaningful messages that would be great.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6581

PostPosted: Mon Apr 06, 2009 3:12 pm    Post subject: Reply with quote

Hi Carl,

SQL Packager tries to catch as many known exception types as it can and tries to construct helpful error messages. Unfortunately, what you are seeing is a software bug, probably caused when trying to create a data script for a table that has a large object and no primary key. SQL Packager should support this, at least when creating a new database package or adding a new table to an existing database.

The only workaround I know of at this time would be to choose one or more columns that can be used to uniquely identify rows of data and create a primary key or unique index or constraint on those column(s).

This query should help you identify the tables that need modification:
Code:
SELECT O.[NAME] as [Table name], C.[NAME] as [Column Name]
FROM SYSOBJECTS O
JOIN SYSCOLUMNS C
 ON C.ID = O.ID
WHERE O.XTYPE = 'U'
 AND C.XTYPE in (34,35,99) /*IMAGE,TEXT,NTEXT*/
 and O.name !='dtproperties'
ORDER BY O.[NAME], C.[NAME]
Back to top
View user's profile Send private message
PSU



Joined: 11 Sep 2009
Posts: 1

PostPosted: Fri Sep 11, 2009 6:15 pm    Post subject: Reply with quote

Hi Carl

Has this software bug been fixed yet?

Thanks
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