SAP Knowledge Base Article - Preview

2813506 - Error SQL-852 returned when creating IQ DataSource from RSA1


  • You want to develop reports on top of IQ table
  • You have completed the DBCO connection with IQ system and tested the connection successfully.
  • From RSA1 you try to create the IQ datasource (RSA1 > Create DataSource), after entering schema name you are getting list of IQ tables in correct manner but when you click in the Proposal Tab this error is returned: 

SQL error 852- with message : [IQ Error SQL-852:42513][Sybase IQ]Table name 'sys
Message no. RSDS_ACCESS023

  • From the developer trace file this can be found:

C ERROR: -1 in function PrepOperation (SQLPrepare) [line 31891]
C (-852) [42S13] [Sybase][ODBC Driver][Sybase IQ]Table name 'sysindexes' is ambiguous
sql statement is ==> SELECT, si.indid, CASE WHEN si.status & 2 = 2 THEN 'UNIQUE' ELSE 'NONUNI
C QUE' END, si.keycnt FROM sysindexes si, sysobjects so, sysusers su WHERE =
C AND si.indid between 1 and 254 AND = ? AND so.uid = su.uid AND s
C = ?
C /* R3:CL_SQL_STATEMENT==============CP:500 T:sysindexes M:250 */

  • No ST22 dump is generated when error is returned.



  • SAP Business Warehouse - All versions 
  • SAP Sybase IQ - All versions


SAP Business Warehouse all versions ; SAP Sybase IQ all versions


BW, data source, RSA1, IQ, sysindexes, ambiguous , KBA , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.