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

Environment

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

Reproducing the Issue

1. Create a history table in HANA database.
2. Create a new JDBC connection to connect HANA database.
3. Create a new data foundation based on this connection.
4. Try to retrieve history data of the history table in the data foundation and the issue occurs.

Cause

• The session parameter Auto_Commit should be set as off when retrieving history data from a history table in HANA database.
• The default Transaction Mode of HANA JDBC connection is AutoCommit, which is defined in newdb.sbo file.

Resolution

1. Backup the file newdb.sbo under the folder <InstallPath>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc.
2. Open the file using notepad.
3. Delete the line below:
   <Parameter Name="Transaction Mode">AutoCommit</Parameter>
4. Save the file and restart Connection Server.

Keywords

BOE, BI4, history table, autocommit, auto_commit, SAP DBTech JDBC, hana history,auto commit

Header Data

Released On	19.05.2015 02:55:32
Release Status	Released to Customer
Component	BI-BIP-IDT Information design tool
Other Components	BI-BIP-SL Semantic Layer
Priority	Normal
Category	Problem