filePro losing odbc connection

[Richard Hane]

Rich,

It is called by a shortcut on the desktop of the workstation.

Here is the beginning of the batch file:
rem this process unlocks fp files accessed during odbc update
set PFDSK=V
set PFPROG=V:
set PFDATA=V:
set PFDIR=
set PFCMARK=20
set PFLMHOST=server2007
cd fp
dprodir ctrl -l
dprodir psch -l
dprodir wofile -l
dprodir wotopull -l
dprodir mrpinv -ka
dprodir mrpinv -l
dprodir psch -l
dprodir mrppo -l
dprodir dprod -l
dprodir womrp -l
dprodir salesorder -l
dprodir prchk -l
dprodir bomc -l
dprodir bom -l
dprodir convert -l
rreport ctrl -f getstart -a -u -h "\r Wake Up DSN Line-047 \r"
dprodir pops -ka
rreport ctrl -f getoper -s one -u -h "\r Get WO Sequenses Line-048 \r"
dprodir pops -l
rreport pops -f recalc -a -u -h "\r Setting Up Routing Data  Line-049 \r"
rreport pops -f setwc -s active -u -h "\r Set Work Center Names Line-050 \r"
rreport pops -f set14n -a -u -h "\r Set fld 14n Line-051 \r"
dprodir wofile -l
rreport wofile -f nxtop -s nxtop -u -h "\r Set next Work order Op Line-052 \r"

Thanks
Rick Hane


 


On Monday, January 19, 2015 9:21 AM, Richard Kreiss <rkreiss at verizon.net> wrote:
  


Top post:

How is the batch file started?

Richard
Sent from my iPhone


> On Jan 19, 2015, at 10:17 AM, Richard Hane <yoresoft at sbcglobal.net> wrote:
> 
> Our system...  filePro ODBC 5.0.15 (16 user) running on a workstation (Windows 7).  We are calling a batch file on a mapped drive to a server running Windows 2003 R2 (32 bit).  
> 
> The batch file runs  approx. 40 processes.  9 of these processed are reading data from our MRP SQL database and writing the data to our filePro files. We run this process file every morning.  The batch file takes about 30 minutes to complete.
> 
> Our problem is that occasionally we seem to loose the odbc connection.  If it makes any difference the SQL database is on another server of the same configuration as the server listed above.
> 
> This morning we received the error listed below after about 70% of the batch file was done.
> 
> Our question...  Can someone give some reasons or causes of this odbc connection failing? 
> 
> Windows error:
> report.exe has stopped working
> Problem Event Name: APPCRASH
> Application Name: report.exe
> Application version: 0.0.0.0
> Application timestamp: 45818b94
> Fault Module Name: report.exe
> Fault Module version: 0.0.0.0
> Fault Module timestamp: 45818b94
> Exception code: c0000005
> Exception offset: 0002235e
> O/S version: 6.1.7601.2.1.0.256.48
> Location ID: 1033
> 
> Thank you in advance
> Rick Hane
> Controller
> Deluxe Stitcher Company Inc
> Retiring 01/22/2015
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20150119/de35a86e/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20150119/919375e8/attachment.html>