[ISS Support Case] Error: The column "ID" (compile-time ordinal 1) of object "" was reported to have a "LENGTH" of 36 at compile time and 37 at run time.
Last updated: September 4th, 2026Description
After upgrading Historian server to SP2023R2SP1P04, customer has the following error relating to the below SQL request: SELECT TOP (1000) * FROM [Runtime].[dbo].[Events] where EventTimeUTC >= DATEADD(DAY, -1, GETDATE()) Msg 7356, Level 16, State 1, Line 1 The OLE DB provider "INSQL" for linked server "INSQL" supplied inconsistent metadata for a column. The column "ID" (compile-time ordinal 1) of object "Runtime.dbo.Events" was reported to have a "LENGTH" of 36 at compile time and 37 at run time. SELECT TOP (1000) * FROM [Runtime].[dbo].[Events] where EventTimeUTC >= DATEADD(DAY, -1, GETDATE()) Msg 7356, Level 16, State 1, Line 1 The OLE DB provider "INSQL" for linked server "INSQL" supplied inconsistent metadata for a column. The column "ID" (compile-time ordinal 1) of object "Runtime.dbo.Events" was reported to have a "LENGTH" of 36 at compile time and 37 at run time.
- Author: Kevin Modlin
- Published: September 4th, 2026
Details:
| Product: Historian |
| Version: 2023 R2 |
| Solution: [Solution is visible below when you're logged in and have a current subscription] |
| Date Created: | 04/15/2026 |
| Case: | 103710 |
Give feedback about this article
Recommended articles
[ISS Support Case] Historian loses connection after shutting down
If the historian is shut down and disabled then re-enabled it doesn't connect to tags that haven't changed. Reboot re-establishes connection.
Read More[ISS Support Case] Trying to access old history blocks
They have a very old system they're trying to open a trend or see the data, but they don't see a trend program and can't figure out how to open the file. They believe they have the data, but it's running in demo mode and won't show data. This is an offline PC and they want to avoid putting it online, so we can't do a screen share.
Read More[ISS Support Case] Trend SQL Login Failure
Client reached out due to receiving time out error message when logging into SQL to View Trends remotely on Development node.
Read More[ISS Support Case] Wanting to pull 9 months of historized data
-Customer is wanting Historized data from the last 9 months in a .CSV file. Or in SQL. and wants to know the best practices.
Read More