PlanetPress Database stops reading remote file

Posted by: Tom@ECI

PlanetPress Database stops reading remote file - 02/25/13 12:09 PM

I have a process that uses PlanetPress Database ODBC connection to a foxpro .dbf file that is located in a shared folder on another machine.

this is the connection string: DSN=PlanetPress;UID=;PWD=;SourceDB=\\10.0.0.2\DDMS\W1;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;
then:
SELECT * FROM af-master.dbf WHERE af_Status <> 'S'

The problem is when the 10.0.0.2 is rebooted, PlanetPress can't access the AF-MASTER.DBF until we reboot PlanetPress machine.

Both machines are running Win2008 Server. They are on a workgroup, not domains.

Here's what I've extracted from the logs:
------------------------------------------------------------------------
LAST SUCESSFULLY SENT E-MAIL THROUGH AF-MASTER PROCESS
------------------------------------------------------------------------
WPROC: AF-Master - 17:30:40
Blah
blah
WPROC: AF-Master complete - 17:30:56
------------------------------------------------------------------------
THIS IS WHERE IT WAS HANDED OFF TO PPIMAGE
------------------------------------------------------------------------
REQST: PPImage Request - 17:30:58
INFO: Processing file C:\ProgramData\Objectif Lune\PlanetPress Suite 7\PlanetPress Image\QueuedJobs\5C8C44B.ps
DEBUG: Reading job options from input file
DEBUG: Watch Process Name : AF-Master
INFO: Starting conversion...
INFO: Initializing PlanetPress Alambic...
INFO: Distilling file to 576840-0.pdf...
INFO: Conversion completed successfully.
INFO: Starting SMTP email....
INFO: Sent to: XXXXXXXXXXXXXXX
INFO: SMTP mail sent successfully.
INFO: Process completed successfully.
REQST: End time: 17:30:59
DEBUG: Adding job to queue: C:\ProgramData\Objectif Lune\PlanetPress Suite 7\PlanetPress Image\QueuedJobs\5E3CA52.ps
------------------------------------------------------------------------
PPWATCH GOES BACK TO *NORMAL* MONITORING OF THE AF-MASTER.DBF
------------------------------------------------------------------------
WPROC: AF-Master - 20:00:12
INFO : File created : C:\ProgramData\Objectif Lune\PlanetPress Suite 7\PlanetPress Watch\Spool\12.tmp\job00ZKLPKR32I3L376516587.dat, size: 25 bytes
INFO : Plugin Create File completed successfully - 20:00:12
INFO : File processed : job00ZKLPKR32I3L376516587.dat, size: 311 bytes
INFO : Plugin PlanetPress Database completed successfully - 20:00:12
INFO : Splitting 1 records and/or 1 pages per split
INFO : No pieces left.
INFO : Plugin Database Splitter completed successfully - 20:00:12
WPROC: AF-Master complete - 20:00:12
------------------------------------------------------------------------
------------------------------------------------------------------------
SERVER REBOOTS FOR DAYEND AT 8PM....CAUSING “AF-MASTER.DBF DOES NOT EXIST” MESSAGE FOR THE NEXT 4 MINUTES.
------------------------------------------------------------------------
------------------------------------------------------------------------
WPROC: AF-Master - 20:00:22
INFO : File created : C:\ProgramData\Objectif Lune\PlanetPress Suite 7\PlanetPress Watch\Spool\12.tmp\job00ZKLPKSQVJSC616518CB6.dat, size: 25 bytes
INFO : Plugin Create File completed successfully - 20:00:22
ERROR: W3612 : Error running SQL: [Microsoft][ODBC Visual FoxPro Driver]File 'af-master.dbf' does not exist
ERROR: PlanetPress Database: W1603 : Plugin failed - 20:00:22
ERROR: W3001 : Error while executing plugin: W3835: The emulation is not database
ERROR: Database Splitter: W1603 : Plugin failed - 20:00:22
INFO : File processed : job00ZKLPKSQVJSC616518CB6.dat, size: 25 bytes
INFO : Plugin Change Emulation completed successfully - 20:00:22
INFO : JobInfo/Variable %{FxFileName} is set to ""
INFO : JobInfo/Variable %{Af_Status} is set to ""
INFO : JobInfo/Variable %{af_Type} is set to ""
INFO : JobInfo/Variable %{af_Comment} is set to ""
INFO : JobInfo/Variable %{Af_FaxNumber} is set to ""
INFO : JobInfo/Variable %{af_Subject} is set to ""
INFO : JobInfo/Variable %{af_ToAddress} is set to ""
INFO : Plugin Set Job Infos and Variables completed successfully - 20:00:22
INFO : is equal to : false
INFO : Condition result is false
INFO : Plugin Text Condition completed successfully - 20:00:22
INFO : Deleting file : job00ZKLPKSQVJSC616518CB6.dat, size: 25 bytes
INFO : Plugin Delete completed successfully - 20:00:22
WPROC: AF-Master complete - 20:00:22
------------------------------------------------------------------------
------------------------------------------------------------------------
SERVER IS NOW BACK UP...”AF-MASTER.DBF..” ERROR GOES AWAY. LOG LOOKS *NORMAL* AGAIN
------------------------------------------------------------------------
------------------------------------------------------------------------
WPROC: AF-Master - 20:04:15
INFO : File created : C:\ProgramData\Objectif Lune\PlanetPress Suite 7\PlanetPress Watch\Spool\12.tmp\job00ZKLPLVATFK3AA6551B6B.dat, size: 25 bytes
INFO : Plugin Create File completed successfully - 20:04:15
INFO : File processed : job00ZKLPLVATFK3AA6551B6B.dat, size: 311 bytes
INFO : Plugin PlanetPress Database completed successfully - 20:04:15
INFO : Splitting 1 records and/or 1 pages per split
INFO : No pieces left.
INFO : Plugin Database Splitter completed successfully - 20:04:15
WPROC: AF-Master complete - 20:04:15
------------------------------------------------------------------------
------------------------------------------------------------------------
AF-MASTER PROCESS CONTINUES RUNNING W/OUT ERRORS BUT IS NOT READING THE QUOTE SUBMITED AT 21:10.
------------------------------------------------------------------------
------------------------------------------------------------------------
WPROC: AF-Master - 21:10:04
INFO : File created : C:\ProgramData\Objectif Lune\PlanetPress Suite 7\PlanetPress Watch\Spool\12.tmp\job00ZKLQ40FSVC3C16915F46.dat, size: 25 bytes
INFO : Plugin Create File completed successfully - 21:10:04
INFO : File processed : job00ZKLQ40FSVC3C16915F46.dat, size: 311 bytes
INFO : Plugin PlanetPress Database completed successfully - 21:10:04
INFO : Splitting 1 records and/or 1 pages per split
INFO : No pieces left.
INFO : Plugin Database Splitter completed successfully - 21:10:04
WPROC: AF-Master complete - 21:10:04
------------------------------------------------------------------------
PLANETPRESS DOES NOT PROCESS THE JOBS QUEUED IN AF-MASTER UNTIL WE REBOOT THE PLANETPRESS MACHINE (OR RESTART PLANETPRESS).
Posted by: Anonymous

Re: PlanetPress Database stops reading remote file - 02/25/13 02:31 PM

Hi Tom,

It is possible you need to get the following fox pro provider for your windows machines. It has been known to be missing in Windows 7 so it might be the case with Server2008 too. This helped a few of our customers get back on track with their connexions to dbf files. Please see if this helps you too:

FoxPro requirement
Posted by: Anonymous

Re: PlanetPress Database stops reading remote file - 02/25/13 02:33 PM

Please try the msi file from the link above
Posted by: Tom@ECI

Re: PlanetPress Database stops reading remote file - 02/25/13 03:33 PM

we'll try the newer driver.
Thanks.
Posted by: Tom@ECI

Re: PlanetPress Database stops reading remote file - 02/26/13 10:52 AM

Update...I installed the new driver last night. After the other server rebooted, we still could not access the AF-MASTER.DBF until rebooting the PlanetPress machine.
PPW log from today shows the shutdown at 1:30am (scheduled reboot).
Then startup at 1:33am. The e-mail we queued up at 21:06 then ran through PPW and e-mailed out.