3 Replies Latest reply: Oct 29, 2012 4:14 PM by JeffJon RSS

    Import script which was working till Friday throws an error now.

    970165
      Hi,

      My import script which was working fine till Friday throws an error now. Please see the error below. Is it some thing to do with the FDM database table space? I am able to connec to the source GL database and see the table there. I believe the script is now not able to insert values in to the FDM table refereed by the import script variable 'strWorkTableName'.

      Can some one please confirm my understanding? Or guide me into the correct direction to get this resolved?

      Thanks,
      Sunil Garugu

      Error below:

      Error: An error occurred running the script:
      -2147467259 - Data access error.
      At Line: 71


      From the error log:
      ** Begin FDM Runtime Error Log Entry [2012-10-29 12:50:17] **
      -------------------------------------------------------------
      ERROR:
      Code............................................. -2147467259
      Description...................................... ORA-00903: invalid table name

      Procedure........................................ clsDataAccess.farsTable
      Component........................................ upsWDataWindowDM
      Version.......................................... 1112
      Thread........................................... 2460

      IDENTIFICATION:
      User............................................. admin
      Computer Name.................................... ELSOXFAPPD169
      App Name......................................... FDMTSTAPP
      Client App....................................... WebClient

      CONNECTION:
      Provider......................................... ORAOLEDB.ORACLE
      Data Server......................................
      Database Name.................................... HFMDEV
      Trusted Connect.................................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location......................................... R12COMPANY30
      Location ID...................................... 767
      Location Seg..................................... 14
      Category......................................... ACTUAL
      Category ID...................................... 12
      Period........................................... Apr - 2012
      Period ID........................................ 4/30/2012
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False