More useful error messages

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

More useful error messages

Postby Carl M » Mon Apr 06, 2009 2:59 am

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.
Carl M
 
Posts: 1
Joined: Mon Apr 06, 2009 2:48 am

Postby Brian Donahue » Mon Apr 06, 2009 3:12 pm

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 all
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]
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby PSU » Fri Sep 11, 2009 6:15 pm

Hi Carl

Has this software bug been fixed yet?

Thanks
PSU
 
Posts: 1
Joined: Fri Sep 11, 2009 6:12 pm


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests

cron