By Paul Chase - 8/27/2010
I am getting an error installing during the data deployment phase. I have triple checked SQL server instance , username and password etc . Where can i find a log file to get a little more info on why it is throwing up?
Paul
|
By Ivan George Borges - 8/27/2010
Hi Paul.The log file should be at "C:\Program Files (x86)\Common Files\MicroFour\StrataFrame".
|
By Trent L. Taylor - 8/27/2010
I would like to see what the log shows. There is clearly some exception being thrown during the SQL deployment which will be shown in the log file, that will give us the starting point to work through this.
|
By Paul Chase - 8/28/2010
• 8/27/2010 4:13:09 PM -> Deploying meta-data for database 'StrataFrame'
• 8/27/2010 4:13:09 PM -> Ensuring Filegroups exist on database 'StrataFrame'
X 8/27/2010 4:13:09 PM -> An error occurred while deploying the meta-data to the server.UnknownPropertyException
Cannot read property IsFileStream.This property is not available on SQL Server 2005.Source : Microsoft.SqlServer.Smo Stack Trace:
at Microsoft.SqlServer.Management.Smo.SqlPropertyMetadataProvider.PropertyNameToIDLookupWithException(String propertyName, PropertyAccessPurpose pap)
at Microsoft.SqlServer.Management.Smo.PropertyCollection.GetValueWithNullReplacement(String propertyName, Boolean throwOnNullValue, Boolean useDefaultOnMissingValue)
at Microsoft.SqlServer.Management.Smo.PropertyCollection.GetValueWithNullReplacement(String propertyName)
at Microsoft.SqlServer.Management.Smo.FileGroup.get_IsFileStream()
at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.VerifyFileGroup(FileGroup Fg, FileGroupInfo FgInfo, DatabaseInfo DbInfo)
at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureFileGroups(Database FgParent, DatabaseInfo DbInfo)
at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureDatabases()
at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployMetaDataThread()
|
By Paul Chase - 8/28/2010
There also seems to be a problem with guid primary keys casting to string. Paul
|
By Ivan George Borges - 8/30/2010
Hi Paul.We got it, there is a test being run that doesn't support SQL Server 2005. If possible, upgrading into SQL Server 2008 would keep you going. Nevertheless, it is being correct now.
|
By Trent L. Taylor - 8/30/2010
Paul,
We will post a build later today (1.7.3.1) that will resolve the issue of the SQL Server 2005 FILESTREAM test.
There also seems to be a problem with guid primary keys casting to string.
In regards to this, I don't really know what you are talking about. When and where are you referring to this? What is your exception and stack trace?
|
By Paul Chase - 8/30/2010
The problem is in businesslayer.vb in the function GetIndexOfPrimaryKey
The code prior to the change used PrimaryKeyValues(lnCnt).ToString() to get the value of that portion of the key
The changed code uses CStr(PrimaryKeyValues(lnCnt)).Replace("'", "''") to get the portion of the key and address the issue of single quotes. CStr doesn't work on a guid.'-- Add the select value'-- TLT Changed 3/8/2010 to resolve an issue with a string primary key that may contain a single quote.' This was reported viat the forum on post http://forum.strataframe.net/FindPost26310.aspx. The suggested' fix was a good solution and was implemented below.'lcSelect &= Me.PrimaryKeyFields(lnCnt) & "='" & PrimaryKeyValues(lnCnt).ToString() & "'"lcSelect &= Me.PrimaryKeyFields(lnCnt) & "='" & CStr(PrimaryKeyValues(lnCnt)).Replace("'", "''") & "'"'-- END OF CHANGE
|
By Trent L. Taylor - 8/30/2010
What version were you on before you updated?
|
By Trent L. Taylor - 8/30/2010
This has been addressed as well and will be in the 1.7.3.1 build posted later today.
|
By Paul Chase - 8/30/2010
Trent the last version was installed on 10\23\2009. I am not sure of the version # .
|
By Paul Chase - 8/30/2010
Thank's I appreciate it. I have another server with SQL 2008 on it, Should a simple backup and restore work to move SF DB's ?
|
By Trent L. Taylor - 8/30/2010
Yes, or you can detach them and move them over. Either way will work.
|
By Paul Chase - 8/30/2010
10-4I assumed that would be the case but you know how that goes.
|
By Hugo R. Figueroa - 8/30/2010
I had the same issue last week, getting the same error trying to install the new version, and getting an error when trying to uninstall it.I left it thinking that there was an issue with my pc. Thanks it wasn't.  Waiting for the update to reinstall. Thank you.
|
By Ivan George Borges - 8/30/2010
It is on its way, Hugo.
|
By Hugo R. Figueroa - 9/2/2010
Installed 1.7.3.1 and now installed OK.Thank You.
|
By Ivan George Borges - 9/2/2010
You're welcome. 
|