Hi All,
I am newbie to SQL programming and encountering and issue in one of live site.
I have the following SQL error in the log file.
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the nvarchar value '2686000.75' to data type int.
Error Code: 245
Call: SELECT t0.DFY004_MDL_D, MAX(CAST(t1.DFY006_ATTR_VAL_X AS int)), MIN(CAST(t1.DFY006_ATTR_VAL_X AS int)) FROM VDFY006_DERTV_ATTR t1 LEFT OUTER JOIN VDFY003_DERTV t0 ON (t1.DFY003_DERTV_D = t0.DFY003_DERTV_D) WHERE (((((t0.DFY004_MDL_D IN (?,?,?,?,?)) AND (t1.DFY005_ATTR_D = ?)) AND (t1.DFY006_ATTR_VAL_X IS NOT NULL)) AND (t1.DFY006_IS_DEL_F = ?)) AND (t0.DFY014_STAT_D = ?)) GROUP BY t0.DFY004_MDL_D
bind => [8 parameters bound]
Query: ReportQuery(referenceClass=DerivativeAttribute sql="SELECT t0.DFY004_MDL_D, MAX(CAST(t1.DFY006_ATTR_VAL_X AS int)), MIN(CAST(t1.DFY006_ATTR_VAL_X AS int)) FROM VDFY006_DERTV_ATTR t1 LEFT OUTER JOIN VDFY003_DERTV t0 ON (t1.DFY003_DERTV_D = t0.DFY003_DERTV_D) WHERE (((((t0.DFY004_MDL_D IN ?) AND (t1.DFY005_ATTR_D = ?)) AND (t1.DFY006_ATTR_VAL_X IS NOT NULL)) AND (t1.DFY006_IS_DEL_F = ?)) AND (t0.DFY014_STAT_D = ?)) GROUP BY t0.DFY004_MDL_D")
Need help to understand the issue and steps to resolve this.
What I have tried:
SQL Server Helper[
^]
[
^]