Selecting any testing or Virtual Service report from Portal and getting below error:
JasperReports encountered error on context creation
2020-09-14 08:35:43,554Z (09:35) [qtp1415924677-103] ERROR net.sf.jasperreports.web.servlets.ReportContextCreatorServlet - Error on report execution
net.sf.jasperreports.engine.JRException: Unable to get next record from result set.
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
Having the language set for user accessing SQL Server causes the DevTest code to break.
When doing a query to the database like the DevTest code is doing get this error:
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
SQL Server for Registry database.
User to access database is language British English.
Change the language on the user accessing SQL Server to be English instead of British English.
Bring down all of the DevTest components.
Delete all the log files.
Start all of the DevTest components.