<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 12pt; color: #000000'><style>p { margin: 0; }</style><div style="font-family: Times New Roman; font-size: 12pt; color: rgb(0, 0, 0);">Hello we have solved this ourselves.<br><br><br>turns out the code im going to paste has a very important line :<br><br> <param name="schemaObjectPrefix" value="version_"/> for versioning change<br><br> <param name="schemaObjectPrefix" value="default_"/> for persistence <br><br> <param name="schemaObjectPrefix" value="data_"/> for data saving<br><br>this param appears on any configuration you wouls like to change into the repository.xml file <br><br>whether you want to change only persistence , or pooling or data saving on the repository yoiu must put different values for it <br><br>This is it , <br><br>regards<br><br>Adrian<br><br><br>----- Original Message -----<br>From: "fugu" <ac@fugu.ec><br>To: rules-users@lists.jboss.org<br>Sent: Wednesday, November 3, 2010 10:51:05 AM<br>Subject: [rules-users] DROOLS 5.1 JBOSS 4.2.3 POSTGRES DUPLICATE KEY ERROR<br><br><br>Hello everybody<br><br>We are setting up DROOLS 5-1+JBOS4.2.3+POSTGRES 8.4<br><br>When server starts up we get this error<br><br>10:22:37,228 ERROR [STDERR] SLF4J: Found binding in<br>[jar:file:/opt/jboss-4.2.3.GA/server/default/deploy/drools-guvnor.war/WEB-INF/lib/slf4j-log4j12-1.6.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]<br>10:22:37,228 ERROR [STDERR] SLF4J: See<br>http://www.slf4j.org/codes.html#multiple_bindings for an explanation.<br>10:22:39,609 INFO [STDOUT] ERROR 03-11 10:22:39,601<br>(ConnectionRecoveryManager.java:logException:453) could not execute<br>statement, reason: ERROR: duplicate key value violates unique constraint<br>"publicbundle_pkey", state/code: 23505/0<br>10:22:39,623 INFO [STDOUT] ERROR 03-11 10:22:39,616<br>(BundleDbPersistenceManager.java:storeBundle:1191) failed to write bundle:<br>deadbeef-cafe-babe-cafe-babecafebabe<br>org.postgresql.util.PSQLException: ERROR: duplicate key value violates<br>unique constraint "publicbundle_pkey"<br> at<br>org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)<br> at<br>org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)<br> at<br>org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)<br> at<br>org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)<br> at<br>org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)<br> at<br>org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:371)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:298)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:261)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:239)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1188)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceManager.java:668)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.storeInternal(AbstractBundlePersistenceManager.java:610)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManager.java:487)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:561)<br> at<br>org.apache.jackrabbit.core.state.SharedItemStateManager.createRootNodeState(SharedItemStateManager.java:1672)<br> at<br>org.apache.jackrabbit.core.state.SharedItemStateManager.<init>(SharedItemStateManager.java:207)<br> at<br>org.apache.jackrabbit.core.RepositoryImpl.createItemStateManager(RepositoryImpl.java:1458)<br> at<br>org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(RepositoryImpl.java:2034)<br> at<br>org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:1997)<br> at<br>org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:535)<br> at<br>org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:366)<br> at<br>org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:673)<br> at<br>org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:231)<br> at<br>org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:279)<br> at<br>org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:375)<br> at<br>org.apache.jackrabbit.commons.AbstractRepository.login(AbstractRepository.java:123)<br> at<br>org.drools.guvnor.server.repository.RepositoryStartupService.newSession(RepositoryStartupService.java:151)<br> at<br>org.drools.guvnor.server.repository.RepositoryStartupService.create(RepositoryStartupService.java:72)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at<br>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)<br> at<br>org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)<br> at<br>org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)<br> at<br>org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)<br> at<br>org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)<br> at<br>org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)<br> at<br>org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)<br> at<br>org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)<br> at<br>org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)<br> at<br>org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)<br> at<br>org.drools.guvnor.server.repository.RepositoryStartupService_$$_javassist_1.create(RepositoryStartupService_$$_javassist_1.java)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at<br>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)<br> at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:138)<br> at org.jboss.seam.Component.callComponentMethod(Component.java:2171)<br> at org.jboss.seam.Component.callCreateMethod(Component.java:2094)<br> at org.jboss.seam.Component.newInstance(Component.java:2054)<br> at org.jboss.seam.contexts.Contexts.startup(Contexts.java:304)<br> at org.jboss.seam.contexts.Contexts.startup(Contexts.java:278)<br> at<br>org.jboss.seam.contexts.ServletLifecycle.endInitialization(ServletLifecycle.java:112)<br> at org.jboss.seam.init.Initialization.init(Initialization.java:727)<br> at<br>org.jboss.seam.servlet.SeamListener.contextInitialized(SeamListener.java:34)<br> at<br>org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3856)<br> at<br>org.apache.catalina.core.StandardContext.start(StandardContext.java:4361)<br> at<br>org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790)<br> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770)<br> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at<br>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)<br> at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at org.apache.catalina.core.StandardContext.init(StandardContext.java:5312)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at<br>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)<br> at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at<br>org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:301)<br> at<br>org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104)<br> at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375)<br> at org.jboss.web.WebModule.startModule(WebModule.java:83)<br> at org.jboss.web.WebModule.startService(WebModule.java:61)<br> at<br>org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)<br> at<br>org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)<br> at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBea<br>10:22:39,624 INFO [STDOUT] nServerImpl.invoke(MBeanServerImpl.java:659)<br> at<br>org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)<br> at $Proxy0.start(Unknown Source)<br> at org.jboss.system.ServiceController.start(ServiceController.java:417)<br> at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)<br> at $Proxy44.start(Unknown Source)<br> at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at<br>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at<br>org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br> at<br>org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)<br> at<br>org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)<br> at<br>org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)<br> at<br>org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87)<br> at<br>org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)<br> at<br>org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)<br> at $Proxy45.start(Unknown Source)<br> at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)<br> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)<br> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)<br> at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at<br>org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br> at<br>org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)<br> at $Proxy9.deploy(Unknown Source)<br> at<br>org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)<br> at<br>org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)<br> at<br>org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)<br> at<br>org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)<br> at<br>org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)<br> at<br>org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)<br> at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at<br>org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)<br> at $Proxy0.start(Unknown Source)<br> at org.jboss.system.ServiceController.start(ServiceController.java:417)<br> at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)<br> at $Proxy4.start(Unknown Source)<br> at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)<br> at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)<br> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)<br> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)<br> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at<br>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at<br>org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br> at<br>org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)<br> at $Proxy5.deploy(Unknown Source)<br> at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)<br> at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)<br> at org.jboss.Main.boot(Main.java:200)<br> at org.jboss.Main$1.run(Main.java:508)<br> at java.lang.Thread.run(Thread.java:636)<br>10:22:40,148 INFO [STDOUT] ERROR 03-11 10:22:40,146<br>(ConnectionRecoveryManager.java:logException:453) could not execute<br>statement, reason: ERROR: duplicate key value violates unique constraint<br>"publicbundle_pkey", state/code: 23505/0<br>10:22:40,154 INFO [STDOUT] ERROR 03-11 10:22:40,149<br>(BundleDbPersistenceManager.java:storeBundle:1191) failed to write bundle:<br>deadbeef-cafe-babe-cafe-babecafebabe<br>org.postgresql.util.PSQLException: ERROR: duplicate key value violates<br>unique constraint "publicbundle_pkey"<br> at<br>org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)<br> at<br>org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)<br> at<br>org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)<br> at<br>org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)<br> at<br>org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)<br> at<br>org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:371)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:298)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:261)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:239)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1188)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceManager.java:668)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.storeInternal(AbstractBundlePersistenceManager.java:610)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManager.java:487)<br> at<br>org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:561)<br> at<br>org.apache.jackrabbit.core.state.SharedItemStateManager.createRootNodeState(SharedItemStateManager.java:1672)<br> at<br>org.apache.jackrabbit.core.state.SharedItemStateManager.<init>(SharedItemStateManager.java:207)<br> at<br>org.apache.jackrabbit.core.RepositoryImpl.createItemStateManager(RepositoryImpl.java:1458)<br> at<br>org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(RepositoryImpl.java:2034)<br> at<br>org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:1997)<br> at<br>org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:535)<br> at<br>org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:366)<br> at<br>org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:673)<br> at<br>org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:231)<br> at<br>org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:279)<br> at<br>org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:375)<br> at<br>org.apache.jackrabbit.commons.AbstractRepository.login(AbstractRepository.java:123)<br> at<br>org.drools.guvnor.server.repository.RepositoryStartupService.newSession(RepositoryStartupService.java:151)<br> at<br>org.drools.guvnor.server.repository.RepositoryStartupService.create(RepositoryStartupService.java:72)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at<br>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)<br> at<br>org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)<br> at<br>org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)<br> at<br>org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)<br> at<br>org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)<br> at<br>org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)<br> at<br>org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)<br> at<br>org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)<br> at<br>org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)<br> at<br>org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)<br> at<br>org.drools.guvnor.server.repository.RepositoryStartupService_$$_javassist_1.create(RepositoryStartupService_$$_javassist_1.java)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at<br>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)<br> at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:138)<br> at org.jboss.seam.Component.callComponentMethod(Component.java:2171)<br> at org.jboss.seam.Component.callCreateMethod(Component.java:2094)<br> at org.jboss.seam.Component.newInstance(Component.java:2054)<br> at org.jboss.seam.contexts.Contexts.startup(Contexts.java:304)<br> at org.jboss.seam.contexts.Contexts.startup(Contexts.java:278)<br> at<br>org.jboss.seam.contexts.ServletLifecycle.endInitialization(ServletLifecycle.java:112)<br> at org.jboss.seam.init.Initialization.init(Initialization.java:727)<br> at<br>org.jboss.seam.servlet.SeamListener.contextInitialized(SeamListener.java:34)<br> at<br>org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3856)<br> at<br>org.apache.catalina.core.StandardContext.start(StandardContext.java:4361)<br> at<br>org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790)<br> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770)<br> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at<br>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)<br> at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at org.apache.catalina.core.StandardContext.init(StandardContext.java:5312)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at<br>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)<br> at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at<br>org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:301)<br> at<br>org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104)<br> at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375)<br> at org.jboss.web.WebModule.startModule(WebModule.java:83)<br> at org.jboss.web.WebModule.startService(WebModule.java:61)<br> at<br>org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)<br> at<br>org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)<br> at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBea<br>10:22:40,155 INFO [STDOUT] nServerImpl.invoke(MBeanServerImpl.java:659)<br> at<br>org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)<br> at $Proxy0.start(Unknown Source)<br> at org.jboss.system.ServiceController.start(ServiceController.java:417)<br> at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)<br> at $Proxy44.start(Unknown Source)<br> at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at<br>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at<br>org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br> at<br>org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)<br> at<br>org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)<br> at<br>org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)<br> at<br>org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87)<br> at<br>org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)<br> at<br>org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)<br> at $Proxy45.start(Unknown Source)<br> at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)<br> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)<br> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)<br> at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at<br>org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br> at<br>org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)<br> at $Proxy9.deploy(Unknown Source)<br> at<br>org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)<br> at<br>org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)<br> at<br>org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)<br> at<br>org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)<br> at<br>org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)<br> at<br>org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)<br> at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at<br>org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)<br> at $Proxy0.start(Unknown Source)<br> at org.jboss.system.ServiceController.start(ServiceController.java:417)<br> at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)<br> at $Proxy4.start(Unknown Source)<br> at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)<br> at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)<br> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)<br> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)<br> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at<br>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at<br>org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)<br> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)<br> at<br>org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br> at<br>org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)<br> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br> at<br>org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)<br> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)<br> at $Proxy5.deploy(Unknown Source)<br> at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)<br> at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)<br> at org.jboss.Main.boot(Main.java:200)<br> at org.jboss.Main$1.run(Main.java:508)<br> at java.lang.Thread.run(Thread.java:636)<br><br><br>If someone could please help to know where DROOLS has the SQL file that<br>INSERTS all these data maybe we can fix it<br><br>regards<br><br>Adrian<br><br>-- <br>View this message in context: http://drools-java-rules-engine.46999.n3.nabble.com/DROOLS-5-1-JBOSS-4-2-3-POSTGRES-DUPLICATE-KEY-ERROR-tp1835720p1835720.html<br>Sent from the Drools - User mailing list archive at Nabble.com.<br>_______________________________________________<br>rules-users mailing list<br>rules-users@lists.jboss.org<br>https://lists.jboss.org/mailman/listinfo/rules-users<br></div></div></body></html>