Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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

Can anyone confirm that RapidAnalytics (JBoss bundle) works on a Windows 2008 x64 R2 server with MS SQL 2008?

Best Regards,

JC

Find more posts tagged with

AI Studio

Server

SQL

Accepted answers

All comments

fischer

Hi,

yes, next door.

Best,
Simon

jcornelius

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

fischer

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

pemguinkpl

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!!

fischer

Hi,

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

Best,
Simon