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

[Corel]

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

Best Regards,

JC

[Simon Fischer]

Hi,

yes, next door.

Best,
Simon

[Corel]

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

[Simon Fischer]

Hi,

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

[Simon Fischer]

Hi,

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

Best,
Simon