NAV 2013 RTC crashes when running a big xml import

matthewtaing

Hi,

Encountered the following scenario when I tried to import a big xml file.

Details :-
SQL Server 2012 Express.
NAV version: 7.00.34664
Number of Lines from files : 500000+ of lines
File Size: 64.8mb

*The process was run on the NAV server itself.

1. The error occurs for standard settings thus tried changing the following settings on the client services to resolve it but failed. :-
- Chunk Size to 80
- Max Upload Size to 2047
- Reconnect Period to MaxValue
2. The first import after I restart the service tier works but I get the prompt of server connection disconnected where when I clicked yes to reconnect then it imports successfully. (Refer to server disconnected prompt.jpg)
3. Subsequent tries of import encounter the same server disconnection prompt (refer to server disconnected prompt.jpg) and then RTC crashed with error message "The session could not be retrieved from the server. The application will close" (Refer to RTC crash message.jpg) and the session will be orphaned in the active session table.
4. Checked the event viewer log and recorded 3 NAVclient error but all of it says the same thing as 3. (refer to Event Viewer 1.jpg)

Would greatly appreciate any help or ideas on how to resolve this.

Thanks

ara3n

I suggest to report it to MS