Error installing So...
 
Notifications
Clear all

Error installing SolidCP 1.4

2 Posts
2 Users
0 Reactions
953 Views
Posts: 1
Topic starter
(@fcasco)
New Member
Joined: 6 years ago

[11/09/2018 9:49:55] 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], [StatusIDchangeDate]) VALUES (1, NULL, 1, N'System', N'', NULL, 1, NULL, NULL, 0, NULL, 0, CAST(N'2018-05-20 23:40:47.813' AS DateTime))
---> System.Data.SqlClient.SqlException: La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo.
Se terminó la instrucción.
en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
en System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
en System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
en System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
en System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
en SolidCP.Setup.SqlProcess.Run()
--- Fin del seguimiento de la pila de la excepción interna ---
en SolidCP.Setup.SqlProcess.Run()
--- Fin del seguimiento de la pila de la excepción interna ---
en SolidCP.Setup.SqlProcess.Run()
en SolidCP.Setup.Actions.ExecuteInstallSqlAction.SolidCP.Setup.Actions.IInstallAction.Run(SetupVariables vars)
[11/09/2018 9:49:55] ERROR: Failed to execute 'SolidCP.Setup.Actions.ExecuteInstallSqlAction' type of action.
[11/09/2018 9:49:55] 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], [StatusIDchangeDate]) VALUES (1, NULL, 1, N'System', N'', NULL, 1, NULL, NULL, 0, NULL, 0, CAST(N'2018-05-20 23:40:47.813' AS DateTime))
---> System.Data.SqlClient.SqlException: La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo.
Se terminó la instrucción.
en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
en System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
en System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
en System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
en System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
en SolidCP.Setup.SqlProcess.Run()
--- Fin del seguimiento de la pila de la excepción interna ---
en SolidCP.Setup.SqlProcess.Run()
--- Fin del seguimiento de la pila de la excepción interna ---
en SolidCP.Setup.SqlProcess.Run()
en SolidCP.Setup.Actions.ExecuteInstallSqlAction.SolidCP.Setup.Actions.IInstallAction.Run(SetupVariables vars)
en SolidCP.Setup.Actions.BaseActionManager.Start()
[11/09/2018 9:49:59] INFO: RollBackPage loaded.

This is a brand new install

1 Reply
Posts: 1967
Admin
(@m-tiggelaar)
Noble Member
Joined: 9 years ago

Hello,
The error indicates a time/language setting issue.
You will need to set the SQL user to use english:
‘ALTER LOGIN “DOMAINMyuser$” WITH DEFAULT_LANGUAGE = us_english;
GO’
Regards,
Marco

Reply
Share: