Hi, We have scheduled reports which run weekly, but the following report is giving the following errors- see logs below. Our Admin mentioned that he removed the deleted computers, but we keep on getting this error. How can we remove the undefined/deleted computers? i'm guessing there is a step we are not performing.

06-14-2014, 07:30:19.945, TID:02436, PID:01700, Starting report File Export: Comma Separated Values (CSV) on All Changes, cookie=424285
06-14-2014, 07:30:19.945, TID:02436, PID:01700, Activity: Determining data set IDs
06-14-2014, 07:30:19.945, TID:02436, PID:01700, Activity: Gathering data set 1 of 1 from All Changes
06-14-2014, 07:30:19.945, TID:02436, PID:01700, Activity: Initializing File Sight database connection
06-14-2014, 07:30:19.947, TID:03292, PID:01700, Created new report.  Cookie=424285
06-14-2014, 07:30:19.947, TID:03292, PID:01700, Report status for cookie=424285, finished=0
06-14-2014, 07:30:19.962, TID:02436, PID:01700, Activity: Connected to database
06-14-2014, 07:30:19.962, TID:02436, PID:01700, Activity: Initializing File Sight database connection
06-14-2014, 07:30:19.973, TID:02436, PID:01700, Activity: Connected to database
06-14-2014, 07:30:19.976, TID:02436, PID:01700, ERROR: Failed to load Computer for index 1 -- [Undefined/Deleted Computer (1)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.976, TID:02436, PID:01700, ERROR: Failed to load Computer for index 2 -- [Undefined/Deleted Computer (2)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.977, TID:02436, PID:01700, ERROR: Failed to load Computer for index 1 -- [Undefined/Deleted Computer (1)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.977, TID:02436, PID:01700, ERROR: Failed to load Computer for index 3 -- [Undefined/Deleted Computer (3)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.978, TID:02436, PID:01700, ERROR: Failed to load Computer for index 3 -- [Undefined/Deleted Computer (3)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.978, TID:02436, PID:01700, ERROR: Failed to load Computer for index 8 -- [Undefined/Deleted Computer (8)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.978, TID:02436, PID:01700, ERROR: Failed to load Computer for index 8 -- [Undefined/Deleted Computer (8)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.979, TID:02436, PID:01700, ERROR: Failed to load Computer for index 2 -- [Undefined/Deleted Computer (2)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.979, TID:02436, PID:01700, ERROR: Failed to load Computer for index 23 -- [Undefined/Deleted Computer (23)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.980, TID:02436, PID:01700, ERROR: Failed to load Computer for index 24 -- [Undefined/Deleted Computer (24)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.980, TID:02436, PID:01700, ERROR: Failed to load Computer for index 25 -- [Undefined/Deleted Computer (25)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.980, TID:02436, PID:01700, ERROR: Failed to load Computer for index 23 -- [Undefined/Deleted Computer (23)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.981, TID:02436, PID:01700, ERROR: Failed to load Computer for index 25 -- [Undefined/Deleted Computer (25)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.981, TID:02436, PID:01700, ERROR: Failed to load Computer for index 24 -- [Undefined/Deleted Computer (24)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:19.982, TID:02436, PID:01700, ERROR: Failed to load Computer for index 27 -- [Undefined/Deleted Computer (27)]  FileSightDataSets.cpp, 982
06-14-2014, 07:30:20.125, TID:02436, PID:01700, Finished report File Export: Comma Separated Values (CSV) on All Changes, cookie=424285
06-14-2014, 07:30:20.129, TID:02436, PID:01700, Activity: File Export: Comma Separated Values (CSV) on All Changes

asked 17 Jun '14, 09:34

rahul77d's gravatar image

rahul77d
324
accept rate: 0%


Hi --

The entries that you are seeing in this log file is telling you that you have data still in the database for a number of servers. The servers have been removed from the monitoring but the data that the monitors had collected is still in the database. These errors shouldn't be shown on your reports that you have scheduled.

Is your report still being created or are you getting errors shown in the report?

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

link

answered 17 Jun '14, 11:05

Quinn's gravatar image

Quinn ♦♦
13.7k3925
accept rate: 40%

Thanks for the response. I just tried to schedule the report again today by changing the schedule, but the report didn't generate. I can manually generate the report without any issues. The issue i have is that for this specific scheduled report, its not being generated automatically and i have to manually run it.

link

answered 17 Jun '14, 11:56

rahul77d's gravatar image

rahul77d
324
accept rate: 0%

Just following up on this- so, to fix this issue, do we have to manually remove data still in the database for all the server which were removed from monitoring? I spoke to our admin and all he does is stop the monitoring and removes the agent from the server. he wasn't aware that he needs to remove any data from the database.

link

answered 23 Jun '14, 10:14

rahul77d's gravatar image

rahul77d
324
accept rate: 0%

It sounds like you still have some deleted servers listed in the scheduled report. Try removing the deleted servers from the scheduled report and then run it. (To run the scheduled report right away right click on the report and select Run Now.)

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

link

answered 23 Jun '14, 14:19

Quinn's gravatar image

Quinn ♦♦
13.7k3925
accept rate: 40%

Thanks for the response. The undefined/Deleted servers are listed in the "Filter and Parameters > Server" field, but they are not checked. however, i don't know how to remove these servers from the item selection window.

Even when i try to create a new scheduled report and go to select my servers, the undefined/deleted servers are listed (but not checked).

Should i try the "Clean all Reports now" option under Report Settings? i'm not sure what it does.

link

answered 23 Jun '14, 14:24

rahul77d's gravatar image

rahul77d
324
accept rate: 0%

Can you send me screenshots of your settings for your scheduled report? Please make sure to include all of your tabs. Please send them to support@poweradmin.com and address your email to Quinn.

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

link

answered 23 Jun '14, 15:42

Quinn's gravatar image

Quinn ♦♦
13.7k3925
accept rate: 40%

Hi I have the same issue in File Sight version 6.4.0.307. Is there a solution for this?

link

answered 22 Jun, 07:52

Typotex%20AG's gravatar image

Typotex AG
1
accept rate: 0%

Hi Typotex AG,

It means a computer was being loaded, but it doesn't exist. This usually means a database/report refers to a computer that was deleted. It's hard to track these down, but they are almost always report related since items in a database can live longer than the computers/monitors that created that database row. The data in the database will eventually be removed when the cleanup function runs but that may take a while.

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

link

answered 22 Jun, 09:09

Quinn's gravatar image

Quinn ♦♦
13.7k3925
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×3
×1
×1

Asked: 17 Jun '14, 09:34

Seen: 2,716 times

Last updated: 22 Jun, 09:09