Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2015
    Posts
    6

    Unanswered: SQL3040N The utility cannot use the file name .. Reason code: "6"

    Hi ,

    We are trying to load xml data into table. Hence we have taken Index and xml files separately like below

    Index file:
    794149703013,<XDS FIL='PZNMF2PZNDS.SMART.CUST.PROFILE.XML' OFF='000000118722465688' LEN='07905'/>
    794149704010,<XDS FIL='PZNMF2PZNDS.SMART.CUST.PROFILE.XML' OFF='000000118722473593' LEN='07895'/>
    794149707011,<XDS FIL='PZNMF2PZNDS.SMART.CUST.PROFILE.XML' OFF='000000118722481488' LEN='07946'/>
    794149715015,<XDS FIL='PZNMF2PZNDS.SMART.CUST.PROFILE.XML' OFF='000000118722489434' LEN='07823'/>

    xml file:
    <CustProf><FicoScorNbr>850</FicoScorNbr><HiValCustInd>0</HiVa...
    <CustProf><FicoScorNbr>655</FicoScorNbr><HiValCustInd>0</HiVa...
    <CustProf><FicoScorNbr>619</FicoScorNbr><HiValCustInd>0</HiVa...
    <CustProf><FicoScorNbr>618</FicoScorNbr><HiValCustInd>0</HiVa...

    The Load replace command that we are using in our scripts is like below

    "load from indexfile_name of del XML from xml_file_name replace into Table_name nonrecoverable"

    We are getting exception like below

    SQL3040N The utility cannot use the file name
    "root/TestLoad/DataLoad/" specified
    in the "XDS" parameter. Reason code: "6".

    We have seen the reason code description which indicates that--*The sum of the starting position and the length of the input data exceeds the size of the file with file name file-name.

    We really do not understand what it is and why the exception is coming even if we are having proper offset and lengths compared. we calculated the offset and length for failed records. They are proper.

    Please help us to understand why some records are failing while loading and giving above error?

    Thanks,
    K.Srinivas.
    Last edited by ksrinu8090; 11-18-15 at 09:06.

  2. #2
    Join Date
    Nov 2015
    Posts
    6

    SQL3040N The utility cannot use the file name .. Reason code: "6"

    Hi,

    Can someone please reply us if know solution. Its kind of urgent.

    Appreciate your help in advance.

    Thanks,
    K.Srinivas.

  3. #3
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    xml_file should have 7905 + 7895 + 7946 + 7823 bytes
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  4. #4
    Join Date
    Nov 2015
    Posts
    6

    SQL3040N The utility cannot use the file name .. Reason code: "6"

    Hi,

    Thank you for reply. We checked that the sum of all lengths is matching with size of xml_file. And the reason is some records are getting inserted and only some are getting failed giving below error.

    SQL3040N The utility cannot use the file name
    "/bcp/instance/Profile_Scripts/Iprofile/USDataLoad/SMART/DataLoad/" specified
    in the "XDS" parameter. Reason code: "6".

    SQL3227W Record token "F2-1007868" refers to user record number "16124593".

    SQL3227W Record token "F2-1007869" refers to user record number "16124594".

    SQL3227W Record token "F2-1007870" refers to user record number "16124595".

    SQL3227W Record token "F2-1007871" refers to user record number "16124596".

    Is there any other reasons that may cause this issue.

    Please suggest.

    Thanks you.
    Last edited by ksrinu8090; 11-20-15 at 01:45.

  5. #5
    Join Date
    Nov 2015
    Posts
    6

    SQL3040N The utility cannot use the file name .. Reason code: "6"

    Hi,

    Can someone please suggest what might be the issue for the above problem.

    Thanks in advance.

  6. #6
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    The reason code 6 it's pretty clear: The sum of the starting position and the length of the input data exceeds the size of the file with file name file-name.

    Something it's wrong with either your file, or your statement.
    Meanwhile, you should try to load one row at a time. Also, try to identify the record that cause the failure nd see what's wrong with it.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  7. #7
    Join Date
    Nov 2015
    Posts
    6

    SQL3040N The utility cannot use the file name .. Reason code: "6"

    Hi Aflorin,

    Thanks for reply. We will check on that. Before that can you please confirm below thing which would help us in debugging.

    Is it possible that the SQL3227W messages above are referring to the wrong user record numbers ? Besides, what does the record tokens starting with F0- and F1- actually i.e SQL3227W Record token "F2-1007868" refers to user record number "16124593" in our file.

    Thanks,
    ksrinu8090.

  8. #8
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    That's why Florin is saying load a single record to verify
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  9. #9
    Join Date
    Nov 2015
    Posts
    6
    Hi

    Pardon for multiple posts. We tried to load one record(which failed earlier) but it loaded successfully. And tried with 10 records (that failed earlier), they are successful. As our xml file size 120GB and error records which failed earlier are getting recorded individually, Hence we are really unable to identify record which is breaking the loading in complete file.

    Thanks for help on this issue.

    Thanks,
    ksrinu8090.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •