Welcome to ISAserver.org

Getting no Reports

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2000 General] >> General >> Getting no Reports

Page: [1] 2 3 next > >>

Message

<< Older Topic Newer Topic >>

Getting no Reports - 28.Aug.2003 8:04:00 AM

camos

Posts: 70
Joined: 17.Aug.2003
Status: offline

I have scheduled a daily Report Job. Logs and Alerts are enabled but nothing is showing up in the Reports folders.

Is there someting else that needs to be done?

Cheers,
Clive

Post #: 1

Featured Links*

RE: Getting no Reports - 28.Aug.2003 10:00:00 AM

aselicean

Posts: 260
Joined: 7.Dec.2002
From: Romania
Status: offline

Hi Clive

Reports are generated today for yesterday. So, if you setup reports today, you will get your first report tommorow.

HTH,

(in reply to camos)

Post #: 2

RE: Getting no Reports - 28.Aug.2003 4:36:00 PM

camos

Posts: 70
Joined: 17.Aug.2003
Status: offline

Alin,

Yes, I think I read that somewhere but ISA has been running for just over a week and there are still no reports. It appears that something isn't right.

New logs are being generated daily in the ISAserver/ISALogs folder.
- The Report Job is configured for Daily.
-Generation was initially set to Immediately and then became At the time the job was configured.
- Recurrence is set to generate every day
- Credentials are Administrator

My login ID is has Domain Admin and Schema Admin privileges. Is there something else that needs to be configured?

Cheers,
Clive

(in reply to camos)

Post #: 3

RE: Getting no Reports - 29.Aug.2003 1:16:00 PM

aselicean

Posts: 260
Joined: 7.Dec.2002
From: Romania
Status: offline

Hi Clive

I suppose you're logging to text files, not to any kind of ODBC-connected database engine...

Have you checked Event Log for any messages pertaining to ISA Server logging ?

Thanks.

(in reply to camos)

Post #: 4

RE: Getting no Reports - 29.Aug.2003 3:38:00 PM

camos

Posts: 70
Joined: 17.Aug.2003
Status: offline

Alin,

Yes, just to text. No point complicating matters too soon.

I don't know what this means but the only thing in the ISAReports folder is a folder called {FFAE4ADD-6A93-40AA-A7EF-6A424EB7462A} created about 1 week ago and it is empty.

Cheers,
Clive

(in reply to camos)

Post #: 5

RE: Getting no Reports - 29.Aug.2003 4:02:00 PM

aselicean

Posts: 260
Joined: 7.Dec.2002
From: Romania
Status: offline

Hi Clive

Did you checked the tasks used to generate the reports ? Try launching them manually, see what happens.

Go to Control Panel, Scheduled Tasks and you should have there 2 jobs (maybe amongst other), named: ISADailySummary and ReportGenerator.

What I (and my other colleagues) found during setting up these jobs (and other as well): on some W2K servers, you have to enter credentials *twice*. Go to each job properties, check the credentials, change them (actually re-enter them), hit apply, enter them again and hit again Apply and then OK. Then, try to run them manually.

HTH,

(in reply to camos)

Post #: 6

RE: Getting no Reports - 30.Aug.2003 7:09:00 PM

camos

Posts: 70
Joined: 17.Aug.2003
Status: offline

Alin,

It looks like Task Scheduler is where the problem is. The 2 tasks you mentioned were listed but when I tried to open each task an error was generated before the property sheet opened. Once opened I could not modify either one. I deleted both tasks and created a new Report Job but no Scheduled task was created.

Now I have manually created the tasks ISADailySummary and ReportGenerator. The Daily Summary was set to run 1 hour before the Report Generator. The tasks were run manually from Scheduler and they completed with no apparent errors. There is still nothing in the Monitoring/Reports folders though. [Confused]

This at the least is progress, perhaps the reports will be generated tomorrow. I will let you know either way.

Thanks Alin.
Cheers,
Clive

(in reply to camos)

Post #: 7

RE: Getting no Reports - 30.Aug.2003 7:16:00 PM

aselicean

Posts: 260
Joined: 7.Dec.2002
From: Romania
Status: offline

Hi Clive

You're very welcome. Let me know the results.

Thanks.

(in reply to camos)

Post #: 8

RE: Getting no Reports - 31.Aug.2003 5:47:00 PM

camos

Posts: 70
Joined: 17.Aug.2003
Status: offline

Alin,

According to Scheduler ISADaily summary ran at 2 AM and ReportGenerator ran at 3 AM. The Monitoring/Reports folders still have nothing in them. I am assuming these folders should contain whatever information was generated.

Cheers,
Clive

(in reply to camos)

Post #: 9

RE: Getting no Reports - 31.Aug.2003 9:50:00 PM

carlferrer

Posts: 13
Joined: 1.Apr.2003
From: Liverpool - UK
Status: offline

I know this sounds like a stupid thing to do.. but I too had the same problem when I set up our ISA server and a number of our clients have had the same issue. I found that when I put no user credentials into the report job the reports actually appeared in the folder, when previously with user credentials they did not. To make it even more of a strange thing, when I went back to the job after they had succesfully completed the Admin credentials were fully entered but not by me... strange I know, but maybe worth giving it a try it has worked on all the problem servers I have come across.

(in reply to camos)

Post #: 10

RE: Getting no Reports - 31.Aug.2003 11:19:00 PM

camos

Posts: 70
Joined: 17.Aug.2003
Status: offline

Carl,

Heh, heh, heh...
The MS way. [Roll Eyes]

So I have done what you suggested, crossed all my fingers and my toes to boot. Maybe tomorrow there will be something in those cronically empty folders.

Cheers,
Clive

(in reply to camos)

Post #: 11

RE: Getting no Reports - 1.Sep.2003 7:02:00 PM

camos

Posts: 70
Joined: 17.Aug.2003
Status: offline

I created a couple of Report Jobs that run at different times set for different periods.
Scheduler does not show any new tasks for these new Report Jobs. The only tasks shown are the ISADailySummary and ReportGenerator I had previously set up. These 2 tasks did run at the designated time. Running these tasks manually does something as there is disk activity indicating something is happening. There are files showing up in /ISAserver/ISASummaries but the only thing in /ISAserver/ISAReports is an empty folder named {FFAE4ADD-6A93-40AA-A7EF-6A424EB7462A}. Apparently summaries are being created but no Report Jobs.

As suggested, I have also tried re-entering and applying the credentials (Administrator) multiple times.

Bummer! [Confused]

Clive

(in reply to camos)

Post #: 12

RE: Getting no Reports - 1.Sep.2003 8:40:00 PM

aselicean

Posts: 260
Joined: 7.Dec.2002
From: Romania
Status: offline

Hi Clive

I must admit that I'm out of ideas. However, 2 things came to my mind. I would check the account under which ISA services are running and I would search the registry for that string, maybe it's related in one way or another with the ISA services (I doubt it but I would search it).

And one more idea (which came up as I wrote): Try to reproduce the tasks using command-line and see what happens. Maybe under a command window some error messages are readable.

HTH,

(in reply to camos)

Post #: 13

RE: Getting no Reports - 2.Sep.2003 8:31:00 PM

camos

Posts: 70
Joined: 17.Aug.2003
Status: offline

Alin,

I am unsure of your meaning regarding "check the account under which ISA services are running". I had a look under Services at MS ISA Server Control properties and there is a logon sheet with Log on as Local System selected and Allow service to interact with desktop not selected. Is that what you meant?

Good thinking Alin. I ran /ISAserver/repgen.exe (with no parameters...?) from the command prompt and it completed without indicating any errors. There was significant disk activity and the task took some time to complete so the appearance is that repgen did do something. However whatever it did, the results did not appear in the Reports folder. Do you know if there is a configuration that sets the path for Report results? If I knew what the file extension for reports is I could do a search for those files. This might tell us if they are being created in the wrong folder.

Cheers,
Clive

(in reply to camos)

Post #: 14

RE: Getting no Reports - 2.Sep.2003 9:38:00 PM

carlferrer

Posts: 13
Joined: 1.Apr.2003
From: Liverpool - UK
Status: offline

You can re-specify the location of where you want the reports to be generated by right clicking the Report Jobs folder under Monitoring Configuration in ISA Management. Try specifying a new folder for them to be generated in.

Pulling at straws here guys but do you have your ISA server setup as an array? Stick with me on this it si hard to explain... The ISA Server reporting mechanism combines the summary logs from the ISA Server computers into a database on each ISA Server. When the report is created, all relevant individual databases are combined into a single report database. The databases reside on the ISA Server computer.

If so you will not be able to view the reports if you run ISA Management of the array from another ISA Server computer.

Like I said pulling at straws but you never know... Good luck anyway...

(in reply to camos)

Post #: 15

RE: Getting no Reports - 2.Sep.2003 9:41:00 PM

carlferrer

Posts: 13
Joined: 1.Apr.2003
From: Liverpool - UK
Status: offline

PS... file extension for reports is .IRP :-)

(in reply to camos)

Post #: 16

RE: Getting no Reports - 3.Sep.2003 4:57:00 PM

camos

Posts: 70
Joined: 17.Aug.2003
Status: offline

Still no joy. Here is a review of the situation.

- I have 3 Report Jobs that indicate they are running.

- Scheduled Tasks, ISADailySummary and ReportGenerator indicate they are running. There are only the 2 tasks that I created manually. Should each Report Job create its own set of tasks?

- Daily summaries are showing up in the ISASummaries folder.

- No reports are showing in ISAReports folder. Did a search for .IRP - nothing. Manually set the report folder to the /ISAserver/ISAReports folder.

- Credentials are administrator. If it matters, this account has been renamed. Could/should the System account be used for this? Hmmm, probably not, did a browse and System did not show up in the list. Another straw.

Carl, this is a standalone server so there's no hay but the way I have been pulling at straws there certainly could be before this thing is resolved. [Wink]

I am out of ideas too.

Cheers,
Clive

(in reply to camos)

Post #: 17

RE: Getting no Reports - 3.Sep.2003 9:25:00 PM

aselicean

Posts: 260
Joined: 7.Dec.2002
From: Romania
Status: offline

Hi Clive

Can we just go back and review all the settings ? I have the feeling that we missed somtehing.

So:
1.Right-click the Report Jobs under Monitoring Configuration in the left-hand side of the ISA MMC and select Properties. Make sure Enable Reports and Enable Daily and Monthly Summaries are checked.

2. Check the settings for folders and make sure the folders do exists, if set to custom folders. Also, I would check permissions on those folders.

3. Check the properties for Report Job on the right-hand side of ISA MMC. All of them: status (enable/disable), first occurence, recurrence (I would try once with Immediatley with no recurrence), credentials (I would try using either the same accountused for ISA services or with a local administrator).

4. Check properties for tasks created by this job, in Scheduled tasks. I would try reproducing the reports mannualy, running the command specified in scheduled tasks in a command prompt window with the output redirected to a text file.

5. I would try to reapply the SPs and latest fixes.

With the risk of being silly: you said that you have a weird-named folder inside the ISAReports folder. That string is the ClassID or ProductID (something like that) of ISA Server product. Have you checked that folder to see if it's the last leaf in the folder tree ? Why... Because the reports are created in ISAReports\<product-id>\Report Job\*.IRP. Now, the Report Job name might be different in your case.

No more ideas... [Frown]

HTH,

[ September 03, 2003, 09:31 PM: Message edited by: Alin Selicean ]

(in reply to camos)

Post #: 18

RE: Getting no Reports - 3.Sep.2003 9:31:00 PM

carlferrer

Posts: 13
Joined: 1.Apr.2003
From: Liverpool - UK
Status: offline

Have you got service pack 1 installed...? If not try installing that, not sure what fixes it gives you but you never know it might have a hotfix for reports. Also while we are at it try and install feature pack 1 - again this may give extra features to reports.

Regarding the user name, try and create a brand new user called reports and give them full access to everything, in other words schema admin, everything ISA etc and then use this user for the reports, as far as I understand as long as the user has privilages for ISA they can be the credentials for reports.

I have done a significant search on Microsofts premier site for you as well (only MS partners have acess to this and it tends to have a lot of stuff the standard technet doesn't) but that brought up very little background on ISA reports unfortunately.

Try the above if not already tried and I will have a good think over the next few days and see if there is anything else I can think might sort you issue... Let me know how you get on though, I am determined not to let this go unresolved...

(in reply to camos)

Post #: 19

RE: Getting no Reports - 4.Sep.2003 7:42:00 AM

camos

Posts: 70
Joined: 17.Aug.2003
Status: offline

Here we go:
1. General tab - Enable Reports (check). Location Other folder (currently).
Log Summaries tab - Enable daily and monthly summaries (check). Location ISASummaries folder. Number of summaries Daily summaries 35, Daily summaries 13.

2. Reports folder does exist. Permissions: System Full Control, Administrators Full Control, Domain Admins Modify, Just added Schema Admins Full Control.

3. All Reports enabled. Credentials are Administrator (local). ISA Server Control Log on tab - changed from Local System to This Account Administrator (local).

4. There are 4 Report Jobs. The Report Jobs do not create Scheduled tasks. There are only the 2 tasks I created manually, they do run. This is interesting, ran E:\ISAserver>repgen > e:\isaserver\reports\mydaily.irp
The file mydaily.irp was created in \reports but it is a 0 length file. Did the same with testrep.txt with the same negative result.

5. I will try re-applying the SP's and hot fixes tomorrow.

Silly Idea. [Big Grin]

Perhaps but the way things are going...
There is nothing inside the \ISAserver\ISAReports special folder. When I ran repgen in the \ISAserver\Reports folder no comparable special folder was created.

Regarding Carl's question: the sp1 with feature pack and all hot fixes were applied immediately after instlling ISA.

After that I'll give the new ISA user idea a shot.

You guys are keeping me busy. [Razz]