[rules-dev] Guvnor in Reselliency environment : Assets stored in DB not visible in Secondary server

[Zahid Ahmed]

I am working in Drools-Guvnor-5.5.0.Final version and have configured repository.xml to save all assets + indexes in Oracle 11 database.



I am deploying Guvnor in a resilient environment which has two servers. Guvnor deployed in both the servers is pointing to the same database.



Step 1

For this I generated the repository.xml from the administration panel of Guvnor and replaced in both primary and secondary Guvnor instance. And when I started the server and imported assets into primary guvnor, I was able to see the following tables in database,



1.       FS_FSENTRY;

2.       FS_WS_DEFAULT_FSENTRY;

3.       PM_WS_DEFAULT_FSENTRY;

4.       PM_WS_DEFAULT_BINVAL;

5.       PM_WS_DEFAULT_BUNDLE;

6.       PM_WS_DEFAULT_REFS;

7.       PM_WS_DEFAULT_NAMES;

8.       REPOSITORY_FS_FSENTRY;

9.       VERSIONING_FS_FSENTRY;

10.    VERSIONING_PM_BINVAL;

11.    VERSIONING_PM_BUNDLE;

12.    VERSIONING_PM_NAMES;

13.    VERSIONING_PM_REFS;



I also configured workspace.xml files in

1.      jboss-eap-6.0/bin/repository/workspaces/default

2.      jboss-eap-6.0/bin/repository/workspaces/security



Step 2

Now started secondary guvnor, configured similar to primary Guvnor. But secondary server did not displayed the packages and assets from DB. Instead asked me to install sample packages.



Step 3

I configured DataStore in repository.xml. Restarted primary Guvnor server and found one more table is created in database with the assets init.

Table name : DS_DATASTORE



Step 4

Configured secondary Guvnor with DataStore and restarted it. Now I could see the packages of primary Guvnor, But the assets in packages were not available.



I am attaching the repository.xml file from both the servers.





SECIND ISSUE : Guvnor not giving the option to import one package

My second issue is that guvnor is not allowing to import one package. User has to import/export complete package. I have 3 applications running JBPM process runtimes. All the applications have there assets in separate packages. For any change in application A I need to import/Export Package A from DEV Guvnor Repo to PROD Guvnor Repo.



There is an un-resolved JIRA for this issue. Kindly let me know if this issue is resolved (and in which version). And if its not resolved then how to import a package in guvnor or an asset.



My Environment

1.       drools-guvnor 5.5.0.Final

2.       Assets

a.       BPMN files

b.      Task Forms

c.       Images

d.      WorkItemDefinitions

e.      ChangeSets


Thanks and Best Regards,

Zahid Ahmed



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-dev/attachments/20130724/042da71f/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: repository-primary server.xml
Type: text/xml
Size: 8778 bytes
Desc: repository-primary server.xml
Url : http://lists.jboss.org/pipermail/rules-dev/attachments/20130724/042da71f/attachment-0003.xml 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: repository-secondary server.xml
Type: text/xml
Size: 8778 bytes
Desc: repository-secondary server.xml
Url : http://lists.jboss.org/pipermail/rules-dev/attachments/20130724/042da71f/attachment-0004.xml 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: workspace.xml
Type: text/xml
Size: 2255 bytes
Desc: workspace.xml
Url : http://lists.jboss.org/pipermail/rules-dev/attachments/20130724/042da71f/attachment-0005.xml