Replacing an activity table in a deployed managed solution with a standard table

(0) Share

Report

Posted on by westerdaled

672

All

I am currently experiencing the above issue when trying to deploy a solution from Dev to Test. So is there a way to replace the table definition in the test environment?

Alternatively, has anyone tried removing the table in the solution in dev and then updating the solution in test, so intending to remove the missing table?

I tried deleting the managed solution in test but to this "helpful" error . Note, the environment variables are not shared with any other solution.

Sql error: Statement conflicted with a constraint. The DELETE statement conflicted with the REFERENCE constraint "environmentvariabledefinition_environmentvariablevalue". The conflict occurred in database "db_crmcoregbr_20230816_12550932_8713", table "dbo.EnvironmentVariableValueBase", column 'EnvironmentVariableDefinitionId'. The statement has been terminated. CRM ErrorCode: -2147185375 Sql ErrorCode: -2146232060 Sql Number: 547

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

I know of no way to issue BOTH a delete and a create operation during solution import. This applies not just to table definitions, but even to individual columns, web resources... everything.

If you want to have table ABC "become" table XYZ via solution import (and they occupy the same name or identity) then there is no alternative but:

- One solution import that deletes table ABC

- A second solution import that creates table XYZ

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

To be clear, I think what you were asking about is:

"I have table new_mytable with IsActivityEntity = True. I want to replace it with new_mytable with IsActivityEntity = false"

(or something very close to that)

Was this reply helpful? Yes No
westerdaled 672 on at

Like (0)

Report
Copy link

Link copied!

@cchannon

Thanks for the reply. If I understand you correctly, I could set IsActivityEntity = False in Test (in managed solution).

Unfortunately, the Entity table is readonly - our table is set to true of course.

Looking at other posts, I see my issue with not being able to delete the managed solution in test is being experienced by other users and there isn't a fix yet.

Was this reply helpful? Yes No
westerdaled 672 on at

Like (0)

Report
Copy link

Link copied!

We tried the importing the solution without the offending table and this didn't work, unfortunately.

Was this reply helpful? Yes No
Verified answer

cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

No, once a table has been set as an Activity table, it cannot be edited. Your only option is to delete the table in its entirety and make a new table that is NOT an activity table. To do this via solution, you would need to remove all dependencies on that table one at a time, then remove it, then make a new solution at that time where the offending table has been deleted. That solution is your "subtractive" solution and is what you will use to delete the table in higher environments. Then, create the new table and make another solution. This is the "additive" solution.

In the destination environment then, you will import the subtractive solution, then the additive solution and the end result will be your table as NOT an activity. However this process is laborious and it will delete the data in that table, so you should think carefully before proceeding with this approach.

Was this reply helpful? Yes No
westerdaled 672 on at

Like (1)

Report
Copy link

Link copied!

@cchannon

You are absolutely correct, as this is what we did in the end ( in our dev environment). Took a couple of hours and I was back working on a newly created activity table . Indeed, we were able to import my main form with all its event handlers onto the new table .

Was this reply helpful? Yes No