Hi, I've got the Problem that I can't install solidcp on a clean environment with Server 2012R2 and SQL Express 2012:
Error:
[30.04.2016 10:03:20] ERROR: Run sql error
System.Exception: Can't run SQL script C:SolidCPEnterprise ServerSetupinstall_db.sql ---> System.Exception: Error executing SQL command: INSERT [dbo].[Packages] ([PackageID], [ParentPackageID], [UserID], [PackageName], [PackageComments], [ServerID], [StatusID], [PlanID], [PurchaseDate], [OverrideQuotas], [BandwidthUpdated], [DefaultTopPackage]) VALUES (1, NULL, 1, N'System', N'', NULL, 1, NULL, CAST(N'2010-07-16 12:53:02.460' AS DateTime), 0, NULL, 0)
---> System.Data.SqlClient.SqlException: Bei der Konvertierung eines nvarchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
Die Anweisung wurde beendet.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei SolidCP.Setup.SqlProcess.Run()
--- Ende der internen Ausnahmestapelüberwachung ---
bei SolidCP.Setup.SqlProcess.Run()
--- Ende der internen Ausnahmestapelüberwachung ---
bei SolidCP.Setup.SqlProcess.Run()
bei SolidCP.Setup.Actions.ExecuteInstallSqlAction.SolidCP.Setup.Actions.IInstallAction.Run(SetupVariables vars)
[30.04.2016 10:03:20] ERROR: Failed to execute 'SolidCP.Setup.Actions.ExecuteInstallSqlAction' type of action.
[30.04.2016 10:03:20] ERROR: Here is the original exception...
System.Exception: Can't run SQL script C:SolidCPEnterprise ServerSetupinstall_db.sql ---> System.Exception: Error executing SQL command: INSERT [dbo].[Packages] ([PackageID], [ParentPackageID], [UserID], [PackageName], [PackageComments], [ServerID], [StatusID], [PlanID], [PurchaseDate], [OverrideQuotas], [BandwidthUpdated], [DefaultTopPackage]) VALUES (1, NULL, 1, N'System', N'', NULL, 1, NULL, CAST(N'2010-07-16 12:53:02.460' AS DateTime), 0, NULL, 0)
---> System.Data.SqlClient.SqlException: Bei der Konvertierung eines nvarchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
Die Anweisung wurde beendet.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei SolidCP.Setup.SqlProcess.Run()
--- Ende der internen Ausnahmestapelüberwachung ---
Output from:
select
date_format
from
sys.dm_exec_sessions
where
session_id = @@spid;
-> DMY
Do you have some hints for me, what I'm doing wrong?
Thank you!
Hello,
It seems to be due to the users localization that the script fails.
a quick work around is to set your SQL user's default language to us_english:
'ALTER LOGIN "DOMAINMyuser$" WITH DEFAULT_LANGUAGE = us_english;
GO'
I will have to work on a permanent solution in the SQL script.
Regards,
Marco
I see that this problem still occurs in the most current version of SoliCP (1.2.1). My suggestion is that this script be embedded in the installation.
Thank you.