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:
Environment
- SAP Lumira Server, version 1.22
- SAP Lumira Desktop, version 1.22
- SAP HANA Platform, revision 82
Reproducing the Issue
- In Lumira Desktop, choose an existing document, or create a new one in Lumira Desktop, based on any data source (excel spreadsheet, universe, etc.)
- Create a visualization story, and click "Publish to SAP Lumira Server" in the share room
- Log in Lumira Server
- Confirm publish options
- 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:
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