Unable to import the table

[pmadhavi]

Hi

We are unable to import some tables in the DS Manager.
Import is working for most of the tables.

But there is a small set of tables for which we are getting an error like

Runtime Error: 'Overflow'

Can u pls help us.

[ArndW]

How are you importing the tables and from what database. Do these tables that cause errors have datatypes that aren't found in the others?

[pmadhavi]

How are you importing the tables and from what database. Do these tables that cause errors have datatypes that aren't found in the others? ...

We are importing the tables from Import menu:
Import -->TableDefinitions-->ODBC Table Definition

And we are importing from Oracle Database.

[DSguru2B]

Why arent you using Plug-in Metadata to import the table definitions. ?

[ray.wurlod]

Try using a Filter on table name or owner. Overflow can occur when there are too many tables in the database.

It can also occur (theoretically) when there are too many columns in a table, but I have never seen this actually happen.

What does your support provider have to say?

[mahi_mahi]

Try using a Filter on table name or owner. Overflow can occur when there are too many tables in the database.

It can also occur (theoretically) when there are too many columns in a table, but I have never seen this actually happen.

What does your support provider have to say?

We did not ask anyone before on this.
Now I am creating a new table definition in DS Manager which references the table in the database.

I culd not find out why is it happing only for few tables.

[ray.wurlod]

You are paying good money for "maintenance" to your support provider. They may as well earn some of it!