Configuring BWAgent with Microsoft SQL Server fails. Error: Failed to start agent due to an error in initializing data store.

Configuring BWAgent with Microsoft SQL Server fails. Error: Failed to start agent due to an error in initializing data store.

book

Article ID: KB0093712

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Description:
Configuring BWAgent with Microsoft SQL Server fails with invalid driver error.
Symptoms:
Following error is seen in the bwagent.log.

++++++++

Failed to start agent due to an error in initializing data store,
<CausedBy> TIBCO-BW-ADMIN-PRSTNC-500007: bwagent.ini configuration error. bw.agent.technology.dbems.db.driver=[com.micro
soft.sqlserver.jdbc.SQLServerDriver] is invalid.
com.tibco.neo.exception.BaseException: TIBCO-BW-ADMIN-PRSTNC-500007: bwagent.ini configuration error. bw.agent.technolog
y.dbems.db.driver=[com.microsoft.sqlserver.jdbc.SQLServerDriver] is invalid.
        at com.tibco.bw.thor.management.persistence.rdbms.dao.BWDataSource.o00000(BWDataSource.java:157) ~[com.tibco.bw.
thor.management.persistence_1.3.200.003.jar:na]
    ...
+++++++

Cause:
DB provider setting (bw.agent.technology.dbems.db.provider) is set incorrectly to "sqlserver" instead of "mssql".

Resolution

Ensure that bw.agent.technology.dbems.db.provider has the database provider set to one of the following:
  • postgresql
  • mysql
  • mssql
  • oracle

Issue/Introduction

Configuring BWAgent with Microsoft SQL Server fails. Error: Failed to start agent due to an error in initializing data store.

Additional Information

https://docs.tibco.com/pub/activematrix_businessworks/6.2.2/doc/html/GUID-12AD9B5A-90AC-4629-8902-DED08DDF3DC2.html
Powered by Wolken Software