SAP Knowledge Base Article - Preview

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

Symptom

  • 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.name, 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 si.id =
C so.id AND si.indid between 1 and 254 AND so.name = ? AND so.uid = su.uid AND s
C u.name = ?
C /* R3:CL_SQL_STATEMENT==============CP:500 T:sysindexes M:250 */

  • No ST22 dump is generated when error is returned.


Read more...

Environment

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

Product

SAP Business Warehouse all versions ; SAP Sybase IQ all versions

Keywords

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 for Me (Login required).

Search for additional results

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