Connecting to Oracle ETL repository

More
12 years 7 months ago #1791 by George
Hi all

My laptop ran out of power over the weekend in standby mode and this morning when I've rebooted I can't get the application to start.
The repository was set to my Oracle db running locally on my PC... when I try to connect to this the application comes
up with a series of messages saying it can't access various tables;

select * from objects_tree where object_type<>900 order by object_type,name

... (long query)

select * from schedule;

... (another long query)

And then it just shows a blank application window saying "Waiting" and "Connecting" in bottom left on status bar.

How do I reset the application so it starts up properly?
Also, for future, how do I set it up so that it has the "repository" tables or whatever it needs created?

Regards,
George

Please Log in or Create an account to join the conversation.

More
12 years 7 months ago #1792 by admin
Looks like you have not actually created the repository

1. Shut down Advanced ETL Processor
2. Run Repository Creation Wizard to create all necessary tables.
3. Run Advanced ETL Processor
4. Click File=>Options=>and choose previous repository
5. Click reconnect
6. Close dialog box
7. Click tools backup repository
8. connect to newly created Oracle ETL Repository
9. Restore repository

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
12 years 7 months ago #1793 by admin
You are right about the repository,
Thank you very much for the assistance,
It all works fine now

George

Mike
ETL Architect

Please Log in or Create an account to join the conversation.