Skip to main content
Skip table of contents

Clearing ESB Server Database

To clear the FES server database of the default profile (that is profile1), double-click the clearDBServer.bat file present in the <fiorano_installation_dir>\esb\server\bin folder or browse to this location and execute the following script:

CODE
script clearDBServer.bat/.sh -mode fes

To clear the FES server database of a specific profile (other than the default profile), double-click the clearDBServer.bat file present in the <fiorano_installation_dir>\esb\server\bin folder or browse to this location  and execute the following script with the profile option as shown below:

CODE
clearDBServer.bat/.sh -mode fes -profile <profilename>

The following operations are available when this script is executed from which you may choose the option of your preference:

OperationDescription
1. File BasedDatastoreClears the local cache of the Enterprise server.
2. Admin Datastore Clears the admin objects, that is, JMS Connection factories, queue and topic destinations, status of running Event Processes and component instances.
3. Peer RepositoryClears all the fetched peer server profiles from Enterprise Server runtimedata.
4. Events DatabaseClears the Events Database using the configurations provided in eventsdb.cfg file present under: <fiorano_installation_dir>/esb/server/profiles/<profilename>/FES/conf directory.
5. SBW Database

Clears the SBW database using the configurations provided in the sbwdb.cfg file present under: <fiorano_installation_dir>/esb/server/profiles/<profilename>/FES/conf directory.
The Enterprise Server processes System events, SBW events and Backlog events and takes appropriate actions. System events and SBW events are queued up to be inserted into an external database while Backlog events are queued up to be handled by various alert handlers. Before this processing happens, events are temporarily stored in persistent database that are created during runtime data of the Enterprise Server. After an event has been processed, it gets deleted from the temporary store. If these events are not able to be processed, the temporary datastore may grow to occupy a large amount of disk-space. Option 7, 8, and 9 can be used to delete the temporary persistent datastore of different events.

6. Events Persistent Database CacheClears the temporary persistent datastore of system events.
7. SBW Persistent DatabaseCacheClears the temporary persistent datastore of SBW events.
8. SBW Call Out Persistent DatabaseCacheClears the temporary persistent datastore of SBW Callout events.
9. Backlog Persistent DatabaseCacheClears the temporary persistent datastore of backlog events.
10. YAWL DatabaseClears the YAWL Database for the Enterprise Servers.
11. AllClears all nine of the above.

Select the preferred number (from 1 to 11) corresponding to the datastore that needs to be cleared.


Figure 2: Options to clear datastore

Ensure that the Enterprise Server is shut down. If not you will get a message prompting to do the same (as in the figure above—"Please shutdown the Fiorano FES Server")

The script can be executed in Quiet Mode as follows (sample):

CODE
clearDBServer.bat -mode fes -profile profile1 -dbPath <DB Directory path> -q 1,2,4

where, the elements included implies as below:

  • -mode - to clear fps or fes runtimedata
  • -dbPath - runtime data directory for the profile
  • -profile - profile name for which runtimedata is to be cleared
  • -q - to run the script in quiet mode.

You can provide comma separated option values to the argument (as in the above sample script). Absence of an argument leads assuming the default option—option 11, ‘ALL’.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.