Forum Discussion

Sanssnap's avatar
Sanssnap
New Contributor II
4 years ago

org.joda.time.LocalDateTime error for DB2 Insert

Hi, I had an issue with DateTime conversion issues Insert records when migrating data from MySQL to DB2. MYSQL dateformat : 2022-03-17 05:10:10 DB2 timeformat 2022/03/17 05:10:10 I am getting ...
transform
dmiller's avatar
dmiller
Former Employee
8 years ago
Copy LinkReport

I know the ORC Writer currently does not have support for S3, but I don’t know if anyone has tried another method to achieve this.

  • ash42's avatar
    ash42
    New Contributor III
    3 years ago
    Copy LinkReport

    No luck, Same error

    • darshthakkar's avatar
      darshthakkar
      Valued Contributor
      3 years ago
      Copy LinkReport

      With these settings, can you write a file to the existing directory?
      If yes, may be check with your admin if you’ve rights to create a directory in that location.

      The settings look good to me as I’ve been able to create directories with the same.

      • ash42's avatar
        ash42
        New Contributor III
        3 years ago
        Copy LinkReport

        I did connect to the ftp server with the same credentials ,and tried creating a folder manually…I was able to create…Dont know why through snaplogic I am not able to create with same credentials