HomeForum
Welcome, Guest

Connecting to Oracle ETL repository
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Connecting to Oracle ETL repository

Connecting to Oracle ETL repository 1 year, 2 months ago #1791

  • George
  • OFFLINE
  • Junior Boarder
  • Posts: 36
  • Karma: 0
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

Re: Connecting to Oracle ETL repository 1 year, 2 months ago #1792

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
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

Re: Connecting to Oracle ETL repository 1 year, 2 months ago #1793

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
You are right about the repository,
Thank you very much for the assistance,
It all works fine now

George
  • Page:
  • 1
Time to create page: 0.16 seconds

Testimonials

"The DBSL Integration solution eliminated our data access bottle neck that previously impeded company growth. We are now able to provide solutions to long standing problems areas such as automated order processing and business reporting limitations. Additionally the solution allows for new opportunities to simply hook-on to our existing data sources. From development through testing the DBSL support  team continues to be helpful, resourceful and responsive to our company needs."

John Kil,
IT Manager

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top