StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Installation Error

Installation Error

Paul Chase — Thu, 02 Sep 2010 16:46:11 GMT

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

RE: Installation Error

Ivan George Borges — Thu, 02 Sep 2010 16:46:11 GMT

You're welcome. :cool:

RE: Installation Error

Hugo R. Figueroa — Thu, 02 Sep 2010 15:14:09 GMT

Installed 1.7.3.1 and now installed OK.

Thank You.

RE: Installation Error

Ivan George Borges — Mon, 30 Aug 2010 14:13:22 GMT

It is on its way, Hugo. ;)

RE: Installation Error

Hugo R. Figueroa — Mon, 30 Aug 2010 14:05:49 GMT

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.

RE: Installation Error

Paul Chase — Mon, 30 Aug 2010 11:10:53 GMT

10-4

I assumed that would be the case but you know how that goes.:D

RE: Installation Error

Trent L. Taylor — Mon, 30 Aug 2010 10:43:10 GMT

Yes, or you can detach them and move them over. Either way will work.

RE: Installation Error

Paul Chase — Mon, 30 Aug 2010 10:42:41 GMT

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 ?

RE: Installation Error

Paul Chase — Mon, 30 Aug 2010 10:40:16 GMT

Trent the last version was installed on 10\23\2009. I am not sure of the version # .

RE: Installation Error

Trent L. Taylor — Mon, 30 Aug 2010 10:40:10 GMT

This has been addressed as well and will be in the 1.7.3.1 build posted later today.

RE: Installation Error

Trent L. Taylor — Mon, 30 Aug 2010 10:32:34 GMT

What version were you on before you updated?

RE: Installation Error

Paul Chase — Mon, 30 Aug 2010 10:19:23 GMT

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.

[codesnippet]

'-- 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

[/codesnippet]

RE: Installation Error

Trent L. Taylor — Mon, 30 Aug 2010 10:11:39 GMT

Paul,

We will post a build later today (1.7.3.1) that will resolve the issue of the SQL Server 2005 FILESTREAM test.

[quote]There also seems to be a problem with guid primary keys casting to string. [/quote]

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?

RE: Installation Error

Ivan George Borges — Mon, 30 Aug 2010 10:09:14 GMT

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.

RE: Installation Error

Paul Chase — Sat, 28 Aug 2010 10:31:49 GMT

There also seems to be a problem with guid primary keys casting to string.

Paul

RE: Installation Error

Paul Chase — Sat, 28 Aug 2010 10:30:26 GMT

• 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()

RE: Installation Error

Trent L. Taylor — Fri, 27 Aug 2010 16:11:58 GMT

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.

RE: Installation Error

Ivan George Borges — Fri, 27 Aug 2010 16:05:54 GMT

Hi Paul.

The log file should be at "C:\Program Files (x86)\Common Files\MicroFour\StrataFrame".