Options

"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

  • Options
    fischerfischer Member Posts: 439 Maven
    Hi,

    yes, next door.

    Best,
    Simon
  • Options
    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
  • Options
    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
  • Options
    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!!
  • Options
    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.