2362682 - Error "HDB 00102" or "Statement cancelled due to timeout in Lumira when trying to create dataset" when running SQL query

SAP Knowledge Base Article - Public

2362682 - Error "HDB 00102" or "Statement cancelled due to timeout in Lumira when trying to create dataset" when running SQL query

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

  1. Click on File->New
  2. Select Query with SQL and connection from the MySQL database.
  3. Enter the dataset name and insert SQL query
  4. 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