IMPORTANT ANNOUNCEMENT

These forums will be permanently set to read-only mode on July 18, 2022. From that day on, no new posting or comment will be allowed on the site, but the historical content will remain intact and searchable.

Upland Objectif Lune is currently working on upgrading the forum infrastructure. Please check back here regularly for updated information.

Topic Options
#42460 - 02/25/13 12:09 PM PlanetPress Database stops reading remote file
Tom@ECI Offline
OL Newbie

Registered: 04/20/10
Posts: 24
Loc: Fort Worth, Tx
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).

Top
#42472 - 02/25/13 02:31 PM Re: PlanetPress Database stops reading remote file [Re: Tom@ECI]
Olivier J
Unregistered


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

Top
#42473 - 02/25/13 02:33 PM Re: PlanetPress Database stops reading remote file [Re: Tom@ECI]
Olivier J
Unregistered


Please try the msi file from the link above

Top
#42480 - 02/25/13 03:33 PM Re: PlanetPress Database stops reading remote file [Re: Tom@ECI]
Tom@ECI Offline
OL Newbie

Registered: 04/20/10
Posts: 24
Loc: Fort Worth, Tx
we'll try the newer driver.
Thanks.

Top
#42487 - 02/26/13 10:52 AM Re: PlanetPress Database stops reading remote file [Re: Tom@ECI]
Tom@ECI Offline
OL Newbie

Registered: 04/20/10
Posts: 24
Loc: Fort Worth, Tx
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.

Top