Cloud Global

 View Only
  • 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 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
    ------------------------------



  • 7.  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
    ------------------------------