Cloud Global

 View Only
Back to discussions
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 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
    ------------------------------

    Original Message


  • 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



    Original Message


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



    Original Message


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

    Posted Mon February 24, 2025 09:42 AM

    Thank you so much!!! 

    It really worked:)

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



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

    Original Message


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

    Original Message


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

    Original Message


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

    Posted 11 days ago

    Hi!

    Vijayalakshmi Arjunan

    It looks like the error is related to loading data from an external source, possibly IBM Cloud Object Storage, and DB2 is not recognizing the file reference correctly. One thing to check is whether the full path to the file is correctly formatted and enclosed in the required syntax. Also, ensure that your DB2 instance has the right permissions to access the storage location. If you are using the LOAD command, try specifying the correct file format and location reference. You might also want to verify if the integration between DB2 and Cloud Object Storage is properly configured.

    Best Regards: Blythe Winslow



    ------------------------------
    Blythe Winslow
    ------------------------------

    Original Message


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

    Posted 10 days ago
    Thanks for the explanation that explains it.

    Regards
    Vijaya



    Original Message


Related Content