2160781 - Error HDB 11009: Unable to Publish Datasets and Stories to Lumira Server

SAP Knowledge Base Article - Public

2160781 - Error HDB 11009: Unable to Publish Datasets and Stories to Lumira Server

Symptom

When publishing any stories or datasets from Lumira Desktop to Lumira Server, you are getting this error message:

  • Error: Dataset cannot be published to SAP Lumira Server; publishing to SAP HANA layer failed. Reason: '<Not Available>'. (HDB 11009)

In HANA trace files, the following log entries are recorded when the error occured:

  • xsengine trace and alert file:
    • [6534]{-1}[-1/-1] 2015-04-24 16:12:31.575595 e xsa:sap.bi.launc sap.bi.launchpad.logic.lib:ResponseHandler.xsjslib(00119) : InternalError: dberror(CallableStatement.execute): 326 - CURRVAL of given sequence is not yet defined in this session[326] "_SYS_BIC"."sap.bi.launchpad.db.havana_procedures/HAVANA_CREATE_DATASET": line 3 col 5 (at pos 434): [326] (range 3) CURRVAL of given sequence is not yet defined in this session exception: CURRVAL of given sequence is not yet defined in this session:  [326] "_SYS_BIC"."sap.bi.launchpad.db.procedures/CREATE_DATASET": line 16 col 9 (at pos 950): [326] (range 3) CURRVAL of given sequence is not yet defined in this session exception: CURRVAL of given sequence is not yet defined in this session:  [326] "_SYS_BIC"."sap.bi.launchpad.db.procedures/CREATE_ITEM": line 102 col 9 (at pos 4307): [326] (range 3) CURRVAL of given sequence is not yet defined in this session exception: CURRVAL of given sequence is not yet defined in this session: cannot find currval location by session_id:215807, seq id:2107194, seq version:1 at function __nextval__() at ptime/session/eapi/jdbc/ExternalStatement.cc:917
  • indexserver trace and alert file
    • [59070]{215807}[82/21521550] 2015-04-24 16:12:31.547824 e cePlanExec       cePlanExecutor.cpp(06890) : Error during Plan execution of model _SYS_BIC:_SYS_SS_CE_72057594040037338_INS (-1), reason: "_SYS_BIC"."sap.bi.launchpad.db.havana_procedures/HAVANA_CREATE_DATASET": line 3 col 5 (at pos 434): [326] (range 3) CURRVAL of given sequence is not yet defined in this session exception: CURRVAL of given sequence is not yet defined in this session:  [326] "_SYS_BIC"."sap.bi.launchpad.db.procedures/CREATE_DATASET": line 16 col 9 (at pos 950): [326] (range 3) CURRVAL of given sequence is not yet defined in this session exception: CURRVAL of given sequence is not yet defined in this session:  [326] "_SYS_BIC"."sap.bi.launchpad.db.procedures/CREATE_ITEM": line 102 col 9 (at pos 4307): [326] (range 3) CURRVAL of given sequence is not yet defined in this session exception: CURRVAL of given sequence is not yet defined in this session: cannot find currval location by session_id:215807, seq id:2107194, seq version:1 at function __nextval__()

NOTE: SAP Lumira, server version for SAP HANA and SAP Lumira Cloud are being retired and will no longer receive new feature investments.

For more information please refer to SAP Knowledge Base Article:

"2195103 - Certain SAP Lumira features are not supported in SAP Lumira Server for HANA and SAP Lumira Cloud"

Environment

  • SAP Lumira Server, version 1.22
  • SAP Lumira Desktop, version 1.22
  • SAP HANA Platform, revision 82 

Reproducing the Issue

  1. In Lumira Desktop, choose an existing document, or create a new one in Lumira Desktop, based on any data source (excel spreadsheet, universe, etc.)
  2. Create a visualization story, and click "Publish to SAP Lumira Server" in the share room
  3. Log in Lumira Server
  4. Confirm publish options
  5. HDB 11009 Error message appears

Cause

This issue is caused by a known bug (id 72560) in HANA database. For details please refer to SAP Note 2155663.

Root cause analysis (from internal bug report):

  • To get CURRVAL and NEXTVAL of a SEQUENCE, we need the ObjectId of that SEQUENCE. Here, the length of ObjectId is 8 bytes but the CURRVAL and NEXTVAL internally handled the ObjectId as a 4 byte integer. Thus, this happens only when the ObjecId of a SEQUENCE is larger than the maximum 4 byte integer number (2,147,483,647).
  • You can check the ObjecId of a sequence from the system table:SEQUENCES. The following SQL query retrieves all the sequences in Lumira Server:
    • SELECT SEQUENCE_NAME, SEQUENCE_OID FROM SEQUENCES where SEQUENCE_NAME like 'sap.bi%'
    • On a non-working system, you would see the SEQUENCE_OID which are larger than 4 bytes:
      sequence_oid.png

Resolution

This bug has been identified and fixed. The targeted release is HANA SPS09 Database Revision 96 (version 1.00.096), and Maintenance Revision 1.00.85.04. This KBA will be updated with their release dates.

See Also

2155663 - Selecting sequence NEXTVALfails with CURRVAL of given sequence is not yet defined in this session

Keywords

lumira server, lumsrv, lumsvr, ls4hana, hana db, bug, issue, error, problem, unable, can't, cannot, publish, upload, send, save, dataset, story, visualization, compose, share, acquire, HDB11009, 11009, HDB error, , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Bug Filed

Product

SAP Lumira, desktop edition 1.0