Skip to Content

Master data load error - Command failed column index is out of range

Hello,

I am trying to load master data from flat file, I am getting below error -

"Command failed *COL(13); column index is out of range"

looks simple, pretty straight forward, however something seems to be missing

Transformation file mapping:

Data file: Columns in the order

I am using the DM package -

/CPMB/IMPORT_MASTER

The dimension I am loading to has no hierarchy created, is it mandatory to have a ParentH1 column for using the above package?

Error log:

transfile.png (19.6 kB)
file1.png (13.6 kB)
file2.png (6.0 kB)
error.png (16.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 18 at 08:01 AM

    HEADER = NO, but I can see header in the sample file!

    And you can see that the lines with the last column (13) with data imported OK!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 17 at 11:41 PM

    Hello,

    The only thing I find strange is the space in the first column value. BPC does not allow spaces in ID values. Is it possible to test this without the space in the value of the first column?

    Best Regards,

    Leila Lappin

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 18 at 02:38 PM

    Keeping the header to yes has solved the issue.

    I had this weird error below so I had to switch the 'Header = No' trying different options

    anyway thanks again for your Input Vadim!

    Add comment
    10|10000 characters needed characters exceeded