Installing Sensenet Web Deploy 6.5.2 leds to SQL ERROR, but goes fine under Sensenet 6.5.0.8064

Report bugs in Sense/Net ECM here
julian_sorel
Posts: 4
Joined: Thu Jan 07, 2016 4:12 am

Installing Sensenet Web Deploy 6.5.2 leds to SQL ERROR, but goes fine under Sensenet 6.5.0.8064

Postby julian_sorel » Mon Jan 18, 2016 9:56 pm

I have the following stack:

.NET 4.5.1
IIS 7.5
MSSQL SERVER 2008 EXPRESS SP 4
VISUAL STUDIO 2013 UPDATE 5
WINDOWS 7 SP1
SENSENET WEB DEPLOY VERSION 6.5.2.8421
I tried to install SENSENET importing the package using the deploy option within IIS, but when creating the data base this shows up:

Code: Select all

Microsoft.Web.Deployment.DeploymentDetailedClientServerException: Error durante la ejecución del script de la base de datos. El error ocurrió entre las siguientes líneas del script: "1061" y "1201". El registro detallado podría tener más información acerca del error. El comando comenzaba con lo siguiente:
"IF NOT EXISTS (SELECT * FROM sys.views WHERE objec"
 Sintaxis incorrecta cerca de '!'. http://go.microsoft.com/fwlink/?LinkId=178587  Obtenga más información en: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_SQL_EXECUTION_FAILURE. ---> System.Data.SqlClient.SqlException: Sintaxis incorrecta cerca de '!'.
   en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   en System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   en System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   en System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   en System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   en System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   en Microsoft.Web.Deployment.DBStatementInfo.Execute(DbConnection connection, DbTransaction transaction, DeploymentBaseContext baseContext, Int32 timeout)
   --- Fin del seguimiento de la pila de la excepción interna ---
   en Microsoft.Web.Deployment.DBStatementInfo.Execute(DbConnection connection, DbTransaction transaction, DeploymentBaseContext baseContext, Int32 timeout)
   en Microsoft.Web.Deployment.DBConnectionWrapper.ExecuteSql(DBStatementInfo sqlStatement, DeploymentBaseContext baseContext, Int32 timeout)
   en Microsoft.Web.Deployment.SqlScriptToDBProvider.AddHelper(DeploymentObject source, Boolean whatIf)
   en Microsoft.Web.Deployment.SqlScriptToDBProvider.Add(DeploymentObject source, Boolean whatIf)
   en Microsoft.Web.Deployment.DeploymentObject.AddChild(DeploymentObject source, Int32 position, DeploymentSyncContext syncContext)
   en Microsoft.Web.Deployment.DeploymentSyncContext.HandleAddChild(DeploymentObject destParent, DeploymentObject sourceObject, Int32 position)
   en Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject dest, DeploymentObject source)
   en Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject dest, DeploymentObject source)
   en Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject dest, DeploymentObject source)
   en Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject dest, DeploymentObject source)
   en Microsoft.Web.Deployment.DeploymentSyncContext.ProcessSync(DeploymentObject destinationObject, DeploymentObject sourceObject)
   en Microsoft.Web.Deployment.DeploymentObject.SyncToInternal(DeploymentObject destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable, ContentRootTable contentRootTable, Nullable`1 syncPassId, String syncSessionId)
   en Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentProviderOptions providerOptions, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
   en Microsoft.Web.Deployment.DeploymentObject.SyncTo(String provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
   en Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentWellKnownProvider provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
   en Microsoft.Web.Deployment.UI.InstallProgressWizardPage.OnWorkerDoWork(Object sender, DoWorkEventArgs e)
   en System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   en System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)


After working for two weeks I realized that the problem was the 6.5.2 build. I could deploy the application using the 6.5.0.8064 version

:ugeek: :ugeek: :ugeek: :ugeek:

User avatar
tusmester
Sense/Net Team Member
Sense/Net Team Member
Posts: 305
Joined: Wed Oct 01, 2008 7:16 pm
Location: Budapest, Hungary
Contact:

Re: Installing Sensenet Web Deploy 6.5.2 leds to SQL ERROR, but goes fine under Sensenet 6.5.0.8064

Postby tusmester » Fri Sep 30, 2016 11:00 pm

Sorry about the inconvenience, the problem was in the install SQL script: we used a SQL method there (IIF) which is not available in older versions of SQL Server. You have two options:

  • install SenseNet on a newer SQL server
  • install a newer version of SenseNet: in version 6.5.3+ we replaced that script with one that is compatible with older versions of SQL Server.
Miklos Toth, developer at Sense/Net


Return to “Bugs”

Who is online

Users browsing this forum: No registered users and 1 guest