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

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]

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

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