Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Internal Web Error
Posted on 2013-01-08
We received this attached error on our intranet when we try and open a specific application.This problem occurs randomly.It has gotten worse the last few weeks where we actually have to restart the server for the application to open.I can't restart the server every day!
The two scenarios that i think is possibly causing this could be
:
1) The software installed by a third party company (This Web Based Employee clocking system) is causing issues with the ISS and ASP.net because of bugs in their software.2 months previously after they "fixed" an asp.net and IIS issue onsite on our premises everything was working fine until about a month ago when this error (attached) started popping up again .
2) Problem on our network or server but then other sections of the nework would also be slow?
Any advice?
Server-Error.gif
The two scenarios that i think is possibly causing this could be
:
1) The software installed by a third party company (This Web Based Employee clocking system) is causing issues with the ISS and ASP.net because of bugs in their software.2 months previously after they "fixed" an asp.net and IIS issue onsite on our premises everything was working fine until about a month ago when this error (attached) started popping up again .
2) Problem on our network or server but then other sections of the nework would also be slow?
Any advice?
Server-Error.gif
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5-
5
- +1
12 Comments
Active today
similar discussion here >>> http://social.msdn.microsoft.com/Forums/en-GB/adodotnetdataproviders/thread/44430e5a-631b-4156-9e4c-b1fc1e4a260a
if that is this clocking system then you need to ask them to have a look at this and change timeout settings I would say.
if that is this clocking system then you need to ask them to have a look at this and change timeout settings I would say.
Is the database server the same as the webserver? It could be a SQL query is creating a lock, or a SQL query is just very slow.
You could profile your SQL Database to see what's going on there. It could also be another database on the same server creating performance issues on this server.
You could profile your SQL Database to see what's going on there. It could also be another database on the same server creating performance issues on this server.
Att: ingriT.
Yes the database server,Mail server is all on one server.
Haven't used SQL Profiler before so i'll see if i can make sense of this built-in function within SQL Server 2008.
I've attached another screen which within SQL Server when trying to delete a row within a view in this specific Webregister db.Even creating a table within this db is giving this error.
Also get these errors in the log files on the second attachment
SQLError.png
Autogrowth-Error.gif
Yes the database server,Mail server is all on one server.
Haven't used SQL Profiler before so i'll see if i can make sense of this built-in function within SQL Server 2008.
I've attached another screen which within SQL Server when trying to delete a row within a view in this specific Webregister db.Even creating a table within this db is giving this error.
Also get these errors in the log files on the second attachment
SQLError.png
Autogrowth-Error.gif
The autogrowth error is the one causing the problems.
Is this a production or a development database? For production you might want to consult a co-worker or a database administrator if you have one.
On development I would just execute this statement:
With SQL Server 2008:
See this link for some more information: http://support.microsoft.c
Is this a production or a development database? For production you might want to consult a co-worker or a database administrator if you have one.
On development I would just execute this statement:
With SQL Server 2008:
use dbname
GO
DBCC SHRINKFILE(logname, 1)
GO
ALTER DATABASE MyDatabase
MODIFY FILE ( NAME = MyDatabase_dat, size=5000MB)
See this link for some more information: http://support.microsoft.c
Yes,it looks like the Logfile is causing the issue.I see the people who installed this third party software set the db + logfile to autogrowth by 10% in SQL Server which is not recommended by a lot of users on the internet.The actual size of these files in the relevant folder under Program Files is higher than the specified space reserved for space.
We do not have a development server,everything is life.
Can i change the the size properties for this db to a higher value and then run one of the above scripts in our production server.Is this to risky though or not really?
We do not have a development server,everything is life.
Can i change the the size properties for this db to a higher value and then run one of the above scripts in our production server.Is this to risky though or not really?
I'm not really an expert on databases, but I run this code on our production databases as well. I don't think it is too risky, especially if it isn't working now anyway.
Please do create a full database backup before running this procedure. And there can be performance issues on this server while running the command, it depends on the filesize how long this will take.
Please do create a full database backup before running this procedure. And there can be performance issues on this server while running the command, it depends on the filesize how long this will take.
The Logfile is 8 GB and the db 300MB.
I'll do the backup now.I'm not going to shrink the db but rather increase the space because we do have the space available
I'll do the backup now.I'm not going to shrink the db but rather increase the space because we do have the space available
Oké, that is an even better solution :)
But do keep in mind, that it will fill up some day, maybe set an alert in SQL if that is possible, or set autoshrink (see the previous link) on it at some point.
But do keep in mind, that it will fill up some day, maybe set an alert in SQL if that is possible, or set autoshrink (see the previous link) on it at some point.
I set the logfile to 15GB and the datafile to 500 MB without the Autoshrink and it worked!
Only problem was when i walked into work this a.m i saw an error in SQL and in the Application "The transactionlog for".." is full.To find out why space can't be reused........." I think this happened last night when the backups kicked off.
This specific db gets a full backup and after that the backed file gets shrunk with another Maintenance plan.
The two files now changed to 7385 MB and 317 MB respectively?This morning i tried several times to change these values but i got the same error in Sql 2008 as the error description mentioned in above paragraph.An hour after basically giving up i enter 10000 MB and 500 MB and miraciously it worked again.
Tonight i'll be running a normal full backup of this db and 20 minutes after that i'll be running the log backup.Is this the right sequence of setting the the full backup and then the log file backup?
Only problem was when i walked into work this a.m i saw an error in SQL and in the Application "The transactionlog for".." is full.To find out why space can't be reused........." I think this happened last night when the backups kicked off.
This specific db gets a full backup and after that the backed file gets shrunk with another Maintenance plan.
The two files now changed to 7385 MB and 317 MB respectively?This morning i tried several times to change these values but i got the same error in Sql 2008 as the error description mentioned in above paragraph.An hour after basically giving up i enter 10000 MB and 500 MB and miraciously it worked again.
Tonight i'll be running a normal full backup of this db and 20 minutes after that i'll be running the log backup.Is this the right sequence of setting the the full backup and then the log file backup?
Featured Post
Veeam is happy to provide a free NFR license for one year. It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference:
Let's make the introductions...
Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, 7 hours left to enroll
636 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.