13 Replies Latest reply: Oct 17, 2012 10:59 AM by user10757003 RSS

    FDM batch script error- Random failure

    968568
      Hi We are loading our data from data warehouse to HFM using batch script schedule. Recently we have upgraded from HFM V9 to HFM V11 and from that day onwards batch script fails for some load and success for some loads, there is no pattern identified. Let's say if we submit our data for an location then it will start loading month by month and it will load 10 month(just for example it can change for next load) successfully and fails in 11 months. If we resubmit the same data for the failed location again and again it will load all 12 months without any issues. Below is the FDM error message;

      tnsnames.ora file is correctly pointing to the database(as said it fails for some times and successfully loads other time).

      Additional information: FDM application is in cluster(2 nodes) and database is also in RAC cluster(2 nodes).

      ERROR:
      Code............................................. -2147467259
      Description...................................... ORA-12545: Connect failed because target host or object does not exist
      At Line: 82
      Procedure........................................ clsEventHandler.PobjAPI_BefValidate
      Component........................................ upsWObjEventHandlerDM
      Version.......................................... 1112
      Thread........................................... 2228

      IDENTIFICATION:
      User............................................. xxxxxxx
      Computer Name.................................... xxxxxxx
      App Name......................................... xxxxxxx
      Client App....................................... BatchEngine

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

      GLOBALS:
      Location......................................... xxxxxx
      Location ID...................................... 754
      Location Seg..................................... 8
      Category......................................... ACT
      Category ID...................................... 13
      Period........................................... Nov - 2012
      Period ID........................................ 30/11/2012
      POV Local........................................ False
      Language......................................... 1033
      User Level....................................... 1
      All Partitions................................... True
      Is Auditor....................................... False