Upgrading from latest 12.4 to latest 13.4

Upgrading from latest 12.4 to latest 13.4

Hi I Am trying to upgrade from 12.4.0.31047 to 13.4.0.5156 and keep getting the same error. 

 

SQL 2008R2, Windows Server 2008 R2 on the database server.

Windows Server 2008 R2 and Dot NEt 4.5.2 on Deployment Mobi Server

 

2018-12-03 15:10:15.201: DACPAC: DAC Message: Message SQL0: Processed 7 pages for database 'MobiControlDB_migration', file 'MobiControlDB_migration_log' on file 1.
2018-12-03 15:10:15.658: DACPAC: DAC Message: Message SQL0: BACKUP DATABASE successfully processed 240567 pages in 275.851 seconds (6.813 MB/sec).
2018-12-03 15:10:17.615: DACPAC: DAC Message: Error SQL72014: .Net SqlClient Data Provider: Msg 3930, Level 16, State 1, Procedure sp_rename, Line 140 The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
2018-12-03 15:10:17.891: DACPAC: DAC Message: Error SQL72045: Script execution error. The executed script:

 

Soti support said this was the database server maxing out of memory but we have doubled the memory and this still happens with 12 GB spare.

Anybody any ideas before I ring Soti back?

  • 03 December 2018
  • SOTI MobiControl
  • 6 Answers
  • 0 Upvote
  • 1 Follower
  • 179 Views
    • 6 Answers
    • 0 Upvote
    • 1 Follower

6 Answers

Order By:   Standard | Newest | Votes
SMod@Soti | posted this 14 December 2018

 Hi Ben,

 

I can see you already have opened a case with Technical Support on this issue and the investigation is in progress.

Can you please verify that you are using a 'sa' account or an account with similar permissions to access the SQL Server via the MobiControl installer?

 

Please let me know if you have any questions.

Thanks

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

 

  • 0
  • 0
Ben Anderson | posted this 14 December 2018

Yes I have the sa account. I have been onto a number of people from Soti technical support but still in the same place. I have been advised to create a new VM with the same OS and SQL version and restore a back of the database so I am just waiting for Soti to come back to me to do the upgrade now.


Thanks

  • 0
  • 0
PRMOD@SOTI | posted this 2 weeks ago

Hi Ben,

 

Please let us know if this issue is resolved for you? 

 

Thanks

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

  • 0
  • 0
Ben Anderson | posted this 1 weeks ago

The upgrade didn't work as such on the architecture that we had. We needed to upgrade to SQL Server 2014 and so we built a new server with Windows Server 2016 and upgrade the database before we could upgrade to 13.4

 

Which we now have done so we are working and I guess this can be closed.

  • 0
  • 0
Raymond, Chan | posted this 1 weeks ago

What you said is really interesting.   According to the official MobiControl documentation, MS-SQL 2016 is not officially supported for MobiControl v13.x.   I really don't know what level of testings have v13.x been done with this SQL version.   Hope you have already got official assurance and commitment from Soti support/professional service team that your approach is fine and supported.

 

  • 0
  • 0
Ben Anderson | posted this 1 weeks ago

Sorry, I do apologize, I got mixed up. I have amended the above post now.

 

SQL Server 2014

Windows Server 2016 

 

We know about 2016 not being fully supported but we went with it anyway. 

  • 0
  • 0
Give us your feedback
Give us your feedback
Feedback