<html><body>
<p><font size="2">Hi folks,</font><br>
<br>
<font size="2">The unix host that our Guvnor instance ran on was shutdown without first shutting down Guvnor.</font><br>
<font size="2">When I restarted Guvnor after the host came back up, I got the message: "This looks like a brand new repository. Would you like to install a sample repository?"</font><br>
<font size="2">Has anyone else experienced this problem?</font><br>
<font size="2">Any pointers on how to recovery would be greatly appreciated.</font><br>
<br>
<font size="2">I do have an xml export of the repository that I can use if all else fails.</font><br>
<font size="2">But I would prefer to recover the existing database so that I can retain the history and the latest changes.</font><br>
<br>
<font size="2">Thank you for your assistance.</font><br>
<font size="2">-tk</font><br>
<br>
<font size="2">-------------------------</font><br>
<font size="2">Guvnor version: 5.0.0.SNAPSHOT 25673M</font><br>
<font size="2">JBoss: Release ID: JBoss [Trinity] 4.2.3.GA (build: SVNTag=JBoss_4_2_3_GA date=200807181417)</font><br>
<font size="2">JDK: Java version: 1.6.0_20,Sun Microsystems Inc.</font><br>
<font size="2">OS: SunOS <hostname> 5.10 Generic_142900-12 sun4v sparc SUNW,T5240</font><br>
<br>
<font size="2">We are using SQL Server as the repository (see repository.xml below)</font><br>
<br>
<font size="2">When I check the database I see the following tables and row counts:</font><br>
<br>
<font size="2" face="Courier New">VERSION_BINVAL 0</font><br>
<font size="2" face="Courier New">VERSION_NODE 13836</font><br>
<font size="2" face="Courier New">VERSION_PROP 66436</font><br>
<font size="2" face="Courier New">VERSION_REFS 3324</font><br>
<br>
<font size="2"><br>
</font><br>
<font size="2">Repository.xml content:</font><br>
<br>
<font size="2" face="Courier New"><?xml version="1.0"?></font><br>
<font size="2" face="Courier New"><!--</font><br>
<font size="2" face="Courier New"> Licensed to the Apache Software Foundation (ASF) under one or more</font><br>
<font size="2" face="Courier New"> contributor license agreements. See the NOTICE file distributed with</font><br>
<font size="2" face="Courier New"> this work for additional information regarding copyright ownership.</font><br>
<font size="2" face="Courier New"> The ASF licenses this file to You under the Apache License, Version 2.0</font><br>
<font size="2" face="Courier New"> (the "License"); you may not use this file except in compliance with</font><br>
<font size="2" face="Courier New"> the License. You may obtain a copy of the License at</font><br>
<br>
<font size="2" face="Courier New"> </font><font size="2" face="Courier New"><a href="http://www.apache.org/licenses/LICENSE-2.0">http://www.apache.org/licenses/LICENSE-2.0</a></font><br>
<br>
<font size="2" face="Courier New"> Unless required by applicable law or agreed to in writing, software</font><br>
<font size="2" face="Courier New"> distributed under the License is distributed on an "AS IS" BASIS,</font><br>
<font size="2" face="Courier New"> WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.</font><br>
<font size="2" face="Courier New"> See the License for the specific language governing permissions and</font><br>
<font size="2" face="Courier New"> limitations under the License.</font><br>
<font size="2" face="Courier New">--></font><br>
<font size="2" face="Courier New"><!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit 1.4//EN"</font><br>
<font size="2" face="Courier New"> "</font><font size="2" face="Courier New"><a href="http://jackrabbit.apache.org/dtd/repository-1.4.dtd">http://jackrabbit.apache.org/dtd/repository-1.4.dtd</a></font><font size="2" face="Courier New">"></font><br>
<font size="2" face="Courier New"><!-- Example Repository Configuration File --></font><br>
<font size="2" face="Courier New"><Repository></font><br>
<font size="2" face="Courier New"> <!--</font><br>
<font size="2" face="Courier New"> virtual file system where the repository stores global state</font><br>
<font size="2" face="Courier New"> (e.g. registered namespaces, custom node types, etc.)</font><br>
<font size="2" face="Courier New"> --></font><br>
<font size="2" face="Courier New"> <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"></font><br>
<font size="2" face="Courier New"> <param name="path" value="${rep.home}/repository"/></font><br>
<font size="2" face="Courier New"> </FileSystem></font><br>
<br>
<font size="2" face="Courier New"> <!--</font><br>
<font size="2" face="Courier New"> security configuration</font><br>
<font size="2" face="Courier New"> --></font><br>
<font size="2" face="Courier New"> <Security appName="Jackrabbit"></font><br>
<font size="2" face="Courier New"> <!--</font><br>
<font size="2" face="Courier New"> access manager:</font><br>
<font size="2" face="Courier New"> class: FQN of class implementing the AccessManager interface</font><br>
<font size="2" face="Courier New"> --></font><br>
<font size="2" face="Courier New"> <AccessManager class="org.apache.jackrabbit.core.security.SimpleAccessManager"></font><br>
<font size="2" face="Courier New"> <!-- <param name="config" value="${rep.home}/access.xml"/> --></font><br>
<font size="2" face="Courier New"> </AccessManager></font><br>
<br>
<font size="2" face="Courier New"> <LoginModule class="org.apache.jackrabbit.core.security.SimpleLoginModule"></font><br>
<font size="2" face="Courier New"> <!-- anonymous user name ('anonymous' is the default value) --></font><br>
<font size="2" face="Courier New"> <!-- <param name="anonymousId" value="anonymous"/> --></font><br>
<font size="2" face="Courier New"> <!--</font><br>
<font size="2" face="Courier New"> default user name to be used instead of the anonymous user</font><br>
<font size="2" face="Courier New"> when no login credentials are provided (unset by default)</font><br>
<font size="2" face="Courier New"> --></font><br>
<font size="2" face="Courier New"> <!-- <param name="defaultUserId" value="superuser"/> --></font><br>
<font size="2" face="Courier New"> </LoginModule></font><br>
<font size="2" face="Courier New"> </Security></font><br>
<br>
<font size="2" face="Courier New"> <!--</font><br>
<font size="2" face="Courier New"> location of workspaces root directory and name of default workspace</font><br>
<font size="2" face="Courier New"> --></font><br>
<font size="2" face="Courier New"> <Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default"/></font><br>
<font size="2" face="Courier New"> <!--</font><br>
<font size="2" face="Courier New"> workspace configuration template:</font><br>
<font size="2" face="Courier New"> used to create the initial workspace if there's no workspace yet</font><br>
<font size="2" face="Courier New"> --></font><br>
<font size="2" face="Courier New"> <Workspace name="${wsp.name}"></font><br>
<font size="2" face="Courier New"> <!--</font><br>
<font size="2" face="Courier New"> virtual file system of the workspace:</font><br>
<font size="2" face="Courier New"> class: FQN of class implementing the FileSystem interface</font><br>
<font size="2" face="Courier New"> --></font><br>
<font size="2" face="Courier New"> <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"></font><br>
<font size="2" face="Courier New"> <param name="path" value="${wsp.home}"/></font><br>
<font size="2" face="Courier New"> </FileSystem></font><br>
<font size="2" face="Courier New"> <!--</font><br>
<font size="2" face="Courier New"> persistence manager of the workspace:</font><br>
<font size="2" face="Courier New"> class: FQN of class implementing the PersistenceManager interface</font><br>
<font size="2" face="Courier New"> --></font><br>
<font size="2" face="Courier New"> <PersistenceManager class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager"></font><br>
<font size="2" face="Courier New"> <param name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/></font><br>
<font size="2" face="Courier New"> <param name="user" value="<dbuser>"/></font><br>
<font size="2" face="Courier New"> <param name="password" value="<dbpassword>"/></font><br>
<font size="2" face="Courier New"> <param name="schema" value="mssql"/></font><br>
<font size="2" face="Courier New"> <param name="url" value="jdbc:sqlserver://<sqlserver_host>:<sqlserver_port>"/></font><br>
<font size="2" face="Courier New"> <param name="schemaObjectPrefix" value="${wsp.name}_"/></font><br>
<font size="2" face="Courier New"> </PersistenceManager></font><br>
<font size="2" face="Courier New"> <!--</font><br>
<font size="2" face="Courier New"> Search index and the file system it uses.</font><br>
<font size="2" face="Courier New"> class: FQN of class implementing the QueryHandler interface</font><br>
<font size="2" face="Courier New"> --></font><br>
<font size="2" face="Courier New"> <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex"></font><br>
<font size="2" face="Courier New"> <param name="path" value="${wsp.home}/index"/></font><br>
<font size="2" face="Courier New"> <param name="textFilterClasses" value="org.apache.jackrabbit.extractor.MsWordTextExtractor,org.apache.jackrabbit.extractor.MsExcelTextExtractor,org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,org.apache.jackrabbit.extractor.PdfTextExtractor,org.apache.jackrabbit.extractor.OpenOfficeTextExtractor,org.apache.jackrabbit.extractor.RTFTextExtractor,org.apache.jackrabbit.extractor.HTMLTextExtractor,org.apache.jackrabbit.extractor.XMLTextExtractor"/></font><br>
<font size="2" face="Courier New"> <param name="extractorPoolSize" value="2"/></font><br>
<font size="2" face="Courier New"> <param name="supportHighlighting" value="true"/></font><br>
<font size="2" face="Courier New"> </SearchIndex></font><br>
<font size="2" face="Courier New"> </Workspace></font><br>
<br>
<font size="2" face="Courier New"> <!--</font><br>
<font size="2" face="Courier New"> Configures the versioning</font><br>
<font size="2" face="Courier New"> --></font><br>
<font size="2" face="Courier New"> <Versioning rootPath="${rep.home}/version"></font><br>
<font size="2" face="Courier New"> <!--</font><br>
<font size="2" face="Courier New"> Configures the filesystem to use for versioning for the respective</font><br>
<font size="2" face="Courier New"> persistence manager</font><br>
<font size="2" face="Courier New"> --></font><br>
<font size="2" face="Courier New"> <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"></font><br>
<font size="2" face="Courier New"> <param name="path" value="${rep.home}/version" /></font><br>
<font size="2" face="Courier New"> </FileSystem></font><br>
<br>
<font size="2" face="Courier New"> <!--</font><br>
<font size="2" face="Courier New"> Configures the persistence manager to be used for persisting version state.</font><br>
<font size="2" face="Courier New"> Please note that the current versioning implementation is based on</font><br>
<font size="2" face="Courier New"> a 'normal' persistence manager, but this could change in future</font><br>
<font size="2" face="Courier New"> implementations.</font><br>
<br>
<font size="2" face="Courier New"> <PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager"></font><br>
<font size="2" face="Courier New"> <param name="url" value="jdbc:derby:${rep.home}/version/db;create=true"/></font><br>
<font size="2" face="Courier New"> <param name="schemaObjectPrefix" value="version_"/></font><br>
<font size="2" face="Courier New"> </PersistenceManager></font><br>
<br>
<font size="2" face="Courier New"> --></font><br>
<font size="2" face="Courier New"> <PersistenceManager class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager"></font><br>
<font size="2" face="Courier New"> <param name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/></font><br>
<font size="2" face="Courier New"> <param name="user" value="<dbuser>"/></font><br>
<font size="2" face="Courier New"> <param name="password" value="<dbpassword>"/></font><br>
<font size="2" face="Courier New"> <param name="schema" value="mssql"/></font><br>
<font size="2" face="Courier New"> <param name="url" value="jdbc:sqlserver://<sqlserver_host>:<sqlserver_port>"/></font><br>
<font size="2" face="Courier New"> <param name="schemaObjectPrefix" value="version_"/></font><br>
<font size="2" face="Courier New"> </PersistenceManager></font><br>
<font size="2" face="Courier New"> </Versioning></font><br>
<br>
<font size="2" face="Courier New"> <!--</font><br>
<font size="2" face="Courier New"> Search index for content that is shared repository wide</font><br>
<font size="2" face="Courier New"> (/jcr:system tree, contains mainly versions)</font><br>
<font size="2" face="Courier New"> --></font><br>
<font size="2" face="Courier New"> <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex"></font><br>
<font size="2" face="Courier New"> <param name="path" value="${rep.home}/repository/index"/></font><br>
<font size="2" face="Courier New"> <param name="textFilterClasses" value="org.apache.jackrabbit.extractor.MsWordTextExtractor,org.apache.jackrabbit.extractor.MsExcelTextExtractor,org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,org.apache.jackrabbit.extractor.PdfTextExtractor,org.apache.jackrabbit.extractor.OpenOfficeTextExtractor,org.apache.jackrabbit.extractor.RTFTextExtractor,org.apache.jackrabbit.extractor.HTMLTextExtractor,org.apache.jackrabbit.extractor.XMLTextExtractor"/></font><br>
<font size="2" face="Courier New"> <param name="extractorPoolSize" value="2"/></font><br>
<font size="2" face="Courier New"> <param name="supportHighlighting" value="true"/></font><br>
<font size="2" face="Courier New"> </SearchIndex></font><br>
<font size="2" face="Courier New"></Repository></font><br>
<br>
<table border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="700" colspan="3"><img width="1" height="1" src="cid:1__=0ABBF2DADFFB3BA28f9e8a93df9386909@db.com" border="0" alt=""></td></tr>
<tr valign="top"><td width="115"><img src="cid:2__=0ABBF2DADFFB3BA28f9e8a93df9386909@db.com" width="115" height="58"></td><td width="231"><b><font size="2" face="Arial">Tharakesh Siddalingaiah</font></b><font size="2" face="Arial"><br>
Solution Architect <br>
GTO GIS Core Banking - PWM IT US <br>
Deutsche Bank AG </font></td><td width="354"><font size="2" face="Arial"><br>
Tel: +1 (410) 895 5275 <br>
Mob: +1 (410) 905 2169 </font><u><font size="2" color="#0000FF" face="Arial"><br>
</font></u><a href="mailto:tharakesh.siddalingaiah@db.com"><u><font size="2" color="#0000FF" face="Arial">tharakesh.siddalingaiah@db.com</font></u></a></td></tr>
<tr valign="top"><td width="115"> </td><td width="585" colspan="2"><a href=""></a><a href=""></a></td></tr>
</table>
<br>
<font size="1" face="Arial">---</font><br>
<font size="2" face="Courier New">This communication may contain confidential and/or privileged information.<br>
If you are not the intended recipient (or have received this communication<br>
in error) please notify the sender immediately and destroy this<br>
communication. Any unauthorized copying, disclosure or distribution of the<br>
material in this communication is strictly forbidden.<br>
<br>
Deutsche Bank does not render legal or tax advice, and the information<br>
contained in this communication should not be regarded as such.</font></body></html>