Finance | Project Operations, Human Resources, ...

Tier 2 UAT Database export fails D365 F&O

(4) Share

Report

Posted on by CU21052024-0

273

Hi All,

I’m running into an issue during tier 2 database export in LCS and showing below error in logs.

“Error exporting database:One or more unsupported elements were found in the schema used as part of a data package.

Error SQL71501: Error validating element [DBO] [DNGE _PropertyGroup_SHARINGVIEW]: View: [DBO] - [DNGE_PropertyGroup_SHARINGVIEW] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [DBO]. [DNGE_PropertyGroup]. [SYROWVERSION], [DBO]. [DNGE_PropertyGroup]. [Tl or [DBO] - [SYSSHARINGRULE] - [T]

Error SQL71501: Error validating element [DBO]. [DNGE_PropertyGroup_SHARINGVIEWWITHUNIQUEID]: View:

[DBO] - [DNGE_PropertyGroup SHARINGVIEWWITHUNIQUEID] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [DBO]. [DNGE_PropertyGroup]-[SYROWVERSION], [DBO] - [DNGE_PropertyGroup]-[T] or [DBO]. [SYSSHARINGRULE] [T].

Error SQL71501: Error validating element [DBO]. [DNGE_PropertyGroup_SHARINGVIEWWITHUNIQUEID] [SYSROWVERSION]: Computed Column: [DBO] - [DNGE PropertyGroup_SHARINGVIEWWITHUNIQUEID] [SYROWVERSION] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [DBO]. [DNGE_PropertyGroup]. [SYSROWERSION], [DBO] - [DNGE_PropertyGroup]-[T] or [DB0]. [SYSSHARINGRULE]. [T].

Error SQL71501: Error validating element [DBO]. [DNGE_PropertyGroup_SHARINGVIEW]. [SYSROWERSION]: Computed Column:

[DBO] - [DNGE PropertyGroup_SHARINGVIEW]. [SYROWVERSION] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [DBO]. [DNGE_PropertyGroup]-[SYSROWVERSION], [DBO] • [DNGE_PropertyGroup]-[T] or [DBO]. [SYSSHARINGRULE].

Any guidance would be greatly appreciated

Thanks!

I have the same question (0)

All responses (4)

Answers (0)

Lisa at AonC.com 1,028 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please tag what Dynamics ERP this is related to.

(I support Dynamics GP and this doesn't look like a message I have seen in GP.)

Was this reply helpful? Yes No
Suggested answer

Anton Venter 20,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CU21052024-0

I'm guessing that the tier 2 database schema is not 100% up to date after changing your custom tables and deploying to the tier 2 environment, I would use SQL Server Management Studio to connect to the tier 2 database and I would drop those tables mentioned in your error message from the database. You could backup the data in those tables first if you don't want to lose the data and copy it back later.

Was this reply helpful? Yes No
Suggested answer

Sagar121 1,151 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

First steps would be do JIT of this UAT DB and check the elements whether they truly exist or not.

Was this reply helpful? Yes No
Suggested answer

vishalsahijwani 213 on at

Like (0)

Report
Copy link

Link copied!

Hi CU21052024-0 ,

Try the below mentioned steps : -

Step 1: Identify the objects

Run the below mentioned query in the JIT Access enabled database:

SELECT name, type_desc FROM sys.objects WHERE name LIKE '%SHARINGVIEW%'

This will confirm if the view is extracting the data correctly

Step 2: Check for any missing relations or joins in the data sources

Step 3: Run Full Build and DB sync

Step 4: Retry export and check if its getting succeeded properly.

If its still not working the you should raise a Microsoft support ticket. MS team will be able to suggest an efficient way to fix this view.

Please see if this help !!!!

Was this reply helpful? Yes No