Scheduled Report not running- Getting "Undefined/Deleted Computer" error

rahul77d 13
Viewed 0

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
undefined deleted computer
8 Answers

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.

Quinn2713

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.

rahul77d13

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.

rahul77d13

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.

Quinn2713

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.

rahul77d13

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.

Quinn2713

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

Typotex AG2

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.

Quinn2713
Related