Managed Solution Import issue

(0) Share

Report

Posted on by Lynda Joyner

We are having errors generated from import of managed solution.

Could anyone help identify the cause of this failure?

SqlException: The correlation name 'manualsla_new_customentityname' is specified multiple times in a FROM clause., View Script: if exists (select * from sys.objects where name = 'new_customentityname' and type = 'V') begin drop view [new_customentityname] end go -- -- base view for new_customentityname -- create view dbo.[new_customentityname] ( -- logical attributes * then returns list of fields, some of which are custom, within the custom entity*

I have recently ticked the 'Enable for SLA' on this custom record, is this connected/ causing this error? If so, how can I reverse/ resolve this?

Many thanks

Lynda

Categories:

Customization / Solutions / SDK and API

Other Functionality

All responses (2)

Answers (0)

Suggested answer

Johnny Gong 6,482 on at

Like (0)

Report
RE: Managed Solution Import issue

Hi Lynda,
I met similar case before. It's truly related with SLA. Entity should have SLA disabled on the mentioned solution.
Since you could not directly access Online DB. I suggest you need to raise a service request from Admin Center to escalate the issue to Dev Team.
Then you could suggest them try the following script which could help you successfully import solution:

Update entity set isSLAEnabled = 1 where Name = 'manualsla_new-customerntityname' and SolutionId = '...'

Solution Id is your mentioned managed solution id.

Regards

Johnny
Suggested answer

Kokulan 18,048 on at

Like (0)

Report

RE: Managed Solution Import issue

Hi

What version of CRM you are on? That to me looks like a CRM bug, you might have to consider raising a ticket with Microsoft.

Do you have any backup before you enabled the SLA on this entity?

Whats the version differences between source and target?