3592954 - SAP IQ - Locking Issue During Data Migration via Proxy Table

• Encountered a locking issue while migrating data from one SAP IQ server to another using a proxy table.
• The issue is reproducible and occurs when copying a table with approximately 2 million rows from one SAP IQ server to another.
• An error message is received indicating that a user has the row in the table locked:
  

  • Could not execute statement.

    Error accessing server 'IQT123': [SAP][ODBC Driver][SAP IQ] User 'another user' has the row in 'Test111' locked

• Chained option is off and the table is totally private.
• The issue does not occur when migrating a smaller table with 1000 rows and three varchar fields.

SAP IQ

SAP IQ, Data Migration, Proxy Table, Locking Issue, Error, s_data_sync.Force_Updatable_Cursors , KBA , BC-SYB-IQ , Sybase IQ , Problem