| Author |
|
renard
Groupie
Joined: November 01 2009
Location: United States
Online Status: Offline
Posts: 72
|
| Posted: October 21 2015 at 22:05 | IP Logged
|
|
|
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 |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: October 21 2015 at 22:13 | IP Logged
|
|
|
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 |
|
| |
renard
Groupie
Joined: November 01 2009
Location: United States
Online Status: Offline
Posts: 72
|
| Posted: October 22 2015 at 20:57 | IP Logged
|
|
|
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 |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: October 22 2015 at 21:26 | IP Logged
|
|
|
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 |
|
| |
renard
Groupie
Joined: November 01 2009
Location: United States
Online Status: Offline
Posts: 72
|
| Posted: October 25 2015 at 21:45 | IP Logged
|
|
|
That worked.
Thanks Dave,
__________________
Terry
|
| Back to Top |
|
| |
jeffw_00
Super User
Joined: June 30 2007
Online Status: Offline
Posts: 929
|
| Posted: August 12 2019 at 15:46 | IP Logged
|
|
|
it is mentioned here:
open powerhome help -> contents -> index -> ph_backupdb
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome General
Topic: Further Adventures with 64-bit Win-7
