NAV 2016 upgrade error during Data Upgrade step

rsaritzky

Hi all,

I'm upgrading a database from 2009->2016. In the last step (going from 2015->2016) I am running the "Data Upgrade" step.

I'm getting the following error:
SessionId : 0
CodeunitId : 104050
FunctionName : CheckPreconditions
CompanyName : <Companyname>
StartTime :
Duration :
State : Failed
Error : There is no Active Session within the filter.

Filters: Server Instance ID: 1024, Session ID: 74

Any ideas?

Ron

rsaritzky

Thanks, Saurav - I will try this!

Ron

postsaurav

Hi Ron,
It seems system is unable to find an active service mapped to the database.
Check the Service Tier, Make sure its running with a domain account and the domain account should have dbo permission in the SQL Server Database.

rsaritzky

Saurav,

This seems like a reasonable suggestion, but I can open the NAV client directly, or run a table from the DEV environment just fine. It's the

sashokcbe

Hi Ron,
I too got this error recently. Re-running the process again to check. Any updates on this? What 2016 Platform Executables you are using for this?

Ashok

rsaritzky

Hi Ashkok:

I am on 2016CU2 executables.

Ron

postsaurav

Hi,

Follow Below Steps to Resolve -

1. From Tools - Debugger, Open Event Subscriptions.
2. Filter For Codeunit 1 - Publisher Object Type - Codeunit, Publisher Object ID - 1.
3. Check Subscribers, if it is a Custom / Addon Object Delete it From Object Designer.
4. Run Sync Table Schema.
5. Run Upgrade Step 2 Again.
6. After Upgrade Process is complete, Re-import all objects Removed in Step 3.

For Details you can see - http://saurav-nav.blogspot.in/2016/03/microsoft-dynamics-nav-2016-data.html

rsaritzky

Thanks, Saurav - I will try this!

Ron