How do I troubleshoot events that do not enter the queue?
Affected Environments:
Webtrends Analytics 8.0
Webtrends Enterprise 7.x
Webtrends Professional 7.x
Webtrends Small Business 7.x
Solution:
Step 1 - Make sure the Scheduler is enabled.
- Log in to the Webtrends Administration console.
- Click Administration > System Management > Hosts.
- Click the blue link that reads "Scheduler".
- If this is a stand-alone install or a distributed install master running the scheduler, make sure that both "Enable the Scheduler on this host " and "Enable the Scheduler agent on this host" are checked.
If this is a distributed install analysis node, make sure that only the "Enable the Scheduler agent on this host" is checked.
Step 2 - Restarting all Services:
- Stop all Webtrends services.
- Start all Webtrends services
- Try analyzing a profile.
Step 3 - Deleting .lock files:
- Cancel all events from the UI.
- Navigate to <Webtrends>\modules\analysis directory
- Remove any file with .LOCK extension.
- Restart the Webtrends - Scheduler Agent service.
- Try analyzing a profile.
Step 4 - Agent.conf possible corruption:
- Navigate to <Webtrends>\modules\agent
- Verify that there is data in the agent.conf file by opening with Notepad.
- If agent.conf does not contain any data, locate the file agent.bak. Delete the existing BLANK agent.conf file. Rename the file agent.bak to agent.conf
- Try analyzing a profile.
Step 5 - Repairing Database:
- Perform the steps - How do I repair damaged MySQL databases?
- Try analyzing a profile.
Step 6 - Truncate Scheduler Database:
1. Open a command prompt
2. Within the command prompt navigate to:
<Webtrends>\common\database\mysql\bin
3. Access the database by typing:
mysql -u <username> -p <select the enter key> You're prompted for password and once typed, hit <Enter> (this is the login to connect to MySQL, not the UI)
4. Once you're in use the following command:
use wt_sched
Truncate TABLE wt_taskqueue;
5. You will see a message: "0 records affected".
6. Type "exit" to get out of the MySQL prompt.
7. Restart the "Webtrends - MySQL" and "Webtrends - Scheduler Agent" services.
8. Try analyzing a profile.
Step 7 - Clear the WT_Environment table in the wt_sched database
1. Open a command prompt
2. Within the command prompt navigate to:
<Webtrends>\common\database\mysql\bin
3. Access the database by typing:
mysql -u <username> -p <select the enter key> You're prompted for password and once typed, hit <Enter> (this is the login to connect to MySQL, not the UI)
4. Once you're in use the following command:
use wt_sched
delete from WT_Environment;
5. You will see a message: "Query OK, 2 rows affected".
6. Type "exit" to get out of the MySQL prompt.
7. Restart the "Webtrends - MySQL" and "Webtrends - Scheduler Agent" services.
8. Try analyzing a profile.
Preventative Measures:
Do you have any anti-virus software running?
- If so, either disable OR configure the anti-virus to exclude the Webtrends directory from being scanned.
Is the "Indexing Service" enabled on the computer where Webtrends is installed?
- If so we will need to disable the service.
Make sure that no other applications are installed/running on the WebTrends machine. Any other processes running on the same machine will require WebTrends to compete for resources which will end up slowing the analysis process and could lead to database corruption.