1922515 - IQ 12.7 local store migration utility iqlsunload does not complete

• Execution of the multiplex local store migration utility iqlsunload does not complete
• The utility never returns and needs to be cancelled
• Messages it produces in IQ server log appear to been in a loop of the following...

I. 10/03 08:09:14. In table 'temp_rowids', the full width insert of 1 columns will begin at record 1.
I. 10/03 08:09:14. Insert Pass 1 completed in 0 seconds.
I. 10/03 08:09:14. Insert Pass 2 completed in 0 seconds.
I. 10/03 08:09:14. 
I. 10/03 08:09:14.  63 records were inserted into 'temp_rowids'.

• Initial messages it produces in the SQL request log show the initial ROW COUNT is set to 63

10/03 08:09:13.898 ** REQUEST conn: 97373 STMT_EXECUTE_IMM        "SET TEMPORARY OPTION ROW_COUNT = 63"
10/03 08:09:13.901 ** DONE    conn: 97373 STMT_EXECUTE_IMM        
10/03 08:09:13.901 ** REQUEST conn: 97373 STMT_EXECUTE_IMM        "CREATE LOCAL TEMPORARY TABLE temp_rowids( rowid_col bigint )"
10/03 08:09:14.292 ** DONE    conn: 97373 STMT_EXECUTE_IMM        
10/03 08:09:14.292 ** REQUEST conn: 97373 STMT_EXECUTE_IMM        "INSERT INTO temp_rowids( rowid_col ) SELECT rowid( "tm_usage_revenue_ict" ) FROM "CREATOR"."tm_usage_revenue_ict" WHERE rowid( "tm_usage_revenue_ict" ) > 0 ORDER BY rowid( "tm_usage_revenue_ict" ) ASC "
10/03 08:09:14.316 ** DONE    conn: 97373 STMT_EXECUTE_IMM        
10/03 08:09:14.316 ** REQUEST conn: 97373 STMT_PREPARE            "SELECT MIN( rowid_col ), MAX( rowid_col ), COUNT( * ) FROM temp_rowids "     

• Subsequent messages it produces in the SQL request level log appear to be in a loop of the following .....

10/03 08:09:14.364 ** REQUEST conn: 97373 STMT_EXECUTE_IMM        "TRUNCATE TABLE temp_rowids"
10/03 08:09:14.374 ** DONE    conn: 97373 STMT_EXECUTE_IMM        
10/03 08:09:14.374 ** REQUEST conn: 97373 STMT_EXECUTE_IMM        "INSERT INTO temp_rowids( rowid_col ) SELECT rowid( "tm_usage_revenue_ict" ) FROM "CREATOR"."tm_usage_revenue_ict" WHERE rowid( "tm_usage_revenue_ict" ) > 126 ORDER BY rowid( "tm_usage_revenue_ict" ) ASC "
10/03 08:09:14.393 ** DONE    conn: 97373 STMT_EXECUTE_IMM        
10/03 08:09:14.393 ** REQUEST conn: 97373 STMT_PREPARE            "SELECT MIN( rowid_col ), MAX( rowid_col ), COUNT( * ) FROM temp_rowids "
10/03 08:09:14.393 ** DONE    conn: 97373 STMT_PREPARE            Stmt=148132 
10/03 08:09:14.393 ** REQUEST conn: 97373 CURSOR_OPEN             Stmt=148132 
10/03 08:09:14.395 ** DONE    conn: 97373 CURSOR_OPEN             Crsr=148133 
10/03 08:09:14.400 ** WARNING conn: 97373 code: 100 "Row not found"
10/03 08:09:14.400 ** REQUEST conn: 97373 CURSOR_CLOSE            Crsr=148133 
10/03 08:09:14.401 ** DONE    conn: 97373 CURSOR_CLOSE            
10/03 08:09:14.401 ** REQUEST conn: 97373 STMT_DROP               Stmt=148132 
10/03 08:09:14.401 ** DONE    conn: 97373 STMT_DROP  

• SAP SYBASE IQ 12.7 ESD 5 upwards
• SAP SYBASE IQ 15.x
• SAP SYBASE IQ 16.x

hung, loop, stuck, migration, upgrade, overflow, , KBA , BC-SYB-IQ , Sybase IQ , Problem