Skip to Content
avatar image
Former Member

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)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 15, 2015 at 08:48 PM

    The file name is referenced as a client file?  You are using dbisql?

    Chris

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      source is Linux Suse / IQ 12.7 -in NY Target  is RHEL IQ 15.4 IL , target bigger page size so maual extract of iqunload followed by data load. having issues withdta load delimters

  • avatar image
    Former Member
    Jul 15, 2015 at 09:22 PM

    This job when ran manually runs as success. Fails as par tof the batch stream. This is the only job that's run, so no contention on the server.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Chris Baker

      Chris ! Thank you for the quick responses.

      No. of rows are 230 million loaded from csv file.


      IQ server - IQ/15.4.0.3019/120816/P/ESD 2/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit/2012-08-16 10:48:47

      Client on - Windows 2008R2 Build 7601 Service Pack 1 , IQ version is IQ 15.2.

      yes, Connection terminated abnormally; client socket shut down

  • Sep 13, 2016 at 10:40 PM

    Hi,

    I have the same problem. Did you find a solution to this issue?

    Regards,

    Alejandro Chinchilla

    Add comment
    10|10000 characters needed characters exceeded

    • How long after your last command does the disconnect happen?

      If the client is on Windows, then it is possible that Windows TCP settings are disconnecting the session as it appears to be idle, even though it is still running.

      Is your topology the same as above - 2 IQ servers on Linux with a Windows client?

      Check your Windows registry for TCP/IP 'idle timeout' settings.  Maybe increase that and your number of 'keep alives' and 'keep alive retries' so that your longest session is covered.

      What client are you using? Interactive SQL/dbisql from the IQ network client or the ASE isql (OpenClient)?  What versions of clients and IQ servers are running.

      Chris