- Posts: 51
- Thank you received: 0
Connecting to Oracle ETL repository
12 years 7 months ago #1791
by George
Connecting to Oracle ETL repository was created 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
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.
12 years 7 months ago #1792
by admin
Mike
ETL Architect
Replied by admin on topic Re: Connecting to Oracle ETL repository
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
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.
12 years 7 months ago #1793
by admin
Mike
ETL Architect
Replied by admin on topic Re: Connecting to Oracle ETL repository
You are right about the repository,
Thank you very much for the assistance,
It all works fine now
George
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.