1 Reply Latest reply: Aug 5, 2011 7:25 AM by JohnGoodwin RSS

    Error in dataload- Duplicate Members From Same Dimension On Data Record

    Ashu
      Hi All,

      I am getting the below error while loading the data in the BSO cube (11.1.2 version). Any one having idea what that error means:


      ERROR:

      Some part of error file below

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000153     23     2001     DE     600100     0810110050     2011     2     1

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000153     23     2001     DE     600100     0810110050     2011     3     1

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000153     23     2001     DE     600100     0810110050     2011     4     1

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000153     23     2001     DE     600100     0810110050     2011     5     1

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000153     23     2001     DE     600100     0810110050     2011     6     1

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000153     23     2001     DE     600200     0810110050     2011     1     0

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000153     23     2001     DE     600200     0810110050     2011     2     0

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000154     23     2001     DE     100000     0810130250     2011     1     1

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000154     23     2001     DE     600100     0810130250     2011     2     1

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000154     23     2001     DE     600100     0810130250     2011     3     1

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000154     23     2001     DE     600100     0810130250     2011     4     1

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000154     23     2001     DE     600100     0810130250     2011     5     1

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000154     23     2001     DE     600100     0810130250     2011     6     1

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000154     23     2001     DE     600200     0810130250     2011     1     0

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000154     23     2001     DE     600200     0810130250     2011     2     0

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000169     23     353     US     600100     0830280857     2011     1     2

      \\ Duplicate Members From Same Dimension On Data Record
      VV000     RB00000169     23     353     US     600100     0830280857     2011     2     7
        • 1. Re: Error in dataload- Duplicate Members From Same Dimension On Data Record
          JohnGoodwin
          It means you have dimension members for the same dimension more than once in a row of data.
          Maybe 2001 and 2011 are both year members and are on the same record, in this case how would essbase know which member to load it against, you would need one instance of the member.

          If you want more detailed information have a read of http://download.oracle.com/docs/cd/E17236_01/epm.1112/esb_err_msgs/data_load_msgs.html#data_load_errs1037295

          Cheers

          John
          http://john-goodwin.blogspot.com/