<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:large"><span class="">Dear,</span><br><span class="">I did a</span> <span class="">test with the</span> <span class="">utility "</span><span class="">Inverted</span> <span class="">file</span> <span class="">generation</span> <span class="">(</span><span>MX</span><span>)"</span><span>,</span> <span class="">using</span> the<span class=""></span> <span class="">vmx_fullinv</span><br>  <span class="">and</span> <span class="">fullinv_steps</span> <span class="">scripts </span><span class="">in</span> <span class="">/</span><span class="">central</span><span class="">/utilities</span><span>.</span> <span class="">It presents a screen</span> <span class="">with</span><span>:</span><br><br><span class="">"Please</span> <span class="">adjust</span> <span class="">the</span> <span class="">Following</span> <span class="">parameters</span> <span class="">and press</span> <span class="">'</span><span>START</span><span>'<br><br></span><span class="">Select</span> <span class="">FST</span> <span class="">ibredoc.fst</span><br><span class="">Use /</span> <span class="">m</span> <span class="">parameter</span><br><span class="">STRAT"<br><br></span><span class="">Clicking on</span> <span class="">START</span><span>,</span> it presents<span class=""></span> <span class="">the message</span><span>: "missing</span> <span class="">file"</span><br><span>It did not write anything</span> <span class="">in the /</span><span class="">log folder</span><br><span class="">I would ask:</span> <span class="">1</span><span>)</span> <span class="">what parameters</span> <span class="">need to be</span> <span class="">adjusted?</span> <span class="">It did </span><span class="">not allow</span> <span class="">any adjustment</span><span>.</span><br><span class="">2) What</span> <span class="">file</span> <span class="">would be missing</span><span>?</span> <span class="">I found that</span> <span class="">all</span> <span class="">necessary files</span> <span class="">(</span><span>fst</span><span>,</span> <span class="">cip</span><span>,</span> <span class="">actab</span> <span class="">and</span> <span class="">uctab</span><span>)</span> <span class="">are in the </span> <span class="">/</span><span class="">dbn</span><span class="">/data </span><span class="">folder<br></span></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:large"><span class="">Any help?<br></span></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:large"><span class="">Thanks,<br></span></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:large"><span class="">Edwin<br></span></div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-11-05 12:10 GMT-02:00 Guilda Ascencio <span dir="ltr"><<a href="mailto:guildaa@gmail.com" target="_blank">guildaa@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div><div><div><div><div><div><div><div><div><div>Question:<br><br>Prezados,<br>
                                                  Tenho uma instalação
                                                  ABCD em Linux com 8
                                                  bases de dados. Em
                                                  apenas uma não
                                                  funciona o utilitário
                                                  "Geração do arquivo
                                                  invertido(MX)"
                                                  (internnd o). Todas estão
                                                  com os mesmos
                                                  isisac.tab e
                                                  isisuc.tab. O arquivo
                                                  .fst está correto. O
                                                  que pode ser o motivo
                                                  de funcionar em outras
                                                  e não em uma
                                                  determinada base de
                                                  dados?<br>
                                                  O resultado do comando
                                                  abaixo:<br>
                                                  <div><br>
                                                  </div>
                                                  ----------<br>
                                                  <span>Dear,</span><br>
                                                  <span>I have an</span>
                                                  <span>ABCD</span> <span>instalção</span>
                                                  (<span>Linux</span>)
                                                  with <span>8</span> <span>databases.</span>
                                                  <span>In</span> <span>only
                                                    one</span> <span>the
                                                    utility</span> <span>"</span><span>Inverted

                                                    file generation</span>
                                                  <span>(</span><span>MX</span><span>)"

                                                    (internal)</span><span></span>
                                                  <span></span><span>does

                                                    not work, </span><span>All</span>
                                                  databases have<span>
                                                    the same</span> <span>isisac.tab</span>
                                                  <span>and</span> <span>isisuc.tab
                                                    and the </span><span></span><span></span>
                                                  <span>FST</span> <span>file
                                                    is correct</span><span>.</span>
                                                  <span>What can be</span>
                                                  <span>the reason for</span>
                                                  <span>working on</span>
                                                  <span>others and</span>
                                                  <span>not on a</span>
                                                  <span>particular
                                                    database</span><span>?<br><br></span></div><span>Answer:<br><br></span></div><span>I have found that in large databases (with a big numer or records) the mx fullinv does not work: it generates the .ln1 and .ln2 files but the sort crashes.  So I developed an script that do the the proccess in 3 steps:<br><br></span></div><span>1. Generates the .ln1 and .ln2 files<br></span></div><span>2. sorts the .ln1 and .ln2 using the internal linux sort and generates .lk1 and .lk2<br></span></div><span>3. loads the inverted file using the .lk1 and .lk2 files generated in 2.<br><br></span></div><span>It has to be tested in other equipments to verify if it works (not in windows) and if the test succeed it could be added in the utilities menu.<br><br></span></div><span>the script is named utilities/fullinv_steps.php and for executing <br><br></span></div><div><span>1. Place the script in central/utilities<br></span></div><span>2. login in your abcd software<br></span></div><span>3. in the url write:  Http://[server addres]/central/utilities/fullinv_steps.php?base=data-base-to-be-inverted<br><br></span></div><span>Note:  the option for using the cipar has not been added yet<br><br></span></div><span>Let me know your results.<br><br></span></div><span>Regards<span class="HOEnZb"><font color="#888888"><br><br></font></span></span></div><span class="HOEnZb"><font color="#888888"><span>Guilda<br></span><div><div><div><div><div><div><div><div><div><div><div><div><span><br></span></div></div></div></div></div></div></div></div></div></div></div></div></font></span></div>
</blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature"><div dir="ltr"><span style="font-family:comic sans ms,sans-serif">Edwin Hübner</span><br>(21)99647-1675<br></div></div>
</div>