Hi,

I’m getting a RepositoryException from my IS and would appreciate help on this one.
The error is as follows:

ServerError: (com.wm.app.b2b.server.ServiceException: com.wm.app.repo.RepositoryException: com.wm.app.repo.RepositoryException: com.wm.util.queue.ValuesHashException: java.sql.SQLException: [wm-cjdbc33-0009][SQLServer JDBC Driver]Exception generated during defered local transaction handling.

When is this kind of error thrown?
What can I do to fix the problem?

Regards
HÃ¥kan

Hi Haykan,

Looks like the DirValuesHash.dat got corrupted which is stored inthe IntegrationServer/WmRepository2/DirValuesHash.dat that might causing this exception. Check the folder and delete everything in the repository2 folder, always make a backup and restart the ISServer.

HTH,
Leon

The solution you’re suggesting applies assuming I was running a file based repository, right?
Correct me if I got this one wrong�
I’m currently running a repository using a database

More help on this would be appreciated.

/Hakan

Can you post your repo configuration settings.
Im assuming you have copied classes12.jar & classes12.zip to c:/webmethods6/integrationserver/lib/jars

Thanks,
Leon

Hi All,
While starting the repository server, i am getting the following error

“2005-06-16 10:00:34 GMT+07:00 [ISC.0067.0099C] Repository Server initialization failed: com.wm.app.repo.RepositoryException: com.wm.app.repo.RepositoryException: com.wm.util.queue.ValuesHashException: Invalid Oracle URL specified”

I am using datbase type of repository and specified the URL as
jdbc:oracle:thin@ip:1521:SID
and driver oracle.jdbc.driver.OracleDriver

I have placed the classes.jar file the IS_DIR/lib/jar
CAn any one have encoutere this problem earlier…plz let me know the soln…
Thanks,
Khalil.

Hi All,
While starting the repository server, i am getting the following error

“2005-06-16 10:00:34 GMT+07:00 [ISC.0067.0099C] Repository Server initialization failed: com.wm.app.repo.RepositoryException: com.wm.app.repo.RepositoryException: com.wm.util.queue.ValuesHashException: Invalid Oracle URL specified”

I am using datbase type of repository and specified the URL as
jdbc:oracle:thin@ip:1521:SID
and driver oracle.jdbc.driver.OracleDriver

I have placed the classes.jar file the IS_DIR/lib/jar
CAn any one have encoutere this problem earlier…plz let me know the soln…
Thanks,
Khalil.

Try changing the URL to something like this:

jdbc:wm:oracle and then the rest as usual.

Khalil,

The database URL you typed is missing a colon after the word ‘thin’.
This is a common error due to a documentation bug.

It should be:
jdbc:oracle:thin:@jp:1521:mysid

I assume you replace SID with the actual SID value from your tnsnames file.

This should work with the driver you mentioned.