Rollbase 4.2 Private installation with dedicated OpenEdge DB problems - Forum - Rollbase - Progress Community

Rollbase 4.2 Private installation with dedicated OpenEdge DB problems

 Forum

Rollbase 4.2 Private installation with dedicated OpenEdge DB problems

  • Hi,

    I am experiencing a problem with a clean install from the installer.
    I am using the OpenEdge database supplied with the installer and it has been started.

    In the log this stack is repeated:

    29-Jul-2016 13:59:10.459 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log No Spring WebApplicationInitializer types detected on classpath
    29-Jul-2016 13:59:12.870 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.loadOnStartup Servlet [Starter] in web application [/master] threw load() exception
    java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]Software caused connection abort: recv failed.
    at com.rb.util.system.a582.loadConfigFilesToDb(a582.java:332)
    at com.rb.master.logics.servlet.Starter.init(Starter.java:58)
    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4997)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
    at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
    at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1795)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

    It looks like Rollbase cannot connect to the DB.

    In the databases.xml it has the following entry:

    <Database name="RB" isDefault="yes" isExternal="no"
    MinConnections="3" MaxConnections="10"
    MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"
    MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="yes">
    <Driver>com.ddtek.jdbc.openedge.OpenEdgeDriver</Driver>
    <Url>jdbc:datadirect:openedge://localhost:8911;databaseName=rbdb</Url>
    <DbUser>admin</DbUser>
    <Password>  XXXXXXXX  </Password>
    </Database>

  • Hi Korak,

    This could be possibly a network error because of below reasons :

    1. DB is Down

    2. Localhost is already used by some other server on network

    Can you please try gracefully shutting down Rollbase server --> Stop DB --> manually Start DB --> Start Rollbase and see if this fixed the issue?

    Regards,

    Mani.

  • Can you connect to the database directly? Or by using a JDBC Query tool using the connection settings you specified?

  • Hi,

    Sorry for the late reply.

    Thank you for the replies.

    The DB is running fine.

    There are no other servers running on the used port.

    The login page loads fine, but when I do anything there (login, even change language) I get this error:

    HTTP Status 500 - Value of HTTP parameter selLang is too large: 2 chars

    type Exception report

    message Value of HTTP parameter selLang is too large: 2 chars

    description The server encountered an internal error that prevented it from fulfilling this request.

    exception

    java.lang.IllegalArgumentException: Value of HTTP parameter selLang is too large: 2 chars

    com.rb.util.web.HttpUtil.getParameter(HttpUtil.java:52)

    com.rb.router.logics.servlet.RouterServlet.doPost(RouterServlet.java:46)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:648)

    javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

    com.rb.util.web.RequestLoggingFilter.doFilter(RequestLoggingFilter.java:37)

    note The full stack trace of the root cause is available in the Apache Tomcat/8.0.30 logs.

    It is installed op an Windows 8.1 64 bit laptop.

    I also tried it on a windows 10 64 bit PC en there it is working fine.

    Any suggestions are welcome.

  • In the Tomcat log files I found the following error, which is repeated many times:

    Cannot convert the "C:\Progress\Rollbase\pas\bin\Expand.2.0.0.jar" value of typ

    e "System.IO.FileInfo" to type "System.Collections.ArrayList".

    At C:\Progress\Rollbase\pas\bin\tctailor.psm1:1428 char:9

    +         _versions

    +         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

       + CategoryInfo          : InvalidArgument: (:) [], RuntimeException

       + FullyQualifiedErrorId : ConvertToFinalInvalidCastException

    You cannot call a method on a null-valued expression.

    At C:\Progress\Rollbase\pas\bin\tctailor.psm1:1429 char:9

    +         _oldversions = [System.Collections.ArrayList]_oldversions.RemoveAt(0)

    +         ~~~~~~~~~~~~~~~~~~~~~~~~~

       + CategoryInfo          : InvalidOperation: (:) [], RuntimeException

       + FullyQualifiedErrorId : InvokeMethodOnNull

  • Is this issue solved by now? I have the same problem and nothing seems to help. It used to work.

  • Haven't found it yet.

  • Hi KorakSchoone,

    Checking the error it seems you are starting Tomcat in pas directory instead of Pas_Instance directory.

    Another possible issue is the user and password accessing the database.

    Using the automatic installer it is always  dbamin/dbadmin