CMDBuild Forum

Shark Workflow issue with OpenMAINT

Hello,

I've been trying to get OpenMAINT up and running properly but have been having trouble getting Shark to work.  When I log into the Data Management module I get several error messages that some Classes are not found.  The are the classes that are under the Process tab in the Administration Module.

 

I've followed the instructions in the Technical Manual and made the appropriate modifications for Shark to run with the OpenMAINT database.  I have the Shark scheme properly set up with the Shark user.  Tomcat is running as root.  The appropriate config files have been changed.  The information in the Setup tab for shark was changed.  I did manual install.

 

I get this block of output for shark startup in catalina.out

 

<code>

Shark will be configured from file /opt/tomcat/webapps/shark/conf/Shark.conf

environmentType= tomcat

    t= org.objectweb.jotm.Current@57dd1ccb

        pre configure . . . . . .

 

Together Workflow Server 4.4-1

 

SharkEngineManager -> Shark engine is being initialized ...

com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery._runQuery(Unknown Source)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.runQuery(Unknown Source)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.getNextDO(Unknown Source)

        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.__refreshCache(Unknown Source)

        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.refreshCache(Unknown Source)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.refreshDOCaches(Unknown Source)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.setLDBName(Unknown Source)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.configure(Unknown Source)

        at org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager.configure(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)

        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:498)

        at org.enhydra.shark.Shark._conf(Unknown Source)

        at org.enhydra.shark.Shark.configure(Unknown Source)

        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)

        at javax.servlet.GenericServlet.init(GenericServlet.java:158)

        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)

        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)

        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)

        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)

        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)

        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
Caused by: java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        ... 36 more
*** Caused by:
java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery._runQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.runQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.getNextDO(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.__refreshCache(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.refreshCache(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.refreshDOCaches(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.setLDBName(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.configure(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager.configure(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
*** Caused by:
java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery._runQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.runQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.getNextDO(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.__refreshCache(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.refreshCache(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.refreshDOCaches(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.setLDBName(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.configure(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager.configure(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery._runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.getDOArray(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getAllXPDLs(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getExistingXPDLIds(Unknown Source)
        at org.enhydra.shark.SharkUtilities.synchronizeXPDLCache(Unknown Source)
        at org.enhydra.shark.SharkUtilities.restorePackages(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.initCaches(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
Caused by: java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        ... 34 more
*** Caused by:
java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery._runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.getDOArray(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getAllXPDLs(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getExistingXPDLIds(Unknown Source)
        at org.enhydra.shark.SharkUtilities.synchronizeXPDLCache(Unknown Source)
        at org.enhydra.shark.SharkUtilities.restorePackages(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.initCaches(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
org.enhydra.shark.api.internal.repositorypersistence.RepositoryException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getExistingXPDLIds(Unknown Source)
        at org.enhydra.shark.SharkUtilities.synchronizeXPDLCache(Unknown Source)
        at org.enhydra.shark.SharkUtilities.synchronizeXPDLCache(Unknown Source)
        at org.enhydra.shark.SharkUtilities.restorePackages(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.initCaches(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
Caused by: com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery._runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.getDOArray(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getAllXPDLs(Unknown Source)
        ... 30 more
Caused by: java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        ... 34 more
Shark -> shark engine initialization is finished, it lasted 3 [s]
Shark -> Shark ready and waiting ...
        pre getConnection . . . . . .
        pre commit . . . . . .
++++++++++++++++++++++++++++++++++++++ init - end
01-Jun-2017 16:08:46.197 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/opt/tomcat/webapps/shark.war] has finished in [10,251] ms
</code>
 
and I get this information in cmdbuild.log
 
<code>
INFO  2017-06-01 16:17:16 [workflow] getting all active process classes
INFO  2017-06-01 16:17:16 [workflow] getting all process classes
INFO  2017-06-01 16:17:20 [workflow] getting all process classes
WARN  2017-06-01 16:17:21 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO  2017-06-01 16:17:21 [workflow] getting process class with name 'Activity'
ERROR 2017-06-01 16:17:21 [jsonrpc ] Error retrieving start activity for process
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'WarehouseManagement' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO  2017-06-01 16:17:27 [workflow] getting process class with name 'Activity'
ERROR 2017-06-01 16:17:27 [jsonrpc ] Error retrieving start activity for process
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Workorder' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'PurchaseRequest' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'WarehouseManagement' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Workorder' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'QRCodeGen' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'PurchaseRequest' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'MaintCalGenerator' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'QRCodeGen' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'MaintCalGenerator' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'MaintenanceRequest' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'WOGen' is startable
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'MaintenanceRequest' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:28 [cmdbuild] Cannot fetch if the process 'WOGen' is startable
 
</code>
 
and finally in the shark.log file
 
<code>
2017-06-01 16:08:42,751: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API
2017-06-01 16:08:42,751: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactoryExt' implementation of core SharkObjectFactory API
2017-06-01 16:08:42,752: SharkEngineManager -> Working with 'org.enhydra.shark.StandardToolActivityHandler' implementation of core ToolAgentManager API
2017-06-01 16:08:42,752: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API
2017-06-01 16:08:43,264: StandardAssignmentManager -> Working with 'org.enhydra.shark.usergroup.DODSUserGroupManagerAdmin' implementation of UserGroup API
2017-06-01 16:08:43,358: StandardAssignmentManager -> Working with 'org.enhydra.shark.partmappersistence.DODSParticipantMappingAdmin' implementation of ParticipantMapping API
2017-06-01 16:08:43,358: SharkEngineManager -> Working with 'org.enhydra.shark.assignment.StandardAssignmentManager' implementation of Assignment API
2017-06-01 16:08:43,362: Process Cache configured - max. size is 100
2017-06-01 16:08:43,363: Resource Cache configured - max. size is 100
2017-06-01 16:08:43,363: SharkEngineManager -> Working with 'org.enhydra.shark.caching.LRUCacheMgr' implementation of Caching API
2017-06-01 16:08:43,642:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkprocessstates)
2017-06-01 16:08:43,652:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
2017-06-01 16:08:43,671: DODSPersistentManager -> persisting String variables into BLOB for sizes greater than 4000
2017-06-01 16:08:43,671: SharkEngineManager -> Working with 'org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager' implementation of InstancePersistence API
2017-06-01 16:08:43,697: DODSGlobalPersistenceManager -> persisting String data into BLOB for sizes greater than 4000
2017-06-01 16:08:43,697: SharkEngineManager -> Working with 'org.enhydra.shark.globalpersistence.DODSGlobalPersistenceManager' implementation of GlobalPersistence API
2017-06-01 16:08:45,851: SharkEngineManager -> Working with 'org.cmdbuild.workflow.CMDBuildEventAuditManager' implementation of EventAudit API
2017-06-01 16:08:45,924: SharkEngineManager -> Working with 'org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager' implementation of RepositoryPersistence API
2017-06-01 16:08:45,928: SharkEngineManager -> Working with 'org.enhydra.shark.scripting.StandardScriptingManager' implementation of Scripting API
2017-06-01 16:08:45,928: SharkEngineManager -> Working without Security API implementation - SecurityManager is not specified.
2017-06-01 16:08:46,092: StandardToolAgentManager -> Working with 'org.enhydra.shark.appmappersistence.DODSApplicationMappingAdmin' implementation of ApplicationMapPersistence API
2017-06-01 16:08:46,092: SharkEngineManager -> Working with 'org.enhydra.shark.toolagent.StandardToolAgentManager' implementation of ToolAgentManager API
2017-06-01 16:08:46,092: SharkEngineManager -> Working without wfEngineInteroperability API implementation - WfEngineInteroperability implementation is not specified.
2017-06-01 16:08:46,111: SharkUtilities -> synchronizing XPDL cache
2017-06-01 16:08:46,139:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
2017-06-01 16:08:46,140: Problem while initializing caches !!!
2017-06-01 16:17:20,777:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:20,915:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:20,939:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:20,964:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:20,981:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,009:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,039:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,069:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,088:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,102:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,610:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,746:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,819:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,858:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,992:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,032:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,099:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,141:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,186:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,212:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,252:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,329:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,356:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,384:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,406:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,450:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,502:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,526:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,559:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,570:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,610:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,627:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
</code>
 
 
 
Any help would be appreciated!
So it appears I had a bit of a database issue that didn't get flushed out on my first pass of dropping and rebuilding.  Everything seems to be working now!
 
Previously Sam wrote:

Hello,

I've been trying to get OpenMAINT up and running properly but have been having trouble getting Shark to work.  When I log into the Data Management module I get several error messages that some Classes are not found.  The are the classes that are under the Process tab in the Administration Module.

 

I've followed the instructions in the Technical Manual and made the appropriate modifications for Shark to run with the OpenMAINT database.  I have the Shark scheme properly set up with the Shark user.  Tomcat is running as root.  The appropriate config files have been changed.  The information in the Setup tab for shark was changed.  I did manual install.

 

I get this block of output for shark startup in catalina.out

 

<code>

Shark will be configured from file /opt/tomcat/webapps/shark/conf/Shark.conf

environmentType= tomcat

    t= org.objectweb.jotm.Current@57dd1ccb

        pre configure . . . . . .

 

Together Workflow Server 4.4-1

 

SharkEngineManager -> Shark engine is being initialized ...

com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery._runQuery(Unknown Source)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.runQuery(Unknown Source)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.getNextDO(Unknown Source)

        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.__refreshCache(Unknown Source)

        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.refreshCache(Unknown Source)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.refreshDOCaches(Unknown Source)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.setLDBName(Unknown Source)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.configure(Unknown Source)

        at org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager.configure(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)

        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:498)

        at org.enhydra.shark.Shark._conf(Unknown Source)

        at org.enhydra.shark.Shark.configure(Unknown Source)

        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)

        at javax.servlet.GenericServlet.init(GenericServlet.java:158)

        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)

        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)

        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)

        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)

        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)

        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
Caused by: java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        ... 36 more
*** Caused by:
java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery._runQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.runQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.getNextDO(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.__refreshCache(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.refreshCache(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.refreshDOCaches(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.setLDBName(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.configure(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager.configure(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
*** Caused by:
java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery._runQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.runQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.getNextDO(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.__refreshCache(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.refreshCache(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.refreshDOCaches(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.setLDBName(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.configure(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager.configure(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery._runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.getDOArray(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getAllXPDLs(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getExistingXPDLIds(Unknown Source)
        at org.enhydra.shark.SharkUtilities.synchronizeXPDLCache(Unknown Source)
        at org.enhydra.shark.SharkUtilities.restorePackages(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.initCaches(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
Caused by: java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        ... 34 more
*** Caused by:
java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery._runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.getDOArray(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getAllXPDLs(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getExistingXPDLIds(Unknown Source)
        at org.enhydra.shark.SharkUtilities.synchronizeXPDLCache(Unknown Source)
        at org.enhydra.shark.SharkUtilities.restorePackages(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.initCaches(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
org.enhydra.shark.api.internal.repositorypersistence.RepositoryException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getExistingXPDLIds(Unknown Source)
        at org.enhydra.shark.SharkUtilities.synchronizeXPDLCache(Unknown Source)
        at org.enhydra.shark.SharkUtilities.synchronizeXPDLCache(Unknown Source)
        at org.enhydra.shark.SharkUtilities.restorePackages(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.initCaches(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
Caused by: com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery._runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.getDOArray(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getAllXPDLs(Unknown Source)
        ... 30 more
Caused by: java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        ... 34 more
Shark -> shark engine initialization is finished, it lasted 3 [s]
Shark -> Shark ready and waiting ...
        pre getConnection . . . . . .
        pre commit . . . . . .
++++++++++++++++++++++++++++++++++++++ init - end
01-Jun-2017 16:08:46.197 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/opt/tomcat/webapps/shark.war] has finished in [10,251] ms
</code>
 
and I get this information in cmdbuild.log
 
<code>
INFO  2017-06-01 16:17:16 [workflow] getting all active process classes
INFO  2017-06-01 16:17:16 [workflow] getting all process classes
INFO  2017-06-01 16:17:20 [workflow] getting all process classes
WARN  2017-06-01 16:17:21 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO  2017-06-01 16:17:21 [workflow] getting process class with name 'Activity'
ERROR 2017-06-01 16:17:21 [jsonrpc ] Error retrieving start activity for process
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'WarehouseManagement' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO  2017-06-01 16:17:27 [workflow] getting process class with name 'Activity'
ERROR 2017-06-01 16:17:27 [jsonrpc ] Error retrieving start activity for process
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Workorder' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'PurchaseRequest' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'WarehouseManagement' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Workorder' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'QRCodeGen' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'PurchaseRequest' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'MaintCalGenerator' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'QRCodeGen' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'MaintCalGenerator' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'MaintenanceRequest' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'WOGen' is startable
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'MaintenanceRequest' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:28 [cmdbuild] Cannot fetch if the process 'WOGen' is startable
 
</code>
 
and finally in the shark.log file
 
<code>
2017-06-01 16:08:42,751: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API
2017-06-01 16:08:42,751: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactoryExt' implementation of core SharkObjectFactory API
2017-06-01 16:08:42,752: SharkEngineManager -> Working with 'org.enhydra.shark.StandardToolActivityHandler' implementation of core ToolAgentManager API
2017-06-01 16:08:42,752: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API
2017-06-01 16:08:43,264: StandardAssignmentManager -> Working with 'org.enhydra.shark.usergroup.DODSUserGroupManagerAdmin' implementation of UserGroup API
2017-06-01 16:08:43,358: StandardAssignmentManager -> Working with 'org.enhydra.shark.partmappersistence.DODSParticipantMappingAdmin' implementation of ParticipantMapping API
2017-06-01 16:08:43,358: SharkEngineManager -> Working with 'org.enhydra.shark.assignment.StandardAssignmentManager' implementation of Assignment API
2017-06-01 16:08:43,362: Process Cache configured - max. size is 100
2017-06-01 16:08:43,363: Resource Cache configured - max. size is 100
2017-06-01 16:08:43,363: SharkEngineManager -> Working with 'org.enhydra.shark.caching.LRUCacheMgr' implementation of Caching API
2017-06-01 16:08:43,642:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkprocessstates)
2017-06-01 16:08:43,652:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
2017-06-01 16:08:43,671: DODSPersistentManager -> persisting String variables into BLOB for sizes greater than 4000
2017-06-01 16:08:43,671: SharkEngineManager -> Working with 'org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager' implementation of InstancePersistence API
2017-06-01 16:08:43,697: DODSGlobalPersistenceManager -> persisting String data into BLOB for sizes greater than 4000
2017-06-01 16:08:43,697: SharkEngineManager -> Working with 'org.enhydra.shark.globalpersistence.DODSGlobalPersistenceManager' implementation of GlobalPersistence API
2017-06-01 16:08:45,851: SharkEngineManager -> Working with 'org.cmdbuild.workflow.CMDBuildEventAuditManager' implementation of EventAudit API
2017-06-01 16:08:45,924: SharkEngineManager -> Working with 'org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager' implementation of RepositoryPersistence API
2017-06-01 16:08:45,928: SharkEngineManager -> Working with 'org.enhydra.shark.scripting.StandardScriptingManager' implementation of Scripting API
2017-06-01 16:08:45,928: SharkEngineManager -> Working without Security API implementation - SecurityManager is not specified.
2017-06-01 16:08:46,092: StandardToolAgentManager -> Working with 'org.enhydra.shark.appmappersistence.DODSApplicationMappingAdmin' implementation of ApplicationMapPersistence API
2017-06-01 16:08:46,092: SharkEngineManager -> Working with 'org.enhydra.shark.toolagent.StandardToolAgentManager' implementation of ToolAgentManager API
2017-06-01 16:08:46,092: SharkEngineManager -> Working without wfEngineInteroperability API implementation - WfEngineInteroperability implementation is not specified.
2017-06-01 16:08:46,111: SharkUtilities -> synchronizing XPDL cache
2017-06-01 16:08:46,139:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
2017-06-01 16:08:46,140: Problem while initializing caches !!!
2017-06-01 16:17:20,777:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:20,915:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:20,939:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:20,964:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:20,981:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,009:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,039:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,069:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,088:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,102:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,610:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,746:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,819:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,858:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,992:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,032:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,099:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,141:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,186:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,212:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,252:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,329:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,356:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,384:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,406:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,450:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,502:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,526:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,559:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,570:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,610:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,627:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
</code>
 
 
 
Any help would be appreciated!

 

Hello Sam,

 
  What issues? Can you tell me how you  resolved this? I think that I have the same problem.
 
Kind regards
 
 
 

 

Hi,

 

How did you resolve this problem. I am facing the same error.

 

 

Previously Sam wrote:
So it appears I had a bit of a database issue that didn't get flushed out on my first pass of dropping and rebuilding.  Everything seems to be working now!
 
Previously Sam wrote:

Hello,

I've been trying to get OpenMAINT up and running properly but have been having trouble getting Shark to work.  When I log into the Data Management module I get several error messages that some Classes are not found.  The are the classes that are under the Process tab in the Administration Module.

 

I've followed the instructions in the Technical Manual and made the appropriate modifications for Shark to run with the OpenMAINT database.  I have the Shark scheme properly set up with the Shark user.  Tomcat is running as root.  The appropriate config files have been changed.  The information in the Setup tab for shark was changed.  I did manual install.

 

I get this block of output for shark startup in catalina.out

 

<code>

Shark will be configured from file /opt/tomcat/webapps/shark/conf/Shark.conf

environmentType= tomcat

    t= org.objectweb.jotm.Current@57dd1ccb

        pre configure . . . . . .

 

Together Workflow Server 4.4-1

 

SharkEngineManager -> Shark engine is being initialized ...

com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery._runQuery(Unknown Source)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.runQuery(Unknown Source)

        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.getNextDO(Unknown Source)

        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.__refreshCache(Unknown Source)

        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.refreshCache(Unknown Source)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.refreshDOCaches(Unknown Source)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.setLDBName(Unknown Source)

        at org.enhydra.shark.instancepersistence.DODSPersistentManager.configure(Unknown Source)

        at org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager.configure(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)

        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:498)

        at org.enhydra.shark.Shark._conf(Unknown Source)

        at org.enhydra.shark.Shark.configure(Unknown Source)

        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)

        at javax.servlet.GenericServlet.init(GenericServlet.java:158)

        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)

        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)

        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)

        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)

        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)

        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
Caused by: java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        ... 36 more
*** Caused by:
java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery._runQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.runQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.getNextDO(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.__refreshCache(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.refreshCache(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.refreshDOCaches(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.setLDBName(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.configure(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager.configure(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
*** Caused by:
java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery._runQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.runQuery(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateQuery.getNextDO(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.__refreshCache(Unknown Source)
        at org.enhydra.shark.instancepersistence.data.ProcessStateDO.refreshCache(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.refreshDOCaches(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.setLDBName(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.configure(Unknown Source)
        at org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager.configure(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery._runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.getDOArray(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getAllXPDLs(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getExistingXPDLIds(Unknown Source)
        at org.enhydra.shark.SharkUtilities.synchronizeXPDLCache(Unknown Source)
        at org.enhydra.shark.SharkUtilities.restorePackages(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.initCaches(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
Caused by: java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        ... 34 more
*** Caused by:
java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery._runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.getDOArray(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getAllXPDLs(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getExistingXPDLIds(Unknown Source)
        at org.enhydra.shark.SharkUtilities.synchronizeXPDLCache(Unknown Source)
        at org.enhydra.shark.SharkUtilities.restorePackages(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.initCaches(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
org.enhydra.shark.api.internal.repositorypersistence.RepositoryException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getExistingXPDLIds(Unknown Source)
        at org.enhydra.shark.SharkUtilities.synchronizeXPDLCache(Unknown Source)
        at org.enhydra.shark.SharkUtilities.synchronizeXPDLCache(Unknown Source)
        at org.enhydra.shark.SharkUtilities.restorePackages(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.initCaches(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)
        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)
        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:498)
        at org.enhydra.shark.Shark._conf(Unknown Source)
        at org.enhydra.shark.Shark.configure(Unknown Source)
        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        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:748)
Caused by: com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery._runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.runQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.getDOArray(Unknown Source)
        at org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.getAllXPDLs(Unknown Source)
        ... 30 more
Caused by: java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
        at com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(Unknown Source)
        at org.enhydra.shark.repositorypersistence.data.XPDLQuery.executeQuery(Unknown Source)
        at com.lutris.appserver.server.sql.standard.StandardDBQuery.query(Unknown Source)
        ... 34 more
Shark -> shark engine initialization is finished, it lasted 3 [s]
Shark -> Shark ready and waiting ...
        pre getConnection . . . . . .
        pre commit . . . . . .
++++++++++++++++++++++++++++++++++++++ init - end
01-Jun-2017 16:08:46.197 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/opt/tomcat/webapps/shark.war] has finished in [10,251] ms
</code>
 
and I get this information in cmdbuild.log
 
<code>
INFO  2017-06-01 16:17:16 [workflow] getting all active process classes
INFO  2017-06-01 16:17:16 [workflow] getting all process classes
INFO  2017-06-01 16:17:20 [workflow] getting all process classes
WARN  2017-06-01 16:17:21 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO  2017-06-01 16:17:21 [workflow] getting process class with name 'Activity'
ERROR 2017-06-01 16:17:21 [jsonrpc ] Error retrieving start activity for process
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'WarehouseManagement' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO  2017-06-01 16:17:27 [workflow] getting process class with name 'Activity'
ERROR 2017-06-01 16:17:27 [jsonrpc ] Error retrieving start activity for process
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Workorder' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'PurchaseRequest' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'WarehouseManagement' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Workorder' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'QRCodeGen' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'PurchaseRequest' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'MaintCalGenerator' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'QRCodeGen' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'MaintCalGenerator' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'MaintenanceRequest' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'WOGen' is startable
WARN  2017-06-01 16:17:27 [cmdbuild] Cannot fetch if the process 'MaintenanceRequest' is startable
INFO  2017-06-01 16:17:27 [workflow] getting all process classes
WARN  2017-06-01 16:17:28 [cmdbuild] Cannot fetch if the process 'WOGen' is startable
 
</code>
 
and finally in the shark.log file
 
<code>
2017-06-01 16:08:42,751: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API
2017-06-01 16:08:42,751: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactoryExt' implementation of core SharkObjectFactory API
2017-06-01 16:08:42,752: SharkEngineManager -> Working with 'org.enhydra.shark.StandardToolActivityHandler' implementation of core ToolAgentManager API
2017-06-01 16:08:42,752: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API
2017-06-01 16:08:43,264: StandardAssignmentManager -> Working with 'org.enhydra.shark.usergroup.DODSUserGroupManagerAdmin' implementation of UserGroup API
2017-06-01 16:08:43,358: StandardAssignmentManager -> Working with 'org.enhydra.shark.partmappersistence.DODSParticipantMappingAdmin' implementation of ParticipantMapping API
2017-06-01 16:08:43,358: SharkEngineManager -> Working with 'org.enhydra.shark.assignment.StandardAssignmentManager' implementation of Assignment API
2017-06-01 16:08:43,362: Process Cache configured - max. size is 100
2017-06-01 16:08:43,363: Resource Cache configured - max. size is 100
2017-06-01 16:08:43,363: SharkEngineManager -> Working with 'org.enhydra.shark.caching.LRUCacheMgr' implementation of Caching API
2017-06-01 16:08:43,642:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkprocessstates)
2017-06-01 16:08:43,652:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
2017-06-01 16:08:43,671: DODSPersistentManager -> persisting String variables into BLOB for sizes greater than 4000
2017-06-01 16:08:43,671: SharkEngineManager -> Working with 'org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager' implementation of InstancePersistence API
2017-06-01 16:08:43,697: DODSGlobalPersistenceManager -> persisting String data into BLOB for sizes greater than 4000
2017-06-01 16:08:43,697: SharkEngineManager -> Working with 'org.enhydra.shark.globalpersistence.DODSGlobalPersistenceManager' implementation of GlobalPersistence API
2017-06-01 16:08:45,851: SharkEngineManager -> Working with 'org.cmdbuild.workflow.CMDBuildEventAuditManager' implementation of EventAudit API
2017-06-01 16:08:45,924: SharkEngineManager -> Working with 'org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager' implementation of RepositoryPersistence API
2017-06-01 16:08:45,928: SharkEngineManager -> Working with 'org.enhydra.shark.scripting.StandardScriptingManager' implementation of Scripting API
2017-06-01 16:08:45,928: SharkEngineManager -> Working without Security API implementation - SecurityManager is not specified.
2017-06-01 16:08:46,092: StandardToolAgentManager -> Working with 'org.enhydra.shark.appmappersistence.DODSApplicationMappingAdmin' implementation of ApplicationMapPersistence API
2017-06-01 16:08:46,092: SharkEngineManager -> Working with 'org.enhydra.shark.toolagent.StandardToolAgentManager' implementation of ToolAgentManager API
2017-06-01 16:08:46,092: SharkEngineManager -> Working without wfEngineInteroperability API implementation - WfEngineInteroperability implementation is not specified.
2017-06-01 16:08:46,111: SharkUtilities -> synchronizing XPDL cache
2017-06-01 16:08:46,139:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
2017-06-01 16:08:46,140: Problem while initializing caches !!!
2017-06-01 16:17:20,777:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:20,915:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:20,939:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:20,964:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:20,981:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,009:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,039:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,069:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,088:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,102:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,610:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,746:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,819:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,858:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:21,992:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,032:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,099:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,141:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,186:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:22,212:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,252:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,329:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,356:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,384:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,406:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,450:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,502:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,526:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,559:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,570:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,610:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
2017-06-01 16:17:26,627:  <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: permission denied for relation shkresourcestable)
</code>
 
 
 
Any help would be appreciated!