Cloud Global

 View Only
Expand all | Collapse all

ERROR: WHILE LOADING DATA IN CLAOUD DATABASE

  • 1.  ERROR: WHILE LOADING DATA IN CLAOUD DATABASE

    Posted Wed July 21, 2021 10:20 AM
    Receiving the an error while trying to load data on previously created table on DB2 cloud lite version.
    Below is the error information:

    An unexpected token ""S3::s3.private.us.cloud-object-storage.appdomain.clo" was found following "FROM". Expected tokens may include: "<filename>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.27.25
    Number of occurrences: 1

    Any help appreciated!


    ------------------------------
    Vijayalakshmi Arjunan
    ------------------------------


  • 2.  RE: ERROR: WHILE LOADING DATA IN CLAOUD DATABASE

    Posted Thu July 22, 2021 01:44 AM
    Hello Vijayalakshmi,

    Thank you for using IBM Cloud!

    For users with a Lite Plan (free tier),  technical support is provided by the IBM Cloud Docs and Stack Overflow.

    IBM Cloud Docs: https://cloud.ibm.com/docs/home/alldocs

    Stack Overflow: https://stackoverflow.com/questions/tagged/ibm-cloud?tab=Newest

    I hope it helps!

    ------------------------------
    Eri Hattori
    ------------------------------



  • 3.  RE: ERROR: WHILE LOADING DATA IN CLAOUD DATABASE

    Posted Thu October 07, 2021 09:08 AM
    Hi - did you manage to resolve this issue? I'm currently having the same error.

    ------------------------------
    Vandan Parmar
    ------------------------------



  • 4.  RE: ERROR: WHILE LOADING DATA IN CLAOUD DATABASE

    Posted Fri October 08, 2021 09:50 AM
    Hi - did you manage to resolve this issue? I'm currently having the same error.?

    I appreciated any help!



    ------------------------------
    Nestor Brito
    ------------------------------



  • 5.  RE: ERROR: WHILE LOADING DATA IN CLAOUD DATABASE

    Posted Sat October 09, 2021 02:45 AM
    Yeah - I was using the name of the file returned by /home_content end point to then create a load job. However, it seems that DB2 on Cloud persists the original filename.

    So e.g. if you were uploading a file called People.csv, you'd make your call to /home_content and get a response with a name like "xxxx_xxxx_xx_People.csv". When then creating a load job, you just need to use People.csv as the filename rather than "xxxx_xxxx_xx_People.csv".

    Vandan

    ------------------------------
    Vandan Parmar
    ------------------------------



  • 6.  RE: ERROR: WHILE LOADING DATA IN CLAOUD DATABASE

    Posted Mon January 13, 2025 09:23 AM

    Thank you. this resolved my issue. unlike the agents who seem to be more interested in playing traffic cops than actually helping out.



    ------------------------------
    uma venkat karanam
    ------------------------------



  • 7.  RE: ERROR: WHILE LOADING DATA IN CLAOUD DATABASE

    Posted Mon January 13, 2025 09:33 AM
    Uma, infact playing traffic cops relieve stress which can help with anxiety:)

    Vijaya Arjunan





  • 8.  RE: ERROR: WHILE LOADING DATA IN CLAOUD DATABASE

    Posted Tue January 14, 2025 02:34 AM
    By the way thanks for sharing experience you all, Happy 2025 to everyone.





  • 9.  RE: ERROR: WHILE LOADING DATA IN CLAOUD DATABASE

    Posted 2 days ago

    Thank you so much!!! 

    It really worked:)

    I would never thought to change the name of the file!



    ------------------------------
    Bahareh Azad
    ------------------------------



  • 10.  RE: ERROR: WHILE LOADING DATA IN CLAOUD DATABASE

    Posted Tue October 12, 2021 11:53 AM
    Hey Vijayalakshmi,

    I ran into this issue as well this morning. I was trying to upload a csv file from my local computer to a Db2 service when I ran into this error. I was able to localize the error to the file name.

    Original File Name
    > Memphis_Police_Department__Public_Safety_Incidents_20211011.csv

    Updated File Name
    > MPD_Incidents_Original.csv

    I think the error was caused by either:
    (1) long file name
    (2) double underscore in file name




    ------------------------------
    Ken Bailey
    ------------------------------



  • 11.  RE: ERROR: WHILE LOADING DATA IN CLAOUD DATABASE

    Posted Tue October 12, 2021 11:53 AM
    I also ran into this error while trying to load a csv file into a Db2 instance.

    I fixed by changing file name. I think it was either too long or b/c it contained double underscore.

    Orignal
    > Memphis_Police_Department__Public_Safety_Incidents_20211011.csv

    Changed
    > MPD_Incidents_Original.csv

    ------------------------------
    Ken Bailey
    ------------------------------