ERROR: Configuration error: Store with similar dbstore_driver_url exists.

ERROR: Configuration error: Store with similar dbstore_driver_url exists.

book

Article ID: KB0089064

calendar_today

Updated On:

Products Versions
TIBCO Enterprise Message Service -
Not Applicable -

Description

Description:
ERROR: Configuration error: Store with similar dbstore_driver_url exists, file=C:\stores.conf, line=99
FATAL: Exception in startup, exiting.

Symptoms:
TIBCO Enterprise Message Service.

Version 8.0.0 V9 6/7/2013
2014-02-20 20:46:47.203 Process started from 'tibemsd'.
2014-02-20 20:46:47.203 Process Id: 7144
2014-02-20 20:46:47.203 Hostname: epozen_tjkwak
2014-02-20 20:46:47.203 Hostname IP address: ...
2014-02-20 20:46:47.203 Hostname IP address: ...
2014-02-20 20:46:47.203 Reading configuration from 'c:\tibemsd.conf'.
2014-02-20 20:46:47.203 Logging into file 'C:\EMS.log'
2014-02-20 20:46:48.345 Server name: 'EMS-SERVER'.
2014-02-20 20:46:48.301 Storage Location: '.'.
2014-02-20 20:46:48.301 Routing is disabled.
2014-02-20 20:46:48.301 Authorization is disabled.
2014-02-20 20:46:48.301 ERROR: Configuration error: Store with similar dbstore_driver_url exists, file=C:\stores.conf, line=99
2014-02-20 20:46:48.301 FATAL: Exception in startup, exiting.

Cause:
Check the stores.conf file.
====
[$formula($sys.nonfailsafe)]
  type=dbstore
  dbstore_driver_url=jdbc:oracle:thin:@127.0.0.1:1521/orcl
  dbstore_driver_username=test
  dbstore_driver_password=test
[$formula($sys.failsafe)]
  type=dbstore
  dbstore_driver_url=jdbc:oracle:thin:@127.0.0.1:1521/orcl
  dbstore_driver_username=test
  dbstore_driver_password=test
[$formula($sys.meta)]
  type=dbstore
  dbstore_driver_url=jdbc:oracle:thin:@127.0.0.1:1521/orcl
  dbstore_driver_username=test
  dbstore_driver_password=test
====
In the syntax "ddbstore_driver_url=jdbc:oracle:thin:@127.0.0.1:1521/orcl", it can be seen that you are using the same database (orcl) and the same username/password ("test") for all three stores [$formula($sys.nonfailsafe)] [$formula($sys.meta)] and [$formula($sys.failsafe)] - this is not allowed.

Issue/Introduction

ERROR: Configuration error: Store with similar dbstore_driver_url exists.

Resolution

You cannot use the same schema for all stores that you create. Either you have to use different databases (SID) (ORCL) for each store or if you are planning to use the same SID, you have to use different usernames and password for each of the stores.