Conversion failed when converting the varchar value 'NA' to data type int

Hi I need help , how do I fix this error?
org.eclipse.birt.report.engine.api.EngineException: Cannot fetch the next data row. org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot move down to next row in the result set. SQL error #1:Conversion failed when converting the varchar value 'NA' to data type int. ; com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the varchar value 'NA' to data type int.

Thanks from Panama

Find more posts tagged with

Comments

mwilliams

So, in your database, you have NA as a value in an int field? Have you tried writing an expression in your sql to return a 0 instead of 'NA'? <a data-ipb='nomediaparse' href='https://msdn.microsoft.com/en-us/library/ms182717.aspx'>https://msdn.microsoft.com/en-us/library/ms182717.aspx</a>