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.