Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: Further Adventures with 64-bit Win-7 Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
renard
Groupie
Groupie
Avatar

Joined: November 01 2009
Location: United States
Online Status: Offline
Posts: 56
Posted: October 21 2015 at 22:05 | IP Logged Quote renard

I have encountered another problem with my Win7/64 implementation of PH 2.1.5d.

I have a timed event that runs at 0000 (midnight)- trimming the log and do some other hygiene stuff. One of these is making a backup copy of the PH database using a formula:

ph_backupdb ("d:\Powerhome\DB-Backup\ph-Backup.db",1)

These tasks quietly ran every night under Win7/32 but now fails with a message box "Unable to Open Backup Log c:\windows\sysWOW64\backup.syb

Interestingly, PH correctly generates what appears to generate an appropriate backup database in the designated location and PH then promptly goes into a coma, still running(?) but completely dead, not even acknowledging messages from the PLM.

I looked to see if I have the mentioned program file in the sysWOW64 folder (the 32-bit execution environment for 64-bit Windows and I have no such file. Given the type is .syb suggesting it is a Sybase file, not having the file would appear to be the problem.

I can run the formula manually and get the backup database but then I need to restart PH.

Thanks for any ideas.



__________________
Terry
Back to Top View renard's Profile Search for other posts by renard
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4271
Posted: October 21 2015 at 22:13 | IP Logged Quote dhoward

Terry,

Check the Help file for ph_backupdb. Look at the Notes
section where the environment variable SALOGDIR is
discussed.

Hope this helps,

Dave.
Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
renard
Groupie
Groupie
Avatar

Joined: November 01 2009
Location: United States
Online Status: Offline
Posts: 56
Posted: October 22 2015 at 20:57 | IP Logged Quote renard

Thanks Dave,

I looked in ph-help.pdf and there is no Notes section for the function ph_backupdb and the string SALOGDIR does not appear anywhere in the file. Are you referring to another help file?

__________________
Terry
Back to Top View renard's Profile Search for other posts by renard
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4271
Posted: October 22 2015 at 21:26 | IP Logged Quote dhoward

Terry,

Thats strange. You're on the latest version of
PowerHome so should have the latest help file. I just
checked my version and it shows in both the help file
(Help->Contents) and the PDF.

Anyways, take a look at the online help file here:
http://www.power-home.com/Web%20Help/index.htm

It says the following:

Notes
In order for this function to execute, the SALOGDIR
environment variable must be defined on the machine
that PowerHome is running on. This environment
variable should be set to a directory where the
BACKUP.SYB temporary file that this function creates
can reside.

Basically you just need to define an environment
variable named SALOGDIR and set it to point to a
directory that PowerHome has access to. If you've
installed PowerHome to the proper location of
c:\powerhome, you can just set the variable to the
same and the errors should go away. Another option
would be to set the variable to the same location that
you're making your backups too.

Let me know how it goes.

Dave.
Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
renard
Groupie
Groupie
Avatar

Joined: November 01 2009
Location: United States
Online Status: Offline
Posts: 56
Posted: October 25 2015 at 21:45 | IP Logged Quote renard

That worked.

Thanks Dave,

__________________
Terry
Back to Top View renard's Profile Search for other posts by renard
 
jeffw_00
Super User
Super User


Joined: June 30 2007
Online Status: Offline
Posts: 792
Posted: August 12 2019 at 15:46 | IP Logged Quote jeffw_00

it is mentioned here:

open powerhome help -> contents -> index -> ph_backupdb
Back to Top View jeffw_00's Profile Search for other posts by jeffw_00
 

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

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
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