last changed: 30th of November 2023
ADBC error 'Internal error 16 has occurred' (refers to old/missing ODBC libraries, Notes 2516116, 2844842
Allocation failed. Dbspace IQ_SYSTEM_TEMP is OUT OF SPACE (refers to SAP Note 2982226, IQ Temp Space)
internal error: Cannot get remote source objects: (refers to incorrect IQ remote source, Notes 1989436 and 3196447)
internal error: Remote execution error [Sybase][ODBC Driver][Sybase IQ]
internal error: Error executing query [SAP][ODBC Driver][SAP IQ]
invalid remote object name: Cannot retrieve why the ODBC API has failed: line 0 col 0 (at pos 0) (refers to HANA ODBC/SDA Driver mismatch and old HANA Studio, Notes 2184030, 2352696)
Invalid data type comparison in predicate (refers to Note 2601496)
DBCO_CONNECTION_NO_METADATA (refers to DB lock/timeout within the ODBC connection, Notes 1983389, 3017355)
ERROR => Codepage mismatch between executable (UNICODE) and DBSL shared library dbsybslib.so (ASCII refers to Notes 1820534, 3210816 only UC supported for ASE/IQ LibDBSL)
[IQ Error SQL-85:08S01][SAP][ODBC Driver][SAP IQ]Communication error (refers to timeout => IQ Setup, Notes 2578523, 2767466, 3017355)
[IQ Error SQL-100:08001][SAP][ODBC Driver][SAP IQ]Database server not found (IQ ServerName/SYBASE_IQ_ENGINE missing, refers to SAP Note 3136413)
[IQ Error SQL-121:42000][SAP][ODBC Driver][SAP IQ]Permission denied: you do not have required privilege to create table "udatest" (refers to Notes 1989436, 2372218, create table/index with user DBA)
[IQ Error SQL-131:42000][SAP][ODBC Driver][SAP IQ]Syntax error near '999' on line 1 (refers to IQ Setup Notes 2754330, 2785785, 3017355)
[IQ Error SQL-131:42000][Sybase IQ]Syntax error near '(end of line)' on line 1 (refers to wrong/missing DB user space - Notes 1959690 and 2297484)
[IQ Error SQL-141:42S02][SAP][ODBC Driver][SAP IQ]Table 'part_ ' missing (refers to Notes 2190504, 3009988)
[IQ Error SQL-141:42S02][SAP][ODBC Driver][SAP IQ]Table '/BI0/ONTCT_C01' not found (run RSDG_ADSO_ACTIVATE and recreate DAP Notes 2698039, 2910697)
[IQ Error SQL-143:42S22][Sybase IQ]Column 'RECORDMODE' not found (refers to SAP Note 2996682)
[IQ Error SQL-143:42S22][Sybase IQ]Column 'ARCHREQUID_SID' not found (refers to SAP Note 2562256)
[IQ Error SQL-157:07006][Sybase IQ]Cannot convert to a Unknown TypeID (refers to outdated LibDBSL, Note 2481656)
[IQ Error SQL-210:40001][Sybase IQ]User 'another user' has the row locked (refers to multiple writes Notes 2524688, 2886870)
[IQ Error SQL-308:08S01][SAP][ODBC Driver][SAP IQ]Connection was terminated (refers to timeout => IQ Setup, Note 3017355)
[IQ Error SQL-308:HY000][Sybase IQ]Connection was terminated (refers to IQ TEMP and BACKUP issues)
[IQ Error SQL-308:HY000][SAP][ODBC Driver][SAP IQ]Connection was terminated (refers to message above)
[IQ Error SQL-308:HY000][SAP][ODBC Driver][SAP IQ]Connection was terminated [dbds 505] (refers to Note 3298954)
[IQ Error SQL-308:HY000][SAP][ODBC Driver][SAP IQ]Connection was terminated Function COMMIT failed (refers to Note 2977213)
[IQ Error SQL-771:HY000][Sybase IQ]Event 'BACKUP_REQUEST' not found (refers to Note 2741824)
[IQ Error SQL-771:HY000][SAP][ODBC Driver][SAP IQ]Event 'BACKUP_REQUEST' not found
[IQ Error SQL-853:24000][Sybase IQ]Cursor not in a valid state (refers to SAP Note 2982226)
[IQ Error SQL-1068:42S02][SAP][ODBC Driver][SAP IQ]Default dbspace '<USER DB SPACE>' not found (missing DB space after IQ copy, refer to Notes 2634028, 2634024)
[IQ Error SQL-1084:HY000][SAP][ODBC Driver][SAP IQ]Use of feature 'DBSPACE' is not allowed (refers to wrong SSL/TLS IQ Setup)
[IQ Error SQL-1285:HY000][Sybase IQ] You have run out of space in "DB user space" (refers to 2297484, DB space)
[IQ Error SQL-1090:08004][Sybase IQ]Function 'substr' has invalid parameter '3' ('-1') (refers to IQ Setup Notes 2287018, 3094594, 3017355)
[IQ Error SQL-1000121:HY000][SAP][ODBC Driver][SAP IQ]binary data not supported odata longer than 32767 Bind host variable (ILM - refers to SAP Note 2806115)
[IQ Error SQL-1000304:HY000][SAP][ODBC Driver][SAP IQ] Cannot drop a partition key column. (refers to Note 2190504 during BW/4 Conversion of NLS Objects)
[IQ Error SQL-1003007:HY000][Sybase IQ]Large Objects Management functionality is not license (Notes 1985209, 2183758, 2439006)
[IQ Error SQL-1009149:HY000][SAP][ODBC Driver][SAP IQ]BArray page header mismatch Internal (refers to IQ binary error, Notes 2709384 and 3006048)
[IQ Error SQL-1006042:HY000][Sybase IQ] All available virtual memory has been used; allocation cancelled => (refers to wrong IQ memory allocation, Notes 2464164, 3017355)
[IQ Error SQL99987]ERROR: could not start iq load. (refers to Notes 2933420, 3200088 missing space/SYBASE_IQ_LOAD_DIR in DBCO string)
[IQ Error SQL99988]ERROR: Driver SAP IQ is unsupported for connections to Sybase IQ
[IQ Error SQL99999]decimal overflow has occured (New, refers to Note 3217479)
[SAP][ODBC Driver][SAP IQ]User ID 'SAPNLS' does not exist (missing/wrong IQ User - refers to Note 2344235)
[SAP][ODBC Driver][SAP IQ]Not enough server threads available for this query (refers to Note 3017355)
SAP DBTech JDBC: [258]: insufficient privilege (refers to Note 3119008, permission of SAP<SID> user)
SAP DBTech JDBC: [403]: (refers to SDA/ODBC connection issues)
SAP DBTech JDBC: [403]: internal error:Cannot get remote source objects (mostly after Systemcopy, same as above)
SQLCode = -121: Permission denied: you don't have the permission to create objects in dbspace IQ_SYSTEM_MAIN (refers to DB Option Enable_LOB_Variables)
Savepoint 'current' not found for query "RELEASE SAVEPOINT" (refers to Note 2998815)
unexpected return code 8192 calling DBDS (refers to missing IQ Network Client, Note 3119008)
# error messages in conjunction with SSL/TLS
Encryption error: The FIPS library (libdbcrypto.so) cannot be found in the LD_LIBRARY_PATH
[SAP][ODBC Driver Manager] Unable to load driver libdbodbc17_r.so
[SAP][ODBC Driver][SQL Anywhere]Unable to connect: The server did not accept the requested encryption type
[SAP][ODBC Driver][SAP IQ]Connection error: Connection was dropped (may not be an SAP IQ server) SQLCODE=-832 SQLSTATE=08001
[IQ Error SQL-832:08001][SAP][ODBC Driver][SAP IQ]Connection error: TLS handshake failed [dbds 1138]
[IQ Error SQL-895:08001][SAP][ODBC Driver][SAP IQ]Encryption error: Unable to open certificate file '/usr/sap/B4H/SYS/global/hostname_SQ1_11.crt'
[IQ Error SQL-895:08001][SQL Anywhere]Encryption error: Unrecognized encryption option 'skip_certificate_name_check'
[IQ Error SQL-1145:08001][SAP][ODBC Driver][SAP IQ]Unable to connect: The server did not accept the requested encryption type
DBSL Dev: the option 'skip_certificate_name_check=yes' is automatically added in the DBCO connection string when DBSL finds libdbodbc17.so
CL_RSDA_ADSO_ARCHIVING_REQUESTCM01C
CL_RSDA_ADSO_ARCHIVING_REQUESTCM01U (refers to IQ performance settings, Note 2371160)
CL_RSDA_ADSO_ARCHIVING_REQUESTCM01Q (refers to IQ backup problems, Note 2741824 and RSDANLCON settings)
CL_RSDA_ADSO_CURSOR===========CM003 (refers to Note 3075223, NLS Archiving limit)
CL_RSDA_ADSO_DTO_PROCESS_INV==CM004 (refers to Note 3076162, enable load striping for DTO)
CL_RSDA_ADSO_RESTORE_REQUEST==CM00V (refers to SAP Note 2996682, BW System Inconcisteny)
CL_RSDA_ARCHIVING_REQUEST=====CM017 (refers to IQ backup, Notes 2741824, 3244231)
CL_RSDA_ADV_NEARLINE_WRITER===CM004 (refers to NLS DAP parallelization and Note 3265867)
CL_RSDA_ADV_NEARLINE_WRITER===CM006 (refers to SAP Note 2996682, Column 'RECORDMODE' missing)
CL_RSDA_DAP_A=================CM02A (refers to RSDAP activation/prod. usage)
CL_RSDA_DAP_A=================CM029 (refers to SAP Note 2562256, Column 'ARCHREQUID_SID' not found)
CL_RSDA_INFOPROV_WRITER_CUBE==CM003 (refers to MasterData inconcistencies, Note 2866852, IQ TEMP space)
CL_RSDA_INFOPROV_WRITER_CUBE==CM003 (refers to Note 3214341, improved error logging upon archiving reload)
CL_RSDA_INFOPROV_WRITER_CUBE==CP (refers to IQ timeout due to inconcistencies, Note 2289880)
CL_RSDA_INFOPROV_WRITER_ODSO==CM001 (refers to locked entries, Notes 2698039, 3040267)
CL_RSDA_INFOPROV_WRITER_ODSO==CM003 (refers to duplicate entries, Note 2400729)
CL_RSDA_NEARLINE_CONNECTION===CP (refers to missing NLS connection)
CL_RSDA_NEARLINE_OBJECT=======CM00Q (refers to IQ lock mode problems after copy)
CL_RSDA_NEARLINE_OBJECT=======CM01B (refers to IQ configuration problems, Note 3017355)
CL_RSDA_NEARLINE_OBJECT=======CM00T (refers to SDA setup problems, Note 3119008)
CL_RSDA_NEARLINE_REQUEST======CM004 (refers to missing IQ Backup event, Note 2741824)
CL_RSDA_NEARLINE_REQUEST======CM006 (refers to IQ copy problems, Notes 2344235 and 3085053)
CL_RSDA_NEARLINE_SEGMENT======CCIMP (refers to SAP Note 2982226, IQ Temp Space)
CL_RSDA_NEARLINE_WRITER=======CM002 (refers to NLS configuration RSDANLCON and Note 2307267)
CL_RSDA_NEARLINE_WRITER=======CM004 (refers to NLS DAP and request size, Note 3075223)
CL_RSDA_RESTORE_REQUEST=======CM00A (refers to locked entries, Notes 2698039, 3040267)
CL_RSDA_SYB_CONNECTION_IMPL===CP (refers to missing IQ ODBC drivers and IQ backup, Note 3119008)
CL_RSDA_SYB_CONNECTION_IMPL===CM006 (refers to wrong setup of RSDANLCON, "is Default Con" not ticked)
CL_RSDA_SYB_CONNECTION_IMPL===CM00C (refers to IQ Options Notes 2131245, 2482264, 3017355)
CL_RSDA_SYB_CONNECTION_IMPL===CM00E (refers to IQ configuration/concisteny problems, Note 3017355)
CL_RSDA_SYB_CONNECTION_IMPL===CM00K (refers to SAP Note 3119008, wrong SDA/ODBC con.)
CL_RSDA_SYB_CONNECTION_IMPL===CM00L (refers to SAP Note 3119008, wrong IQ Client SW)
CL_RSDA_SYB_CONNECTION_IMPL===CM00X (refers to Note 2191066, missing backup)
CL_RSDA_SYB_CONNECTION_IMPL===CM01J (refers to IQ License LOB/VLDBMGMT Notes 2372218, 2628620)
CL_RSDA_SYB_CONNECTION_IMPL===CM01T (refers to DAP inconcistency, update Report RSDG_ADSO_ACTIVATE)
CL_RSDA_SYB_CONNECTION_IMPL===CM02B (refers to HANA perm. and ODBC driver, Notes 2352696, 3106440)
CL_RSDA_SYB_CONNECTION_IMPL===CM02K (refers to missing IQ Backup setup, see below)
CL_RSDA_SYB_CONNECTION_IMPL===CM02U (refers to missing IQ Backup, Notes 2658428, 2741824, 3017355)
CL_RSDA_SYB_CONNECTION_IMPL===CM03T (refers Report RSDA_CLEANUP_DTO_COLDSTORE)
CL_RSDA_SYB_CURSOR============CM002 (refers to SAP Note 2996682, BW System Incconcisteny)
CL_RSDA_SYB_CURSOR============CM004 (refers to SAP Note 3217479, BW System Incconcisteny)
CL_RSDA_SYB_WRITER_STRIPED====CM002 (refers to Notes 2307267, 2902060 NLS load stripping mismatch)
CL_RSDA_SYB_WRITER_TSN_STRIPEDCM002 (refers to Notes 2307267, 2902060 NLS load stripping mismatch)
CL_RSDA_SYB_WRITER_TSN========CM002 (refers to Notes 2464164, 3017355 IQ memory configuration)
CL_RSDA_SYB_WRITER_TSN========CP (refers to the last three messages above)
CL_RS2HANA_VIEW_OBJ===========CM004 (refers to CL_RSDA_SYB_CONNECTION_IMPL===CM02B)
CL_RSSDA_FEDERATION_SERVICES==CM004 (refers to HANA priv. and no spc on device, Notes 1989436/2902060)
CL_RSSDA_FEDERATION_SERVICES==CM00H (refers to HANA virtual Index creation, Note 2790789)
CL_RSSDA_FEDERATION_SERVICES==CM00O (refers to System/Migration issues, Note 2953944)
CL_RSSDA_FEDERATION_SERVICES==CM011 (new, refers to BW/4 2021 during RSDANLCON setup)
CL_RSSDA_REMOTE_SOURCE========CM009 (new, refers to BW/4 2021 missing HANA remote source temporary)
CL_RSDRS_SQL_QUERY============CM01C (refers to InfoCube/aDSO Model Complexity, Note 2720236)
CL_SQL_RESULT_SET=============CM006 (refers to ABAP bottleneck and straggler, Notes 2509498, 3056306, 3206592)
CL_SQL_STATEMENT==============CM002 (refers to IQ configuration problems, Note 3017355)
CL_SQL_STATEMENT==============CM004 (refers to general problems, i.e. timout, large result set, etc.)
CL_SQL_STATEMENT==============CM008 (refers to Note 2482264, space problem)
of course you should check your Software Level as well to ensure that you are up-to date with the SAP Corrections - Access Expert Search
Version | SP-Level | Current SP (06/2023) | Support |
SAP BW 7.40 | 26 | SAPKW74026 | until End of 2020 |
SAP BW 7.50 | 27 | SAPK-75022INSAPBW | until End of 2027 |
SAP BW/4 1.0 | 20 | SAPK-10020INDW4CORE | until End of 2021 |
SAP BW/4 2.0 | 15 | SAPK-20010INDW4CORE | until End of 2024 |
SAP BW/4 2021 | 6 | SAPK-30001INDW4CORE | commitment until 2040 |
Components | Category | ||
BW-WHM-DST-ARC | BW/4 only | BW4-DM-DTO | Program Error |
BW-SYS-DB-IQ | optional | BW-WHM-DST-DTP | Search Term |
BC-SYB-IQ | optional | BW-WHM-DBA-ADSO | archive, near-line, IQ |
I still remember this phrase from a Swiss SAP Sales Person from my early days.
I told him, that I did some Consulting activities which helped
one of many Customers to move forward with their SAP BW Solution.
His Answer to that Information was fairly simple for him:
"Roland, what is your Point? I can only remember three things at the time."
Also the following Issues have to be considered here, when the SDA/ODB connection worked in the past and suddenly not anymore:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
54 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |