StrataFrame Forum

Moved DDT to another box - pkg from 1st box won't deploy

http://forum.strataframe.net/Topic18573.aspx

By Charles R Hankey - 8/19/2008

I realize I probably mucked something up here, but thought I might get a better understanding of DDT metadata by asking this question while on a non-critical issue :



I moved my Strataframe installation from my laptop to my desktop. i detached the strataframe.mdf and reattached on new box.



I took a package created on the 1st box (but never deployed) and brought it over to the 2nd box and imported it into a new profile.



SQL Server on box 2 does't not have a database Netpark



I try to deploy the package and get this



• 8/19/2008 11:05:46 AM-> Deploying meta-data for database 'Netpark'

X 8/19/2008 11:05:46 AM-> Creating database 'Netpark' failed.

X 8/19/2008 11:05:46 AM-> FailedOperationException

X 8/19/2008 11:05:46 AM-> Create failed for Database 'Netpark'.

X 8/19/2008 11:05:46 AM-> SmoException

X 8/19/2008 11:05:46 AM-> The PRIMARY filegroup must have at least one file.

X 8/19/2008 11:05:46 AM->

X 8/19/2008 11:05:46 AM-> Source : Microsoft.SqlServer.Smo

X 8/19/2008 11:05:46 AM->

X 8/19/2008 11:05:46 AM-> Stack Trace:

X 8/19/2008 11:05:46 AM-> at Microsoft.SqlServer.Management.Smo.FileGroup.ScriptDdl(ScriptingOptions so, StringBuilder ddl, Boolean databaseIsView)

X 8/19/2008 11:05:46 AM-> at Microsoft.SqlServer.Management.Smo.Database.GetFileGroupsScript(StringBuilder query, Boolean databaseIsView, StringCollection emptyfgs, ScriptingOptions so)

X 8/19/2008 11:05:46 AM-> at Microsoft.SqlServer.Management.Smo.Database.ScriptCreate(StringCollection createQuery, ScriptingOptions so)

X 8/19/2008 11:05:46 AM-> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ScriptCreateInternal(StringCollection query, ScriptingOptions so)

X 8/19/2008 11:05:46 AM-> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()

X 8/19/2008 11:05:46 AM-> at Microsoft.SqlServer.Management.Smo.Database.Create()

X 8/19/2008 11:05:46 AM-> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.CreateSmoObject(ICreatable ObjectToCreate, String ObjectName, DBEObjectType ObjectType, Boolean verboseLogging)

X 8/19/2008 11:05:46 AM->

• 8/19/2008 11:05:46 AM-> Finished verifying databases on server.

• 8/19/2008 11:05:46 AM-> The meta data conversion to the SQL Server has been completed.





I do see PRIMARY under filegroups in the profile.



Not sure what the DDT is complaining about, but no database is getting deployed



Thoughts?
By Trent L. Taylor - 8/19/2008

Well, it appears (for whatever reason) that the data file underneath the Primary file groups doesn't exist.  You have the primary file group, but there is not a specific data file defined underneath it...does that make sense?

Just select the PRIMARY file group, then add a data file underneath it with the standard $dbname$ and default settings and then try to re-deploy and you should be good to go.

By Charles R Hankey - 8/19/2008

Thanks Trent - that indeed did the trick



For lurkers : I right clicked the PRIMARY file group in the right column (after selecting Filegroups) There was no choice to EDIT but I clicked ADD and it created a $dbname$ entry as Trent said.



After saving the name of my database was substituted.



Package now deploys with not problem.