Error While restoring Backup in NAV 2013

chandrurec

Hi all,

I am trying to restore the backup in nav 2013 in the newly created db. When I try to restore the backup , I am getting a error as follows.

The Session Event already exists.

Identification fields and values:

User SID='{3C9455E4-B2CE-4A20-8287-DC061AA4B926}',Server Instance ID='3',Session ID='42',Event Datetime='11-06-13 10:28 AM',Event Type='Logon'

If anyone knows how to overcome this error, Kindly let me know.

Thanks in advance.

Regards,
chandru.

mohana_cse06

You can search with the error
http://dynamicsuser.net/forums/t/57903.aspx
http://www.mibuso.com/forum/viewtopic.php?t=55601
http://www.dynamics.is/?p=1363

arvkum

Normally following trick should solve this.
Truncate the rows first, from the following tables in the DB where you are restoring this backup.

1. Session Event
2. Active Session
3. User
4. User Metadata
5. User Personalization
6. User Property

Some Details you Can check http://msdn.microsoft.com/en-us/library/jj551765(v=nav.70).aspx

Thanks
Arvind

chandrurec

Hi arvkum,

So what ideally I must do is first I should the run the truncate query in db where I am taking the backup and then take the backup and then restore it.

Am I right?

I tried to create the db as per your suggestion and then run the truncate query and then restored the backup but still I am getting the same error.

Kindly advise.

Thanks & Regards,
chandru.