SAP Knowledge Base Article - Preview

2277951 - After Import of transport request containing more than 30 DAP-s ends with an exception in class CL_RSSDA_FEDERATION_SERVICES

Symptom

A transport request, which contains more than 30 Data Archiving Processes, is imported in a HANA system. The included DAP's use SDA (Smart Data Access). The log of the after import contains the following error messages:

  • RSDA140 Exception   occurred in line 36 of include CL_SQL_STATEMENT==============CM004 (program CL_SQL_STATEMENT==============CP)
  • RSSDA001 Error in BW: Error checking table XXX:
  • RSDA140 Exception   occurred in line 27 of include CL_RSSDA_FEDERATION_SERVICES==CM001 (program CL_RSSDA_FEDERATION_SERVICES==CP)

The systemlog (SM21) contains the following warning:

  • Database selection with invalid cursor

The work process trace contains the following information:

  •   *** ERROR => more than 30 native SQL cursors opened
     [dbdssdb.cpp  2541]
    C  00 : qstate=-2, hold=0, prepped=0
    C  SQL COMMAND: SELECT COUNT(*) FROM sys.functions      WHERE schema_name          = ?        AND function_name     \
  • B  ***LOG BY7=> invalid cursor specified            for database selection [dbacds       1944]


Read more...

Environment

  • SAP NetWeaver BW 7.40 on HANA
  • SAP NetWeaver 7.40 on HANA

Product

SAP NetWeaver 7.4

Keywords

CL_RSSDA_FEDERATION_SERVICES, CL_SQL_STATEMENT, EXISTS_VIEW_WITH_PARAMS CL_DD_DB_VIEW_HDB, IF_RSDAI_NEARLINE_CONNECTION~ALTER_TABLE CL_RSDA_SYB_CONNECTION_IMPL, RSSDA 001, RSDA 140, RS_DAPA_AFTER_IMPORT , KBA , BW-WHM-DST-ARC , Archiving , BW-WHM-MTD-CTS , Transport connection , HAN-DB-SDA , SAP HANA Smart Data Access , 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.