3265867 - Data archiving job fails with the error "Database returned the SQL code 143-. Error text: [IQ Error SQL-143:42S22][SAP][ODBC Driver][SAp IQ]Column 'XXXX' not found"

The archiving job "BI_ARCH-<InfoProvider>-CREATE" fails with the below errors:

Database returned the SQL code 143-. Error text: [IQ Error SQL-143:42S22][SAP][ODBC Driver][SAP IQ]Column 'XXXX' not found                           
Exception  occurred in line 26 of include CL_RSDA_SYB_WRITER============CM004 (program CL_RSDA_SYB_WRITER============CP)    
SQLCode = -143: Column 'XXXX' not found. 
Exception  occurred in line 63 of include CL_RSDA_SYB_WRITER============CM004 (program CL_RSDA_SYB_WRITER============CP)    
General error in BW archiving (-> see long text)                                                               
Exception  occurred in line 70 of include CL_RSDA_NEARLINE_WRITER=======CM002 (program CL_RSDA_NEARLINE_WRITER=======CP)     
Processing of data archiving process <InfoProvider> canceled  
Job canceled after system exception ERROR_MESSAGE  

• SAP Netweaver 7.5.

Data archiving process , DAP , Infoprovider , SQL code 143 , BW archiving , SAP IQ , KBA , BW-WHM-DST-ARC , Archiving , Problem