Import metadata is taking lot of time

Sangeeta Pandey

Hello All,

Import metadata is taking lot of time and even selecting and transferring objects to physical layer is taking a great amount of time. I selected only 5 tables and waiting for last 1.5 hours to get it transferred. My DB server and OBIEE server is located on same machine. Is it that much slow or some issue which I can recify?

Thanks,

Sangeeta

Gianni Ceresa

Sangeeta Pandey wrote:transferring objects to physical layer is taking a great amount of time. I selected only 5 tables and waiting for last 1.5 hours to get it transferred.

Nothing is being transferred!

The menu is called "import metadata", not "import data" or "transfer data". Only metadata is collected, nothing is transferred. Tables names, column names, columns types, columns properties (null or not) and, based on your selection, primary/foreign keys and indexes.

Only metadata!

An import metadata taking 1h30 for 5 tables doesn't sound right, but impossible to say more as there are many options and every system is different than another.

The job is done by the host where you admintool is running, therefore doesn't really matter if the DB is on the same host than OBIEE: if your admintool is running somewhere else with extremely slow or laggish network, it will be slow.

Import metadata isn't mandatory, you can also create objects by hand. If you have only 5 tables you will be done manually in a lot less than 1h30...