KB34164: "An object with name 'xxx' and type 'Column' already exists in the destination folder" error message appears when attempting to add a table to warehouse catalog in MicroStrategy Developer 9.4.x-10.x.

Salesforce Solutions Architect • Strategy

This knowledge base article explains why "An object with name 'xxx' and type 'Column' already exists in the destination folder" error message appears when attempting to add a table to warehouse catalog in MicroStrategy Developer 9.4.x-10.x.

SYMPTOM:
The following error occurs when user is attempting to add a table to a project through Warehouse Catalog in Strategy Developer 9.4.x-10.x.


Error adding Table(s) to the schema.
An object with name 'xxx' and type 'Column' already exists in the destination folder.

CAUSE:
One possible cause of the error is two or more column objects with the same name (appended with parenthesis) exist in different warehouse tables but are designated as different data types. This is a known issue in Strategy Developer 9.4.x-10.x.

ACTION:
Contact Strategy Technical Support for an update on this issue.

WORKAROUND:
Choose the Warehouse Catalog read option to 'Use maximum denominator datatype' by following these steps:

Open the Warehouse Catalog and click the 'Options' button in the tool bar.
Click 'Read Settings' under the Catalog section.
In the 'Column Merging Options', choose 'Use maximum denominator datatype' as shown below:

After these steps, user should be able to add tables into warehouse catalog.
Refer to the following knowledge base article for more details on duplicate columns:
KB45179: Best practices for avoiding metadata issues that result from Duplicate Columns in Strategy 9.4.x-10.x and how duplicate columns can be created.

Comment

0 comments

Details

Knowledge Article

Published:

April 12, 2017

Last Updated:

April 12, 2017