ISA Server

Question

Post reply

ISA Server

VastSQL

SSC-Dedicated

Points: 36144
More actions
August 4, 2008 at 8:35 pm

#130438

Hi Experts,
We are using ISA Server 2006 application and daily am getting the error
The ISA Server web filter failed to log information to MSDE database ISALOG_20080808_WEB_000.The MSDE Error description is database already exists.
Went through the .mdf and .ldf files.Found new database already created with tomorrows date

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736644 More actions · Answer 1

Does ISA create a new database every day?

Wow, that's kind of amazing.

VastSQL SSC-Dedicated Points: 36144 More actions · Answer 2

VastSQL

SSC-Dedicated

Points: 36144

August 5, 2008 at 1:31 am

#853035

Please find the attachment.

Jeff Moden SSC Guru Points: 1004454 More actions · Answer 3

From the description of things, it sounds like you have some code somewhere that makes tomorrow's database today... maybe, in more than one spot. I'm thinking that all you have to do is change that code, where ever it appears, to test to see if tomorrow's database already exists before it trys to make a new one.

Hopefully, it's in a nice stored procedure that's easy to change without having to recompile your app. Otherwise, you'll just need to hucker down and find all the instances of code in your application that try to make the database.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

GSquared SSC Guru Points: 260824 More actions · Answer 4

Jeff Moden (8/6/2008)
From the description of things, it sounds like you have some code somewhere that makes tomorrow's database today... maybe, in more than one spot. I'm thinking that all you have to do is change that code, where ever it appears, to test to see if tomorrow's database already exists before it trys to make a new one.
Hopefully, it's in a nice stored procedure that's easy to change without having to recompile your app. Otherwise, you'll just need to hucker down and find all the instances of code in your application that try to make the database.

ISA Server 2006 is a Microsoft product. != Open Source. He won't be able to change any code.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

GSquared SSC Guru Points: 260824 More actions · Answer 5

I'm going to hazard a guess that either one of the servers has the wrong date on it, or someone set the calendar ahead one day to test something (or something like that), and then set it back.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

VastSQL SSC-Dedicated Points: 36144 More actions · Answer 6

I expected the same and checked the date and time,no hope.Date and time or the server is the current date and no issues with the same.Persently we are restarting the server everyday.Please help

Thanks very much in advance and thanks for the replies.

GSquared SSC Guru Points: 260824 More actions · Answer 7

It's going to take a call (or e-mail) to Microsoft to sort this one out.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Andy sql SSCrazy Eights Points: 9496 More actions · Answer 8

Some good information can be found in the TechNet article "Monitoring, Logging, and Reporting Features in ISA Server 2006":

http://technet.microsoft.com/en-us/library/bb794817.aspx

Amazingly, yes, ISA Server does create a new database each day.... I guess they never need to worry about partitioning tables 🙂

Of interest to this post is the statement: "ISA Server prepares log databases for the next day in advance. When you save logs to MSDE, a database that refers to the next day always exists."

So, what you are experiencing is normal behaviour; the database for the next day should exist. The mystery is why you are getting an error.

VastSQL SSC-Dedicated Points: 36144 More actions · Answer 9

When i disabled that particular login for which the error occuring,the server

is working properly and no error is reported so far....:crazy:

Andy sql SSCrazy Eights Points: 9496 More actions · Answer 10

Could it be, through some hair-brained logic, that the ISA Service tries writing to the database; if the write fails, it assumes the database does not exist and then tries to create it???