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

    Original Message


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

    Original Message


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

    Original Message


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

    Original Message


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

    Posted 29 days ago

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

    Original Message


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

    Posted 29 days ago
    Uma, infact playing traffic cops relieve stress which can help with anxiety:)

    Vijaya Arjunan



    Original Message


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

    Posted 28 days ago
    By the way thanks for sharing experience you all, Happy 2025 to everyone.



    Original Message


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

    Original Message


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

    Original Message