SAP Knowledge Base Article - Preview

2401674 - LOAD TABLE fails to write row log file - SAP IQ

Symptom

In the Windows environment, writing the Row log file fails when LOAD TABLE is repeatedly executed.
This error will recur until restarting the SAP IQ server.

Could not execute statement.
  OS error reported on file: C:\iqdemo\table02.rowlog . OS error: 0
  --
  (oslib\hos_io.cxx 782)
  SQLCODE=-1006131, ODBC 3 State="HY000"
  File: "repro02.sql" on line 2, column 1
  insert into "table02" ignore constraint all 0 message log 'C:\iqdemo\table02.m
sglog' row log 'C:\iqdemo\table02.rowlog' only log all select "col01","col02","c
ol03","GETDATE"(),"col05","col06","col07","col08","col09","col10","col11","col12
","col13","col14","col15","col16","col17","col18","col19","col20","col21","col22
","col23","col24","col25","col26","col27","col28","col29","col30","col31" from "
table01"
  You can continue executing or stop.
1. Stop
2. Continue
Select an option:
 


Read more...

Environment

  • SAP IQ 16.0
  • Windows

Product

SAP IQ 16.0

Keywords

SAP IQ, IQ, load table, OS error: 0, row log , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.