SAP Knowledge Base Article - Preview

2157823 - Error: Could not restore session: autocommit must be off when using JDBC to connect HANA in IDT

Symptom

  • Error: Could not restore session: autocommit must be off when using JDBC connection to retrieve history data from a history table of HANA in IDT
  • The error persists after setting JDBC Driver Properties to autocommit=off

 


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.x
  • SAP HANA Database 1.0
  • Information Design Tool (IDT)

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

BOE, BI4, history table, autocommit, auto_commit, SAP DBTech JDBC, hana history,auto commit , KBA , BI-BIP-IDT , Information design tool , 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 ONE Support launchpad (Login required).

Search for additional results

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