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