SAP Knowledge Base Article - Preview

3512269 - How to disable implicit transactions mode when connecting to Azure Synapse with JDBC in SAP BusinessObjects Business Intelligence Platform

Symptom

  • Scheduling or refreshing Webi reports from BI Launchpad using Azure Synapse database with JDBC connection successfully.
  • From the database side, the "set implicit_transactions on" statement consistently appears at the beginning of each transaction, which blocks other processes from executing queries.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.x
  • All supported Operating System
  • Azure Synapse Analytics
  • JDBC middleware

Product

SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3

Keywords

JDBC, begin_sql, Azure Synapse, set implicit_transactions on, implicit, transactions, bo, boe, bi, 4.x , KBA , BI-BIP-SL , Semantic Layer , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.