SQL Server (language is British English) JasperReports encountered error on context creation

Article Id: 130262
Status: Published
Updated On: 14-09-2020 05:51
Products:
CA Application Test , Service Virtualization , CA Continuous Application Insight (PathFinder)
Issue/Introduction:

Selecting any testing or Virtual Service report  from Portal and getting below error:

Error :
JasperReports encountered error on context creation

OR

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.

Cause:

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.

Environment:

SQL Server for Registry database.

User to access database is language British English.

Resolution:

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.