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.