# Sql\_last\_value resets to 1969-12-31 19.00.00 after logstash restart **URL:** \ **Category:** Logstash\ **Created:** [June 27, 2018, 5:56pm UTC](https://discuss.elastic.co/t/sql-last-value-resets-to-1969-12-31-19-00-00-after-logstash-restart/137672 "2018-06-27T17:56:35Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Arun\_Kumar\_N](https://avatars.discourse-cdn.com/v4/letter/a/f475e1/32.png) [@Arun\_Kumar\_N](https://discuss.elastic.co/u/Arun_Kumar_N)\ **Post date:** [June 27, 2018, 5:56pm UTC](https://discuss.elastic.co/t/sql-last-value-resets-to-1969-12-31-19-00-00-after-logstash-restart/137672/1 "2018-06-27T17:56:35Z")
I have written a conf file as below to get data from Oracle SQL jdbc { jdbc\_driver\_library =\> "C:\dev\script\config\mssql-jdbc-6.2.2.jre8.jar" jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver" jdbc\_connection\_string =\> "jdbc:sqlserver://1.2.3.4:1433;databaseName=MyDB;" jdbc\_user =\> "user" jdbc\_password =\> "\*\*\*\*" jdbc\_validate\_connection =\> true schedule =\> "/3 \* \* \* \* \*" statement\_filepath =\> "C:\dev\script\sql\script\_es.sql" last\_run\_metadata\_path =\> "C:\dev\script\es\_jdbc\_last\_run\_metadata.log" } If I restart logstash it is not picking up from last run value, instead It resetting value to TIMESTMAP '1969-12-31 19.00.00 '. if I keep the logstash scheduled for every 5min or something, it works as expected. I am using this command to start logstash = \> " logstash -f abc.conf --config.reload.automatic --path.data=C:/home/test/folder " ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 25, 2018, 5:56pm UTC](https://discuss.elastic.co/t/sql-last-value-resets-to-1969-12-31-19-00-00-after-logstash-restart/137672/2 "2018-07-25T17:56:37Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.