Symptom
- Running an SQL query results in error "HDB 00102" or "Statement cancelled due to timeout in Lumira when trying to create dataset"
Environment
- Lumira Desktop 1.31
- Windows Server 2012
- MySQL 5.6.23
- MySQL JDBC driver 5.1.39
Reproducing the Issue
- Click on File->New
- Select Query with SQL and connection from the MySQL database.
- Enter the dataset name and insert SQL query
- Run Query
Cause
- Driver version has compatibility issues with Lumira
Resolution
- Use MySQL JDBC Driver 5.1.34
Keywords
Lumira Desktop MySQL , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem
Product
SAP Lumira, desktop edition 1.0