1 Reply Latest reply on Jun 7, 2019 12:50 PM by JohnGoodwin

    Metadata Load error using DM

    Nishant Fukate

      Hello Experts,

       

      We are trying to load metadata using DM on EPBCS env. We have total 125 records in a source file. But it is getting failed because of this error:

       

      [Fri Jun 07 12:14:19 UTC 2019] [11] Ignoring data record 11, number of header record fields (19) does not match the number of data record fields (20). Check delimiter setting and record fields.

      [Fri Jun 07 12:14:19 UTC 2019] [12] Ignoring data record 12, number of header record fields (19) does not match the number of data record fields (20). Check delimiter setting and record fields.

      [Fri Jun 07 12:14:19 UTC 2019] [13] Ignoring data record 13, number of header record fields (19) does not match the number of data record fields (20). Check delimiter setting and record fields.

      [Fri Jun 07 12:14:19 UTC 2019] [15] Ignoring data record 15, number of header record fields (19) does not match the number of data record fields (20). Check delimiter setting and record fields.

      [Fri Jun 07 12:14:19 UTC 2019] [16] Ignoring data record 16, number of header record fields (19) does not match the number of data record fields (20). Check delimiter setting and record fields.

      [Fri Jun 07 12:14:19 UTC 2019] [120] Ignoring data record 120, number of header record fields (19) does not match the number of data record fields (20). Check delimiter setting and record fields.

      [Fri Jun 07 12:14:19 UTC 2019]Load dimension "Project" has been unlocked successfully.

      Outline data store load process finished. 125 data records were read, 118 data records were processed, 111 were accepted for loading (verify actual load with Essbase log files), 7 were rejected.

      [Fri Jun 07 12:14:20 UTC 2019]Outline data store load process finished. 125 data records were read, 118 data records were processed, 111 were accepted for loading (verify actual load with Essbase log files), 7 were rejected.

       

       

      Any guess?

        • 1. Re: Metadata Load error using DM
          JohnGoodwin

          Looks like some of the records are missing a column,  for example the following rejection has 19 columns but it is expecting 20 columns

          [Fri Jun 07 12:14:19 UTC 2019] [11] Ignoring data record 11, number of header record fields (19) does not match the number of data record fields (20). Check delimiter setting and record fields.

           

          Cheers

           

          John