https://forge.codesys.com/forge/talk/Engineering/thread/2e44c5a663/2020-03-29T09:42:57.777000ZRecent posts to ac_datalog Application_DataLog.sqlite has no tables2020-03-29T09:42:57.777000Z2020-03-29T09:42:57.777000ZDavidBohttps://forge.codesys.com/u/davidbo/https://forge.codesys.comba5096fa0657851ee5e75e60916a57a288fbb563

<div class="markdown_content"><p>I try to figure out how to use ac_datalog to log a value using sqlite as storage. CODESYS creates a file /var/opt/codesys/PlcLogic/ac_datalog/Application_DataLog.sqlite<br/> but as seen here it has no tables. Why?</p> <div class="codehilite"><pre><span></span><span class="n">sqlite</span><span class="o">&gt;</span> <span class="p">.</span><span class="n">dbinfo</span> <span class="k">database</span> <span class="n">page</span> <span class="k">size</span><span class="p">:</span> <span class="mi">32768</span> <span class="k">write</span> <span class="n">format</span><span class="p">:</span> <span class="mi">1</span> <span class="k">read</span> <span class="n">format</span><span class="p">:</span> <span class="mi">1</span> <span class="n">reserved</span> <span class="n">bytes</span><span class="p">:</span> <span class="mi">0</span> <span class="n">file</span> <span class="n">change</span> <span class="n">counter</span><span class="p">:</span> <span class="mi">12</span> <span class="k">database</span> <span class="n">page</span> <span class="k">count</span><span class="p">:</span> <span class="mi">2</span> <span class="n">freelist</span> <span class="n">page</span> <span class="k">count</span><span class="p">:</span> <span class="mi">1</span> <span class="k">schema</span> <span class="n">cookie</span><span class="p">:</span> <span class="mi">12</span> <span class="k">schema</span> <span class="n">format</span><span class="p">:</span> <span class="mi">4</span> <span class="k">default</span> <span class="k">cache</span> <span class="k">size</span><span class="p">:</span> <span class="mi">0</span> <span class="n">autovacuum</span> <span class="n">top</span> <span class="n">root</span><span class="p">:</span> <span class="mi">0</span> <span class="n">incremental</span> <span class="k">vacuum</span><span class="p">:</span> <span class="mi">0</span> <span class="nb">text</span> <span class="k">encoding</span><span class="p">:</span> <span class="mi">1</span> <span class="p">(</span><span class="n">utf8</span><span class="p">)</span> <span class="k">user</span> <span class="k">version</span><span class="p">:</span> <span class="mi">0</span> <span class="n">application</span> <span class="n">id</span><span class="p">:</span> <span class="mi">0</span> <span class="n">software</span> <span class="k">version</span><span class="p">:</span> <span class="mi">3028000</span> <span class="nb">number</span> <span class="k">of</span> <span class="n">tables</span><span class="p">:</span> <span class="mi">0</span> <span class="nb">number</span> <span class="k">of</span> <span class="n">indexes</span><span class="p">:</span> <span class="mi">0</span> <span class="nb">number</span> <span class="k">of</span> <span class="n">triggers</span><span class="p">:</span> <span class="mi">0</span> <span class="nb">number</span> <span class="k">of</span> <span class="n">views</span><span class="p">:</span> <span class="mi">0</span> <span class="k">schema</span> <span class="k">size</span><span class="p">:</span> <span class="mi">0</span> <span class="k">data</span> <span class="k">version</span> <span class="mi">2</span> <span class="n">sqlite</span><span class="o">&gt;</span> <span class="p">.</span><span class="n">dbinfo</span> <span class="k">database</span> <span class="n">page</span> <span class="k">size</span><span class="p">:</span> <span class="mi">32768</span> <span class="k">write</span> <span class="n">format</span><span class="p">:</span> <span class="mi">1</span> <span class="k">read</span> <span class="n">format</span><span class="p">:</span> <span class="mi">1</span> <span class="n">reserved</span> <span class="n">bytes</span><span class="p">:</span> <span class="mi">0</span> <span class="n">file</span> <span class="n">change</span> <span class="n">counter</span><span class="p">:</span> <span class="mi">12</span> <span class="k">database</span> <span class="n">page</span> <span class="k">count</span><span class="p">:</span> <span class="mi">2</span> <span class="n">freelist</span> <span class="n">page</span> <span class="k">count</span><span class="p">:</span> <span class="mi">1</span> <span class="k">schema</span> <span class="n">cookie</span><span class="p">:</span> <span class="mi">12</span> <span class="k">schema</span> <span class="n">format</span><span class="p">:</span> <span class="mi">4</span> <span class="k">default</span> <span class="k">cache</span> <span class="k">size</span><span class="p">:</span> <span class="mi">0</span> <span class="n">autovacuum</span> <span class="n">top</span> <span class="n">root</span><span class="p">:</span> <span class="mi">0</span> <span class="n">incremental</span> <span class="k">vacuum</span><span class="p">:</span> <span class="mi">0</span> <span class="nb">text</span> <span class="k">encoding</span><span class="p">:</span> <span class="mi">1</span> <span class="p">(</span><span class="n">utf8</span><span class="p">)</span> <span class="k">user</span> <span class="k">version</span><span class="p">:</span> <span class="mi">0</span> <span class="n">application</span> <span class="n">id</span><span class="p">:</span> <span class="mi">0</span> <span class="n">software</span> <span class="k">version</span><span class="p">:</span> <span class="mi">3028000</span> <span class="nb">number</span> <span class="k">of</span> <span class="n">tables</span><span class="p">:</span> <span class="mi">0</span> <span class="nb">number</span> <span class="k">of</span> <span class="n">indexes</span><span class="p">:</span> <span class="mi">0</span> <span class="nb">number</span> <span class="k">of</span> <span class="n">triggers</span><span class="p">:</span> <span class="mi">0</span> <span class="nb">number</span> <span class="k">of</span> <span class="n">views</span><span class="p">:</span> <span class="mi">0</span> <span class="k">schema</span> <span class="k">size</span><span class="p">:</span> <span class="mi">0</span> <span class="k">data</span> <span class="k">version</span> <span class="mi">2</span><span class="n">code</span> </pre></div> <p>My application is very simple:</p> <div class="codehilite"><pre><span></span><span class="nv">PROGRAM</span> <span class="nv">PLC_PRG</span> <span class="nv">VAR</span> {<span class="nv">attribute</span> <span class="s1">'</span><span class="s">ac_datalog</span><span class="s1">'</span> :<span class="o">=</span> <span class="s1">'</span><span class="s">DataLogChannel_1</span><span class="s1">'</span>} {<span class="nv">attribute</span> <span class="s1">'</span><span class="s">ac_datalog_hysteresis</span><span class="s1">'</span> :<span class="o">=</span> <span class="s1">'</span><span class="s">0.10</span><span class="s1">'</span>} {<span class="nv">attribute</span> <span class="s1">'</span><span class="s">ac_datalog_hysteresis</span><span class="s1">'</span> :<span class="o">=</span> <span class="s1">'</span><span class="s">1.10</span><span class="s1">'</span>} <span class="nv">data</span>:<span class="nv">INT</span>:<span class="o">=</span><span class="mi">100</span><span class="c1">;</span> <span class="nv">down</span>: <span class="nv">bool</span>:<span class="o">=</span><span class="nv">FALSE</span><span class="c1">;</span> <span class="nv">END_VAR</span> <span class="k">IF</span> <span class="nv">data</span> <span class="o">&gt;</span><span class="mi">115</span> <span class="nv">OR</span> <span class="nv">down</span> <span class="k">THEN</span> <span class="k">IF</span> <span class="nv">data</span> <span class="o">&gt;</span><span class="mi">115</span> <span class="k">THEN</span> <span class="nv">down</span>:<span class="o">=</span><span class="nv">TRUE</span><span class="c1">;</span> <span class="nv">END_IF</span> <span class="nv">data</span>:<span class="o">=</span><span class="nv">data</span><span class="o">-</span><span class="mi">1</span><span class="c1">;</span> <span class="k">IF</span> <span class="nv">data</span><span class="o">&lt;</span><span class="mi">85</span> <span class="k">THEN</span> <span class="nv">down</span>:<span class="o">=</span><span class="nv">FALSE</span><span class="c1">;</span> <span class="nv">END_IF</span> <span class="k">ELSE</span> <span class="nv">data</span>:<span class="o">=</span><span class="nv">data</span><span class="o">+</span><span class="mi">1</span><span class="c1">;</span> <span class="nv">END_IF</span> </pre></div> </div>