Private cloud Rollbase with SQL 2014

Posted by Thomas Suijkerbuijk on 29-Sep-2015 09:20

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)"

Posted by Srinivas Panyala on 30-Sep-2015 08:26

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

Posted by Ricardo Rafols on 29-Sep-2015 10:41
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
 
 
Posted by Thomas Suijkerbuijk on 30-Sep-2015 02:25

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.

Posted by Srinivas Panyala on 30-Sep-2015 02:34

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

Posted by Thomas Suijkerbuijk on 30-Sep-2015 03:00

Confirmed :)

Posted by Srinivas Panyala on 30-Sep-2015 07:44

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

Posted by Thomas Suijkerbuijk on 30-Sep-2015 08:13

[View:/cfs-file/__key/communityserver-discussions-components-files/25/catalina.2015_2D00_09_2D00_30.log:50:50]

[View:/cfs-file/__key/communityserver-discussions-components-files/25/databases.xml:50:50]

[View:/cfs-file/__key/communityserver-discussions-components-files/25/localhost.2015_2D00_09_2D00_30.log:50:50]

Posted by Srinivas Panyala on 30-Sep-2015 08:26

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

Posted by Thomas Suijkerbuijk on 30-Sep-2015 08:59

Srinivas,

Thank you it worked! :)

This thread is closed