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

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

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

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