SOTI Pulse Logo

error wile updating

O
Orhan
Kumport Liman Hizmetleri ve Lojistik San.ve Tic. AS

Hello,

I have an error while updating to version 14.58 from 14.2. Log details below,

Can you help please?

2024-11-12 13:03:02.345: DACPAC: DAC Message: Error SQL72045: Script execution error.  The executed script:
IF OBJECT_ID('tmpDeviceRights') IS NOT NULL
DROP TABLE tmpDeviceRights
GO
 
CREATE TABLE tmpDeviceRights (Name VARCHAR(200), Value BIGINT)
GO
 
INSERT INTO tmpDeviceRights (Name, Value) VALUES 
('RemoteControl', 0x000001),
('RemoteControlViewFiles', 0x000002),
('RemoteControlUpdateFiles', 0x000004),
('RemoteControlViewRegistry', 0x000008),
('RemoteControlUpdateRegistry', 0x000010),
('RemoteControlViewTasks', 0x000020),
('RemoteControlManageTasks', 0x000040),
('RemoteControlViewSystemInfo', 0x000080),
('RemoteControlCommands', 0x000100),
('RemoteControlScripting', 0x000200),
('RemoteControlInput', 0x000400),
('RemoteControlWithoutNotification', 0x000800),
('LoginSSP', 0x2000000),
('ViewGroup', 0x00100000000),
('ModifyGroup', 0x00200000000),
('ConfigureGroupSecurity', 0x00400000000),
('ConfigureAdvancedSettings', 0x00800000000),
('SendDeviceMessage', 0x02000000000),
('SendDeviceScript', 0x04000000000),
('ManageAndMoveDevices', 0x08000000000),
('UpdateDeviceNotes', 0x10000000000),
('L
2024-11-12 13:03:02.376: DACPAC: DAC Message: Error SQL72014: .Net SqlClient Data Provider: Msg 3013, Level 16, State 1, Line 3542 BACKUP DATABASE is terminating abnormally.
2024-11-12 13:03:02.391: DACPAC: DAC Message: Error SQL72045: Script execution error.  The executed script:
IF OBJECT_ID('tmpDeviceRights') IS NOT NULL
DROP TABLE tmpDeviceRights
GO
 
CREATE TABLE tmpDeviceRights (Name VARCHAR(200), Value BIGINT)
GO
 
INSERT INTO tmpDeviceRights (Name, Value) VALUES 
('RemoteControl', 0x000001),
('RemoteControlViewFiles', 0x000002),
('RemoteControlUpdateFiles', 0x000004),
('RemoteControlViewRegistry', 0x000008),
('RemoteControlUpdateRegistry', 0x000010),
('RemoteControlViewTasks', 0x000020),
('RemoteControlManageTasks', 0x000040),
('RemoteControlViewSystemInfo', 0x000080),
('RemoteControlCommands', 0x000100),
('RemoteControlScripting', 0x000200),
('RemoteControlInput', 0x000400),
('RemoteControlWithoutNotification', 0x000800),
('LoginSSP', 0x2000000),
('ViewGroup', 0x00100000000),
('ModifyGroup', 0x00200000000),
('ConfigureGroupSecurity', 0x00400000000),
('ConfigureAdvancedSettings', 0x00800000000),
('SendDeviceMessage', 0x02000000000),
('SendDeviceScript', 0x04000000000),
('ManageAndMoveDevices', 0x08000000000),
('UpdateDeviceNotes', 0x10000000000),
('L
2024-11-12 13:03:02.423: DACPAC: DAC Message: Message SQL0: An error occurred while the batch was being executed.
2024-11-12 13:03:02.454: DACPAC: Faulted [2]: Updating database
2024-11-12 13:03:02.485: DACPAC: DAC Message: Message SQL73036: Updating database (Failed)
2024-11-12 13:03:02.516: DACPAC: Faulted [2]: Deploying package to database
2024-11-12 13:03:02.657: DACPAC: Faulted [2]: Registering metadata for database
2024-11-12 13:05:02.782: DACPAC: FAILURE: DACPAC has failed to deploy: Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package.
Warning SQL72015: The column [dbo].[ConnectServer].[CertificateId] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[ConnectServer].[LastConnectedTime] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[ConnectServer].[ClientId] on table [dbo].[ConnectServer] must be added, but the column has no default value and does not allow NULL values. If the table contains data, the ALTER script will not work. To avoid this issue you must either: add a default value to the column, mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
Warning SQL72015: The column [dbo].[ConnectServer].[ClientSecret] on table [dbo].[ConnectServer] must be added, but the column has no default value and does not allow NULL values. If the table contains data, the ALTER script will not work. To avoid this issue you must either: add a default value to the column, mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
Warning SQL72015: The column [dbo].[ConnectServer].[DataKeyId] on table [dbo].[ConnectServer] must be added, but the column has no default value and does not allow NULL values. If the table contains data, the ALTER script will not work. To avoid this issue you must either: add a default value to the column, mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
Error SQL72014: .Net SqlClient Data Provider: Msg 3268, Level 16, State 1, Line 3542 Cannot use the backup file 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Backup\MobiControlDB_migration.bak' because it was originally formatted with sector size 4096 and is now on a device with sector size 512.
Error SQL72045: Script execution error.  The executed script:
IF OBJECT_ID('tmpDeviceRights') IS NOT NULL
DROP TABLE tmpDeviceRights
GO
 
CREATE TABLE tmpDeviceRights (Name VARCHAR(200), Value BIGINT)
GO
 
INSERT INTO tmpDeviceRights (Name, Value) VALUES 
('RemoteControl', 0x000001),
('RemoteControlViewFiles', 0x000002),
('RemoteControlUpdateFiles', 0x000004),
('RemoteControlViewRegistry', 0x000008),
('RemoteControlUpdateRegistry', 0x000010),
('RemoteControlViewTasks', 0x000020),
('RemoteControlManageTasks', 0x000040),
('RemoteControlViewSystemInfo', 0x000080),
('RemoteControlCommands', 0x000100),
('RemoteControlScripting', 0x000200),
('RemoteControlInput', 0x000400),
('RemoteControlWithoutNotification', 0x000800),
('LoginSSP', 0x2000000),
('ViewGroup', 0x00100000000),
('ModifyGroup', 0x00200000000),
('ConfigureGroupSecurity', 0x00400000000),
('ConfigureAdvancedSettings', 0x00800000000),
('SendDeviceMessage', 0x02000000000),
('SendDeviceScript', 0x04000000000),
('ManageAndMoveDevices', 0x08000000000),
('UpdateDeviceNotes', 0x10000000000),
('L
Error SQL72014: .Net SqlClient Data Provider: Msg 3013, Level 16, State 1, Line 3542 BACKUP DATABASE is terminating abnormally.
Error SQL72045: Script execution error.  The executed script:
IF OBJECT_ID('tmpDeviceRights') IS NOT NULL
DROP TABLE tmpDeviceRights
GO
 
CREATE TABLE tmpDeviceRights (Name VARCHAR(200), Value BIGINT)
GO
 
INSERT INTO tmpDeviceRights (Name, Value) VALUES 
('RemoteControl', 0x000001),
('RemoteControlViewFiles', 0x000002),
('RemoteControlUpdateFiles', 0x000004),
('RemoteControlViewRegistry', 0x000008),
('RemoteControlUpdateRegistry', 0x000010),
('RemoteControlViewTasks', 0x000020),
('RemoteControlManageTasks', 0x000040),
('RemoteControlViewSystemInfo', 0x000080),
('RemoteControlCommands', 0x000100),
('RemoteControlScripting', 0x000200),
('RemoteControlInput', 0x000400),
('RemoteControlWithoutNotification', 0x000800),
('LoginSSP', 0x2000000),
('ViewGroup', 0x00100000000),
('ModifyGroup', 0x00200000000),
('ConfigureGroupSecurity', 0x00400000000),
('ConfigureAdvancedSettings', 0x00800000000),
('SendDeviceMessage', 0x02000000000),
('SendDeviceScript', 0x04000000000),
('ManageAndMoveDevices', 0x08000000000),
('UpdateDeviceNotes', 0x10000000000),
('L
 
   at Microsoft.SqlServer.Dac.DeployOperation.ThrowIfErrorManagerHasErrors()
   at Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass14.<>c__DisplayClass16.<CreatePlanExecutionOperation>b__13()
   at Microsoft.Data.Tools.Schema.Sql.Dac.OperationLogger.Capture(Action action)
   at Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass14.<CreatePlanExecutionOperation>b__12(Object operation, CancellationToken token)
   at Microsoft.SqlServer.Dac.Operation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   at Microsoft.SqlServer.Dac.ReportMessageOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   at Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   at Microsoft.SqlServer.Dac.OperationExtension.Execute(IOperation operation, DacLoggingContext loggingContext, CancellationToken cancellationToken)
   at Microsoft.SqlServer.Dac.DacServices.InternalDeploy(IPackageSource packageSource, Boolean isDacpac, String targetDatabaseName, DacDeployOptions options, CancellationToken cancellationToken, DacLoggingContext loggingContext, Action`3 reportPlanOperation, Boolean executePlan)
   at Microsoft.SqlServer.Dac.DacServices.Deploy(DacPackage package, String targetDatabaseName, Boolean upgradeExisting, DacDeployOptions options, Nullable`1 cancellationToken)
   at Soti.MobiControl.Tools.DacpacInstaller.Program.Main(String[] args)
2024/11/12 13:05:05.079(0x0000270c): ERROR: DACPAC deployment failed with error -1
 
Thank you.
a year ago
SOTI MobiControl
ANSWERS
MB
Marcus Breitenthaler
a year ago

Hi Orhan, 

recommand to create a Ticket on the Soti Support.

In your message is shows that it had an issue with do the Backup  and an issue with Updating the Database.

Do you see an Error if the File is existing at this Path ?

  • C:\DBInstall.log

Generaly may think about it to migrate with the help of Professional Service to a newer Version like 2024.1.2.?

LC
Leon Callsen
a year ago

Hi Marcus, 

I don't think that Orhan will get support by the "standard" support team. 
Everything prior v15.0 is end of service. 
I am not sure how many devices you manage @Orhan. 
I would suggest you to to a fresh new installation to 2024.1.2

J
JCMOD@SOTI
a year ago

Hi Leon,

We will still support Orhan in this instance. Please feel free to take a look at our Product Lifecycle page. Which has the following information:

"SOTI provides technical support for all versions of our products, including those that are past EOL, so long as there is an active service contract and no product development involvement is required.  Our technical support continues for the life of your contract"

Regards,

Technical Support | SOTI Inc. |1.905.624.9828 | support@soti.net | www.soti.net

J
JCMOD@SOTI
a year ago

Hi Orhan,

Thank you for posting on SOTI Pulse.

As mentioned on our Product Lifecycle page - "SOTI provides technical support for all versions of our products, including those that are past EOL, so long as there is an active service contract and no product development involvement is required.  Our technical support continues for the life of your contract."

I suggest you raise a ticket with us through log a case so we can have a look. I believe your issue matches MCMR-22822. I suggest including that on your ticket to help speed up the resolution.

Thank you.

Regards,

Technical Support | SOTI Inc. |1.905.624.9828 | support@soti.net | www.soti.net

Similar Discussions