Unable to start shark for openmaint

devanshu.chakraborty · February 23, 2018, 9:26am

Hi,

I am facing issue in making shark application work with openmaint.

My environment:

- MS Windows 7 Professional 64Bit

- Apache Tomcat 8.5.28

- openmaint-1.1-2.4.3

- PostgeSQL server version 10

Following are the two issues I am facing:

Issue No. 1. Related to OpenMaint

I configured the application by using frontend setup wizard and loaded it with demo data. With that I am able to login but when I login I see a small prompt at right bottom corner which says:

Class RequestForChange not found

Following is the log message in cmdbuild.log

--------------------------------------------------------------------------------------------------------------

INFO 2018-02-23 14:42:48 [jsonrpc ] Calling url /utils/gettranslationobject
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /schema/setup/getconfiguration
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /schema/setup/getconfiguration
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /bim/rootclassname
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /schema/setup/getconfiguration
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /schema/setup/getconfiguration
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /gis/getgistreenavigation
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /utils/listavailabletranslations
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /schema/setup/getconfiguration
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /schema/setup/getconfiguration
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /schema/modsecurity/getuiconfiguration
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /schema/setup/getconfiguration
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /schema/modclass/getallclasses
INFO 2018-02-23 14:42:49 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /dashboard/list
INFO 2018-02-23 14:42:49 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:49 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:49 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:49 [workflow] getting all active process classes
INFO 2018-02-23 14:42:49 [workflow] getting all process classes
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /schema/modclass/getalldomains
INFO 2018-02-23 14:42:49 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:49 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:49 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:49 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:49 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /schema/modlookup/tree
INFO 2018-02-23 14:42:49 [workflow] getting all process classes
WARN 2018-02-23 14:42:49 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO 2018-02-23 14:42:49 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:49 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:49 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:49 [workflow] getting process class with name 'Activity'
ERROR 2018-02-23 14:42:49 [jsonrpc ] Error retrieving start activity for process
INFO 2018-02-23 14:42:49 [jsonrpc ] Calling url /widget/readall
INFO 2018-02-23 14:42:50 [jsonrpc ] Calling url /schema/modclass/readall
INFO 2018-02-23 14:42:50 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:50 [jsonrpc ] Calling url /schema/modmenu/getassignedmenu
INFO 2018-02-23 14:42:50 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:50 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:50 [jsonrpc ] Calling url /custompages/readforcurrentuser
INFO 2018-02-23 14:42:50 [jsonrpc ] Calling url /workflow/readall
INFO 2018-02-23 14:42:50 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:50 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:50 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:50 [workflow] getting all active process classes
INFO 2018-02-23 14:42:50 [workflow] getting all process classes
INFO 2018-02-23 14:42:50 [workflow] getting all process classes
WARN 2018-02-23 14:42:50 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO 2018-02-23 14:42:50 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:50 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:50 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:50 [workflow] getting process class with name 'Activity'
INFO 2018-02-23 14:42:50 [jsonrpc ] Calling url /viewmanagement/read
ERROR 2018-02-23 14:42:50 [jsonrpc ] Error retrieving start activity for process
INFO 2018-02-23 14:42:50 [jsonrpc ] Calling url /dashboard/list
INFO 2018-02-23 14:42:50 [jsonrpc ] Calling url /management/modreport/getreporttypestree
INFO 2018-02-23 14:42:50 [jsonrpc ] Calling url /custompages/readforcurrentuser
INFO 2018-02-23 14:42:50 [jsonrpc ] Calling url /utils/generateid
INFO 2018-02-23 14:42:50 [jsonrpc ] Calling url /schema/modlookup/getlookuplist
INFO 2018-02-23 14:42:51 [jsonrpc ] Calling url /utils/generateid
INFO 2018-02-23 14:42:51 [jsonrpc ] Calling url /schema/modclass/getallclasses
INFO 2018-02-23 14:42:51 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:51 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:51 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:51 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:51 [workflow] getting all process classes
INFO 2018-02-23 14:42:51 [jsonrpc ] Calling url /schema/modclass/getallclasses
INFO 2018-02-23 14:42:51 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:51 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:51 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:51 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:51 [workflow] getting all process classes
INFO 2018-02-23 14:42:51 [workflow] getting all process classes
INFO 2018-02-23 14:42:51 [workflow] getting all process classes
WARN 2018-02-23 14:42:51 [cmdbuild] Cannot fetch if the process 'RequestForChange' is startable
INFO 2018-02-23 14:42:51 [workflow] getting all process classes
WARN 2018-02-23 14:42:51 [cmdbuild] Cannot fetch if the process 'RequestForChange' is startable
INFO 2018-02-23 14:42:51 [workflow] getting all process classes
WARN 2018-02-23 14:42:51 [cmdbuild] Cannot fetch if the process 'Activity' is startable
WARN 2018-02-23 14:42:51 [cmdbuild] Cannot fetch if the process 'Activity' is startable
INFO 2018-02-23 14:42:52 [jsonrpc ] Calling url /schema/modmenu/getassignedmenu
INFO 2018-02-23 14:42:52 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:52 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2018-02-23 14:42:52 [jsonrpc ] Calling url /custompages/readforcurrentuser
INFO 2018-02-23 14:42:52 [jsonrpc ] Calling url /dashboard/getchartdata
INFO 2018-02-23 14:42:52 [jsonrpc ] Calling url /dashboard/getchartdata
INFO 2018-02-23 14:42:53 [jsonrpc ] Calling url /dashboard/getchartdata

--------------------------------------------------------------------------------------------------------

Issue No. 2: Related to shark

When I try to open url: http://localhost:8080/shark/

I get following message on screen:

AXIS error

No service is available at this URL

In the log file shark.log, I get following error message:

-------------------------------------------------------------------------------------------------

2018-02-23 14:12:35,200: SharkEngineManager -> Working with 'org.enhydra.shark.caching.LRUCacheMgr' implementation of Caching API
2018-02-23 14:12:35,403: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: relation "shkprocessstates" does not exist
Position: 32)
2018-02-23 14:12:35,405: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
2018-02-23 14:12:35,409: DODSPersistentManager -> persisting String variables into BLOB for sizes greater than 4000
2018-02-23 14:12:35,409: SharkEngineManager -> Working with 'org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager' implementation of InstancePersistence API
2018-02-23 14:12:35,420: DODSGlobalPersistenceManager -> persisting String data into BLOB for sizes greater than 4000
2018-02-23 14:12:35,420: SharkEngineManager -> Working with 'org.enhydra.shark.globalpersistence.DODSGlobalPersistenceManager' implementation of GlobalPersistence API
2018-02-23 14:12:36,906: SharkEngineManager -> Working with 'org.cmdbuild.workflow.CMDBuildEventAuditManager' implementation of EventAudit API
2018-02-23 14:12:36,949: SharkEngineManager -> Working with 'org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager' implementation of RepositoryPersistence API
2018-02-23 14:12:36,953: SharkEngineManager -> Working with 'org.enhydra.shark.scripting.StandardScriptingManager' implementation of Scripting API
2018-02-23 14:12:36,953: SharkEngineManager -> Working without Security API implementation - SecurityManager is not specified.
2018-02-23 14:12:37,068: StandardToolAgentManager -> Working with 'org.enhydra.shark.appmappersistence.DODSApplicationMappingAdmin' implementation of ApplicationMapPersistence API
2018-02-23 14:12:37,068: SharkEngineManager -> Working with 'org.enhydra.shark.toolagent.StandardToolAgentManager' implementation of ToolAgentManager API
2018-02-23 14:12:37,068: SharkEngineManager -> Working without wfEngineInteroperability API implementation - WfEngineInteroperability implementation is not specified.
2018-02-23 14:12:37,089: SharkUtilities -> synchronizing XPDL cache
2018-02-23 14:12:37,101: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
2018-02-23 14:12:37,101: Problem while initializing caches !!!
2018-02-23 14:22:50,710: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API
2018-02-23 14:22:50,710: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactoryExt' implementation of core SharkObjectFactory API
2018-02-23 14:22:50,710: SharkEngineManager -> Working with 'org.enhydra.shark.StandardToolActivityHandler' implementation of core ToolAgentManager API
2018-02-23 14:22:50,710: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API
2018-02-23 14:22:51,069: StandardAssignmentManager -> Working with 'org.enhydra.shark.usergroup.DODSUserGroupManagerAdmin' implementation of UserGroup API
2018-02-23 14:22:51,400: StandardAssignmentManager -> Working with 'org.enhydra.shark.partmappersistence.DODSParticipantMappingAdmin' implementation of ParticipantMapping API
2018-02-23 14:22:51,400: SharkEngineManager -> Working with 'org.enhydra.shark.assignment.StandardAssignmentManager' implementation of Assignment API
2018-02-23 14:22:51,407: Process Cache configured - max. size is 100
2018-02-23 14:22:51,408: Resource Cache configured - max. size is 100
2018-02-23 14:22:51,408: SharkEngineManager -> Working with 'org.enhydra.shark.caching.LRUCacheMgr' implementation of Caching API
2018-02-23 14:22:51,584: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: relation "shkprocessstates" does not exist
Position: 32)
2018-02-23 14:22:51,585: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
2018-02-23 14:22:51,589: DODSPersistentManager -> persisting String variables into BLOB for sizes greater than 4000
2018-02-23 14:22:51,589: SharkEngineManager -> Working with 'org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager' implementation of InstancePersistence API
2018-02-23 14:22:51,598: DODSGlobalPersistenceManager -> persisting String data into BLOB for sizes greater than 4000
2018-02-23 14:22:51,598: SharkEngineManager -> Working with 'org.enhydra.shark.globalpersistence.DODSGlobalPersistenceManager' implementation of GlobalPersistence API
2018-02-23 14:22:53,042: SharkEngineManager -> Working with 'org.cmdbuild.workflow.CMDBuildEventAuditManager' implementation of EventAudit API
2018-02-23 14:22:53,090: SharkEngineManager -> Working with 'org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager' implementation of RepositoryPersistence API
2018-02-23 14:22:53,097: SharkEngineManager -> Working with 'org.enhydra.shark.scripting.StandardScriptingManager' implementation of Scripting API
2018-02-23 14:22:53,097: SharkEngineManager -> Working without Security API implementation - SecurityManager is not specified.
2018-02-23 14:22:53,224: StandardToolAgentManager -> Working with 'org.enhydra.shark.appmappersistence.DODSApplicationMappingAdmin' implementation of ApplicationMapPersistence API
2018-02-23 14:22:53,224: SharkEngineManager -> Working with 'org.enhydra.shark.toolagent.StandardToolAgentManager' implementation of ToolAgentManager API
2018-02-23 14:22:53,224: SharkEngineManager -> Working without wfEngineInteroperability API implementation - WfEngineInteroperability implementation is not specified.
2018-02-23 14:22:53,247: SharkUtilities -> synchronizing XPDL cache
2018-02-23 14:22:53,259: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: current transaction is aborted, commands ignored until end of transaction block)
2018-02-23 14:22:53,260: Problem while initializing caches !!!
2018-02-23 14:28:15,752: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: relation "shkresourcestable" does not exist
Position: 33)
2018-02-23 14:28:15,871: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: relation "shkresourcestable" does not exist
Position: 33)
2018-02-23 14:28:15,909: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: relation "shkresourcestable" does not exist
Position: 33)
2018-02-23 14:28:15,931: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: relation "shkresourcestable" does not exist
Position: 33)
2018-02-23 14:28:15,947: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: relation "shkresourcestable" does not exist
Position: 33)

-----------------------------------------------------------------------------------------------------------------------------------

How can I get rid of this issue and how can I know that shark has been configured properly. The credentials to login into openmaint is admin/admin in my computer. I have set following details in shark configuration files. Are these configurations correct?

Shark.conf:

# CMDBuild connection settings
org.cmdbuild.ws.url=http://localhost:8080/opemmaint/
org.cmdbuild.ws.username=admin
org.cmdbuild.ws.password=admin

context.xml:

I have set following configuration.

Thanks

Devanshu

tecnoteca · February 23, 2018, 9:30am

The first problem depends on the second and means that Shark is not configured correctly.
Have you already checked the CMDBuild Technical Manual?
CMDBuild Team

tecnoteca · February 23, 2018, 2:06pm

Hi,

Thanks for the reply.

I followed that technical manual as it was referred in the "INSTALL.txt" to follow the manual from page 16 onwards:
"Configure shark as explained in CMDBuild Technical Manual (http://www.cmdbuild.org/file/manuali/technical-manual-in-english page 16 and following)"

But after you said to refer it, I thought to do a fresh setup of openmaint application with freshly extracted files in Tomcat Server and database.

Here is what I did:
Initially I tied to first create a database in postgres and tried to restore this database with file "openmaint-1.1-demo.backup" as available in extracted openmaint-1.1-2.4.3.zip file. But unfortunately it did not work as during restore a lot of SQL errors were thrown in the pgAdmin console. So, I dropped this approach and tried to setup the openmaint application from setup wizard by accessing it at url: http://localhost:8080/openmaint

Now I followed following steps:
1. Copied the zip files "openmaint-1.1-2.4.3.war" and "openmaint-shark-server-1.1-2.4.3.war" in to the "Tomcat8.5.28\webapps" folder.
2. Renamed these two folders to "openmaint.war" and "shark.war" respectively.
3. Now I started the Tomcat Server
After starting server, two important points to note is that, when "shark.war" gets extracted into folder "shark", the code of shark application does not resides inside this "shark" folder. Inside the "shark" folder, there are two folders with names "META-INF" and "openmaint-shark-server-1.1-2.4.3". The "META-INF" folder carries one file called "war-tracker". The folder "openmaint-shark-server-1.1-2.4.3" carries the code of shark application. Is this correct ? I suppose, the "shark" folder itself should carry the code of shark application rather than the code of shark application residing inside "Tomcat8.5.28\webapps\shark\openmaint-shark-server-1.1-2.4.3" folder. Please correct if I am wrong in my thought.

Secondly, in the “Tomcat8.5.28\logs” folder, the “cmdbuild.log”
and “cmdbuild_dd_sql.log” gets created. But I do not see the “shark.log”
file. The “shark.log” file gets
created

when I move the code residing inside the "openmaint-shark-server-1.1-2.4.3

" to the folder “shark” parent folder and restart Tomcat server.

4. I stop the Tomcat server and move the “openmaint-shark-server-1.1-2.4.3” folder to “webapps” folder and rename it to “shark”.

5. I updated following files residing inside “shark” folder

     i). "Tomcat8.5.28\webapps\shark\META-INF\context.xml"
Changes done to following xml code in url, username and password tags
<?xml version=“1.0” encoding=“UTF-8”?>
<Context>
    <Resource
        auth=“Container”
        name=“UserTransaction”
        type=“javax.transaction.UserTransaction”
        jotm.timeout=“180”
        factory=“org.objectweb.jotm.UserTransactionFactory”/>
    <Resource
        name=“sharkdb”
        type=“javax.sql.DataSource”
        driverClassName=“org.postgresql.Driver”
        url=“jdbc:postgresql://localhost/openmaint_1_1_demo”
        username=“postgres”
        password=“postgres”
        maxIdle=“10”
        maxActive=“300”
        maxWait=“5000”
        factory=“org.enhydra.jndi.DataSourceFactory”/>
</Context>

ii). "Tomcat8.5.28\webapps\shark\conf\Shark.conf"
The
org.cmdbuild.ws.username

is set to value “admin” because when I will configure opemmaint in some
time, I will set the admin login username as “admin” and
org.cmdbuild.ws.password

to also “admin”

# CMDBuild connection settings
org.cmdbuild.ws.url=http://localhost:8080/openmaint/
org.cmdbuild.ws.username=admin
org.cmdbuild.ws.password=admin

6.
After making above changes, I open url
“http://localhost:8080/openmaint/” in my Firefox browser. A
configuration wizard screen opens with form fields and values either
pre-populated or filled by me as follows

Step 1 (Screen 1):

Choose default language (Drop down list): English

Show language selection in login box (Checkbox): Unchecked

Step 2 (Screen 2):

CMDBuild database:

Type (Drop Down List): Demo

Name (Text Box): openmaint_1_1_demo

Create a Shark schema (checkbox): checked

Database connection (PostgreSQL JDBC Driver 42.2.1

Host: localhost
Port: 5432
Super User: postgres

Password: postgres

Note that when, I test connection, it is successful.

Then I click on Finish button.

I get following message on screen:

"Configuration wizard is successfully completed, clicking OK you will be redirect to the application."

When I click on "OK", I get a screen where it shows a list "Available patch list" as below:

Category Name Description

Default                  2.4.1-01                            Adds missing "TranslationUuid" values to "LookUp" table and related trigger.
Default                  2.4.2-01                            Adds a CHECK on "Status" attribute for historic tables.
Default                  2.4.2-02                            Fixes the values within "Delay" columns of tables "Email" and "_EmailTemplate"
Default                  2.4.3-01                            Creates _graph_get_related_classes function.

There is a button "Apply" at bottom. I clicked on this button as there was no option to skip this step.

All patches gets applied successfully and login screen displays.

7. I login with username and password both as "admin/admin". Note that in the login screen, the version is displayed as "openMAINT 1.1 - 2.4.3 (22/02/2017)"

After login, a small error popup displays at right bottom corner with message:

Class RequestForChange not found

I checked shark.log file and found a lot of continuous following message in it:
2018-02-23 18:08:56,198: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: relation "shkresourcestable" does not exist Position: 33

I also checked the database. In the database "openmain_1_1_demo", there are two schemas created namely "public" and "shark". The "public" schema carries the tables of "openmaint" application and "shark" schema carries the tables for "shark" application.

The "shark" schema carries 84 tables and one of them is "shkresourcestable" table. But there is no data inside this table.

Is it possible that this error was thrown when I first accessed the url " http://localhost:8080/openmaint" and since the tables for openmaint were still probably being created and populated with demo data and in parallel shark application was accessed and there at that time shark tables were not even created! This is my guess only. Please correct me if I am wrong in this assumption.

8. Now I access the "shark" application at url: http://localhost:8080/shark

And I see following information on screen:

And now... Some Services

    AdminService (wsdl)
        AdminService
    ExecutionAdministrationExt (wsdl)
        goBack
        goForth
        goAnywhere
        goPrevious
        goNext
        deleteProcessInstances
        reevaluateAssignmentsForUser
        migrateProcessVersion
    AdminMisc (wsdl)
        getActivityDefinitionInfo
        getProcessDefinitionInfo
        getProcessDefinitionInfoByUniqueProcessDefinitionName
        getVariableDefinitionInfo
        getVariableDefinitionInfoByUniqueProcessDefinitionName
        getVariableJavaClassName ......
        ......................

So it seems that the "Axis Error - No Service Available" shown on screen last time when I accessed the url http://localhost:8080/shark

has gone now but the error of "
Class RequestForChange not found

" still shows up in openmaint application. But there is no error shown in “cmdbuild.log” for this error message shown on screen.

And secondly, one error of "shkresourcestable" does not exist showed up in "shark.log" file.

So these are all the steps that I followed. Did I miss something in it? How can I be sure that everything (including shark) is working perfectly in this installation.

Thanks

Devanshu

Previously Tecnoteca wrote:

The first problem depends on the second and means that Shark is not configured correctly.
Have you already checked the CMDBuild Technical Manual?
CMDBuild Team

devanshu.chakraborty · February 26, 2018, 9:43am

Hi,

Any suggestion by anyone for the two issues I mentioned in my previous reply.

Thanks

Devanshu

Previously Devanshu wrote:

Hi,

Thanks for the reply.

I followed that technical manual as it was referred in the "INSTALL.txt" to follow the manual from page 16 onwards:
"Configure shark as explained in CMDBuild Technical Manual (http://www.cmdbuild.org/file/manuali/technical-manual-in-english page 16 and following)"

But after you said to refer it, I thought to do a fresh setup of openmaint application with freshly extracted files in Tomcat Server and database.

Here is what I did:
Initially I tied to first create a database in postgres and tried to restore this database with file "openmaint-1.1-demo.backup" as available in extracted openmaint-1.1-2.4.3.zip file. But unfortunately it did not work as during restore a lot of SQL errors were thrown in the pgAdmin console. So, I dropped this approach and tried to setup the openmaint application from setup wizard by accessing it at url: http://localhost:8080/openmaint

Now I followed following steps:
1. Copied the zip files "openmaint-1.1-2.4.3.war" and "openmaint-shark-server-1.1-2.4.3.war" in to the "Tomcat8.5.28\webapps" folder.
2. Renamed these two folders to "openmaint.war" and "shark.war" respectively.
3. Now I started the Tomcat Server
    After starting server, two important points to note is that, when "shark.war" gets extracted into folder "shark", the code of shark application does not resides inside this "shark" folder. Inside the "shark" folder, there are two folders with names "META-INF" and "openmaint-shark-server-1.1-2.4.3". The "META-INF" folder carries one file called "war-tracker". The folder "openmaint-shark-server-1.1-2.4.3" carries the code of shark application. Is this correct ? I suppose, the "shark" folder itself should carry the code of shark application rather than the code of shark application residing inside "Tomcat8.5.28\webapps\shark\openmaint-shark-server-1.1-2.4.3" folder. Please correct if I am wrong in my thought.

Secondly, in the “Tomcat8.5.28\logs” folder, the “cmdbuild.log”
and “cmdbuild_dd_sql.log” gets created. But I do not see the “shark.log”
file. The “shark.log” file gets
created

when I move the code residing inside the "openmaint-shark-server-1.1-2.4.3

" to the folder “shark” parent folder and restart Tomcat server.

4. I stop the Tomcat server and move the “openmaint-shark-server-1.1-2.4.3” folder to “webapps” folder and rename it to “shark”.

5. I updated following files residing inside “shark” folder

     i). "Tomcat8.5.28\webapps\shark\META-INF\context.xml"
Changes done to following xml code in url, username and password tags
<?xml version=“1.0” encoding=“UTF-8”?>
<Context>
    <Resource
        auth=“Container”
        name=“UserTransaction”
        type=“javax.transaction.UserTransaction”
        jotm.timeout=“180”
        factory=“org.objectweb.jotm.UserTransactionFactory”/>
    <Resource
        name=“sharkdb”
        type=“javax.sql.DataSource”
        driverClassName=“org.postgresql.Driver”
        url=“jdbc:postgresql://localhost/openmaint_1_1_demo”
        username=“postgres”
        password=“postgres”
        maxIdle=“10”
        maxActive=“300”
        maxWait=“5000”
        factory=“org.enhydra.jndi.DataSourceFactory”/>
</Context>


ii). "Tomcat8.5.28\webapps\shark\conf\Shark.conf"
The
org.cmdbuild.ws.username
is set to value “admin” because when I will configure opemmaint in some
time, I will set the admin login username as “admin” and
org.cmdbuild.ws.password

to also “admin”

# CMDBuild connection settings
org.cmdbuild.ws.url=http://localhost:8080/openmaint/
org.cmdbuild.ws.username=admin
org.cmdbuild.ws.password=admin

6.
After making above changes, I open url
“http://localhost:8080/openmaint/” in my Firefox browser. A
configuration wizard screen opens with form fields and values either
pre-populated or filled by me as follows

   Step 1 (Screen 1):

             Choose default language (Drop down list): English

             Show language selection in login box (Checkbox): Unchecked

    Step 2 (Screen 2):

              CMDBuild database:

                   Type (Drop Down List): Demo

   Name (Text Box): openmaint_1_1_demo

                   Create a Shark schema (checkbox): checked

Database connection (PostgreSQL JDBC Driver 42.2.1

Host: localhost
Port: 5432
Super User: postgres

Password: postgres

               Note that when, I test connection, it is successful.

               Then I click on Finish button.


               I get following message on screen:

               "Configuration wizard is successfully completed, clicking OK you will be redirect to the application."

When I click on "OK", I get a screen where it shows a list "Available patch list" as below:

Category               Name                               Description

Default                  2.4.1-01                            Adds missing "TranslationUuid" values to "LookUp" table and related trigger.
Default                  2.4.2-01                            Adds a CHECK on "Status" attribute for historic tables.
Default                  2.4.2-02                            Fixes the values within "Delay" columns of tables "Email" and "_EmailTemplate"
Default                  2.4.3-01                            Creates _graph_get_related_classes function.

There is a button "Apply" at bottom. I clicked on this button as there was no option to skip this step.

All patches gets applied successfully and login screen displays.

7. I login with username and password both as "admin/admin". Note that in the login screen, the version is displayed as "openMAINT 1.1 - 2.4.3 (22/02/2017)"

After login, a small error popup displays at right bottom corner with message:

Class RequestForChange not found

I checked shark.log file and found a lot of continuous following message in it:
2018-02-23 18:08:56,198: <SqlQueryExecute><SqlQueryException>(<Replicated>:ERROR: relation "shkresourcestable" does not exist Position: 33

I also checked the database. In the database "openmain_1_1_demo", there are two schemas created namely "public" and "shark". The "public" schema carries the tables of "openmaint" application and "shark" schema carries the tables for "shark" application.

The "shark" schema carries 84 tables and one of them is "shkresourcestable" table. But there is no data inside this table.

Is it possible that this error was thrown when I first accessed the url " http://localhost:8080/openmaint" and since the tables for openmaint were still probably being created and populated with demo data and in parallel shark application was accessed and there at that time shark tables were not even created! This is my guess only. Please correct me if I am wrong in this assumption.

8. Now I access the "shark" application at url: http://localhost:8080/shark

And I see following information on screen:

And now... Some Services

    AdminService (wsdl)
        AdminService
    ExecutionAdministrationExt (wsdl)
        goBack
        goForth
        goAnywhere
        goPrevious
        goNext
        deleteProcessInstances
        reevaluateAssignmentsForUser
        migrateProcessVersion
    AdminMisc (wsdl)
        getActivityDefinitionInfo
        getProcessDefinitionInfo
        getProcessDefinitionInfoByUniqueProcessDefinitionName
        getVariableDefinitionInfo
        getVariableDefinitionInfoByUniqueProcessDefinitionName
        getVariableJavaClassName ......
        ......................

So it seems that the "Axis Error - No Service Available" shown on screen last time when I accessed the url http://localhost:8080/shark
has gone now but the error of "
Class RequestForChange not found

" still shows up in openmaint application. But there is no error shown in “cmdbuild.log” for this error message shown on screen.

And secondly, one error of "shkresourcestable" does not exist showed up in "shark.log" file.

So these are all the steps that I followed. Did I miss something in it? How can I be sure that everything (including shark) is working perfectly in this installation.

Thanks

Devanshu

Previously Tecnoteca wrote:
The first problem depends on the second and means that Shark is not configured correctly.
Have you already checked the CMDBuild Technical Manual?
CMDBuild Team

tecnoteca · February 26, 2018, 4:08pm

If
you have performed the simplified installation of CMDBuild, with the
creation of the demo database from the setup procedure (rather than
manually restore a database) you must manually upload the XPDL file
corresponding to each workflow (in this case RequestForChange).
Did you do this?
If
you have not done so, go to the Administration Module, Workflow menu,
choose the RequestForChange workflow and upload the XPDL file you find
in the CMDBuild ZIP (folder extras\workflow\RFC).
CMDBuild Team