I’m having an issue with one of my tags where I am unable to display more than 3 days of historical data on an easy chart in vision. Screen shot below shows the component turns red when doing so.
I also see the following message logged:
com.microsoft.sqlserver.jdbc.SQLServerException: The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
Any thoughts on how I can fix this???
Did you ever resolve this? Getting a similar issue in the logs and wondering how you fixed it...
Are you querying many tag paths? Are they created/retired often? You might need to get with support to audit your historian DB; it seems like there might be an issue with sqlth_te leading to excessive records (and thus, excessive conditions in the ultimate query being used to return historical data), or some other issue with the historian that support should be able to help with.
