[rules-users] DROOLS 5.1 JBOSS 4.2.3 POSTGRES DUPLICATE KEY ERROR

Adrian Cadena - Fugu Ecuador ac at fugu.ec
Wed Nov 3 16:52:50 EDT 2010


Hello we have solved this ourselves. 


turns out the code im going to paste has a very important line : 

<param name="schemaObjectPrefix" value="version_"/> for versioning change 

<param name="schemaObjectPrefix" value="default_"/> for persistence 

<param name="schemaObjectPrefix" value="data_"/> for data saving 

this param appears on any configuration you wouls like to change into the repository.xml file 

whether you want to change only persistence , or pooling or data saving on the repository yoiu must put different values for it 

This is it , 

regards 

Adrian 


----- Original Message ----- 
From: "fugu" <ac at fugu.ec> 
To: rules-users at lists.jboss.org 
Sent: Wednesday, November 3, 2010 10:51:05 AM 
Subject: [rules-users] DROOLS 5.1 JBOSS 4.2.3 POSTGRES DUPLICATE KEY ERROR 


Hello everybody 

We are setting up DROOLS 5-1+JBOS4.2.3+POSTGRES 8.4 

When server starts up we get this error 

10:22:37,228 ERROR [STDERR] SLF4J: Found binding in 
[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] 
10:22:37,228 ERROR [STDERR] SLF4J: See 
http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 
10:22:39,609 INFO [STDOUT] ERROR 03-11 10:22:39,601 
(ConnectionRecoveryManager.java:logException:453) could not execute 
statement, reason: ERROR: duplicate key value violates unique constraint 
"publicbundle_pkey", state/code: 23505/0 
10:22:39,623 INFO [STDOUT] ERROR 03-11 10:22:39,616 
(BundleDbPersistenceManager.java:storeBundle:1191) failed to write bundle: 
deadbeef-cafe-babe-cafe-babecafebabe 
org.postgresql.util.PSQLException: ERROR: duplicate key value violates 
unique constraint "publicbundle_pkey" 
at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) 
at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) 
at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) 
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) 
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) 
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343) 
at 
org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:371) 
at 
org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:298) 
at 
org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:261) 
at 
org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:239) 
at 
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1188) 
at 
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceManager.java:668) 
at 
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.storeInternal(AbstractBundlePersistenceManager.java:610) 
at 
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManager.java:487) 
at 
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:561) 
at 
org.apache.jackrabbit.core.state.SharedItemStateManager.createRootNodeState(SharedItemStateManager.java:1672) 
at 
org.apache.jackrabbit.core.state.SharedItemStateManager.<init>(SharedItemStateManager.java:207) 
at 
org.apache.jackrabbit.core.RepositoryImpl.createItemStateManager(RepositoryImpl.java:1458) 
at 
org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(RepositoryImpl.java:2034) 
at 
org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:1997) 
at 
org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:535) 
at 
org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:366) 
at 
org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:673) 
at 
org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:231) 
at 
org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:279) 
at 
org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:375) 
at 
org.apache.jackrabbit.commons.AbstractRepository.login(AbstractRepository.java:123) 
at 
org.drools.guvnor.server.repository.RepositoryStartupService.newSession(RepositoryStartupService.java:151) 
at 
org.drools.guvnor.server.repository.RepositoryStartupService.create(RepositoryStartupService.java:72) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at org.jboss.seam.util.Reflections.invoke(Reflections.java:22) 
at 
org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31) 
at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) 
at 
org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) 
at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) 
at 
org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) 
at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) 
at 
org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) 
at 
org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166) 
at 
org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102) 
at 
org.drools.guvnor.server.repository.RepositoryStartupService_$$_javassist_1.create(RepositoryStartupService_$$_javassist_1.java) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at org.jboss.seam.util.Reflections.invoke(Reflections.java:22) 
at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:138) 
at org.jboss.seam.Component.callComponentMethod(Component.java:2171) 
at org.jboss.seam.Component.callCreateMethod(Component.java:2094) 
at org.jboss.seam.Component.newInstance(Component.java:2054) 
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:304) 
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:278) 
at 
org.jboss.seam.contexts.ServletLifecycle.endInitialization(ServletLifecycle.java:112) 
at org.jboss.seam.init.Initialization.init(Initialization.java:727) 
at 
org.jboss.seam.servlet.SeamListener.contextInitialized(SeamListener.java:34) 
at 
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3856) 
at 
org.apache.catalina.core.StandardContext.start(StandardContext.java:4361) 
at 
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790) 
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770) 
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296) 
at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at org.apache.catalina.core.StandardContext.init(StandardContext.java:5312) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296) 
at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at 
org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:301) 
at 
org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104) 
at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375) 
at org.jboss.web.WebModule.startModule(WebModule.java:83) 
at org.jboss.web.WebModule.startService(WebModule.java:61) 
at 
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289) 
at 
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245) 
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBea 
10:22:39,624 INFO [STDOUT] nServerImpl.invoke(MBeanServerImpl.java:659) 
at 
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978) 
at $Proxy0.start(Unknown Source) 
at org.jboss.system.ServiceController.start(ServiceController.java:417) 
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) 
at $Proxy44.start(Unknown Source) 
at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at 
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) 
at 
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142) 
at 
org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97) 
at 
org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238) 
at 
org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87) 
at 
org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188) 
at 
org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) 
at $Proxy45.start(Unknown Source) 
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025) 
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819) 
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782) 
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at 
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) 
at 
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) 
at $Proxy9.deploy(Unknown Source) 
at 
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421) 
at 
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634) 
at 
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263) 
at 
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336) 
at 
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289) 
at 
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245) 
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at 
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978) 
at $Proxy0.start(Unknown Source) 
at org.jboss.system.ServiceController.start(ServiceController.java:417) 
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) 
at $Proxy4.start(Unknown Source) 
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304) 
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025) 
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819) 
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782) 
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at 
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) 
at 
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) 
at $Proxy5.deploy(Unknown Source) 
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482) 
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362) 
at org.jboss.Main.boot(Main.java:200) 
at org.jboss.Main$1.run(Main.java:508) 
at java.lang.Thread.run(Thread.java:636) 
10:22:40,148 INFO [STDOUT] ERROR 03-11 10:22:40,146 
(ConnectionRecoveryManager.java:logException:453) could not execute 
statement, reason: ERROR: duplicate key value violates unique constraint 
"publicbundle_pkey", state/code: 23505/0 
10:22:40,154 INFO [STDOUT] ERROR 03-11 10:22:40,149 
(BundleDbPersistenceManager.java:storeBundle:1191) failed to write bundle: 
deadbeef-cafe-babe-cafe-babecafebabe 
org.postgresql.util.PSQLException: ERROR: duplicate key value violates 
unique constraint "publicbundle_pkey" 
at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) 
at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) 
at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) 
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) 
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) 
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343) 
at 
org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:371) 
at 
org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:298) 
at 
org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:261) 
at 
org.apache.jackrabbit.core.persistence.bundle.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:239) 
at 
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1188) 
at 
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceManager.java:668) 
at 
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.storeInternal(AbstractBundlePersistenceManager.java:610) 
at 
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManager.java:487) 
at 
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:561) 
at 
org.apache.jackrabbit.core.state.SharedItemStateManager.createRootNodeState(SharedItemStateManager.java:1672) 
at 
org.apache.jackrabbit.core.state.SharedItemStateManager.<init>(SharedItemStateManager.java:207) 
at 
org.apache.jackrabbit.core.RepositoryImpl.createItemStateManager(RepositoryImpl.java:1458) 
at 
org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(RepositoryImpl.java:2034) 
at 
org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:1997) 
at 
org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:535) 
at 
org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:366) 
at 
org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:673) 
at 
org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:231) 
at 
org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:279) 
at 
org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:375) 
at 
org.apache.jackrabbit.commons.AbstractRepository.login(AbstractRepository.java:123) 
at 
org.drools.guvnor.server.repository.RepositoryStartupService.newSession(RepositoryStartupService.java:151) 
at 
org.drools.guvnor.server.repository.RepositoryStartupService.create(RepositoryStartupService.java:72) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at org.jboss.seam.util.Reflections.invoke(Reflections.java:22) 
at 
org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31) 
at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) 
at 
org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) 
at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) 
at 
org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) 
at 
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) 
at 
org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) 
at 
org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166) 
at 
org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102) 
at 
org.drools.guvnor.server.repository.RepositoryStartupService_$$_javassist_1.create(RepositoryStartupService_$$_javassist_1.java) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at org.jboss.seam.util.Reflections.invoke(Reflections.java:22) 
at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:138) 
at org.jboss.seam.Component.callComponentMethod(Component.java:2171) 
at org.jboss.seam.Component.callCreateMethod(Component.java:2094) 
at org.jboss.seam.Component.newInstance(Component.java:2054) 
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:304) 
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:278) 
at 
org.jboss.seam.contexts.ServletLifecycle.endInitialization(ServletLifecycle.java:112) 
at org.jboss.seam.init.Initialization.init(Initialization.java:727) 
at 
org.jboss.seam.servlet.SeamListener.contextInitialized(SeamListener.java:34) 
at 
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3856) 
at 
org.apache.catalina.core.StandardContext.start(StandardContext.java:4361) 
at 
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790) 
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770) 
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296) 
at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at org.apache.catalina.core.StandardContext.init(StandardContext.java:5312) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296) 
at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at 
org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:301) 
at 
org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104) 
at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375) 
at org.jboss.web.WebModule.startModule(WebModule.java:83) 
at org.jboss.web.WebModule.startService(WebModule.java:61) 
at 
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289) 
at 
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245) 
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBea 
10:22:40,155 INFO [STDOUT] nServerImpl.invoke(MBeanServerImpl.java:659) 
at 
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978) 
at $Proxy0.start(Unknown Source) 
at org.jboss.system.ServiceController.start(ServiceController.java:417) 
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) 
at $Proxy44.start(Unknown Source) 
at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at 
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) 
at 
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142) 
at 
org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97) 
at 
org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238) 
at 
org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87) 
at 
org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188) 
at 
org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) 
at $Proxy45.start(Unknown Source) 
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025) 
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819) 
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782) 
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at 
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) 
at 
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) 
at $Proxy9.deploy(Unknown Source) 
at 
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421) 
at 
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634) 
at 
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263) 
at 
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336) 
at 
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289) 
at 
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245) 
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at 
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978) 
at $Proxy0.start(Unknown Source) 
at org.jboss.system.ServiceController.start(ServiceController.java:417) 
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) 
at $Proxy4.start(Unknown Source) 
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304) 
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025) 
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819) 
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782) 
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:616) 
at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) 
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) 
at 
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) 
at 
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142) 
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) 
at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) 
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) 
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) 
at $Proxy5.deploy(Unknown Source) 
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482) 
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362) 
at org.jboss.Main.boot(Main.java:200) 
at org.jboss.Main$1.run(Main.java:508) 
at java.lang.Thread.run(Thread.java:636) 


If someone could please help to know where DROOLS has the SQL file that 
INSERTS all these data maybe we can fix it 

regards 

Adrian 

-- 
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 
Sent from the Drools - User mailing list archive at Nabble.com. 
_______________________________________________ 
rules-users mailing list 
rules-users at lists.jboss.org 
https://lists.jboss.org/mailman/listinfo/rules-users 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20101103/6b989ab7/attachment.html 


More information about the rules-users mailing list