| Author |
|
UpstateMike
Senior Member
Joined: February 18 2006
Location: United States
Online Status: Offline
Posts: 142
|
| Posted: August 25 2006 at 00:49 | IP Logged
|
|
|
Whenever I try to view the event log it locks up PowerHome and I have to kill the program and restart. Any idea what I'm doing wrong? This is not new; I don't remember ever being able to view it.
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: August 29 2006 at 22:17 | IP Logged
|
|
|
Mike,
Most likely your eventlog is so huge, it's taking PowerHome a long time to open and appearing to be hung.
It sounds as if you're probably not doing any regular trimming of the eventlog (my fault, since it's not clearly explained) and are probably due. PowerHome provides a couple of functions to help in this respect. ph_trimeventlog and ph_exporteventlog. Both of these functions will allow you two keep your eventlog to a manageable level (usually from 2 to 7 days worth). The best way to set this up is with a timed event that runs a second or two after midnight everyday.
Once you've trimmed your eventlog, you may want to use the DB Upgrade Utility to reduce the database filesize. You can see how big the file is by looking at pwrhome.db in c:\program files\powerhome\database. If it's over 10 meg, you'll probably want to use the util to rebuild (and at the same time compact) your database.
After this, you should be able to view the eventlog.
Dave.
|
| Back to Top |
|
| |
UpstateMike
Senior Member
Joined: February 18 2006
Location: United States
Online Status: Offline
Posts: 142
|
| Posted: August 29 2006 at 23:42 | IP Logged
|
|
|
It's 190 meg. If I just delete it and restart PH will it create a fresh one?
How about setting up these functions by default in the next version? Then if people want to they can edit the default to customize it but at least it would prevent any problems while folks are still getting familiar with the program.
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: August 29 2006 at 23:53 | IP Logged
|
|
|
Mike,
Whatever you do, don't delete the pwrhome.db file. This is where all your Insteon links, devices, etc. are stored. This single database file (as well as the pwrhome.ini) stores all of your custom PowerHome configuration.
Im working on a special timing object so that things like trimming the eventlog, backing up the database, etc. (system related events) can be done without having to resort to timed events. However, it won't be ready by the next version. What I could probably do though is just have the database preconfigured for a timed event with the ph_trimeventlog function already in there.
Dave.
|
| Back to Top |
|
| |
UpstateMike
Senior Member
Joined: February 18 2006
Location: United States
Online Status: Offline
Posts: 142
|
| Posted: August 30 2006 at 00:57 | IP Logged
|
|
|
A preconfigured timed event should be fine for now. Meantime I better read up on the ph_trimeventlog function.
|
| Back to Top |
|
| |
UpstateMike
Senior Member
Joined: February 18 2006
Location: United States
Online Status: Offline
Posts: 142
|
| Posted: August 30 2006 at 08:45 | IP Logged
|
|
|
Tried running ph_trimeventlog but it locked everything up. I crashed PH and ran DB upgrade and it created a new copy of the database bigger than the old one. Tried to restart PH and it just hangs with an hourglass after I tell it to restart timed events but skip running old events during startup.
What now? Crash PH again and see if I can get it to start?
|
| Back to Top |
|
| |
TonyNo
Moderator Group
Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
|
| Posted: August 30 2006 at 13:48 | IP Logged
|
|
|
Strange! I would say to delete the newer, bigger db, rename the backup db (created when phug runs), and try again.
If your db was 190M it will take a while to trim. Did you let it chug for a bit?
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: August 30 2006 at 14:40 | IP Logged
|
|
|
Mike,
Give Tony's suggestion a try. With an eventlog as large as yours, it would have taken awhile to trim. It's possible that your database is now corrupt since PowerHome was shutdown in the middle of the trim operation however.
Let me know how it goes. If we cant get it back working, we'll have to figure out a way to get me a copy of the DB so I can repair it for you.
Dave.
|
| Back to Top |
|
| |
UpstateMike
Senior Member
Joined: February 18 2006
Location: United States
Online Status: Offline
Posts: 142
|
| Posted: August 30 2006 at 16:10 | IP Logged
|
|
|
OK I crashed everything, rebooted the computer, renamed the files so I am using the original one again, and restarted PH.
I created a formula called Trimlog that contains the function ph_trimeventlog (2)
So if I right click on this and select play, what is going to happen? Will I see a message or a progrss bar? Will it just give me an hourglass? Will everything just kind of freeze up till its done?
How long do I wait till I assume it is stuck? 5 min? 20 min? An hour?
Is there a better way to kick this off?
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: August 30 2006 at 17:10 | IP Logged
|
|
|
Mike,
Your plan sounds good...I would just make sure that you've saved a good working copy of the DB (even if it is 190 meg  ).
No progress bar or message will appear. If you'd like a message, then I would create a macro with a couple of lines that look like this:
10 Formula, Immediate, ph_trimeventlog(2)
20 Message Box, No TTS, OK,"Eventlog trimming complete."
I would then right-click and run this instead. You'll get the message when it's done as well as be able to see if it's done from the PowerHome Status screen (assuming that you can even open the status screen if it doesnt bog the system too much).
It may take awhile, but I would think that it should be less than 20 minutes. What is essentially happening is a single SQL statement is being sent to the Adaptive Server Anywhere database server to delete frow from the eventlog table beyond a certain time/date stamp.
Dave.
|
| Back to Top |
|
| |
UpstateMike
Senior Member
Joined: February 18 2006
Location: United States
Online Status: Offline
Posts: 142
|
| Posted: August 30 2006 at 20:57 | IP Logged
|
|
|
I think I'm OK. File size went up to 318 meg then back down to 1.5 meg and now the event log opens. Thanks to both Dave and Tony!
|
| Back to Top |
|
| |
TonyNo
Moderator Group
Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
|
| Posted: August 30 2006 at 22:30 | IP Logged
|
|
|
Yay! 
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome Bug Reports
Topic: Can’t View Event Log
