Upgrading from latest 12.4 to latest 13.4

Upgrading from latest 12.4 to latest 13.4

BA
Ben Anderson

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?

...Show More
  • 03 December 2018
  • SOTI MobiControl
  • 7 Answers
  • 0 Upvote
  • 1 Follower
  • 3.3K Views
    •
    • 7 Answers
    • 0 Upvote
    • 1 Follower

7 Answers

Order By:   Standard | Newest | Votes
Support Staff | posted this 01 March 2019

Hi Ben,

 

What versions are you getting the error between?

 

As the error you are receiving is being generated after the DB is backed up try doing your backup manually and unchecking this in the installer in the advance section before committing to begin the upgrade.

 

Also, the actual error is indicating an error with sp_rename on line 140, without access to your version of the DB I cannot confirm what that line contains but I have used a clever workaround before for issues such as these and that is to upgrade to an in between version when you are following the upgrade path.  Assuming your issue isn't that you are not following the upgrade path in the first place?? 

 

For example follow the upgrade path here but when you get to the last version that is upgrading successfully upgrade to a version before the one you are erroring out on.   This may help to update the procedure in question with the correct information/format and then upgrade to the version you were having difficulty upgrading to.

 

Hopefully you have a successful upgrade after this.

 

Cheers,  

 

 

 

 

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

  • 0
  • 0
  • 0
  • 0
Ben Anderson | posted this 11 February 2019

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
  • 0
  • 0
Raymond Chan | posted this 11 February 2019

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
  • 0
  • 0
Ben Anderson | posted this 11 February 2019

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
  • 0
  • 0
PRMOD@SOTI | posted this 08 February 2019

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
  • 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
  • 0
  • 0
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
  • 0
  • 0

Give us your feedback
Give us your feedback
Feedback