PowerHome Messageboard: Help! PH Hanging on PC startup

Active Topics

Memberlist

Help

PowerHome General
PowerHome Messageboard : PowerHome General

Topic: Help! PH Hanging on PC startup

Author

Message

<< Prev Topic | Next Topic >>

jeffw_00
Super User

Joined: June 30 2007
Online Status: Offline
Posts: 935

Posted: November 12 2009 at 20:28 \| IP Logged

Hi - I'm running the latest PH2 on a Dual-core 3GHz Windows PC running XP-SP3 with anti-virus, anti-malware, and no other issues.
-----------------
PROBLEM - 2 of the last 4 times my machine rebooted, Powerhome came "up" with a window "OBDC Configuration for Adaptive Server Anywhere". I hit CANCEL and got
ERROR: Database Connection Error 100, No data was found to satisfy the request.
(See both message windows at http://www.kwcpa.com/ph.pdf )

So - PH no longer comes up reliably at reboot. It looks like it can't find its database??

This is not good. anyone have any ideas what's going on?

Thanks!
/j

Edited by jeffw_00 - November 12 2009 at 20:32

BeachBum
Super User

Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880

Posted: November 13 2009 at 09:05 \| IP Logged

I would suspect a path problem. Did you install with the default directories? I assume you are running a 32 bit OS.

__________________
Pete - X10 Oldie

jeffw_00
Super User

Joined: June 30 2007
Online Status: Offline
Posts: 935

Posted: November 13 2009 at 09:52 \| IP Logged

Hi Beachbum - I guess I should appreciate that you post a reply to every one of my posts - makes me feel like part of the crowd, 8-} but I don't see this as on point - if the path was wrong it would be a hard problem, yes? WIN XP SP3 is a 32b O/S and I did a totally default installation.

Edited by jeffw_00 - November 13 2009 at 10:13

BeachBum
Super User

Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880

Posted: November 13 2009 at 10:02 \| IP Logged

Jeff, that is true unless the path is also registered in the registry and a program such as CCleaner is used and the entry is deleted for some reason. Just thinking out loud.

__________________
Pete - X10 Oldie

jeffw_00
Super User

Joined: June 30 2007
Online Status: Offline
Posts: 935

Posted: November 13 2009 at 10:12 \| IP Logged

Definitely thinking out loud, and I hope people scroll down far enough to see I still have a problem 8-}. I don't use any junky registry cleaners (i don't use any), and I still don't see how a path problem could be intermittent, or specifically where the path is specified that you suggest is the problem.

I know you mean well, but I'm really hoping someone with some understanding of OBDC might chime in as having seen something familiar before (while the thread is still on page 1 8-})
thanks anyway
/j

jpcurcio
Senior Member

Joined: April 01 2007
Location: United States
Online Status: Offline
Posts: 119

Posted: November 13 2009 at 10:18 \| IP Logged

I can't be sure, since it was a while ago, but this sounds
like something I used to get when I had a database
corruption.

Try using the database conversion/update utility on it;
I've had some luck in the past getting this to clear things
up.

jeffw_00
Super User

Joined: June 30 2007
Online Status: Offline
Posts: 935

Posted: November 13 2009 at 10:24 \| IP Logged

Thanks! - I'm not at my home computer - is the location/name of this utility obvious and/or is it in the doc?

ALSO - every time I make a change to my database I back it up in normal and exported form. Maybe i should try to clear it and re-import? Anyone familiar with how to do this? (I could go to the last backup but it may also be corrupt - i could go further back but I don't log my changes (though maybe I can diff the exported files...))

thanks!
/j

Edited by jeffw_00 - November 13 2009 at 10:25

grif091
Super User

Joined: March 26 2008
Location: United States
Online Status: Offline
Posts: 1357

Posted: November 13 2009 at 16:59 \| IP Logged

It would be very unusual for a PC to run every process and thread in exactly the same way for every reboot. Tasking is just not that predictable with multiple processes/threads running at the same time. Something that PH requires is probably not being established before PH gets to the point where it needs it. There have been other posts with similar problems. Seems like they were related to running PH as a service but not sure about that fact.

__________________
Lee G

jeffw_00
Super User

Joined: June 30 2007
Online Status: Offline
Posts: 935

Posted: November 13 2009 at 17:03 \| IP Logged

well, starting back in July, I started delaying PH startup for 20 seconds at boot to make sure the USB drivers are loaded - but that should also give any service plenty of time to start. I'm going to see how far I can rollback the database and see if it goes away.
/j

jeffw_00
Super User

Joined: June 30 2007
Online Status: Offline
Posts: 935

Posted: November 14 2009 at 13:21 \| IP Logged

Ok - I reverted the database, I had a current backup that pre-dated the problems.

I also wrote a perl script for initializing powerhome at boot time. I added lines to my powerhome initialization macro to write a timestamp to a file. The perl script tries 3 times to start powerhome, checking the timestamp to see if it succeeded. If not, reboot the PC and try 3 more times - then give up. Hopefully this will improve reliability. If anyone wants the script let me know.

jpcurcio
Senior Member

Joined: April 01 2007
Location: United States
Online Status: Offline
Posts: 119

Posted: November 15 2009 at 21:26 \| IP Logged

jeffw_00 wrote:

Sorry, I was at work as well, and I've been incommunicado for a few. The utility is phupg.exe; it should be located in the PowerHome installation directory.

jeffw_00
Super User

Joined: June 30 2007
Online Status: Offline
Posts: 935

Posted: November 16 2009 at 10:10 \| IP Logged

so if I run phupg.exe - will it prompt me or just do something - (if so,what?)
thanks!
/j

grif091
Super User

Joined: March 26 2008
Location: United States
Online Status: Offline
Posts: 1357

Posted: November 16 2009 at 10:42 \| IP Logged

It prompts. I have used it reduce the size of 2.1b DB after trimming the size. Was 2.1b to 2.1b.

__________________
Lee G

dhoward
Admin Group

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447

Posted: November 16 2009 at 15:14 \| IP Logged

Jeff,

Definately try the phupg.exe Database Upgrade Utility. What I would do is go back to your original DB file that was having problems (assuming it will start at all in PowerHome) and trim the event log to a reasonable size (say a month or less...I do two days) using ph_trimeventlog or ph_exporteventlog. Then exit PowerHome and run the phupg.exe utility and rebuild the database. This should keep all of your data but clean up any corruption that may exist.

Dave.

jeffw_00
Super User

Joined: June 30 2007
Online Status: Offline
Posts: 935

Posted: November 16 2009 at 16:00 \| IP Logged

Hi Dave - I typically run the event log at 2 weeks. As it turned out, once someone suggested it was a database issue I looked and found that I had a backup (I make a backup whenever I change anything), that predated the problems by a week, so exited PH, copied the old database in as the current one, restarted PH, and all seems to be well. However, at the next sign of trouble I will do exactly as you suggest. Thanks very much!
/j

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

Printable version

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum