<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div><span>Rich,</span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span>It is called by a shortcut on the desktop of the workstation.</span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue,
Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span>Here is the beginning of the batch file:</span></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><span>rem this process unlocks fp files accessed during odbc update<br>set PFDSK=V<br>set PFPROG=V:<br>set PFDATA=V:<br>set PFDIR=<br>set PFCMARK=20<br>set PFLMHOST=server2007<br>cd fp<br>dprodir ctrl -l<br>dprodir psch -l<br>dprodir wofile -l<br>dprodir wotopull -l<br>dprodir mrpinv -ka<br>dprodir mrpinv -l<br>dprodir psch -l<br>dprodir mrppo -l<br>dprodir dprod -l<br>dprodir womrp -l<br>dprodir salesorder -l<br>dprodir prchk -l<br>dprodir bomc -l<br>dprodir bom -l<br>dprodir convert -l<br>rreport ctrl -f getstart -a -u -h "\r Wake Up DSN Line-047 \r"<br>dprodir pops -ka<br>rreport ctrl -f
getoper -s one -u -h "\r Get WO Sequenses Line-048 \r"<br>dprodir pops -l<br>rreport pops -f recalc -a -u -h "\r Setting Up Routing Data Line-049 \r"<br>rreport pops -f setwc -s active -u -h "\r Set Work Center Names Line-050 \r"<br>rreport pops -f set14n -a -u -h "\r Set fld 14n Line-051 \r"<br>dprodir wofile -l<br>rreport wofile -f nxtop -s nxtop -u -h "\r Set next Work order Op Line-052 \r"</span></div><div><br></div><div>Thanks</div><div>Rick Hane</div><div><br></div><span><div><br></div><div style="color: rgb(0, 0, 0); font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px; font-style: normal; background-color: transparent;"><br></div></span> <div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div style="font-family: HelveticaNeue,
Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"> <font face="Arial" size="2"> On Monday, January 19, 2015 9:21 AM, Richard Kreiss <rkreiss@verizon.net> wrote:<br> </font> </div> <br><br> <div>Top post:<br clear="none"><br clear="none">How is the batch file started?<br clear="none"><br clear="none">Richard<br clear="none">Sent from my iPhone<br clear="none"><div id="yqtfd37119"><br clear="none">> On Jan 19, 2015, at 10:17 AM, Richard Hane <<a href="mailto:yoresoft@sbcglobal.net" shape="rect" ymailto="mailto:yoresoft@sbcglobal.net">yoresoft@sbcglobal.net</a>> wrote:<br clear="none">> <br clear="none">> 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). <br clear="none">> <br clear="none">> 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.<br clear="none">> <br clear="none">> 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.<br clear="none">> <br clear="none">> This morning we received the error listed below after about 70% of the batch file was done.<br clear="none">> <br clear="none">> Our question... Can someone give some reasons or causes of this odbc connection failing? <br clear="none">> <br clear="none">> Windows error:<br clear="none">> report.exe has stopped working<br clear="none">> Problem Event Name: APPCRASH<br clear="none">> Application Name: report.exe<br clear="none">> Application
version: 0.0.0.0<br clear="none">> Application timestamp: 45818b94<br clear="none">> Fault Module Name: report.exe<br clear="none">> Fault Module version: 0.0.0.0<br clear="none">> Fault Module timestamp: 45818b94<br clear="none">> Exception code: c0000005<br clear="none">> Exception offset: 0002235e<br clear="none">> O/S version: 6.1.7601.2.1.0.256.48<br clear="none">> Location ID: 1033<br clear="none">> <br clear="none">> Thank you in advance<br clear="none">> Rick Hane<br clear="none">> Controller<br clear="none">> Deluxe Stitcher Company Inc<br clear="none">> Retiring 01/22/2015<br clear="none">> -------------- next part --------------<br clear="none">> An HTML attachment was scrubbed...<br clear="none">> URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20150119/de35a86e/attachment.html" target="_blank"
shape="rect">http://mailman.celestial.com/pipermail/filepro-list/attachments/20150119/de35a86e/attachment.html</a>><br clear="none">> _______________________________________________<br clear="none">> Filepro-list mailing list<br clear="none">> <a href="mailto:Filepro-list@lists.celestial.com" shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">> Subscribe/Unsubscribe/Subscription Changes<br clear="none">> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank" shape="rect">http://mailman.celestial.com/mailman/listinfo/filepro-list</a></div><br><br></div> </div> </div> </div> </div></body></html>