RA Fix #2

1)You can try the following on the RA console.

mysql -P3308 reporter

delete from database_servers_scheduler where resultcode not like '%SUCCEEDED%';

2)Then recycle the ReporterAnalyzer Manager service on the RA console and the "DSA Loader Service" on the DSA and see if those tables start updating or not.

Then wait about 15-30 minutes to see if any new data shows up.

3)If not, just delete the interface from the "Administration->Physical & Virtual", this will delete the agent record from the database and should clean up the DSA.

4)Then delete the full router from "Administration->Enable Interfaces"

5)RDP to the Harvester and run the following....

mysql -P3308 harvester

truncate table routers;

truncate table interfaces;

6)Recycle the "Harvester" and "Reaper" Services on the Harvester.

7)Wait for the router to show up again in "Enable Interfaces" and enable the interfaces.

8)Wait at least 15-30 minutes before expecting any data

9)If no data, run an NFA Parser report and verify that specific interface has more than 50 KB of traffic over a 15 minute period.

RA Router fix issue

If you look at the report for this interface for less than two hours do you see any data?

Are other devices using the same DSA having the same issue?

You could use the query below to find out what other interfaces are using that DSA.  Use the router Address in the first query to find out what DSA its using, then use the DSA address in the second query to see what other devices are using that DSA.

mysql -P3308 reporter

select DataServerAddress, RouterAddress from agents_all_view where RouterAddress='x.x.x.x';

select * from agents_all_view where DataServerAddress="x.x.x.x";

Can you also upload a SupportCIG file if possible so I can see what is going on in the logs?

ftp://ftp.ca.com/pub/netqos/supporttools/releasedtools/SupportCIG.exe

You may also want to check the DSA credentials on the Administration->DSA page to make sure they are a valid login for the RA console and the account is not locked out or anything like that.

Copy/Paste

http://www.evernote.com/shard/s4/sh/9ce13685-da6f-40f3-b48a-5130deed047a/f9fd89c5f795d9863769e476e5b4f2ce

Restarting a Windows Server from another NetQoS server

Sometimes when you restart a server, it hangs and doesn't restart. This means that the RDP sessions fails but you can ping the box.

Use the shutdown -i command from the command line of another server. Fill out the GUI to force a restart.

You can also run the following from command line:

shutdown /r /m \\servername

Where servername is either an ip address or the dns name of the server.

NV database repair (BI)

Completed successfully on 11/27/2012

 

NV database repair:

show databases

use nms2

repair table pollinst use_frm; <enter>

repair table group_instances use_frm; <enter>

nqwebtool -verbose

nqwebtool -verbose

Free Up Space on the C Drive

***PUBLIC INFORMATION - THIS CAN BE SHARED WITH CUSTOMERS AS NEEDED***

ISSUE

How do I free up some space when the C:/ drive is near full?

RESOLUTION

The simplest thing to do to free up some space on the C:/ drive is to run the NQDiskCleaner utility. Just download the tool and run it anywhere on the server. It will remove any unnecessary and temporary files.
ftp://ftp.ca.com/pub/netqos/supporttools/releasedtools/nqdiskcleaner.zip (see options below)

Use windirstat to find out what is taking the most space. http://sourceforge.net/projects/windirstat/.
That will show disk usage in a visual way where you can see what is taking up the most space. Look at C:, and see if you can clean up some disk space.

If this doesn't free up enough space, you can move the page file over to the D:/ drive. To do this, just follow these steps:

1. Right click on My Computer -> Properties
2. Select Advanced tab.
3. Click Settings in the Performance section.
4. Select Advanced tab.
5. Click Change in the Virtual memory section.
6. Note the values under 'Initial size (MB):' and 'Maximum size (MB):'
7. Select the D: drive. Select 'Custom size:'
8. Change the values to match the ones noted in step 6.
9. Click 'Set'
10. Select the C: drive.
11. Select 'No paging file'
12. Click 'Set'
13. Click 'OK' three times.
14. Select Yes to Reboot the server.

You could also try moving the windows temp folders to the D:\ drive, where there is usually more space.

1. Right click on My Computer and select Properties.
2. Click on the Advanced Tab.
3. Click on the Environment Variables button at the bottom.
4. In the bottom section of the window (System Variables), scroll down to the bottom where TEMP and TMP are.
5. For both TEMP and TMP, left-click on the variable name, then click "Edit".
6. Change the variable value from "%SystemRoot%\TEMP" to "D:\netqos\temp".
7. Click ok, then repeat the procedure so both TEMP and TMP are set to the new directory.
8. Create the D:\netqos\temp directory if it does not already exist.
9. Restart the server.

NOTE: After the reboot, you can delete the C:\Windows\temp directory to free up disk space on C:\.

Another thing that can be done is to clean up the web service logs, if they are enabled, in C:\WINDOWS\system32\LogFiles\W3SVC1.
You can disable them by going into IIS manager and right click the Websites folder and select properties, and uncheck the Enable Logging box. Then reset IIS in cmd: iisreset.

NQ Disk Cleaner

-Deletes hidden folders in C:\windows. Typically these are backup files from Windows Updates containing files replaced by specific Windows OS patches.
-Runs Windows Disk Cleanup. It enables all options, including hidden options within the tool then runs the tool to delete files.

Options enabled:
 Recycle Bin
Content Indexer Cleaner
Downloaded Program Files
Internet Cache Files
Memory Dump Files
Microsoft Event Reporting
Offline Files
Offline Page Files
Old ChkDsk Files
Remote Desktop Cache Files
Setup Log Files
Temporary Files
Temporary Offline Files
WebClient and WebPublisher Cache
Active Setup temp folders
Compress old files

-Deletes IIS logs in c:\windows\system32\LogFiles\W3SVC\ or c:\winnt\system32\LogFiles\W3SVC\
-Empties the Recycle Bin