Supply chain | Supply Chain Management, Commerce

database exports issues through the LCS tools

(0) Share

Report

Posted on by Community Member

Hello All,

one of my project i am trying export azure db on my client sand box environment . i ma having issues with mu custom model objects having some invliad reference errors while export db usind lcs.

error

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

[2020-05-20 11:42:11Z] Error SQL71501: Error validating element [DBO].[INVENTORYSITEONHANDENTITY]: SqlView: [DBO].[INVENTORYSITEONHANDENTITY] 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].[INVENTSITEONHANDAGGREGATEDVIEW].[I95DEVMODIFIEDDATETIME] or [DBO].[INVENTSITEONHANDAGGREGATEDVIEW].[T1].

I have tried updated the view with proper two part name by removing alias name T1. but when rebuild my model and synchronize the db it is again retaining back to alias T1.

Can anyone let me know the process or steps to resolve the same.

Regards,

Praveen

I have the same question (0)

All responses (11)

Answers (0)

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Praveen,

Is I95DEVMODIFIEDDATETIME field you added to the view INVENTSITEONHANDAGGREGATEDVIEW?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes. this is the custom field i have added. extended this view in my model

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Praveen,

And you added the field only to the view or to the entity as well?

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

try removing the custom object and after clean build and DB sync , initiate database export and suggest

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yeah, we do have these fields available on entity level.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Rahul.

Yes , Thanks for the heads up.

however , is there anyway i can resolve and export along with custom object.

Was this reply helpful? Yes No
WillWU 22,363 on at

Like (0)

Report

Hi praveen,

Could you see your custom field in the view INVENTSITEONHANDAGGREGATEDVIEW?

Was this reply helpful? Yes No
Suggested answer

Tad Okada on at

Like (0)

Report

Hi Praveen,

I think I need to add field to entity as well as view. Did you add field to the entity?

Hope it helps, Tad

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Will,

No, we don't have custom fields available on standard view. we have created extension to this standard view where these custom fields available

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Tad,

Yes, We do made these fields available on entity extension using from its data source of our extension of INVENTSITEONHANDAGGREGATEDVIEW

Was this reply helpful? Yes No