SAP Knowledge Base Article - Preview

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

Symptom

  • 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  


Read more...

Environment

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

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7

Keywords

hung, loop, stuck, migration, upgrade, overflow, , KBA , BC-SYB-IQ , Sybase IQ , 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.