Welcome to ISAserver.org

RE: Getting no Reports

Users viewing this topic: none

Logged in as: Guest

Printable Version

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

Page: << < prev 1 [2] 3 next > >>

Message

<< Older Topic Newer Topic >>

RE: Getting no Reports - 4.Sep.2003 8:33:00 AM

aselicean

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

Hi Clive

I would even go to delete the report jobs and recreate them. Try to also delete the folders, if they are not deleted automatically. Try using custom folders for new jobs you gonna create. Carl's idea with a new user is great. Go try it.

Sorry for my silly idea, hope I didn't offend your IQ, man... I owe you a beer for that one...

Thanks.

(in reply to camos)

Post #: 21

Featured Links*

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

camos

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

Alin,

I guess I will have to come to Romania to get the beer. [Cool]

I haven't re-applied the updates yet or created a special ISA user account, will be doing that today.

Keeping in mind that I have never seen a working report. It appears to me that there may be a couple if issues that have been identified so far.

1. Creating a Report Job - should each job create its own scheduled item in Scheduled Tasks? Mine are not doing that.
2. When a report is created in ISAReports folder, is it supposed to be in its own sub-folder?
3. Running repgen.exe manually creates a 0 length file but generates no errors. That indicates to me that there could be a permission problem. Local Administrator with full control isn't enough, how can that be?

Food for thought... I am off to the salt mines.

Cheers,
Clive

(in reply to camos)

Post #: 22

RE: Getting no Reports - 5.Sep.2003 12:39:00 PM

Posts: 2
Joined: 5.Sep.2003
From: Vienna/Austria
Status: offline

Hi Clive

I think I have a similar problem with report generation after demoting my ISA-Server from DC to member server.

I have found an entry in the eventlog like the following

Event Type: Error
Event Source: Microsoft ISA report generator
Event Category: None
Event ID: 21009
Date: 05.09.2003
Time: 11:48:02
User: N/A
Computer: ISABOX1
Description:
The action to retrieve the DSN and table names for the ISA Server log failed.The error code in the Data area of the event properties indicates the cause of the failure. The error description is: The system cannot find the file specified.
Data:
0000: 05 00 07 80 ...€

My IsaDailySummary Job runs under the local administrator account and i was not able to leave this field blank (e.g. LocalSystem) (error when saving the job)

I have also checked the permissions and everything seams to be ok.

My last approach was to delete the job's in TaskScheduler and reapply them using the cmdline tool "at". After that the job does have a blank "run as" field and the reports work fine again. (new daily summary files etc...)

Maybe this will help you with your problem.

----------------------------------------
mfg (kind regards)
Rainer Horsak

(in reply to camos)

Post #: 23

RE: Getting no Reports - 5.Sep.2003 6:19:00 PM

camos

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

- The SP 1 and all hotfixes have been re-applied.
- Created a new user ISAserver member of Domain Users, Administrators, Schema Admins, Enterprise Admins. Added ISAserver account to the ISA install folder tree.
- In Scheduler, disabled the 2 tasks I had previously created manually, ISADailySummary and ReportGenerator. This didn't do good so I deleted them.
- Created new Report Job called Daily Summary. This did not create any task in Scheduler. Should it have? Probably should have but I don't know that because it has never happened.

None of this has accomplished anything.

Rainer,
I have found that demoting a DC isn't a particularly clean operation when it comes to permissions. I have never used the at command, would you please give me an example that relates to creating a Scheduled Task?

Not very cheery,
Clive

(in reply to camos)

Post #: 24

RE: Getting no Reports - 6.Sep.2003 12:08:00 PM

aselicean

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

Hi Clive

Tried to reproduce your scenario on my ISA, and what I found is that when you create an additional report job:
1. A new schedule is added to the task in Scheduled Tasks
2. A new folder is created under ISAReports.

So I guess that when you create a report job, if other does not exists, a new entry in Scheduled Tasks should be created. Used a local admin account and worked right after clicking OK.

I want to try this weeken a virtual machine with a new ISA installation.

Dunno where the problem is. Have you checked Event Log for any events that eventually will lead to the root cause of this ?

Thanks.

(in reply to camos)

Post #: 25

RE: Getting no Reports - 8.Sep.2003 8:36:00 AM

Posts: 2
Joined: 5.Sep.2003
From: Vienna/Austria
Status: offline

Hi clive,

i have added the job with the following command

at 00:30 /every:M,T,W,Th,F,S,Su "c:\program files\microsoft isa server\dailysum.exe"

You will get a job with the name At1 (or a higher number if a job with this name already exists). I renamed the job to IsaDailySummary.

first parameter:
The time when the job should run

second parameter:
The days of the week the job should run.

third parameter:
The command which should be executed.

Detailed information about the "at" command is also available in the w2k help.

(in reply to camos)

Post #: 26

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

camos

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

Alin,

It appears that something is definitly broken. When a new Report Job is created nothing is added to Scheduler. Manually created scheduled tasks do run. The dailysum.exe runs and a summary is created in \isaserver\ISASummaries. The repgen.exe runs but does not create a folder or a report in \isaserver\ISAReports.

There are no issues being reported in Event Viewer.

Rainer,

Thanks for the AT command info. My brain seems to have turned to mush, never thought to look in Windows Help. As suggested I used AT to create 2 tasks in Scheduler which did run but the results were the same as the previously mentioned manually created tasks.

Cheers,
Clive

(in reply to camos)

Post #: 27

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

aselicean

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

Hi Clive

I would prepare myself for the worst scenario: reinstall or, at least, fresh install on a new machine and export and import the settings using ISAExportImport.vbs available at www.isaserver.org. Then try there creating reports.

But right before that, aren't your reports being messed up right after some OS patches/hotfixes/WindowsUpdate processes ?

Just a philosophical question...

Thanks,

(in reply to camos)

Post #: 28

RE: Getting no Reports - 8.Sep.2003 9:28:00 PM

aselicean

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

Hi Clive

Do you, by chance, have the message screener installed ?

Thanks,

(in reply to camos)

Post #: 29

RE: Getting no Reports - 9.Sep.2003 4:55:00 PM

camos

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

Alin,

I have re-installed once already but both times the SP and all hot-fixes were applied immediately following installation. Only after upgrading was any ISA configuration done.

I don't think message screener is installed, at the least, I know I have not configured it. It is not listed under services, how would I find out?

Cheers,
Clive

(in reply to camos)

Post #: 30

RE: Getting no Reports - 9.Sep.2003 5:35:00 PM

Guest

what log file format are you using? Try it with the ISA server file format.

(in reply to camos)

Post #: 31

RE: Getting no Reports - 9.Sep.2003 6:05:00 PM

camos

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

PBH,

Log format is ISA

Cheers,
Clive

(in reply to camos)

Post #: 32

RE: Getting no Reports - 9.Sep.2003 6:36:00 PM

aselicean

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

Hi Clive,

When you installed ISA, there was at some moment a question asking you whether you want to install message screener.

I was asking this because I was browsing thru the tutorials and articles and found this one:

http://www.isaserver.org/tutorials/ISA_Server_2000_Fixes_July_2003_by_Scott_Jiles.html

Somewhere inside I've found a fix for some reporting problems.

See if it's your case.

HTH,

(in reply to camos)

Post #: 33

RE: Getting no Reports - 10.Sep.2003 10:13:00 AM

aselicean

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

Hi Clive

Found this one: http://forums.isaserver.org/ultimatebb.cgi?ubb=get_topic;f=2;t=003295

See if it applies.

HTH,

(in reply to camos)

Post #: 34

RE: Getting no Reports - 11.Sep.2003 6:54:00 AM

camos

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

Alin,

Checked for Message Screener and it is not installed. Did a re-install but not a fresh install and re-applied all SP/Hotfixes with no change. I did mention previously that I have tried a complete uninstall/reinstall.

Checked the Scott Jiles fixes but they do not relate to my problem. Followed your suggested forum topic re: the Skinley007 procedure which also did not help. As far as I can tell the DailySummaries are not corrupted and are succeeding in what appears to be a normal manner. It is the reports that are failing.

It was interesting to find a folder in the Registry similar to the special folder that was originally in ISAReports. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fpc\Reports\{FFAE4ADD-6A93-40AA-A7EF-6A424EB7462A}
Inside this folder is a Directory setting for alternate report folder path. Also found a key for Directory status which was set to 0. Changed it to 1 in a vain attempt to manually accept the directory. (Talk about reaching for the stars. [Eek!]

)

Cheers,
Clive

(in reply to camos)

Post #: 35

RE: Getting no Reports - 11.Sep.2003 8:25:00 AM

aselicean

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

Hi Clive

Will wait to see what happens. {Keeping fingers crossed}...

Cheers,

(in reply to camos)

Post #: 36

RE: Getting no Reports - 12.Sep.2003 6:42:00 PM

camos

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

After reinstalling ISA things are back to where they were at the beginning of this exercise. New Report Jobs do not create any new tasks in Scheduler. ISAReports has an empty sub-dir {FFAE4ADD-6A93-40AA-A7EF-6A424EB7462A}. The Schedule Tasks created before using AT cmd indicate they are being run on time. DailySum.exe is doing its job and ISASummaries are being created successfully. RepGen.exe seems to be doing its job, activity for 3 minutes in TaskManager Processes but no ISAReports appear in the dir. A search for *.irp finds nothing so reports are not going somewhere else.

Just got a message that the power is going down for a few minutes so I will send this message off.
There isn't much more to add anyway.

Cheers,
Clive

(in reply to camos)

Post #: 37

RE: Getting no Reports - 12.Sep.2003 10:10:00 PM

aselicean

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

Hi Clive

Sorry to hear that. I would try opening a ticket with MS PSS.

(in reply to camos)

Post #: 38

RE: Getting no Reports - 14.Sep.2003 12:51:00 AM

camos

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

Alin,

Yes, unfortunately that seems to be the only option left.

I want to express my gratitude to all for attempting to help me with this problem. In particular Alin, your sterling effort has been greatly appreciated.

Thanks,
Clive

(in reply to camos)

Post #: 39

RE: Getting no Reports - 14.Sep.2003 3:03:00 PM