Red Gate forums :: View topic - Error: 'fillfactor' is not a recognized CREATE TYPE option.
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

Error: 'fillfactor' is not a recognized CREATE TYPE option.

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



Joined: 15 Oct 2010
Posts: 37

PostPosted: Fri Mar 15, 2013 10:11 pm    Post subject: Error: 'fillfactor' is not a recognized CREATE TYPE option. Reply with quote

SQL Packager 6.4.0.8, SQL 2008 R2

I have 2 User-Defined Table Types in my database. When SQL Packager builds a script, it includes this statement for the Primary Key in the script:
Code:
WITH (FILLFACTOR=90)

But that is not a valid option. Thus, when I run the package against a SQL server I get this error:
Quote:
'fillfactor' is not a recognized CREATE TYPE option.

So I have to manually edit the script first, then use SQL Packager to build the exe. I don't want to set SQL Packager to ignore Fillfactor because I don't want Fillfactor ignored on my table indexes.
Is this a bug with SQL Packager or have I done something wrong?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Tue Mar 19, 2013 12:06 pm    Post subject: Reply with quote

Hi Adam,

I'm sorry SQL Packager is giving you problems. Can you please try updating to the latest patch, and see if that helps?

ftp://support.red-gate.com/patches/SQL_Packager/SQL_Packager_6.6.0.347.zip
Back to top
View user's profile Send private message
AdamY



Joined: 15 Oct 2010
Posts: 37

PostPosted: Tue Mar 19, 2013 5:46 pm    Post subject: v6.6.0.347 did not resolve the problem Reply with quote

Thank you for the help. I installed v6.6.0.347 and the Fillfactor problem for User-Definied Table Types still occurs.

If it helps at all - this also used to be a problem in SQL Source Control, but it was fixed. I don't remember when or in what version it was fixed.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Thu Mar 21, 2013 1:34 pm    Post subject: Reply with quote

Here is the definition for the type that I successfully packaged... maybe yours differs somehow. But generally this should work in Packager.
Code:
CREATE TYPE LocationTableType AS TABLE
( LocationName VARCHAR(50),
ID int PRIMARY KEY,
CostRate INT );
GO
Back to top
View user's profile Send private message
AdamY



Joined: 15 Oct 2010
Posts: 37

PostPosted: Thu Mar 21, 2013 5:36 pm    Post subject: Follow-up Reply with quote

When I run SQL Packager to generate a script or package, it generates code that has WITH (FILLFACTOR=90) included. I have to manually remove the WITH (FILLFACTOR=90) code first and then package that script.

Here is definition of one of the types I'm having the problem with:
Code:
CREATE TYPE [LockNeedList] AS TABLE
(
[NeedKey] [varchar](9) NOT NULL,
[NeedType] [varchar](6) NOT NULL,
PRIMARY KEY CLUSTERED ([NeedKey] ASC)
)

Again, the code generated by SQL Packager has WITH (FILLFACTOR=90) added on.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Fri Mar 22, 2013 3:02 pm    Post subject: Reply with quote

Sorry to say again, I can't reproduce the same behavior. Either with ignore fillfactor on or off.
Back to top
View user's profile Send private message
AdamY



Joined: 15 Oct 2010
Posts: 37

PostPosted: Fri Mar 22, 2013 7:10 pm    Post subject: So that's it? Reply with quote

SQL Source Control used to have this same issue and does not now - so it seems it was a bug they found and corrected.

Should I send a DB backup or is that a waste of time? I won't take the time to put one together if Red Gate isn't going to look at it.

Just so you know I'm not crazy:


Last edited by AdamY on Wed Feb 26, 2014 5:37 am; edited 1 time in total
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 889
Location: Red Gate Software

PostPosted: Mon Mar 25, 2013 4:31 pm    Post subject: Reply with quote

Hi AdamY

Sorry that you have encountered a problem.

I can confirm that this is a bug, I was able to reproduce the error using both V6.4.0.8 and V6.6.0.347.

The bug reference number is SPA-601, sadly I cannot provide an ETA as to when this bug will be eventually fixed. I will be maintaining a "watch" on the bug report I submitted so I can be alerted on any changes to the Bug Report and provide an update.

The workaround I can advise is to continue editing the script to remove the WITH (FILLFACTOR=90) before building the exe file.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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