SAP Knowledge Base Article - Preview

2583093 - SQL error "SQL code: -10709" occurred while accessing table "UJAM_ACT_CACHE" - BPC NW 10.1

Symptom

The following dump happened many times in ST22:

Category               Installation Errors
Runtime Errors         DBSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB

----------------------------------------------------------------------------------------------------
|Short Text 
|    SQL error "SQL code: -10709" occurred while accessing table "UJAM_ACT_CACHE".      
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|What happened?
|    Database error text: "SQL message: Connect failed (connect timeout expired)"         
----------------------------------------------------------------------------------------------------

The following information was logged in dev trace.
C  Try to connect via secure store (SERVICE) on connection 1 ...
C
C Mon Dec 18 11:43:26 2017
C  *** ERROR => Connect to database failed, rc=1, rcSQL=-10709
 [dbhdbsql.cpp 360]
C  {root-id=005056ABA9FD1ED7B8F4B118EBE71E41}_{conn-id=005056ABA9FD1ED7B8F4B118EBE73E41}_1
C  SQLCODE    : -10709
C  SQLERRTEXT : Connect failed (connect timeout expired)


Read more...

Environment

  • SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver
  • HANA database

Product

SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver

Keywords

EPM, BPC  NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, UJAM_ACT_CACHE, hana , KBA , EPM-BPC-NW , NetWeaver Version , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

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