Database Conversion Issue to NAV 2013 - (Invalid object name 'Session')

Hello Friends,

On last week i am working on upgrade project from NAV 2009 R2 to NAV 2013 R2 (IN Version).
It is heavy customize database there are lots of store procedure created in database to get the data using sql query.

I have got the error in database conversion from NAV 2009 R2 to NAV 2013
Error Detail: Invalid object name 'session'

Database is corrupted after this error. You will not able to open this database either using NAV 09 R2 or NAV 2013

Error Reason:

·         There are some non-compiled store procedure is created in SQL database. It cause the error in database conversion.

Solution:

·         There are 2 possible solution are available

1)      Restore the NAV 09 R2 data backup (*.bak) file using SQL and Take the backup from NAV in fbk file and restore it is using NAV.

Note:  After backup and restore the database from NAV. It will remove all the store procedure and other modification done on SQL database. It will solve the issue of non-compile SP

2)      Delete all the non-compiled store procedure from NAV 2009 R2 database and try again. (if it is possible than delete all the customize SP. You can add it later after database upgrade)

I hope it will help you in future.

Keep sharing.....keep growing !!!!!

Thank you