DBIF_REPO_SQL_ERROR while trying to activate ENVIRONMENTSHELL for BPC 10.0 NW on HANA

[Former Member]

Hi experts,

I'm getting this short dump "DBIF_REPO_SQL_ERROR" while trying to activate the ENVIRONMENTSHELL(UJS_ACTIVATE_CONTENT) for BPC 10.0 NW on Hana database :

Category                  Resource Shortage

Runtime Errors         DBIF_REPO_SQL_ERROR

Short Text

    SQL error "-10760" while accessing program "CX_SY_OPEN_SQL_DB=============CP" part "LOAD".

What happened?

    Database error text: "Memory allocation failed."

Error analysis

    Database error text: Memory allocation failed.

    Triggering SQL statement:  "CX_SY_OPEN_SQL_DB=============CP        "

System environment

    SAP Release..... 740

    SAP Basis level 0005

    Application server... vSAPPRD

    Network address...... 172.16.10.230

    Operating system... Windows NT

    Release.............. 6.2

    Hardware type....... 4x AMD64 Level

    Character length..... 16 Bits

    Pointer length........ 64 Bits

    Work process number... 9

    Shortdump setting. full

    Database server... hana-prd

    Database type..... HDB

    Database name..... PRD

    Database user ID SAPPRD

   Terminal.......... Maha-HP

    Character set C

    SAP kernel....... 741

    Created on....... Mar 21 2014 17:31:58

    Created at....... NT 6.0 6002 x86 MS VC++ 16.00

    Database version SQLDBC 1.00.60.0379371

    Patch level....... 26

    Patch text.......

    Database............. HDB 1.0

   SAP database version. 741

   Operating system... Windows NT 5.1, Windows NT 5.2, Windows NT 6.0, Windows NT

   6.1, Windows NT 6.2, Windows NT 6.3

   Memory consumption

   Roll.... 0

   EM...... 44600400

   Heap.... 0

   Page.... 49152

   MM used. 33089488

   MM free. 4949248

The program interrupted was SAPLSADB

Thanks

Maha

[Former Member · Accepted solution]

Hi Maha,

Please check the versions of:

HANA server
HANA client (on HANA server)
HANA client (on the PAS)
SAP Kernel (both the generic and HDB specific files)

The versions between them should be in sync.

My issue with the error: " CX_SY_OPEN_SQL_DB=============CP        " is resolved by applying the latest SAP Kernel 7.41 Patches which is currently patch level 43.

Good luck!

Regards,

Mike