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

StrataFrame Forum

Back

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

Author	Message
Charles R Hankey	Charles R Hankey posted 16 Years Ago Topic Details Share Topic
Group: Forum Members Posts: 524, Visits: 30K	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?
	Reply Like 0
Trent Taylor	Trent Taylor posted 16 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 6.9K	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.
	Reply Like 0
Charles R Hankey	Charles R Hankey posted 16 Years Ago Post Details Share Post
Group: Forum Members Posts: 524, Visits: 30K	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.
	Reply Like 0