2 Replies Latest reply on Jul 15, 2010 10:29 AM by GiacomoD

    FDM file import Error

    GiacomoD
      Hi everybody,
      I'm trying to load a flat file in FDQM (target system HFM) but it returns me an Error.
      In the Log file the error is the following:

      ** Begin FDM Runtime Error Log Entry [2010-07-13-17.26.48] **
      -------------------------------------------------------------
      ERROR:
      Code......................................... -2147217913
      Description.................................. The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
      Update tDataArchive Set ArchiveSuperceded = 1, ArchiveSupercededTimeStamp = '20100713 17.26.48' WHERE ((PartitionKey) = 749) AND ((CatKey) = 12) AND ((PeriodKey) = '20090930') AND ((ArchiveSuperceded) = 0)
      Procedure.................................... clsDataManipulation.fExecuteDML
      Component.................................... upsWDataWindowDM
      Version...................................... 931
      Thread....................................... 3856

      IDENTIFICATION:
      User......................................... hypadmin
      Computer Name................................ MIR-HYPINT-T
      App Name..................................... TESTGR
      Client App................................... WebClient

      CONNECTION:
      Provider..................................... SQLOLEDB
      Data Server.................................. mir-sql
      Database Name................................ TESTGR
      Trusted Connect.............................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location..................................... FASHION
      Location ID.................................. 749
      Location Seg................................. 3
      Category..................................... ACT
      Category ID.................................. 12
      Period....................................... Sep - 2009
      Period ID.................................... 30/09/2009
      POV Local.................................... False
      Language..................................... 1033
      User Level................................... 1
      All Partitions............................... True
      Is Auditor................................... False

      Where can I check to find a solution??? it seems to be a problem with the Year-Period convertion...

      Thanks in Advance

      Giacomo