Parameter Name: reportedElement Value cannot be null

Nathan Heaivilin 1 Reputation point
2023-04-20T21:51:45.5966667+00:00

We have an VS2022 database project that we've been using without issue for a while. It contains an AlwaysEncrypted column. We recently added transactional replication to the database. As part of that process, in our publish profile, we de-select the 'Do not ALTER replicated objects' properties in the advanced section of our published profiles. This has worked without issues in other projects. However, when changing this and trying to generate scripts or publish, we now get an error that shows this: User's image

I cannot find a way around it and am unable to deploy as a result.
I bring up the alwaysEncypted as I found a similar issue with those features in different articles from a few years back, so unclear if it's related or not.
Regardless, I'm at a loss of what to do at this point and how to move forward. Anyone have any suggestions, ideas, thoughts? Very much appreciate any assistance. Nathan

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,830 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,218 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
189 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,461 Reputation points
    2023-04-24T06:37:32.5466667+00:00

    Hi @Nathan Heaivilin,

    Please refer to this similar thread:

    https://stackoverflow.com/questions/55924997/value-cannot-be-null-parameter-name-reportedelement-when-adding-a-new-always

    Hope this would give you some help.

    Best regards,

    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it.