<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    There is also a wiki page describing the sqlite version:
    <a class="moz-txt-link-freetext" href="https://halldweb1.jlab.org/wiki/index.php/SQLite-form_of_CCDB_database">https://halldweb1.jlab.org/wiki/index.php/SQLite-form_of_CCDB_database</a><br>
    <br>
    <div class="moz-cite-prefix">On 02/25/2014 02:47 PM, David Lawrence
      wrote:<br>
    </div>
    <blockquote cite="mid:8D8A5B34-365E-40D3-B7CA-E52C32762A0E@jlab.org"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <div><br>
      </div>
      Hi Matt,
      <div><br>
      </div>
      <div>&nbsp;The flat files that we kept in the repository for the
        calibration constants have not been kept up for some time. You
        now have to get the constants from the CCDB either via SQLite
        file (recommended for your current use case) or MySQL. An SQLite
        file is generated every night now from the MySQL database. These
        can be found on the JLab CUE here:</div>
      <div><br>
      </div>
      <div>
        <div style="margin: 0px; font-size: 10px; font-family: Monaco;">/group/halld/Software/calib/ccdb_sqlite</div>
      </div>
      <div style="margin: 0px; font-size: 10px; font-family: Monaco;"><br>
      </div>
      <div style="margin: 0px;">Download a recent file and set your
        JANA_CALIB_URL environment variable to something like:</div>
      <div style="margin: 0px;"><br>
      </div>
      <div style="margin: 0px;">setenv JANA_CALIB_URL <a
          moz-do-not-send="true"
          href="sqlite:////path/to/ccdb_2014-02-21.sqlite">sqlite:////path/to/ccdb_2014-02-21.sqlite</a></div>
      <div style="margin: 0px;"><br>
      </div>
      <div style="margin: 0px;">(note the four &#8220;/&#8216;)</div>
      <div style="margin: 0px;"><br>
      </div>
      <div style="margin: 0px;">You will have to download a new SQLite
        file occasionally. If you point to the MySQL DB at JLab, you
        will always be up-to-date, but will have a slower startup due to
        the long distance network access.</div>
      <div style="margin: 0px;"><br>
      </div>
      <div style="margin: 0px;">Regards,</div>
      <div style="margin: 0px;">-David</div>
      <div><br>
        <div>
          <div>On Feb 25, 2014, at 1:55 PM, Matthew Shepherd &lt;<a
              moz-do-not-send="true" href="mailto:mashephe@indiana.edu">mashephe@indiana.edu</a>&gt;
            wrote:</div>
          <br class="Apple-interchange-newline">
          <blockquote type="cite"><br>
            Dear offline friends,<br>
            <br>
            I'm trying to help one of my students get going again with
            software and he is having trouble running hdview2 after
            doing an update to his sim-recon install. <br>
            <br>
            Problem seems to be:<br>
            <br>
            ?JException: &nbsp;&nbsp;&nbsp;code = 0 &nbsp;&nbsp;&nbsp;text = Unable to open
"/home/s4/zacqjone/gluex/svn/calib/Magnets/Solenoid/solenoid_1350_poisson_20130925"!<br>
            <br>
            We checked and indeed this file is missing, but an update of
            calib doesn't seem to restore it. &nbsp;<br>
            <br>
            Did someone forget to check in the new map?<br>
            <br>
            Matt<br>
            <br>
            <br>
            JANA &gt;&gt;Opening source "pions_1gev_smeared.hddm" of
            type: HDDM<br>
            JANA &gt;&gt;Creating DGeometry:<br>
            JANA &gt;&gt; &nbsp;Run requested:9999 &nbsp;found:9999<br>
            JANA &gt;&gt; &nbsp;Run validity range: 9999-9999<br>
            JANA &gt;&gt; &nbsp;URL="<a moz-do-not-send="true"
              href="xmlfile:///home/s4/zacqjone/gluex/svn/hdds/prod/main_HDDS.xml">xmlfile:///home/s4/zacqjone/gluex/svn/hdds/prod/main_HDDS.xml</a>"
            &nbsp;context="default"<br>
            JANA &gt;&gt; &nbsp;Type="JGeometryXML"<br>
            Reading preferences from "/s4/zacqjone/.hdview2" ...<br>
            JANA &gt;&gt;Created JCalibration object of type:
            JCalibrationFile<br>
            JANA &gt;&gt;Generated via: fallback creation of
            JCalibrationFile<br>
            JANA &gt;&gt;Run:1<br>
            JANA &gt;&gt;URL: <a moz-do-not-send="true"
              href="file:///home/s4/zacqjone/gluex/svn/calib">file:///home/s4/zacqjone/gluex/svn/calib</a><br>
            JANA &gt;&gt;context: default<br>
            <a moz-do-not-send="true" href="http://JCalibrationFile.cc">JCalibrationFile.cc</a>:51
            Unable to open "/tmp/jana/resources/info.xml"!<br>
            JANA &gt;&gt;Reading Magnetic field map from
            Magnets/Solenoid/solenoid_1350_poisson_20130925 ...<br>
            JANA &gt;&gt; Factory Call Stack<br>
            JANA &gt;&gt;============================<br>
            JANA &gt;&gt; JEventLoop:OneEvent &nbsp;(brun) &nbsp;-- &nbsp;&nbsp;line:572 &nbsp;<a
              moz-do-not-send="true" href="http://JEventLoop.cc">JEventLoop.cc</a><br>
            JANA &gt;&gt;----------------------------<br>
            <a moz-do-not-send="true" href="http://JEventLoop.cc">JEventLoop.cc</a>:575
            &nbsp;EXCEPTION : <br>
            ?JException: &nbsp;&nbsp;&nbsp;code = 0 &nbsp;&nbsp;&nbsp;text = Unable to open
"/home/s4/zacqjone/gluex/svn/calib/Magnets/Solenoid/solenoid_1350_poisson_20130925"!<br>
            <br>
            Stack trace:<br>
            <br>
            &nbsp;&nbsp;jana::JException::getStackTrace()<br>
            &nbsp;&nbsp;jana::JException::JException(std::string const&amp;)<br>
            &nbsp;&nbsp;jana::JCalibrationFile::GetCalib(std::string,
            std::map&lt;std::string, std::string,
            std::less&lt;std::string&gt;,
            std::allocator&lt;std::pair&lt;std::string const,
            std::string&gt; &gt; &gt;&amp;, int)<br>
            &nbsp;&nbsp;bool
            jana::JCalibration::Get&lt;std::string&gt;(std::string,
            std::map&lt;std::string, std::string,
            std::less&lt;std::string&gt;,
            std::allocator&lt;std::pair&lt;std::string const,
            std::string&gt; &gt; &gt;&amp;, int)<br>
            &nbsp;&nbsp;jana::JResourceManager::GetResource(std::string)<br>
            &nbsp;&nbsp;bool
            jana::JResourceManager::Get&lt;std::vector&lt;std::vector&lt;float,
            std::allocator&lt;float&gt; &gt;,
            std::allocator&lt;std::vector&lt;float,
            std::allocator&lt;float&gt; &gt; &gt; &gt; &gt;(std::string,
            std::vector&lt;std::vector&lt;float,
            std::allocator&lt;float&gt; &gt;,
            std::allocator&lt;std::vector&lt;float,
            std::allocator&lt;float&gt; &gt; &gt; &gt;&amp;, int)<br>
            &nbsp;&nbsp;DMagneticFieldMapFineMesh::ReadMap(std::string, int,
            std::string)<br>
            &nbsp;&nbsp;DMagneticFieldMapFineMesh::DMagneticFieldMapFineMesh(jana::JApplication*,
            unsigned int, std::string)<br>
            &nbsp;&nbsp;DApplication::GetBfield(unsigned int)<br>
            &nbsp;&nbsp;MyProcessor::brun(jana::JEventLoop*, int)<br>
            &nbsp;&nbsp;jana::JEventLoop::OneEvent()<br>
            &nbsp;&nbsp;jana::JEventLoop::OneEvent()<br>
            &nbsp;&nbsp;jana::JEventLoop::OneEvent()<br>
            &nbsp;&nbsp;jana::JEventLoop::OneEvent()<br>
            <br>
            terminate called after throwing an instance of
            'std::exception'<br>
            &nbsp;what(): &nbsp;std::exception<br>
            Abort<br>
            [zacqjone@stanley pion_1gev]$ <br>
            <br>
            <br>
            <br>
---------------------------------------------------------------------<br>
            Matthew Shepherd, Associate Professor<br>
            Department of Physics, Indiana University, Swain West 265<br>
            727 East Third Street, Bloomington, IN 47405<br>
            <br>
            Office Phone: &nbsp;+1 812 856 5808<br>
            <br>
            <br>
            _______________________________________________<br>
            Halld-offline mailing list<br>
            <a moz-do-not-send="true"
              href="mailto:Halld-offline@jlab.org">Halld-offline@jlab.org</a><br>
            <a class="moz-txt-link-freetext" href="https://mailman.jlab.org/mailman/listinfo/halld-offline">https://mailman.jlab.org/mailman/listinfo/halld-offline</a><br>
          </blockquote>
        </div>
        <br>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
Halld-offline mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Halld-offline@jlab.org">Halld-offline@jlab.org</a>
<a class="moz-txt-link-freetext" href="https://mailman.jlab.org/mailman/listinfo/halld-offline">https://mailman.jlab.org/mailman/listinfo/halld-offline</a></pre>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Mark M. Ito, Jefferson Lab, <a class="moz-txt-link-abbreviated" href="mailto:marki@jlab.org">marki@jlab.org</a>, (757)269-5295
</pre>
  </body>
</html>