<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<br><br></span></div><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></div>