I'm working with Index Server and am getting an error of:
System.InvalidCastException: The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was still retrievable.
When I try to return the FileIndex column. My select statement looks like "SELECT FileIndex, DocTitle, vpath, filename, size, write, characterization, rank". If I remove FileIndex, it works great!
Does anyone have an idea on how to fix this? It is necessary for me to pull back FileIndex, so removing it is not an option.
Thanks,
Tim
System.InvalidCastException: The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was still retrievable.
When I try to return the FileIndex column. My select statement looks like "SELECT FileIndex, DocTitle, vpath, filename, size, write, characterization, rank". If I remove FileIndex, it works great!
Does anyone have an idea on how to fix this? It is necessary for me to pull back FileIndex, so removing it is not an option.
Thanks,
Tim