Server Details Page Leads to Blank/Error Page. What should I do?

Server Details Page Leads to Blank/Error Page. What should I do?

While clicking on the server monitor it leads to blank or error page. This could be due to some entries missing in the database tables.
I have attached the following files. (These are all the sample output files).
  • select_query_new.txt --> file used to find out missing tables.
  • OutputPGSQLResult_New.txt --> Customer output.
  • insert_query_new.txt   --> Based on the customer output, we have given insert queries to overcome this issue.
If you see the "OutputPGSQLResult_New.txt" file, entries for the server "10.200.92.6" is missing in the following tables.
  • CollectData
  • HostDetails
  • ManagedObject
If you see the "insert_query_new.txt " file, we have given the insert queries to insert the entries in the above tables. This should resolve this issue.


Note

I have given the sample output here. If you find any entries are missing in some other tables, you need to give insert query for those table as well.

                    New to ADSelfService Plus?