Deployed App - SMO Error


Author
Message
William Fields
William Fields
StrataFrame User (328 reputation)StrataFrame User (328 reputation)StrataFrame User (328 reputation)StrataFrame User (328 reputation)StrataFrame User (328 reputation)StrataFrame User (328 reputation)StrataFrame User (328 reputation)StrataFrame User (328 reputation)StrataFrame User (328 reputation)
Group: StrataFrame Users
Posts: 80, Visits: 239
Hello,

From a non-development machine, I'm running a customized/compiled version of the SF Database Installer sample app and am getting the following error when the DDT metadata is deployed:

The SQLSMOMergeModulel.msm was installed on the workstation along with the SF DLL's.

Any ideas?

• 12/03/2014 2:10:53 PM -> Deploying meta-data for database 'DDTdeploymentTest'
X 12/03/2014 2:10:53 PM -> An error occurred while deploying the meta-data to the server.
X 12/03/2014 2:10:53 PM -> IndexOutOfRangeException       
X 12/03/2014 2:10:53 PM ->   Index was outside the bounds of the array.       
X 12/03/2014 2:10:53 PM ->        
X 12/03/2014 2:10:53 PM -> Source     : Microsoft.SqlServer.Smo       
X 12/03/2014 2:10:53 PM ->        
X 12/03/2014 2:10:53 PM -> Stack Trace:        
X 12/03/2014 2:10:53 PM ->        
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SqlPropertyMetadataProvider.PropertyNameToIDLookupWithException(String propertyName, PropertyAccessPurpose pap)       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.PropertyCollection.GetProperty(String name)       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetDbComparer(Boolean inServer)       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.InitializeStringComparer()       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.get_StringComparer()       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SimpleObjectCollectionBase.InitInnerCollection()       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.GetObjectByKey(ObjectKeyBase key)       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.Contains(ObjectKeyBase key)       
X 12/03/2014 2:10:53 PM ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.FindDatabase(Int32 DatabasePK)       
X 12/03/2014 2:10:53 PM ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureDatabases()       
X 12/03/2014 2:10:53 PM ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployMetaDataThread()       
X 12/03/2014 2:10:53 PM ->  
Reply
StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
William,

I'm glad you found a workaround.  I thought that installing just the management tools and associated connectors would fix it, but I had never confirmed that.  We've always installed full SQL Server 2012 (Standard or Development depending on the machine), so I had never tried it with only installing the management tools.

Edhy,

Thanks for that post.  I remember us running into that problem when trying to get over the x64 stuff, but I didn't remember whether it worked with SQL Server 2012.  I do have a folder on my computer that has the 2008 R2 SMO objects saved off that I have to copy back to the GAC on a computer after installing SQL Server 2012 in order to be able to build the DBEngine from source.  

We used SMO hoping it would simplify things, but every time SQL Server has a new version we run into deployment/compilation problems.  I'm guessing we're going to have the same issues with SQL Server 2014 when it becomes more widespread.

Hrm... Maybe that's why we've avoided SMO for V2...
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
William Fields - 11 Years Ago
William Fields - 11 Years Ago
William Fields - 11 Years Ago
William Fields - 11 Years Ago
Trent L. Taylor - 11 Years Ago
StrataFrame Team - 11 Years Ago
                         Hi All, Ben, now that you mentioned this, I remember, yes there is a...
Edhy Rijo - 11 Years Ago
                         Thanks Ben. I can confirm that after installing the SQL Server 2012...
William Fields - 11 Years Ago
                             William, I'm glad you found a workaround. I thought that installing...
StrataFrame Team - 11 Years Ago
                             Hi William, [quote][b]William Fields (12/4/2014)[/b][hr]I can confirm...
Edhy Rijo - 11 Years Ago
                                 Thanks for the information Edhy! I did run into problems installing...
William Fields - 11 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search