problem with importing table definitions

kirankota79 · Post by **kirankota79** » Thu May 22, 2008 8:22 am

When i logon to designer, everything is fine when working with jobs. But when i want to import some table definitions the designer is not responding. I am able to connect through ODBC and filter the tables i need to import, but when i press the IMPORT button, it is a never ending process. Where does the problem lies. I tried 4 to 5 times and it is happening the same way. i have to close the designer through task manager

any clues?

wesd · Post by **wesd** » Thu May 22, 2008 9:10 am

Try and import through Manager.

Sounds to me like a DB connection issue.

OddJob · Post by **OddJob** » Thu May 22, 2008 9:16 am

What database are you connecting to via ODBC - I have seen the same issue connecting to DB2, but I can't remember for the life of me what the solution is. Anyway, please confirm your DB and I'll keep trying to remember!

kirankota79 · Post by **kirankota79** » Thu May 22, 2008 9:23 am

i am connecting to oracle, i was working with the database since past 10 days and never faced the problem..suddenly it happened.....i am checking it now but still getting hanged.

kirankota79 · Post by **kirankota79** » Thu May 22, 2008 9:24 am

wesd wrote:Try and import through Manager.

Sounds to me like a DB connection issue.

if it is a DB connection issue, how can i see the tables....the prorblem is only when i press the IMPORT button

kirankota79 · Post by **kirankota79** » Thu May 22, 2008 9:28 am

wesd wrote:Try and import through Manager.

Sounds to me like a DB connection issue.

i have tried with manager too...but its the same problem.

wesd · Post by **wesd** » Thu May 22, 2008 1:07 pm

This happened to me once too. Try using the Plug in Meta data extraction versus ODBC.

ray.wurlod · Post by **ray.wurlod** » Thu May 22, 2008 3:22 pm

kirankota79 wrote:i am connecting to oracle, i was working with the database since past 10 days and never faced the problem..suddenly it happened.....i am checking it now but still getting hanged.

What changed?

"Nothing" clearly is not the correct answer.

kirankota79 · Post by **kirankota79** » Thu May 22, 2008 4:36 pm

As wesd said i tried Plug in Meta data extraction, and that too is hanging. The DBA said that they hadn't done any changes. I was working till last evening and today suddenly it is creating problems. please give me some clues...

ray.wurlod · Post by **ray.wurlod** » Thu May 22, 2008 7:06 pm

FIND OUT what has changed.

keshav0307 · Post by **keshav0307** » Fri May 23, 2008 12:04 am

if its oracle table, then why don't you try using Orchestrate Schema definition import