sql Datatype convert

Question

I am getting the following error. I know it datatype error,
the thing is here is work early now it failed with this error.

c# code
long cdrid
execute.sp(getcdrdetailsrange @cdrid = cdrid)

SQL CODE
sp getcdrdetailsrange(@cdrid int)
(
select * from cdrdetails where cdrid>@cdrid;
)

ERROR: Error converting data type bigint to int.
TYPE: System.Data.SqlClient.SqlException

why it works so many years and now erroring out

Answer 1

Probably after the years the values of cdrid became greater than 2,147,483,647. If the column is bigint, then change int to bigint in your getcdrdetailsrange and other SQL scripts. Also make sure that the corresponding C# variables are long.