November 05, 2004
Installing Oracle Warehouse Builder
I've recently had quite a few goes at installing Oracle Warehouse Builder 10.1, each of which has been a glorious failure. Today I found the cause of my pain and, delight of delights, a solution.
I was failing to install the repository into my development database. For those new to the world of Warehouse Builder the tool stores the design information you supply in a series of tables (with associated sequences, triggers, views and code objects) called the repository. Before you can define mappings and transformations you need to create this repository.
My problem lies, I think, in the fact that I was trying to create my repository in an Oracle 9.2 (as opposed to 10g) database with a unicode character set (in my case 'AL32UTF8'). This combination causes the repository assistant to crash when populating the repository tables with seed data. The error I received was;
INS0017: Installation of seeded data failed
INS0029: Error occurred during installation. Check the log file C:\Oracle\product\10.1.0\OWB\owb\reposasst\log.txt for details
Checking the log file wasn't much use as it just showed an enormous exception stack from when the error occurred with the primary culprit being SetCurrentProjectExceptionSDK1001. Various searches on metalink hadn't revealed much, until I used the exception itself as my search string
Then I found this forum thread which mirrored my experiences and provided a solution. For those without access to Oracle support the problem (and solution) lies in the use of the thick Java JDBC driver in this particular circumstance. Telling OWB to use the thin JDBC driver for the duration of the repository installation solves the problem and allows the repository creation to work. The steps, as detailed in the forum thread, are;
1) Locate OWBHome\owb\bin\admin directory (Windows) or OWBHome/owb/bin/admin (Unix)
2) Create a file jdbcdriver.properties in this directory with the following line ONLY.
3) Create OWB Repository
4) After successful creation, delete the above created jdbcdriver.properties file
Posted by Andy Todd at November 05, 2004 10:41 AM