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 ONE Support launchpad (Login required).

Search for additional results

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