[rules-users] 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.


Thanks and Best Regards,

Zahid Ahmed
Senior Software Engineer | Emirates Group IT
P.O. Box 686 | Dubai, United Arab Emirates
T +971 4 245 2551| M +971   55 124 9171



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20130721/64f4dbc9/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-users/attachments/20130721/64f4dbc9/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-users/attachments/20130721/64f4dbc9/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-users/attachments/20130721/64f4dbc9/attachment-0005.xml