Hello,
I designed a report in NAV 5.0 SP1 (in a test enviornment), and it seemed to be working fine for a couple of months. I was finally ready to move it to my live database, but when I tried to export it to a .fob it crashed my database. Every time I click on the report in object designer, or scroll past it, I receive the following error and my connection to SQL server (version: 2005) is lost:
Your connection to the ‘LOCALHOST’ server is no longer responding. This is probably because of one of the following reasons:
- The Server has been shut down, either manually or as a result of an error.
- Your session has been killed by an administrator.
*A network failure has occured.
*A hardware failure has occured on the server computer or on your computer.
Contact your system manager if you need assistance.
It then boots me out of the database. As far as I know nothing has changed on the server, or in the object between now and the last time it was working. The error occurs on any computer I try this from, and I can ping the SQL server just fine. All of the other reports are functioning fine. I’m guessing there must be some sort of issue with that particular report, but I can’t even click on it, let alone get it open in design mode to see what is going on. Any ideas on what is causing this or how I can troubleshoot it would be much appreciated. Preferably, I would like to be able to save my report. Any thoughts?
Thanks!