Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

"RapidAnalytics on a Windows 2008 x64 R2 server running MS SQL 2008"

jcorneliusjcornelius Member Posts: 2 Contributor I
edited June 2019 in Help
Can anyone confirm that RapidAnalytics (JBoss bundle) works on a Windows 2008 x64 R2 server with MS SQL 2008?

Best Regards,

JC
Tagged:

Answers

  • fischerfischer Member Posts: 439 Maven
    Hi,

    yes, next door.

    Best,
    Simon
  • jcorneliusjcornelius Member Posts: 2 Contributor I
    Thanks for a rapid answer.

    Anyone have a clue what Im missing here;

    Setup on a Windows 2008 x64 R2 server running MS SQL 2008

    1. Extracted the RapidAnalytics-1.0.000-JBoss-bundle.zip to c:\temp\rapidanalytics
    2. Created the database and user in SQL Server Management Studio.
    3. Ran the rapidanalytics/config/quartz/tables_sqlServer.sql which created the tables.
    4. Edited rapidanalytics-sqlserver-ds.xml.template with the password for the SQL user and renamed the file to rapidanalytics-sqlserver-ds.xml
    5. Ran C:\temp\rapidanalytics\bin\run.bat from cmd

    Results (copy/paste from cmd):

    C:\temp\rapidanalytics\bin>run.bat
    Calling C:\temp\rapidanalytics\bin\run.conf.bat
    JAVA_HOME is not set. Unexpected results may occur.
    Set JAVA_HOME to the directory of your local JDK to avoid this message.

    6. Edited run.conf.bat with the path to Java (set "JAVA_HOME=C:\Program Files (x86)\Java\jre6\bin").

    Results (copy/paste from cmd):

    C:\temp\rapidanalytics\bin>run.bat
    Calling C:\temp\rapidanalytics\bin\run.conf.bat

    C:\temp\rapidanalytics\bin>

    7. And this is where Im at, nothing seems to happen..


    Best regards,

    JC
  • fischerfischer Member Posts: 439 Maven
    Hi,
    Corel wrote:

    6. Edited run.conf.bat with the path to Java (set "JAVA_HOME=C:\Program Files (x86)\Java\jre6\bin").
    There are at least two issues with this:
    • Please check the quortes in this line
    • JAVA_HOME should not point to the bin directory but to the JRE directory itself.
    Best,
    Simon
  • pemguinkplpemguinkpl Member Posts: 14 Contributor II
    Hi,

    I have the problem to ran the tables_sqlServer.sql which created the tables. I get the error msg as below:

    ===================================

    Unable to start the Transact-SQL debugger. The Transact-SQL debugger does not support SQL Server 2005 or earlier versions of SQL Server. (SQLEditors)

    ------------------------------
    Program Location:

      at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.DebugWrapper.Start()
      at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.OnDebugScript(Object sender, EventArgs a)


    May i know what is the problem?

    Thank You!!
  • fischerfischer Member Posts: 439 Maven
    Hi,

    are you sure you are using the correct JDBC driver for your version of MS SQL Server?

    Best,
    Simon
Sign In or Register to comment.