Getting 'integer out of range' error sqlalchemy
<p>So, I am using <code>odo</code> for data migration but came across this error: </p>

<pre><code>sqlalchemy.exc.DataError: (psycopg2.DataError) integer out of range  
</code></pre>

<p>Both the source and the destination tables have the same schema but in the sql statement being executed in the backend the integer values have .0 with them. Like the integer <code>34</code> in the source table is shown as <code>34.0</code>: </p>

<pre><code>[SQL: INSERT INTO table2 (col1, col2,col3) VALUES (%(col1)s, %(col2)s, %(col3)s] 
[parameters: ({'col2' : val2', 'col3' : val3', 'col1' : val1})]
</code></pre>

<p>Please let me know if more information is needed.</p>