The column XXXX was specified multiple times for a system view when import solution

(0) Share

Report

Posted on by Community Member

A sql exception when import a V8.1 solution to V9. It complains a primary key 'new_testid' of a custom entity called "test"was specified multiple times for 'Filterednew_test'.

Any help will be much appreciated!!!

Randy

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Clem 2,541 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Did you update any system views putting multiple columns which have the same display name ?

Clément

Was this reply helpful? Yes No
Suggested answer

Temmy Wahyu Raharjo 2,916 on at

Like (0)

Report
Copy link

Link copied!

Hi,

If your environment is unmanaged, try to remove the attribute new_testid then import again.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi there.

Thanks for you reply.

This field is primary key of an table. I have resolved that issue.

It originates from primary key has upper case prefix in source but lower case in target system. CRM never complains it when check missing components but will throw exception when importing the solution. I assume some sql action is case sensitive so it treats "new_testid" and "NEW_testid" different fields but primary key name must be unique for same entity.

Was this reply helpful? Yes No