All Forums Tools
K-MAN 2 posts Joined 11/11
02 Nov 2011
Conversion from type "DBNull" to type 'Integer' is not valid.

Would anybody know why I would be getting this error with Teradata, and not with Teradata 12?

Conversion from type "DBNull" to type 'Integer' is not valid.


It happens when selecting down the database tree, at the columns folder (Expand / Collapse). I can see the tables, just not the column names and their data types.

This happens within many of my database schemas, but some others it works just fine. Is there a setting that needs to be changed, inorder for the columns to be able to fully expand? Maybe an software upgrade, or install? I hope others have seen this issue before, and have come to some resolution to this issue.


I'm using an oracle database.

-Database Version: Oracle 10.02.0040

-Provider Version: ODBC 09.02.0006

Used the same settings as Teradata 12 vs Teradata 13.


I'm not sure what other information you might need, but please let me know if I'm missing something.

Please and Thanks.

~ K-MAN ~
You must sign in to leave a comment.