Private cloud Rollbase with SQL 2014 - Forum - Rollbase - Progress Community

Private cloud Rollbase with SQL 2014

 Forum

Private cloud Rollbase with SQL 2014

This question is answered

I installed the private cloud Rollbase on a windows 2012 server following the installation guide (and installer).

Used the create_ms script and edited the database.xml.

But when I when i start tcman i get the error "Database RB not found".

I have no idea why it cannot find the database, has anyone else ever had this problem?

Small part of the logfile:

"Sep 29, 2015 3:06:07 PM org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /master threw load() exception
com.rb.util.db.a528: Database RB not found
    at com.rb.util.system.a558.loadConfigFilesToDb(a558.java:331)
    at com.rb.master.logics.servlet.Starter.init(Starter.java:58)
    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
    at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:976)
    at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1653)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
    at java.util.concurrent.FutureTask.run(FutureTask.java:166)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    at java.lang.Thread.run(Thread.java:722)"

Verified Answer
  • Parent tags are missing in databases.xml file. Please replace databases.xml file entire content with below content and restart the server. Please let me know if you still see the same error

    <Databases>

    <Database name="RB" isDefault="yes" isExternal="no"

    MinConnections="3" MaxConnections="10"

    MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"

    MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="no">

    <Driver>com.rb.jdbc.sqlserver.SQLServerDriver</Driver>

    <Url>jdbc:rollbase:sqlserver://localhost:1433;databaseName=RB_DBO;ConnectionRetryCount=10;ConnectionRetryDelay=10</Url>

    <DbUser>sa</DbUser>

    <Password></Password>

    </Database>

    </Databases>

    Thanks

    Srinivas

All Replies
  • Hi Thomas,
     
    Did you change the Database name in the database.xml file?
     
    The database name has to be RB……
     
    <Database name="RB" isDefault="yes" isExternal="no"
                    MinConnections="3" MaxConnections="10"
                    MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"
                    MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="no">
                    <Driver>com.rb.jdbc.sqlserver.SQLServerDriver</Driver>
                    <Url>jdbc:rollbase:sqlserver://localhost:1433;databaseName=RB_D$
                    <DbUser>root</DbUser>
                    <Password>...</Password>
            </Database -->
     
    Regards,
    Ricardo
     
     
  • Hello Ricardo,

    This is my copy of the databases.xml file located in Pas_instance/rollbase/config:

    <Database name="RB" isDefault="yes" isExternal="no"
    MinConnections="3" MaxConnections="10" MaxInUseConnTimeMins="30"
    MaxNotUsedConnTimeMins="1" MaxConnLifetimeMins="60"
    TxIsolation="2" useTxRecovery="no">
    <Driver>com.rb.jdbc.sqlserver.SQLServerDriver</Driver>
    <Url>jdbc:rollbase:sqlserver://localhost:1433;databaseName=RB_DBO;
    ConnectionRetryCount=10;ConnectionRetryDelay=10</Url>
    <DbUser>sa</DbUser>
    <Password>****</Password>
    </Database>

    But still the same error.

  • Hi Thomas,

    Could you please confirm that you created DB with name "RB_DBO" ?

    Please provide DB name "databaseName=RB_DBO" correctly in below tag

    <Url>jdbc:rollbase:sqlserver://localhost:1433;databaseName=RB_DBO;

    ConnectionRetryCount=10;ConnectionRetryDelay=10</Url>

    Thanks

    Srinivas

  • Confirmed :)

  • Hi Thomas,

    Could you please share your entire databases.xml file?

    Please share full server logs also.

    This kind of exception we get if we don't have any Database entry in databases.xml file

    Thanks

    Srinivas

  • catalina.2015-09-30.log

    databases.xml

    localhost.2015-09-30.log

  • Parent tags are missing in databases.xml file. Please replace databases.xml file entire content with below content and restart the server. Please let me know if you still see the same error

    <Databases>

    <Database name="RB" isDefault="yes" isExternal="no"

    MinConnections="3" MaxConnections="10"

    MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"

    MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="no">

    <Driver>com.rb.jdbc.sqlserver.SQLServerDriver</Driver>

    <Url>jdbc:rollbase:sqlserver://localhost:1433;databaseName=RB_DBO;ConnectionRetryCount=10;ConnectionRetryDelay=10</Url>

    <DbUser>sa</DbUser>

    <Password></Password>

    </Database>

    </Databases>

    Thanks

    Srinivas

  • Srinivas,

    Thank you it worked! :)