IS 601 repository initialization on Oracle 9i release 2 92

[klievens]

Hi,

Has anyone already tried to install the IS 6.0.1 repository on an Oracle 9i release 2 database? I receive the following error when starting the repository sever:

2003-10-09 23:32:38 CEST [ISC.0067.0111V5] Connected to repository server jdbc:oracle:thin:@mir:1521:db92 as user wm6repository
2003-10-09 23:32:38 CEST [ISC.0067.9999D] Cluster Database Exception => ORA-00942: Tabel or view does not exist.
42000
2003-10-09 23:32:38 CEST [ISC.0067.0099C] Repository Server initialization failed: com.wm.app.repo.RepositoryException: java.lang.NullPointerException
2003-10-09 23:32:38 CEST [ISC.0067.0099C] Repository Server initialization failed: com.wm.app.repo.RepositoryException: java.lang.NullPointerException

Funny thing is that it works with IS 4.6!!

Thanks in advance,
Kristof

[jplesmid]

Kristof,
Your original post was a fairly long time ago, but I am wondering if you ever found a solution.
I am getting the same error messages as you indicate in your post.
I know that I did not have any difficulty in getting the repo2 server to use SQLServer.

Thanks

[jplesmid]

FYI,
I submitted this problem to webMethods and received this response:
"... In general, when RepoV2 starts up, it searches for the WmRDBContainer table anywhere in the Oracle Instance. Not sure if you have tried connecting earlier to the same database with a different user for the repo, causing this table to be created initially. In case you then switched to another user, its possible that this table is still found in the database from the first user install of reposerver and it assumes that the RepoV2 tables are already there. However, when RepoV2 tries to do a select on the WmRDBContainer table it doesn't find it amongst the tables of the new user causing the exception. ..."

This, indeed, explained the cause of the exception, in my case. I was able to drop the old tables and was able to start the repov2 server without error.