Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

load table fails with hos_clientfileio.cxx:208,

IQ Guru's

user trying to load 10GB file from IQ client toIQ server, it fails in the middle of the load. I have this options set on the DB. Any suggestions please -

set option allow_read_client_file='on' ;

grant READCLIENTFILE to user ;

I. 07/15 07:09:01. 0001270195 PostCmt 0

I. 07/15 07:09:02. 0000000000 Cancellation request received:  SA connHandle: 1862  SA connID: 28  IQ connID: 0001270078  User: xxxx

I. 07/15 07:09:02. 0001270078 Exception Thrown from hos_clientfileio.cxx:208, Err# 9, tid 233 origtid 233

I. 07/15 07:09:02. 0001270078    O/S Err#: 0, ErrID: 522 (hos_ioexception); SQLCode: -1006140, SQLState: 'QBB40', Severity: 14

I. 07/15 07:09:02. 0001270078 [20378]: I/O Error on file X:/temp/LOAD/LOAD_201507xx.csv

-- (hos_clientfileio.cxx 208)

I. 07/15 07:09:02. 0001270078 Exception Thrown from hos_clientfileio.cxx:208, Err# 9, tid 8 origtid 233

I. 07/15 07:09:02. 0001270078    O/S Err#: 0, ErrID: 522 (hos_ioexception); SQLCode: -1006140, SQLState: 'QBB40', Severity: 14

I. 07/15 07:09:02. 0001270078 [20378]: I/O Error on file X:/temp/LOAD/LOAD_201507xx.csv

-- (hos_clientfileio.cxx 208)

Former Member
Not what you were looking for? View more on this topic or Ask a question