Page 1 of 1
problem with importing table definitions
Posted: Thu May 22, 2008 8:22 am
by kirankota79
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?
Posted: Thu May 22, 2008 9:10 am
by wesd
Try and import through Manager.
Sounds to me like a DB connection issue.
Posted: Thu May 22, 2008 9:16 am
by OddJob
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!
Posted: Thu May 22, 2008 9:23 am
by kirankota79
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.
Posted: Thu May 22, 2008 9:24 am
by kirankota79
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
Posted: Thu May 22, 2008 9:28 am
by kirankota79
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.
Posted: Thu May 22, 2008 1:07 pm
by wesd
This happened to me once too. Try using the Plug in Meta data extraction versus ODBC.
Posted: Thu May 22, 2008 3:22 pm
by ray.wurlod
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.
Posted: Thu May 22, 2008 4:36 pm
by kirankota79
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...
Posted: Thu May 22, 2008 7:06 pm
by ray.wurlod
FIND OUT what has changed.
Posted: Fri May 23, 2008 12:04 am
by keshav0307
if its oracle table, then why don't you try using Orchestrate Schema definition import