1 Reply Latest reply: Sep 16, 2013 6:27 AM by SH RSS

    Mapping Error

    user8819264

      I am using PULL adapter to transform a file to another one. I have imported and registered the adaptor to a new application. Created the import format and assigned to location. But When i do the mapping of columns i get below error.

       

      Error: Error adding new record.

      Detail: An invalid value was entered for the dimension (Account)

       

      My admin log says below. What could be the reason.

      I have used a like mapping with all *

       

      ** Begin FDM Runtime Error Log Entry [2013-09-16 10:55:06] **

      -------------------------------------------------------------

      ERROR:

      Code............................................. 2580

      Description...................................... Script: (ACCOUNTList) No Data!

      Procedure........................................ clsBlockProcessor.DimensionList

      Component........................................ upsWBlockProcessorDM

      Version.......................................... 1112

      Thread........................................... 6736

       

       

      IDENTIFICATION:

      User............................................. admin

      Computer Name.................................... NEWR-VMX86-3

      App Name......................................... NEWR_PROD

      Client App....................................... WebClient

       

       

      CONNECTION:

      Provider......................................... ORAOLEDB.ORACLE

      Data Server......................................

      Database Name.................................... HYDBPROD

      Trusted Connect.................................. False

      Connect Status.. Connection Open

       

       

      GLOBALS:

      Location......................................... HRCOUNT

      Location ID...................................... 749

      Location Seg..................................... 3

      Category......................................... FLAT_FILE

      Category ID...................................... 13

      Period........................................... sept - 2013

      Period ID........................................ 30/09/2013

      POV Local........................................ False

      Language......................................... 1033

      User Level....................................... 1

      All Partitions................................... True

      Is Auditor....................................... False

        • 1. Re: Mapping Error
          SH

          You need to configure the PULL adapter dimensions in Workbench so that it is not attempting to do a lookup for the target value from a list. To do this go into each enabled dimensions properties and uncheck the Use List checkbox if this is checked.