3 Replies Latest reply on Sep 30, 2010 6:27 PM by TonyScalese

    FDM Import Error

    user10203602
      Hi All,
      I'm running FDM 11.1.1.3 on SQL 2005 DB

      When I trying Import step (in flat file or integration script option) , I getting this error:



      ** Begin FDM Runtime Error Log Entry [2010-09-30-18.50.19] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2147217833
      Description...................................... Arithmetic overflow error converting expression to data type datetime.
      INSERT INTO tDataArchive (ArchiveDocKey, PartitionKey, CatKey, PeriodKey, ArchiveFileName, ArchiveExtension, ArchiveDocTypeID, ArchiveProcTypeID, ArchiveTimeStamp, ArchiveDesc, ArchiveCreator, ArchiveSetID) VALUES (N'SQL_INTEGRATION-ADMIN-2010-09-30-18.50.19.776', 748, 13, N'20101231', N'SQL_Integration', N'uss', 3, 1, N'20100930 18.50.19', '', N'admin', 0)
      Procedure........................................ clsDataManipulation.fExecuteDML
      Component........................................ upsWDataWindowDM
      Version.......................................... 1111
      Thread........................................... 5472

      The cause is due to that FDM attempt to write a timestamp in wrong format (20100930 18.50.19)....
      The column ArchiveTimeStamp is datetime...

      Executing the query in Management Studio and changing the string in '20100930 18:50:19' it works!

      Any suggestions?

      Thank you,
      Vic.