SQL Server (language is British English) JasperReports encountered error on context creation
Article ID: 130262
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.
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.
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.
Bring down all of the DevTest components.
Delete all the log files.
Start all of the DevTest components.
Feedback
Yes
No
Powered by
