Column names in each table must be unique.

[Former Member]

Hello there,

I am working in SAP BPC 5.x, when i try clear the data with a DM Package named clear, i get the following error "Column names in each table must be unique. Column name 'SIGNEDDATA' in table 'sourceTable_xxx' is specified more than once."

I haven´t modified the dtsx package, some idea?

THX,

[Former Member]

No idea, I've never seen that error before.

Are you certain there's data to clear, for the dimension intersection you specify? This may be trying to say "no data to clear"

Do you see any add'l info in the package details / debug log?

Can you process the application with no errors?

What answers to the prompts do you provide, when you run the clear? I don't think it works if you answer <ALL> to every dimension; you need to specify members for at least one dimension.

Can you run successfully if you specify only one member, for EVERY dimension? That's not what you want, but may help pinpoint the problem.