Page 1 of 1
Can't open project on a server.
Posted: Mon Jul 11, 2005 6:24 pm
by killbill1
We have several projects and all of the sudden we can't log into one of the projects. Everytime you try logging in it just hangs on us. Can't log in thru designer, director, manager nor administrator.
I tried running the jobs for this project from command line and its the same problem, it just hangs without any error message.
Can anyone suggest what might have gone wrong.
Posted: Mon Jul 11, 2005 7:21 pm
by ray.wurlod
Possibly internal corruption in the Repository database or associated files.
Take a backup of the project if you don't already have one.
On the server machine, attach to the project directory then execute the following commands.
This should get you to the TCL prompt (>) where you can enter some more commands.
Code: Select all
SELECT COUNT(*) FROM DS_JOBS;
SELECT COUNT(*) FROM DS_JOBOBJECTS;
DS.REINDEX ALL
QUIT
(The last of these exits from
dssh environment.) Let us know what happened (any error messages). If there was none, can you now connect using clients?
Posted: Mon Jul 11, 2005 7:38 pm
by Kryt0n
Considering the co-incidence between me reading the pdfs and this topic I will post a reply on the off chance it may be what you have done...
Apparently if you install a trial ODBC driver, DataStage will hang (because it can't handle the evaluation status screens).
Maybe you haven't installed a trial ODBC driver but something similar?
Posted: Thu Jul 14, 2005 4:19 pm
by killbill1
Rebouncing the Ascential engine did the trick....trying to figure out what was the problem...