The Session Event already exists

Kau_147

Hello All

I have some problem. when I restore backup into NAV 2013 new database, this error results:

---

Microsoft Dynamics NAV Development Environment

---

The Session Event already exists.Identification fields and values:

User SID='{7A4F0FCC-6F43-4691-80A1-FA700AE196F4}',Server Instance ID='2',Session ID='40',Event Datetime='08/10/12 04:01 PM',Event Type='Logon'

---

OK

---

what should I do?

Please Help ](*,)

Thanks in Advance

Best Regards,
Kavita Bavkar

vijay_g

Go through this link....
http://dynamicsuser.net/forums/p/57903/310606.aspx

afarr

I got a similar error today, when restoring a NAV 2013 .fbk into a new, blank NAV 2013 database.

The Session Event already exists.
Identification fields and values:
User SID='{00000000-0000-0000-0000-000000000001}', Server Instance ID='2',Session ID='1',Event Datetime='01/11/12 13:46',Event Type='Logoff'

The mentioned link unfortunately does not provide a solution - it just links to the standard list of steps for restoring a .fbk

Note:
1. The Session Event table seems to be empty in SQL.

2. The record mentioned in my error is different from that mentioned by Kau_147

3. When I restored a second time, exactly the same error is reported. But when I restored a different .fbk in the same database, no error was reported. So the record apparently exists in the .fbk itself, or is somehow re-created (at least twice) during the restore.


This may be due to the way that the .fbk is created - e.g. because the .fbk was created while the user was logged into a company, so if the user logs out of all companies before creating the .fbk then the error would not appear during the restore. This is just a suggestion, it's probably wrong.

afarr

There is a workaround to this problem -

1. import just the objects from the .fbk (you can import from an .fbk the same as from a .fob file);

2. import just the companies, without application objects, or data common to all companies.

This works because system tables are not imported in step 1.
The only small snag is if you have a table that has "Data Per Company" set to No - its data won't be imported in step 2.

tularam

Yes This Solved the problem, but may i know what caused the problem??

afarr wrote:

There is a workaround to this problem -

1. import just the objects from the .fbk (you can import from an .fbk the same as from a .fob file);

2. import just the companies, without application objects, or data common to all companies.

This works because system tables are not imported in step 1.
The only small snag is if you have a table that has "Data Per Company" set to No - its data won't be imported in step 2.

afarr

I'm afraid I never found out what caused the problem (or how to avoid it in future).

tularam

afarr wrote:

I'm afraid I never found out what caused the problem (or how to avoid it in future).

May be you have multiple instance and you have selected wrong instance.
I got same error while i was running NAV 2009 and 2013 parallel. By mistake i choose wrong instance (Instance of 2009) then i got the same error.

pman

To solve the Problem, do following:

-start SQL Server Management Studio - Go to the source DB, to table

dbo.Session Event and right click "Edit Top 200 Rows"
- select all entries and delete them
- create a new FBK from the source DB
- restore the new FBK in the target DB

This worked for me. Hope it works for you.

Regards
Daniel