# MS SQL Transaction Log Errors **URL:** \ **Category:** Beats\ **Tags:** metricbeat\ **Created:** [August 7, 2019, 11:27am UTC](https://discuss.elastic.co/t/ms-sql-transaction-log-errors/194220 "2019-08-07T11:27:51Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![SvenC56](https://avatars.discourse-cdn.com/v4/letter/s/a5b964/32.png) [@SvenC56](https://discuss.elastic.co/u/SvenC56)\ **Post date:** [August 7, 2019, 11:27am UTC](https://discuss.elastic.co/t/ms-sql-transaction-log-errors/194220/1 "2019-08-07T11:27:51Z")
Hi, I'm running the MSSQL Beat and I get some error messages. This is my connection string: `sqlserver://login:password@localhost:1433/instance_name` In the explorer field I get the following error message in the transaction\_log dataset. > error scanning single result: sql: expected 4 destination arguments in Scan, not 5 > error scanning single result: mssql: Invalid object name 'sys.dm\_db\_log\_stats'. I can read the performance data of the MS SQL database. Do you know where this issue may come from? Thank you. ---
**Author:** ![Kaiyan\_Sheng](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kaiyan_sheng/32/38247_2.png) [@Kaiyan\_Sheng](https://discuss.elastic.co/u/Kaiyan_Sheng)\ **Post date:** [August 8, 2019, 3:34am UTC](https://discuss.elastic.co/t/ms-sql-transaction-log-errors/194220/2 "2019-08-08T03:34:51Z")
@SvenC56 Thanks for posting! Quick question, what version of Metricbeat and what version of MSSQL are you using? ---
**Author:** ![SvenC56](https://avatars.discourse-cdn.com/v4/letter/s/a5b964/32.png) [@SvenC56](https://discuss.elastic.co/u/SvenC56)\ **Post date:** [August 8, 2019, 6:29am UTC](https://discuss.elastic.co/t/ms-sql-transaction-log-errors/194220/3 "2019-08-08T06:29:27Z")
Hi, thank you for the fast response. We use `Microsoft SQL Server Standard Edition (64-bit)` in version `11.0.5058 SP2`, the language is set to `English (United States)`, sorting `Latin1_General_CI_AS`. We use a virtual instance hence the connection string. The default database is set to `master`. We use the complete ELK Stack + Metricbeat in Version `7.3`. ---
**Author:** ![Kaiyan\_Sheng](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kaiyan_sheng/32/38247_2.png) [@Kaiyan\_Sheng](https://discuss.elastic.co/u/Kaiyan_Sheng)\ **Post date:** [August 8, 2019, 10:46pm UTC](https://discuss.elastic.co/t/ms-sql-transaction-log-errors/194220/4 "2019-08-08T22:46:55Z")
@Mario_Castro I tracked down to the source code but still not sure why hmmm Can I get help please? Thanks!! ---
**Author:** ![Mario\_Castro](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mario_castro/32/35107_2.png) [@Mario\_Castro](https://discuss.elastic.co/u/Mario_Castro)\ **Post date:** [August 9, 2019, 9:19am UTC](https://discuss.elastic.co/t/ms-sql-transaction-log-errors/194220/5 "2019-08-09T09:19:26Z")
Hi @SvenC56 🙂 I'm afraid that the `transaction_log` Metricset is only compatible with SQL Server 2017 and up. You version seems to be from 2012 according to this table I found [https://sqlserverbuilds.blogspot.com/](https://sqlserverbuilds.blogspot.com/) It looks for the table `sys.dm_db_log_stats` which was introduced in version 2017 as an enhancement in Dynamic management views ---
**Author:** ![SvenC56](https://avatars.discourse-cdn.com/v4/letter/s/a5b964/32.png) [@SvenC56](https://discuss.elastic.co/u/SvenC56)\ **Post date:** [August 9, 2019, 11:50am UTC](https://discuss.elastic.co/t/ms-sql-transaction-log-errors/194220/6 "2019-08-09T11:50:01Z")
Hi, I can confirm it works with our 2017 instance. Thank you both for the help! 🙂 ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 6, 2019, 11:50am UTC](https://discuss.elastic.co/t/ms-sql-transaction-log-errors/194220/7 "2019-09-06T11:50:03Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.