INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Thank you for the best reply I've ever had to a forum question - it's extremely comprehensive and legible and answers my query thoroughly..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Project and Data Management > Data Management Programming issues > Data warehousing general discussion Forum

Error creating repository user in OWB

Read More Threads Like This One

brokenbone (Programmer)

3 May 07 7:20

Hi all!

First I'd like to thank you all for replying to my previous post. Now I have more technical problem.
I'm using Oracle Warehouse Builder (10.2.0.1). I've been following Oracle Examples and successfully created 2 repositories (repository users). But now I'm trying to create a new one and I get next error:

The Warehouse Builder repository owner installation failed on user XXX.
INS0017: Installation of the seed data failed.oracle.wh.util.parser.ParseException.

After clicking OK, there is another message:
INS0029: Error occured during installation. Check the log file <path>\<log file name>.log for details.

Among other things in log file there is this error:

The user is not a new user. INS0018: Error occurred to this new user. This user name already exists in database. Specify another new user name.
OWBRT_SYS user already exists in database.

But OWBRT_SYS is Versioning User, that I can't change anywhere in the Create Repository Wizard. My question is, is there a way to change this versioning user or maybe I must grant/revoke some privileges to this user?

I'm not even sure that this is the main reason for this error, but I don't know where to go next.

I've posted my problem on OWB forum, but there are daily new posts there and I didn't get the answer. If anyone is interested, here is the link:
http://forums.oracle.com/forums/thread.jspa?threadID=500502&tstart=0

Any ideas?

Thank you!
BB

brokenbone (Programmer)

15 May 07 10:06

Hi!

Well, since I didn't know what to do I went and dropped user OWBRT_SYS and all it's objects. Then I created new repository user with no problem. I inserted records for previous repositories in OWB in OWBRT_SYS tables and for now everything works fine.

Just a reply if someone will run into the same problem.

Best regards!

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Data warehousing general discussion