The Session Event already exists

Kau_147
Member Posts: 84
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
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
Best Regards,
Kavita Mutha
Kavita Mutha
0
Comments
-
Go through this link....
http://dynamicsuser.net/forums/p/57903/310606.aspx0 -
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.Alastair Farrugia0 -
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.Alastair Farrugia0 -
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.0 -
I'm afraid I never found out what caused the problem (or how to avoid it in future).Alastair Farrugia0
-
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.0 -
To solve the Problem, do following:
-
-start SQL Server Management Studio
- Go to the source DB, to table
- 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
DanielCarpe diem!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions