Problems with insta...
 
Notifications
Clear all

Problems with installing Solidcp

3 Posts
3 Users
0 Reactions
1,478 Views
Posts: 1
Topic starter
(@mwitzgall)
New Member
Joined: 9 years ago

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!

2 Replies
Posts: 1995
Admin
(@m-tiggelaar)
Noble Member
Joined: 9 years ago

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

Reply
Posts: 15
(@ricardolerma)
Active Member
Joined: 8 years ago

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.

Reply
Share: