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

book

Article ID: 130262

calendar_today

Updated On:

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.