Link to home
Start Free TrialLog in
Avatar of anseris
anseris

asked on

ISA server report failure

ISA Server 2000 on Small Business Server 2000. I created a daily report job which worked nicely until late last week, when the reports simply stopped appearing. The report job itself has a status of "Failure", but I can't find any other information anywhere. How do I go about troubleshooting this?

Thanks
anseris
Avatar of Julian_C
Julian_C
Flag of United Kingdom of Great Britain and Northern Ireland image

Hi there,

Not much to go on here so. Is there anything in the eventlog? ISA uses a named account to produce these reports. Is the account still OK, has it expired, been locked out etc etc. Look for a clue in the event log message.

Cheers
Julian
Avatar of anseris
anseris

ASKER

I can't find anything in the event log from the ISA server. I have looked for logging settings in ISA management but can't find anything for report generating.
OK, if you look in The ISA managment in Monitoring Configuration\Logs and make sure it's enabled (right click). Then in Monitoring Configuration\Reports Jobs, find your report and right click it and check the credentials. The user should be valid user.

Cheers
Julian
Avatar of anseris

ASKER

Found a problem with the application log - but will take that to the appropriate forum in due course.

The username is definitely valid, and it's the same username used back when the report was being generated correctly. So the event in the log still doesn't look terribly helpful. Details:

Event Type:      Error
Event Source:      Microsoft ISA report generator
Event Category:      None
Event ID:      12026
Date:            8/26/2004
Time:            8:56:07 AM
User:            N/A
Computer:      CVMSRV1
Description:
The action to create the scheduled report, "Report Job", with the specified credentials, failed. The error code in the Data area of the event properties indicates the cause.  
Data:
0000: 0d 00 00 00               ....    
Just to humour me for a minute. Change the user to an Administrator and run the report again. I'm not saying that this is how it needs to stay but I am trying to eliminate possibilities.

Cheers
Julian
Also, the other error you are getting in the event log isn't something to do with bsing unable to talk to the domain controller is it?
Avatar of Bembi
Have you installed the latest service packs ?!? :-)
What Julian is saying is correct, the user account, the reports are using, must have permissions on ISA. You can take a service account for that or create a new one.

I experienced that behavior after installing SP2. Recreating the reports with a service account works fine.
Avatar of anseris

ASKER

Okay, Administrator can't generate the reports either.

We only have one server here, so it's a domain controller running ISA server and everything else.

I will go check the service pack situation, but there certainly weren't any installed since last week when the reports were working.
So, what was changed since last week? Are you running windows update automatically? Something has  changed. Any further  clues in the event log?

Please verify whether the Task Scheduler (MSTask.exe) is started. If this service was stopped, the reports will not be generated.
Yes, but not having the schedule service running wouldn't generate the "Credentials Failed" error in the event log I think? That error suggests that it is a least trying to run and failing for security reasons.

Have you tried just creating a new (identical) report using another account BTW?

Cheers
Julian
Note that - as the scheduler runs as a service - the account you are using might have the permissions to run as service and to logon locally, set by the local policies.
Avatar of anseris

ASKER

Okay, there's a report sitting on the server this morning - wasn't there at 3pm yesterday which was the last time I checked. It claims it was generated at 1.08pm yesterday, which was when I tried to generate the report from the administrator account, but no report appeared at the time, and there's an error in the event log (same as the one already posted) to prove that I wasn't imagining things.
It contains the data for 25/8.

Changed the report schedule to "immediately" and got the report for 26/8.

It seems that no event is generated for successful reports.

So I have now scheduled the next report for Saturday at 6.00am, let's see how that goes... I HATE intermittent problems.

Things that changed on the server yesterday:
(1) Fixed application log
(2) Changed accounts under which ISA report is generated (now back on original account)
(3) AV update
The problem can't have been just a mistyped password in the account credentials, the reports stopped appearing before I made any changes to the account details.

Re your suggestions:
MSTask.exe is running.
SP2 not yet applied. I had planned to apply it tonight after work but now will wait to see if the report scheduled for tomorrow morning is generated.
The application log wasn't doing its job back when the reports stopped happening. I will go through the system log with a comb but at first glance there's nothing unusual there. Windows Automatic Update isn't running on the server.
ASKER CERTIFIED SOLUTION
Avatar of Julian_C
Julian_C
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of anseris

ASKER

Saturday's report and today's have generated as expected.

So, not sure why the reports stopped, but I think I will close this question and then go have a good look at what monitoring is being done on the server.

Thanks very much for your time and suggestions.

anseris