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
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.