SAP Knowledge Base Article - Preview

2481656 - IQ Error SQL-157 Cannot convert to a Unknown TypeID error occur during BW archiving process - SAP BW with SAP IQ Near-line Storage

Symptom

You are performing BW DAP (Data Archiving Process) to archive data to SAP IQ database and fail with the following errors:

  • Error occur during the archiving process:

[IQ Error SQL-157:07006][Sybase IQ]Cannot convert to a Unknown TypeID (*)(*) (column
Message no. RSDA147
Exception occurred in line 51 of include CL_SQL_STATEMENT==============CM002 (program CL_SQL_STATEMENT==============CP)
Message no. RSDA140
SQLCode = -157: Cannot convert to a Unknown TypeID (*)(*) (column *)
Message no. RSDA_SYB004
Exception occurred in line 57 of include CL_RSDA_SYB_CONNECTION_IMPL===CM00C (program CL_RSDA_SYB_CONNECTION_IMPL===CP)
Message no. RSDA140
General error in BW archiving (-> see long text)
Message no. RSDA001
Diagnosis
An error has occurred, characterized by the following parameters:
1. Parameter:2. Parameter:3. Parameter:4. Parameter:
System Response
Processing was terminated.
Exception occurred in line 24 of include CL_RSDA_NEARLINE_WRITER=======CM004 (program CL_RSDA_NEARLINE_WRITER=======CP)
Message no. RSDA140

  • Checking in DEV trace, you will see following detailed errors:

C ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 14484]
C (-157) [07006] [Sybase][ODBC Driver][Sybase IQ]Cannot convert to a Unknown T
C ypeID (*)(*) (column ***)
C dbdssyb: DBSL99 SQL-157*
C [IQ Error SQL-157:07006][Sybase IQ]Cannot convert to a Unknown TypeID (*)(*) (column *)
B ***LOG BY2=> sql error -157 performing EXE [dbds 684]
B ***LOG BY0=> [IQ Error SQL-157:07006][Sybase IQ]Cannot convert to a Unknown TypeID (*)(*) (column *) [dbds


Read more...

Environment

  • SAP Sybase IQ 15.4
  • SAP IQ 16.0
  • SAP IQ 16.1
  • SAP NetWeaver BW 7.5

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP NetWeaver 7.5 ; SAP Sybase IQ 15.4

Keywords

IQ Error SQL-157, SQLCode = -157, RSDA147, RSDA_SYB004, STATEMENT @DBSL_SET_PARAM SYBASE_IQ_END_LOAD=1 , KBA , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , BW-WHM-DST-ARC , Archiving , 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.