Overview

You have installed Aurea Process (formerly known as CX Process, Savvion and SBM) 2019 R2 with PostgreSQL, embedded TomEE 7.0.2 and JDK 1.8.x.  When you try to start the Aurea Process server it is failing with an Error initializing Document Management Service and Error Initializing the sequences errors as shown below:

SEVERE [<username>-startStop-1] org.apache.openejb.core.transaction.EjbTransactionUtil.handleSystemException EjbTransactionUtil.handleSystemException: (3062) Error initializing Document Management Service.; context(BLControl.initSDMS())java.lang.RuntimeException: (038) Error initializing the sequences(DBResource.initSequence()) 
 com.savvion.sbm.bizlogic.util.BizLogicException: (3062) Error initializing Document Management Service.; context(BLControl.initSDMS())java.lang.RuntimeException: (038) Error initializing the sequences(DBResource.initSequence()) 
        at com.savvion.sbm.bizlogic.util.BLControl.initSDMS(BLControl.java:696) 
        at com.savvion.sbm.bizlogic.server.ejb.ServiceBean.initSDMS(ServiceBean.java:531) 
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
        at java.lang.reflect.Method.invoke(Method.java:497) 
        at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:205) 
        at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:186) 
        at org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:181) 
        at org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:100) 
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
        at java.lang.reflect.Method.invoke(Method.java:497) 
        at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:205) 
        at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:186) 
        at org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:85) 
        at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:252) 
        at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:212) 
        at org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:265) 
        at org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:260) 
        at org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:89) 
        at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:347) 
        at com.sun.proxy.$Proxy138.initSDMS(Unknown Source) 
        at com.savvion.sbm.bizlogic.util.BLControl.init(BLControl.java:627) 
        at com.savvion.sbm.bizlogic.util.BLControl.initAll(BLControl.java:768) 
        at com.savvion.sbm.bizlogic.util.BLControl.start(BLControl.java:741) 
        at com.savvion.sbm.bizlogic.util.BLControl.start(BLControl.java:721) 
        at com.savvion.sbm.bizlogic.web.util.BLWebUtil.startSingleServer(BLWebUtil.java:124) 
        at com.savvion.sbm.bizlogic.web.util.BLWebUtil.startBizLogic(BLWebUtil.java:95) 
        at com.savvion.sbm.bizlogic.web.listener.BLContextListener.contextInitialized(BLContextListener.java:60) 
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745) 
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207) 
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) 
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1419) 
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1409) 
        at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
        at java.lang.Thread.run(Thread.java:745) 
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: (038) Error initializing the sequences(DBResource.initSequence()) 
        at com.savvion.sbm.dms.DocumentServiceFactory.getInstance(DocumentServiceFactory.java:180) 
        at com.savvion.sbm.bizlogic.util.BLDocClient.init(BLDocClient.java:142) 
        at com.savvion.sbm.bizlogic.util.BLDocService.init(BLDocService.java:47) 
        at com.savvion.sbm.bizlogic.util.BLControl.initSDMS(BLControl.java:693) 
        ... 39 more 
Caused by: java.lang.RuntimeException: (038) Error initializing the sequences(DBResource.initSequence()) 
        at com.savvion.sbm.dms.util.DSExceptionHandler.createRuntimeException(DSExceptionHandler.java:107) 
        at com.savvion.sbm.dms.sds.util.DBResource.initSequence(DBResource.java:166) 
        at com.savvion.sbm.dms.sds.util.DBResource.<init>(DBResource.java:114) 
        at com.savvion.sbm.dms.DocumentServiceFactory.getInstance(DocumentServiceFactory.java:166) 
        ... 42 more 
Caused by: org.postgresql.util.PSQLException: ERROR: relation "document_sequence" already exists 
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) 
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) 
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) 
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) 
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) 
        at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303) 
        at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289) 
        at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266) 
        at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:246) 
        at com.savvion.sbm.util.Sequence.createSequenceInDB(Sequence.java:373) 
        at com.savvion.sbm.util.Sequence.init(Sequence.java:292) 
        at com.savvion.sbm.util.Sequence.<init>(Sequence.java:223) 
        at com.savvion.sbm.util.Sequence.<init>(Sequence.java:210) 
        at com.savvion.sbm.dms.sds.util.DBResource.initSequence(DBResource.java:150) 
        ... 44 more

Solution

This issue has been identified in Aurea Process 2019 R2 and fixed as of the Aurea Process 2021 R1 release.  To resolve this issue with please upgrade to Aurea Process 2021 R1 or later release.

Testing

After upgrading to Aurea Process 2021 R1 with PostgreSQL and TomEE, you are able to start the Aurea Process server without issue.