2534024 - Unable to connect to SQL Server 2012 from Lumira Desktop

SAP Knowledge Base Article - Public

2534024 - Unable to connect to SQL Server 2012 from Lumira Desktop

Symptom

  • Attempting to connect to Microsoft SQL Server 2012 results in the error message:
    com/microsoft/sqlserver/jdbc/SQLServerDriver has been compiled by a more recent version of the Java Runtime (class file version 52.0), this version of the Java Runtime only recognizes class file versions up to 51.0

Environment

  • SAP Lumira Desktop 1.31.x
  • Microsoft Windows
  • Microsoft SQL Server 2012

Reproducing the Issue

  1. In Lumira Desktop click on File > New
  2. Select "Query with SQL"
  3. Click on the MS SQL 2012 driver
  4. Enter Database details
  5. Click Connect

Cause

  • SAP Lumira uses SAP JVM 7 (Java Virutal Machine), Lumira needs to be pointed to Java 8 in order for this driver to run successfully

Resolution

  1. Edit C:\Program Files\SAP Lumira\Desktop\SAPLumira.ini in notepad or other text editor
  2. At the very top of the file add these lines (note they should be two separate lines):
    -vm
    C:\Program Files\Java\jre1.8.0_31\bin

Please note:

  • The path most likely will be different depending on the install and version of Java installed on the machine.
  • Save the file and start Lumira.
  • On install of a patch the SAPLumira.ini will be overwritten and this fix will need to be applied again.

Keywords

KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem

Product

SAP Lumira, desktop edition 1.0