WebTrends db Error...

Oh-Oh....

[mmiller]

I seem to have a MySQL error in my Webtrends 7.1 installation and it's worrying me....

I keep seeing red stop signs in event viewer;

Event ID: 100

WTMySQLService: Can't open file: 'wt_componentstatus.MYI'. (errno: 145)

I've verified that the file exists and that it can be read & written to by everyone.

Does anyone know if there is a way to repair this problem?

[cgrantski]

you could try a general mysql repair to your main db files: (these are lifted from WT KB articles)

mysqlcheck.exe -r --databases wt_sched -u Administrator -p

mysqlcheck.exe -r --databases wtmaster -u Administrator -p

where "Administrator" is your mysql username of course

also this:

mysql –u Administrator –p
use wtmaster
repair table wt_servicestatus:
exit

These are done from the mysql/bin folder

afterwards restart the mysql and scheduler services

[mmiller]

Good work cgrantski - you saved my bacon!

I never thought about the KB (even though it's usually my first choice) but I looked up the article you dug up and enter the command as written.

It found one error but my problem persisted. I then ran the graphical MySQL interface and found another db - this one containing the table the error was coming from. It was the scheduler table so I modified the command for that db and it cleared out the problem. I re-booted and all is well.

That was a close one - thank you very much!

While I've got you here can I ask one more question? I don't know how to backup my data at all. I took a look at the backup section of the WT admin but it looks quite useless (very primitive).

Specifically, is there any way I can back up all the changes I've made to the program and my profiles as well so that if I had to re-install I could just worry about my logfile data and not all the configuration settings? That would be really, really great and put my mind at ease because as I learn this program I've butchered it several times. I've got a lot of time into it now though and don't want to loose any of my configuration settings.

Thanks again;
Marvin

[cgrantski]

Sure. I do that all the time (too often). What version are you using?

For recent versions like 6 and 7 the important stuff is in /storage/config/wtm _ wtx/datfiles .... I'm doing that from memory so just look for a /datfiles folder if I don't have it quite right. That's where most of the good stuff is. If you haven't prowled around in /datfiles, you should. It's an eye-opener.

You should be storing your translation files in a folder in there also, for convenience of this kind of backup (I'm referring to translation files for parameter analysis, if you use them).

In fact, go up one level and save the /wtm _ wtx folder because the wtm _ wtx.ini file may have some settings in it you'll want to keep.

Some things aren't savable. Your data sources (location of your logs) are embedded in the reporting databases because the reporting databases keep track of the last logfile line analyzed, etc. Your scheduler settings also aren't in there and I don't think they can be saved.

If you have changed the images in the reports, they are stored somewhere else. Same for any changes you may have hacked, er made, in the wording of the reports. If you haven't done either of these don't worry about them.

I always keep a copy of the wtm _ wtx folder that contains /datfiles somewhere else. You're right. Once you have WT customized just right and humming, you never want to go through that fine tuning and report building again! I've saved the day by just blowing away the original installation, reinstalling and dropping in the datfiles folder plus the wtm _ wtx.ini file. It even works for moving from one machine to another (same version of the program, usually). It also sorta works for a kludgy upgrade, but not, repeat NOT, for 7.1 to 7.5.

I hope that answers your question!

[mmiller]

Thanks cgrantski - that does answer my questions and it's going to save me a lot of time when I have to wipe it & install it.

I took a look around the directory you mentioned and found easily editable .ini files :-) You never know, it may find some new functionality in there somewhere. I'm running 7.1b btw and it seems to work pretty good. It's a bit of resource hog but I've been tuning it up and I figure I can trim it down a bit once I'm more familiar with it.

By any chance have you had occassion to use the Post-Processing feature? Try as I might I can't get it to do much of anything :-)

[cgrantski]

I haven't used post processing since the WT versions that outputted to a static series of web pages - I used it to change text and labels. These days I guess it's mainly for moving logs and such when done and I wouldn't know how to do that. I don't think I've ever even seen anything written up on it. It would be nice if WT wrote a document aimed just at log management.

[cgrantski]

Regarding the ini files - there's a WT document, I think the big Advanced Configuration Guide, that explains some or most of the lines in those files in one of the chapters or appendices. Check it out.

One piece of advice for messing with those --- never change the GUIDS (the long nonsense strings). Don't even do it temporarily thinking you back revert.

[matthewharper]

I think I might have a similar problem and would appreciate very much if anyone might be able ot help me out.
------------------

I am using WebTrends 7.0c

Today is August 12 and a profile has been stuck in Analysis mode since July 26. Under Analysis Status under Profiles it reads "Processing on Server".

Under Event Queue it says there are no Tasks currently running.

I have 5 - 8 profiles Queued for processing which I cannot seem to cancel in the Scheduled Events section.

Any ideas how I can release the stuck profile?

Thank you,
M

[cgrantski]

Have you restarted the Scheduler Service? Rebooted the server? If so and it's still stuck, something is probably corrupted. WebTrends tech support has a list of things to try, so contact them. They'll probably suggest you upgrade to at least 7.1b which was pretty stable in the Scheduler area.

[matthewharper]

I have restarted services run mysqlcheck and the other tips you gave. Any others you can think of?

suggest you upgrade to at least 7.1b which was pretty stable in the Scheduler area.

>>am i wrong to think 7.1c would come after 7.1b?

[cgrantski]

Oops sorry you said 7.1 and I assumed.

If you rebooted (not just restart services) after doing those sql repairs, I can only offer the following, sent to me by WT. By the end of this, my situation was fixed.

1. Stop and restart all the webtrends services and try again.
2. Delete lock files:
Cancel any events from the UI.
Navigate to <WebTrends>\modules\analysis directory and delete any .LOCK files.
Restart the WebTrends - Scheduler Agent service.
3. Perform the steps located here: [netiq.com...]
4. Is the agent.conf in modules\agent blank? Run repair on install by downloading at ftp://ftp.webtrends.com/wrc/70d
5. Perform the steps below:
1. Within a command prompt access the installation directory and go to
.\common\database\mysql\bin
2. Access the database by typing:
mysql -u<username> -p<password> (this is the username/password to connect to the database not the UI)
3. Once you're in use the following command:
use wt_sched
Truncate TABLE wt_taskqueue;
4. Type "exit" to get out of the MySQL prompt.
5. Restart the "WebTrends - MySQL" and "WebTrends - Scheduler Agent" services.
6. Try to analyze your profile.
7. Other:
---Do you have anti-virus software? Run repair on install by downloading at ftp://ftp.webtrends.com/wrc/70d

[matthewharper]

3. Once you're in use the following command:
use wt_sched
Truncate TABLE wt_taskqueue;
4. Type "exit" to get out of the MySQL prompt.
5. Restart the "WebTrends - MySQL" and "WebTrends - Scheduler Agent" services.

----
i am in mysql in Dos prompt and I then typed "wt_sched" (hit enter)
then typed "Truncate TABLE wt_taskqueue;" (hit enter)

and i receive the error: ERROR1064: You have an eror in your SQL syntax. Check the manual that corresponds to you MySQL server ersion for the right syntax to use near 'wt_sched

does the "Truncate" line need to be on the same line as "wt_sched"?

thank you,
M

[matthewharper]

by the way my agent.conf is blank

[mattglet]

Chris-
You're a life saver man... you need to be paid more.

Matthew-
Do you have a agent.bak file in there? If so, get rid of the blank agent.conf file, and rename the bak file to "agent.conf". If you open that file in notepad, you *should* have your settings. Just restart the Scheduler Agent, and it'll be back and running.

I'm not sure if that will work for you, but I was literally 10 minutes away from reinstalling WebTrends until I just happened to take a look in this forum to see if by chance there are any updates.

THANKS AGAIN CHRIS!

[cgrantski]

I'm showing these to my boss.

[matthewharper]

After all said is done. I ended up grabbing 07.d from the FTP site ftp://ftp.webtrends.com/wrc/70d

Thank you for your insightful cgrantski!

-Matt